diff options
| author | ivan <ivan> | 2010-06-17 02:08:53 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2010-06-17 02:08:53 +0000 |
| commit | 8966833a87b9a002c9d72c56832e35b55628dc81 (patch) | |
| tree | 5ebe5128d453eb940580b1876b2218d1db8d87be /httemplate/browse/part_pkg.cgi | |
| parent | 259921ee5e89a68fc79b2a358643c558ebb4fdaa (diff) | |
Add "View customers of all agents" access rights, RT#7010
Diffstat (limited to 'httemplate/browse/part_pkg.cgi')
| -rwxr-xr-x | httemplate/browse/part_pkg.cgi | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/browse/part_pkg.cgi b/httemplate/browse/part_pkg.cgi index e226ce13e..42eb5dfcb 100755 --- a/httemplate/browse/part_pkg.cgi +++ b/httemplate/browse/part_pkg.cgi @@ -84,11 +84,11 @@ my $extra_sql = scalar(@where) join( 'AND ', @where) : ''; -my $agentnums = join(',', $curuser->agentnums); +my $agentnums_sql = $curuser->agentnums_sql( 'table'=>'cust_main' ); my $count_cust_pkg = " SELECT COUNT(*) FROM cust_pkg LEFT JOIN cust_main USING ( custnum ) WHERE cust_pkg.pkgpart = part_pkg.pkgpart - AND cust_main.agentnum IN ($agentnums) + AND $agentnums_sql "; $select = " |