@layout:private.html;

@sql:tran;
select 
    name, count, cast(cast(value as numeric(15,2))/100 as numeric(15,2)) as value, capacity
from cashcontainer
where   not name like 'Billbox%'
        and 
        not name like 'Cashbox%'
union
select 
    'Billbox' as name, sum(count) as count, 0 as value, 900 as capacity
from cashcontainer
where   name like 'Billbox%'
        and 
        value > 0
union
select 
    'Cashbox' as name, sum(count) as count, 0 as value, 900 as capacity
from cashcontainer
where   name like 'Cashbox%'
        and 
        value > 0
order by name;
@send;

<div class="work-head">
    <div class="centerfold">
        <p class="area-name">Stan gotówki w urządzeniu</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>Komponent</td>
            <td>Ilość</td>
            <td>Nominał</td>
            <td>Max</td>
        </tr>
    </thead>
    <tbody>
        @repeat:tran;
        <tr>
            <td>@{tran:name}</td>
            <td>@{tran:count}</td>
            <td>@{tran:value}</td>
            <td>@{tran:capacity}</td>
        </tr>
        @rend;
    </tbody>
  </table>

</div>