@layout:private.html;

@sql:tran;
  select 
    to_char(Created, 'YYYY-MM-DD') as Created,
    count(1) Count
  from
    Transaction
  where
    Created + interval '3 months'  > now()
  group by
    1
  order by
    1 desc;
@send;

<div class="work-head">
    <div class="centerfold">
        <p class="area-name">Lista transakcji</p>

        <p class="area-button" onclick="window.location='/';">Powrot do formularza platnosci</p>
    </div>
</div>

<br />

<div class="centerfold">

  <table class="entity-list">
    <thead>
        <tr>
            <td>Data rozpoczecia</td>
            <td>Ilosc transakcji</td>
        </tr>
    </thead>
    <tbody>
        @repeat:tran;
        <tr onclick="window.location='Transactions.gx?date=@{tran:Created}';">
            <td>@{tran:Created}</td>
            <td>@{tran:Count}</td>
        </tr>
        @rend;
    </tbody>
  </table>

</div>