Subversion Repositories computer_asset_manager_v1

Rev

Rev 41 | Rev 47 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | Download | RSS feed 

<?php 
   include_once( '../../header.php' ); 
?>
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >
<html xmlns="http://www.w3.org/1999/xhtml">
   <head>
      <title>Computer Asset Management Program - MODULE NAME - PAGE NAME</title>
      <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>