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

Timestamp:

Jan 1, 2017, 10:21:42 PM (8 years ago)

Author:

chronos

Message:

• Added: Autocreate new finance year if necessary for new document line items.

File:

• trunk/Modules/Finance/Finance.php (modified) (1 diff)

trunk/Modules/Finance/Finance.php

@@ -82 +82 @@
     return(round($Spotreba * 0.72 * $this->kWh));
   }
-
-  function GetNextDocumentLineNumber($Id, $FinanceYear = 0)
-  {
-    if($FinanceYear == 0)
+  
+  function CreateFinanceYear($Year)
+  {
+    $StartTime = mktime(0, 0, 0, 1, 1, $Year);
+    $EndTime = mktime(0, 0, 0, 12, 31, $Year);
+    $this->Database->insert('FinanceYear', array('Year' => $Year, 
+          'DateStart' => TimeToMysqlDate($StartTime), 'DateEnd' => TimeToMysqlDate($EndTime), 'Closed' => 0));
+        $YearId = $this->Database->insert_id;
+
+    // Create DocumentLineSequence from previous
+    $DbResult = $this->Database->select('DocumentLine', 'Id', '`Yearly` = 1');
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+          $this->Database->insert('DocumentLineSequence', array('FinanceYear' => $YearId, 
+            'NextNumber' => 1, 'YearPrefix' => 1, 'DocumentLine' => $DbRow['Id']));
+        }
+  }
+  
+  function GetFinanceYear($Year)
+  {
+    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`='.$FinanceYear);
-    if($DbResult->num_rows == 0) throw new Exception('Rok '.$FinanceYear.' nenalezen');
+    } else $DbResult = $this->Database->select('FinanceYear', '*', '`Year`='.$Year);
+    if($DbResult->num_rows == 0) {
+          if($Year == date('Y'))
+          {
+                $this->CreateFinanceYear($Year);
+        $DbResult = $this->Database->select('FinanceYear', '*', '`Year`='.$Year);           
+          } else throw new Exception('Rok '.$Year.' nenalezen');
+        }
     $FinanceYear = $DbResult->fetch_assoc();
-    if($FinanceYear['Closed'] == 1) throw new Exception('Rok '.$FinanceYear['Year'].' je již uzavřen. Nelze do něj přidávat položky.');
+    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;          
+  }
+
+  function GetNextDocumentLineNumber($Id, $FinanceYear = 0)
+  {
+        $FinanceYear = $this->GetFinanceYear($FinanceYear);
 
     $DbResult = $this->Database->query('SELECT `Shortcut`, `Id` FROM `DocumentLine` WHERE `Id`='.$Id);