Revision 13c238dd
Von Udo Spallek vor etwa 19 Jahren hinzugefügt
| SL/USTVA.pm | ||
|---|---|---|
| 638 | 638 |
my $glwhere = ""; |
| 639 | 639 |
my $subwhere = ""; |
| 640 | 640 |
my $ARwhere = ""; |
| 641 |
my $arwhere = ""; |
|
| 641 | 642 |
my $item; |
| 642 | 643 |
|
| 643 | 644 |
if ($fromdate) {
|
| ... | ... | |
| 646 | 647 |
$glwhere = " AND ac.transdate >= '$fromdate'"; |
| 647 | 648 |
$ARwhere .= " AND acc.transdate >= '$fromdate'"; |
| 648 | 649 |
$where .= " AND ac.transdate >= '$fromdate'"; |
| 650 |
|
|
| 649 | 651 |
} |
| 650 | 652 |
} |
| 651 | 653 |
|
| 652 | 654 |
if ($todate) {
|
| 653 | 655 |
$where .= " AND ac.transdate <= '$todate'"; |
| 654 | 656 |
$ARwhere .= " AND acc.transdate <= '$todate'"; |
| 655 |
$arwhere .= " AND ac.transdate <= '$todate'"; |
|
| 656 | 657 |
$subwhere .= " AND transdate <= '$todate'"; |
| 657 | 658 |
} |
| 658 | 659 |
|
| ... | ... | |
| 695 | 696 |
c.pos_ustva |
| 696 | 697 |
FROM acc_trans ac |
| 697 | 698 |
JOIN chart c ON (c.id = ac.chart_id) |
| 698 |
JOIN ar ON (ar.id = ac.trans_id) |
|
| 699 |
--JOIN ar ON (ar.id = ac.trans_id)
|
|
| 699 | 700 |
where |
| 700 | 701 |
1=1 |
| 701 |
$arwhere |
|
| 702 |
-- Here no where, please. All Transactions ever should be |
|
| 703 |
-- testet if they are paied in the USTVA report period. |
|
| 702 | 704 |
GROUP BY c.pos_ustva |
| 703 | 705 |
UNION |
| 704 | 706 |
|
Auch abrufbar als: Unified diff
Nachtrag zu R704 'Diverse USTVA Bugs geloest'