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

{% block title %} <strong>{{ reportName }} </strong>{% endblock %}

{% block body %}
    
    <div class="row justify-content-end">        
                
        {{ include('reportes/filters.html.twig') }}
    </div>
    
    <div class="row">
    {% set totalMonto = 0 %}                  
    {% for nombreSet, results in dataset %} 
        <div class="col">   
        <h2>    
            <span class="badge badge-info">{{ nombreSet |upper }}</span>        
        </h2>    
    
        <table class="table table-border table-hover">
        <thead class="thead-dark ">
            <tr>               
                {% for nombreColumna in results.columnas %}
                    <th>{{ splitCamelCase(nombreColumna) }}</th>                               
                {% endfor %}                                 
            </tr>
        </thead>
        <tbody>
                <tr>
                  
                {% for key, dato in results.datos %}
                    {% if dato is iterable %}
                        <tr>
                        {% for datoColumn in dato %}                            
                            
                            {% if loop.index == results.columnas|length  %}                                                            
                                {% set totalMonto = totalMonto + datoColumn %}
                                {% set datoColumn = datoColumn|number_format(2, ',', '.') %}                            
                            {% endif %}
                            
                              <td> {{ datoColumn }} </td> 
                        {% endfor %}
                        </tr>
                    {% else %}
                        {% set valor = dato %}                                               
                        {% if loop.index == results.columnas|length  %}                                                            
                            {% set totalMonto = totalMonto + dato %}
                        {% endif %}                            
                        {% if isNumeric(valor) %}                            
                            {% set valor = valor|number_format(2, ',', '.') %}                            
                        {% endif %} 
                        
                        <td> 
                            <strong>
                               {{ valor }} 
                            </strong>
                        </td>    
                        
                    {% endif %}
                    
                
            {% else %}
                
                    <td colspan="7">No existen datos</td>
                
            {% endfor %}
                </tr>
        </tbody>
    </table>  
        </div>        
    {% endfor %}
    </div>
    <div class="row"> 
        <div style="margin-left: 2%">
            <h2>
                <span class="badge {% if totalMonto > 0 %}badge-success{% else %}badge-danger{% endif %}"><strong> 
                TOTAL ${{ totalMonto|number_format(2, ',', '.') }}</strong></span>
            </h2>
        </div> 
    </div>                                    
    
{% endblock %}