{% extends reportShell|default('base.html.twig') %}
{% block title %}Antiguedad de saldos{% endblock %}
{% block page_title %}Antiguedad de saldos{% endblock %}

{% block stylesheets %}
  {% if reportShell|default('base.html.twig') == 'base.html.twig' %}
    {{ parent() }}
  {% endif %}
  {% include 'reporte/_styles.html.twig' %}
{% endblock %}

{% block breadcrumb %}
  <nav class="flex no-print" aria-label="Breadcrumb">
    <ol class="flex items-center space-x-4">
      <li><a href="{{ path('home') }}" class="text-secondary-500 hover:text-secondary-700">Inicio</a></li>
      <li class="text-secondary-300">/</li>
      <li class="text-secondary-500">Reportes</li>
      <li class="text-secondary-300">/</li>
      <li class="text-secondary-500">Antiguedad de saldos</li>
    </ol>
  </nav>
{% endblock %}

{% block report_title %}Antiguedad de saldos{% endblock %}
{% block report_subtitle %}Al {{ filtros.fechas.hasta|date('d/m/Y') }}{% endblock %}

{% block content %}
  {% set isExportView = reportShell|default('base.html.twig') != 'base.html.twig' %}
  {% set exportQuery = {'hasta': filtros.fechas.hasta} %}
  {% if filtros.proveedor_id %}
    {% set exportQuery = exportQuery|merge({'proveedor_id': filtros.proveedor_id}) %}
  {% endif %}

  <div class="{{ isExportView ? 'report-stack report-stack--export' : 'report-shell report-stack' }}">
    <div class="report-panel no-print">
      <div class="report-form-grid">
        <form method="get" class="report-form-grid">
          <div class="report-field">
            <label class="report-label" for="proveedor_id">Proveedor</label>
            <select class="report-select" id="proveedor_id" name="proveedor_id">
              <option value="">Todos los proveedores</option>
              {% for proveedor in proveedores %}
                <option value="{{ proveedor.id }}" {{ filtros.proveedor_id == proveedor.id ? 'selected' : '' }}>{{ proveedor.razonSocial }}</option>
              {% endfor %}
            </select>
          </div>
          <div class="report-field report-field--sm">
            <label class="report-label" for="hasta">Fecha de corte</label>
            <input class="report-input" type="date" id="hasta" name="hasta" value="{{ filtros.fechas.hasta }}">
          </div>
          <div class="report-actions">
            <button class="report-button report-button--primary" type="submit">Actualizar</button>
            <a class="report-link-button" href="{{ path('rep_antiguedad', exportQuery|merge({export: 'excel'})) }}">Excel</a>
            <a class="report-link-button" href="{{ path('rep_antiguedad', exportQuery|merge({export: 'excel_raw'})) }}">Excel datos</a>
            <a class="report-link-button" href="{{ path('rep_antiguedad', exportQuery|merge({export: 'pdf'})) }}">PDF</a>
            <a class="report-link-button" target="_blank" href="{{ path('rep_antiguedad', exportQuery|merge({export: 'print'})) }}">Imprimir</a>
          </div>
        </form>
      </div>
    </div>

    <div class="report-grid">
      <div class="report-card">
        <span class="report-card__label">Documentos</span>
        <span class="report-card__value">{{ stats.documentos_total|default(0) }}</span>
      </div>
      <div class="report-card">
        <span class="report-card__label">Documentos vencidos</span>
        <span class="report-card__value">{{ stats.documentos_vencidos|default(0) }}</span>
      </div>
      <div class="report-card">
        <span class="report-card__label">Saldo corriente</span>
        <span class="report-card__value">{{ stats.total_corriente|default(0)|number_format(2, '.', ',') }}</span>
      </div>
      <div class="report-card">
        <span class="report-card__label">Saldo vencido</span>
        <span class="report-card__value">{{ stats.total_vencido|default(0)|number_format(2, '.', ',') }}</span>
      </div>
    </div>

    <div class="report-panel report-panel--table">
      {{ block('report_body') }}
    </div>
  </div>
{% endblock %}

{% block report_body %}
  <div class="report-table-wrap">
    <table class="report-table report-table--dense">
      <thead>
        <tr>
          <th>Proveedor / Moneda</th>
          <th>Referencia</th>
          <th>Documento</th>
          <th>F. emision</th>
          <th>F. vencimiento</th>
          <th class="text-right">Saldo</th>
          <th class="text-right">Corriente</th>
          <th class="text-right">1 a 30</th>
          <th class="text-right">31 a 60</th>
          <th class="text-right">61 a 90</th>
          <th class="text-right">91 o mas</th>
        </tr>
      </thead>
      {% if reporte|length > 0 %}
        {% for grupo in reporte %}
          <tbody data-page-item>
            <tr class="is-group">
              <td colspan="11">{{ grupo.proveedor }} | {{ grupo.moneda }}</td>
            </tr>
            {% for doc in grupo.documentos %}
              <tr>
                <td>{{ grupo.proveedor }}</td>
                <td class="report-cell--nowrap">{{ doc.referencia }}</td>
                <td class="report-cell--nowrap">{{ doc.documento }}</td>
                <td class="report-cell--nowrap">{{ doc.f_aplicacion }}</td>
                <td class="report-cell--nowrap">{{ doc.f_vencimiento }}</td>
                <td class="text-right report-cell--nowrap">{{ doc.saldo|number_format(2, '.', ',') }}</td>
                <td class="text-right report-cell--nowrap">{{ doc.corriente > 0 ? doc.corriente|number_format(2, '.', ',') : '-' }}</td>
                <td class="text-right report-cell--nowrap">{{ doc.d01_30 > 0 ? doc.d01_30|number_format(2, '.', ',') : '-' }}</td>
                <td class="text-right report-cell--nowrap">{{ doc.d31_60 > 0 ? doc.d31_60|number_format(2, '.', ',') : '-' }}</td>
                <td class="text-right report-cell--nowrap">{{ doc.d61_90 > 0 ? doc.d61_90|number_format(2, '.', ',') : '-' }}</td>
                <td class="text-right report-cell--nowrap">{{ doc.d91_mas > 0 ? doc.d91_mas|number_format(2, '.', ',') : '-' }}</td>
              </tr>
            {% endfor %}
            <tr class="is-subtotal">
              <td colspan="5" class="text-right">Subtotal {{ grupo.proveedor }} | {{ grupo.moneda }}</td>
              <td class="text-right">{{ grupo.subtotal.total|number_format(2, '.', ',') }}</td>
              <td class="text-right">{{ grupo.subtotal.corriente|number_format(2, '.', ',') }}</td>
              <td class="text-right">{{ grupo.subtotal.d01_30|number_format(2, '.', ',') }}</td>
              <td class="text-right">{{ grupo.subtotal.d31_60|number_format(2, '.', ',') }}</td>
              <td class="text-right">{{ grupo.subtotal.d61_90|number_format(2, '.', ',') }}</td>
              <td class="text-right">{{ grupo.subtotal.d91_mas|number_format(2, '.', ',') }}</td>
            </tr>
          </tbody>
        {% endfor %}
      {% else %}
        <tbody>
          <tr data-table-empty>
            <td colspan="11" class="report-empty">No hay saldos pendientes a la fecha seleccionada.</td>
          </tr>
        </tbody>
      {% endif %}
      {% if reporte|length > 0 %}
        <tfoot>
          <tr>
            <td colspan="5" class="text-right">Total general</td>
            <td class="text-right">{{ grandTotal.total|number_format(2, '.', ',') }}</td>
            <td class="text-right">{{ grandTotal.corriente|number_format(2, '.', ',') }}</td>
            <td class="text-right">{{ grandTotal.d01_30|number_format(2, '.', ',') }}</td>
            <td class="text-right">{{ grandTotal.d31_60|number_format(2, '.', ',') }}</td>
            <td class="text-right">{{ grandTotal.d61_90|number_format(2, '.', ',') }}</td>
            <td class="text-right">{{ grandTotal.d91_mas|number_format(2, '.', ',') }}</td>
          </tr>
        </tfoot>
      {% endif %}
    </table>
  </div>
{% endblock %}