{% extends 'base_admin.html.twig' %}

{% block title %}Financial index{% endblock %}

{% block body %}
    <h1 style="color: red">All Pubs - Financials.</h1>
    {% if is_granted('ROLE_ADMIN')  %}
        <a class="btn btn-success btn-sm" href="{{ path('dashboard_financial_new') }}">New</a>
    {% endif %}
    <table class="table">
        <thead>
        <tr>
            <th>Pub</th>
            <th>Description</th>
            <th>Date range</th>
            <th>Comments</th>
            <th>Received</th>
            <th>Attachment</th>
        </tr>
        </thead>
        <tbody>
        {% for financial in financials %}
            {% set pub = financial.pub %}
            {% if is_granted('PUB_ACCESS', pub) or is_granted('ROLE_ADMIN') or is_granted('ROLE_MANAGER') %}
                <tr>
                    <td> {{ financial.pub.name }}</td>
                    <td> <a href ="{{ path('dashboard_financial_show', {'id': financial.id}) }}"> {{ financial.descriptor }}</td>
                    <td>{{ financial.year }}</td>
                    <td>
                        {{financial.comments2}}
                    </td>
                    {% if financial.dateReceivedAt is not null %}
                        <td data-sort="{{ financial.dateReceivedAt.format('Y-m-d') }}"> {{ financial.dateReceivedAt.format('d-M-Y') }}
                        </td>
                    {% else %}
                        <td>
                            -
                        </td>
                    {% endif %}

                    <td>
                        <ul>
                            {% for attachment  in financial.attachments %}
                                <li><a href="/admin/attachments/financials/{{ attachment.attachmentName }}">{{ attachment.attachmentName }}</a></li>
                            {% endfor %}
                        </ul>
                    </td>

                </tr>
            {% endif %}
        {% else %}
            <tr>
                <td colspan="3">no records found</td>
            </tr>
        {% endfor %}
        </tbody>
    </table>

{% endblock %}

  {% block datatable %}
      <script>
          $(document).ready( function () {
              $('.table').DataTable({
                  'pageLength': 100,
                  "paging":   false,
                  "order": [[ 4, 'desc' ]]
              });


          });
      </script>
  {% endblock datatable %}