Subversion Repositories computer_asset_manager_v1

Rev

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

Rev 37 Rev 38
Line 106... Line 106...
106 
   );
 106 
   );
107 
//            DATE(DATE_ADD(maintenance_performed.maintenance_date, INTERVAL schedule DAY)) "Due Date",
 107 
//            DATE(DATE_ADD(maintenance_performed.maintenance_date, INTERVAL schedule DAY)) "Due Date",
108
108
109 
   define (SQL_GET_OUTSTANDING_MAINTENANCE, '
 109 
   define (SQL_GET_OUTSTANDING_MAINTENANCE, '
110 
     select concat( client.name, \' Site \', site.name ) "Site",
 110 
     select concat( client.name, \' Site \', site.name ) "Site",
- 
 
 111 
            device.device_id "Device ID",
111 
            device.name "Device Name",
 112 
            device.name "Device Name",
112 
            device.notes "Device Notes",
 113 
            device.notes "Device Notes",
113 
            device.restrictions "Restrictions",
 114 
            device.restrictions "Restrictions",
114 
            maintenance_task.description "Task",
 115 
            maintenance_task.description "Task",
115 
            maintenance_task.notes "Task Notes",
 116 
            maintenance_task.notes "Task Notes",