X-Git-Url: https://git.harvie.cz/?a=blobdiff_plain;f=assistants%2Fmigrations.inc.php;h=c00b8e36ef99c588fee0dc9fe2d6de7bb8c60173;hb=67360e5092c34ffeae0fa67624c8dafc743b381e;hp=95d3b86dac4c83fa2364110260891cebdcae75d9;hpb=79cc0871640b08bbe5c5e7b132e7bcc934d20823;p=mirrors%2FSokoMan.git

diff --git a/assistants/migrations.inc.php b/assistants/migrations.inc.php
index 95d3b86..c00b8e3 100644
--- a/assistants/migrations.inc.php
+++ b/assistants/migrations.inc.php
@@ -1,6 +1,16 @@
-<pre><h1>populate column item_date_bought</h1><?php
-$data = $this->db->safe_query_fetch('SELECT item_id,MIN(item_valid_from) AS item_valid_from FROM item GROUP BY item_id;');
+<pre>
+<h1>-- populate barcode table</h1><?php
+$data = $this->db->safe_query_fetch('SELECT model_id as id, model_barcode as bar FROM model;');
+//print_r($data);
+echo("UPDATE item SET barcode_id=model_id;\n");
+echo("INSERT INTO barcode (barcode_id,model_id,barcode_name) VALUES\n");
+foreach($data as $line) echo("('".$line['id']."','".$line['id']."','".$line['bar']."'),\n");
+?>
+<h1>-- populate columns item_date_bought and item_date_sold</h1><?php
+$data = $this->db->safe_query_fetch('SELECT item_id,MIN(item_valid_from) AS min,MAX(item_valid_from) AS max FROM item GROUP BY item_id;');
 //print_r($data);
 echo("START TRANSACTION;\n");
-foreach($data as $line) echo("UPDATE item SET item_date_bought='".$line['item_valid_from']."' WHERE item_id=".$line['item_id'].";\n");
+foreach($data as $line) echo("UPDATE item SET item_date_bought='".$line['min']."',item_date_sold='".$line['max']."' WHERE item_id=".$line['item_id'].";\n");
 echo("COMMIT;\n");
+?>
+</pre>