X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fview%2Fcust_main%2Fchange_history.html;h=a781c73721b5c3e130b9d3fbeb26376000a8c929;hb=f675734f1eda5b39f891a6fc8f2f29cbd2e36c35;hp=fe11b95f22f530cc4b5ebca8c2982e47bc2eec7e;hpb=da9ab0af53220f6f1cb0e4d31ce7de81dd591783;p=freeside.git diff --git a/httemplate/view/cust_main/change_history.html b/httemplate/view/cust_main/change_history.html index fe11b95f2..a781c7372 100644 --- a/httemplate/view/cust_main/change_history.html +++ b/httemplate/view/cust_main/change_history.html @@ -46,6 +46,7 @@ tie my %tables, 'Tie::IxHash', 'phone_device' => 'Phone device', 'cust_pkg_discount' => 'Discount', #? it gets provisioned anyway 'phone_avail' => 'Phone', + 'cust_tag' => 'Tag', ; my $pkg_join = "JOIN cust_pkg USING ( pkgnum )"; @@ -159,10 +160,10 @@ foreach my $table ( keys %tables ) { # but it would spoil database optimizations on this lookup my @svcnumobj = qsearch({ 'select' => 'DISTINCT svcnum', - 'hashref' => { 'custnum' => $cust_main->custnum, - 'history_date' => { op=>'>=', value=>$newer_than } }, + 'hashref' => { 'history_date' => { op=>'>=', value=>$newer_than } }, 'table' => 'h_cust_svc', 'addl_from' => 'JOIN cust_pkg USING (pkgnum)', + 'extra_sql' => ' AND custnum = '. $cust_main->custnum, }); # now grab those svcs explicitly