diff options
author | ivan <ivan> | 2004-10-26 06:33:29 +0000 |
---|---|---|
committer | ivan <ivan> | 2004-10-26 06:33:29 +0000 |
commit | 717d562bcfb691d971a01b738d0b55cdda480cf0 (patch) | |
tree | 279e37689898bb6cf71ae38b669e69f863306057 /httemplate/search/report_tax.cgi | |
parent | a060dff493749162467afbdb5ccdb7144ea0c2d5 (diff) |
and one last case with named and not named taxes in the same region, ack
Diffstat (limited to 'httemplate/search/report_tax.cgi')
-rwxr-xr-x | httemplate/search/report_tax.cgi | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/httemplate/search/report_tax.cgi b/httemplate/search/report_tax.cgi index 838335b78..aa9ed6f11 100755 --- a/httemplate/search/report_tax.cgi +++ b/httemplate/search/report_tax.cgi @@ -122,7 +122,10 @@ foreach my $r ( my @param = @base_param; #match itemdesc if necessary! - my $named_tax = $r->taxname ? 'AND itemdesc = '. dbh->quote($r->taxname) : ''; + my $named_tax = + $r->taxname + ? 'AND itemdesc = '. dbh->quote($r->taxname) + : "AND itemdesc IS NULL or itemdesc = ''"; my $x = scalar_sql($r, \@taxparam, "SELECT SUM(cust_bill_pkg.setup+cust_bill_pkg.recur) $taxwhere ". "AND pkgnum = 0 $named_tax", |