diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-05-16 16:05:30 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-05-16 16:05:30 -0700 |
| commit | a0877673b88d523c3c4ede51ff2c238285d8aeea (patch) | |
| tree | e9c23fa3a2c0942e551f73b5f253dddf6b59d0c9 /httemplate | |
| parent | 29bd43c28ef5a1b418f0fbef9791cc4879c438fe (diff) | |
| parent | b0c05606c571c67e750ccd3c34c35d5e77345aba (diff) | |
Merge branch 'FREESIDE_3_BRANCH' of git.freeside.biz:/home/git/freeside into FREESIDE_3_BRANCH
Diffstat (limited to 'httemplate')
| -rw-r--r-- | httemplate/search/cust_event.html | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/httemplate/search/cust_event.html b/httemplate/search/cust_event.html index 344ceb8f7..8ab0f8fa6 100644 --- a/httemplate/search/cust_event.html +++ b/httemplate/search/cust_event.html @@ -181,12 +181,16 @@ $search{'ending'} = $ending; my $where = ' WHERE '. FS::cust_event->search_sql_where( \%search ); my $join = FS::cust_event->join_sql() . + # warning: does not show the true service address for package events. + # the query to do that would be painfully slow. 'LEFT JOIN cust_location bill_location '. 'ON (cust_main.bill_locationnum = bill_location.locationnum) '. 'LEFT JOIN cust_location ship_location '. - 'ON (cust_main.ship_locationnum = ship_location.locationnum)'; - # warning: does not show the true service address for package events. - # the query to do that would be painfully slow. + 'ON (cust_main.ship_locationnum = ship_location.locationnum)'. + # include link to referral in case it's in cust-fields + # (maybe we should be using FS::UI::Web::join_cust_main instead?) + 'LEFT JOIN (select refnum, referral from part_referral) AS part_referral_x '. + 'ON (cust_main.refnum = part_referral_x.refnum) '; my $sql_query = { 'table' => 'cust_event', |