Changeset 877 for trunk/Modules/Finance/Finance.php

Timestamp:

Apr 25, 2020, 10:58:07 PM (4 years ago)

Author:

chronos

Message:

• Added: Show number of paired invoices in finance operations.

File:

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

trunk/Modules/Finance/Finance.php

@@ -269 +269 @@
         'Generate' => array('Type' => 'Boolean', 'Caption' => 'Generovat', 'Default' => ''),
         'InvoiceRel' => array('Type' => 'TFinanceInvoiceOperationRelListOperation', 'Caption' => 'Zaplacené faktury', 'Default' => ''),
+        'InvoiceRelCount' => array('Type' => 'Integer', 'Caption' => 'Faktur',
+          'ReadOnly' => true, 'SQL' => '(SELECT COUNT(`FinanceInvoiceOperationRel`.`Id`) FROM `FinanceInvoiceOperationRel` '.
+          'WHERE `FinanceInvoiceOperationRel`.`Operation`=#Id)'),
       ),
       'BeforeInsert' => array($this, 'BeforeInsertFinanceOperation'),