diff options
author | ivan <ivan> | 2003-12-27 08:24:13 +0000 |
---|---|---|
committer | ivan <ivan> | 2003-12-27 08:24:13 +0000 |
commit | 0e9d0175f15e1de80c773e0f8b654340295ed025 (patch) | |
tree | d6dbb09ee5e9ae5cea908836c98f696c4fccca00 /httemplate/search/cust_pkg.cgi | |
parent | c7a9fb2edba3264683b8f6195f7dba53210af0b2 (diff) |
package reports by agent
Diffstat (limited to 'httemplate/search/cust_pkg.cgi')
-rwxr-xr-x | httemplate/search/cust_pkg.cgi | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/httemplate/search/cust_pkg.cgi b/httemplate/search/cust_pkg.cgi index 74f584084..2e9dc5a22 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; |