X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep204.php;h=5521c7450e40eec5673b46c28e685fbadcbc07a6;hb=3ff9ed87cb909f19c8fe3e7dfda5df79d0c01a6c;hp=120bbbc0615c9f28de30e7d5113414ffcb7d06ff;hpb=f50187b9c3095886d7fd847f635cd8763109a75e;p=fa-stable.git diff --git a/reporting/rep204.php b/reporting/rep204.php index 120bbbc0..5521c745 100644 --- a/reporting/rep204.php +++ b/reporting/rep204.php @@ -9,7 +9,7 @@ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the License here . ***********************************************************************/ -$page_security = 2; +$page_security = 'SA_SUPPLIERANALYTIC'; // ---------------------------------------------------------------- // $ Revision: 2.0 $ // Creator: Joe Hunt @@ -25,7 +25,6 @@ include_once($path_to_root . "/gl/includes/gl_db.inc"); //---------------------------------------------------------------------------------------------------- -// trial_inquiry_controls(); print_outstanding_GRN(); function getTransactions($fromsupp) @@ -49,7 +48,7 @@ function getTransactions($fromsupp) AND ".TB_PREF."grn_batch.id = ".TB_PREF."grn_items.grn_batch_id AND ".TB_PREF."grn_items.po_detail_item = ".TB_PREF."purch_order_details.po_detail_item AND qty_recd-quantity_inv <>0 "; - if ($fromsupp != reserved_words::get_all_numeric()) + if ($fromsupp != ALL_NUMERIC) $sql .= "AND ".TB_PREF."grn_batch.supplier_id ='" . $fromsupp . "' "; $sql .= "ORDER BY ".TB_PREF."grn_batch.supplier_id, ".TB_PREF."grn_batch.id"; @@ -67,17 +66,11 @@ function print_outstanding_GRN() $comments = $_POST['PARAM_1']; $destination = $_POST['PARAM_2']; if ($destination) - { include_once($path_to_root . "/reporting/includes/excel_report.inc"); - $filename = "OutstandingGRN.xml"; - } else - { include_once($path_to_root . "/reporting/includes/pdf_report.inc"); - $filename = "OutstandingGRN.pdf"; - } - if ($fromsupp == reserved_words::get_all_numeric()) + if ($fromsupp == ALL_NUMERIC) $from = _('All'); else $from = get_supplier_name($fromsupp); @@ -93,7 +86,7 @@ function print_outstanding_GRN() $params = array( 0 => $comments, 1 => array('text' => _('Supplier'), 'from' => $from, 'to' => '')); - $rep = new FrontReport(_('Outstanding GRNs Report'), $filename, user_pagesize()); + $rep = new FrontReport(_('Outstanding GRNs Report'), "OutstandingGRN", user_pagesize()); $rep->Font(); $rep->Info($params, $cols, $headers, $aligns);