{% extends "@index/base.html.twig" %}

{% set page_id = 'backend' %}
{% set noindex = true %}
{% set oneColumn = true %}

{% set page = page > 0 ? page : 1 %} 

{% 
    set tooltips = {
        'password':'La contraseña está encriptada y solo es posible generar una nueva, no puede desencriptarse',
    } 
%}

{%
    set filters = {
        'today':'Hoy',
        'yesterday':'Ayer',
        'last_days':'Últimos días',
        'last_items':'Últimos comentarios',
        'active_items':'Comentarios activos',
    } 
%}

{% set noShow = ['ancestors','depth','guest_name'] %}   

{% block titulo %}Backend Búsquedas{% endblock %}

{% block lang %}{% endblock lang %}

{% block stylesheet %}
    {{ parent() }}
    <link rel="stylesheet" href="{{ SITE_URL }}css/jquery-ui-1.10.3.custom.min.css" />
    <link rel="stylesheet" href="{{ SITE_URL }}css/jqueryui-editable.css" />
{% endblock stylesheet %}

{% block bread %}

    {{ breadCrumbs | raw }}

    <form method="post" class="form" action="{{ url('backend-search') }}">
        <ul class="filters">       
            <li>
                <fieldset>
                    <p class="head">Filtro por fecha de registro (Create at)</p>            
                    <input type="text" id="from" name="date_start" value="{{ date_start ? date_start | date('d-m-Y') : '' }}" placeholder="Fecha inicio rango" />
                    <input type="text" id="to" name="date_end" value="{{ date_end ? date_end | date('d-m-Y') : '' }}" placeholder="Fecha fin rango" />
                </fieldset>
                <fieldset>
                    <p class="head">&nbsp;</p>
                    <input type="submit" value="Filtrar" class="button bGreen" />
                    {% if date_start or date_end or search or filter_predefined %}
                        <input type="submit" name="reset" value="Reset" class="button bRed" />
                    {% endif %}
                </fieldset>
            </li>
            <li>
                <h3><span class='counterT'>{{ numTotalItems }}</span> Registros</h3>            
            </li>
        </ul>
    </form>

{% endblock bread %}

{% block oneOne %}               
    
    <article class="dinamic">
        <h1>Gestor de Búsquedas</h1>
        <div>
            {% if date_start or date_end or search or filter_predefined %}
                <strong>Filtros: </strong>
            {% endif %}
            {% if (date_start or date_end) and filter_predefined not in 'today,yesterday' %}
                <span>Entre el {{ dateFormat(date_start) }} y el {{ dateFormat(date_end) }}</span>
            {% endif %}
            {% if search %}
                <span>{{ search }}</span>
            {% endif %}
            {% if filter_predefined is not empty and filter_predefined != 'last_days' %}
                <span>{{ filters[filter_predefined] }}</span>
            {% endif %}                

            <h2><b class='counterS'>{{ numItems }}</b> registros seleccionados</h2>
        </div>
    </article>
    
    <table class="grill searches">

        {% for row in items %}

            {% if loop.first %}
                <thead>
                    <tr>
                        <td></td>
                        {% for k,v in row %}
                            {% if k not in noShow %}
                                <td data-order="{{ k }}" class="tooltip" title="{{ tooltips[k] }}">
                                    <span data-mode="ASC" {{ order == k ~ ' ASC' ? 'class="current"' : '' }}></span>
                                    <span data-mode="DESC" {{ order == k ~ ' DESC' ? 'class="current"' : '' }}></span>
                                    {{ k | replace({"_":" "}) | capitalize }}
                                </td>
                            {% endif %}
                        {% endfor %}
                        <td></td>
                    </tr>
                    </thead>
            {% endif %}

            {{ loop.first ? '<tbody>' : '' }}                    

            <tr>
                <td>{{ loop.index + ((page - 1) * limit) }}</td>
                {% for k,v in row %}
                    {% if k not in noShow %}
                        <td>                           
                            {% if k in 'create_at' %}
                                <a href="#" class="editable" id="{{ k }}" data-format="yyyy-mm-dd" data-viewformat="dd-mm-yyyy" data-type="date" data-pk="{{ row.id }}" data-url="{{ url('backend-search-editable') }}" data-title="Introduce {{ k | replace({"_":" "}) | capitalize }}">
                                    {{ v  | date('d-m-Y H:i') }}
                                </a>                                 
                            {% elseif k in 'search,user_ip,referer' %}
                                <a href="#" class="editable" id="{{ k }}" data-type="text" data-pk="{{ row.id }}" data-url="{{ url('backend-search-editable') }}" data-title="Introduce {{ k | replace({"_":" "}) | capitalize }}">
                                    {{ v  | truncate(60, true) }}
                                </a>
                            {% else %}
                                {{ v }}
                            {% endif %}
                        </td> 
                    {% endif %}
                {% endfor %}          
                <td class="delete">
                    <a class="iconDel" id="{{ row.id }}" href="{{ url('backend-search-delete') }}" title="Eliminar">
                        Eliminar
                    </a>                          
                </td>                          
            </tr>        

            {{ loop.last ? '</tbody>' : '' }}

        {% endfor %}
    
    </table>

    {{ paginador | raw }}            

    <form name="order" method="post" action="{{ url('backend-search') }}">
        <input type="hidden" name="order" value="" />
        <input type="hidden" name="mode" value="" />
    </form>

    <small class="version">Versión: 1.0</small>
    
{% endblock oneOne %}

{% block javascript %} 

    {{ parent() }}

    <script src="{{ SITE_URL }}js/jquery-ui-1.10.3.custom.min.js" type="text/javascript"></script>
    <script src="{{ SITE_URL }}js/jqueryui-editable.js" type="text/javascript"></script>
    
    <script>
        
        
        $(function() {
            
            $('.editable').editable({
                placement: 'top', // top|right|bottom|left
                params: function(params) {
                    params.reg_date = $(this).data('reg_date');
                    return params;
                },   
                ajaxOptions: {
                    dataType: 'json'
                },                
                success: function(response, newValue) {      
                    if(response.status == 'error') return response.msg;
                    if(response !== 'ok'){
                        alert('Error');
                    }
                }                
            });            
            
            
            $( "#from" ).datepicker({
                dayNamesMin: [ "Do", "Lu", "Ma", "Mi", "Ju", "Vi", "Sa" ],
                monthNames: [ "Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre" ],
                firstDay: 1,
                dateFormat: "dd-mm-yy",
                changeMonth: true,
                changeYear: true,
                numberOfMonths: 1,
                showOtherMonths: true,
                selectOtherMonths: true,
                onClose: function( selectedDate ) {
                    $( "#to" ).datepicker( "option", "minDate", selectedDate );
                }
            });
            $( "#to" ).datepicker({
                dayNamesMin: [ "Do", "Lu", "Ma", "Mi", "Ju", "Vi", "Sa" ],
                monthNames: [ "Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre" ],
                firstDay: 1,
                dateFormat: "dd-mm-yy",
                changeMonth: true,
                changeYear: true,
                numberOfMonths: 1,
                showOtherMonths: true,
                selectOtherMonths: true,                
                onClose: function( selectedDate ) {
                    $( "#from" ).datepicker( "option", "maxDate", selectedDate );
                }
            });
        });
    </script>        
        
    
{% endblock javascript %}