X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep106.php;h=1274a8df9cb94b4018c63e7f1940b2cafbb9ef3b;hb=7e6e0807990447d2977b970c3a0fd28dc9250194;hp=c8a5538533278bb0ad3273d03b28881915256d8d;hpb=40da959b32eb27fcb0422207a284eed13cc27d7e;p=fa-stable.git

diff --git a/reporting/rep106.php b/reporting/rep106.php
index c8a55385..1274a8df 100644
--- a/reporting/rep106.php
+++ b/reporting/rep106.php
@@ -35,20 +35,27 @@ function GetSalesmanTrans($from, $to)
 	$fromdate = date2sql($from);
 	$todate = date2sql($to);
 
-	$sql = "SELECT DISTINCT ".TB_PREF."debtor_trans.*,
-		ov_amount+ov_discount AS InvoiceTotal,
-		".TB_PREF."debtors_master.name AS DebtorName, ".TB_PREF."debtors_master.curr_code, ".TB_PREF."cust_branch.br_name,
-		".TB_PREF."cust_branch.contact_name, ".TB_PREF."salesman.*
-		FROM ".TB_PREF."debtor_trans, ".TB_PREF."debtors_master, ".TB_PREF."sales_orders, ".TB_PREF."cust_branch,
-			".TB_PREF."salesman
-		WHERE ".TB_PREF."sales_orders.order_no=".TB_PREF."debtor_trans.order_
-		    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=".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";
+	$sql = "SELECT DISTINCT trans.*,
+			ov_amount+ov_discount AS InvoiceTotal,
+			cust.name AS DebtorName,
+			cust.curr_code,
+			branch.br_name,
+			sorder.customer_ref,
+			salesman.*
+		FROM ".TB_PREF."debtor_trans trans,
+			 ".TB_PREF."debtors_master cust,
+			 ".TB_PREF."sales_orders sorder,
+			 ".TB_PREF."cust_branch branch,
+			".TB_PREF."salesman salesman
+		WHERE sorder.order_no=trans.order_
+		    AND sorder.branch_code=branch.branch_code
+		    AND sorder.trans_type = ".ST_SALESORDER."
+		    AND branch.salesman=salesman.salesman_code
+		    AND trans.debtor_no=cust.debtor_no
+		    AND (trans.type=".ST_SALESINVOICE." OR trans.type=".ST_CUSTCREDIT.")
+		    AND trans.tran_date>='$fromdate'
+		    AND trans.tran_date<='$todate'
+		ORDER BY salesman.salesman_code, trans.tran_date";
 
 	return db_query($sql, "Error getting order details");
 }
@@ -137,16 +144,20 @@ function print_salesman_list()
 		}
 		$rate = $myrow['rate'];
 		$amt = $myrow['InvoiceTotal'] * $rate;
-		if ($subprov > $myrow['break_pt'] && $myrow['provision2'] != 0)
-			$prov = $myrow['provision2'] * $amt / 100;
-		else
+		if ($myrow['provision2'] == 0)
 			$prov = $myrow['provision'] * $amt / 100;
+		else {
+			$amt1 = min($amt, max(0, $myrow['break_pt']-$subtotal));
+			$amt2 = $amt - $amt1;
+
+			$prov = $amt1*$myrow['provision']/100 + $amt2*$myrow['provision2']/100;
+		}
 		if (!$summary)
 		{
 			$rep->TextCol(0, 1,	$myrow['trans_no']);
 			$rep->TextCol(1, 2,	$myrow['DebtorName']);
 			$rep->TextCol(2, 3,	$myrow['br_name']);
-			$rep->TextCol(3, 4,	$myrow['contact_name']);
+			$rep->TextCol(3, 4,	$myrow['customer_ref']);
 			$rep->DateCol(4, 5,	$myrow['tran_date'], true);
 			$rep->AmountCol(5, 6, $amt, $dec);
 			$rep->AmountCol(6, 7, $prov, $dec);
@@ -177,4 +188,3 @@ function print_salesman_list()
 	$rep->End();
 }
 
-?>
\ No newline at end of file