diff options
| author | mark <mark> | 2010-10-25 22:22:42 +0000 |
|---|---|---|
| committer | mark <mark> | 2010-10-25 22:22:42 +0000 |
| commit | 0a51b87d75f8c93de863f729ef1ca568ca227e32 (patch) | |
| tree | 17305873562562672fa2239fff869fc38b2fafa7 /httemplate/search/cust_svc.html | |
| parent | 716be4fdacc0995d54a0df8c77268606f23fa768 (diff) | |
summary display of bulk packages with many services, RT#9821
Diffstat (limited to 'httemplate/search/cust_svc.html')
| -rw-r--r-- | httemplate/search/cust_svc.html | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/httemplate/search/cust_svc.html b/httemplate/search/cust_svc.html index 2c17561f2..61bfc7091 100644 --- a/httemplate/search/cust_svc.html +++ b/httemplate/search/cust_svc.html @@ -93,6 +93,10 @@ if ( length( $cgi->param('search_svc') ) ) { errorpage("No search term specified"); } +if ( $cgi->param('pkgnum') =~ /^(\d+)$/ ) { + push @extra_sql, "cust_svc.pkgnum = $1"; +} + #here is the agent virtualization push @extra_sql, $FS::CurrentUser::CurrentUser->agentnums_sql( 'null_right' => 'View/link unlinked services' @@ -113,6 +117,8 @@ my $sql_query = { 'extra_sql' => "$extra_sql $orderby", }; +warn Dumper($sql_query)."\n"; + my $count_query = "SELECT COUNT(*) FROM cust_svc $addl_from $extra_sql"; my $link = sub { |