{% 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 nombreCol, datoColumn in dato %}
                           
                            <td>
                                {% if nombreCol == 'TotalGastos' or nombreCol == 'totalIngresos' %}                            
                                    {{ datoColumn|number_format(2, ',', '.') }}                            
                                {% elseif nombreCol == 'Caso'  %}
                                    
                                    <a href="{{ path('caso_edit', {'id': datoColumn}) }}" target="_blank" class="btn " style="color: #{{colorTexto(dato['numero']) }} ; background-color: #{{ stringToHexa(dato['numero']) }}"> 
                                        {{ dato['numero'] }} 
                                    </a>
                                                                     
                                {% elseif nombreCol == 'UltimoGasto'  %}
                                    {{ datoColumn | date('d/m/Y') }}                                 
                                {% elseif nombreCol == 'etapa'  %}
                                    <h2>
                                    <span class="badge badge-lg " style="color: #{{colorTexto(datoColumn) }} ; background-color: #{{ stringToHexa(datoColumn) }}"> 
                                        {{ datoColumn | upper }} 
                                    </span>
                                    </h2>
                                {% else %}
                                    {{ datoColumn }} 
                                    
                                {% endif %}
                            </td> 
                            
                        {% endfor %}
                        </tr>
                    {% else %}
                        {% set valor = dato %}                                               
                        {% if loop.index == results.datos|length  %}                                                            
                            {% set totalMonto = totalMonto + dato %}
                        {% endif %}                            
                        {% if isNumeric(valor) %}                            
                            {% set valor = valor|number_format(2, ',', '.') %}                            
                        {% endif %} 
                        
                        <td> 
                            <strong>
                              NO ES ITERABLE {{ 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 %}