Changeset 688 for trunk/Common/Setup/Updates.php

Timestamp:

Sep 7, 2014, 2:48:21 PM (10 years ago)

Author:

chronos

Message:

• Upraveno: Spotřeba se dále bude zákazníkům evidovat jako samostatná přiřazená služba namísto pevného vkládání položky a dopočtu z tabulky "Placení zákazníků".

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -885 +885 @@
 }
 
+function UpdateTo688($Manager)
+{
+        // Convert monthly plus payment for consumption to regular service
+  $DbResult = $Manager->Execute('SELECT `MonthlyPlus`, `Member` FROM `MemberPayment` WHERE `MonthlyPlus` > 0');
+  while($DbResult->num_rows > 0)
+  {
+        $DbRow = $DbResult->fetch_assoc();
+    $Manager->Execute("INSERT INTO `Service` (`Id` ,`Name` ,`Category` ,`Price` ,`VAT`) ".
+      "VALUES (NULL , 'Spotřeba energie', 3, -".$DbRow['MonthlyPlus'].", 2);");
+    $ServiceId = $Manager->Database->insert_id;
+    $Manager->Execute("INSERT INTO `ServiceCustomerRel` (`Id` ,`Service` ,`Customer`) ".
+      "VALUES (NULL , ".$ServiceId.', '.$DbRow['Member'].");");
+  }
+}
+
 class Updates
 {
@@ -933 +948 @@
       676 => array('Revision' => 678, 'Function' => 'UpdateTo678'),
       678 => array('Revision' => 679, 'Function' => 'UpdateTo679'),
+      679 => array('Revision' => 688, 'Function' => 'UpdateTo688'),
     ));
   }