Changeset 722 for trunk/Application

Timestamp:

Jan 3, 2015, 8:20:29 PM (10 years ago)

Author:

chronos

Message:

• Modified: Count of customers per service removed as column from Service table. It is now calculated online as SQL subcommand.
• Removed: Old tariffs recalculation for computation of dynamic aggregation according selected customer tariffs and maximum speed is not used further. Now static minimum and maximum speed is sufficient and it is enough general.

Location:

trunk/Application

Files:

• FormClasses.php (modified) (1 diff)
• Version.php (modified) (1 diff)

trunk/Application/FormClasses.php

@@ -126 +126 @@
       'Price' => array('Type' => 'Integer', 'Caption' => 'Cena', 'Default' => '0', 'Suffix' => 'Kč'),
       'VAT' => array('Type' => 'TFinanceVATType', 'Caption' => 'Sazba DPH', 'Default' => '0', 'Suffix' => ''),
-      'CustomerCount' => array('Type' => 'Integer', 'Caption' => 'Počet zákazníků', 'Default' => '', 'ReadOnly' => true),
+      'CustomerCount' => array('Type' => 'Integer', 'Caption' => 'Počet zákazníků', 'Default' => '', 'ReadOnly' => true,
+        'SQL' => '(SELECT COUNT(*) FROM `ServiceCustomerRel` LEFT JOIN `Member` ON `Member`.`Id`=`ServiceCustomerRel`.`Customer` WHERE (`ServiceCustomerRel`.`Service`=#Id) AND (`Member`.`Blocked`=0))'),
       'Public' => array('Type' => 'Boolean', 'Caption' => 'Veřejné', 'Default' => ''),
       'InternetSpeedMin' => array('Type' => 'Integer', 'Caption' => 'Min. rychlost internetu', 'Default' => '0', 'Suffix' => 'kbit/s'),

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 721; // Subversion revision
-$DatabaseRevision = 720; // SQL structure revision
+$Revision = 722; // Subversion revision
+$DatabaseRevision = 722; // SQL structure revision
 $ReleaseTime = strtotime('2015-01-03');