Changeset 718

Timestamp:

Jan 1, 2015, 3:22:27 PM (10 years ago)

Author:

chronos

Message:

• Added: New table Company for representation of currecnt selected subject to work with.

Location:

trunk

Files:

• Application/Version.php (modified) (1 diff)
• Common/Setup/Updates.php (modified) (2 diffs)
• Modules/Finance/Finance.php (modified) (1 diff)

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 717; // Subversion revision
-$DatabaseRevision = 715; // SQL structure revision
+$Revision = 718; // Subversion revision
+$DatabaseRevision = 718; // SQL structure revision
 $ReleaseTime = strtotime('2015-01-01');

trunk/Common/Setup/Updates.php

@@ -1001 +1001 @@
         $Manager->Execute('ALTER TABLE `Member` DROP `NetworkSegment`');
         $Manager->Execute('DROP TABLE `NetworkSegment`');
+        $Manager->Execute('DELETE FROM `MenuItem` WHERE `Name`="Úseky sítě"');
+        $Manager->Execute('DELETE FROM `Action` WHERE `Title`="Úseky sítě"');
+}
+
+function UpdateTo718($Manager)
+{       
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `Company` (
+`Id` int(11) NOT NULL,
+`Name` varchar(255) NOT NULL,
+`Subject` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+  $Manager->Execute('ALTER TABLE `Company`
+ADD PRIMARY KEY (`Id`), ADD KEY `Subject` (`Subject`);');
+  $Manager->Execute('ALTER TABLE `Company`
+MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
+  $Manager->Execute('ALTER TABLE `Company`
+ADD CONSTRAINT `Company_ibfk_1` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`);');
+
+  // IS menu item
+  $Manager->Execute('INSERT INTO `Action` (`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,
+`Group` ,`Icon` ,`PermissionOperation` ,`Enable`) VALUES (
+NULL , "", "Firmy", "1", "/is/?t=Company&a=list", NULL , NULL , NULL , "1");');
+  $ActionId = $Manager->Database->insert_id;
+  $DbResult = $Manager->Execute('SELECT `Id` FROM `MenuItem` WHERE `Name`="Finance"');
+  if($DbResult->num_rows > 0)
+  {
+        $DbRow = $DbResult->fetch_assoc();
+    $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+      "VALUES (NULL , 'Firmy', ".$DbRow['Id'].", '".$ActionId."', '1');");
+  }
 }
 
@@ -1057 +1087 @@
       697 => array('Revision' => 707, 'Function' => 'UpdateTo707'),
       710 => array('Revision' => 715, 'Function' => 'UpdateTo715'),
+      715 => array('Revision' => 718, 'Function' => 'UpdateTo718'),
     ));
   }

trunk/Modules/Finance/Finance.php

@@ -320 +320 @@
       'BeforeInsert' => array($this, 'BeforeInsertFinanceOperation'),
     ));
+    $this->System->FormManager->RegisterClass('Company', array(
+      'Title' => 'Firma',
+      'Table' => 'Company',
+      'Items' => array(
+        'Name' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => '0'),
+        'Subject' => array('Type' => 'TSubject', 'Caption' => 'Subjekt', 'Default' => '0'),
+      ),
+    ));
     $this->System->FormManager->RegisterClass('FinanceInvoiceItem', array(
       'Title' => 'Položka faktury',