X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fmisc%2Femail-customers.html;h=cf3ab1b48ad0b3ae37aa283c19d9653803ce24e9;hp=b631165dc68e1306b84a106411727564e433ce9c;hb=1fe87434632f2627de487ca2aed6cfadea2c6061;hpb=80cea05076d397b3b06246a3df4451aea415e9fc diff --git a/httemplate/misc/email-customers.html b/httemplate/misc/email-customers.html index b631165dc..cf3ab1b48 100644 --- a/httemplate/misc/email-customers.html +++ b/httemplate/misc/email-customers.html @@ -372,6 +372,15 @@ if ( !$cgi->param('preview') ) { $body ||= $content->body; } + my $sql_query = "FS::$table"->search(\%search); + my $count_query = delete($sql_query->{'count_query'}); + my $count_sth = dbh->prepare($count_query) + or die "Error preparing $count_query: ". dbh->errstr; + $count_sth->execute + or die "Error executing $count_query: ". $count_sth->errstr; + my $count_arrayref = $count_sth->fetchrow_arrayref; + $num_cust = $count_arrayref->[0]; + } else { my @checked_email_dest; @@ -520,8 +529,8 @@ if ( my @in_classnums = $cgi->param('classnums') ) { $dest_ischecked{message} = 1 unless %dest_ischecked; my @optin_checkboxes = ( - [ 'message' => { label => 'Message recipients' } ], - [ 'invoice' => { label => 'Invoice recipients' } ], + [ 'message' => { label => 'Message recipients', desc => 'send this notice to all message recipients for the '.$num_cust.' selected customers.' } ], + [ 'invoice' => { label => 'Invoice recipients', desc => 'send this notice to all invoice recipients for the '.$num_cust.' selected customers.' } ], ); my @classnum_checkboxes = ( [ '0' => { label => '(None)' }],