Changeset 133 for www/finance/bills.php

Timestamp:

Jan 10, 2009, 4:29:49 PM (15 years ago)

Author:

george

Message:

• Přidáno: Ukládání pdf faktůr jako soubory namísto databáze. * Přidáno: Používání číslených řad pro identifikaci dokumentů.

File:

• www/finance/bills.php (modified) (10 diffs)

www/finance/bills.php

@@ -5 +5 @@
 {
   var $SpecificSymbol = 1; // počítačová sít
+  var $FileFolder = 'doklady';
+  var $FileNamePrefix = 'doklad-';
 
   function GenerateBill($BillId)
@@ -30 +32 @@
       'Zděchov 208<br>'.
       '75607 Zděchov<br>'.
-      'IČO: 75904535<br>'.
+      'IČ: 75904535<br>'.
       'DIČ: CZ8303255884<br>'.
       'Účet: 218098370 / 0300<br>'.
-      'Nejsem plátce DPH<br>'.
+      'Neplátce DPH<br>'.
       '</td><td valign="top">'.
       '<strong>Odběratel:</strong><br>'.
@@ -46 +48 @@
       '<tr><td width="50%" valign="top">'.
       '<strong>Platební podmínky:</strong><br>'.
-      'Číslo dokladu: '.$Bill['id'].'<br>'.
+      'Číslo dokladu: '.$Bill['BillCode'].'<br>'.
       'Variabilní symbol: '.$User['id'].'<br>'.
       'Specifický symbol: '.$this->SpecificSymbol.'<br>'.
@@ -54 +56 @@
       '<br>'.
       'Datum vystavení: '.HumanDate($Bill['time_create']).'<br>'.
-      'Datum splatnosti: '.HumanDate($Bill['time_due']).'<br>'.
-      'Fakturované období: '.HumanDate($Bill['time_from']).' - '.HumanDate($Bill['time_to']).'<br>'.
-      '</td></tr>'.
+      '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>'.
@@ -67 +71 @@
     foreach($Dodavka as $Polozka)
     {
-      $Output .= '<tr><td>'.$Polozka['description'].'</td><td align="right">'.$Polozka['quantity'].'</td><td align="right">'.$Polozka['price'].' Kč</td><td align="right">'.($Polozka['quantity'] * $Polozka['price']).' Kč</td></tr>';
+      $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.' Kč</th></tr>';
+    $Output .= '<tr><th colspan="3" align="left">Celkem</th><th align="right">'.$Total.'&nbsp;Kč</th></tr>';
     $Output .= '</table>'.
       '</td></tr>'.
@@ -79 +83 @@
   }
 
-  function CreateBill($UserId, $Items, $TimeFrom, $TimeTo)
-  {
-    global $Database;
-  
-    $Database->insert('finance_bills', array('time_create' => TimeToMysqlDateTime(time()), 'user_id' => $UserId, 'time_from' => TimeToMysqlDateTime($TimeFrom), 'time_to' => TimeToMysqlDateTime($TimeTo), 'time_due' => TimeToMysqlDateTime($TimeFrom + 15*24*3600)));
+  function CreateBill($UserId, $Items, $TimeFrom, $TimeTo, $BillCode)
+  {
+    global $Database;
+  
+    $Database->insert('finance_bills', array('time_create' => TimeToMysqlDateTime(time()), 'user_id' => $UserId, 'time_from' => TimeToMysqlDateTime($TimeFrom), 'time_to' => TimeToMysqlDateTime($TimeTo), 'time_due' => TimeToMysqlDateTime($TimeFrom + 15*24*3600), 'BillCode' => $BillCode));
     $BillId = $Database->insert_id;
     foreach($Items as $Item)
@@ -92 +96 @@
     $PdfData = $this->HtmlToPdf($this->GenerateBill($BillId));
     //echo($PdfData);
-    $Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
+    file_put_contents($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf', $PdfData);
+    //$Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
     return($BillId);
   } 
@@ -101 +106 @@
 
     $PdfData = $this->HtmlToPdf($this->GenerateBill($BillId));
-    $Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
+    //echo($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf');
+    echo(file_put_contents($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf', $PdfData));
+    //$Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
   }
 
@@ -108 +115 @@
     global $Database;
     
-    $DbResult = $Database->select('finance_bills', 'pdf', 'id='.$BillId);
-    if($DbResult->num_rows == 1)
-    {
-      $DbRow = $DbResult->fetch_array();
+    //$DbResult = $Database->select('finance_bills', 'pdf', 'id='.$BillId);
+    //if($DbResult->num_rows == 1)
+    //{
+    //  $DbRow = $DbResult->fetch_array();
+    $FileName = $this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf';
+    if(file_exists($FileName))
+    {
       Header('Content-Type: application/pdf');
-      Header('Content-Disposition: attachment; filename="faktura-'.$BillId.'.pdf"');
-      echo($DbRow['pdf']);
+      Header('Content-Disposition: attachment; filename="'.$this->FileNamePrefix.$BillId.'.pdf"');
+      echo(file_get_contents($FileName));
     } else echo('Faktura nenalezena');
   }
@@ -123 +133 @@
     
     Header('Content-Type: application/pdf');
-    Header('Content-Disposition: attachment; filename="faktura-'.$BillId.'.pdf"');
+    Header('Content-Disposition: attachment; filename="'.$this->FileNamePrefix.$BillId.'.pdf"');
     echo($this->HtmlToPdf($this->GenerateBill($BillId)));
+  }
+
+  function HasPDFFile($BillId)
+  {
+    return(file_exists($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf'));
   }