Added optional popup for pdf reports display.
[fa-stable.git] / reporting / includes / reporting.inc
index 15cfee6a07931c7e36c0c75a3840afbf05764d83..f57739d6412f0934d8abf9dbd0ed831e53d29362 100644 (file)
@@ -1,42 +1,93 @@
 <?php
-function printTransaction($link_text, $form_id, $form_type, $trans_type, $trans_no, $ref, $param1, $param2) {
-       $ar = array(
-                               'COMPANY'       => $_SESSION["wa_current_user"]->company,
-                               'FORMID'        => $form_id,
-                               'FORMTYPE'      => $form_type,
-                               'TRANSNO'       => $trans_no,
-                               'TRANSTYPE'     => $trans_type,
-                               'REF'           => $ref,
-                               'PARAM1'        => $param1,
-                               'PARAM2'        => $param2
-                               );      
-       $pdf_href =     getPDFOpenScript($link_text, $ar);
-       return "<a href=\"javascript:$pdf_href\">" . _($link_text) . "</a>";    
-}
+// Link to printing single document with bulk report template file.
+// Ex. label_cell(print_document_link($myrow['order_no'], _("Print")), $type);
+// or display_note(print_document_link($order_no, _("Print this order")));
+// You only need full parameter list for invoices/credit notes
 
-function getHiddenFieldScript() {
-       $ar = Array('COMPANY','LANG','FORMID','FORMTYPE','TRANSNO','TRANSTYPE','REF','PARAM1','PARAM2');
-       foreach ($ar as $value) $st.= "<input type='hidden' name='$value'>";
-       
-       $st .= "<input type='hidden' name='QTY_DEC'     value='" . user_qty_dec()        . "'>
-                       <input type='hidden' name='PRICE_DEC'   value='" . user_price_dec()      . "'>
-                       <input type='hidden' name='PER_DEC'     value='" . user_percent_dec(). "'>";    
+function print_document_link($doc_no, $link_text, $link=true, $type_no)
+{
+       global $path_to_root;
+       include_once($path_to_root . "/includes/types.inc");
+
+       $url = $path_to_root.'/reporting/prn_redirect.php?';
+
+       switch ($type_no)
+       {
+               case systypes::sales_order() :
+                       $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' => 0, 
+                               'PARAM_5' => 0, 
+                               'PARAM_6' => "");
+                       break;
+               case systypes::cust_dispatch() :
+                       $rep = 110;
+                       // from, to, email, comments
+                       $ar = array(
+                               'PARAM_0' => $doc_no, 
+                               'PARAM_1' => $doc_no, 
+                               'PARAM_2' => 0, 
+                               'PARAM_3' => "");
+                       break;
+               case 10 : // Sales Invoice
+               case 11 : // 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' => 0, 
+                               'PARAM_5' => "",
+                               'PARAM_6' => "", 
+                               'PARAM_7' => $type_no);
+                       break;
+               case systypes::po() :
+                       $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' => 0, 
+                               'PARAM_5' => "");
+                       break;
+//             default: $ar = array();
+       }
        
-       $st = "<form method='post' name='pdf_form'>" . $st . "</form>"; 
-       return $st;
+       return print_link($link_text, $rep, $ar);
 }
+//
+//     Universal link to any kind of report.
+//
+function print_link($link_text, $rep, $pars = array(), $dir = '')
+{
+       global $path_to_root, $pdf_debug;
+
+       $url = $dir == '' ?  $path_to_root.'/reporting/prn_redirect.php?' : $dir;
 
-function getPDFOpenScript($link_text, $ar_params) {
-       $st = "document.pdf_form.LANG.value='" . $_SESSION['language']->code . "';";
-       foreach ($ar_params as $key => $value) {
-               $st .= "document.pdf_form.{$key}.value = '{$value}';";
+       foreach($pars as $par => $val) {
+               $pars[$par] = "$par=".urlencode($val);
        }
-       $st.= "window.open('','REP_WINDOW','toolbar=no,scrollbar=no,resizable=yes,menubar=no');";       
-       $st.= "document.pdf_form.target='REP_WINDOW';";
-       $st.= "document.pdf_form.action= '" . C_JSP_ROOT . "/reporting/gen_pdf_form.jsp';";
-       $st.= "document.pdf_form.submit();";
-       
-       return $st;
+       $pars[] = 'REP_ID='.urlencode($rep);
+       $url .= implode ('&', $pars);
+       $class = $pdf_debug ? '' : "class='printlink'";
+       return "<a $class target='_blank' href='$url'>$link_text</a>";
 }
 
+function get_first_bank_account()
+{
+       $sql = "SELECT ".TB_PREF."bank_accounts.account_code 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