From abc64a997eeacdc95988296889754d708aa97cad Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 27 Dec 2003 08:23:38 +0000 Subject: package reports by agent --- httemplate/index.html | 2 +- httemplate/search/cust_pkg.cgi | 6 ++++ httemplate/search/cust_pkg.html | 46 ------------------------- httemplate/search/cust_pkg_report.cgi | 63 +++++++++++++++++++++++++++++++++++ 4 files changed, 70 insertions(+), 47 deletions(-) delete mode 100755 httemplate/search/cust_pkg.html create mode 100755 httemplate/search/cust_pkg_report.cgi (limited to 'httemplate') diff --git a/httemplate/index.html b/httemplate/index.html index d863f3f3e..d024de0bf 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -56,7 +56,7 @@
-
View pending credit card batch

Packages (by next bill date range) +
View pending credit card batch

Packages (by next bill date range)

Invoice reports

Invoice event errors (failed credit cards) diff --git a/httemplate/search/cust_pkg.cgi b/httemplate/search/cust_pkg.cgi index 3c3e17864..c2f6272c4 100755 --- a/httemplate/search/cust_pkg.cgi +++ b/httemplate/search/cust_pkg.cgi @@ -35,6 +35,12 @@ if ( $cgi->param('magic') && $cgi->param('magic') eq 'bill' ) { $range .= ( $range ? 'AND ' : ' WHERE ' ). '( cancel IS NULL OR cancel = 0 )'; + if ( $cgi->param('agentnum') =~ /^(\d+)$/ and $1 ) { + $range .= ( $range ? 'AND ' : ' WHERE ' ). + "$1 = ( SELECT agentnum FROM cust_main". + " WHERE cust_main.custnum = cust_pkg.custnum )"; + } + #false laziness with below my $statement = "SELECT COUNT(*) FROM cust_pkg $range"; warn $statement; diff --git a/httemplate/search/cust_pkg.html b/httemplate/search/cust_pkg.html deleted file mode 100755 index 0dad83a2a..000000000 --- a/httemplate/search/cust_pkg.html +++ /dev/null @@ -1,46 +0,0 @@ - - - Packages - - - - - - -

Packages

- - - - - diff --git a/httemplate/search/cust_pkg_report.cgi b/httemplate/search/cust_pkg_report.cgi new file mode 100755 index 000000000..b31674540 --- /dev/null +++ b/httemplate/search/cust_pkg_report.cgi @@ -0,0 +1,63 @@ + + + Packages + + + + + + +

Packages

+ + + + + -- cgit v1.2.1

From:	m/d/y
To:	m/d/y

From:	m/d/y
To:	m/d/y
Agent: