Revision 41cceb1e
Von Moritz Bunkus vor fast 8 Jahren hinzugefügt
| SL/Form.pm | ||
|---|---|---|
| 2664 | 2664 |
|
| 2665 | 2665 |
# now get the account numbers |
| 2666 | 2666 |
$query = qq| |
| 2667 |
SELECT c.accno, c.description, c.link, c.taxkey_id, tk2.tax_id |
|
| 2667 |
SELECT c.accno, c.description, c.link, c.taxkey_id, c.id AS chart_id, tk2.tax_id
|
|
| 2668 | 2668 |
FROM chart c |
| 2669 | 2669 |
-- find newest entries in taxkeys |
| 2670 | 2670 |
INNER JOIN ( |
| ... | ... | |
| 2694 | 2694 |
|
| 2695 | 2695 |
push @{ $self->{"${module}_links"}{$key} },
|
| 2696 | 2696 |
{ accno => $ref->{accno},
|
| 2697 |
chart_id => $ref->{chart_id},
|
|
| 2697 | 2698 |
description => $ref->{description},
|
| 2698 | 2699 |
taxkey => $ref->{taxkey_id},
|
| 2699 | 2700 |
tax_id => $ref->{tax_id} };
|
| ... | ... | |
| 2747 | 2748 |
} |
| 2748 | 2749 |
|
| 2749 | 2750 |
# now get the account numbers |
| 2750 |
$query = qq|SELECT c.accno, c.description, c.link, c.taxkey_id, tk.tax_id |
|
| 2751 |
$query = qq|SELECT c.accno, c.description, c.link, c.taxkey_id, c.id AS chart_id, tk.tax_id
|
|
| 2751 | 2752 |
FROM chart c |
| 2752 | 2753 |
LEFT JOIN taxkeys tk ON (tk.chart_id = c.id) |
| 2753 | 2754 |
WHERE c.link LIKE ? |
| ... | ... | |
| 2769 | 2770 |
|
| 2770 | 2771 |
push @{ $self->{"${module}_links"}{$key} },
|
| 2771 | 2772 |
{ accno => $ref->{accno},
|
| 2773 |
chart_id => $ref->{chart_id},
|
|
| 2772 | 2774 |
description => $ref->{description},
|
| 2773 | 2775 |
taxkey => $ref->{taxkey_id},
|
| 2774 | 2776 |
tax_id => $ref->{tax_id} };
|
| ... | ... | |
| 2783 | 2785 |
$query = |
| 2784 | 2786 |
qq|SELECT |
| 2785 | 2787 |
c.accno, c.description, |
| 2786 |
a.acc_trans_id, a.source, a.amount, a.memo, a.transdate, a.gldate, a.cleared, a.project_id, a.taxkey, |
|
| 2788 |
a.acc_trans_id, a.source, a.amount, a.memo, a.transdate, a.gldate, a.cleared, a.project_id, a.taxkey, a.chart_id,
|
|
| 2787 | 2789 |
p.projectnumber, |
| 2788 | 2790 |
t.rate, t.id |
| 2789 | 2791 |
FROM acc_trans a |
Auch abrufbar als: Unified diff
Debitorenbuchungen auf Verwendung des Chart-Pickers umgestellt