diff options
author | Christopher Burger <burgerc@freeside.biz> | 2018-04-27 13:48:58 -0400 |
---|---|---|
committer | Christopher Burger <burgerc@freeside.biz> | 2018-04-27 13:48:58 -0400 |
commit | ae9a208fa96fca49f1eef01519353a4c9f54d15f (patch) | |
tree | 039db89f357e1e959a5502cd41557650f0da84c7 /httemplate | |
parent | 8309e857e05c33d65edee6bfe18a60db5300e310 (diff) |
RT# 77160 - fixed report error when multiple canceled packages had they same datetime
Diffstat (limited to 'httemplate')
-rw-r--r-- | httemplate/search/cust_timespan.html | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/search/cust_timespan.html b/httemplate/search/cust_timespan.html index a380b78..f568425 100644 --- a/httemplate/search/cust_timespan.html +++ b/httemplate/search/cust_timespan.html @@ -88,7 +88,7 @@ my $cancel_date = 'select max(cancel) from cust_pkg where cust_pkg.custnum = cus my $cancel_reason = 'select reason.reason from cust_pkg left join cust_pkg_reason on (cust_pkg.pkgnum = cust_pkg_reason.pkgnum) left join reason on (cust_pkg_reason.reasonnum = reason.reasonnum) - where cust_pkg.custnum = cust_main.custnum and cust_pkg_reason.date = ('.$cancel_date.') + where cust_pkg.custnum = cust_main.custnum and cust_pkg_reason.date = ('.$cancel_date.') limit 1 '; my @header = ( '#', 'Name', 'Address', 'Phone', 'Email', 'Active Date', 'Cancelled Date', 'Reason', 'Active Days' ); |