Changeset 939 for trunk/Application/UpdateTrace.php

Timestamp:

Aug 2, 2022, 9:26:10 AM (22 months ago)

Author:

chronos

Message:

• Fixed: Incorrectly used member date BillingPeriodLastDate for determining new payments log for payment notification email.

File:

• trunk/Application/UpdateTrace.php (modified) (2 diffs)

trunk/Application/UpdateTrace.php

@@ -2217 +2217 @@
   $Manager->Execute('UPDATE `PermissionGroup` SET `SysName`="other-users" WHERE `Description`="Ostatní"');
   $Manager->Execute('UPDATE `PermissionGroup` SET `SysName`="customers" WHERE `Description`="Zákazníci"');
+}
+
+function UpdateTo939(UpdateManager $Manager): void
+{  
+  $Manager->Execute('ALTER TABLE `Member` ADD `PaymentEmailTime` DATETIME NULL DEFAULT NULL AFTER `Contract`;');
+  $Manager->Execute('UPDATE `Member` SET `PaymentEmailTime`=DATE_SUB(`BillingPeriodLastDate`, INTERVAL 1 MONTH) WHERE BillingPeriod=2 AND BillingPeriodLastDate<>"0000-00-00"');
+  $Manager->Execute('UPDATE `Member` SET `PaymentEmailTime`=DATE_SUB(`BillingPeriodLastDate`, INTERVAL 3 MONTH) WHERE BillingPeriod=3 AND BillingPeriodLastDate<>"0000-00-00"');
+  $Manager->Execute('UPDATE `Member` SET `PaymentEmailTime`=DATE_SUB(`BillingPeriodLastDate`, INTERVAL 6 MONTH) WHERE BillingPeriod=4 AND BillingPeriodLastDate<>"0000-00-00"');
+  $Manager->Execute('UPDATE `Member` SET `PaymentEmailTime`=DATE_SUB(`BillingPeriodLastDate`, INTERVAL 12 MONTH) WHERE BillingPeriod=5 AND BillingPeriodLastDate<>"0000-00-00"');
+  $Manager->Execute('ALTER TABLE `UserOnline` ENGINE = InnoDB;');
 }
 
@@ -2328 +2338 @@
       911 => array('Revision' => 921, 'Function' => 'UpdateTo921'),
       921 => array('Revision' => 933, 'Function' => 'UpdateTo933'),
+      933 => array('Revision' => 939, 'Function' => 'UpdateTo939'),
     );
   }