Revision eaae02cd
Von Bernd Bleßmann vor mehr als 1 Jahr hinzugefügt
| SL/RP.pm | ||
|---|---|---|
|
$customer_join
|
||
|
WHERE $saldowhere
|
||
|
$dpt_where_without_arapgl
|
||
|
$dpt_where
|
||
|
$customer_where
|
||
|
$project
|
||
|
AND c.accno = ? AND (NOT ac.ob_transaction OR ac.ob_transaction IS NULL)) AS saldo,
|
||
| ... | ... | |
|
$customer_join
|
||
|
WHERE $sumwhere
|
||
|
$dpt_where_without_arapgl
|
||
|
$dpt_where
|
||
|
$customer_where
|
||
|
$project
|
||
|
AND ac.amount > 0
|
||
| ... | ... | |
|
JOIN chart c ON (ac.chart_id = c.id)
|
||
|
$customer_join
|
||
|
WHERE $sumwhere
|
||
|
$dpt_where
|
||
|
$dpt_where_without_arapgl
|
||
|
$customer_where
|
||
|
$project
|
||
Auch abrufbar als: Unified diff
Bericht: SuSa/Projektbuchungen: SQL-Fehler bei Abteilungs- u. Projektfilter gefixt.
Behebt #89 (redmine)