Subversion Repositories computer_asset_manager_v1

Rev

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

Rev 1 Rev 37
Line 108... Line 108...
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.name "Device Name",
 111 
            device.name "Device Name",
112 
            device.notes "Device Notes",
 112 
            device.notes "Device Notes",
- 
 
 113 
            device.restrictions "Restrictions",
113 
            maintenance_task.description "Task",
 114 
            maintenance_task.description "Task",
114 
            maintenance_task.notes "Task Notes",
 115 
            maintenance_task.notes "Task Notes",
115 
            DATEDIFF(DATE_ADD(maintenance_performed.maintenance_date, INTERVAL schedule DAY), now()) "Due",
 116 
            DATEDIFF(DATE_ADD(maintenance_performed.maintenance_date, INTERVAL schedule DAY), now()) "Due",
116 
            DATE(DATE_ADD(maintenance_performed.maintenance_date, INTERVAL schedule DAY)) "Date Due",
 117 
            DATE(DATE_ADD(maintenance_performed.maintenance_date, INTERVAL schedule DAY)) "Date Due",
117 
            login.email "Technician",
 118 
            login.email "Technician",