diff options
author | Mark Wells <mark@freeside.biz> | 2016-08-26 15:44:02 -0700 |
---|---|---|
committer | Mark Wells <mark@freeside.biz> | 2016-08-26 15:44:12 -0700 |
commit | a91bf2fe8faae6f2c71e0a774218774bafce13e7 (patch) | |
tree | d89c5fde2c6b7c40c4c2b243aad3b36a2cb35675 /httemplate | |
parent | 03be36821ff5e9a61f783cfbc0d22bc5d4114a32 (diff) |
agent-virtual contract end date report, #71964
Diffstat (limited to 'httemplate')
-rw-r--r-- | httemplate/search/cust_pkg-date.html | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/httemplate/search/cust_pkg-date.html b/httemplate/search/cust_pkg-date.html index 1b93775..5bb772b 100644 --- a/httemplate/search/cust_pkg-date.html +++ b/httemplate/search/cust_pkg-date.html @@ -36,6 +36,8 @@ my @sort_fields = ( map '', @fields ); # should only ever sort by $col push @header, FS::UI::Web::cust_header($cust_fields); push @fields, \&FS::UI::Web::cust_fields; +my $agentnums_sql = $curuser->agentnums_sql('table' => 'cust_main'); + my $query = { 'table' => 'cust_pkg', 'addl_from' => FS::UI::Web::join_cust_main('cust_pkg', 'cust_pkg'), @@ -43,11 +45,13 @@ my $query = { $col => { op => '!=', value => '' }, 'cancel' => '', }, - 'order_by' => "ORDER BY $col", + 'extra_sql' => ' AND '.$agentnums_sql, + 'order_by' => "ORDER BY $col", }; my $count_query = - "SELECT COUNT(*) FROM cust_pkg WHERE $col IS NOT NULL AND cancel IS NULL"; + "SELECT COUNT(*) FROM cust_pkg JOIN cust_main USING (custnum) ". + "WHERE $col IS NOT NULL AND cancel IS NULL AND $agentnums_sql"; my $pkg_link = sub { my $self = shift; |