|
|
| Zeile 1: |
Zeile 1: |
| __NOCACHE__{{ButtonLinkVertikal|ziel=:Special:RunQuery/SucheBuchung|text=Suche}} | | __NOCACHE__{{ButtonLinkVertikal|ziel=:Special:RunQuery/SucheBuchung|text=Suche}} |
| <!--{{ButtonLinkVertikal|ziel={{BookingsTotal}}|text=Total}}-->
| |
| {{#cargo_query: | | {{#cargo_query: |
| tables=bookings
| | tables=bookings |
| |fields=_pageName=Buchung,
| | |fields=trim(year)=Jahr, datum=Datum |
| DATE_FORMAT(datum, "%e.%b")= ,
| | |group by=year |
| itemtype=Art,
| |
| department=Ressort,
| |
| LEFT(purpose,25)=Zweck,
| |
| CONCAT(
| |
| '<span class="betrag ',
| |
| IF(itemtype="Einnahme","betrag-ein",
| |
| IF(itemtype="Ausgabe","betrag-aus","")),
| |
| '">',
| |
| '<span class="amt amt-lb">',
| |
| IF(pound>0, CONCAT(pound,'lb'), ''),
| |
| '</span>',
| |
| '<span class="amt amt-sh">',
| |
| IF(shilling>0, CONCAT(shilling,'ß'), ''),
| |
| '</span>',
| |
| '<span class="amt amt-dn">',
| |
| IF(denar>0, CONCAT(denar,'dn'), ''),
| |
| '</span>',
| |
| '</span>'
| |
| )=Betrag,
| |
| IF(person__full>"",CONCAT("[[",person__full,"]]"),personOrig)=Person(en),
| |
| IF(pendenz>"","P"," ")=P,
| |
| |where={{{pick|}}}
| |
| |limit=2000
| |
| |default=Keine Buchungen für diesen Bereich ({{{pick|}}})
| |
| }} | | }} |
| <span style="display:block; height:0.4em;"></span>{{BookingsTotal|{{{pick|}}} }}
| |
