Changeset 808 for trunk/Modules/Finance/Finance.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/Modules/Finance/Finance.php (modified) (1 diff)

trunk/Modules/Finance/Finance.php

@@ -425 +425 @@
           'WHERE `FinanceOperation`.`Treasury`=#Id)'),
         'Operations' => array('Type' => 'TFinanceOperationListTreasury', 'Caption' => 'Operace', 'Default' => ''),
-      ),
+        'Check' => array('Type' => 'TFinanceTreasuryCheckListTreasury', 'Caption' => 'Kontrola', 'Default' => ''),
+      ),
+    ));
+    $this->System->FormManager->RegisterClass('FinanceTreasuryCheck', array(
+      'Title' => 'Kontrola pokladen',
+      'Table' => 'FinanceTreasuryCheck',
+      'DefaultSortColumn' => 'Time',
+      'Items' => array(
+        'Treasury' => array('Type' => 'TFinanceTreasury', 'Caption' => 'Pokladna', 'Default' => ''),
+        'Time' => array('Type' => 'DateTime', 'Caption' => 'Čas', 'Default' => ''),
+        'Value1' => array('Type' => 'Integer', 'Caption' => 'Hodnota 1', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value2' => array('Type' => 'Integer', 'Caption' => 'Hodnota 2', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value5' => array('Type' => 'Integer', 'Caption' => 'Hodnota 5', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value10' => array('Type' => 'Integer', 'Caption' => 'Hodnota 10', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value20' => array('Type' => 'Integer', 'Caption' => 'Hodnota 20', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value50' => array('Type' => 'Integer', 'Caption' => 'Hodnota 50', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value100' => array('Type' => 'Integer', 'Caption' => 'Hodnota 100', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value200' => array('Type' => 'Integer', 'Caption' => 'Hodnota 200', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value500' => array('Type' => 'Integer', 'Caption' => 'Hodnota 500', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value1000' => array('Type' => 'Integer', 'Caption' => 'Hodnota 1000', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value2000' => array('Type' => 'Integer', 'Caption' => 'Hodnota 2000', 'Default' => '0', 'Suffix' => 'ks'),
+        'Value5000' => array('Type' => 'Integer', 'Caption' => 'Hodnota 5000', 'Default' => '0', 'Suffix' => 'ks'),
+        'Sum' => array('Type' => 'Integer', 'Caption' => 'Součet', 'Default' => '0', 'Suffix' => 'Kč',
+          'SQL' => '(`Value1` * 1 + `Value2` * 2 + `Value5` * 5 + `Value10` * 10 + '.
+          '`Value20` * 20 + `Value50` * 50 + `Value100` * 100 + `Value200` * 200 + '.
+          '`Value500` * 500 + `Value1000` * 1000 + `Value2000` * 2000 + `Value5000` * 5000)'),
+      ),
+    ));
+    $this->System->FormManager->RegisterFormType('TFinanceTreasuryCheckListTreasury', array(
+      'Type' => 'ManyToOne',
+      'Table' => 'FinanceTreasuryCheck',
+      'Id' => 'Id',
+      'Ref' => 'Treasury',
+      'Filter' => '1',
     ));
     $this->System->FormManager->RegisterFormType('TFinanceTreasury', array(