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

{% block dashboard %}
    <style>
        .wrapper{padding-bottom:50px;}
        .header{background:#000000;}.header .container{padding-bottom:20px;}.header .container h1{color:#FFF;line-height:50px;margin-top:30px;margin-bottom:0;}
        .header .container h3{color:#E0E0E0;font-size:16px;margin-top:-5px;}.header .container h3 a{color:#66aacc;}.header .container h3 a:hover{color:#b3d5e6;}
        .top-menu{position:absolute;z-index:9999;}.top-menu .nav-list{background:rgba(255, 255, 255, 0.8);border:1px solid #CCC;margin:20px;position:fixed;right:0;}
        pre,.well{background:#FFFFFF;}
        .syntax-container{background:#FCFCFC;-webkit-border-radius:7px;-webkit-background-clip:padding-box;-moz-border-radius:7px;-moz-background-clip:padding;border-radius:7px;background-clip:padding-box;border:1px solid #e3e3e3;margin-bottom:30px;padding-bottom:20px;}
        .isloading-wrapper.isloading-right{margin-left:45%;}
        .isloading-overlay{position:relative;text-align:center;}.isloading-overlay .isloading-wrapper{background:#FFFFFF;-webkit-border-radius:7px;-webkit-background-clip:padding-box;-moz-border-radius:7px;-moz-background-clip:padding;border-radius:7px;background-clip:padding-box;display:inline-block;margin:0 auto;padding:10px 20px;top:10%;z-index:9000;}

        /*Glyphicon Spinner*/
        .glyphicon-spin {
            -animation: spin .9s infinite linear;
            -webkit-animation: spin2 .9s infinite linear;
        }

        @-webkit-keyframes spin2 {
            from { -webkit-transform: rotate(0deg);}
            to { -webkit-transform: rotate(360deg);}
        }

        @keyframes spin {
            from { transform: scale(1) rotate(0deg);}
            to { transform: scale(1) rotate(360deg);}
        }
        
        .table-responsive {
            height: 400px !important;
            overflow: scroll;
        }
        
         .btn-claro {
            color: #fff;
            background-color: #aa0001;
            border-color: #e06a70;
        }
        
        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
        }

        .table th{
            font-size: 9pt;
        }
        .table td{
            font-size: 9pt;
        }

       .btn-yellow {
            background-color: #ffff0c;
            color: #000000;
            background-image: -moz-linear-gradient(top, #ecea19, #ecea19);
            background-image: -ms-linear-gradient(top, #ecea19, #ecea19);
            background-image: -webkit-gradient(linear, 0 0, 0 100%, from(#ecea19), to(#ecea19));
            background-image: -webkit-linear-gradient(top, #ecea19, #ecea19);
            background-image: -o-linear-gradient(top, #ecea19, #ecea19);
            background-image: linear-gradient(top, #ecea19, #ecea19);
            background-repeat: repeat-x;
            filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#'78cd51, endColorstr='#'5AAD34, GradientType=0);
            border-color: #ecea19 #ffff0c #ecea19;
            border-color: rgba(0, 0, 0, 0.1) rgba(0, 0, 0, 0.1) rgba(0, 0, 0, 0.25);
            filter: progid:DXImageTransform.Microsoft.gradient(enabled = false);
        }
        .btn-yellow {
            color: #fff;
            background-color: #000000;
            border-color: #ecea19;
        }

        .col-lg-12{
            padding-left: 5px;
        }

        #menuTop { margin-top: 15px; }

        hr { width: 75%; margin: auto; margin-top: 20px; margin-bottom: 20px;}
        
        ._hr { display: none; } 

    </style>
    
    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-12">
                <img id="logo" class="pull-right" src="{{ asset('images/claro.jpg') }}"  width="220" height="72" >
             </div>
        </div>
    
             
        <div class="row">
            <div class="col-lg-2" style="margin-top: 1%">
                <label>{{'monitores.pais' | trans}}: </label>                 
                <select class="form-control" id="pais">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    {%for pais in paises%}
                        <option value="{{pais.eval_proyecto_id}}">{{pais.nombre}}</option>
                    {%endfor%}
                </select>
            </div> 
            <div class="col-lg-2"  style="margin-top: 1%">
                <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>  
                <input type="text" class="form-control hasDatepicker" id="Filtros_fechaIni" value="{{ dateStart }}">
            </div>
            <div class="col-lg-2"  style="margin-top: 1%">
                <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>  
                <input type="text" class="form-control hasDatepicker" id="Filtros_fechaFin" value="{{ dateEnd }}">
            </div>
            <div class="col-lg-2"  style="margin-top: 1%">
                <label>{{'monitor.etiqueta.region' | trans}}: </label>
                <select class="form-control" id="region">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                </select>
            </div>
            <div class="col-lg-2"  style="margin-top: 1%">
                 <label>{{'Visita' | trans}}: </label>
                 <select class="form-control" id="visita">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    <option value="1">{{'SIN VISITA' | trans}}</option>
                    <option value="0">{{'CON VISITA' | trans}}</option>
                </select>
            </div>
            <div class="col-lg-2" id="parametros" style="margin-top: 1%">
               <button class="btn btn-claro" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
               <button class="btn btn-claro" id="clear">{{'ticketDetail.boton.limpiar' | trans}}</button>              
            </div>                
        </div>                
            
        <div class="row">
            <hr class="_hr">
            <div class="col-lg-12" id="_dailyGraph"></div>
            <hr class="_hr">
            <div class="col-lg-12" id="_monthGraph"></div>
            <hr class="_hr">
        </div>
            
        <div class="row">
            <div class="col-lg-12 text-center"  style="margin-top: 1%">
                <h1>{{'MANTENIMIENTOS PREVENTIVOS PROGRAMADOS' | trans}}</h1>
            </div>
        </div>
            
        <div class="row">
            <div class="col-lg-3"  style="margin-top: 1%">
                Total:&nbsp;<span id="cantidad" class="bold"></span><br>
                {{'Planificados' | trans}}:&nbsp;<span id="_planed" class="bold">0</span><br>
                {{'Cumplidos' | trans}}:&nbsp;<span id="_done" class="bold">0</span><br>
            </div>
            <div class="col-lg-offset-9"  style="margin-top: 1%">
                <div class="btn-group pull-right">
                    <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                    <ul class="dropdown-menu" role="menu">
                        <li><a href="#" onclick="$('#primer_reporte').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                    </ul>
                </div>
            </div>
        </div>
                    
        <div class="row" style="margin-bottom: 40px;">
            <div class="col-lg-12" id="primer_reporte" style="margin-top: 1%; font-size: 13px;"></div>
        </div>

    </div>        


{#    <div class="modal fade" id="myModalDetalle" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header  bg-primary">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                    <h2 class="modal-title text-center" id="myModalLabel">DETALLE VISITAS</h2>
                </div>

                <div class="modal-body">
                </div>
                
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                </div>

            </div>
        </div>
    </div>#}
    <div class="modal" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-body"></div>
                <div class="modal-footer">
                <button type="button" class="btn btn-danger" data-dismiss="modal">
                    {{'inbox.all' | trans}}&nbsp;<span class="glyphicon glyphicon-remove"></span>
                </button>
                </div>
            </div>
        </div>
    </div>
                    
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script src="{{ asset('js/jquery.numeric.js') }}"></script>
    <script src="{{ asset('js/jquery.form.js') }}"></script>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script>
        
        var translation = {
        };

        $(function () {
            
            var $btnGenerar = $("#generar"),
                $amount     = $("#cantidad"),
                $dateStart  = $('#Filtros_fechaIni'),
                $dateEnd    = $('#Filtros_fechaFin'),
                $btnClear   = $("#clear"),
                $country    = $("#pais"),
                $region     = $("#region"),
                $tankType   = $("#tipoTanque");
            
            $btnGenerar.click(function(){
                loading(1);
                $amount.html(0);
                reporteBateria();
            });
            
            $dateStart.datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function( selectedDate ) {
                    $dateEnd.datepicker( "option", "minDate", selectedDate );
                }
            }); 

            $dateEnd.datepicker({
                dateFormat: 'yy-mm-dd',
            });  
            
            $btnClear.click(function(){
                $country.val();
                $region.val("TODOS");      
                $tankType.val("TODOS");     
                $dateStart.val("");
                $dateEnd.val("");                   
            });             
            
            {% if idproyectos == 35 or idproyectos == 30 or idproyectos == 32 or idproyectos == 36 or idproyectos == 37 or idproyectos == 38 %} 
                   {% if idproyectos == 35 %} {% set idpais=1 %} {% set pais='Guatemala' %}{% endif %}
                   {% if idproyectos == 30 %} {% set idpais=2 %} {% set pais='Honduras' %}{% endif %} 
                   {% if idproyectos == 32 %} {% set idpais=4 %} {% set pais='Nicaragua' %}{% endif %}   
                   {% if idproyectos == 36 %} {% set idpais=3 %} {% set pais='El Salvador' %}{% endif %}        
                   {% if idproyectos == 37 %} {% set idpais=5 %} {% set pais='Costa Rica' %}{% endif %}  
                   {#Para reunion con telefonica se incluyo el reporte en el proyecto 38#}
                   {% if idproyectos == 38 %} {% set idpais=3 %} {% set pais='El Salvador' %}{% endif %}  
                   $("#pais option").remove(); 
                   $country.append('<option value={{ idpais }}>{{ pais }}</option>');
                    
                    //Llenar Combos
                    loading(1);
                    llenarCombos();
            {%endif%}
                
            $country.change(function(){
                
                if ( $country.val() != "TODOS" ) {
                    
                    loading(1);
                    llenarCombos();
               
                } else {                
                    
                    $("#region option").remove(); 
                    $region.append('<option value="TODOS">TODOS</option>');   
                }
               
                $btnGenerar.trigger('click');
                
            });  

            $btnGenerar.trigger('click');
            
        });

        function loading(value){
            
            if ( value === 1 ) { $.isLoading({ text: "Loading" }); } else { $.isLoading("hide"); }
            
        }

        function reporteBateria(){

            var $dateStart  = $('#Filtros_fechaIni'),
                $dateEnd    = $('#Filtros_fechaFin'),
                $visit      = $("#visita"),
                $country    = $("#pais"),
                $region     = $("#region"),
                $firstRep   = $("#primer_reporte"),
                $cantidad   = $("#cantidad"),
                $_planed    = $("#_planed"),
                $_done      = $("#_done"),
                $monthGraph = $("#_monthGraph"),
                $dailyGraph = $("#_dailyGraph"),
                $hr         = $("._hr"),
                data = {};

            data['visita']      = $visit.val();
            data['region']      = $region.val();
            data['pais']        = $country.val();  
            data['fechaIni']    = $dateStart.val();  
            data['fechaFin']    = $dateEnd.val(); 
            
            $.getJSON('{{path('reportemshonduras_reportePP')}}', data, function (data) {

               {# console.log(data);#}
                var bateria     = data.bateria,
                    /*planMes     = data.planMes,
                    cumplidoMes = data.cumplidoMes,
                    sinPlanMes  = data.sinPlanMes,
                    */planDia     = data.planDia,
                    cumplidoDia = data.cumplidoDia,
                    sinPlanDia  = data.sinPlanDia,
                    days        = data.days,
                    mDataGraph  = data.monthGraph,
                    _days       = [],
                    ddPlan      = [],
                    ddCumplidos = [],
                    ddSinPlan   = [],
                    dmPlan      = [], 
                    dmCumplidos = [], 
                    dmSinPlan   = [],
                    dmProm      = [],
                    /*dmPlan      = [null, null, null, null, null, null, null, null, null, null, null, null],
                    dmCumplidos = [null, null, null, null, null, null, null, null, null, null, null, null],
                    dmSinPlan   = [null, null, null, null, null, null, null, null, null, null, null, null],
                    */mSeries, $auxT,
                    dSeries;
                    
                $monthGraph.empty();
                $dailyGraph.empty();
                $hr.show();

                if ( bateria.length == 0 ) {

                    $firstRep.empty();
                    $firstRep.append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                    loading(0);
                    return false;

                }
                
                // --- MESES ---
                
                if ( mDataGraph.length > 0 ) {
                    {#console.log(mDataGraph);#}
                    var n1, n2, n3;
                    for ( var i in mDataGraph ) {
                        n1 = parseInt(mDataGraph[i].sitesPlan);
                        n2 = parseInt(mDataGraph[i].sitesCumplidos)
                        n3 = parseInt(mDataGraph[i].sitesVisitados)                       
                        n1 = isNaN(n1) ? null : n1;
                        n2 = isNaN(n2) ? null : n2;
                        n3 = isNaN(n3) ? null : n3;
                        dmPlan.push(n1);
                        dmCumplidos.push(n2);
                        dmSinPlan.push(n3);
                        
                        {#dmPlan.push(parseInt(mDataGraph[i].sitesPlan));
                        dmCumplidos.push(parseInt(mDataGraph[i].sitesCumplidos));
                        dmSinPlan.push(parseInt(mDataGraph[i].sitesVisitados));#}
                    }
                    
                    dmProm = getProm(dmPlan, dmCumplidos);
                    
                    mSeries = [
                        {
                            name: 'Planificados',
                            data: dmPlan
                        },{
                            name: 'Planificado Ejecutados',
                            data: dmCumplidos
                        },{
                            name: 'Ejecutados Sin Planificación',
                            data: dmSinPlan
                        },{
                            type: 'spline',
                            name: 'Promedio',
                            data: dmProm,
                            yAxis: 1,
                            marker: {
                                lineWidth: 2,
                                lineColor: Highcharts.getOptions().colors[3],
                                fillColor: 'white'
                            }
                        }];
                    
                    $monthGraph.highcharts(columnChart(1, mSeries));
                }
                
                // --- DÍAS ---
                for ( var i in days ) {    
                        
                    _days.push(days[i].date);
                    ddPlan.push(null);
                    ddCumplidos.push(null);
                    ddSinPlan.push(null);

                }
                    
                if ( _days.length > 40 ) {
                    
                    $dailyGraph.append('<div class="alert alert-warning col-lg-5 col-lg-offset-2" role="alert">RANGO DE FECHAS MUY AMPLIO PARA GRAFICAR</div>');
                
                } else if ( planDia.length > 0 || cumplidoDia.length > 0 || sinPlanDia.length > 0 ) {
                    
                    
                    for ( var i in planDia ) {                        
                        ddPlan[_days.indexOf(planDia[i].ultima_fecha_plan)] = parseInt(planDia[i].sites);                    
                    }
                    
                    for ( var i in cumplidoDia ) {  
                        ddCumplidos[_days.indexOf(cumplidoDia[i].ultima_fecha_plan)] = parseInt(cumplidoDia[i].sites);                     
                    }

                    for ( var i in sinPlanDia ) {  
                        ddSinPlan[_days.indexOf(sinPlanDia[i].ultima_fecha_visita)] = parseInt(sinPlanDia[i].sites);                    
                    }                  

                    dmProm = getProm(ddPlan, ddCumplidos);

                    dSeries = [
                        {
                            name: 'Planificados',
                            data: ddPlan
                        },{
                            name: 'Planificado Ejecutados',
                            data: ddCumplidos
                        },{
                            name: 'Ejecutados Sin Planificación',
                            data: ddSinPlan
                        },{
                            type: 'spline',
                            name: 'Promedio',
                            data: dmProm,
                            yAxis: 1,
                            marker: {
                                lineWidth: 2,
                                lineColor: Highcharts.getOptions().colors[3],
                                fillColor: 'white'
                            }
                        }];                   
                            
                    $dailyGraph.highcharts(columnChart(2, dSeries, _days));
                
                } else {
                    
                    $dailyGraph.append('<div class="alert alert-warning col-lg-4 col-lg-offset-2" role="alert">SIN DATOS SUFICIENTES PARA GRAFICAR</div>');
                
                }
                
                $_planed.html('');
                $_done.html('');
                if ( planDia.length > 0 && cumplidoDia.length > 0 ) {
                    
                    var _planed = 0, 
                        _done   = 0;
                    
                    for ( var i in planDia ) {
                        _planed += parseInt(planDia[i].sites);
                    }
                    for ( var i in cumplidoDia ) {
                        _done += parseInt(cumplidoDia[i].sites);
                    }
                    
                    $_planed.html(_planed);
                    $_done.html(_done);
                }
                $cantidad.html(bateria.length);
                $firstRep.empty().append(createTable(bateria));
                $auxT = $($firstRep.children()[0]);
                $auxT.attr("id", "_t1");
                $auxT.removeClass("table-striped");
                color2Table('_t1', '6', 'SIN VISITA', 'ff0000');
                loading(0);

            });
       }

       function getProm(target, acum) {
            
            var prom = [],
                value;
            
            for (var i in target) {
                
                if ( target[i] && target[i] > 0 ) {
                    
                    value = parseFloat( (acum[i] * 100 / target[i]).toFixed(2) );
                    
                } else {
                    
                    value = null;
                    
                }
                
                prom.push(value);
            } 
            
            return prom;
       }

        function getTotal(valor,key,tipo) {
            
            var total   = new Array(),
                header  = Object.keys(valor[0]);

                for(var i = 0; i< valor.length;i++){

                    for(var j = 0; j< key.length;j++){

                        if(typeof total[key[j]] === "undefined"){
                            total[key[j]] = 0;
                        }
                        
                    if (tipo==1){
                        total[key[j]] +=  parseFloat(valor[i][header[key[j]]]);
                        if (i == (valor.length-1)) total[key[j]]=parseFloat(total[key[j]]).toPrecision(3);
                    //alert(total[key[j]]);
                    }
                    else
                        total[key[j]] +=  parseInt(valor[i][header[key[j]]]);

                    }
                    
                }
            return total;
        }

        function createTable(monitor,total,nombreColTotal){
            
            var header = Object.keys(monitor[0]);
            var table = '<table  class="table table-bordered table-hover table-striped table-responsive"> <thead>' +

                    '<tr class="btn-claro">';

            for (var j = 0; j < header.length; j++) {

                 if(header[j] != 'CLASS'){
                table += "<th style='vertical-align:middle;' class='text-center'>" + header[j] + "</th>"
                }

            }
            table += "</tr></thead>";

            for (var i = 0; i < monitor.length; i++) {
                table += "<tr id="+monitor[i]['TCIKET']+">";
                for (var j = 0; j < header.length; j++) {
                        var clases   = '';
                    if(header[j] == '% TANQUE'){

                             var porcentaje = parseInt(monitor[i][['% TANQUE']]);

                            if(porcentaje < 50){
                                clases = 'btn-danger';
                            }else if(porcentaje >= 80){

                                clases = 'btn-success'
                            }else if(porcentaje < 80 && porcentaje >= 70){

                                clases = 'btn-yellow';
                            }else{
                                 clases = 'btn-warning';
                            }
                    }

                table += "<td class="+clases+">" + monitor[i][header[j]]  + "</td>";

                }
                table += "</tr>";

                if(typeof total !== "undefined") {

                    if (i == monitor.length - 1) {

                        var headerTotal = Object.keys(total);
                table += '<tr><td>' + nombreColTotal +'</td>';

                        for(var x=0; x<headerTotal.length;x++){
                            table += '<td>';
                                table += total[headerTotal[x]];

                            table += '</td>';

                        }
                        table += '</tr>';
                    }
                }
            }
            table += "</table>";

            return table;
        }
        
        function color2Table(_table, indice, str, color) {
            /*
             *  Para colorear tablas (Parametros):
             *  1. ID de tabla (selector).
             *  2. Indice a colorear.
             *  3. Valor de búsqueda a colorear.
             *  4. HEX de Color.
             */
            var lenTable    = $("#" + _table + " > tbody tr" ).length,
                $auxTd;
            
            for ( var i = 0; i < lenTable; i++ ) {
                
                $auxTd = $("#" + _table + " > tbody > tr:eq(" + i + ") > td:eq(" + indice + ")");
                
                if ( $auxTd.html() == str ) {
                    
                    $auxTd.attr("bgColor", color);
                    
                }
            }    
        }

        function columnChart(op, series, categories) {
            
            var obj = {},
                name;
            
            if ( op == 1 ) {
                
                categories = [
                            'Jan',
                            'Feb',
                            'Mar',
                            'Apr',
                            'May',
                            'Jun',
                            'Jul',
                            'Aug',
                            'Sep',
                            'Oct',
                            'Nov',
                            'Dec'
                        ];
                name = 'Preventivos Mensual';
                
            } else {
                name = 'Preventivos Diarios';
            }

            
            obj = {
                    chart: {
                        type: 'column',
                    },
                    title: {
                        text: name
                    },
                    {#subtitle: {
                        text: 'Source: WorldClimate.com'
                    },#}
                    xAxis: {
                        categories: categories,
                        crosshair: true
                    },
                    {#yAxis: {
                        min: 0,
                        title: {
                            text: 'Sitios'
                        }
                    },#}
                                
                    yAxis: [{ // Primary yAxis
                            {#labels: {
                                format: '{value}°C',
                                style: {
                                    color: Highcharts.getOptions().colors[1]
                                }
                            },#}
                            min: 0,
                            title: {
                                text: 'Sitios',
                                {#style: {
                                    color: Highcharts.getOptions().colors[1]
                                }#}
                            }
                        }, { // Secondary yAxis
                            min: 0,
                            title: {
                                text: 'Percent (%)',
                                {#style: {
                                    color: Highcharts.getOptions().colors[0]
                                }#}
                            },
                            {#labels: {
                                format: '{value} mm',
                                style: {
                                    color: Highcharts.getOptions().colors[0]
                                }
                            },#}
                            opposite: true
                        }],
                                
                    tooltip: {
                        headerFormat: '<span style="font-size:10px"><strong>{point.key}</strong></span><table>',
                        pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' +
                            '<td style="padding:0"><b>{point.y}</b></td></tr>',
                        footerFormat: '</table>',
                        shared: true,
                        useHTML: true
                    },
                    plotOptions: {
                        column: {
                            pointPadding: 0.2,
                            borderWidth: 0
                        },
                        series: {
                            cursor: 'pointer',
                            point: {
                                events: {
                                    click: function (e) {
                                        var month, date,
                                            data = {};
                                    
                                        if ("shapeType" in this) {
                                            
                                            if ( this.category.length > 3 ) {
                                            date = this.category;
                                            } else {
                                                month = this.index + 1;
                                            }

                                            data['visita']      = $("#visita").val();
                                            data['region']      = $("#region").val();
                                            data['pais']        = $("#pais").val();  
                                            data['fechaIni']    = $('#Filtros_fechaIni').val();  
                                            data['fechaFin']    = $('#Filtros_fechaFin').val();
                                            data['month']       = month;
                                            data['date']        = date;
                                            data['type']        = this.series._i;

                                            generateModal('{{path('reportemshonduras_reportePPgraphDetail')}}', data );

                                        } 

                                    }
                                }
                            }
                        }
                        
                    },
                    series: series
                };
                
            if ( op == 2 ) {
                obj.xAxis.labels = { rotation: -60 };
            }
                
            return obj;
        }

        function translate(translation,table){

            var translationHeader = Object.keys(translation);

            for ( var i = 0; i < translationHeader.length; i++ ) {

                table = table.replace(translationHeader[i],translation[translationHeader[i]]);

            }

            return table;
        }

        function ISO8601_week_no(dt) {
            
            var tdt = new Date(dt.valueOf());
            var dayn = (dt.getDay() + 6) % 7;
            tdt.setDate(tdt.getDate() - dayn + 3);
            var firstThursday = tdt.valueOf();
            tdt.setMonth(0, 1);
            
            if (tdt.getDay() !== 4) {
                tdt.setMonth(0, 1 + ((4 - tdt.getDay()) + 7) % 7);
            }
            return 1 + Math.ceil((firstThursday - tdt) / 604800000);
        }

        function llenarCombos(){
            
            var $region = $("#region"),
                data    = {};
        
            $("#region option").remove();     
            $region.append('<option value="TODOS">REGION</option>');            
            data['pais']=$("#pais").val();  
            
            $.getJSON('{{path('reportemsguatemala_llenarCombosInventario')}}',data, function (data) {
                    
                    var regions  = data.region;
   
                    for (var i = 0; i < regions.length; i++) {
                        
                        $region.append('<option value="'+regions[i]['REGION']+'">' +regions[i]['REGION']+ '</option>');
                    
                    }
            
                    loading(0);

            });              
        };
        
        function generateModal(url, data) {
            
            var $modal     = $('#myModal'),
                $modalBody = $('#myModal .modal-body').empty();
            
            $modal.find('.isloading-wrapper').remove();
            $modalBody.isLoading();
            
            $.getJSON( url, data, function(data) {
                {#console.log(data);#}
                if ( data.length == 0 ) {

                    $modal.modal('hide');
                    $modalBody.isLoading('hide');        
                    return false;
                } 
                
                var monitor = data,
                    header  = Object.keys( data[0] ),
                    table   = '<table class="table table-hover table-condensed"><thead><tr class="bg-primary">';
                
                for (var j = 0; j < header.length; j++) {
                    table += "<th class='text-center'>" + header[j] + "</th>"
                }
                
                table += "</tr></thead>";

                for (var i = 0; i < monitor.length; i++) {
                    table += "<tr>";
                    for (var j = 0; j < header.length; j++) {

                        table += "<td>" +  monitor[i][header[j]] +"</td>";
                    }
                    table += "</tr>";
                }

                table += "</table>";
                $modalBody.html(table).isLoading('hide');
            });

            $modal.modal('show');
        }
        
    </script>
{% endblock %}