Changeset 581 for trunk/Modules/Network/Network.php

Timestamp:

Oct 14, 2013, 12:26:30 AM (11 years ago)

Author:

chronos

Message:

• Přidáno: Možnost určovat položky formulářových typů jako virtuální zadané jako SQL poddotaz.

File:

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

trunk/Modules/Network/Network.php

@@ -132 +132 @@
     
     $this->System->FormManager->RegisterClass('Subject', array(
-        'Title' => 'Subjekty',
-        'Table' => 'Subject',
-        'DefaultSortColumn' => 'Name',
-        'Items' => array(
-            'Id' => array('Type' => 'Integer', 'Caption' => 'Identifikace', 'Default' => '', 'ReadOnly' => true),
-            'Name' => array('Type' => 'String', 'Caption' => 'Celé jméno', 'Default' => ''),
-            'AddressStreet' => array('Type' => 'String', 'Caption' => 'Ulice', 'Default' => ''),
-            'AddressTown' => array('Type' => 'String', 'Caption' => 'Město', 'Default' => ''),
-            'AddressPSC' => array('Type' => 'String', 'Caption' => 'PSČ', 'Default' => ''),
-            'AddressCountry' => array('Type' => 'TCountry', 'Caption' => 'Země', 'Default' => ''),
-            'IC' => array('Type' => 'String', 'Caption' => 'IČ', 'Default' => ''),
-            'DIC' => array('Type' => 'String', 'Caption' => 'DIČ', 'Default' => ''),
-            'MapPosition' => array('Type' => 'TMapPosition', 'Caption' => 'Pozice na mapě', 'Default' => '', 'Null' => true),
-            'WWW' => array('Type' => 'Hyperlink', 'Caption' => 'WWW', 'Default' => ''),
-            'Note' => array('Type' => 'String', 'Caption' => 'Poznámka', 'Default' => ''),
-            'Customer' => array('Type' => 'TMemberListSubject', 'Caption' => 'Členové', 'Default' => ''),
-            'Operations' => array('Type' => 'TFinanceOperationListSubject', 'Caption' => 'Platby', 'Default' => ''),
-            'Invoices' => array('Type' => 'TFinanceInvoiceListSubject', 'Caption' => 'Faktury', 'Default' => ''),
-        ),
+      'Title' => 'Subjekty',
+      'Table' => 'Subject',
+      'DefaultSortColumn' => 'Name',
+      'Items' => array(
+        'Id' => array('Type' => 'Integer', 'Caption' => 'Identifikace', 'Default' => '', 'ReadOnly' => true),
+        'Name' => array('Type' => 'String', 'Caption' => 'Celé jméno', 'Default' => ''),
+        'AddressStreet' => array('Type' => 'String', 'Caption' => 'Ulice', 'Default' => ''),
+        'AddressTown' => array('Type' => 'String', 'Caption' => 'Město', 'Default' => ''),
+        'AddressPSC' => array('Type' => 'String', 'Caption' => 'PSČ', 'Default' => ''),
+        'AddressCountry' => array('Type' => 'TCountry', 'Caption' => 'Země', 'Default' => ''),
+        'IC' => array('Type' => 'String', 'Caption' => 'IČ', 'Default' => ''),
+        'DIC' => array('Type' => 'String', 'Caption' => 'DIČ', 'Default' => ''),
+        'MapPosition' => array('Type' => 'TMapPosition', 'Caption' => 'Pozice na mapě', 'Default' => '', 'Null' => true),
+        'WWW' => array('Type' => 'Hyperlink', 'Caption' => 'WWW', 'Default' => ''),
+        'Note' => array('Type' => 'String', 'Caption' => 'Poznámka', 'Default' => ''),
+        'Customer' => array('Type' => 'TMemberListSubject', 'Caption' => 'Členové', 'Default' => ''),
+        'Operations' => array('Type' => 'TFinanceOperationListSubject', 'Caption' => 'Platby', 'Default' => ''),
+        '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)'),
+      ),
     ));
     $this->System->FormManager->RegisterClass('NetworkDomainAlias', array(