Changeset 968 for trunk/Modules/Finance/FinanceModels.php

Timestamp:

Apr 12, 2024, 9:43:27 PM (5 weeks ago)

Author:

chronos

Message:

• Modified: Improved content of email with finance account state.
• Added: Customer IS action to generate finance email into email queue.

File:

• trunk/Modules/Finance/FinanceModels.php (modified) (2 diffs)

trunk/Modules/Finance/FinanceModels.php

@@ -40 +40 @@
     $DbResult = $this->Database->query('SELECT * FROM `FinanceBillingPeriod`');
     while ($BillingPeriod = $DbResult->fetch_assoc())
+    {
       $this->BillingPeriods[$BillingPeriod['Id']] = $BillingPeriod;
+    }
 
     // Period parameter is not used as it have to be determined from item replacement
@@ -65 +67 @@
 
     $DbResult = $this->Database->query('SELECT SUM(`MemberPayment`.`MonthlyInternet`) AS `MonthlyInternet`, '.
-        'SUM(`MemberPayment`.`MonthlyTotal`) AS `MonthlyTotal` '.
-        'FROM `MemberPayment` JOIN `Member` ON `Member`.`Id`=`MemberPayment`.`Member` WHERE `Member`.`Blocked`=0');
+      'SUM(`MemberPayment`.`MonthlyTotal`) AS `MonthlyTotal` '.
+      'FROM `MemberPayment` JOIN `Member` ON `Member`.`Id`=`MemberPayment`.`Member` WHERE `Member`.`Blocked`=0');
     $Row = $DbResult->fetch_assoc();
     $this->TotalInternetPaid = $Row['MonthlyInternet'];