{% extends '::base.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;
        }
        .nav-link.active {
            font-weight: bold;
        }

        .badge {
            font-size: 85%;
        }
  </style>
  
  <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
  <script src="{{asset('js/jquery.doubleScroll.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>
    $(function () {
      
      $("#generar").click(function(){
        $.isLoading({
          text:       "Loading"
        });
        reporteCorrectivoAperturaAditional();
      });
      
      $('#txtStartDate').datepicker({
          dateFormat: 'yy-mm-dd',
          onClose: function (selectedDate) {
              $("#txtEndDate").datepicker("option", "minDate", selectedDate);
          }
      });
      
      $('#txtEndDate').datepicker({
          dateFormat: 'yy-mm-dd',
      });
      
      var f = new Date();
      var month = (f.getMonth() + 1);
      
      if (month < 10) month = '0' + month;
        var dateI = f.getFullYear() + '-' + month + "-01";
        var dateF = f.getFullYear() + '-' + month + "-" + f.getDate();
        $('#txtStartDate').val(dateI);
        $('#txtEndDate').val(dateF);
        $("#clear").click(function(){
          $("#proyecto").val("TODOS");
          $('#Filtros_fechaIni').val("");
          $('#Filtros_fechaFin').val("");
      });

            $('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);
                }
            } );

//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 country = $("#pais").val();
          var data = {
              valor_filtro : $(this).val(),
              campo_filtrar : campo_filtrar,
              campo_mostrar : campo_mostrar,
              country: country,
          };
          //console.log(data);
          $("."+data_act+" option").remove();
          $("."+data_act).append('<option value="TODOS">-- All --</option>');
          if ($(this).val()!='TODOS'){                    
              $.getJSON('{{path('additional_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>');
                  }
              });
          }
      });
     
  });


  function myFunction(index , idelment) {
    // Declare variables
    var input, filter, table, tr, td, i, tmpstr;

    input = document.getElementById('id'+index+'id');
    //   index =index-1;
    filter = input.value.toUpperCase();
    table = document.getElementById("tabla1");
    tr = table.getElementsByTagName("tr");

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

      td = tr[i].getElementsByTagName("td")[index];

      if (td) {
          tmpstr = td.innerHTML.toUpperCase();
        if (tmpstr.search(filter) > -1) {
           tr[i].style.display = "";
        } else {
          if(i>1) {
            tr[i].style.display = "none";
          }
        }
      }
    }
  }
  
  
        function resizeChart(){
            try{
                var panel_width = $('#panel_content').width();
                var offset = 32;

                $('#grafico_Causas').width(panel_width-offset);
                $('#grafico_Ofensores').width(panel_width-offset);
                $('#grafico_Reportes').width(panel_width-offset);
                $('#grafico_Mayorprecio').width(panel_width-offset);

                if ($("#grafico_Causas").highcharts()!=undefined){ 
                    $('#grafico_Causas').highcharts().reflow();  
                } 
                if ($("#grafico_Ofensores").highcharts()!=undefined){ 
                    $('#grafico_Ofensores').highcharts().reflow();  
                }
                if ($("#grafico_Reportes").highcharts()!=undefined){ 
                    $('#grafico_Reportes').highcharts().reflow();  
                }
                if ($("#grafico_Mayorprecio").highcharts()!=undefined){ 
                    $('#grafico_Mayorprecio').highcharts().reflow();  
                }

                $('#grafico_CausasR').width('70%');
                if ($("#grafico_CausasR").highcharts()!=undefined){ 
                    $('#grafico_CausasR').highcharts().reflow();  
                }
                $('#grafico_OfensoresR').width('70%');
                if ($("#grafico_OfensoresR").highcharts()!=undefined){ 
                    $('#grafico_OfensoresR').highcharts().reflow();  
                }
                $('#grafico_MayorprecioR').width('70%');
                if ($("#grafico_MayorprecioR").highcharts()!=undefined){ 
                    $('#grafico_MayorprecioR').highcharts().reflow();  
                }
                $('#grafico_ReportesR').width('70%');
                if ($("#grafico_ReportesR").highcharts()!=undefined){ 
                    $('#grafico_ReportesR').highcharts().reflow();  
                }                

                
         
                //redrawDt();
            }catch(err) {
                //console.log(err.message);
            }
        }

        $(window).resize(function(){
            resizeChart();

        });
        $(".click_tab").click(function(){
            resizeChart();
        });        


  function reporteCorrectivoAperturaAditional(){
    
    parametros = {};
    if($('#cluster').val()!='TODOS'){
       var cluster = $('#cluster').val();
    }else{
        if ($("#cluster_user").val()==null || $("#cluster_user").val()==''){
            var cluster = 'TODOS';
        }else{
            var cluster = $("#cluster_user").val();
        }
    } 
    if (cluster=='TODOS'){
        parametros['cluster']=" is not null";
      }else{
        parametros['cluster']="='"+cluster + "'";    }

    if ($("#pais").val()=='TODOS'){
        parametros['pais']=" is not null";
      }else{
        parametros['pais']="='"+$("#pais").val() + "'";
    }

    if ($("#cliente").val()=='TODOS'){
        parametros['cliente']=" is not null";
      }else{
        parametros['cliente']="='"+$("#cliente").val() + "'";
    }
   
    if ($("#proyecto").val()=='TODOS'){
        parametros['proyecto']=" is not null";
      }else{
        parametros['proyecto']="='"+$("#proyecto").val() + "'";
    }

    if ($("#asp").val()=='TODOS'){
        parametros['asp']=" is not null";
      }else{
        parametros['asp']="='"+$("#asp").val() + "'";
    }

    if ($("#status").val()=='TODOS'){
        parametros['status']=" is not null";
      }else{
        parametros['status']="='"+$("#status").val() + "'";
    }

    if ($("#charged_customer").val()=='TODOS'){
        parametros['charged_customer']=" (tr.isCustomer is null or tr.isCustomer is not null)";
      }else{
        parametros['charged_customer']="tr.isCustomer='"+$("#charged_customer").val() + "'";
    } 
    parametros['fechaIni'] = $("#txtStartDate").val();
    parametros['fechaFin'] = $("#txtEndDate").val();
    
      {%if direc == "td2.valor" or direc ==""%}
        parametros['direc']=" td2.valor";
      {%else%}
        parametros['direc']="'"+'{{direc}}' + "'";
      {%endif%}

     $.getJSON('{{path('cargarDashboard',{'idproyectos':idproyectos,'idmodule':idmodule})}}',parametros, function (data) {
      var causas  = data.causas;
      var ofensores  = data.ofensores;
      var mayorprecio  = data.mayorprecio;
      var reportes  = data.reportes;
//render, categoria, series, title, w,target_line, target_line2, target_line3, inicio, fin, asp, orderArray, path, rawData
        if (causas.categories.length > 0){
            $("#grafico_Causas").empty();
            var series = getDataToObjectSerieAll(causas.data,Object.keys(causas.data[0]));
            createChartColumn('grafico_Causas', causas.categories, series, 'Pareto Chart - Most Common Reasons for Requesting Additional',
                   null, null, null, null, parametros ,null,"{{ path('additional_graficas_detalles') }}", causas.data);            
        }else{
            if ($("#grafico_Causas").highcharts()!=undefined){
                $("#grafico_Causas").highcharts().destroy();
            }                    
            $("#grafico_Causas").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
        }
        
        if (ofensores.categories.length > 0){
            $("#grafico_Ofensores").empty();
            var series = getDataToObjectSerieAll(ofensores.data,Object.keys(ofensores.data[0]));
            createChartColumn('grafico_Ofensores', ofensores.categories, series, 'Pareto Chart - Worst Offenders',
                   null, null, null, null,parametros,null,"{{ path('additional_graficas_detalles') }}", ofensores.data);       
        }else{
            if ($("#grafico_Ofensores").highcharts()!=undefined){
                $("#grafico_Ofensores").highcharts().destroy();
            }                    
            $("#grafico_Ofensores").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
        }      
        
        if (mayorprecio.categories.length > 0){
            $("#grafico_Mayorprecio").empty();
            var series = getDataToObjectSerieAll(mayorprecio.data,Object.keys(mayorprecio.data[0]));
            createChartColumn('grafico_Mayorprecio', mayorprecio.categories, series, 'Pareto chart - ASPs with the Highest Amount of Money Paid',
                   null, null, null, null, parametros,null,"{{ path('additional_graficas_detalles') }}", mayorprecio.data);      
        }else{
            if ($("#grafico_Mayorprecio").highcharts()!=undefined){
                $("#grafico_Mayorprecio").highcharts().destroy();
            }                    
            $("#grafico_Mayorprecio").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
        }
        
        if (reportes.categories.length > 0){
            $("#grafico_Reportes").empty();
            var series = getDataToObjectSerieAll(reportes.data,Object.keys(reportes.data[0]));
            createChartColumn('grafico_Reportes', reportes.categories, series, 'Pareto Chart - ASPs with the highest Requested Items',
                   null, null, null, null, parametros,null,"{{ path('additional_graficas_detalles') }}",  reportes.data)
        }else{
            if ($("#grafico_Reportes").highcharts()!=undefined){
                $("#grafico_Reportes").highcharts().destroy();
            }                    
            $("#grafico_Reportes").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
        }  
        
// Pestaña Resumen
        if (causas.categories.length > 0){
            $("#grafico_CausasR").empty();
            var series = getDataToObjectSerieAll(causas.data,Object.keys(causas.data[0]));
            createChartColumn('grafico_CausasR', causas.categories, series, 'Pareto Chart - Most Common Reasons for Requesting Additional',
                  null, null, null, null, parametros,null,null, causas.data,320);            
        }else{
            if ($("#grafico_CausasR").highcharts()!=undefined){
                $("#grafico_CausasR").highcharts().destroy();
            }                    
            $("#grafico_CausasR").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
        }
        
        if (ofensores.categories.length > 0){
            $("#grafico_OfensoresR").empty();
            var series = getDataToObjectSerieAll(ofensores.data,Object.keys(ofensores.data[0]));
            createChartColumn('grafico_OfensoresR', ofensores.categories, series, 'Pareto Chart - Worst Offenders',
                   null, null, null, null, parametros,null,null,  ofensores.data,320);       
        }else{
            if ($("#grafico_OfensoresR").highcharts()!=undefined){
                $("#grafico_OfensoresR").highcharts().destroy();
            }                    
            $("#grafico_OfensoresR").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
        }      
        
        if (mayorprecio.categories.length > 0){
            $("#grafico_MayorprecioR").empty();
            var series = getDataToObjectSerieAll(mayorprecio.data,Object.keys(mayorprecio.data[0]));
            createChartColumn('grafico_MayorprecioR', mayorprecio.categories, series, 'Pareto chart - ASPs with the Highest Amount of Money Paid',
                   null, null, null, null, parametros,null,null,  mayorprecio.data,320);      
        }else{
            if ($("#grafico_MayorprecioR").highcharts()!=undefined){
                $("#grafico_MayorprecioR").highcharts().destroy();
            }                    
            $("#grafico_MayorprecioR").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
        }
        
        if (reportes.categories.length > 0){
            $("#grafico_ReportesR").empty();
            var series = getDataToObjectSerieAll(reportes.data,Object.keys(reportes.data[0]));
            createChartColumn('grafico_ReportesR', reportes.categories, series, 'Pareto Chart - ASPs with the highest Requested Items',
                   null, null, null, null, parametros,null,null,  reportes.data,320)
        }else{
            if ($("#grafico_ReportesR").highcharts()!=undefined){
                $("#grafico_ReportesR").highcharts().destroy();
            }                    
            $("#grafico_ReportesR").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
        }          
        resizeChart();
        
      $.isLoading("hide");

    });
 }
 
  function getDataToObjectSerieAll(data, header){
            var arrayReturn = new Array();
            var data1 = new Array();
            var menor = 1000;
            var mayor = -1;
            var total = 0;
            var valorA=0;
            var dataAux = new Array()
            
            for (var i = 0; i < header.length; i++){
                var dataAux = new Array();
                var dataAux1 = new Array();
                valorA=0;
                total = 0;
                if (header[i].indexOf('_cat_') < 0){
                    for (var j=0; j<data.length; j++){
                        
                        var valor = parseFloat(data[j][header[i]]);
                        valorA+= valor; 
                        total+=valor;
                        dataAux.push(valor);
                        dataAux1.push(valorA); 
                        console.log(valorA);
                        if (valor < menor){
                            menor = valor;
                        }
                        if (valor > mayor){
                            mayor = valor;
                        }
                        
                    }

                    for (var k=0; k<dataAux1.length; k++){
                        dataAux1[k]=Math.round(parseFloat((dataAux1[k]/total)*100));
                    }

                    if(header[i]!="pareto") arrayReturn.push({'name': header[i], 'data': dataAux, 'dataLabels': {'enabled': true}});
                    arrayReturn.push({'name': 'pareto1', 'data': dataAux1, 'dataLabels': {'enabled': true}});
                }
            }
            data1[0] = arrayReturn;
            data1[1] = menor;
            data1[2] = mayor;
            return data1;
        }
        
  function createChartColumn(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, parametros, orderArray, path, rawData,height){
            //ajustar la serie para la doble axies
            var arrayReturn = new Array();
            var data = new Array();           
            if (series.length>0){
                $.each(series, function(key, value) {
                    $.each(value, function(k, v) { 
                        //data.push({"name":v.name,"data":v.data,type: 'column'});
                        
                            if(k==0){ 
                               data.push({"name":v.name,"data":v.data,type: 'column'});
                            }else{
                                data.push({"name":"%","data":v.data,yAxis: 1});
                            }                        
                    });
                });
            }                   
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            switch (render){
                case 'grafico_Causas':
                        rotation = -45;
                        break;    
                case 'grafico_CausasR':
                        rotation = -45;
                        break;                                    
            }
            console.log(data);
            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=35;
                }   
            }else{
                var yMax=35;
            } 
            console.log(yMax);   
            //var height = 320;
             var options = {
                chart: {
                    //height: height,
                    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: ''
                  },
                  enableMouseTracking : false,
                  xAxis: {
                        categories: [],
                        lineWidth: 1,
                        lineColor: '#4c4c4c',
                        //tickColor: '#4c4c4c',
                        //tickWidth: 1,
                        //minorTickWidth: 1,
                        crosshair: true,
                        labels: {
                            groupedOptions: [{ // 1st-level
                                autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                //rotation: -30,
                                lineWidth: 1,
                                tickWidth: 1,
                                style: {
                                    fontSize: '10px',
                                    color: '#333333'
                                    //color: '#4c4c4c'
                                }
                            }, // 2nd-level
                                {
                                    autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                    //rotation: 0,
                                    lineWidth: 0,
                                    tickWidth: 0,
                                    //align: 'right',
                                    style: {
                                        fontSize: '9px',
                                        color: '#333333'
                                        //color: '#4c4c4c'
                                    }
                                }
                            ],
                            //step: step,
                            lineWidth: 0,
                            tickWidth: 0,
                            rotation: 0,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            },
                            formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                                if(this.value.length > 15){
                                    return this.value.substring(0, 15) + '...';
                                }
                                return this.value;
                            }
                        },
                        overflow: 'justify',
                        scrollbar: {
                            enabled: false
                        }
                  },
                  plotOptions:{
                    column: {
                        pointPadding: 0.2,
                        borderWidth: 0,
                        depth: 40,
                        dataLabels: {
                            enabled: true,
                            crop: false,
                            overflow: 'none'
                        }
                    },
                    series:{
                        shadow:true,
                        dataLabels: {
                            enabled: true,
                            style: {
                                fontWeight: 'bold'
                            }
                        }
                    }
                },
                responsive: {
                    rules: [{
                        condition: {
                            maxWidth: 500
                        },
                        chartOptions: {
                            legend: {
                                align: 'center',
                                verticalAlign: 'bottom',
                                layout: 'horizontal'
                            },
                            yAxis: {
                                labels: {
                                    align: 'left',
                                    x: 0,
                                    y: -5
                                },
                                title: {
                                    text: null
                                }
                            },
                            subtitle: {
                                text: null
                            },
                            credits: {
                                enabled: false
                            }
                        }
                    }]
                },
                legend: {
                    backgroundColor: 'rgba(66, 139, 202, 0.5)'

                },

                  yAxis: [{ // Primary yAxis
                    plotLines: [
                        {
                            value: 0,
                            width: 1,
                            color: '#808080'
                        }
                    ],
                    title: {
                      text: 'Qty',
                      style: {
                        color: Highcharts.getOptions().colors[1]
                      }
                    },
                    min: 0,
                    //tickPositions: [0,1,2,5,10,20,30,yMax],
                    tickPositioner: function () {
                        var positions = [],
                            tick = Math.floor(this.dataMin),
                            increment = Math.ceil((this.dataMax - this.dataMin) / 6);

                        if (this.dataMax !== null && this.dataMin !== null) {
                            for (tick; tick - increment <= this.dataMax; tick += increment) {
                                positions.push(tick);
                            }
                        }
                        return positions;
                    }
                  },{ // Secondary yAxis
                    title: {
                      text: 'Percent (%)'
                    },
                    //max: 100,
                    min: 0,
                    tickPositions: [0,10,20,30,40,50,60,70,80,90,100],
                    opposite: true,
                    labels: {
                        format: "{value}%"
                    },
                  }],
                  tooltip: {
                    shared: false
                  },
                  colors: ['#275f76', '#e55550', '#4fa165', '#910000', '#1aadce',
                            '#492970', '#f28f43', '#77a1e5', '#c42525', '#a6c96a'],                  
                  series: data
            };            

            if (target_line != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line[0],
                    color: '#2e8201', //Verde Grama
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: -10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line[1]
                    }
                };
            }

            if (target_line2 != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line2[0],
                    color: '#7cf23c', //Verde Manzana
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: -10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line2[1]
                    }
                };
                
            }

            if (target_line3 != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line3[0],
                    color: '#f7e81d', //Amarillo
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: 10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line3[1]
                    }
                };               
            }

            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {
                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true,
                            formatter: function () {
                                if (this.series.name=='%OTD'){
                                    return this.point.y.toFixed(2) + '%';
                                }else{
                                    if (this.point.y!=0){
                                        return this.point.y;
                                    }                                
                                }
                            }
                        },   
                        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('prueba',row,rawData,'path',path);
                                        var categoriaDetalle =  row['_cat_Causes'];
                                        var selected_serie = this.series.name;  
                                        if (render=='grafico_Causas' || render=='grafico_Ofensores' || render=='grafico_Mayorprecio' || render=='grafico_Reportes'){              
                                            var t ='';
                                            if (render=='grafico_Causas'){
                                                categoriaDetalle =   row['_cat_Causes'];        
                                                t = 'Detail Causes';
                                                parametros['kpi']='DETALLE_CAUSAS';
                                            }else if (render=='grafico_Ofensores'){
                                                categoriaDetalle =   row['_cat_Offender'];   
                                                t = 'Detail Offender';
                                                 parametros['kpi']='DETALLE_OFENSORES';
                                            }else if (render=='grafico_Mayorprecio'){
                                                categoriaDetalle =   row['_cat_ASP']; 
                                                t = 'Detail Mayor Precio';
                                                 parametros['kpi']='DETALLE_MP';
                                            }else if (render=='grafico_Reportes'){
                                                categoriaDetalle =   row['_cat_ASP']; 
                                                t = 'Detail reports';
                                                 parametros['kpi']='DETALLE_REPORTES';  
                                            }
                                           
                                            var title_detalle = t;
                                            var subtitle_detalle = selected_serie;
                                            if (row._cat_Project){
                                                parametros['proyecto'] = row._cat_Project;
                                                subtitle_detalle+="["+row._cat_Project+"]";
                                            }                                           
                                            if (row._cat_Customer){
                                                parametros['cliente'] = row.__cat_Customer;
                                                subtitle_detalle+="["+row._cat_Customer+"]";
                                            }                                           
                                            if (row._cat_Cluster){
                                                parametros['cluster'] = row._cat_Cluster;
                                                subtitle_detalle+="["+row._cat_Cluster+"]";
                                            }                                           
                                            if (row._cat_Country){
                                                parametros['pais'] = row._cat_Country;
                                                subtitle_detalle+="["+row._cat_Country+"]";
                                            }
                                        }     
                                        parametros['selected_item'] = categoriaDetalle;
                                        generateModal(path, parametros, false,  title_detalle, subtitle_detalle, orderArray);
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }

            var num = categoria.length;

            var baseMargin = render=='graficoDashAsp' ? 170 : 90;
            var marginBottom = baseMargin + ((num-1) * 20);
            var menor = series[1];
            var mayor = series[2];
            options.chart.marginBottom = marginBottom;


            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]);
                    }
                }
            }
            if (render!='graficoCFIssues'){
                if (menor >50) menor= 50;
                options.yAxis[0].min=menor;
            } 
            return $('#' + render).highcharts(options);
        }


 ////////Descomentar/////////////////////////////////////////////////

 
  function getTotal(valor,key,tipo) {
      var total = new Array();
      var 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,type){
            console.log(monitor,monitor[0]);
            var header = Object.keys(monitor[0]);
            var headerType = Object.keys(type);
            var table = '<table  class="table table-bordered table-hover table-striped table-responsive table1" id="tableSitios"> <thead>' +'<tr class="btn-info">';
            for (var j = 0; j < header.length; j++) {
                if( j != 0){
                    table += "<th class='text-center'>" + header[j] + "</th>"
                }
            }
            table += "</tr></thead>";
            for (var i = 0; i < monitor.length; i++) {
                table += "<tr id='"+ monitor[i][header[0]] +"'>";
                for (var j = 0; j < header.length; j++) {

                        if( $.inArray(j,headerType))
                        {
                            var typeString = 'id="' + type[j] + '"';

                        }
                    if( j != 0) {
                        if (header[j] == 'STATUS'){                       
                            var traduccion = traducirStatus(monitor[i][header[j]]);
                            table += "<td class='text-center' style='vertical-align:middle;'>" + traduccion.toUpperCase() + "</td>";
                        }else if (header[j]!='idticket' && header[j]!='proyect' && header[j]!='ref' && header[j]!='TOTAL_ITEM' && header[j]!='TOTAL_APROBADOS' && header[j]!='TOTAL_ITEM_FUERA_LPU' && header[j]!='TOTAL_ITEM_POR_VALIDAR'){
                                table += "<td class='text-center' style='vertical-align:middle;'>" + monitor[i][header[j]] + "</td>";
                        }                        
                        
                        
                        //table += "<td " + typeString + ">" + 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 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;
  }
  
        $('html').on('click', '.openModal', open);

        // este metodo ya no es esta usando en las tablas de datos, por ejemplo workmanship
        function open(){
            $('#myModal');
            $('#myModal .tabla-datos').empty();
            $('#myModal .punto-grafica').empty();

            if ($(this).text() == 0)
                return false;

            generateModal($(this).attr('data-load-remote'));
        }
        

       function generateModal(ruta, objParams, numerar, title, subtitle, orderArray)
        {        
          
            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();
            }
            console.log(ruta, objParams);
            $.getJSON(ruta, objParams, function (data)
            {
                if (data.length > 0){ 
                    var total_general = 0; 
                    var porcentaje_ohs = 0; 
                    var total_registros = 0;                          
                    var col = createTableDTDetail(Object.keys(data[0]),'tableModalDetalle', 'datatableModalDetalle',objParams.kpi,porcentaje_ohs,total_registros);
                    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');
        }

        $('#myModal').on('hidden.bs.modal', function (){
            $('#myModal .tabla-datos').isLoading('hide');
        });  
        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();                            
            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 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: '60vh',
                scrollX: true,
                scrollCollapse: true,
                orderCellsTop: true,
                data:data,
                "deferRender": false,
                "processing": true,
                "language": {
                    "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                },
                "order": [[ 0, "asc" ]],
                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_' + kpi
                    }
                ],
                drawCallback: function() {
                    $('[data-toggle="popover"]').popover();
                } 
            } );
        } 

    </script>
            
 <div class="container-fluid">  
    <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">     
        <div class="row" style="margin-top: 20px;">
            <input type="hidden" name="cluster_user" id="cluster_user" value="{{ data_user.cluster_user }}">
            <input type="hidden" name="country_user" id="country_user" value="{{ data_user.country_user }}">
            <input type="hidden" name="project_user" id="project_user" value="{{ data_user.project_user }}">
            <input type="hidden" name="asp_user" id="asp_user" value="{{ data_user.asp_user }}">
            <div class="col-lg-3" id="parametros">
                <label>Cluster: </label>
                <select class="form-control get-list" id="cluster" name="cluster" data='pais'
                data-act='refresh_pais' data-campo-filtro='td3' data-campo-mostrar='td'>                 
                  <option value="TODOS">-- All -- </option>
                  {%for cluster in clusters%}
                      <option value="{{cluster.valor}}">{{cluster.nombre}}</option>
                  {%endfor%}
                </select>
            </div>
             <div class="col-lg-3" id="parametros">
                <label>{{'monitores.pais' | trans}}: </label>
               <select class="form-control get-list refresh_pais" id="pais" name="pais" data='cliente'
                data-act='refresh_cliente' data-campo-filtro='td' data-campo-mostrar='td4'>                 
                  <option value="TODOS">-- All -- </option>
                </select>
            </div>
            <div class="col-lg-3" id="parametros">
                <label>{{'monitores.cliente' | trans}}: </label>
               <select class="form-control get-list refresh_cliente refresh_pais" id="cliente" name="cliente"  data='proyecto'
                data-act='refresh_proyecto' data-campo-filtro='td4' data-campo-mostrar='td1'>                 
                  <option value="TODOS">-- All -- </option>
                </select>
            </div>                   
            <div class="col-lg-3" id="parametros">
                <label>{{'monitores.proyecto' | trans}}: </label>
               <select class="form-control get-list refresh_proyecto refresh_cliente refresh_pais" id="proyecto" name="proyecto" data='asp'
                data-act='refresh_asp' data-campo-filtro='td1' data-campo-mostrar='td5'> 
                     <option value="TODOS">-- All -- </option>
                </select>
            </div>
        </div>
           
        <div class="row" style="margin-top: 20px;">
            <div class="col-lg-2">
                <label>ASP: </label>
               <select class="form-control refresh_proyecto refresh_cliente refresh_pais refresh_asp" id="asp" name="asp"> 
                     <option value="TODOS">-- All -- </option>
                </select>
            </div>
            <div class="col-lg-2">
                <label>Status: </label>
                <select class="form-control" id="status" name="status">                 
                  <option value="TODOS">-- All -- </option>
                  {%for estatu in estatus%}
                      <option value="{{estatu.valor}}">{{estatu.valor}}</option>
                  {%endfor%}
                </select>
            </div>
            <div class="col-lg-2">
                <label>Charged to Customer: </label>
                <select class="form-control" id="charged_customer" name="charged_customer">                 
                  <option value="TODOS">-- All -- </option>
                  <option value="1">YES</option>
                  <option value="0">NO</option>                  
                </select>
            </div>
            <div class="col-lg-2" id="parametros">
                <label for="txtStartDate">{{'monitor.etiqueta.fechaI' | trans}}: </label>
                <input type="text" class="form-control" id="txtStartDate" name="txtStartDate" value="">
            </div>
            <div class="col-lg-2" id="parametros">
                <label for="txtEndDate">{{'monitor.etiqueta.fechaF' | trans}}: </label>
                <input type="text" class="form-control" id="txtEndDate" name="txtEndDate" value="">
            </div>
            <div class="col-lg-2" id="parametros" ><br>
                <button class="btn btn-primary col-lg-5" id="generar">{{'monitoriii.generate' | trans}}</button>
            </div>
            <div class="col-lg-2" id="parametros" ><br>
                
            </div>
        </div>
            </div></div></div>
        <div class="row">
            <div class="col-lg-12 col-md-12">
                <h1 class="text-center text-primary"><i class="fa fa-file-text-o"></i>
                    {{'Dashboard' | trans}}
                </h1>
            </div>            
            {% if identity is not empty %}               
                <div class="pull-right" style="">
                    <div class="col-lg-12">
                        <img id="logo" src="{{ asset( identity.pathLogo ) }}"  width="350" height="65">
                        <p class="text-center" style="font-size: 14pt;font-weight: bold;">{{ identity.alias }}</p>
                    </div>
                </div>                
            {% endif %}
        </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="tabsSummary" class="click_tab active"><a data-toggle="tab" href="#_tabsSummary">Summary</a></li>                                  
                            <li role="presentation" id="tabsCausas" class="click_tab "><a data-toggle="tab" href="#_tabsCausas">Most Common Causes</a></li>      
                            <li role="presentation" id="tabsOfensores" class="click_tab" ><a data-toggle="tab" href="#_tabsOfensores">Worst Offenders</a></li>      
                            <li role="presentation" id="tabsMayorprecio" class="click_tab" ><a data-toggle="tab" href="#_tabsMayorprecio">Highest Amount Paid by ASP</a></li>  
                            <li role="presentation" id="tabsReportes" class="click_tab" ><a data-toggle="tab" href="#_tabsReportes">Highest items by ASP</a></li>  
                        </ul>
                    </div>
                    <div class="panel-body">
                        <div class="tab-content">
                            <div id="_tabsSummary" class="tab-pane active">                        
                                <div class="row">
                                    <div class="col-lg-6" style="display:true" id="kpi1" style="width: 100%; min-width: 320px;">
                                        <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                            <div class="panel-heading">Most Common Causes</div>
                                            <div class="panel-body fixed-panel" id="grafico_CausasR" style="width:45.5%;height: 400px !important;">

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-lg-6" style="display:true" id="kpi2" style="width: 100%; min-width: 320px;">
                                        <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                            <div class="panel-heading">Worst Offenders</div>
                                            <div class="panel-body fixed-panel" id="grafico_OfensoresR" style="width:45.5%;height: 400px !important;">

                                            </div>
                                        </div>

                                    </div>
                                </div> <!-- end row2-->
                                <div class="row">
                                    <div class="col-lg-6" style="display:true" id="kpi3" style="width: 100%; min-width: 320px;">
                                        <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                            <div class="panel-heading">Highest Amount Paid by ASP</div>
                                            <div class="panel-body fixed-panel" id="grafico_MayorprecioR" style="width:45.5%;height: 400px !important;">
                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-lg-6" style="display:true" id="kpi4" style="width: 100%; min-width: 320px;">
                                        <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                            <div class="panel-heading">Highest items by ASP</div>
                                            <div class="panel-body fixed-panel" id="grafico_ReportesR" style="width:45.5%;height: 400px !important;">

                                            </div>
                                        </div>

                                    </div>
                                </div> <!-- end row2-->
                            </div>                                
                            <div id="_tabsCausas" class="tab-pane fade">
                                <div class="row" id="chartcontainer_Causas">
                                    <div id="grafico_Causas" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>                                
                            </div>    
                            <div id="_tabsOfensores" class="tab-pane fade">
                                <div class="row" id="chartcontainer_Ofensores">
                                    <div id="grafico_Ofensores" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>                                
                            </div>   
                            <div id="_tabsMayorprecio" class="tab-pane fade">
                                <div class="row" id="chartcontainer_MayorPrecio">
                                    <div id="grafico_Mayorprecio" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>                                
                            </div>    
                            <div id="_tabsReportes" class="tab-pane fade">
                                <div class="row" id="chartcontainer_Reportes">
                                    <div id="grafico_Reportes" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </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">
            <div class="modal-content" style="width: 1200px;margin: 0px 0px 0px -140px;">
                <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-1.12.4.js') }}"></script-->
    <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>
     <script src="{{ asset('highcharts5/code/modules/data.src.js') }}"></script>

{% endblock %}