[Web-erp-svn] SF.net SVN: web-erp:[6545] trunk/PrintCustStatements.php

[<ex...@us...>]

Revision: 6545
          http://sourceforge.net/p/web-erp/reponame/6545
Author:   exsonqu
Date:     2014-01-19 15:35:37 +0000 (Sun, 19 Jan 2014)
Log Message:
-----------
19/01/14 Exson: Add sales man login control and modify the PDF to download to harmony with other files and solve backward failure problem in PrintCustStatements.php.

Modified Paths:
--------------
    trunk/PrintCustStatements.php

Modified: trunk/PrintCustStatements.php
===================================================================
--- trunk/PrintCustStatements.php	2014-01-19 01:19:06 UTC (rev 6544)
+++ trunk/PrintCustStatements.php	2014-01-19 15:35:37 UTC (rev 6545)
@@ -104,9 +104,14 @@
 				FROM debtortrans INNER JOIN systypes
 					ON debtortrans.type=systypes.typeid
 				WHERE debtortrans.debtorno='" . $StmtHeader['debtorno'] . "'
-				AND debtortrans.settled=0
-				ORDER BY debtortrans.id";
+				AND debtortrans.settled=0";
+	
+		if ($_SESSION['SalesmanLogin'] != '') {
+			$sql .= " AND debtortrans.salesperson='" . $_SESSION['SalesmanLogin'] . "'";
+		}
 
+		$sql .= " ORDER BY debtortrans.id";
+
 		$OstdgTrans=DB_query($sql,$db, $ErrMsg);
 
 	   	$NumberOfRecordsReturned = DB_num_rows($OstdgTrans);
@@ -129,9 +134,14 @@
 						WHERE custallocns.datealloc >='" .
 							Date('Y-m-d',Mktime(0,0,0,Date('m')-1,Date('d'),Date('y'))) . "'
 						AND debtortrans.debtorno='" . $StmtHeader['debtorno'] . "'
-						AND debtortrans.settled=1
-						ORDER BY debtortrans.id";
+						AND debtortrans.settled=1";
 
+			if ($_SESSION['SalesmanLogin'] != '') {
+				$sql .= " AND debtortrans.salesperson='" . $_SESSION['SalesmanLogin'] . "'";
+			}
+
+			$sql .= " ORDER BY debtortrans.id";
+
 			$SetldTrans=DB_query($sql,$db, $ErrMsg);
 			$NumberOfRecordsReturned += DB_num_rows($SetldTrans);
 
@@ -264,7 +274,7 @@
 		/* head up a new statement/credit note page */
 			$PageNumber++;
 			$pdf->newPage();
-		include ('includes/PDFStatementPageHeader.inc');
+			include ('includes/PDFStatementPageHeader.inc');
 		}
 			/*Now figure out the aged analysis for the customer under review */
 
@@ -325,8 +335,13 @@
 					INNER JOIN debtortrans
 						ON debtorsmaster.debtorno = debtortrans.debtorno
 					WHERE
-						debtorsmaster.debtorno = '" . $StmtHeader['debtorno'] . "'
-					GROUP BY
+						debtorsmaster.debtorno = '" . $StmtHeader['debtorno'] . "'";
+
+			if ($_SESSION['SalesmanLogin'] != '') {
+				$sql .= " AND debtortrans.salesperson='" . $_SESSION['SalesmanLogin'] . "'";
+			}
+
+			$sql .= " GROUP BY
 						debtorsmaster.name,
 						currencies.currency,
 						paymentterms.terms,
@@ -396,7 +411,7 @@
 
 	if (isset($pdf)){
 
-        $pdf->OutputI($_SESSION['DatabaseName'] . '_CustStatements_' . date('Y-m-d') . '.pdf');
+        $pdf->OutputD($_SESSION['DatabaseName'] . '_CustStatements_' . date('Y-m-d') . '.pdf');
         $pdf->__destruct();
 
 	} else {