Changeset 939 for trunk/Application

Timestamp:

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

Author:

chronos

Message:

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

Location:

trunk/Application

Files:

• UpdateTrace.php (modified) (2 diffs)
• Version.php (modified) (1 diff)

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'),
     );
   }

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 933; // Subversion revision
-$DatabaseRevision = 933; // SQL structure revision
-$ReleaseTime = strtotime('2022-05-11');
+$Revision = 939; // Subversion revision
+$DatabaseRevision = 939; // SQL structure revision
+$ReleaseTime = strtotime('2022-08-01');