diff options
| author | Mark Wells <mark@freeside.biz> | 2012-02-23 10:24:23 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2012-02-23 10:24:23 -0800 |
| commit | 229b67b82cbd4f1b70cad07c0da33d12f2a114c0 (patch) | |
| tree | a5f6f18f89614498d4302700e0057936316e3c48 | |
| parent | 558af464b550a135753e73b40b71a4d3fa9ae3cc (diff) | |
fix bug with manual notices directly to customers
| -rw-r--r-- | FS/FS/cust_main_Mixin.pm | 1 | ||||
| -rw-r--r-- | httemplate/misc/email-customers.html | 1 |
2 files changed, 2 insertions, 0 deletions
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; |