Revision 90bb521a
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
| SL/GL.pm | ||
|---|---|---|
| 354 | 354 |
} |
| 355 | 355 |
} |
| 356 | 356 |
|
| 357 |
my $false = ($myconfig->{dbdriver} eq 'Pg') ? "FALSE" : q|'0'|;
|
|
| 358 |
|
|
| 359 | 357 |
my %sort_columns = ( |
| 360 | 358 |
'id' => [ qw(id) ], |
| 361 | 359 |
'transdate' => [ qw(transdate id) ], |
| ... | ... | |
| 385 | 383 |
|
| 386 | 384 |
$query = |
| 387 | 385 |
qq|SELECT |
| 388 |
ac.acc_trans_id, g.id, 'gl' AS type, $false AS invoice, g.reference, ac.taxkey, c.link,
|
|
| 386 |
ac.acc_trans_id, g.id, 'gl' AS type, FALSE AS invoice, g.reference, ac.taxkey, c.link,
|
|
| 389 | 387 |
g.description, ac.transdate, ac.gldate, ac.source, ac.trans_id, |
| 390 | 388 |
ac.amount, c.accno, g.notes, t.chart_id, |
| 391 | 389 |
CASE WHEN (COALESCE(e.name, '') = '') THEN e.login ELSE e.name END AS employee |
Auch abrufbar als: Unified diff
Alle Vorkommen von dbdriver, sid, Oracle entfernt
...und gegen das hardcodierte Werte für PostgreSQL ersetzt.