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 49... Line 49...
49 
      select device.device_id "ID",
 49 
      select device.device_id "ID",
50 
             concat(client.name, \' - \', site.name) "Site",
 50 
             concat(client.name, \' - \', site.name) "Site",
51 
             device_type.name "Type",
 51 
             device_type.name "Type",
52 
             device.name "Name",
 52 
             device.name "Name",
53 
             device.notes "Notes",
 53 
             device.notes "Notes",
- 
 
 54 
             device.restrictions "Restrictions",
54 
             partof.name "Part Of",
 55 
             partof.name "Part Of",
55 
             date(device.added_date) "Added",
 56 
             date(device.added_date) "Added",
56 
             date(device.removed_date) "Removed"
 57 
             date(device.removed_date) "Removed"
57 
      from device join site on device.site_id = site.site_id
58 
      from device join site on device.site_id = site.site_id
58 
           join client on site.client_id = client.client_id
59 
           join client on site.client_id = client.client_id
Line 154... Line 155...
154 
            include_once( $_SESSION['file system root'] . "/$directory/database.php" );
 155 
            include_once( $_SESSION['file system root'] . "/$directory/database.php" );
155 
         }
 156 
         }
156 
      }
 157 
      }
157 
   }
 158 
   }
158 
 
 159 
 
159 
?>
 - 
 
160 
 
 160 
?>
- 
 
 161