| 41 |
rodolico |
1 |
<?php
|
|
|
2 |
|
|
|
3 |
/* define(SQL_GET_PACKAGES,
|
|
|
4 |
'select client.name,device.name,software.package_name,software_version.version
|
|
|
5 |
from client join site on client.client_id = site.client_id
|
|
|
6 |
join device on device.site_id = site.site_id
|
|
|
7 |
join installed_packages on device.device_id = installed_packages.device_id
|
|
|
8 |
join software on installed_packages.software_id = software.software_id
|
|
|
9 |
join software_version on installed_packages.software_version_id = software_version.software_version_id
|
|
|
10 |
where <whereClause>
|
|
|
11 |
order by package_name,version
|
|
|
12 |
'
|
|
|
13 |
);
|
|
|
14 |
*/
|
|
|
15 |
|
|
|
16 |
?>
|