source: trunk/temp/product.php@ 548

<?php
die();

include('../Common/Global.php');
GlobalInit();

/* @var $System System */
$System->Database->query('DELETE FROM StockItem');
$System->Database->query('DELETE FROM Product');

$DbResult = $System->Database->select('ProductOld', '*');
while($DbRow = $DbResult->fetch_assoc())
{
  echo($DbRow['Name'].', ');
  
  $System->Database->insert('Product', array('Name' => $DbRow['Name'], 
    'SellPrice' => $DbRow['Price'], 'BuyPrice' => $DbRow['Price'],
    'Consumption' => $DbRow['Consumption'], 'UnitOfMeasure' => 1, 'VAT' => 20));
  $ProductId = $System->Database->insert_id;
  //print_r($DbRow);
  switch($DbRow['Used'])
  {
    case 0: $Elimination = '0000-00-00'; break;
    case 1: $Elimination = NULL; break;
    case 2: $Elimination = NULL; break;
  }
        
  //  else $Elimination = $DbRow['TimeElimination'];
  if($DbRow['Used'] == 2) $DbRow['User'] = NULL;
  echo($DbRow['Used'].'"'.$Elimination.'"<br/>');
//  print_r(array('Stock' => 1, 'Product' => $ProductId, 'Amount' => $DbRow['Count'],
//    'Segment' => $DbRow['Segment'], 'TimeEnlistment' => $DbRow['Date'], 'TimeElimination' => $Elimination, 
//    'SerialNumber' => $DbRow['DeviceId'], 'BuyPrice' => $DbRow['Price'], 'SellPrice' => $DbRow['Price'],
//    'Location' => $DbRow['User'], 'Info' => $DbRow['Info']));
  $Database->insert('StockItem', array('Stock' => 1, 'Product' => $ProductId, 'Amount' => $DbRow['Count'],
    'Segment' => $DbRow['Segment'], 'TimeEnlistment' => $DbRow['Date'], 'TimeElimination' => $Elimination, 
    'SerialNumber' => $DbRow['DeviceId'], 'BuyPrice' => $DbRow['Price'], 'SellPrice' => $DbRow['Price'],
    'Location' => $DbRow['User'], 'Info' => $DbRow['Info']));
}