{ 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;
- my %message = $msg_template->prepare( 'cust_main' => $cust );
+ my %message = $msg_template->prepare(
+ 'cust_main' => $cust,
+ 'object' => $object
+ );
($from, $subject, $html_body) = @message{'from', 'subject', 'html_body'};
}
}