Subversion Repositories computer_asset_manager_v1

Rev

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

Rev 46 Rev 48
Line 9... Line 9...
9 
   include_once('reports.php');
 9 
   include_once('reports.php');
10
10
11 
   global $MODULE_REPORTS;
 11 
   global $MODULE_REPORTS;
12 
   $MODULE_REPORTS = array('main device screen' => 1);
 12 
   $MODULE_REPORTS = array('main device screen' => 1);
13
13
- 
 
 14 
   define (SQL_GET_MODULES,
- 
 
 15 
     "select a.key_name 'module',
- 
 
 16 
             a.theValue 'script',
- 
 
 17 
             b.theValue 'path'
- 
 
 18 
      from _system a join _system b using ( key_name )
- 
 
 19 
      where
- 
 
 20 
         a.group_name = '<screen>'
- 
 
 21 
         and b.group_name = 'Modules'
- 
 
 22 
         and a.removed_date is null
- 
 
 23 
         and b.removed_date is null"
- 
 
 24 
   );
- 
 
 25
14 
   define (SQL_SHOW_SITES,
 26 
   define (SQL_SHOW_SITES,
15 
      "select concat('<a href=\"index.html?site_id=',site.site_id,'\">', site.name,'</a>') 'Site',
 27 
      "select concat('<a href=\"index.html?site_id=',site.site_id,'\">', site.name,'</a>') 'Site',
16 
              count(*) 'Devices',
 28 
              count(*) 'Devices',
17 
              concat('<a href=\"edit.html?site_id=',site.site_id,'\">Edit</a>') Action
 29 
              concat('<a href=\"edit.html?site_id=',site.site_id,'\">Edit</a>') Action
18 
       from client_site site left outer join current_systems device using (site_id)
 30 
       from client_site site left outer join current_systems device using (site_id)
Line 48... Line 60...
48 
   define (SQL_SHOW_DEVICE, '
 60 
   define (SQL_SHOW_DEVICE, '
49 
      select device.device_id "ID",
 61 
      select device.device_id "ID",
50 
             concat(client.name, \' - \', site.name) "Site",
 62 
             concat(client.name, \' - \', site.name) "Site",
51 
             device_type.name "Type",
 63 
             device_type.name "Type",
52 
             device.name "Name",
 64 
             device.name "Name",
- 
 
 65 
             device.serial "Serial",
53 
             device.notes "Notes",
 66 
             device.notes "Notes",
54 
             device.restrictions "Restrictions",
 67 
             device.restrictions "Restrictions",
55 
             partof.name "Part Of",
 68 
             partof.name "Part Of",
56 
             date(device.added_date) "Added",
 69 
             date(device.added_date) "Added",
57 
             date(device.removed_date) "Removed"
 70 
             date(device.removed_date) "Removed"