From fe699b35b2e0e81ce025e3ced4211f823ba0655f Mon Sep 17 00:00:00 2001 From: Mark Wells Date: Thu, 23 Feb 2012 10:29:30 -0800 Subject: [PATCH] fix bug with manual notices directly to customers --- FS/FS/cust_main_Mixin.pm | 1 + httemplate/misc/email-customers.html | 1 + 2 files changed, 2 insertions(+) diff --git a/FS/FS/cust_main_Mixin.pm b/FS/FS/cust_main_Mixin.pm index 7fcb5b5c7..a0677060e 100644 --- a/FS/FS/cust_main_Mixin.pm +++ b/FS/FS/cust_main_Mixin.pm @@ -410,6 +410,7 @@ sub email_search_result { } my $sql_query = $class->search($param->{'search'}); + $sql_query->{'select'} = $sql_query->{'table'} . '.*'; my $count_query = delete($sql_query->{'count_query'}); my $count_sth = dbh->prepare($count_query) diff --git a/httemplate/misc/email-customers.html b/httemplate/misc/email-customers.html index b87a1bfbb..d26e40298 100644 --- a/httemplate/misc/email-customers.html +++ b/httemplate/misc/email-customers.html @@ -188,6 +188,7 @@ if ( $cgi->param('action') eq 'preview' ) { { msgnum => $cgi->param('msgnum') } ) or die "template not found: ".$cgi->param('msgnum'); $sql_query->{'extra_sql'} .= ' LIMIT 1'; + $sql_query->{'select'} = "$table.*"; $sql_query->{'order_by'} = ''; my $object = qsearchs($sql_query); my $cust = $object->cust_main; -- 2.11.0