diff options
author | Jonathan Prykop <jonathan@freeside.biz> | 2016-05-12 22:37:25 -0500 |
---|---|---|
committer | Jonathan Prykop <jonathan@freeside.biz> | 2016-05-12 22:37:25 -0500 |
commit | 12a1fd3b75876dd3ec5449bc87fd8313da1b750b (patch) | |
tree | 3bb909605a8ac510cb34f72c38217347d3ff24be /FS/FS/cust_payby.pm | |
parent | cf2014ff0946351fd7bd4bc134ae2535543b63da (diff) |
RT#41394: Add advertising source to customer fields selection [safer part_referral join]
Diffstat (limited to 'FS/FS/cust_payby.pm')
-rw-r--r-- | FS/FS/cust_payby.pm | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/FS/FS/cust_payby.pm b/FS/FS/cust_payby.pm index 50d9ee0..5bfb4af 100644 --- a/FS/FS/cust_payby.pm +++ b/FS/FS/cust_payby.pm @@ -831,6 +831,9 @@ sub search_sql { ' LEFT JOIN cust_location AS '.$pre.'location '. 'ON (cust_main.'.$pre.'locationnum = '.$pre.'location.locationnum) '; } + # always make referral available in results + # (maybe we should be using FS::UI::Web::join_cust_main instead?) + $addl_from .= ' LEFT JOIN (select refnum, referral from part_referral) AS part_referral_x ON (cust_main.refnum = part_referral_x.refnum) '; my $count_query = "SELECT COUNT(*) FROM cust_payby $addl_from $extra_sql"; |