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 {
|
