Added print document options in inquiries.
[fa-stable.git] / reporting / includes / reporting.inc
index f1da464eaabb1e333b21d9a8ea0d2d94d97b317a..75b8d76f30ebd6f389c00c072dd20d9bb6d96048 100644 (file)
 <?php
 
-// Put this on the page only once, e.g. print_hidden_script(systypes::sales_order());
+// Put this on the page only once an outside a form, e.g. print_hidden_script(systypes::sales_order());
+// If you have both invoices and credit notes on the same page use 10 or 11. Is doesn't matter which.
 
 function print_hidden_script($type_no)
 {
        global $path_to_root;
        include_once($path_to_root . "/includes/types.inc");
        $action = "";
-       $_POST['PARAM_0'] = $_POST['PARAM_1'] = 0; // the document no. is updated in print_document_link().
 
        switch ($type_no)
        {
                case systypes::sales_order() :
                        $action = "$path_to_root/reporting/rep109.php";
-                       $_POST['PARAM_2'] = ""; // currency
-                       $_POST['PARAM_3'] = ""; // bank account
-                       $_POST['PARAM_4'] = 0; // email
-                       $_POST['PARAM_5'] = 0; // quote
-                       $_POST['PARAM_6'] = ""; // comments
-                       $params = 7;
+                       $ar = array(
+                               'PARAM_0' => 0,         // from - these values are updated in print_document_link()
+                               'PARAM_1' => 0,         // to
+                               'PARAM_2' => "",        // currency
+                               'PARAM_3' => get_first_bank_account(),  // bank account
+                               'PARAM_4' => 0,         // email
+                               'PARAM_5' => 0,         // quote
+                               'PARAM_6' => "");       // comments
                        break;
                case systypes::cust_dispatch() :
                        $action = "$path_to_root/reporting/rep110.php";
-                       $_POST['PARAM_2'] = 0; // email
-                       $_POST['PARAM_3'] = ""; // comments
-                       $params = 4;
+                       $ar = array(
+                               'PARAM_0' => 0,         // from - these values are updated in print_document_link()
+                               'PARAM_1' => 0,         // to
+                               'PARAM_2' => 0,         // email
+                               'PARAM_3' => "");       // comments
                        break;
                case 10 : // Sales Invoice
                case 11 : // Customer Credit Note
                        $action = "$path_to_root/reporting/rep107.php";
-                       $_POST['PARAM_2'] = ""; // currency
-                       $_POST['PARAM_3'] = ""; // bank account
-                       $_POST['PARAM_4'] = 0; // email
-                       $_POST['PARAM_5'] = ""; // paylink
-                       $_POST['PARAM_6'] = ""; // comments
-                       $params = 7;
+                       $ar = array(
+                               'PARAM_0' => 0,         // from - these values are updated in print_document_link()
+                               'PARAM_1' => 0,         // to
+                               'PARAM_2' => "",        // currency
+                               'PARAM_3' => get_first_bank_account(),  // bank account
+                               'PARAM_4' => 0,         // email
+                               'PARAM_5' => "",        // paylink
+                               'PARAM_6' => "",        // comments
+                               'PARAM_7' => 0);        // IV or CN
                        break;
                case systypes::po() :
                        $action = "$path_to_root/reporting/rep209.php";
-                       $_POST['PARAM_2'] = ""; // currency
-                       $_POST['PARAM_3'] = ""; // bank account
-                       $_POST['PARAM_4'] = 0; // email
-                       $_POST['PARAM_5'] = ""; // comments
-                       $params = 6;
+                       $ar = array(
+                               'PARAM_0' => 0,         // from - these values are updated in print_document_link()
+                               'PARAM_1' => 0,         // to
+                               'PARAM_2' => "",        // currency
+                               'PARAM_3' => get_first_bank_account(),  // bank account
+                               'PARAM_4' => 0,         // email
+                               'PARAM_5' => "");       // comments
                        break;
        }
-       $st = "";
-       for ($i = 0; $i < $params; $i++)
+       $st = "<form method='post' name='pdf_form' action='$action'>";
+       foreach ($ar as $key => $value)
        {
-               $st .= "<input type='hidden' name='PARAM_".$i."' value='".$_POST['PARAM_'.$i]."' />";
+               $st .= "<input type='hidden' name='$key' value='$value' />";
        }
-       $st = "<form method='post' name='pdf_form' action='$action'>" . $st . "</form>\n";
+       $st .= "</form>\n";
+       $st .= "<script type='text/javascript'>
+<!--
+function printDocument(docno, typeno) {
+  document.pdf_form.PARAM_0.value = document.pdf_form.PARAM_1.value = docno;
+  if (typeno == 10 || typeno == 11)
+       document.pdf_form.PARAM_7.value = typeno;
+  window.open('','REP_WINDOW','toolbar=no,scrollbar=no,resizable=yes,menubar=no');
+  document.pdf_form.target='REP_WINDOW';
+  document.pdf_form.submit();
+}
+-->
+</script>\n";
+
        echo $st;
 }
 
 // Ex. label_cell(print_document_link($myrow['order_no'], _("Print")));
 // or display_note(print_document_link($order_no, _("Print this order")));
 // or if a button
-// echo "<input type='button' name='button' value='"._("Print this order")."' onclick=\"".
-//             print_document_link($order_no, "", false)."\" class='inputsubmit' />\n";
+// button("button", _("Print this order"), print_document_link($order_no, "", false))";
+// or if a button inside a TD
+// button_cell("button", _("Print this order"), print_document_link($order_no, "", false))";
+//
+// You only need full parameter list for invoices/credit notes
 
-function print_document_link($doc_no, $link_text, $link=true)
+function print_document_link($doc_no, $link_text, $link=true, $type_no=0)
 {
-       $st = "document.pdf_form.PARAM_0.value = '$doc_no';";
-       $st .= "document.pdf_form.PARAM_1.value = '$doc_no';";
-       $st .= "window.open('','REP_WINDOW','toolbar=no,scrollbar=no,resizable=yes,menubar=no');
-               document.pdf_form.target='REP_WINDOW';
-               document.pdf_form.submit();\n";
        if ($link)
-               return "<a href=\"javascript:$st\">" . $link_text . "</a>";
+               return "<a href=\"javascript:printDocument('$doc_no', '$type_no');\">$link_text</a>";
        else
-               return "javascript:$st";
+               return "javascript:printDocument('$doc_no', '$type_no');";
+}
+
+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