Changeset 808 for trunk/Application/UpdateTrace.php

Timestamp:

Mar 6, 2016, 5:06:42 PM (9 years ago)

Author:

chronos

Message:

• Added: Table FinanceTreasuryCheck for tracking treasury check records.

File:

• trunk/Application/UpdateTrace.php (modified) (2 diffs)

trunk/Application/UpdateTrace.php

@@ -1908 +1908 @@
 {
   $Manager->Execute('ALTER TABLE `Product` ADD `StockMinCount` INT NOT NULL AFTER `UnitOfMeasure`;');
+}
+
+function UpdateTo808($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `FinanceTreasuryCheck` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Treasury` int(11) NOT NULL,
+    `Time` datetime NOT NULL,
+    `Value1` int(11) NOT NULL,
+    `Value2` int(11) NOT NULL,
+    `Value5` int(11) NOT NULL,
+    `Value10` int(11) NOT NULL,
+    `Value20` int(11) NOT NULL,
+    `Value50` int(11) NOT NULL,
+    `Value100` int(11) NOT NULL,
+    `Value200` int(11) NOT NULL,
+    `Value500` int(11) NOT NULL,
+    `Value1000` int(11) NOT NULL,
+    `Value2000` int(11) NOT NULL,
+    `Value5000` int(11) NOT NULL,
+    PRIMARY KEY (`Id`),
+    KEY `Treasury` (`Treasury`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `FinanceTreasuryCheck`
+    ADD CONSTRAINT `FinanceTreasuryCheck_ibfk_1` FOREIGN KEY (`Treasury`) REFERENCES `FinanceTreasury` (`Id`);');
+
+  // IS menu item
+  $Manager->Execute('INSERT INTO `Action` (`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,
+`Group` ,`Icon` ,`PermissionOperation` ,`Enable`) VALUES (
+NULL , "", "Kontrola pokladen", "1", "/is/?t=FinanceTreasuryCheck&a=list", NULL , NULL , NULL , "1");');
+  $ActionId = $Manager->Database->insert_id;
+  $DbResult = $Manager->Execute('SELECT `Id` FROM `MenuItem` WHERE `Name`="Pokladny"');
+  if($DbResult->num_rows > 0)
+  {
+    $DbRow = $DbResult->fetch_assoc();
+    $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+        "VALUES (NULL , 'Kontrola pokladen', ".$DbRow['Id'].", '".$ActionId."', '1');");
+  }
+
 }
 
@@ -1997 +2036 @@
       802 => array('Revision' => 803, 'Function' => 'UpdateTo803'),
       803 => array('Revision' => 807, 'Function' => 'UpdateTo807'),
+      807 => array('Revision' => 808, 'Function' => 'UpdateTo808'),
     ));
   }