Changeset 873 for trunk/Modules/Finance/Finance.php

Timestamp:

Apr 6, 2020, 11:17:40 PM (4 years ago)

Author:

chronos

Message:

• Modified: Improved code format.

File:

• trunk/Modules/Finance/Finance.php (modified) (21 diffs)

trunk/Modules/Finance/Finance.php

@@ -44 +44 @@
   {
     $DbResult = $this->Database->query('SELECT * FROM `FinanceBillingPeriod`');
-    while($BillingPeriod = $DbResult->fetch_assoc())
+    while ($BillingPeriod = $DbResult->fetch_assoc())
       $this->BillingPeriods[$BillingPeriod['Id']] = $BillingPeriod;
 
@@ -80 +80 @@
   function W2Kc($Spotreba)
   {
-    return(round($Spotreba * 0.72 * $this->kWh));
+    return (round($Spotreba * 0.72 * $this->kWh));
   }
 
@@ -93 +93 @@
     // Create DocumentLineSequence from previous
     $DbResult = $this->Database->select('DocumentLine', 'Id', '`Yearly` = 1');
-    while($DbRow = $DbResult->fetch_assoc())
+    while ($DbRow = $DbResult->fetch_assoc())
     {
           $this->Database->insert('DocumentLineSequence', array('FinanceYear' => $YearId,
@@ -102 +102 @@
   function GetFinanceYear($Year)
   {
-    if($Year == 0)
+    if ($Year == 0)
     {
       // Get latest year
       $DbResult = $this->Database->select('FinanceYear', '*', '1 ORDER BY `Year` DESC LIMIT 1');
     } else $DbResult = $this->Database->select('FinanceYear', '*', '`Year`='.$Year);
-    if($DbResult->num_rows == 0) {
-          if($Year == date('Y'))
+    if ($DbResult->num_rows == 0) {
+          if ($Year == date('Y'))
           {
                 $this->CreateFinanceYear($Year);
@@ -115 +115 @@
         }
     $FinanceYear = $DbResult->fetch_assoc();
-    if($FinanceYear['Closed'] == 1)
+    if ($FinanceYear['Closed'] == 1)
       throw new Exception('Rok '.$FinanceYear['Year'].' je již uzavřen. Nelze do něj přidávat položky.');
     return $FinanceYear;
@@ -131 +131 @@
     $Sequence = $DbResult->fetch_assoc();
 
-    if($Sequence['YearPrefix'] == 1)
+    if ($Sequence['YearPrefix'] == 1)
     {
       $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'].'/'.$FinanceYear['Year'];
@@ -138 +138 @@
     $this->Database->query('UPDATE `DocumentLineSequence` SET `NextNumber` = `NextNumber` + 1 '.
       'WHERE (`DocumentLine`='.$Id.') AND (`FinanceYear`='.$FinanceYear['Id'].')');
-    return($Result);
+    return ($Result);
   }
 
@@ -151 +151 @@
   {
     $DbResult = $this->Database->query('SELECT * FROM `'.$Table.'` WHERE `Id`= '.$Id);
-    if($DbResult->num_rows == 1) {
+    if ($DbResult->num_rows == 1) {
       $Group = $DbResult->fetch_assoc();
-      return($Group);
+      return ($Group);
     } else die('Finance group id '.$Id.' not found in table '.$Table);
   }
@@ -162 +162 @@
     $this->Database->query('TRUNCATE TABLE `MemberPayment`');
     $DbResult = $this->Database->query('SELECT * FROM `Member`');
-    while($Member = $DbResult->fetch_assoc())
+    while ($Member = $DbResult->fetch_assoc())
     {
       $DbResult2 = $this->Database->query('SELECT ((SELECT COALESCE(SUM(`Value`), 0) FROM `FinanceOperation` '.
@@ -182 +182 @@
       $DbRow = $DbResult2->fetch_assoc();
       $Monthly = 0;
-      if($DbRow['Price'] != '') $MonthlyInet = $DbRow['Price'];
+      if ($DbRow['Price'] != '') $MonthlyInet = $DbRow['Price'];
       else $MonthlyInet = 0;
 
@@ -189 +189 @@
       $Monthly = round($Monthly);
 
-      if($Member['BillingPeriod'] == 1)
+      if ($Member['BillingPeriod'] == 1)
       {
         // Inactive payer
@@ -204 +204 @@
     }
     $this->System->ModuleManager->Modules['Log']->NewRecord('Finance', 'RecalculateMemberPayment');
-    return($Output);
+    return ($Output);
   }
 
@@ -214 +214 @@
       TimeToMysqlDate($Time).'") OR (ValidTo IS NULL)) LIMIT 1');
     $Row = $DbResult->fetch_array();
-    return($Row[0]);
+    return ($Row[0]);
   }
 }
@@ -665 +665 @@
   function BeforeInsertFinanceOperation($Form)
   {
-    if(array_key_exists('Time', $Form->Values)) $Year = date("Y", $Form->Values['Time']);
+    if (array_key_exists('Time', $Form->Values)) $Year = date("Y", $Form->Values['Time']);
       else $Year = date("Y", $Form->Values['ValidFrom']);
     $FinanceGroup = $this->System->Modules['Finance']->GetFinanceGroupById($Form->Values['Group'], 'FinanceOperationGroup');
     $Form->Values['BillCode'] = $this->System->Modules['Finance']->GetNextDocumentLineNumberId($FinanceGroup['DocumentLine'], $Year);
-    return($Form->Values);
+    return ($Form->Values);
   }
 
@@ -677 +677 @@
     $this->Database->query('UPDATE `'.$Form->Definition['Table'].'` SET `Value`= '.
       ($Form->Values['ValueUser'] * $FinanceGroup['ValueSign']).' WHERE `Id`='.$Id);
-    return($Form->Values);
+    return ($Form->Values);
   }
 
@@ -685 +685 @@
     $this->Database->query('UPDATE `'.$Form->Definition['Table'].'` SET `Value`= '.
       ($Form->Values['ValueUser'] * $FinanceGroup['ValueSign']).' WHERE `Id`='.$Id);
-    return($Form->Values);
+    return ($Form->Values);
   }
 
@@ -691 +691 @@
   {
     // Get new DocumentLineCode by selected invoice Group
-    if(array_key_exists('Time', $Form->Values)) $Year = date("Y", $Form->Values['Time']);
+    if (array_key_exists('Time', $Form->Values)) $Year = date("Y", $Form->Values['Time']);
       else $Year = date("Y", $Form->Values['ValidFrom']);
     $Group = $this->System->Modules['Finance']->GetFinanceGroupById($Form->Values['Group'], 'FinanceInvoiceGroup');
     $Form->Values['BillCode'] = $this->System->Modules['Finance']->GetNextDocumentLineNumberId($Group['DocumentLine'], $Year);
-    return($Form->Values);
+    return ($Form->Values);
   }
 
@@ -707 +707 @@
     $this->Database->query('UPDATE `'.$Form->Definition['Table'].'` SET `Value`= '.
       ($Sum * $FinanceGroup['ValueSign']).' WHERE `Id`='.$Id);
-    return($Form->Values);
+    return ($Form->Values);
   }
 
@@ -718 +718 @@
     $this->Database->query('UPDATE `'.$Form->Definition['Table'].'` SET `Value`= '.
       ($Sum * $FinanceGroup['ValueSign']).' WHERE `Id`='.$Id);
-    return($Form->Values);
+    return ($Form->Values);
   }
 
@@ -727 +727 @@
     $ParentForm->LoadValuesFromDatabase($Form->Values['FinanceInvoice']);
     $this->AfterInsertFinanceInvoice($ParentForm, $Form->Values['FinanceInvoice']);
-    return($Form->Values);
+    return ($Form->Values);
   }
 
@@ -736 +736 @@
     $ParentForm->LoadValuesFromDatabase($Form->Values['FinanceInvoice']);
     $this->BeforeModifyFinanceInvoice($ParentForm, $Form->Values['FinanceInvoice']);
-    return($Form->Values);
+    return ($Form->Values);
   }
 
   function BeforeInsertContract($Form)
   {
-    if(array_key_exists('Time', $Form->Values)) $Year = date("Y", $Form->Values['Time']);
+    if (array_key_exists('Time', $Form->Values)) $Year = date("Y", $Form->Values['Time']);
       else $Year = date("Y", $Form->Values['ValidFrom']);
     $Form->Values['BillCode'] = $this->System->Modules['Finance']->GetNextDocumentLineNumberId($Form->Values['DocumentLine'], $Year);
-    return($Form->Values);
+    return ($Form->Values);
   }
 }