Subversion Repositories computer_asset_manager_v1

<?php

   define(VERSION,'1.0.0');
   define(BUILD_DATE,'20170709');

   include_once("database.php");
   
   include_once("library.php");
   include_once('reports.php');
   
   define (SQL_SHOW_LICENSE,
      "select 
                  client.name 'Client',
                  concat('<a href=\"index.html?action=edit&license_id=',license.license_id,'\">', license.license,'</a>') 'License',
                  device.name 'Installed On',
                  license_product.name 'Product',
                  license.added_date 'Installed',
                  concat('<a href=\"index.html?action=move&license_id=',license.license_id,'\">', 'Move','</a>') 'Action'
       from
                  license join license_product using (license_product_id)
                  left outer join device using (device_id)
                  join client using ( client_id )
       where <whereClause>
       order by 
          client.name,
          device.name,
          license_product.name,
          license.license"
      );

   define (SQL_SHOW_LICENSE_HISTORY,
      "select 
                  client.name 'Client',
                  concat('<a href=\"index.html?license_id=',license.license_id,'\">', license.license,'</a>') 'License',
                  device.name 'Installed On',
                  license_product.name 'Product',
                  license.added_date 'Installed',
                  license.removed_date 'Removed'
       from
                  license join license_product using (license_product_id)
                  left outer join device using (device_id)
                  join client using ( client_id )
       where <whereClause>
       order by 
          client.name,
          device.name,
          license_product.name,
          license.license"
        );
        
/*
 * Adds/updates license in license table
 * if already licensed for this machine, returns 'Already Set'
 * if license exists and is for a different machine
 *    mark it as removed
 *    adds key to new machine
 *    returns "Assigned"
 * Othewise, Adds key and assigns to machine
 * returns "Added"
 * NOTE: $device_id may be null which indicates license owned by client but unassigned
 */
function updateLicense ( $client_id, $device_id, $license_product_id, $license ) {
   // see if the entry already exists
   $results = queryDatabaseExtended( "select license_id,client_id,device_id from license where license_product_id = $license_product_id and license = '$license' and removed_date is null" );
   //print "<pre>"; print_r( $results ); print "</pre>"; die;
   $db_license_id = $results['data'][0]['license_id'];
   $db_client_id = $results['data'][0]['client_id'];
   $db_device_id = $results['data'][0]['device_id'];
   // SQL does not understand an empty string, so we replace it with the keyword null for queries
   $queryDeviceID = $device_id ? $device_id : 'null';
   if ( ! $results ) { # this was not found, so just add it
      doSQL( "insert into license (client_id,device_id,license_product_id,license, added_date) values ( $client_id, $queryDeviceID, $license_product_id, '$license', now() )" );
      return "Added";
   }
   if ( $client_id == $db_client_id && $device_id == $db_device_id or $db_device_id  ) { // already done, so just leave alone
      return "Already Set";
   }
   if ( ! $db_device_id ) { # key was not assigned before, so just assign it
      doSQL( "update license set device_id = $queryDeviceID,added_date = now() where license_id = $db_license_id" );
      return "Assigned";
   }
   // at this point, there is already an entry, but it is for a different machine, so we need to update it, ie remove the old, add the new
   doSQL( "update license set removed_date = now() where license_id = $db_license_id" );
   doSQL( "insert into license (client_id,device_id,license_product_id,license, added_date) values ( $client_id, $queryDeviceID, $license_product_id, '$license', now() )" );
   return "Reassigned";
}

/* 
 * select $column from $table where $match = '$value'
 * if $add is true, will add row if it does not exist.
 * returns $column from the result (or '' if it does not exist)
 * Used mainly to get an index from a table with matching value
 */

function getValue ( $table, $column, $match, $value, $add = false ) {
   $return = getOneDBValue( "select $column from $table where $match = '$value'" );
   if ( $return === null ) {
      if ( $add ) {
         $return = doSQL( "insert into $table ( $match ) values ( '$value' )" );
         return $return['insert_id'];
      } else {
         $return = '';
      } // if..else
   } // if
   return $return;
} // function getValue

function getDescription( $license_id ) {
   $result = queryDatabaseExtended( 
           "select 
               license_product.name 'Product',
               license.license 'License',
               device.name 'Machine',
               client.name 'Client'
            from
               license join license_product using (license_product_id)
               left outer join device using (device_id)
               join client using ( client_id )
            where 
               license.removed_date is null
               and license.license_id = $license_id"
            );
   if ( $result['count'] ) {
      $return = 'Product: ' . $result['data'][0]['Product'] . "\n";
      $return .= 'Client:  ' . $result['data'][0]['Client'] . "\n";
      $return .= 'Machine:  ' . ( $result['data'][0]['Machine'] ? $result['data'][0]['Machine'] : 'Not Currently Assigned' ) . "\n";
      $return .= 'License:  ' . $result['data'][0]['License'] . "\n";
      return $return;
   } else {
      return "No License found for license_id $license_id";
   }
} // function getDescription

?>