Changeset 140 for www/finance/bills.php

Timestamp:

Jan 21, 2009, 10:12:36 AM (15 years ago)

Author:

george

Message:

• Odstraněno: Stará statistika nahrazena samostatným projektem z vlastního repozitáře.

Location:

www

Files:

• . (modified) (1 prop)
• finance (modified) (1 prop)
• finance/bills.php (modified) (1 diff)

www

@@ -1 +1 @@
 config.php
 php_script_error.log
+statistic
+

@@ -1 +1 @@
 config.php
 php_script_error.log
+statistic
+

www/finance/bills.php

@@ -83 +83 @@
   }
 
+
+  function GenerateIncomeBill($BillId)
+  {
+    global $Database, $SpecificSymbol;
+  
+    $DbResult = $Database->select('finance_bills', '*', 'id='.$BillId);
+    $Bill = $DbResult->fetch_array();
+ 
+    $DbResult = $Database->select('users', '*', 'id='.$Bill['user_id']);
+    $User = $DbResult->fetch_array();
+
+    $Dodavka = array();
+    $DbResult = $Database->select('finance_bills_items', '*', 'bill_id='.$BillId);
+    while($Item = $DbResult->fetch_array())
+    {
+      $Dodavka[$Item['id']] = $Item; 
+    }
+  
+    $Output = '<table width="100%" border="1"><tr><td>'.
+      '<strong>Subjekt:</strong><br>'.
+      $User['subject_name'].'<br>'.
+      $User['street'].'<br>'.
+      $User['psc'].' '.$User['town'].'<br>';
+      if($User['ico'] != 0) $Output .= 'IČ: '.$User['ico'].'<br>';
+      if($User['dic'] != '') $Output .= 'DIČ: '.$User['dic'].'<br>';
+      $Output .= 
+      '</td><td>'.
+      'PŘÍJMOVÝ POKLADNÍ DOKLAD<br><br>'.
+      'Číslo dokladu: '.$Bill['BillCode'].'<br>'.
+      'Datum vystavení: '.HumanDate($Bill['time_create']).'<br>'.
+      '</td></tr>'.
+      '<tr><td colspan="2"><strong>Přijato od:</strong><br>'.
+      '</td></tr>'.
+      '<tr><td colspan="2"><strong>Částka: '.
+      '<strong>Platební podmínky:</strong><br>'.
+      'Variabilní symbol: '.$User['id'].'<br>'.
+      'Specifický symbol: '.$this->SpecificSymbol.'<br>'.
+      'Konstantní symbol:<br>'.
+      'Způsob úhrady: převodem'.
+      '</td><td valign="top">'.
+      '<br>'.
+      'Datum zdanitel. plnění: '.HumanDate($Bill['time_create']).'<br>'.
+      'Datum splatnosti: '.HumanDate($Bill['time_due']).'<br>';
+      if(($Bill['time_from'] != '0000-00-00 00:00:00') and ($Bill['time_to'] != '0000-00-00 00:00:00'))
+        $Output .= 'Fakturované období: '.HumanDate($Bill['time_from']).' - '.HumanDate($Bill['time_to']).'<br>';
+      $Output .= '</td></tr>'.
+      '<tr><td colspan="2">'.
+      '<hr>'.
+      '<br>'.
+      '<table border="0" width="100%">'.
+      '<tr><th align="left">Dodávka</th><th align="right">Množství</th><th align="right">Cena/MJ</th><th align="right">Celkem</th></tr>'.
+      '<tr><td colspan="4"><hr></td></tr>';
+    
+    $Total = 0;
+    foreach($Dodavka as $Polozka)
+    {
+      $Output .= '<tr><td>'.$Polozka['description'].'</td><td align="right">'.$Polozka['quantity'].'</td><td align="right">'.$Polozka['price'].'&nbsp;Kč</td><td align="right">'.($Polozka['quantity'] * $Polozka['price']).'&nbsp;Kč</td></tr>';
+      $Total += ($Polozka['quantity'] * $Polozka['price']);
+    }
+    $Output .= '<tr><th colspan="3" align="left">Celkem</th><th align="right">'.$Total.'&nbsp;Kč</th></tr>';
+    $Output .= '</table>'.
+      '</td></tr>'.
+      '<tr><td colspan="2"><hr></td></tr>'.
+      '</table>';
+
+    return($Output);
+  }
+
   function CreateBill($UserId, $Items, $TimeFrom, $TimeTo, $BillCode)
   {

@@ -1 +1 @@
 config.php
 php_script_error.log
+statistic
+