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 = '.
$_ . ')';
}
<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>