@layout:private.html;

@sql:tran;
select 
TransactionId,
case when Barcode is null or Barcode = 0 then 'n/d' else coalesce((12745 # (Barcode * 1111))::varchar, 'n/d') end as Id,
(ClientData::json ->> 'firstName') || ' ' || (ClientData::json ->> 'lastName') as ClientName,
ClientData::json ->> 'document' ClientDocument,
to_char(Created, 'YYYY-MM-DD HH:MI:SS') as Created,
to_char(Terminated, 'YYYY-MM-DD HH:MI:SS') as Terminated,
case when PayModel = 'Card' then 'Karta' when PayModel = 'Cash' then 'Gotowka' else '' end as PayModel,
to_char(CashIn::float / 100.0, 'FM999999990.00') || '&nbsp;<sub>PLN</sub>' as CashInDisp,
to_char(CashOut::float / 100.0, 'FM999999990.00') || '&nbsp;<sub>PLN</sub>' as CashOutDisp,
case 
when CashRequested is null then '' 
when CashRequested::int > 0 then 'Do zaplaty' 
when CashRequested::int < 0 then 'Do zwrotu' 
else ''
end || ' ' || to_char(CashRequested::float / 100.0, 'FM999999990.00') || '&nbsp;<sub>PLN</sub>' as CashRequestedDisp,
case 
when CashReported is null then '' 
when CashReported::int > 0 then 'Do zaplaty' 
when CashReported::int > 0 then 'Do zaplaty' 
when CashReported::int = 0 then 'Oplacono w calosci' 
else ''
end || case
when coalesce(CashReported::int, 0) != 0 then
' ' || to_char(CashReported::float / 100.0, 'FM999999990.00') || '&nbsp;<sub>PLN</sub>'
else ''
end as CashReportedDisp,
case 
when Close = 'Normal' then 'Prawidlowo zakonczona'
when Close = 'Cancelled' then 'Anulowana'
when Close = 'Interrupted' then 'Przerwana'
when Close = 'Timeout' then 'Uplyw czasu'
when Close is null then 'Nie zakonczona'
end as CloseDisp,
'Raport' as Report,
(select reportId from report b where type = 'CashPaymentReport' and b.transaction = a.transactionid limit 1) as ReportId
from
Transaction a
where
ClientData is not null and ClientData != ''
and
to_char(Created, 'YYYY-MM-DD') = '@{http:url:date}'
order by
TransactionId;
@send;

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

        <p class="area-button" onclick="window.location = 'List.gx';">Powrot do kalendarza</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>Nr transakcji</td>
                <td>Nr zlecenia</td>
                <td>Imie i nazwisko</td>
                <td>Data rozpoczecia</td>
                <td>Rodzaj platnosci</td>
                <td>Bilans poczatkowy</td>
                <td>Wplata gotowkowa</td>
                <td>Wplata karta platnicza</td>
                <td>Wyplata gotowkowa</td>
                <td>Bilans koncowy</td>
                <td>Sposob zakonczenia</td>
                <td>Raport</td>
                
            </tr>
        </thead>
        <tbody>
            @repeat:tran;
            <tr onclick="window.location='Cash.gx?tid=@{tran:TransactionId}&date=@{http:url:date}';">
                <td>@{tran:TransactionId}</td>
                <td>@{tran:Id}</td>
                <td>@{tran:ClientName}</td>
                <td>@{tran:Created}</td>
                <td>@{tran:PayModel}</td>
                <td>@{tran:CashRequestedDisp}</td>
                <td>@{tran:CashInDisp}</td>
                <td>@{tran:CardInDisp}</td>
                <td>@{tran:CashOutDisp}</td>
                <td>@{tran:CashReportedDisp}</td>
                <td>@{tran:CloseDisp}</td>
                <td><a href="~/action/public/getReport/@{tran:ReportId}" download>Pobierz</a></td>
            </tr>
            @rend;
        </tbody>
    </table>

</div>