projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
RT# 73422 Changes to report Customer Contacts
[freeside.git]
/
FS
/
FS
/
cust_main.pm
diff --git
a/FS/FS/cust_main.pm
b/FS/FS/cust_main.pm
index
a82d8a2
..
7c9868d
100644
(file)
--- a/
FS/FS/cust_main.pm
+++ b/
FS/FS/cust_main.pm
@@
-3072,14
+3072,15
@@
sub contact_list {
# WHERE ...
# AND (
# 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 (
# AND (
- #
( cust_contact.invoice_dest = 'Y' )
+ #
cust_contact.invoice_dest = 'Y'
# OR
# OR
- #
( cust_contact.message_dest = 'Y' )
+ #
cust_contact.message_dest = 'Y'
# )
# )
# )
# )
@@
-3105,12
+3106,14
@@
sub contact_list {
$search->{extra_sql} .= ' AND ( ';
if (@or_classnum) {
$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} .= ' 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;
}
$search->{extra_sql} .= ' ) ' if @or_classnum;
}