Subversion Repositories computer_asset_manager_v1

<?php

  /*

   * This is the callable library for the license module.

   * routines are assumed to be called from other modules, returning 

   * HTML data.

   * All routines will receive one array containing the parameters to

   * be used. Parameters may be

   * client_id - A client_id to be used for queries

   * device_id - A device_id to be used for queries

   * site_id   - A site_id to be used for queries

   * htmlDirectory - the HTML path to the module

   */

   function licenseView ( $parameters ) {

      // this is an array containing the columns we will display in the

      // query. The query will be generated as

      // select $key '$value', $key '$value

      $reportColumns = array( 

            'license_id' => 'ID',

            'license_product.name' => 'Product',

            'license.license' => 'License',

            'license.added_date' => 'Installed',

            'device_id' => 'Machine',

            );

      // first, let's remove any fields from $report_columns which are 

      // listed in the $parameters, and add them to the where clause

      $whereClause = array( 'license.removed_date is null' );

      foreach ( $parameters as $key => $value ) {

         if ( isset( $reportColumns[ $key ] ) ) {

            unset( $reportColumns[ $key ] );

            $whereClause[] = "$key = $value";

         }

      }

      $columnList = array();

      foreach ( $reportColumns as $key => $value ) {

         $columnList[] = "$key '$value'";

      }

      $query = 'select ' . implode( ',', $columnList );

      $query .= 'from

                  license join license_product using (license_product_id)

                  left outer join device using (device_id)

                  join client using ( client_id )';

      $query .= ' where ' . implode ( ' and ', $whereClause );

      return queryToTable( $query );

   }

?>