projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
b391b1c
)
fix self-service contact logins, RT#74798
author
Ivan Kohler
<ivan@freeside.biz>
Tue, 21 Mar 2017 21:12:37 +0000
(14:12 -0700)
committer
Ivan Kohler
<ivan@freeside.biz>
Tue, 21 Mar 2017 21:12:37 +0000
(14:12 -0700)
FS/FS/contact.pm
patch
|
blob
|
history
diff --git
a/FS/FS/contact.pm
b/FS/FS/contact.pm
index
c462e55
..
a873fda
100644
(file)
--- a/
FS/FS/contact.pm
+++ b/
FS/FS/contact.pm
@@
-766,8
+766,13
@@
sub by_selfservice_email {
'table' => 'contact_email',
'addl_from' => ' LEFT JOIN contact USING ( contactnum ) ',
'hashref' => { 'emailaddress' => $email, },
'table' => 'contact_email',
'addl_from' => ' LEFT JOIN contact USING ( contactnum ) ',
'hashref' => { 'emailaddress' => $email, },
- 'extra_sql' => " AND ( contact.disabled IS NULL ) ".
- " AND ( contact.selfservice_access = 'Y' )",
+ 'extra_sql' => "
+ AND ( contact.disabled IS NULL )
+ AND EXISTS ( SELECT 1 FROM cust_contact
+ WHERE contact.contactnum = cust_contact.contactnum
+ AND cust_contact.selfservice_access = 'Y'
+ )
+ ",
}) or return '';
$contact_email->contact;
}) or return '';
$contact_email->contact;