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

{% block menuTop %}
{% endblock %}


{% 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:10px;}
        .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);}
        }

        #menuTop {
            margin-top: 10px;
        }
        .fixed-panel {
            min-height: 200px;
            /* max-height: 800px; */
            overflow-y: auto;
        }
        #parametros .panel-body .row{

            padding-left: 5px;
        }
        #chart .panel-body {
            padding: 0px;
        }
        .btn-claro {
            color: #fff;
            /*background-color: #00569C;
            border-color: #3D59CA;*/
            background-color: #428bca;
            border-color: #3071a9;
        }
        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
        }
        .tabla-detalle
        {
                text-transform: uppercase;
                font-size: 9px;
        }
    
        .disabledTab{
            pointer-events: none;
        }
        #menuTop { margin-top: 0px; }

        .form-inline .form-group { margin-bottom: 20px; }

        .form-group{ margin-left: 20px; }

        hr.style14 { 
            border: 0; 
            height: 1px; 
            background-image: -webkit-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -moz-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -ms-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -o-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0); 
        }

        .hrHide { display: none; }

        .highcharts-container{width:100% !important;}

      
        table th{
            {#text-transform: uppercase;#}
            font-weight: bold;
            font-size: 12px;
        }
        
        table td{
            {#text-transform: uppercase;#}
            font-weight: normal;
            font-size: 12px;
        }        

        .commentList {
            padding:0;
            list-style:none;
            max-height:100px;
            overflow:auto;
        }
        .commentList li {
            margin:0;
            margin-top:10px;
        }
        .commentList li > div {
            display:table-cell;
        }       
        .commentText p {
            margin:0;
        }
        .sub-text {
            color:#aaa;
            font-family:verdana;
            font-size:11px;
        }
        /********************************************************************/
        .panel.with-nav-tabs .panel-heading{
            padding: 5px 5px 0 5px;
        }
        .panel.with-nav-tabs .nav-tabs{
            border-bottom: none;
        }
        .panel.with-nav-tabs .nav-justified{
            margin-bottom: -1px;
        }
        /*** PANEL PRIMARY ***/
        .with-nav-tabs.panel-primary .nav-tabs > li > a,
        .with-nav-tabs.panel-primary .nav-tabs > li > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > li > a:focus {
            color: #fff;
        }
        .with-nav-tabs.panel-primary .nav-tabs > .open > a,
        .with-nav-tabs.panel-primary .nav-tabs > .open > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > .open > a:focus,
        .with-nav-tabs.panel-primary .nav-tabs > li > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > li > a:focus {
            color: #fff;
            background-color: #3071a9;
            border-color: transparent;
        }
        .with-nav-tabs.panel-primary .nav-tabs > li.active > a,
        .with-nav-tabs.panel-primary .nav-tabs > li.active > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > li.active > a:focus {
            color: #428bca;
            background-color: #fff;
            border-color: #428bca;
            border-bottom-color: transparent;
        }
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu {
            background-color: #428bca;
            border-color: #3071a9;
        }
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > li > a {
            color: #fff;
        }
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > li > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > li > a:focus {
            background-color: #3071a9;
        }
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > .active > a,
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > .active > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > .active > a:focus {
            background-color: #4a9fe9;
        }
        /********************************************************************/
        input {
            -webkit-appearance: textfield;
            background-color: white;
            color: #1b1b1b;
            font-weight: lighter;
            -webkit-rtl-ordering: logical;
            cursor: text;
            padding: 1px;
            border-width: 1px;
            border-style: solid;
            border-color: #1B1B1B !important;
            border-image: initial;
        }
        .dataTables_length select {
            width: 60px;
        }
        .dataTables_length label {
            font-weight: normal;
        }
        table.dataTable thead th{
            border-bottom: 1px solid #3071a9 !important;
        }
        table.dataTable tfoot th{
            border-top: 1px solid #3071a9 !important;
        }
        .dataTables_scroll{
            border: 1px solid #3071a9 !important;
        }
        div.dt-buttons {
            position: relative !important;
            float: right !important;
            margin-right: -5px !important;
        }
        .header_dt{
            color: #fff;
            background-color: #428bca;
            border-color: #3071a9 !important;
        }
        .highcharts-graph {
            filter: url(#glow);
        }

        .list-group-item {
            position: relative;
            display: block;
            padding: 2px 5px !important;
            margin-bottom: -1px;
            background-color: #fff;
            border: 1px solid #ddd;
        }
        .Resizer {
            padding: 0;
            margin: 0;
            top: 0;
            left: 0;
        }

        .contentWindow{
            position: absolute;
            background-color: #B4E0DE;
        }

        .resizer{
            position: absolute;
            z-index: 100;
            background-color: #4E6160;
        }

        .verticalResizer{
            cursor: ns-resize;
        }

        .horizontalResizer{
            cursor: ew-resize;
        }
        .panel .panel-primary {
            min-height: 100px;
            max-height: 300px;
            height: 300px;
            overflow-y: scroll;
            overflow-x: scroll;
        }

    </style>
    
    <link  href="{{ asset('select2/css/select2.css') }}" rel="stylesheet" type="text/css" />
    <link  href="{{ asset('bootstrap-multiselect/css/bootstrap-multiselect.css') }}" rel="stylesheet" type="text/css" />
    <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 src="{{ asset('bootstrap-multiselect/js/bootstrap-multiselect.js') }}" type="text/javascript"></script>
    <script>
        Highcharts.wrap(Highcharts.Axis.prototype, 'getPlotLinePath', function(proceed) {
            var path = proceed.apply(this, Array.prototype.slice.call(arguments, 1));
            if (path) {
                path.flat = false;
            }
            return path;
        });
        //VALIDACIONES JQUERY
        $(document).ready(function (){       
            $('#myTabs a:first').tab('show');
            $('.activarButton').hide();
            //inicio validacion de la fecha
            $.fn.dataTable.moment( 'YYYY-MMM' );
            $('#Filtros_fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#Filtros_fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });            
            $('#Filtros_fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });
            //
            $('#fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });            
            $('#fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });
            {% if departamento_user!=33 %}
                $("#proyecto").multiselect();
                $("#region").multiselect();
                //$("#asp").multiselect();
                //$("#brigada").multiselect();
                //$("#region").multiselect();
            {% else %}
                $('#proyecto').multiselect();
                $("#region").multiselect();
                //$("#region").multiselect();
            {% endif %}
            //
            var f = new Date();
            var mes = (f.getMonth() + 1);
            if (mes < 10)
                mes = '0' + mes;
            var fechaI = f.getFullYear() + '-' + mes + "-01";
            var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();
            $('#fechaIni').val(fechaI);
            $('#fechaFin').val(fechaF);
            //validacion de la fecha
            //funcion para los select dependientes
            $(".get-list").change(function(e) {
                var data_select_refresh = $(this).attr('data');
                var data_act = $(this).attr('data-act');
                var campo_filtrar = $(this).attr('data-campo-filtro');  
                var campo_mostrar = $(this).attr('data-campo-mostrar'); 
                var div = $(this).attr('data-div-siguiente'); 
                var data = {
                    valor_filtro : $(this).val(),
                    campo_filtrar : campo_filtrar,
                    campo_mostrar : campo_mostrar,
                };
                $("."+data_act+" option").remove();                
                $("."+data_act).multiselect("destroy");
                $("."+data_act).multiselect();
                $("."+data_select_refresh+" option").remove(); 
                //console.log('prueba',$(this).val());
                if ($(this).val()!=''){     //               
                    $.getJSON('{{path('reportemexicoatt_llenarSelect',{'idproyectos':idproyectos,'idmodule':idmodule})}}', data, function (data){
                        var registros = data.registros;
                        for (var i = 0; i < registros.length; i++){
                            $("#"+data_select_refresh).append('<option value="' + registros[i]['valor'] + '">' + registros[i]['nombre'] + '</option>');
                        }
                        $("#"+data_select_refresh).attr('multiple',true);
                        $("#"+data_select_refresh).multiselect("destroy");
                        $("#"+data_select_refresh).multiselect();
                        $('#'+div+' .multiselect-container>li[class="active"]>a>label>input').first().trigger('click'); 
                        
                    });
                }
               
            });
            //fin select dependientes
            //accion cuando le dan al boton de generar
            $("#generar").click(function (){
                 if ($("#rango_fecha").hasClass("btn-primary")){
                    $('#Filtros_fechaIni').val($('#fechaIni').val());
                    $('#Filtros_fechaFin').val($('#fechaFin').val());  
                }
                if ($('#Filtros_fechaIni').val()=="" ||  $('#Filtros_fechaFin').val()==""){
                    swal("Error!", "Date Required", "error");
                }else{
                    $.isLoading({
                         text: "Loading"
                    });
                    getChart();
                }
                     
               
            });     
            $(document).on("click",'#btnDetalleOtd',function(){ 
                $('#datatable_02 tr').remove(); 
                $('#modalDetalleOtdTitle').text('OTD (On Time Delivery)');  
                $("#modalDetalleOtd").modal('show');
                $("#datatable_02").isLoading('hide');           
                getTableModal('general','');
            });
            $(window).resize(function(){
                //resizeChart();
            });
            $(".click_tab").click(function(){
                resizeChart();
            });
            $('a[data-toggle="tab"]').on( 'shown.bs.tab', function (e) {
                $.fn.dataTable.tables( {visible: true, api: true} ).columns.adjust();
                try{
                    resizeChart();
                }catch(err) {
                    //console.log(err.message);
                }
            });
            $(".div_fecha").hide();
            $(".ajuste_fecha").click(function(){
                $('.ajuste_fecha').removeClass('btn-primary');
                $('.ajuste_fecha').addClass('btn-default');
                var id = $(this).attr('id');
                $("#"+id).addClass('btn-primary');
                $(".div_fecha").hide();
                if (id=="rango_fecha"){
                    $(".div_fecha").show();
                }
                rangosFecha(id);
            });
            $("#mostrar_excel_entrada").hide();
            //rangosFecha('hoy');
        });
        function rangosFecha(opcion){
            //para el dia actual
            if (opcion=='hoy'){
                var f = new Date();
                var mes = (f.getMonth() + 1);
                if (mes < 10) mes = '0' + mes;
                var dia = f.getDate();
                if (dia < 10) dia = '0' + dia;
                var fechaI = f.getFullYear() + '-' + mes + "-" + dia;
                var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            //para ultimos_7_dias
            if (opcion=='ultimos_7_dias'){
                var f = new Date();
                console.log(f);
                var mes = (f.getMonth() + 1);
                if (mes < 10) mes = '0' + mes;
                //OBTENER EL DIA DE LA SEMANA DE LA FECHA ACTUAL
                var weekday = f.getDay();
                //console.log(weekday);
                //SI ES LUNES
                if (weekday==1){
                    var nueva_fecha = new Date();
                    var nuevo_mes = (nueva_fecha.getMonth() + 1);
                    if (nuevo_mes < 10) nuevo_mes = '0' + nuevo_mes;
                    var dia_n = nueva_fecha.getDate();
                    if (dia_n < 10) dia_n = '0' + dia_n;
                }else{
                    if (weekday==2){ //SI ES MARTES
                        cantidad_dias_restar = 1;
                    }
                    if (weekday==3){ //SI ES MIERCOLES
                        cantidad_dias_restar = 2;
                    }
                    if (weekday==4){ //SI ES JUEVES
                        cantidad_dias_restar = 3;
                    }
                    if (weekday==5){ //SI ES VIERNES
                        cantidad_dias_restar = 4;
                    }
                    if (weekday==6){ //SI ES SABADO
                        cantidad_dias_restar = 5;
                    }
                    if (weekday==0){ //SI ES DOMINGO
                        cantidad_dias_restar = 6;
                    }
                    var dias_restar = 1000 * 60 * 60 * 24 * cantidad_dias_restar;
                    var resta = f.getTime() - dias_restar;
                    var nueva_fecha = new Date(resta);
                    var nuevo_mes = (nueva_fecha.getMonth() + 1);
                    if (nuevo_mes < 10) nuevo_mes = '0' + nuevo_mes;
                    var dia_n = nueva_fecha.getDate();
                    if (dia_n < 10) dia_n = '0' + dia_n;
                }                
                var fechaI = nueva_fecha.getFullYear() + '-' + nuevo_mes + "-" + dia_n;
                var dia = f.getDate();
                if (dia < 10) dia = '0' + dia;
                var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            //para el mes actual
            if (opcion=='mes_actual'){
                var f = new Date();
                var mes = (f.getMonth() + 1);
                if (mes < 10) mes = '0' + mes;
                var fechaI = f.getFullYear() + '-' + mes + "-01";
                var dia = f.getDate();
                if (dia < 10) dia = '0' + dia;
                var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            //para mes_anterior
            if (opcion=='mes_anterior'){
                //desde
               const f1=moment().subtract(1, 'months').startOf('month').format('DD-MM-YYYY');
               //console.log(f1);
               var fInicial = f1.split('-');
               //hasta
               const f2=moment().subtract(1, 'months').endOf('month').format('DD-MM-YYYY');
               var fFinal = f2.split('-');
               //actualizar
               var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
               var fechaF = fFinal[2] + '-' + fFinal[1] + "-" + fFinal[0];

            }
            //para las 6 meses
            if (opcion=='ultimo_6_meses'){
                //desde
               const f1=moment().subtract(5, 'months').startOf('month').format('DD-MM-YYYY');
               //console.log(f1);
               var fInicial = f1.split('-');
               //hasta
               var f = new Date();
               var mes = (f.getMonth() + 1);
               if (mes < 10) mes = '0' + mes;               
               //actualizar
               var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
               var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();
            }
            //para las 12 meses
            if (opcion=='ultimo_12_meses'){
                //desde
               const f1=moment().subtract(12, 'months').startOf('month').format('DD-MM-YYYY');
               console.log(f1);
               var fInicial = f1.split('-');
               //hasta
               var f = new Date();
               var mes = (f.getMonth() + 1);
               if (mes < 10) mes = '0' + mes;               
               //actualizar
               var dia = f.getDate();
               if (dia < 10) dia = '0' + dia; 
               var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
               var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            if (opcion!="rango_fecha"){
                //$(".detalleRango").text('Of '+fechaI+' to '+fechaF);
            }else{
                //$(".detalleRango").text('');
            }
            $('#Filtros_fechaIni').val(fechaI);
            $('#Filtros_fechaFin').val(fechaF);
            if (opcion!='rango_fecha'){
                $("#generar").trigger('click');
            }
        }        
        //FUNCIONES DE JAVASCRIP
        var projectList = new Array(4); //Lista de proyectos para cada gráfico
        //fin grafiaca de linea
        // get serie
        function getDataToObjectSerie(data, header){
            var arrayReturn = new Array();
            var data1 = new Array();

            for (var i = 0; i < data.length; i++){
                data1.push(parseFloat(data[i][header[header.length - 1]]));
            }
            arrayReturn.push({'name': header[header.length - 1], 'data': data1, 'dataLabels': {'enabled': true}});
            return arrayReturn;
        }
        //fin get serie
        //funcion para crear las tablas
        function createTableDT(data, tableRender, dtRender)
        {
            //console.log(data, tableRender, dtRender);
            var strHeader = "";
            var strFooter="";
            var columns = [];        ;
            var strTable = '<table id="' + tableRender + '" class="display cell-border compact stripe" width="100%">' +
                    '<thead><tr class="header_dt">';
            $('#' + dtRender).empty();
            for (var i=0; i<data.length; i++){
                var fechaGroup = ""
                var title = data[i];
                var t = title.replace(/_/g,' ');
                t = title.replace('#','');
                var visible = title.startsWith('_') ? false : true;
                if (tableRender=='table_IssuesExecuted' && t=='%OHS'){
                    t = t +"<img src='{{ asset('images/down_red.png') }}'>";
                }else if (t=='%FTR' || t=='%FTR ASP' || t=='%OTD' || t=='%QP' || t=='%OHS'){
                    t = t +"<img src='{{ asset('images/up_red.png') }}'>";
                }
                if (t!='workplan_id'){
                    
                    strHeader += '<th class="text-center">' + t + '</th>';
                }
                columns.push({data: data[i], title: t, visible:visible});
            }
            strTable += strHeader + '</tr></thead><tbody id="tbody_' + tableRender + '"></tbody>' + strFooter + '</table>';
            $('#' + dtRender).empty();
            $('#' + dtRender).html(strTable);
            $('#' + tableRender + ' thead tr').clone(true).appendTo( '#' + tableRender + ' thead' );
            $('#' + tableRender + ' thead tr:eq(1) th').each( function (i) {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%; margin: 0px; padding: 0px;"/>' );
                $( 'input', this ).on( 'keyup change', function () {
                    if ( $.fn.DataTable.isDataTable( '#' + tableRender ) ) {
                        var table = $('#' + tableRender).DataTable();
                        if ( table.column(i).search() !== this.value ) {
                            table
                                    .column(i)
                                    .search( this.value )
                                    .draw();
                        }
                    }
                } );
            } );
            return columns;
        }       
        //configuracion de los datatable
        function buildDatatablePrin(render, columnas, data,suffix_export,orderArray)
        {
            var a=[];b=[];
            var Defs = [];
            var ini = (columnas.length) -5;
            var kpi = '';
            for (var i=0; i<=(columnas.length - 1); i++){
                a.push(i);
            }
            Defs.push({ targets: a, className: 'dt-body-center' });
            for (var i=0; i<=(columnas.length - 1); i++){
                if (columnas[i].visible){
                    b.push(i);
                }
            }
            table = $('#'+render).DataTable( {
                dom: '<"row" <"col-md-12 text-right"B>> <"row" <"col-md-6 "l> <"col-md-6"f>>rtip',
                scrollY: false,
                scrollX: true,
                scrollCollapse: true,
                orderCellsTop: true,
                data:data,
                "deferRender": false,
                "processing": true,
                "bPaginate": false,
                "language": {
                    "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                },
                //"order": [[ 0, "asc" ]],
                "ordering": false,
                columns: columnas,
                columnDefs: Defs,
                lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                buttons: [
                    {
                        extend:'excel',
                        text: 'Table Excel ' + kpi,
                        exportOptions: {
                            columns: b,
                            orthogonal: 'export'
                        },
                        title: 'DASHBOARD_Checkin'
                    }
                ],
                drawCallback: function() {
                    $('[data-toggle="popover"]').popover();
                } 
            } );
            
        }        
        //llamado para generar las graficas y las tablas  
        function getChart(){
           
            var inicio = $('#Filtros_fechaIni').val();
            var fin = $('#Filtros_fechaFin').val();            
            var proyecto = $('#proyecto').val();            
            if($('#asp_user').val()!=''){
                var asp = [$('#asp_user').val()];
            }else{
                var asp = $('#asp').val();
            }  
            var brigada = $('#brigada').val();
            var region = $('#region').val();
            var valor = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();
            var entrada_sitio = $("#entrada_sitio").val();
            var primer_checkin = $("#primer_checkin").val();                       
            var cliente = $("#cliente").val();
            var parametro_dia = 0;
            if($("#ultimos_7_dias").hasClass('btn-primary')){
                parametro_dia = 1;
            }
            var justificacion_tardia = $("#justificacion_tardia").val(); 
            var parametros = {
                'postfix' : 'uki',
                'FechaInicio': inicio,
                'FechaFin': fin,                
                'proyecto': proyecto,
                'asp': asp,
                'date': valor,
                'parametro_dia': parametro_dia,
                'brigada': brigada,
                'region': region,
                'entrada_sitio':entrada_sitio,
                'cliente':cliente,
                'primer_checkin':primer_checkin,
                'justificacion_tardia':justificacion_tardia,
            };
            $.getJSON('{{path('reportemexicoatt_DashboardCheckin',{'idproyectos':idproyectos,'idmodule':idmodule})}}', parametros, function (data){
                var chart = data;
                //destroyGraphs();     
                //para el grafico Horas ATT Entrada
                if (chart.grafico_HorasATT.categories.length > 0){
                    $("#mostrar_excel_entrada").show();
                    $("#grafico_HorasATT").empty();                    
                    var series = getDataToObjectSerieAll(chart.grafico_HorasATT.data, Object.keys(chart.grafico_HorasATT.data[0]));
                    createChartColumnPeq('grafico_HorasATT', chart.grafico_HorasATT.categories, series, 'Checkin vs Hora de Llegada',
                            null, inicio, fin, null,null,"{{ path('reportemexicoatt_detalleTablaCheckin',{'idproyectos':idproyectos,'idmodule':idmodule}) }}", chart.grafico_HorasATT.data,parametros);
                }else{
                    if ($("#grafico_HorasATT").highcharts()!=undefined){
                        $("#grafico_HorasATT").highcharts().destroy();
                    }                    
                    $("#grafico_HorasATT").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                } 
                //table Horas ATT Entrada                
                if (chart.table_HorasATT.length > 0){
                    $("#datatable_HorasATT").empty();
                    col = createTableDT(Object.keys(chart.table_HorasATT[0]),'table_HorasATT', 'datatable_HorasATT');
                    console.log(col);
                    buildDatatablePrin('table_HorasATT',col,chart.table_HorasATT,null,null);
                }else{
                    $("#datatable_HorasATT").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para el grafico Horas ATT Salida
                {% if departamento_user!=33 %}     
                    if (chart.grafico_HorasSalida.categories.length > 0){
                        $("#grafico_HorasSalida").empty();                    
                        var series = getDataToObjectSerieAll(chart.grafico_HorasSalida.data, Object.keys(chart.grafico_HorasSalida.data[0]));
                        createChartColumnPeq('grafico_HorasSalida', chart.grafico_HorasSalida.categories, series, 'Checkout',
                                null, inicio, fin, null,null,"{{ path('reportemexicoatt_detalleTablaCheckin',{'idproyectos':idproyectos,'idmodule':idmodule}) }}", chart.grafico_HorasSalida.data,parametros);
                    }else{
                        if ($("#grafico_HorasSalida").highcharts()!=undefined){
                            $("#grafico_HorasSalida").highcharts().destroy();
                        }                    
                        $("#grafico_HorasSalida").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                    } 
                {% endif %}


                //grafico cita
                /*if (chart.grafico_Cita.categories.length > 0){
                    $("#grafico_Cita").empty();                    
                    var series = getDataToObjectSerieAll(chart.grafico_Cita.data, Object.keys(chart.grafico_Cita.data[0]));
                    createChartColumnPeq('grafico_Cita', chart.grafico_Cita.categories, series, 'Checkin vs Hora de Cita',
                            null, inicio, fin, null,null,"{{ path('reportemexicoatt_detalleTablaCheckin',{'idproyectos':idproyectos,'idmodule':idmodule}) }}", chart.grafico_Cita.data,parametros);
                }else{
                    if ($("#grafico_Cita").highcharts()!=undefined){
                        $("#grafico_Cita").highcharts().destroy();
                    }                    
                    $("#grafico_Cita").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                } 
                //table cita               
                if (chart.table_Cita.length > 0){
                    $("#datatable_Cita").empty();
                    col = createTableDT(Object.keys(chart.table_Cita[0]),'table_Cita', 'datatable_Cita');
                    buildDatatablePrin('table_Cita',col,chart.table_Cita,null,null);
                }else{
                    $("#datatable_Cita").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }*/

                $.isLoading("hide");
                resizeChart();
            });
        }
        function getDataToObjectSerieAll(data, header){
            var arrayReturn = new Array();
            var data1 = new Array();
            var menor = 1000;
            var mayor = -1;

            for (var i = 0; i < header.length; i++){
                var dataAux = new Array();
                if (header[i].indexOf('_cat_') < 0){
                    for (var j=0; j<data.length; j++){
                        var valor = parseFloat(data[j][header[i]]);
                        dataAux.push(valor);
                        if (valor < menor){
                            menor = valor;
                        }
                        if (valor > mayor){
                            mayor = valor;
                        }
                    }
                    arrayReturn.push({'name': header[i], 'data': dataAux, 'dataLabels': {'enabled': true}});
                }
            }
            data1[0] = arrayReturn;
            data1[1] = menor;
            data1[2] = mayor;
            return data1;
        }
        function openModalDetalle(fechaGroup){  
            $('#datatable_02 tr').remove();
            $('#modalDetalleOtdTitle').text('Services Not Delivered On Time');     
            $("#modalDetalleOtd").modal('show');
            $("#datatable_02").isLoading('hide');           
            getTableModal('detalle',fechaGroup);
        }
          
        function resizeChart(){
            var panel_width = $('#panel_content').width();
            var offset = 32;
            $('#grafico_HorasATT').width(panel_width-offset); 
            $('#grafico_HorasSalida').width(panel_width-offset); 
            $('#grafico_Cita').width(panel_width-offset); 
            var panel_width1 = $('.panel-body').width()
            if ($("#grafico_HorasATT").highcharts()!=undefined){ 
                $('#grafico_HorasATT').highcharts().reflow(); 
            }
            if ($("#grafico_HorasSalida").highcharts()!=undefined){ 
                $('#grafico_HorasSalida').highcharts().reflow(); 
            }
            if ($("#grafico_Cita").highcharts()!=undefined){ 
                $('#grafico_Cita').highcharts().reflow(); 
            }
            
        }
        function generateModal(ruta, objParams, numerar, title, subtitle, orderArray)
        {        
            //console.log(objParams);
            if (objParams.kpi=='ftr' || objParams.kpi=='ftr_asp' || objParams.kpi=='ftr_total_service' || objParams.kpi=='ftr_aggregate_total_sites'){
                $("#mes_seleccionado").val(objParams.mes);
                $("#pais_seleccionado").val(objParams.pais);
                $("#cliente_seleccionado").val(objParams.cliente);
                $("#proyecto_seleccionado").val(objParams.proyecto);
                $("#asp_seleccionado").val(objParams.asp);
            }else{
                $("#mes_seleccionado").val('');
                $("#pais_seleccionado").val('');
                $("#cliente_seleccionado").val('');
                $("#proyecto_seleccionado").val('');
                $("#asp_seleccionado").val('');
            }        
            
            var title_ = title!=null ? title.trim() : "";
            var ordArr = orderArray!=null ? orderArray : null;
            $("#datatableModalDetalle").empty().isLoading();
            $('#myModal .punto-grafica').empty().hide();
            $('#myModal .modal_detalle_titulo').empty();
            if (title != null)
            {
                $('#myModal .modal_detalle_titulo').html(title);
                title_ = title_.replace(' ','_');
                title_ = title_.replace('-','');
                title_ = title_.replace(' ','');
            }
            else
            {
                $('#myModal .modal_detalle_titulo').html('{{'monitorii.detail' | trans }}');
                title = '{{'monitorii.detail' | trans }}';
                title_ = title_.replace(' ','_');
                title_ = title_.replace('-','');
                title_ = title_.replace(' ','');
            }
            if (subtitle != null)
            {
                $('#myModal .punto-grafica').html(subtitle).show();
            }
            $.getJSON(ruta, objParams, function (data)
            {
                if (data.length > 0){ 
                    var total_general = 0;
                    var col = createTableDTDetail(Object.keys(data[0]),'tableModalDetalle', 'datatableModalDetalle',objParams.kpi,0,0);
                    buildDatatablePrin('tableModalDetalle',col,data,title_,ordArr);
                    $('[data-toggle="popover"]').popover('destroy');
                    $('[data-toggle="popover"]').popover({
                        template: '<div class="popover" role="tooltip" style="width: 800px;"><div class="arrow"></div><h3 class="popover-title"></h3><div class="popover-content"><div class="data-content"></div></div></div>'
                    }).on("show.bs.popover", function () { $(this).data("bs.popover").tip().css("max-width", "600px"); });
                }else{
                    $("#datatableModalDetalle").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                $("#datatableModalDetalle").isLoading('hide');
            });

            $('#myModal').modal('show');
        }
         function createTableDTDetail(data, tableRender, dtRender, type, porcentaje_ohs, total_registros)
         {
            var strHeader = "";
            var strFooter="";
            var columns = [];
            var col_issues = 8;
            var strType = (type == null ? "" : type);
            var strTable = '<table id="' + tableRender + '" class="display cell-border compact stripe" width="100%">' +
                    '<thead><tr class="header_dt">';
            $('#' + dtRender).empty();
            //console.log('strType',strType);
            switch(strType.toLocaleUpperCase()){
                case 'QP':
                case 'QP_DETAIL':
                    col_issues = 8;
                    break;
                case 'OHS':
                case 'OHS_DETAIL':
                    col_issues = 9;
                    break;
                case 'FTR':
                    col_issues = 8;
                    break;
                case 'FTR_ASP':
                    col_issues = 8;
                    break;
            }                                
            for (var i=0; i<data.length; i++){
                var title = data[i];
                var t = title.replace(/_/g,' ');
                t = title.replace('#','');
                var visible = title.startsWith('_') ? false : true;
                strHeader += '<th class="text-center">' + t + '</th>';                
                columns.push({data: data[i], title: t, visible:visible});
            }
            strTable += strHeader + '</tr></thead><tbody id="tbody_' + tableRender + '"></tbody>' + strFooter + '</table>';
            $('#' + dtRender).empty();
            $('#' + dtRender).html(strTable);
            $('#' + tableRender + ' thead tr').clone(true).appendTo( '#' + tableRender + ' thead' );
            $('#' + tableRender + ' thead tr:eq(1) th').each( function (i) {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%; margin: 0px; padding: 0px;"/>' );
                $( 'input', this ).on( 'keyup change', function () {
                    if ( $.fn.DataTable.isDataTable( '#' + tableRender ) ) {
                        var table = $('#' + tableRender).DataTable();
                        if ( table.column(i).search() !== this.value ) {
                            table
                                    .column(i)
                                    .search( this.value )
                                    .draw();
                        }
                    }
                } );
            } );
            return columns;
        } 
        function createChartColumnPeq(render, categoria, series, title, w,
                                   inicio, fin, pais, orderArray, path, rawData,parametros)
        {
            //ajustar la serie para la doble axies
            //colors: ['#275f76', '#00A9E5', '#93D543'],   
            var arrayReturn = new Array();
            var data = new Array();  
            if (render=='grafico_HorasATT'){
                if (series.length>0){
                    if(parametros.parametro_dia==0){
                        $.each(series, function(key, value) {
                            $.each(value, function(k, v) {  
                                if(v.name=='<=09:00' || v.name=='<09:30'){ //VERDE
                                   data.push({"color":'#009775',"name":v.name,"data":v.data,yAxis: 1,type: 'column','cita':'0'});  
                                }else if (v.name=='<=11:00'){ //AMARILLO
                                  data.push({"color":'#FFC824',"name":v.name,"data":v.data,yAxis: 1,type: 'column','cita':'0'});  
                                }else if (v.name=='<=11:00 cita'){ //AMARILLO claro
                                  data.push({"color":'#EED077',"name":'<=11:00 JT',"data":v.data,yAxis: 1,type: 'column','cita':'1'});  
                                }else if (v.name=='<=12:00'){ //NARANJA
                                  data.push({"color":'#ED7D31',"name":v.name,"data":v.data,yAxis: 1,type: 'column','cita':'0'});  
                                }else if (v.name=='<=12:00 cita'){ //NARANJA claro
                                  data.push({"color":'#EE965B',"name":'<=12:00 JT',"data":v.data,yAxis: 1,type: 'column','cita':'1'});  
                                }else if (v.name=='>12:00'){ //ROJO
                                  data.push({"color":'#FF0000',"name":v.name,"data":v.data,yAxis: 1,type: 'column','cita':'0'});  
                                }else if (v.name=='>12:00 cita'){ //ROJO mas claro
                                  data.push({"color":'#FB4D4D',"name":'>12:00 JT',"data":v.data,yAxis: 1,type: 'column','cita':'1'});  
                                }else{
                                    data.push({"name":"% Puntualidad","data":v.data});
                                }                      
                                
                            });
                        });
                    }else{
                        $.each(series, function(key, value) {
                            $.each(value, function(k, v) {  
                                if(v.name=='06:00am' || v.name=='07:00am' || v.name=='08:00am'  || v.name=='09:00am'  || v.name=='09:30am'){ //VERDE
                                   data.push({"color":'#009775',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                                }else if (v.name=='10:00am'){ //AMARILLO
                                  data.push({"color":'#FFC824',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                                }else if (v.name=='10:00am cita'){ //AMARILLO CLARO
                                  data.push({"color":'#EED077',"name":'10:00am JT',"data":v.data,yAxis: 1,type: 'column'});  
                                }else if (v.name=='11:00am'){ //NARANJA
                                  data.push({"color":'#ED7D31',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                                }else if (v.name=='11:00am cita'){ //NARANJA CLARO
                                  data.push({"color":'#EE965B',"name":'11:00am JT',"data":v.data,yAxis: 1,type: 'column'});  
                                }else if (v.name=='12:00pm' || v.name=='01:00pm' || v.name=='02:00pm' || v.name=='03:00pm' || v.name=='04:00pm' || v.name=='05:00pm' || v.name=='06:00pm'){ //ROJO
                                  data.push({"color":'#FF0000',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                                }else if (v.name=='12:00pm cita' || v.name=='01:00pm cita' || v.name=='02:00pm cita' || v.name=='03:00pm cita' || v.name=='04:00pm cita' || v.name=='05:00pm cita' || v.name=='06:00pm cita'){ //ROJO CLARO
                                  data.push({"color":'#FB4D4D',"name":v.name.replace(' cita',' JT'),"data":v.data,yAxis: 1,type: 'column'});  
                                }else{
                                    data.push({"name":"% Puntualidad","data":v.data});
                                }                      
                                
                            });
                        });
                    }
                }      
            }
            if (render=='grafico_HorasSalida'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(v.name=='07am' || v.name=='08am' || v.name=='09am' || v.name=='10am' || v.name=='11am' || v.name=='12pm'){ //ROJO
                               data.push({"color":'#FF0000',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (v.name=='01pm'){ //NARANJA
                              data.push({"color":'#ED7D31',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (v.name=='02pm' || v.name=='03pm' || v.name=='04pm' || v.name=='05pm'){ //AMARILLO
                              data.push({"color":'#FFC824',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (v.name=='06pm'  || v.name=='07pm' || v.name=='08pm' || v.name=='09pm'){ //verde
                              data.push({"color":'#009775',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else{
                                data.push({"name":"% Puntualidad","data":v.data});
                            }                      
                            
                        });
                    });
                }      
            } 

            if (render=='grafico_Cita'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(v.name=='<=30min'){ //VERDE
                               data.push({"color":'#009775',"name":"<=30min","data":v.data,yAxis: 1,type: 'column'});  
                            }else if (v.name=='<=120min'){ //amarillo
                              data.push({"color":'#FFC824',"name":"<=120min","data":v.data,yAxis: 1,type: 'column'});  
                            }else if (v.name=='<=180min'){ //naranja
                              data.push({"color":'#ED7D31',"name":"<=180min","data":v.data,yAxis: 1,type: 'column'});  
                            }else if (v.name=='>180min'){ //rojo
                              data.push({"color":'#FF0000',"name":">180min","data":v.data,yAxis: 1,type: 'column'});  
                            }else{
                                data.push({"name":"% Puntualidad","data":v.data});
                            }                      
                            
                        });
                    });
                }      
            }

            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            var height = 250;
            switch (render){ 
                case 'grafico_HorasATT':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "detalle_horas";
                    height = 420;
                    break;   
                case 'grafico_HorasSalida':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "detalle_horas";
                    height = 420;
                    break; 
                case 'grafico_Cita':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "detalle_citas";
                    height = 420;
                    break;           
            }    
            var porcentaje = data[0].data;
            if (porcentaje!="" && porcentaje!=undefined){
                var yMax = porcentaje.reduce(function(a, b) {
                    return Math.max(a, b);
                });
                if (yMax==0){
                    yMax=60;
                }   
            }else{
                var yMax=60;
            }         
            var options = {
                chart: {
                    //height: height,
                    borderColor: '#428bca',
                    borderWidth: 1,
                    zoomType: 'xy',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: ''
                  },
                  xAxis: {
                    categories: [],
                    crosshair: true,
                },
                yAxis: [{
                    title: {
                        text: 'Percent (%)'
                    },
                    //minPadding: 0,
                    //maxPadding: 0,
                    //max: 100,
                    min: 0,
                    tickPositions: [0,3,5,10,20,30,50,70,80,90,100],
                    labels: {
                        overflow: 'justify'
                    },
                }, {
                    title: {
                        text: 'Percent (%)'
                    },
                    //minPadding: 0,
                    //maxPadding: 0,
                    max: 100,
                    min: 0,
                    opposite: true,
                    labels: {
                        format: "{value}%"
                    }
                }],             
                series: data
            };
            //var formato = '{point.y}';
            //if (parametros.parametro_dia==1){
                var formato = '{point.y:.2f}%';
            //}
            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {

                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true,
                            format: formato
                        },   
                        legend: {
                            layout: 'vertical',
                            align: 'right',
                            verticalAlign: 'top',
                            x: -40,
                            y: 80,
                            floating: true,
                            borderWidth: 1,
                            backgroundColor: '#FFFFFF',
                            shadow: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];  
                                        //console.log(row,rawData,this,this.series.columnIndex,this.y);
                                        var categoriaDetalle =  row['_cat_Categoria'];
                                        var selected_serie = this.series.name; 
                                        if (this.y>0){ 
                                            if (render=='grafico_HorasATT'){   
                                                parametros['semana'] = row['_cat_Semana'];
                                                parametros['position'] = this.series.columnIndex;  
                                                parametros['kpi'] = "detalle_horas";
                                                parametros['selected_serie'] = selected_serie;
                                                if (row['_cat_Dia_Semana']){
                                                    parametros['dia_semana'] = row['_cat_Dia_Semana'];
                                                }else{
                                                    parametros['dia_semana'] = '';
                                                }  
                                                if (row._cat_Categoria!=undefined){
                                                    var title_detalle = 'Checkin vs Hora de Llegada - '+row._cat_Categoria;
                                                }else{
                                                    var title_detalle = 'Checkin vs Hora de Llegada';
                                                }                                            
                                                var subtitle_detalle = selected_serie;
                                                if(selected_serie=='%'){
                                                    $.isLoading("hide");
                                                    return false;
                                                }
                                            }    
                                            if (render=='grafico_HorasSalida'){            
                                                parametros['kpi'] = "detalle_horas_salida";
                                                parametros['selected_serie'] = selected_serie;
                                                parametros['position'] = ''; 
                                                if (row['_cat_Dia_Semana']){
                                                    parametros['dia_semana'] = row['_cat_Dia_Semana'];
                                                }else{
                                                    parametros['dia_semana'] = '';
                                                }  
                                                if (row._cat_Categoria!=undefined){
                                                    var title_detalle = 'Checkout - '+row._cat_Categoria;
                                                }else{
                                                    var title_detalle = 'Checkout';
                                                }                                            
                                                var subtitle_detalle = selected_serie;
                                                if(selected_serie=='%'){
                                                    $.isLoading("hide");
                                                    return false;
                                                }
                                            }     
                                            if (render=='grafico_Cita'){   
                                                parametros['semana'] = row['_cat_Semana'];                                         
                                                parametros['kpi'] = "detalle_citas";
                                                parametros['selected_serie'] = selected_serie;
                                                if (row['_cat_Dia_Semana']){
                                                    parametros['dia_semana'] = row['_cat_Dia_Semana'];
                                                }else{
                                                    parametros['dia_semana'] = '';
                                                }  
                                                if (row._cat_Categoria!=undefined){
                                                    var title_detalle = 'Checkin vs Hora de Cita - '+row._cat_Categoria;
                                                }else{
                                                    var title_detalle = 'Checkin vs Hora de Cita';
                                                }                                            
                                                var subtitle_detalle = selected_serie;
                                                if(selected_serie=='%'){
                                                    $.isLoading("hide");
                                                    return false;
                                                }
                                            }                                          
                                            parametros['selected_item'] = categoriaDetalle;
                                            generateModal(path, parametros, false,  title_detalle, subtitle_detalle, orderArray);
                                        }else{
                                            $.isLoading("hide");
                                            return false;
                                        }
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }
            var num = categoria.length;
            for (var k=0; k<rawData.length; k++){
                var hasThisCategory = false;
                var categoryIndex = -1;
                var categoryPath = options.xAxis.categories;
                var lastCat = categoria[categoria.length - 1]['sql_name'];
                if (categoria.length>=1){ //Si hay 2 o mas categorias
                    // I. level of categories
                    if (categoria.length >= 1) {
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[0]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[0]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

                    if (categoria.length >= 3){
                        // II. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[1]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[1]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

                    if (categoria.length >=4){
                        // III. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[2]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[2]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

                    if (categoria.length >=5){
                        // IV. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[3]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[3]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    if (categoria.length >=6){
                        // V. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[4]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[4]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            return $('#' + render).highcharts(options);        
        }    
        function ExportExcelEntrada() {
          document.forms['formulario_filtros'].action="{{path('reportemexicoatt_ExcelDetalleDashboardCheckin')}}";
          document.forms['formulario_filtros'].submit();
        }        
    </script>
    <div class="container-fluid">
        <form id="formulario_filtros" onsubmit="return false;">
            <div class="panel panel-primary">
                <div class="panel-heading">
                    <h3 class="panel-title"><a data-toggle="collapse" href="#collapse1">Filters <span class="caret"></span></a></h3>
                </div>
                <div id="collapse1" class="panel-collapse collapse in">
                    <div id="panelFilter" class="panel-body">
                       
                            <input type="hidden" name="mes_seleccionado" id="mes_seleccionado" value="" style="">
                            <input type="hidden" name="pais_seleccionado" id="pais_seleccionado" value="">
                            <input type="hidden" name="cliente_seleccionado" id="cliente_seleccionado" value="">
                            <input type="hidden" name="proyecto_seleccionado" id="proyecto_seleccionado" value="">
                            <input type="hidden" name="asp_seleccionado" id="asp_seleccionado" value="">
                            <input type="hidden" class="form-control" id="Filtros_fechaIni" name="Filtros_fechaIni" value="">
                            <input type="hidden" class="form-control" id="Filtros_fechaFin" name="Filtros_fechaFin" value="">
                            <input type="hidden" name="departamento_user" id="departamento_user" value="{{departamento_user}}">
                            <input type="hidden" name="asp_user" id="asp_user" value="{{ asp_user }}">
                            <div class="row"> 
                                <div class="col-md-7 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>Date Filter: <span class="detalleRango"></span> </label><br>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="hoy">Today</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimos_7_dias">Week</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="mes_actual">This Month</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="mes_anterior">Last Month</button>
                                        {% if departamento_user!=33 %} 
                                            <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_6_meses">Last 6 Months</button>
                                            <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_12_meses">Last 12 Months</button>
                                        {% endif %}
                                        <button type="button" class="btn btn-default ajuste_fecha" id="rango_fecha">Custom Range</button>
                                    </div>
                                </div> 
                                <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                                    <div class="form-group">                                            
                                       <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>
                                        <input type="text" class="form-control" id="fechaIni" name="fechaIni" value="">
                                    </div> 
                                </div>   
                                <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                                    <div class="form-group">                                            
                                        <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>
                                        <input type="text" class="form-control" id="fechaFin" name="fechaFin" value="">
                                    </div> 
                                </div> 
                            </div>    
                            <!--PARA EL INTERNO-->
                            {% if departamento_user!=33 %}  
                                <div class="row">        
                                    <div id="div_cliente" class="col-md-4 col-sm-6 col-xs-12">
                                        <div class="form-group">
                                            <label>{{'monitores.proyecto' | trans}}: </label><br>
                                            <select class="form-control get-list proyecto" id="proyecto" name="proyecto" data='asp' data-campo-filtro='erisite_proyecto' data-campo-mostrar='asp_JSA' data-act='refresh_proyecto' multiple="multiple" style="width: 100%;" data-div-siguiente="div_asp">
                                                <!--<option value="TODOS">-- All -- </option>-->
                                                {%for proyecto in proyectos %}
                                                    <option value="{{proyecto.valor}}">{{proyecto.nombre}}</option>
                                                {%endfor%}
                                            </select>
                                        </div>
                                    </div>
                                    <div id="div_asp" class="col-md-3 col-sm-6 col-xs-12">
                                        <div class="form-group">
                                            <label>{{'ASP' | trans}}: </label><br>
                                            <select class="form-control get-list asp refresh_proyecto" id="asp" name="asp" data='brigada' data-campo-filtro='asp_JSA' data-campo-mostrar='brigada' data-act='refresh_asp' style="width: 30%;" data-div-siguiente="div_brigada">
                                                <!--<option value="TODOS">-- All --</option>-->
                                            </select>
                                        </div>
                                    </div>
                                    <div id="div_brigada" class="col-md-3 col-sm-6 col-xs-12">
                                        <div class="form-group">
                                            <label>{{'Crew' | trans}}: </label><br>
                                             <select class="form-control brigada refresh_proyecto refresh_asp" id="brigada" name="brigada" data='region' data-campo-filtro='brigada' data-campo-mostrar='region' data-act='refresh_brigada' style="width: 30%;" data-div-siguiente="div_region">
                                                <!--<option value="TODOS">-- All --</option>-->
                                            </select>
                                        </div>
                                    </div>
                                    <div id="div_region" class="col-md-2 col-sm-6 col-xs-12">
                                        <div class="form-group">
                                            <label>{{'Region'}}: </label><br>
                                             <select class="form-control region" id="region" name="region" multiple="multiple" style="width: 100%;">
                                                <!--<option value="TODOS">-- All --</option>-->
                                                <option value="1">1</option>
                                                <option value="2">2</option>
                                                <option value="3">3</option>
                                                <option value="4">4</option>
                                                <option value="6">6</option>
                                                <option value="9">9</option>
                                                <!--{%for region in regiones %}
                                                    <option value="{{region.valor}}">{{region.nombre}}</option>
                                                {%endfor%}-->
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="row"> 
                                    <div id="div_entrada_sitio" class="col-md-3 col-sm-6 col-xs-12">
                                        <div class="form-group">
                                            <label>{{'Check-in'}}: </label>
                                             <select class="form-control entrada_sitio" id="entrada_sitio" name="entrada_sitio" style=" width: 100%;">
                                                <option value="TODOS">-All-</option>
                                                <option value="NO">SI</option>
                                                <option value="SI">NO</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div id="div_justificacion_tardia" class="col-md-3 col-sm-6 col-xs-12">
                                        <div class="form-group">
                                            <label>{{'Check-in JT'}}: </label>
                                             <select class="form-control justificacion_tardia" id="justificacion_tardia" name="justificacion_tardia" style=" width: 100%;">
                                                <option value="TODOS">-All-</option>
                                                <option value="SI">SI</option>
                                                <option value="NO">NO</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div id="div_primer_checkin" class="col-md-2 col-sm-3 col-xs-12">
                                    <!--    <div class="form-group">
                                            <label>{{'1st. Site Check-in'}}: </label>
                                             <select class="form-control primer_checkin" id="primer_checkin" name="primer_checkin" style=" width: 100%;">
                                                <option value="TODOS">-All-</option>
                                                <option value="SI">SI</option>
                                                <option value="NO">NO</option>
                                            </select>
                                        </div> -->
                                    </div>                                    
                                    <div class="col-md-2 col-sm-3 col-xs-12" id="parametros">
                                        <div class="form-group">
                                            <label for="generar">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</label>
                                            <button class="btn btn-primary form-control" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
                                        </div>
                                    </div>
                                    <div class="col-md-6 col-sm-6 col-xs-12" id="parametros">
                                        <div class="form-group">
                                            
                                        </div>
                                    </div>
                                </div>
                            {% else %}
                                <input type="hidden" id="brigada" name="brigada" value="">
                                <input type="hidden" id="asp" name="asp" value="">
                                <input type="hidden" id="entrada_sitio" name="entrada_sitio" value="TODOS">
                                <div class="row">        
                                    <div id="div_cliente" class="col-md-4 col-sm-6 col-xs-12">
                                        <div class="form-group">
                                            <label>{{'monitores.proyecto' | trans}}: </label><br>
                                            <select class="form-control get-list proyecto" id="proyecto" name="proyecto" data='region' data-campo-filtro='proyecto' data-campo-mostrar='region' data-act='refresh_region' multiple="multiple" style="width: 100%;" data-div-siguiente="div_region">
                                                <!--<option value="TODOS">-- All -- </option>-->
                                                {%for proyecto in proyectos %}
                                                    <option value="{{proyecto.valor}}">{{proyecto.nombre}}</option>
                                                {%endfor%}
                                            </select>
                                        </div>
                                    </div>
                                    <div id="div_region" class="col-md-3 col-sm-6 col-xs-12">
                                        <div class="form-group">
                                             <label>{{'Region'}}: </label><br>
                                             <select class="form-control region refresh_region refresh_proyecto refresh_asp refresh_brigada" id="region" name="region" style=" width: 30%;">
                                                <!--<option value="TODOS">-- All --</option>-->
                                            </select>
                                        </div>
                                    </div>
                                    <div id="div_primer_checkin" class="col-md-2 col-sm-6 col-xs-12">
                                        <div class="form-group">
                                            <label>{{'1st. Site Check-in'}}: </label>
                                             <select class="form-control primer_checkin" id="primer_checkin" name="primer_checkin" style=" width: 50%;">
                                                <option value="TODOS">-All-</option>
                                                <option value="SI">SI</option>
                                                <option value="NO">NO</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-2 col-sm-6 col-xs-12" id="parametros">
                                        <div class="form-group">
                                            <label for="generar">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</label>
                                            <button class="btn btn-primary form-control" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
                                        </div>
                                    </div>
                                    <div class="col-md-1 col-sm-6 col-xs-12">
                                        
                                    </div>
                                </div>                                
                            {% endif %}
                            </div> 
                        </div>                        
                    </div>
                
            </div>
            {% if idproyectos==60 %}                         
                <input type="hidden" name="cliente" id="cliente" value="AT&T">
            {% else %}
                <input type="hidden" name="cliente" id="cliente" value="TELCEL">
            {% endif %}  
        </form>

        <div class="row">
            <div class="col-md-12 text-center">
                <h1 class="text-center text-primary">
                    <i class="fa fa-file-text-o"></i> <strong>DASHBOARD</strong>
                </h1>
            </div>
        </div> 
        <div class="row">
            <div id="panel_content" class="col-lg-12"> 
                <div class="panel with-nav-tabs panel-primary">
                    <div class="panel-heading">
                        <ul class="nav nav-tabs" id="myTabs">                           
                            <li role="presentation" id="tabsHorasAtt" class="click_tab"><a data-toggle="tab" href="#_tabsHorasAtt"><strong>Checkin vs Hora de Llegada</strong></a></li> 
                            {% if idproyectos==11 %}  
                                <!--<li role="presentation" id="tabsCita" class="click_tab"><a data-toggle="tab" href="#_tabsCita"><strong>Checkin vs Hora de Cita</strong></a></li>--> 
                            {% endif %}
                            {% if departamento_user!=33 %}                         
                                 <li role="presentation" id="tabsHorasSalida" class="click_tab"><a data-toggle="tab" href="#_tabsHorasSalida"><strong>Checkout</strong></a></li> 
                            {% endif %}                                    
                        </ul>
                    </div>
                    <div class="panel-body">
                        <div class="col-md-12 text-right" id="mostrar_excel_entrada">
                            <div class="dt-buttons">
                                <a class="dt-button" tabindex="0" aria-controls="tableModalDetalle" id="excelIssues" href="javascript:ExportExcelEntrada()">
                                <span class="dt-button export-excel-issus">Table Excel Checkin</span>
                                </a>
                            </div>
                        </div>
                        <div class="tab-content">                            
                            <!--horas Att -->   
                            <div id="_tabsHorasAtt" class="tab-pane fade">
                                <div class="row" id="chartcontainer_HorasAtt">
                                    <div id="grafico_HorasATT" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row">
                                    <div id="datatable_HorasATT" class="col-sm-12">
                                        <table id="table_HorasATT" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_HorasATT"></tbody>
                                        </table>
                                    </div>
                                </div>                                
                            </div>
                            <!--cita --> 
                            {% if idproyectos==11 %}   
                                <!--<div id="_tabsCita" class="tab-pane fade">
                                    <div class="row" id="chartcontainer_Cita">
                                        <div id="grafico_Cita" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_Cita" class="col-sm-12">
                                            <table id="table_Cita" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_Cita"></tbody>
                                            </table>
                                        </div>
                                    </div>                                
                                </div>-->
                            {% endif %}
                            <!--horas Salida Att -->   
                            <div id="_tabsHorasSalida" class="tab-pane fade">
                                <div class="row" id="chartcontainer_HorasAtt">
                                    <div id="grafico_HorasSalida" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row">
                                    <div id="datatable_HorasSalida" class="col-sm-12">
                                        <table id="table_HorasSalida" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_HorasSalida"></tbody>
                                        </table>
                                    </div>
                                </div>                                
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>   
    </div> 
    <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document" style="width: 1300px">
            <div class="modal-content">
                <div class="modal-header">
                    <h2 class="modal-title text-center" id="myModalLabel"><strong>{# {'monitorii.detail' | trans } #}<span class="modal_detalle_titulo"></span></strong></h2>
                    <div class="punto-grafica text-center"></div>
                </div>
                <div class="modal-body">
                    <div class="tabla-datos">

                    </div>                    
                    <div id="datatableModalDetalle" class="col-sm-12" {#style="overflow-x: scroll"#}>
                        <table id="tableModalDetalle" class="display nowrap" width="100%">
                            <tbody id="tbodyModalDetalle">
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-claro" data-dismiss="modal">
                        {{'monitorii.close' | trans}}
                        <span class="glyphicon glyphicon-remove"></span>
                    </button>
                </div>
            </div>
        </div>
    </div>

{% endblock %}
{% block javascripts %}
    <link rel="stylesheet" href="{{ asset('css/jquery.dataTables.min.css')}}">
    <link rel="stylesheet" href="{{ asset('css/buttons.dataTables.min.css')}}">
    <link rel="stylesheet" href="{{ asset('datatables/css/select.bootstrap.min.css')}}">
    <script src="{{ asset('js/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('js/buttons.flash.min.js') }}"></script>
    <script src="{{ asset('js/jszip.min.js') }}"></script>
    <script src="{{ asset('js/pdfmake.min.js') }}"></script>
    <script src="{{ asset('js/vfs_fonts.js') }}"></script>
    <script src="{{ asset('js/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('js/buttons.print.min.js') }}"></script>
    <script src="{{ asset('datatables/js/dataTables.select.min.js') }}"></script>
    <script src="{{ asset('datatables/moment.min.js') }}"></script>
    <script src="{{ asset('datatables/js/datetime-moment.js') }}"></script>
    <script src="{{ asset('js/grouped-categories.js') }}"></script>

{% endblock %}