Subversion Repositories computer_asset_manager_v1

Rev

Rev 1 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1 Rev 85
Line 26... Line 26...
26
         </tr>
26
         </tr>
27
         <tr>
27
         <tr>
28
            <td>Device</td>
28
            <td>Device</td>
29
            <td>
29
            <td>
30
               <select name="device">
30
               <select name="device">
31
                  <?php print queryToSelect("select device.device_id,concat(device.name, ', ', client.name,' - ', site.name) 
-
 
32
                                             from device join site using (site_id) 
-
 
33
                                                  join client using (client_id) 
-
 
34
                                                  join device_type using (device_type_id)
-
 
35
                                             where device_type.show_as_system = 'Y'
-
 
36
                                                   and device.removed_date is null
-
 
37
                                             order by client.name,site.name,device.name", $_POST['device'] ); ?>
31
                  <?php print queryToSelect(getAllDevices(), $_POST['device'] ); ?>
38
               </select>
32
               </select>
39
            </td>
33
            </td>
40
         </tr>
34
         </tr>
41
         <tr>
35
         <tr>
42
            <td>
36
            <td>
Line 60... Line 54...
60
            <td>
54
            <td>
61
               Performed By
55
               Performed By
62
            </td>
56
            </td>
63
            <td valign='top'>
57
            <td valign='top'>
64
               <select name="technician">
58
               <select name="technician">
65
                  <?php print queryToSelect('select login_id,email from login order by email', "select " . $_SESSION['login_id'] ); ?>
59
                  <?php print queryToSelect(getTechs(), "select " . $_SESSION['login_id'] ); ?>
66
               </select>
60
               </select>
67
            </td>
61
            </td>
68
         </tr>
62
         </tr>
69
         <tr>
63
         <tr>
70
            <td>
64
            <td>