$dpt_join .
qq|WHERE | . $where . $dpt_where . $project .
qq| AND ac.chart_id = ? | .
+ qq| AND ac.trans_id = a.id | .
- qq|UNION | .
+ qq|UNION ALL | .
qq|SELECT a.id, a.invnumber, c.name, ac.transdate, | .
qq| a.invoice, ac.amount, 'ar' as module | .
qq|WHERE | . $where . $dpt_where . $project .
qq| AND ac.chart_id = ? | .
qq| AND NOT a.storno | .
+ qq| AND ac.trans_id = a.id | .
qq| AND a.customer_id = c.id | .
- qq|UNION | .
+ qq|UNION ALL | .
qq|SELECT a.id, a.invnumber, v.name, ac.transdate, | .
qq| a.invoice, ac.amount, 'ap' as module | .
$dpt_join .
qq|WHERE | . $where . $dpt_where . $project .
qq| AND ac.chart_id = ? | .
+ qq| AND ac.trans_id = a.id | .
qq| AND NOT a.storno | .
qq| AND a.vendor_id = v.id |;
$union = qq|UNION ALL|;
}
- $query .= qq|ORDER BY | . $form->{sort};
+ my $sort = grep({ $form->{sort} eq $_ } qw(transdate reference description)) ? $form->{sort} : 'transdate';
+
+ $query .= qq|ORDER BY $sort|;
$sth = prepare_execute_query($form, $dbh, $query, @values);
$form->{CA} = [];
$ca->{debit} = 0;
}
+ $ca->{index} = join "--", map { $ca->{$_} } qw(id reference description);
+
push(@{ $form->{CA} }, $ca);
}