Changeset 786 for trunk/Application

Timestamp:

Jan 11, 2016, 12:06:08 AM (9 years ago)

Author:

chronos

Message:

• Modified: Now billing period for invoice generation is calculated as aligned to year boundary and if period is not complete then only valid months are used.
• Removed: ToDo list and list of task and bugs is available in Trac web system.
• Modified: BillingPeriodNext was replaced by more general ChangeAction in Member table.
• Added: Log new monthly finance recalculation report to log table.

Location:

trunk/Application

Files:

• FormClasses.php (modified) (3 diffs)
• UpdateTrace.php (modified) (2 diffs)

trunk/Application/FormClasses.php

@@ -30 +30 @@
       'Shortcut' => array('Type' => 'String', 'Caption' => 'Kód', 'Default' => ''),
       'Sequence' => array('Type' => 'TDocumentLineSequenceListLine', 'Caption' => 'Čísleníky', 'Default' => ''),
-        'Codes' => array('Type' => 'TDocumentLineCodeList', 'Caption' => 'Kódy', 'Default' => ''),
+      'Codes' => array('Type' => 'TDocumentLineCodeList', 'Caption' => 'Kódy', 'Default' => ''),
+      'Operations' => array('Type' => 'TFinanceOperationGroupListDocumentLine', 'Caption' => 'Skupiny finančních operací', 'Default' => ''),
+      'Invoices' => array('Type' => 'TFinanceInvoiceGroupListDocumentLine', 'Caption' => 'Skupiny faktur', 'Default' => ''),
     ),
   ),
@@ -42 +44 @@
       'NextNumber' => array('Type' => 'Integer', 'Caption' => 'Další číslo', 'Default' => '1'),
       'YearPrefix' => array('Type' => 'Boolean', 'Caption' => 'Rok jako přípona', 'Default' => '1'),
-      'Operations' => array('Type' => 'TFinanceOperationListDocumentLine', 'Caption' => 'Finanční operace', 'Default' => ''),
-      'Invoices' => array('Type' => 'TFinanceInvoiceListDocumentLine', 'Caption' => 'Faktury', 'Default' => ''),
     ),
   ),
@@ -461 +461 @@
     'Filter' => '1',
   ),
-  'TFinanceOperationListDocumentLine' => array(
-    'Type' => 'ManyToOne',
-    'Table' => 'FinanceOperation',
+  'TFinanceOperationGroupListDocumentLine' => array(
+    'Type' => 'ManyToOne',
+    'Table' => 'FinanceOperationGroup',
     'Id' => 'Id',
     'Ref' => 'DocumentLine',
     'Filter' => '1',
   ),
-  'TFinanceInvoiceListDocumentLine' => array(
-    'Type' => 'ManyToOne',
-    'Table' => 'FinanceInvoice',
+  'TFinanceInvoiceGroupListDocumentLine' => array(
+    'Type' => 'ManyToOne',
+    'Table' => 'FinanceInvoiceGroup',
     'Id' => 'Id',
     'Ref' => 'DocumentLine',

trunk/Application/UpdateTrace.php

@@ -1793 +1793 @@
 {
   $Manager->Execute('DROP TABLE `NetworkInterfaceStat`');
+}
+
+function UpdateTo786($Manager)
+{
+  $Manager->Execute('ALTER TABLE `Member` DROP FOREIGN KEY Member_ibfk_28;');
+  $Manager->Execute('ALTER TABLE `Member` DROP `BillingPeriodNext`;');
+  $Manager->Execute('ALTER TABLE `Member` ADD `Action` ENUM( "add", "modify", "remove" ) NULL');
+  $Manager->Execute('ALTER TABLE `Member` ADD `ChangeTime` DATETIME NULL');
+  $Manager->Execute('ALTER TABLE `Member` ADD `ReplaceId` `ChangeReplaceId` INT(11) NULL DEFAULT NULL;');
+  $Manager->Execute('ALTER TABLE `Member` ADD FOREIGN KEY (`ChangeReplaceId`) REFERENCES `Member`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
 }
 
@@ -1876 +1886 @@
       768 => array('Revision' => 770, 'Function' => 'UpdateTo770'),
       770 => array('Revision' => 785, 'Function' => 'UpdateTo785'),
+      775 => array('Revision' => 786, 'Function' => 'UpdateTo786'),
     ));
   }