Tt: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 7: | Zeile 7: | ||
trim(round(sum(if(itemtype="Ausgabe", valDenar, 0))/240,1))=Ausgaben, | trim(round(sum(if(itemtype="Ausgabe", valDenar, 0))/240,1))=Ausgaben, | ||
trim(round(sum(valDenar)/240,1))=Saldo | trim(round(sum(valDenar)/240,1))=Saldo | ||
|where=department IS NOT NULL AND department != '' AND year=1427 | |where=department IS NOT NULL AND department != '' AND year=1427 and purpose=Lohn | ||
|group by=department | |group by=department | ||
}} | }} | ||
Version vom 19. Februar 2026, 10:37 Uhr
Error 1054: Unknown column 'Lohn' in 'WHERE'
Function: CargoSQLQuery::run Query: SELECT `department` AS `Ressort`,trim(round(sum(if(itemtype="Einnahme", valDenar, 0))/240,1)) AS `Einnahmen`,trim(round(sum(if(itemtype="Ausgabe", valDenar, 0))/240,1)) AS `Ausgaben`,trim(round(sum(valDenar)/240,1)) AS `Saldo` FROM `cargo__bookings` `bookings` WHERE department IS NOT NULL AND department != AND year=1427 and purpose=Lohn GROUP BY `department` ORDER BY `department`,trim(round(sum(if(itemtype="Einnahme", valDenar, 0))/240,1)),trim(round(sum(if(itemtype="Ausgabe", valDenar, 0))/240,1)),trim(round(sum(valDenar)/240,1)) LIMIT 100