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

Timestamp:

Sep 7, 2014, 6:15:54 PM (10 years ago)

Author:

chronos

Message:

• Opraveno: Zobrazení stavu placení u Subjektů v ISu.
• Přidáno: Výchozí řazení u fronty emailů podle času.

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' => '(SELECT SUM(`FinanceOperation`.`Value`) FROM `FinanceOperation` '.
-          'WHERE `FinanceOperation`.`Subject`=#Id) - (SELECT SUM(`FinanceInvoice`.`Value`) FROM `FinanceInvoice` '.
-          'WHERE `FinanceInvoice`.`Subject`=#Id)'),
+          'ReadOnly' => true, 'Suffix' => 'Kč', 'SQL' => 'IFNULL((SELECT SUM(`FinanceOperation`.`Value`) FROM `FinanceOperation` '.
+          'WHERE `FinanceOperation`.`Subject`=#Id), 0) - IFNULL((SELECT SUM(`FinanceInvoice`.`Value`) FROM `FinanceInvoice` '.
+          'WHERE `FinanceInvoice`.`Subject`=#Id), 0)'),
       ),
     ));