From 2581f5e097f2c4fc95902514bfe473014ce94018 Mon Sep 17 00:00:00 2001 From: Mark Wells Date: Sat, 28 Sep 2013 18:04:41 -0700 Subject: and make this work with pre-upgrade location info --- httemplate/search/phone_state.html | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/httemplate/search/phone_state.html b/httemplate/search/phone_state.html index 7b3acbbbf..67965b702 100644 --- a/httemplate/search/phone_state.html +++ b/httemplate/search/phone_state.html @@ -86,6 +86,10 @@ for(my $i = 0; $i < scalar(@tables); $i++) { # join to the preceding table if there is one, and filter out # deleted records if ( $i > 0 ) { + # special case to make pre-3.x data work; remove this later + if ( $table eq 'cust_main' ) { + $last_table = 'h_cust_pkg'; + } $addl_from .= " LEFT JOIN ( $h_table $inside ) AS $h_table ON ($h_table.$pkey = $last_table.$pkey)"; @@ -109,7 +113,9 @@ push @where, $curuser->agentnums_sql( ); my $where = " WHERE ".join(' AND ', map "($_)", @where); -my $group_field = 'h_cust_location.state'; +# for pre-3.x data +my $group_field = 'COALESCE(h_cust_location.state, h_cust_main.ship_state, h_cust_main.state)'; + my @select = ( "$group_field AS state", 'count(DISTINCT h_svc_phone.svcnum) AS num_svcnums', -- cgit v1.2.1