Subversion Repositories computer_asset_manager_v1

Rev

Rev 48 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 48 Rev 50
Line 10... Line 10...
10 
   * device_id - A device_id to be used for queries
 10 
   * device_id - A device_id to be used for queries
11 
   * site_id   - A site_id to be used for queries
 11 
   * site_id   - A site_id to be used for queries
12 
   * htmlDirectory - the HTML path to the module
 12 
   * htmlDirectory - the HTML path to the module
13 
   */
 13 
   */
14
14
15 
   function view ( $parameters ) {
 15 
   function licenseView ( $parameters ) {
16 
      // this is an array containing the columns we will display in the
 16 
      // this is an array containing the columns we will display in the
17 
      // query. The query will be generated as
 17 
      // query. The query will be generated as
18 
      // select $key '$value', $key '$value
 18 
      // select $key '$value', $key '$value
19 
      $reportColumns = array(
19 
      $reportColumns = array(
20 
            'license_id' => 'ID',
 20 
            'license_id' => 'ID',
Line 41... Line 41...
41 
                  license join license_product using (license_product_id)
 41 
                  license join license_product using (license_product_id)
42 
                  left outer join device using (device_id)
 42 
                  left outer join device using (device_id)
43 
                  join client using ( client_id )';
 43 
                  join client using ( client_id )';
44 
      $query .= ' where ' . implode ( ' and ', $whereClause );
 44 
      $query .= ' where ' . implode ( ' and ', $whereClause );
45 
      return queryToTable( $query );
 45 
      return queryToTable( $query );
46 
      //return "Parameters are<br /><pre>" . print_r( $parameters, true ) . "</pre><br />\n<pre>$query</pre>\n";
 - 
 
47 
   }
 46 
   }
48 
 
 47 
 
49 
?>
 48 
?>
50 
 
 49