Revision eac37e54
Von Jan Büren vor etwa 2 Jahren hinzugefügt
| SL/IR.pm | ||
|---|---|---|
| 779 | 779 |
$form->add_shipto($dbh, $form->{id}, "AP");
|
| 780 | 780 |
|
| 781 | 781 |
# delete zero entries |
| 782 |
do_query($form, $dbh, qq|DELETE FROM acc_trans WHERE amount = 0|); |
|
| 782 |
do_query($form, $dbh, qq|DELETE FROM acc_trans WHERE amount = 0 AND trans_id = ?|, $form->{id});
|
|
| 783 |
|
|
| 783 | 784 |
|
| 784 | 785 |
Common::webdav_folder($form); |
| 785 | 786 |
|
| ... | ... | |
| 939 | 940 |
|
| 940 | 941 |
my @values = (conv_i($form->{id}));
|
| 941 | 942 |
|
| 942 |
# delete zero entries |
|
| 943 |
# wtf? use case for this? |
|
| 944 |
$query = qq|DELETE FROM acc_trans WHERE amount = 0|; |
|
| 945 |
do_query($form, $dbh, $query); |
|
| 946 |
|
|
| 947 |
|
|
| 948 | 943 |
my @queries = ( |
| 949 | 944 |
qq|DELETE FROM invoice WHERE trans_id = ?|, |
| 950 | 945 |
qq|DELETE FROM ap WHERE id = ?|, |
Auch abrufbar als: Unified diff
Eingangsrechnungen: Grobschlächtige Aufräumaktionen verhindern
amount = 0 sollte sowieso nie als gültige Buchung in der acc_trans
landen