diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2018-10-24 10:55:50 -0400 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2018-10-24 10:55:50 -0400 |
| commit | ec5b34c097718b91d98d90fece500864e50892b9 (patch) | |
| tree | 95f75699c5aa7182bc8fe635d083b5f73ea6c166 | |
| parent | 25f16a9668fba4e652372228ca55789ce50e2fa8 (diff) | |
RT# 76722 - added option to search on tags not selected in advanced customer report
| -rw-r--r-- | FS/FS/cust_main/Search.pm | 3 | ||||
| -rwxr-xr-x | httemplate/search/report_cust_main.html | 4 |
2 files changed, 5 insertions, 2 deletions
diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index bfaf621..3e77704 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -1016,8 +1016,9 @@ sub search { if ( @tagnums ) { if ( $params->{'all_tags'} ) { + my $exists = $params->{'all_tags'} eq 'all' ? 'exists' : 'not exists'; foreach ( @tagnums ) { - push @where, 'exists(select 1 from cust_tag where '. + push @where, $exists.'(select 1 from cust_tag where '. 'cust_tag.custnum = cust_main.custnum and tagnum = '. $_ . ')'; } diff --git a/httemplate/search/report_cust_main.html b/httemplate/search/report_cust_main.html index 0a67262..da2f1a4 100755 --- a/httemplate/search/report_cust_main.html +++ b/httemplate/search/report_cust_main.html @@ -102,7 +102,9 @@ <DIV STYLE="display:inline-block; vertical-align:baseline"> <INPUT TYPE="radio" NAME="all_tags" VALUE="0" CHECKED> Any of these <BR> - <INPUT TYPE="radio" NAME="all_tags" VALUE="1"> All of these + <INPUT TYPE="radio" NAME="all_tags" VALUE="all"> All of these + <BR> + <INPUT TYPE="radio" NAME="all_tags" VALUE="none"> None of these </DIV> </TD> </TR> |