Changeset 967 for trunk/Application

Timestamp:

Mar 6, 2024, 11:47:49 PM (3 months ago)

Author:

chronos

Message:

• Added: Monthly finance report.

Location:

trunk/Application

Files:

• UpdateTrace.php (modified) (3 diffs)
• Version.php (modified) (1 diff)

trunk/Application/UpdateTrace.php

@@ -619 +619 @@
   $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD `Contract` INT NULL ,
 ADD INDEX ( `Contract` ) ;');
- $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD FOREIGN KEY ( `Contract` ) REFERENCES `Contract` (
+  $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD FOREIGN KEY ( `Contract` ) REFERENCES `Contract` (
 `Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
   $Manager->Execute("INSERT INTO `Action` (
@@ -2242 +2242 @@
 {
   $Manager->Execute('ALTER TABLE `Log` ADD `URL` VARCHAR(255) NOT NULL AFTER `IPAddress`;');
+}
+
+function UpdateTo967(UpdateManager $Manager): void
+{
+  $DbResult = $Manager->Execute('SELECT `Id` FROM `MenuItem` WHERE `Name`="Roční výkazy"');
+  if ($DbResult->num_rows > 0)
+  {
+    $DbRow = $DbResult->fetch_assoc();
+
+    $Manager->Execute("INSERT INTO `Action` (
+      `Id` ,`Name` ,`Title` ,`Type` ,`URL` ,`Group` ,`Icon` ,`PermissionOperation` ,
+      `Enable`) VALUES (NULL , '', 'Měsíční přehled', '1', '/is/?t=FinanceMonthReport&a=list', NULL , NULL , NULL , '1'
+      );");
+    $ActionId = $Manager->Database->insert_id;
+    $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+      "VALUES (NULL , 'Měsíční přehled', '".$DbRow['Id']."', '".$ActionId."', '1');");   
+  }
 }
 
@@ -2357 +2374 @@
       948 => array('Revision' => 953, 'Function' => 'UpdateTo953'),
       953 => array('Revision' => 957, 'Function' => 'UpdateTo957'),
+      957 => array('Revision' => 967, 'Function' => 'UpdateTo967'),
     );
   }

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 964; // Subversion revision
-$DatabaseRevision = 957; // SQL structure revision
-$ReleaseTime = strtotime('2024-02-03');
+$Revision = 967; // Subversion revision
+$DatabaseRevision = 967; // SQL structure revision
+$ReleaseTime = strtotime('2024-03-06');