- $query = qq|SELECT a.id, s.spoolfile, vc.name, ac.transdate, a.invnumber,
- a.invoice, '$arap' AS module
- FROM status s, chart c, $form->{vc} vc, $arap a, acc_trans ac
- WHERE s.formname = '$form->{type}'
- AND s.chart_id = c.id
- AND c.accno = '$accno'
- AND s.trans_id = a.id
- AND a.$form->{vc}_id = vc.id
- AND ac.trans_id = s.trans_id
- AND ac.chart_id = c.id
- AND NOT ac.fx_transaction|;
- } else {
+ $query =
+ qq|SELECT a.id, s.spoolfile, vc.name, ac.transdate, a.invnumber, | .
+ qq| a.invoice, '$arap' AS module | .
+ qq|FROM status s, chart c, $vc vc, $arap a, acc_trans ac | .
+ qq|WHERE s.formname = ? | .
+ qq| AND s.chart_id = c.id | .
+ qq| AND c.accno = ? | .
+ qq| AND s.trans_id = a.id | .
+ qq| AND a.${vc}_id = vc.id | .
+ qq| AND ac.trans_id = s.trans_id | .
+ qq| AND ac.chart_id = c.id | .
+ qq| AND NOT ac.fx_transaction|;
+ @values = ($form->{type}, $accno);