X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Fincludes%2Freporting.inc;h=75b8d76f30ebd6f389c00c072dd20d9bb6d96048;hb=7d866f768b8be95c82ab0664721da9ca09c7604f;hp=15cfee6a07931c7e36c0c75a3840afbf05764d83;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/reporting/includes/reporting.inc b/reporting/includes/reporting.inc index 15cfee6a..75b8d76f 100644 --- a/reporting/includes/reporting.inc +++ b/reporting/includes/reporting.inc @@ -1,42 +1,104 @@ $_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 "" . _($link_text) . ""; + +// 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 = ""; + + switch ($type_no) + { + case systypes::sales_order() : + $action = "$path_to_root/reporting/rep109.php"; + $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"; + $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"; + $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"; + $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 = "
"; + foreach ($ar as $key => $value) + { + $st .= ""; + } + $st .= "
\n"; + $st .= "\n"; -function getHiddenFieldScript() { - $ar = Array('COMPANY','LANG','FORMID','FORMTYPE','TRANSNO','TRANSTYPE','REF','PARAM1','PARAM2'); - foreach ($ar as $value) $st.= ""; - - $st .= " - - "; - - $st = "
" . $st . "
"; - return $st; + echo $st; } -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}';"; - } - $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; +// 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 +// 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, $type_no=0) +{ + if ($link) + return "$link_text"; + else + 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