Changeset 552 for trunk/Modules/Finance/Manage.php

Timestamp:

Jul 7, 2013, 10:41:07 PM (11 years ago)

Author:

chronos

Message:

• Opraveno: Generování měsíčních plateb. Chyběla funkce vkládání faktury.
• Opraveno: Pořadí mazání starých tabulek FinanceBills.
• Opraveno: Chyba zobrazení souborů z IS.

File:

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

trunk/Modules/Finance/Manage.php

@@ -99 +99 @@
     $Output .= '<a href="?Operation=ProcessMonthlyPayment">Generovat faktury</a>';
     return($Output);
+  }
+  
+  function InsertInvoice($Subject, $TimeCreation, $TimeDue, $Items,
+  $DocumentLine, $PeriodFrom, $PeriodTo)
+  {
+    global $LastInsertTime;
+    
+    $BillCode = $this->System->Modules['Finance']->GetNextDocumentLineNumber($DocumentLine);
+    $SumValue = 0;
+    foreach($Items as $Item)
+        $SumValue = $SumValue + $Item['Price'];
+    $this->Database->insert('FinanceInvoice', array(
+          'Subject' => $Subject, 'TimeCreation' => TimeToMysqlDateTime($TimeCreation),
+          'TimeDue' => TimeToMysqlDateTime($TimeDue), 'Value' => $SumValue, 'BillCode' => $BillCode,
+          'PeriodFrom' => TimeToMysqlDate($PeriodFrom), 'PeriodTo' => TimeToMysqlDate($PeriodTo),
+          'Generate' => 1));
+    $InvoiceId = $this->Database->insert_id;
+    foreach($Items as $Item)
+      $this->Database->insert('FinanceInvoiceItem', array('FinanceInvoice' => $InvoiceId,
+        'Description' => $Item['Description'], 'Price' => $Item['Price'], 'Quantity' => $Item['Quantity'], 'VAT' => $Item['VAT']));
+    //$LastInsertTime = $Time;
+    //$this->CheckAdvancesAndLiabilities($Subject);
+    return($InvoiceId);
   }