<h2>Hallo, hier ist deine wöchentliche Projektübersicht:</h2>
<br />
<table style="border:1px solid black;border-collapse:collapse;">
    <tr style="border:1px solid black;">
        <th style="background: #CCC;text-align:left;border:1px solid black;">Projektcode</th>
        <th style="background: #CCC;text-align:left;border:1px solid black;">Kunde</th>
        <th style="background: #CCC;text-align:left;border:1px solid black;text-align:right">Stundenbudget</th>
        <th style="background: #CCC;text-align:left;border:1px solid black;text-align:right">Verbrauchte Stunden (ext)</th>
        <th style="background: #CCC;text-align:left;border:1px solid black;text-align:right">Restbudget (ext)</th>
    </tr>
    {{@foreach(sql:"Projekt":"creationdatetime>'{date.incday(-120).formatdatetime('yyyy-mm-dd')}'":"bold_id")}}
    <tr style="border:1px solid black;">
        <td style="text-align:left;border:1px solid black;">{{code}}</td>
        <td style="text-align:left;border:1px solid black;">{{kunde.asString}}</td>
        <td style="text-align:left;border:1px solid black;text-align:right">{{planminutenint/60[currency:#0.00]}} h</td>
        <td style="text-align:left;border:1px solid black;text-align:right">{{self->groupLeistungenP('','','')->collect(minutenExtOffen+minutenExtVerrechnet)->sum/60[currency:#0.00}} h</td>
        <td style="text-align:left;border:1px solid black;text-align:right">{{planMinutenInt/60 - (self->groupLeistungenP('','','')->collect(minutenExtOffen+minutenExtVerrechnet)->sum/60)[currency:#0.00}} h</td>
    </tr>
    {{@endforeach}}
    </tablestyle="border:1px>
