{% extends "include/_base.twig" %}

{% set title = "Buchungen" %}
{% set auth = true %}

{% block content %}

<div class="page-card m-h-20">
  <a href="/index.html">Startseite</a>&nbsp;|&nbsp;
  {{title}}
</div>

{% if urlParam['sort'] is null %}
  {% set sort = "date" %}
{% else %}
  {% set sort = urlParam['sort'] %}
{% endif %}

{% if (urlParam['desc'] is null or urlParam['desc'] == "desc") %}
  {% set order = sort ~ " desc" %}
  {% set desc = "asc" %}
  {% set isDesc = "desc" %}
{% else %}
  {% set order = sort ~ " asc" %}
  {% set desc = "desc" %}
  {% set isDesc = "asc" %}
{% endif %}

{% if urlParam['fromDate'] is not null %}
  {% set fromDate = urlParam['fromDate'] %}
{% endif %}

{% if urlParam['toDate'] is not null %}
  {% set toDate = urlParam['toDate'] %}
{% endif %}

{% if urlParam['entries'] is not null %}
  {% set entries = urlParam['entries'] %}
{% else %}
  {% set entries = "50" %}
{% endif %}

{% if toDate and fromDate %}
  {% set where = "buchung.date >= '" ~ fromDate ~ "' and buchung.date <= '" ~ toDate ~ "'" %}
{% elseif toDate and not fromDate %}
  {% set where = "buchung.date <= '" ~ toDate ~ "'" %}
{% elseif not toDate and fromDate %}
  {% set where = "buchung.date >= '" ~ fromDate ~ "'" %}
{% endif %}

{% set maxPage = 'maxPage'|main(order=order, where=where, entries=entries) %}

{% if (urlParam['page'] is null or urlParam['page'] <= "1" ) %}
  {% set previewPage = "1" %}
  {% set nextPage = "2" %}
  {% set currentPage = "1" %}
  {% set page = "0" %}
{% else %}
  {% if urlParam['page'] > maxPage %}
    {% set previewPage = maxPage-1 %}
    {% set nextPage = maxPage %}
    {% set currentPage = maxPage %}
    {% set page = previewPage %}
  {% else %}
    {% set previewPage = urlParam['page']-1 %}
    {% set nextPage = urlParam['page']+1 %}
    {% set currentPage = urlParam['page'] %}
    {% set page = urlParam['page']-1 %}
  {% endif %}
{% endif %}

<div class="page-card">
  <div class="card-page__border-left">&nbsp;</div>
  <div class="teaser-box">
    <div class="box_85">
      <h3 class="card-page__title">Buchungsübersicht</h3>
    </div>
    <div>
      <a href="buchung-edit.html" class="btn btn--success btn__form">Neue Buchung anlegen</a>
    </div>
  </div>

  <form method="get" action="buchung.html" class="teaser-box m-b-0 no-wrap">
    <div class="form__entry">
      <label for="fromDate" class="control-label">Buchungen ab</label>
      <input type="date" class="form-control" id="fromDate" name="fromDate" value="{{fromDate}}" placeholder="Buchungen ab">
    </div>
    <div class="form__entry">
      <label for="toDate" class="control-label">Buchungen bis</label>
      <input type="date" class="form-control" id="toDate" name="toDate" value="{{toDate}}" placeholder="Buchungen bis">
    </div>
    <div class="form__entry">
      <label for="entries" class="control-label">Anzahl Einträge pro Seite</label>
      <select id="entries" name="entries" class="form-control">
        <option value="5" {% if entries == "5" %} selected {% endif %}>5</option>
        <option value="25" {% if entries == "25" %} selected {% endif %}>25</option>
        <option value="50" {% if entries == "50" %} selected {% endif %}>50</option>
        <option value="100" {% if entries == "100" %} selected {% endif %}>100</option>
        <option value="150" {% if entries == "150" %} selected {% endif %}>150</option>
        <option value="250" {% if entries == "250" %} selected {% endif %}>250</option>
        <option value="500" {% if entries == "500" %} selected {% endif %}>500</option>
        <option value="1000" {% if entries == "1000" %} selected {% endif %}>1000</option>
      </select>
    </div>
    <div class="form__entry">
      <button class="btn btn--success btn__form m-t-18" id="btn_send">senden</button>
    </div>
    <div class="form__entry t-a-e">
      <a href="?" class="btn btn--success btn__form">alle Filter löschen</a>
    </div>
  </form>

  {% set buchungen = 'buchungen'|main(order=order, page=page, where=where, entries=entries) %}
  <table>
    <thead>
    <tr>
      <th><a href="?sort=date&desc={{desc}}&page={{currentPage}}&fromDate={{fromDate}}&toDate={{toDate}}&entries={{entries}}">Datum</a></th>
      <th><a href="?sort=value&desc={{desc}}&page={{currentPage}}&fromDate={{fromDate}}&toDate={{toDate}}&entries={{entries}}">Wert</a></th>
      <th><a href="?sort=konto&desc={{desc}}&page={{currentPage}}&fromDate={{fromDate}}&toDate={{toDate}}&entries={{entries}}">Konto</a></th>
      <th><a href="?sort=verwendung&desc={{desc}}&page={{currentPage}}&fromDate={{fromDate}}&toDate={{toDate}}&entries={{entries}}">Verwendungszweck</a></th>
      <th><a href="?sort=wertstellung&desc={{desc}}&page={{currentPage}}&fromDate={{fromDate}}&toDate={{toDate}}&entries={{entries}}">Wertstellung</a></th>
      <th><a href="?sort=fixed&desc={{desc}}&page={{currentPage}}&fromDate={{fromDate}}&toDate={{toDate}}&entries={{entries}}">Fix</a></th>
      <th>&nbsp;</th>
    </tr>
    </thead>
    <tbody>
      {% for item in buchungen %}
        <tr>
          <td data-label="Datum">{{ item.date|date("d.m.Y") }}</td>
          <td data-label="Wert">{{ (item.value)|number_format(2, '.', ',') }} €</td>
          <td data-label="Konto">{{ item.konto }}</td>
          <td data-label="Verwendung">{{ item.verwendung }}</td>
          <td data-label="Wertstellung">{{ item.wertstellung }}</td>
          <td data-label="fixed">{% if item.fixed == 0 %} Nein {% else %} Ja {% endif %}</td>
          <td data-label="Optionen">
            <a href="/buchung-edit.html?id={{item.id}}">edit</a>
            <a href="/buchung-delete.html?id={{item.id}}">delete</a>
          </td>
        </tr>
      {% endfor %}
    </tbody>
  </table>

<div class="teaser-box m-t-18">
  <div class="box_50">
    {% if currentPage > "1" %}
      <a href="?sort={{sort}}&desc={{isDesc}}&page={{previewPage}}&fromDate={{fromDate}}&toDate={{toDate}}&entries={{entries}}">Vorherige Seite</a>
      {% if currentPage < maxPage %}
        &nbsp;|&nbsp;
      {% endif %}
    {% endif %}
    {% if currentPage < maxPage %}
      <a href="?sort={{sort}}&desc={{isDesc}}&page={{nextPage}}&fromDate={{fromDate}}&toDate={{toDate}}&entries={{entries}}">Nächste Seite</a>
    {% endif %}
  </div>
  <div class="box_50 t-a-e">
    <span>Seite {{currentPage}} von {{maxPage}}</span>
  </div>
</div>


</div>
{% endblock %}