Added a date column and combined the # and View column in 'View / Print Transactions.

[fa-stable.git] / reporting / includes / reporting.inc

diff --git a/reporting/includes/reporting.inc b/reporting/includes/reporting.inc
index 7fa0c122ad1d9754951e5be3be79da37f35d6f5b..9491c0c04b799b85bf6aa95f22e2a43e0f74ac3d 100644 (file)
--- a/reporting/includes/reporting.inc
+++ b/reporting/includes/reporting.inc
@@ -15,7 +15,7 @@
 // You only need full parameter list for invoices/credit notes
 
 function print_document_link($doc_no, $link_text, $link=true, $type_no, 
-       $icon=false, $class='printlink', $id='', $email=0)
+       $icon=false, $class='printlink', $id='', $email=0, $extra=0)
 {
        global $path_to_root;
        include_once($path_to_root . "/includes/types.inc");
@@ -24,62 +24,87 @@ function print_document_link($doc_no, $link_text, $link=true, $type_no,
 
        switch ($type_no)
        {
-               case systypes::sales_quotation() :
+               case ST_SALESQUOTE :
                        $rep = 111;
                        // from, to, currency, bank acc, email, quote, comments
                        $ar = array(
                                'PARAM_0' => $doc_no, 
                                'PARAM_1' => $doc_no, 
-                               'PARAM_2' => "", 
-                               'PARAM_3' => get_first_bank_account(), 
-                               'PARAM_4' => $email, 
-                               'PARAM_5' => "");
+                               'PARAM_2' => '', 
+                               'PARAM_3' => $email, 
+                               'PARAM_4' => '');
                        break;
-               case systypes::sales_order() :
+               case ST_SALESORDER :
                        $rep = 109;
                        // from, to, currency, bank acc, email, quote, comments
                        $ar = array(
                                'PARAM_0' => $doc_no, 
                                'PARAM_1' => $doc_no, 
-                               'PARAM_2' => "", 
-                               'PARAM_3' => get_first_bank_account(), 
-                               'PARAM_4' => $email, 
-                               'PARAM_5' => 0, 
-                               'PARAM_6' => "");
+                               'PARAM_2' => '', 
+                               'PARAM_3' => $email, 
+                               'PARAM_4' => 0, 
+                               'PARAM_5' => '');
                        break;
-               case systypes::cust_dispatch() :
+               case ST_CUSTDELIVERY :
                        $rep = 110;
                        // from, to, email, comments
                        $ar = array(
                                'PARAM_0' => $doc_no, 
                                'PARAM_1' => $doc_no, 
-                               'PARAM_2' => $email, 
-                               'PARAM_3' => "");
+                               'PARAM_2' => $email,
+                               'PARAM_3' => $extra);
                        break;
-               case 10 : // Sales Invoice
-               case 11 : // Customer Credit Note
+               case ST_SALESINVOICE : // Sales Invoice
+               case ST_CUSTCREDIT : // Customer Credit Note
                        $rep = 107;
                        // from, to, currency, bank acc, email, paylink, comments, type
                        $ar = array(
                                'PARAM_0' => $doc_no, 
                                'PARAM_1' => $doc_no, 
-                               'PARAM_2' => "", 
-                               'PARAM_3' => get_first_bank_account(), 
-                               'PARAM_4' => $email, 
-                               'PARAM_5' => "",
-                               'PARAM_6' => "", 
-                               'PARAM_7' => $type_no);
+                               'PARAM_2' => '', 
+                               'PARAM_3' => $email, 
+                               'PARAM_4' => '',
+                               'PARAM_5' => '', 
+                               'PARAM_6' => $type_no);
                        break;
-               case systypes::po() :
+               case ST_PURCHORDER :
                        $rep = 209;
                        // from, to, currency, bank acc, email, comments
                        $ar = array(
                                'PARAM_0' => $doc_no, 
                                'PARAM_1' => $doc_no, 
-                               'PARAM_2' => "", 
-                               'PARAM_3' => get_first_bank_account(), 
-                               'PARAM_4' => $email, 
-                               'PARAM_5' => "");
+                               'PARAM_2' => '', 
+                               'PARAM_3' => $email, 
+                               'PARAM_4' => '');
+                       break;
+               case ST_CUSTPAYMENT :
+                       $rep = 112;
+                       // from, to, currency, bank acc, email, comments
+                       $ar = array(
+                               'PARAM_0' => $doc_no, 
+                               'PARAM_1' => $doc_no, 
+                               'PARAM_2' => '', 
+                               'PARAM_4' => '');
+                       break;
+               case ST_SUPPAYMENT :
+                       $rep = 210;
+                       // from, to, currency, bank acc, email, comments
+                       $ar = array(
+                               'PARAM_0' => $doc_no, 
+                               'PARAM_1' => $doc_no, 
+                               'PARAM_2' => '', 
+                               'PARAM_3' => $email, 
+                               'PARAM_4' => '');
+                       break;
+               case ST_WORKORDER :
+                       $rep = 409;
+                       // from, to, currency, bank acc, email, comments
+                       $ar = array(
+                               'PARAM_0' => $doc_no, 
+                               'PARAM_1' => $doc_no, 
+                               'PARAM_2' => $email, 
+                               'PARAM_3' => '', 
+                               'PARAM_4' => '');
                        break;
 //             default: $ar = array();
        }
@@ -113,12 +138,4 @@ function print_link($link_text, $rep, $pars = array(), $dir = '',
        return "<a target='_blank' href='$url'$id$class $pars[1]>$pars[0]</a>";
 }
 
-function get_first_bank_account()
-{
-       $sql = "SELECT ".TB_PREF."bank_accounts.id FROM ".TB_PREF."bank_accounts, ".TB_PREF."company
-               WHERE bank_curr_code=curr_default LIMIT 0, 1";
-       $result = db_query($sql);
-       $row = db_fetch_row($result);
-       return $row[0];
-}
 ?>
\ No newline at end of file