Revision 96b67ec1
Von Bernd Bleßmann vor mehr als 2 Jahren hinzugefügt
| SL/GL.pm | ||
|---|---|---|
| 366 | 366 |
} |
| 367 | 367 |
|
| 368 | 368 |
my %sort_columns = ( |
| 369 |
'id' => [ qw(id) ], |
|
| 370 |
'transdate' => [ qw(transdate id) ], |
|
| 371 |
'gldate' => [ qw(gldate id) ], |
|
| 372 |
'reference' => [ qw(lower_reference id) ], |
|
| 373 |
'description' => [ qw(lower_description id) ], |
|
| 374 |
'accno' => [ qw(accno transdate id) ], |
|
| 375 |
'department' => [ qw(department transdate id) ], |
|
| 369 |
'id' => [ qw(id) ],
|
|
| 370 |
'transdate' => [ qw(transdate id) ],
|
|
| 371 |
'gldate' => [ qw(gldate id) ],
|
|
| 372 |
'reference' => [ qw(lower_reference id) ],
|
|
| 373 |
'description' => [ qw(lower_description id) ],
|
|
| 374 |
'accno' => [ qw(accno transdate id) ],
|
|
| 375 |
'department' => [ qw(department transdate id) ],
|
|
| 376 | 376 |
'transaction_description' => [ qw(lower_transaction_description id) ], |
| 377 | 377 |
); |
| 378 | 378 |
my %lowered_columns = ( |
| 379 |
'reference' => { 'gl' => 'g.reference', 'arap' => 'a.invnumber', },
|
|
| 380 |
'source' => { 'gl' => 'ac.source', 'arap' => 'ac.source', },
|
|
| 381 |
'description' => { 'gl' => 'g.description', 'arap' => 'ct.name', },
|
|
| 382 |
'transaction_description' => { 'gl' => 'g.transaction_description', 'arap' => 'a.transaction_description', },
|
|
| 379 |
'reference' => { 'gl' => 'g.reference', 'arap' => 'a.invnumber', },
|
|
| 380 |
'source' => { 'gl' => 'ac.source', 'arap' => 'ac.source', },
|
|
| 381 |
'description' => { 'gl' => 'g.description', 'arap' => 'ct.name', },
|
|
| 382 |
'transaction_description' => { 'gl' => 'g.transaction_description', 'arap' => 'a.transaction_description', },
|
|
| 383 | 383 |
); |
| 384 | 384 |
|
| 385 | 385 |
# sortdir = sort direction (ascending or descending) |
| ... | ... | |
| 670 | 670 |
g.storno, g.storno_id, |
| 671 | 671 |
g.department_id, d.description AS department, |
| 672 | 672 |
e.name AS employee, g.taxincluded, g.gldate, |
| 673 |
g.ob_transaction, g.cb_transaction, |
|
| 674 |
g.transaction_description |
|
| 673 |
g.ob_transaction, g.cb_transaction,
|
|
| 674 |
g.transaction_description
|
|
| 675 | 675 |
FROM gl g |
| 676 | 676 |
LEFT JOIN department d ON (d.id = g.department_id) |
| 677 | 677 |
LEFT JOIN employee e ON (e.id = g.employee_id) |
Auch abrufbar als: Unified diff
Kosmetik Dialogbuchung gl.pl, GL.pm: Ausrichtung