Revision 081a4f97
Von Moritz Bunkus vor mehr als 18 Jahren hinzugefügt
| SL/CA.pm | ||
|---|---|---|
| 164 | 164 |
$where .= $fromto; |
| 165 | 165 |
$AR_PAID = ""; |
| 166 | 166 |
$AP_PAID = ""; |
| 167 |
$glwhere = ""; # note! gl will be aliased as "a" later... |
|
| 167 |
$glwhere = ""; # note! gl will be aliased as "a" later...
|
|
| 168 | 168 |
} |
| 169 | 169 |
my $sortorder = join ', ', |
| 170 | 170 |
$form->sort_columns(qw(transdate reference description)); |
| ... | ... | |
| 323 | 323 |
|
| 324 | 324 |
foreach my $id (@id) {
|
| 325 | 325 |
|
| 326 |
# NOTE:
|
|
| 327 |
# Postgres is really picky about the order of implicit CROSS JOINs with ','
|
|
| 328 |
# if you alias the tables and want to use the alias later in another JOIN.
|
|
| 329 |
# the alias you want to use has to be the most recent in the list, otherwise
|
|
| 330 |
# Postgres will overwrite the alias internally and complain.
|
|
| 331 |
# For this reason, in the next 3 SELECTs, the 'a' alias is last in the list.
|
|
| 332 |
# Don't change this, and if you do, substitute the ',' with CROSS JOIN
|
|
| 333 |
# ... that also works.
|
|
| 326 |
# NOTE:
|
|
| 327 |
# Postgres is really picky about the order of implicit CROSS JOINs with ',' |
|
| 328 |
# if you alias the tables and want to use the alias later in another JOIN. |
|
| 329 |
# the alias you want to use has to be the most recent in the list, otherwise |
|
| 330 |
# Postgres will overwrite the alias internally and complain. |
|
| 331 |
# For this reason, in the next 3 SELECTs, the 'a' alias is last in the list. |
|
| 332 |
# Don't change this, and if you do, substitute the ',' with CROSS JOIN |
|
| 333 |
# ... that also works. |
|
| 334 | 334 |
|
| 335 | 335 |
# get all transactions |
| 336 | 336 |
$query .= qq|$union |
Auch abrufbar als: Unified diff
Kosmetik: Perltidy-Lauf nach den Einstellungen in doc/programmierrichtlinien.txt ueber alle .pl und .pm.