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

{% endblock %}

{% block stylesheets %}
    <link rel="stylesheet" href="{{ asset('datatables/css/dataTables.bootstrap.min.css')}}">
    <link rel="stylesheet" href="{{ asset('datatables/css/buttons.bootstrap.min.css')}}">
   <style>
       .double-scroll {
            width: 100%;
            margin-bottom: 20px;
        }

        .tablesorter-pager select {
            margin: 0;
            padding: 0;
            width: 50px;
        }
        table.tablesorter thead tr th {
            background-color:#00569C;
            border: 2px solid #FFF;
            font-size: 8pt;
            text-transform:uppercase;
            padding: 4px;
            text-align: center;
            color: white;
            font-weight: bold;
        }
        .th2
        {
            background-color:#00569C;
              border: 2px solid #FFF;
            font-size: 8pt;
            text-transform:uppercase;
            padding: 4px;
            text-align: center;
            color: white;
            font-weight: bold;
        }
 .std {
            background-color:#00569C;
            border: 2px solid #FFF;
            font-size: 8pt;
            text-transform:uppercase;
            padding: 4px;
            text-align: right;
            color: white;
            font-weight: bold;
        }
     .stdLeft {
            background-color:#00569C;
            border: 2px solid #FFF;
            font-size: 8pt;
            text-transform:uppercase;
            padding: 4px;
            text-align: left;
            color: white;
            font-weight: bold;
        }
        .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: 30px;
        }
       /* .table{
            font-size: 12px;
            width: 3000px;
        }
*/
        .estilod{
            background-color: green;

        }

        .estilof{
            background-color: red;

        }
        espacio{
            padding-top: 20px;
        }
    
    .reconocer
        {
            background:#00569C;
            color:#ffffff;
           border-radius: 300px 300px 300px 300px;
            -moz-border-radius: 300px 300px 300px 300px;
            -webkit-border-radius: 300px 300px 300px 300px;
            border: 1px solid #000000;
            height: 38px;
            width: 80px;
            font: oblique bold 120% ;
        }
        .modal-header{
            background:#00569C;
            font:oblique bold;
           text-transform: uppercase;
        }
            
    
.btn-orange {
    color: #fff;
    background-color: #00569C;
    border-color: #ecea19;
}	
</style> 
 <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script src="{{ asset('js/jquery.numeric.js') }}"></script>
    <script src="{{ asset('js/jquery.form.js') }}"></script>
   
    
    
    <script>
                                      
  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";
          }
        
      }
    } 
  }
}
        
        var translation = {



        };

        $(function () {
            
                 var starYear = 2016;
            var d = new Date();
            var year = d.getFullYear();
            var month = new Array();

            $(".checklist").live('click', function () {


                window.location.href = $(this).attr('href');
            });

        for(var i=starYear; year >= i;i++ )
        {
            $('#ano').append($("<option/>", {
                value: i,
                text: i
            }));

        }

            month[0] = "ENERO";
            month[1] = "FEBRERO";
            month[2] = "MARZO";
            month[3] = "ABRIL";
            month[4] = "MAYO";
            month[5] = "JUNIO";
            month[6] = "JULIO";
            month[7] = "AGOSTO";
            month[8] = "SEPTIEMBRE";
            month[9] = "OCTUBRE";
            month[10] = "NOVIEMBRE";
            month[11] = "DICIEMBRE";
            var n = month[d.getMonth()];
            var options = new Array();

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




                if(i <=  d.getMonth()){



                    $('#mes').append($("<option/>", {
                        value: i + 1,
                        text: month[i]
                    }));

                }
            }
                    $("#ano").change(function(){

                        var yearSelected = parseInt($(this).val());
                        var semana = ISO8601_week_no(new Date()) - 1;

                        $('#mes').empty();

                        for(var i=0;i<month.length;i++) {
                            if (yearSelected < year) {
                                $('#mes').append($("<option/>", {
                                    value: i + 1,
                                    text: month[i]
                                }));
                            }else if(i <=  d.getMonth()){
                                $('#mes').append($("<option/>", {
                                    value: i + 1,
                                    text: month[i]
                                }));

                            }
                        }
                        $('#semana').empty();

                            if (yearSelected < year) {
                                    var semana = 52;
                                for(var i=semana;i>=1;i--){

                                    $('#semana').append($("<option/>", {
                                        value: i,
                                        text: i
                                    }));
                                }

                            }else{

                                for(var i=semana;i>=1;i--){

                                    $('#semana').append($("<option/>", {
                                        value: i,
                                        text: i
                                    }));
                                }
                            }





                    });

            $("#tipoBusqueda").on('change load',function(){

                $(this).val() == 'mes' ? $("#mes").removeAttr('class','hide'):$("#mes").addClass('hide');
                $(this).val() == 'semana' ? $("#semana").removeAttr('class','hide'):$("#semana").addClass('hide');
            });

            
            
            
            
            
            
            
            
            
            
            
            
            
            
              $("#generar").click(function(){
                $.isLoading({
                    text:       "Loading"
                });
                    $("#cantidad").html(0);  
                 reporte();

            });

           $('#Filtros_fechaIni').datepicker({
                    dateFormat: 'yy-mm-dd',
                    onClose: function( selectedDate ) {
                             $( "#Filtros_fechaFin" ).datepicker( "option", "minDate", selectedDate );

                    }
            }); 

            $('#Filtros_fechaFin').datepicker({
                    dateFormat: 'yy-mm-dd',
            });
            
            $("#clear").click(function(){
                $("#region").val("TODOS");      
                $('#Filtros_fechaIni').val("");
                $('#Filtros_fechaFin').val("");  
            });             

            $('#generar').trigger('click');

        });

        function reporte(){
               var inicio;
               var fin;
               var anio;
               var  data = {};
               var tipo  = $("#tipoBusqueda").val();

          
               anio= $("#ano").val();    
               if ($("#mes").val()<10)
               {
                   inicio=anio+"-0"+$("#mes").val()+"-01";
                      fin=anio+"-0"+$("#mes").val()+"-31";
               }
               else
               {
                      inicio=anio+"-"+$("#mes").val()+"-01";
                      fin=anio+"-"+$("#mes").val()+"-31";
               }
             
               data['inicio']=inicio;
               data['fin']=fin;
                 
            $.getJSON('{{path('ReportesCR_ResportesFotograficos')}}',data
          
            , function (data) {
               // alert(data['inicio']);
                        
                    var datos  = data.datos;
                      
                            if(datos.length == 0){

                    $("#primer_reporte").empty();
                    $("#primer_reporte").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                    $.isLoading("hide");
                 

                            }
                    $("#cantidad").html(datos.length);
                    $("#primer_reporte").empty().append(createTable(datos,1));
                    //$("#primer_reporte" ).slider();
                    $.isLoading("hide");
                    
                    
                     var pagerOptions = {
                        // target the pager markup - see the HTML block below
                        container: $(".pager"),
                        // output string - default is '{page}/{totalPages}'; possible variables: {page}, {totalPages}, {startRow}, {endRow} and {totalRows}
                        output: '{startRow} - {endRow} / {filteredRows} ({totalRows})',
                        // if true, the table will remain the same height no matter how many records are displayed. The space is made up by an empty
                        // table row set to a height to compensate; default is false
                        fixedHeight: false,
                        // remove rows from the table to speed up the sort of large tables.
                        // setting this to false, only hides the non-visible rows; needed if you plan to add/remove rows with the pager enabled.
                        removeRows: true,
                        // go to page selector - select dropdown that sets the current page
                        cssGoto: '.gotoPage'
                    };
                    // initial sort set using sortList option
                  $(".table8").tablesorter({
                        theme: 'blue',
                        // sort on the first column and second column in ascending order
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            // extra css class applied to the table row containing the filters & the inputs within that row
                            filter_cssFilter: '',
                            // If there are child rows in the table (rows with class name from "cssChildRow" option)
                            // and this option is true and a match is found anywhere in the child row, then it will make that row
                            // visible; default is false
                            filter_childRows: false,
                            // if true, filters are collapsed initially, but can be revealed by hovering over the grey bar immediately
                            // below the header row. Additionally, tabbing through the document will open the filter row when an input gets focus
                            filter_hideFilters: false,
                            // Set this option to false to make the searches case sensitive
                            filter_ignoreCase: true,
                            // jQuery selector string of an element used to reset the filters
                            filter_reset: '.reset',
                            // Use the $.tablesorter.storage utility to save the most recent filters
                            filter_saveFilters: true
                        }
                    }).tablesorterPager(pagerOptions);
                });
       }
  $("td").live("click",function(e){
        var id = $(this).attr("id");
        if(id!=0)
        {
        var inicio;
               var fin;
               var anio;
               var  data = {};
               var tipo  = $("#tipoBusqueda").val();

          
               anio= $("#ano").val();    
               if ($("#mes").val()<10)
               {
                   inicio=anio+"-0"+$("#mes").val()+"-01";
                      fin=anio+"-0"+$("#mes").val()+"-31";
               }
               else
               {
                      inicio=anio+"-"+$("#mes").val()+"-01";
                      fin=anio+"-"+$("#mes").val()+"-31";
               }
             
               data['inicio']=inicio;
               data['fin']=fin;
                 
         data['sitioForma']=id;
             if(e.target.tagName != 'TD'){ return 0;}
             $('#myModalDetalle .modal-body').empty();
             $('#myModalDetalle').modal();
             $('#myModalDetalle .modal-body').isLoading({
                text:       "Loading",
                position:   "inside"
                });

                 $.ajax({

                url : "{{ path('ReportesCR_ResportesFotograficosDetalles') }}",data
               // data : {'id': id}


            }).done(function(data){

                $('#myModalDetalle .modal-body').empty();
                var tierra = ''
                tierra += '<div class="table-responsive">'
                 tierra += createTable(data.datos,0);
                // alert(data['sql']);
                 tierra += '</div>'
                $('#myModalDetalle .modal-body').append(tierra);
                 $.isLoading("hide");
            });

}
               });

        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,detail){
             var id="0";
            var header = Object.keys(monitor[0]);
           var table = '<table id="tabla1" class="table relleno table-bordered table-hover table-striped table-responsive table1 tablesorter tablesorter-blue hasFilters"> <thead>' +
                   '<tr class="btn-claro">';
            for (var j = 0; j < header.length; j++) {
                 if(header[j] != 'ID'){
                  table+="<th width='5%'>"+header[j]+"</th>";
            }
        }
           table+="</tr></thead>";
        
            for (var i = 0; i < monitor.length; i++) {
               
                 id=0;  
                table += "<tr >";
                clase=null;
                for (var j = 0; j < header.length; j++) {
                    if (monitor[i]['EQUIPO']!='nada')
                        
                        if(header[j] != 'ID')
                    {
                     
                         if( monitor[i][header[j]]=='')
                         {
                              monitor[i][header[j]]="-"
                         }
                         
               if(j==2)
               {
                   id="reportes_fotograficos@"+monitor[i]['ID sitio'];
               }
               if(j==3)
               {
                   id="reportes_fotograficos_atp@"+monitor[i]['ID sitio'];
               }
              if(j==4)
               {
                   id="reportes_fotograficos_vineta@"+monitor[i]['ID sitio'];
               }
                        
                table += "<td id='"+id+"' width='15%' style='vertical-align:middle; text-align:center'>" + 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;
        }
        
        
       
        
     

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

    </script>

<!-- <div class="container">
        <div class="row">
  <div class="container-fluid">
        <div class="row">

            <div class="col-lg-2" id="parametros">

                <select class="form-control" id="ano">
                    <option value="0">Select Year</option>

                </select>
            </div>
            <div class="col-lg-2" id="parametros">

                <select class="form-control" id="tipoBusqueda">
                    <option value="0"> Select Date</option>

                    <option value="mes">MES</option>
                    <option value="ano">A&Ntilde;O</option>

                </select>
            </div>
            <div class="col-lg-3" id="parametros" >
                <select class="hide" id="mes"> -->
    
    <div class="page-header text-center text-muted">
    <!-- <h1 class="eri-font"></h1> -->
    </div>

    <div class="container">
        <div class="row">
            <div class="col-lg-2 eri-font top-uno">
                <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>  
                <input type="text" class="form-control" id="Filtros_fechaIni" value="{{ dateStart }}">
            </div>
            <div class="col-lg-2 eri-font top-uno">
                <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>  
                <input type="text" class="form-control" id="Filtros_fechaFin" value="{{ dateEnd }}">
            </div>
             <br>
                
            <div class="col-lg-3 top-uno" id="parametros">
               <button class="btn btn-claro" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
               <button class="btn btn-claro" id="clear">{{'ticketDetail.boton.limpiar' | trans}}</button>



                </select>
                <select class="hide" id="semana">



                </select>
            </div>


            <!-- <div class="col-lg-2" id="parametros" >
                <button class="btn btn-primary" id="generar">Generar</button>
            </div> -->
         
            
            
            
                              
               <img id="logo" class="pull-right" src="{{ asset('images/telefonica.png') }}"  width="100" height="62" >

            </div>            

         <div class="row">
                <div class="col-lg-12 text-center eri-font top-uno">
                    <h1>{{'MONITOR TOTAL DE FORMAS' | trans | upper}}</h1>
                 </div>

        </div>
        <div class="row">
        <!-- <div class="col-lg-3 eri-font"  style="margin-top: 1%">
                Cantidad :<span id="cantidad" class="bold  eri-font"></span>
             </div>
        -->
             <div class="col-lg-offset-9 top-uno">
                    <div class="btn-group pull-right">
                    <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                    <ul class="dropdown-menu" role="menu">



                        <li><a href="#" onclick="$('#primer_reporte').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>


                    </ul>
                </div>
         </div>
        </div>
        <div class="row">
            <div class="col-lg-12 top-uno" id="primer_reporte">

            </div>

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

                <div class="modal-body">



                   </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">{{'monitorii.close' | trans}}</button>

                </div>

            </div>
        </div>
    </div>
{% endblock %}