X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep106.php;h=42a02083828a5930dcb30c8872d7beb66ea119dd;hb=55bddc51260dc87dba6e3217e2117cc760346306;hp=bc3889359764e2428ed19688cd4b290f9f3e0ced;hpb=d567a10b7925c8bb97c734e213d6651a979af29d;p=fa-stable.git diff --git a/reporting/rep106.php b/reporting/rep106.php index bc388935..42a02083 100644 --- a/reporting/rep106.php +++ b/reporting/rep106.php @@ -9,12 +9,12 @@ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the License here . ***********************************************************************/ -$page_security = 2; +$page_security = 'SA_SALESMANREP'; // ---------------------------------------------------------------- // $ Revision: 2.0 $ // Creator: Joe Hunt // date_: 2005-05-19 -// Title: Order Status List +// Title: Salesman Report // ---------------------------------------------------------------- $path_to_root=".."; @@ -45,7 +45,7 @@ function GetSalesmanTrans($from, $to) AND ".TB_PREF."sales_orders.branch_code=".TB_PREF."cust_branch.branch_code AND ".TB_PREF."cust_branch.salesman=".TB_PREF."salesman.salesman_code AND ".TB_PREF."debtor_trans.debtor_no=".TB_PREF."debtors_master.debtor_no - AND (".TB_PREF."debtor_trans.type=10 OR ".TB_PREF."debtor_trans.type=11) + AND (".TB_PREF."debtor_trans.type=".ST_SALESINVOICE." OR ".TB_PREF."debtor_trans.type=".ST_CUSTCREDIT.") AND ".TB_PREF."debtor_trans.tran_date>='$fromdate' AND ".TB_PREF."debtor_trans.tran_date<='$todate' ORDER BY ".TB_PREF."salesman.salesman_code, ".TB_PREF."debtor_trans.tran_date"; @@ -74,7 +74,7 @@ function print_salesman_list() else $sum = _("Yes"); - $dec = user_qty_dec(); + $dec = user_price_dec(); $cols = array(0, 60, 150, 220, 325, 385, 450, 515); @@ -97,7 +97,7 @@ function print_salesman_list() $rep->Font(); $rep->Info($params, $cols, $headers, $aligns, $cols2, $headers2, $aligns2); - $rep->Header(); + $rep->NewPage(); $salesman = 0; $subtotal = $total = $subprov = $provtotal = 0; @@ -108,7 +108,7 @@ function print_salesman_list() if ($rep->row < $rep->bottomMargin + (2 * $rep->lineHeight)) { $salesman = 0; - $rep->Header(); + $rep->NewPage(); } $rep->NewLine(0, 2, false, $salesman); if ($salesman != $myrow['salesman_code']) @@ -155,7 +155,7 @@ function print_salesman_list() if ($rep->row < $rep->bottomMargin + (2 * $rep->lineHeight)) { $salesman = 0; - $rep->Header(); + $rep->NewPage(); } } $subtotal += $amt;