projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
RT# 32917 - updated tax report to show pre discount estimated tax
[freeside.git]
/
httemplate
/
misc
/
xmlhttp-cust_main-email_search.html
diff --git
a/httemplate/misc/xmlhttp-cust_main-email_search.html
b/httemplate/misc/xmlhttp-cust_main-email_search.html
index
d8c8ef4
..
eb9ecc8
100644
(file)
--- a/
httemplate/misc/xmlhttp-cust_main-email_search.html
+++ b/
httemplate/misc/xmlhttp-cust_main-email_search.html
@@
-1,4
+1,4
@@
-<%
JSON::to
_json(\@result) %>\
+<%
encode
_json(\@result) %>\
<%init>
die 'access denied'
unless $FS::CurrentUser::CurrentUser->access_right('Edit customer');
<%init>
die 'access denied'
unless $FS::CurrentUser::CurrentUser->access_right('Edit customer');
@@
-6,14
+6,14
@@
die 'access denied'
my $sub = $cgi->param('sub');
my $email = $cgi->param('arg');
my @where = (
my $sub = $cgi->param('sub');
my $email = $cgi->param('arg');
my @where = (
- "cust_main_invoice.dest != 'POST'",
- "cust_main_invoice.dest LIKE ".dbh->quote('%'.$email.'%'),
+ 'contact_email.emailaddress LIKE '.dbh->quote('%'.$email.'%'),
$FS::CurrentUser::CurrentUser->agentnums_sql(table => 'cust_main'),
);
my @cust_main = qsearch({
'table' => 'cust_main',
$FS::CurrentUser::CurrentUser->agentnums_sql(table => 'cust_main'),
);
my @cust_main = qsearch({
'table' => 'cust_main',
- 'select' => 'cust_main.*, cust_main_invoice.dest',
- 'addl_from' => 'JOIN cust_main_invoice USING (custnum)',
+ 'select' => 'cust_main.*',
+ 'addl_from' => ' JOIN cust_contact USING (custnum) '.
+ ' JOIN contact_email USING (contactnum)',
'extra_sql' => 'WHERE '.join(' AND ', @where),
});
'extra_sql' => 'WHERE '.join(' AND ', @where),
});