Revision 62a9b707
Von Sven Schöling vor fast 18 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
|
do_query($form, $dbh, $query, $id);
|
||
|
|
||
|
# now copy acc_trans entries
|
||
|
$query = qq|SELECT a.*, c.link FROM acc_trans a LEFT JOIN chart c ON a.chart_id = c.id WHERE a.trans_id = ?|;
|
||
|
$query = qq|SELECT a.*, c.link FROM acc_trans a LEFT JOIN chart c ON a.chart_id = c.id WHERE a.trans_id = ? ORDER BY a.oid|;
|
||
|
my $rowref = selectall_hashref_query($form, $dbh, $query, $id);
|
||
|
|
||
|
# kill all entries containing payments, which are the last 2n rows, of which the last has link =~ /paid/
|
||
| SL/AR.pm | ||
|---|---|---|
|
do_query($form, $dbh, $query, $id);
|
||
|
|
||
|
# now copy acc_trans entries
|
||
|
$query = qq|SELECT a.*, c.link FROM acc_trans a LEFT JOIN chart c ON a.chart_id = c.id WHERE a.trans_id = ?|;
|
||
|
$query = qq|SELECT a.*, c.link FROM acc_trans a LEFT JOIN chart c ON a.chart_id = c.id WHERE a.trans_id = ? ORDER BY a.oid|;
|
||
|
my $rowref = selectall_hashref_query($form, $dbh, $query, $id);
|
||
|
|
||
|
# kill all entries containing payments, which are the last 2n rows, of which the last has link =~ /paid/
|
||
Auch abrufbar als: Unified diff
storno fix: acc_trans query muessen nach oid sortieren