Subversion Repositories computer_asset_manager_v1

<?php

include_once( '../../header.php' ); 

include_once( 'csvImporter.php' );

$filename = 'machine_licenses.csv';

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;

}

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'];

   $db_license_product_id = $results['data'][0]['license_product_id'];

   if ( ! $results ) { # this was not found, so just add it

      if ( $device_id === '' ) $device_id = 'null';

      doSQL( "insert into license (client_id,device_id,license_product_id,license, added_date) values ( $client_id, $device_id, $license_product_id, '$license', now() )" );

      return "Added";

   }

   if ( $client_id == $db_client_id && $device_id == $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 = $db_device_id,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, $device_id, $license_product_id, '$license', now() )" );

   return "Reassigned";

}

$fileInfo = new CsvImporter( $filename, true );

while ( $line = $fileInfo->get(1) ) {

   foreach ( $line as $index => $values ) {

      $import[$values['client']][$values['device']][$values['license_product']] = $values['license'];

   }

};

//print '<pre>'; print_r( $import ); print '</pre>';

print "<table border='1'><tr></tr><th>Client</th><th>ID</th><th>Machine</th><th>ID</th><th>Product</th><th>ID</th><th>License</th></tr>\n";

foreach ( $import as $client => $data ) {

   $client_id = getValue ( 'client', 'client_id', 'name', $client );

   if ( $client_id === '' ) {

      print "<tr><td><b>Error</b></td><td colspan='7'>Could not find client ID for $client</td></tr>";

      continue;

   }

   foreach ( $data as $machine => $info ) {

      if ( $machine === '' ) {

         $machine_id = '';

      } else {

         $machine_id = getValue( 'device', 'device_id', 'name', $machine );

         if ( $machine_id === '' ) {

            print "<td><b>Error</b></td><td>$client</td><td>$client_id</td>";

            print "<td colspan='5'>Could not find machine ID for $machine</td></tr>";

            continue;

         }

      }

      foreach ( $info as $product => $license ) {

         $product_id = getValue( 'license_product', 'license_product_id', 'name', $product, true );

         $action = updateLicense( $client_id, $machine_id, $product_id, $license );

         print "<tr>\n";

         print "<td>$action</td><td>$client</td><td>$client_id</td>";

         print "<td>$machine</td><td>$machine_id</td>";

         print "<td>$product</td><td>$product_id</td><td>$license</td>\n";

         print "</tr>\n";

      }

   } // for each machine

} // for each client

print "</table>\n";

?>