Subversion Repositories computer_asset_manager_v1

Rev

Rev 38 | Rev 87 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 38 Rev 85
Line 91... Line 91...
91 
                  <td valign='top'>
 91 
                  <td valign='top'>
92 
                     <?php print $thisRow['Date Due'] . ' (' . $thisRow['Due'] . ' days)'; ?>
 92 
                     <?php print $thisRow['Date Due'] . ' (' . $thisRow['Due'] . ' days)'; ?>
93 
                  </td>
 93 
                  </td>
94 
                  <td valign='top'>
 94 
                  <td valign='top'>
95 
                     <select name="technician_<?php print $thisRow['ID']; ?>">
 95 
                     <select name="technician_<?php print $thisRow['ID']; ?>">
96 
                     <?php print queryToSelect('select login_id,email from login order by email', "select " . $_SESSION['login_id'] ); ?>
 96 
                     <?php print queryToSelect(getTechs(), "select " . $_SESSION['login_id'] ); ?>
97 
                     </select>
 97 
                     </select>
98 
                  </td>
 98 
                  </td>
99 
               </tr>
 99 
               </tr>
100 
         <?php
 100 
         <?php
101 
            }
 101 
            }
Line 125... Line 125...
125 
             Client
 125 
             Client
126 
          </td>
 126 
          </td>
127 
          <td>
 127 
          <td>
128 
             <select name='select_client' >
 128 
             <select name='select_client' >
129 
                <option value='0'>All</option>
 129 
                <option value='0'>All</option>
130 
                <?php print queryToSelect('
 - 
 
131 
                     select distinct client.client_id,client.name
- 
 
132 
                     from client join site on site.client_id = site.client_id
- 
 
133 
                        join device on device.site_id = site.site_id
- 
 
134 
                        join maintenance_schedule on device.device_id = maintenance_schedule.device_id
 - 
 
135 
                     where maintenance_schedule.removed_date is null
- 
 
136 
                           and device.removed_date is null
- 
 
137 
                           and site.removed_date is null
- 
 
138 
                           and client.removed_date is null
 - 
 
139 
                ', $_SESSION['do_maintenance_select_client'] ); ?>
 130 
                <?php print queryToSelect( getClients(), $_SESSION['do_maintenance_select_client'] ); ?>
140 
             </select>
 131 
             </select>
141 
          </td>
 132 
          </td>
142 
       </tr>
 133 
       </tr>
143 
       <tr>
 134 
       <tr>
144 
          <td>
 135 
          <td>
Line 146... Line 137...
146 
          </td>
 137 
          </td>
147 
          <td>
 138 
          <td>
148 
             <select name='select_tech'>
 139 
             <select name='select_tech'>
149 
                <option value='0'>All</option>
 140 
                <option value='0'>All</option>
150 
                   <?php
141 
                   <?php
151 
                      print queryToSelect('select login_id,email from login order by email', $_SESSION['do_maintenance_select_tech'] );
142 
                      print queryToSelect(getTechs(), $_SESSION['do_maintenance_select_tech'] );
152 
                   ?>
 143 
                   ?>
153 
             </select>
 144 
             </select>
154 
          </td>
 145 
          </td>
155 
       </tr>
 146 
       </tr>
156 
       <tr>
 147 
       <tr>