Changeset 755 for trunk/Common/Setup/Updates.php

Timestamp:

Oct 25, 2015, 9:51:51 PM (9 years ago)

Author:

chronos

Message:

• Modified: Now IS Dashboard is not dependent on other modules. They need to register their view to IS dashboard.
• Fixed: Wrong sign of created finance operations from bank import.
• Added: Storno invoices now have special groups in FinanceInvoiceGroup table.

Both Storno and previous storned documents should be linked together using new table FinanceInvoiceStorno.
Also they should be marked as not visible to user.

File:

• trunk/Common/Setup/Updates.php (modified) (5 diffs)

trunk/Common/Setup/Updates.php

@@ -1523 +1523 @@
     'VALUES (NULL, "Kontrola změn stavů", "SchedulerNotifyCheck");');
 
-  $this->Database->query('
+  $Manager->Database->query('
   CREATE TABLE IF NOT EXISTS `NotifyUser` (
   `Id` int(11) NOT NULL AUTO_INCREMENT,
@@ -1533 +1533 @@
   KEY `Contact` (`Contact`)
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');
-  $this->Database->query('ALTER TABLE `NotifyUser`
+  $Manager->Database->query('ALTER TABLE `NotifyUser`
 ADD CONSTRAINT `NotifyUser_ibfk_1` FOREIGN KEY (`User`) REFERENCES `User` (`Id`),
 ADD CONSTRAINT `NotifyUser_ibfk_2` FOREIGN KEY (`Contact`) REFERENCES `Contact` (`Id`);');
 
-  $this->Database->query('CREATE TABLE IF NOT EXISTS `NotifyCategory` (
+  $Manager->Database->query('CREATE TABLE IF NOT EXISTS `NotifyCategory` (
       `Id` int(11) NOT NULL AUTO_INCREMENT,
       `Name` varchar(255) NOT NULL,
@@ -1544 +1544 @@
     ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
 
-  $this->Database->query("INSERT INTO `NotifyCategory` (`Id`, `Name`, `SysName`) VALUES
+  $Manager->Database->query("INSERT INTO `NotifyCategory` (`Id`, `Name`, `SysName`) VALUES
     (1, 'Dostupnost zařízení (ping)', 'NetworkReachability'),
     (2, 'Dostupnost URL', 'URL'),
@@ -1553 +1553 @@
 }
 
+function UpdateTo755($Manager)
+{
+  $Manager->Execute("INSERT INTO `FinanceInvoiceGroup` (`Id`, `Name`, `DocumentLine`, `ValueSign`, `Direction`) '.
+    'VALUES (NULL, 'Přijaté faktury - storno', '5', '1', '0'), (NULL, 'Vydané faktury - storno', '6', '-1', '1')");
+  $Manager->Execute("ALTER TABLE `FinanceInvoice` ADD `VisibleToUser` INT NOT NULL DEFAULT '1' AFTER `Generate`;ALTER TABLE `FinanceInvoice` ADD `VisibleToUser` INT NOT NULL DEFAULT '1' AFTER `Generate`;");
+
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `FinanceInvoiceStorno` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `StornoBy` int(11) NOT NULL,
+    `StornoOf` int(11) NOT NULL,
+    PRIMARY KEY (`Id`),
+    KEY `StornoBy` (`StornoBy`),
+    KEY `StornoOf` (`StornoOf`)
+  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
+
+  $Manager->Execute("ALTER TABLE `FinanceInvoiceStorno`
+  ADD CONSTRAINT `FinanceInvoiceStorno_ibfk_1` FOREIGN KEY (`StornoBy`) REFERENCES `FinanceInvoice` (`Id`),
+  ADD CONSTRAINT `FinanceInvoiceStorno_ibfk_2` FOREIGN KEY (`StornoOf`) REFERENCES `FinanceInvoice` (`Id`);
+  ");
+}
 
 class Updates
@@ -1627 +1647 @@
       747 => array('Revision' => 748, 'Function' => 'UpdateTo748'),
       748 => array('Revision' => 752, 'Function' => 'UpdateTo752'),
+      752 => array('Revision' => 755, 'Function' => 'UpdateTo755'),
     ));
   }