diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2018-10-23 10:06:37 -0400 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2018-10-23 10:06:37 -0400 |
| commit | 63488b6ec28a6546bb8d43b7b1273d0362d99b57 (patch) | |
| tree | 615df2cfca85f2faa98f241faf318f8e757f7779 /httemplate/view | |
| parent | ae40f1d7aa1a0fcf8c32c60660a51de3551854d8 (diff) | |
RT# 71289 - fixed duplicate contact changes in customer history
Diffstat (limited to 'httemplate/view')
| -rw-r--r-- | httemplate/view/cust_main/change_history.html | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/view/cust_main/change_history.html b/httemplate/view/cust_main/change_history.html index 4ff604d7a..11777b54c 100644 --- a/httemplate/view/cust_main/change_history.html +++ b/httemplate/view/cust_main/change_history.html @@ -151,7 +151,7 @@ foreach my $table ( keys %tables ) { elsif ($table eq 'contact') { my $contact_addl_from = " - INNER JOIN (select contactnum, min(history_date) as min_history_date, max(history_date) as max_history_date FROM h_cust_contact WHERE custnum = ".$cust_main->custnum." AND history_date >= $newer_than GROUP BY contactnum) a ON h_cust_contact.contactnum = a.contactnum + INNER JOIN (select contactnum, min(history_date) as min_history_date, max(history_date) as max_history_date, max(historynum) as max_historynum FROM h_cust_contact WHERE custnum = ".$cust_main->custnum." AND history_date >= $newer_than GROUP BY contactnum) a ON h_cust_contact.contactnum = a.contactnum "; ## get list with add and remove dates of contacts for customer @@ -159,7 +159,7 @@ foreach my $table ( keys %tables ) { 'table' => "h_cust_contact", 'select' => "a.contactnum, a.min_history_date, a.max_history_date, history_action AS max_history_action", 'addl_from' => $contact_addl_from, - 'extra_sql' => " WHERE history_date = a.max_history_date", + 'extra_sql' => " WHERE historynum = a.max_historynum", }); foreach my $c (@h_cust_contacts) { |