WebSVN – computer_asset_manager_v1 – Diff – /modules/license/index.html

       <link rel="stylesheet" type="text/css" href="../../camp.css">
    </head>
    <body>
       <?php include_once('../../menu.php'); ?>
       <div id="content">
+         <?php print queryToTable(
+               "select
+                  license_product.name 'Product',
+                  license.license 'License',
+                  ifnull(device.name,'--- Available ---') 'Installed On',
+                  client.name 'Client'
+               from
+                  license join license_product using (license_product_id)
+                  left outer join device using (device_id)
+                  join client using ( client_id )
+               order by license_product.name, device.name
+               "
+               );
+         ?>
       </div>
    </body>
 </html>

Subversion Repositories computer_asset_manager_v1