Changeset 61 for www/finance

Timestamp:

Apr 1, 2008, 8:00:13 AM (17 years ago)

Author:

george

Message:

Upraveno: Správa generování dokladů. Řazení podle jména. Možnost regenerovat PDF data.

Location:

www/finance

Files:

• bills.php (modified) (7 diffs)
• bills_manage.php (added)

www/finance/bills.php

@@ -1 +1 @@
 <?php
-include_once('../style.php');
 include('code.php');
 
@@ -41 +40 @@
       $User['psc'].' '.$User['town'].'<br>';
       if($User['ico'] != 0) $Output .= 'IČO: '.$User['ico'].'<br>';
+      if($User['dic'] != '') $Output .= 'DIČ: '.$User['dic'].'<br>';
       $Output .= 
       '</td></tr>'.
@@ -96 +96 @@
   } 
 
+  function RegeneratePDF($BillId)
+  {
+    global $Database;
+
+    $PdfData = $this->HtmlToPdf($this->GenerateBill($BillId));
+    $Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
+  }
+
   function ShowStoredBill($BillId)
   {
@@ -149 +157 @@
       while($Item = $DbResult->fetch_array())
       {
-        echo('<a href="?bill='.$Item['id'].'">faktura '.$Item['id'].'</a> <a href="?billpdf='.$Item['id'].'">PDF</a> <a href="?billpdf2='.$Item['id'].'">PDF</a><br>');
+        echo('<a href="?bill='.$Item['id'].'">faktura '.$Item['id'].'</a> <a href="?billpdf='.$Item['id'].'">Uložené PDF</a> <a href="?billpdf2='.$Item['id'].'">Generované PDF</a> <a href="?regenerate='.$Item['id'].'">Přegenerovat</a><br>');
       } 
     } else
@@ -159 +167 @@
     {
       $this->ShowGeneratedBill($_GET['billpdf2']);
+    } else
+    if(array_key_exists('regenerate', $_GET))
+    {
+      $this->RegeneratePDF($_GET['regenerate']);
     } else
     if(array_key_exists('bill', $_GET))
@@ -171 +183 @@
       ShowHeader('Faktury', 'Faktury');
       echo('Faktury:<br>');
-      $DbResult = $Database->select('users', '*, CONCAT(second_name," ", first_name)  as fullname');
+      $DbResult = $Database->select('users', '*, CONCAT(second_name," ", first_name)  as fullname', '1 ORDER BY fullname');
       while($User = $DbResult->fetch_array())
       {
@@ -182 +194 @@
 
 $InvoiceGenerator = new InvoiceGenerator;
-//$InvoiceGenerator->ShowPage();
+
 ?>