Revision 62a9b707
Von Sven Schöling vor mehr als 17 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
| 776 | 776 |
do_query($form, $dbh, $query, $id); |
| 777 | 777 |
|
| 778 | 778 |
# now copy acc_trans entries |
| 779 |
$query = qq|SELECT a.*, c.link FROM acc_trans a LEFT JOIN chart c ON a.chart_id = c.id WHERE a.trans_id = ?|; |
|
| 779 |
$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|;
|
|
| 780 | 780 |
my $rowref = selectall_hashref_query($form, $dbh, $query, $id); |
| 781 | 781 |
|
| 782 | 782 |
# kill all entries containing payments, which are the last 2n rows, of which the last has link =~ /paid/ |
| SL/AR.pm | ||
|---|---|---|
| 645 | 645 |
do_query($form, $dbh, $query, $id); |
| 646 | 646 |
|
| 647 | 647 |
# now copy acc_trans entries |
| 648 |
$query = qq|SELECT a.*, c.link FROM acc_trans a LEFT JOIN chart c ON a.chart_id = c.id WHERE a.trans_id = ?|; |
|
| 648 |
$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|;
|
|
| 649 | 649 |
my $rowref = selectall_hashref_query($form, $dbh, $query, $id); |
| 650 | 650 |
|
| 651 | 651 |
# 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