diff options
| author | Mark Wells <mark@freeside.biz> | 2012-02-23 10:29:30 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2012-02-23 10:29:30 -0800 |
| commit | fe699b35b2e0e81ce025e3ced4211f823ba0655f (patch) | |
| tree | ffeeb73216fbb4849b690d9d94d43ead77575e8c | |
| parent | ec2a4130eedbec0a08278456439605aaadbdda85 (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 7fcb5b5..a067706 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 b87a1bf..d26e402 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; |