diff options
| author | Mark Wells <mark@freeside.biz> | 2013-02-05 16:23:29 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2013-02-05 16:23:29 -0800 |
| commit | fed12e8214a8a951377961ccbe7a09171b1e38c2 (patch) | |
| tree | b3c902ff90c7397d49716844506a81f921ad9fa4 /httemplate/search/cust_event.html | |
| parent | fc8d730d0a7b31b617c963c5619bd3f45c5c3eb6 (diff) | |
make customer location columns available in various reports, #940
Diffstat (limited to 'httemplate/search/cust_event.html')
| -rw-r--r-- | httemplate/search/cust_event.html | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/httemplate/search/cust_event.html b/httemplate/search/cust_event.html index deb34b9e5..bd6ba6974 100644 --- a/httemplate/search/cust_event.html +++ b/httemplate/search/cust_event.html @@ -175,7 +175,13 @@ $search{'ending'} = $ending; my $where = ' WHERE '. FS::cust_event->search_sql_where( \%search ); -my $join = FS::cust_event->join_sql(); +my $join = FS::cust_event->join_sql() . + '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. my $sql_query = { 'table' => 'cust_event', |