- $acc_cash_where = qq| AND (ac.trans_id IN (SELECT id FROM ar WHERE datepaid>='$form->{fromdate}' AND datepaid<='$form->{todate}' UNION SELECT id FROM ap WHERE datepaid>='$form->{fromdate}' AND datepaid<='$form->{todate}' UNION SELECT id FROM gl WHERE transdate>='$form->{fromdate}' AND transdate<='$form->{todate}')) |;
- $ar_ap_cash_where = qq| AND (a.datepaid>='$form->{fromdate}' AND a.datepaid<='$form->{todate}') |;
- }
+ $where = qq| (ac.trans_id IN (SELECT id FROM ar WHERE datepaid>= ? AND datepaid<= ? UNION SELECT id FROM ap WHERE datepaid>= ? AND datepaid<= ? UNION SELECT id FROM gl WHERE transdate>= ? AND transdate<= ?)) |;
+ @where_values = ();
+ push(@where_values, conv_date($form->{fromdate}));
+ push(@where_values, conv_date($form->{todate}));
+ push(@where_values, conv_date($form->{fromdate}));
+ push(@where_values, conv_date($form->{todate}));
+ push(@where_values, conv_date($form->{fromdate}));
+ push(@where_values, conv_date($form->{todate}));
+ }
+