Revision 9f07753b
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
| SL/AM.pm | ||
|---|---|---|
| 475 | 475 |
do_query($form, $dbh, $query, $form->{id});
|
| 476 | 476 |
} |
| 477 | 477 |
|
| 478 |
foreach my $table (qw(partstax customertax vendortax tax)) {
|
|
| 479 |
$query = qq|DELETE FROM $table |
|
| 480 |
WHERE chart_id = ?|; |
|
| 481 |
do_query($form, $dbh, $query, $form->{id});
|
|
| 482 |
} |
|
| 478 |
$query = qq|DELETE FROM tax |
|
| 479 |
WHERE chart_id = ?|; |
|
| 480 |
do_query($form, $dbh, $query, $form->{id});
|
|
| 483 | 481 |
|
| 484 | 482 |
# delete chart of account record |
| 485 | 483 |
$query = qq|DELETE FROM chart |
| ... | ... | |
| 1779 | 1777 |
taxkey, |
| 1780 | 1778 |
taxdescription, |
| 1781 | 1779 |
round(rate * 100, 2) AS rate, |
| 1782 |
chart_id,
|
|
| 1783 |
(id IN (SELECT tax_id
|
|
| 1780 |
chart_id, |
|
| 1781 |
(id IN (SELECT tax_id |
|
| 1784 | 1782 |
FROM acc_trans)) AS tax_already_used |
| 1785 | 1783 |
FROM tax |
| 1786 | 1784 |
WHERE id = ? |; |
Auch abrufbar als: Unified diff
Überflüssige Tabellen customertax, vendortax, partstax entfernt
Fixt #2186.