Subversion Repositories computer_asset_manager_v1

/* 

 * 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 = '';

      }

   }

   return $return;

}

/*

 * 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";

}