fhiiqm/laser_flist.php
changeset 23 a382de56a8e4
parent 22 aae5b0ecc47b
child 24 15f33315f045
equal deleted inserted replaced
22:aae5b0ecc47b 23:a382de56a8e4
   103             können Sie nach relevanten Spalten auf- bzw. absteigend sortieren</td></tr>
   103             können Sie nach relevanten Spalten auf- bzw. absteigend sortieren</td></tr>
   104             <tr><td class='bigger'>'<img src='/fhiiqm/img/filter.gif' border='0' width='14' hight='11' />' erm&ouml;glicht das Filtern nach ausgew&auml;hlten Spalten der Liste</td></tr>
   104             <tr><td class='bigger'>'<img src='/fhiiqm/img/filter.gif' border='0' width='14' hight='11' />' erm&ouml;glicht das Filtern nach ausgew&auml;hlten Spalten der Liste</td></tr>
   105             <tr><td class='bigger'>Klick auf '<img src='/fhiiqm/img/edit.gif' border='0' width='11' hight='11'>' - Bearbeiten "; 
   105             <tr><td class='bigger'>Klick auf '<img src='/fhiiqm/img/edit.gif' border='0' width='11' hight='11'>' - Bearbeiten "; 
   106         if (!is_null($_SESSION["recht"]) && in_array("le",$_SESSION["recht"]))
   106         if (!is_null($_SESSION["recht"]) && in_array("le",$_SESSION["recht"]))
   107             echo ", '<img src='/fhiiqm/img/duplicate.gif' border='0' hight='11'>' - Duplizieren";
   107             echo ", '<img src='/fhiiqm/img/duplicate.gif' border='0' hight='11'>' - Duplizieren";
       
   108         echo ", '<img src='/fhiiqm/img/script_edit.png' border='0' hight='11'>' - Log-Buch";
   108         echo "    des Lasers</td></tr>\n";
   109         echo "    des Lasers</td></tr>\n";
   109         echo "</table>\n";
   110         echo "</table>\n";
   110 
   111 
   111         $anz = $dbc -> querySingleItem("SELECT @anz");
   112         $anz = $dbc -> querySingleItem("SELECT @anz");
   112         $anzpl = $dbc -> querySingleItem("SELECT @anzpl");
   113         $anzpl = $dbc -> querySingleItem("SELECT @anzpl");
   134         if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td><tr>\n";
   135         if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td><tr>\n";
   135 
   136 
   136         // Listenkopf generieren
   137         // Listenkopf generieren
   137         echo "<tr bgcolor='#68ACBF'>";
   138         echo "<tr bgcolor='#68ACBF'>";
   138         tab_column(2,"ID",$sort,$dir,2,$fnum,$filter,$start,$zeil);
   139         tab_column(2,"ID",$sort,$dir,2,$fnum,$filter,$start,$zeil);
   139         tab_column(13,"ref-ID",$sort,$dir,13,$fnum,$filter,$start,$zeil);
   140         tab_column(13,"zu ID",$sort,$dir,13,$fnum,$filter,$start,$zeil);
   140         tab_column(3,"Bezeichnung",$sort,$dir,3,$fnum,$filter,$start,$zeil);
   141         tab_column(3,"Bezeichnung",$sort,$dir,3,$fnum,$filter,$start,$zeil);
   141         echo "<th>Welle</th>";
   142         echo "<th>Welle</th>";
   142         tab_column(4,"Art",$sort,$dir,4,$fnum,$filter,$start,$zeil);
   143         tab_column(4,"Art",$sort,$dir,4,$fnum,$filter,$start,$zeil);
   143         tab_column(6,"Typ",$sort,$dir,6,$fnum,$filter,$start,$zeil);
   144         tab_column(6,"Typ",$sort,$dir,6,$fnum,$filter,$start,$zeil);
   144         tab_column(5,"Klasse",$sort,$dir,5,$fnum,$filter,$start,$zeil);
   145         tab_column(5,"Klasse",$sort,$dir,5,$fnum,$filter,$start,$zeil);
   149         tab_column(11,"Raum",$sort,$dir,11,$fnum,$filter,$start,$zeil);
   150         tab_column(11,"Raum",$sort,$dir,11,$fnum,$filter,$start,$zeil);
   150         tab_column(12,"Verantw.",$sort,$dir,12,$fnum,$filter,$start,$zeil);
   151         tab_column(12,"Verantw.",$sort,$dir,12,$fnum,$filter,$start,$zeil);
   151 
   152 
   152         echo "<th>&nbsp;</th>";
   153         echo "<th>&nbsp;</th>";
   153         if (!is_null($_SESSION["recht"]) && in_array("le",$_SESSION["recht"]))
   154         if (!is_null($_SESSION["recht"]) && in_array("le",$_SESSION["recht"]))
   154             echo "<th>&nbsp;</th></tr>\n";
   155             echo "<th>&nbsp;</th>";
   155         
   156         echo "<th>&nbsp;</th></tr>\n";
       
   157        
   156         foreach ($result as $row)
   158         foreach ($result as $row)
   157         {
   159         {
   158 			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
   160 			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
   159             echo "<tr bgcolor='" . $bg . "'><td>$row->las_ID</td>";
   161             echo "<tr bgcolor='" . $bg . "'><td>$row->las_ID</td>";
   160             echo "<td>$row->las_ref_ID</td>";
   162             echo "<td>$row->las_ref_ID</td>";
   170             echo "<td>$row->raum_nr</td>";
   172             echo "<td>$row->raum_nr</td>";
   171             echo "<td>$row->vma</td>";
   173             echo "<td>$row->vma</td>";
   172             echo "<td><a href='/fhiiqm/laser_ed.php?i=$row->las_ID'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td>";
   174             echo "<td><a href='/fhiiqm/laser_ed.php?i=$row->las_ID'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td>";
   173             if (!is_null($_SESSION["recht"]) && in_array("le",$_SESSION["recht"]))
   175             if (!is_null($_SESSION["recht"]) && in_array("le",$_SESSION["recht"]))
   174                 echo "<td><a href='/fhiiqm/laser_ed.php?i=$row->las_ID&d=1&c=1'><img src=\"/fhiiqm/img/duplicate.gif\" alt='duplizieren' title='duplizieren' border='0'/></a></td>";
   176                 echo "<td><a href='/fhiiqm/laser_ed.php?i=$row->las_ID&d=1&c=1'><img src=\"/fhiiqm/img/duplicate.gif\" alt='duplizieren' title='duplizieren' border='0'/></a></td>";
       
   177             echo "<td><a href='/fhiiqm/laser_log_flist_ed.php?i=$row->las_ID'><img src=\"/fhiiqm/img/script_edit.png\" alt='log' title='log' border='0'/></a></td>";
   175         }
   178         }
   176         echo "</table></div>\n";
   179         echo "</table></div>\n";
   177 
   180 
   178         echo "<br />&nbsp;&nbsp;&nbsp;";
   181         echo "<br />&nbsp;&nbsp;&nbsp;";
   179         
   182         
   189             if ($key != "st" && $key != "subf" && $key != "filter") $liste .= "&" . $key ."=".$val;
   192             if ($key != "st" && $key != "subf" && $key != "filter") $liste .= "&" . $key ."=".$val;
   190             if ($key == "filter") $liste .= "&b=" . $val;
   193             if ($key == "filter") $liste .= "&b=" . $val;
   191         }    
   194         }    
   192         
   195         
   193         // Links auf andere Seiten generieren
   196         // Links auf andere Seiten generieren
   194         liste_links($start,$zeil,$panz,$liste);
   197         liste_links($start,$zeil,$anz,$liste);
   195 
   198 
   196     }
   199     }
   197     else
   200     else
   198     {
   201     {
   199         if ($dbc -> error)  
   202         if ($dbc -> error)