diff options
| author | Mitch Jackson <mitch@freeside.biz> | 2018-01-30 09:27:42 -0600 |
|---|---|---|
| committer | Mitch Jackson <mitch@freeside.biz> | 2018-10-28 15:03:32 -0400 |
| commit | 945bc9a8c3edf867cbaea0aa2af738d73ac180c8 (patch) | |
| tree | 6ca2ce309937fa0b011cbe508a38747f58253909 /FS/FS/cust_main.pm | |
| parent | 9ecbe48e7226f9fe9b8b641d6fe7b3fddcd4bc1e (diff) | |
RT# 73422 Changes to report Customer Contacts
Diffstat (limited to 'FS/FS/cust_main.pm')
| -rw-r--r-- | FS/FS/cust_main.pm | 19 |
1 files changed, 11 insertions, 8 deletions
diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index d2c4a36..f35ec12 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -3315,14 +3315,15 @@ sub contact_list { # WHERE ... # AND ( - # ( cust_contact.classnum IN (1,2,3) ) - # OR - # ( cust_contact.classnum IS NULL ) - # + # ( + # cust_contact.classnum IN (1,2,3) + # OR + # cust_contact.classnum IS NULL + # ) # AND ( - # ( cust_contact.invoice_dest = 'Y' ) + # cust_contact.invoice_dest = 'Y' # OR - # ( cust_contact.message_dest = 'Y' ) + # cust_contact.message_dest = 'Y' # ) # ) @@ -3348,12 +3349,14 @@ sub contact_list { $search->{extra_sql} .= ' AND ( '; if (@or_classnum) { - $search->{extra_sql} .= join ' OR ', map {" ($_) "} @or_classnum; + $search->{extra_sql} .= ' ( '; + $search->{extra_sql} .= join ' OR ', map {" $_ "} @or_classnum; + $search->{extra_sql} .= ' ) '; $search->{extra_sql} .= ' AND ( ' if @and_dest; } if (@and_dest) { - $search->{extra_sql} .= join ' OR ', map {" ($_) "} @and_dest; + $search->{extra_sql} .= join ' OR ', map {" $_ "} @and_dest; $search->{extra_sql} .= ' ) ' if @or_classnum; } |