Changeset 52

Timestamp:

Feb 24, 2008, 3:18:56 PM (17 years ago)

Author:

george

Message:

Přidáno: Funkce pro vygenerování faktur za tři předchozí měsíce.

Location:

www

Files:

• finance/bills.php (modified) (3 diffs)
• finance/prepocet.php (modified) (1 diff)
• global.php (modified) (1 diff)

www/finance/bills.php

@@ -39 +39 @@
       $User['fullname'].'<br>'.
       $User['street'].'<br>'.
-      $User['psc'].' '.$User['town'].'<br>'.
-      'IČO: '.$User['ico'].'<br>'.
+      $User['psc'].' '.$User['town'].'<br>';
+      if($User['ico'] != 0) $Output .= 'IČO: '.$User['ico'].'<br>';
+      $Output .= 
       '</td></tr>'.
       '<tr><td colspan="2"><hr></td></tr>'.
@@ -82 +83 @@
     global $Database;
   
-    $Database->insert('finance_bills', array('time_create' => 'NOW()', 'user_id' => $UserId, 'time_from' => TimeToMysqlDateTime($TimeFrom), 'time_to' => TimeToMysqlDateTime($TimeTo), 'time_due' => TimeToMysqlDateTime(time() + 15*24*3600)));
+    $Database->insert('finance_bills', array('time_create' => TimeToMysqlDateTime($TimeFrom), 'user_id' => $UserId, 'time_from' => TimeToMysqlDateTime($TimeFrom), 'time_to' => TimeToMysqlDateTime($TimeTo), 'time_due' => TimeToMysqlDateTime($TimeFrom + 15*24*3600)));
     $BillId = $Database->insert_id;
     foreach($Items as $Item)
@@ -122 +123 @@
     $Output = shell_exec('echo "'.addslashes(from_utf8($HtmlCode)).'"|htmldoc --no-numbered --webpage --charset 8859-2 -t pdf -');
     return($Output);
+  }
+
+  function CustomGenerate()
+  {
+    global $Database;
+    
+    $DbResult = $Database->select('finance_operations', '*', '(date="2008-02-01" AND comment="Poplatek za měsíc Únor") OR '.
+    '(date="2008-01-01" AND comment="Poplatek za měsíc Leden") OR (date="2007-12-01" AND comment="Poplatek za měsíc Prosinec") AND (bill_id = 0)');
+    while($Row = $DbResult->fetch_array())
+    {
+      echo($Row['id']."<br>\n");
+      $Time = MysqlDateToTime($Row['date']);
+      $BillId = $this->CreateBill($Row['user'], array(array('description' => 'Poplatek za připojení k síti', 'price' => (-$Row['money']), 'quantity' => 1)), $Time, $Time + (date("t", time()) - 1) * 24 * 3600);  
+     $Database->update('finance_operations', 'id='.$Row['id'], array('bill_id' => $BillId));
+    }
   }
 

www/finance/prepocet.php

@@ -128 +128 @@
 RecalculateTariffs();
 //DiscountNetworkDevicePrice();
+$InvoiceGenerator->CustomGenerate();
 RecalculateUsersFinance();
 

www/global.php

@@ -45 +45 @@
 {
   return(date('Y-m-d H:i:s', $Time));  
+}
+
+function MysqlDateTimeToTime($Time)
+{
+  $Parts = explode(' ', $Time);
+  $DateParts = explode('-', $Parts[0]); 
+  $TimeParts = explode(':', $Parts[1]);
+  $Result = mktime($TimeParts[0], $TimeParts[1], $TimeParts[2], $DateParts[1], $DateParts[2], $DateParts[0]); 
+  return($Result);  
+}
+
+function MysqlDateToTime($Time)
+{
+  return(MysqlDateTimeToTime($Time.' 0:0:0'));  
 }