Quelltext der Seite Sammel-Buchungen

__NOCACHE__
{{#cargo_query:
  tables=bookings
  |fields=_pageName=Buchung,
    DATE_FORMAT(datum, "%e.%b")=  ,
    itemkind= ,
    itemtype=Art,
    department=Abt.,
    purpose=Zweck,
    CONCAT(IF(pound>0,    CONCAT(pound,"£ ")    ,"       "),
           IF(shilling>0,CONCAT(shilling,"ß "),"       "),
           IF(denar>0,    CONCAT(denar,    "d"),"       ")
          )=Betrag,
    valDenar=in Dn,
    person=Person,
  |where=bookings.itemkind = 'Sammel-Buchung'    
}}
{{#cargo_query:
  tables=bookings
  |fields=CONCAT(COUNT(*),"  Einträge")=,
          CONCAT("Total in Denar:   ",Sum(valDenar))=,
  |where=bookings.itemkind = 'Sammel-Buchung'   
}}  

<div style="
  font-weight: bold;
  text-align: center;
  float: right;">
  [[Spezial:Mit Formular bearbeiten/Booking|Neue Buchung]]
</div>