Changeset 452 for trunk/temp/product.php

Timestamp:

Oct 28, 2012, 10:20:32 AM (12 years ago)

Author:

chronos

Message:

• Opraveno: Zobrazování odkazů v aktualitách.
• Upraveno: Tabulka Product rozdělena na Product a StockItem. Upravena struktura.

File:

• trunk/temp/product.php (modified) (1 diff)

trunk/temp/product.php

@@ -12 +12 @@
   echo($DbRow['Name'].', ');
   
-  $System->Database->insert('Product', array('Name' => $DbRow['Name'], 'SellPrice' => $DbRow['Price'],
-    'BuyPrice' => $DbRow['Price'],
+  $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;
+  if($DbRow['Used'] == 1) $Elimination = 'NULL';
+    else $Elimination = $DbRow['TimeElimination'];
   $Database->insert('StockItem', array('Stock' => 1, 'Product' => $ProductId, 'Amount' => $DbRow['Count'],
-    'Segment' => $DbRow['Segment'], 'TimeEnlistment' => $DbRow['Date'], 'SerialNumber' => $DbRow['DeviceId'],
+    'Segment' => $DbRow['Segment'], 'TimeEnlistment' => $DbRow['Date'], 'TimeElimination' => $Elimination, 
+    'SerialNumber' => $DbRow['DeviceId'], 'BuyPrice' => $DbRow['Price'], 'SellPrice' => $DbRow['Price'],
     'Location' => $DbRow['User'], 'Info' => $DbRow['Info']));
 }