Changeset 761 for trunk/Modules/Subject/Subject.php

Timestamp:

Nov 4, 2015, 9:00:41 AM (9 years ago)

Author:

chronos

Message:

• Fixed: Generation of new invoices.
• Fixed: Presetting values for pairing imported operations from bank account.
• Fixed: Firewall NAT rules error.

File:

• trunk/Modules/Subject/Subject.php (modified) (1 diff)

trunk/Modules/Subject/Subject.php

@@ -36 +36 @@
         'Invoices' => array('Type' => 'TFinanceInvoiceListSubject', 'Caption' => 'Faktury', 'Default' => ''),
         'Payment' => array('Type' => 'Float', 'Caption' => 'Placení', 'Default' => '',
-          'ReadOnly' => true, 'Suffix' => 'Kč', 'SQL' => 'IFNULL((SELECT SUM(`FinanceOperation`.`Value`) FROM `FinanceOperation` '.
+          'ReadOnly' => true, 'Suffix' => 'Kč', 'SQL' => 'ROUND(IFNULL((SELECT SUM(`FinanceOperation`.`Value`) FROM `FinanceOperation` '.
           'WHERE `FinanceOperation`.`Subject`=#Id), 0) - IFNULL((SELECT SUM(`FinanceInvoice`.`Value`) FROM `FinanceInvoice` '.
-          'WHERE `FinanceInvoice`.`Subject`=#Id), 0)'),
-        'BankAccounts' => array('Type' => 'TFinanceBankAccountListSubject', 'Caption' => 'Bankovní účety', 'Default' => ''),
+          'WHERE `FinanceInvoice`.`Subject`=#Id), 0))'),
+        'BankAccounts' => array('Type' => 'TFinanceBankAccountListSubject', 'Caption' => 'Bankovní účty', 'Default' => ''),
       ),
     ));