@extends('layouts.tracking')

@push('styles')
<!-- Include Date Range Picker -->
<link rel="stylesheet" type="text/css" href="{{asset('css/daterangepicker.css')}}" />
<link rel="stylesheet" type="text/css" href="{{asset('css/beautify-marker-icon.css')}}" />
@endpush
@section('content')

<div class="row" >
    <div class="col-md-12" >
            <div class="card">    
                <div class="card-header">
                    <h1>{{ __('strings.historical') }} SmartLock</h1>
                </div>
                <div class="col-md-12">
                    <div id="reportrange" style="background: #fff; cursor: pointer; padding: 5px 10px; border: 1px solid #ccc;" class="col-md-6">
                        <i class="fa fa-calendar"></i>&nbsp;
                        <span></span> <i class="fa fa-caret-down"></i>
                    </div>
                </div>
                <div class="card-body">
                    <div class="dashboard-widget-content">

                        <div class="col-md-6 col-sm-12 col-xs-12" style="height:650px;">
                            <div id='map'></div>
                        </div>

                        <div class="col-md-6 col-sm-12 col-xs-12">
                            <div style="height: 350px;">
                                <div id="t_chart" style="width: 100%; height: 100%;"></div>
                            </div>
                            <div style="height: 290px;">
                                    <div id="h_chart" style="width: 100%; height: 290px;"></div>
                            </div>
                            <div class="col-md-6" style="display: none">
                                <div class="card p-4">
                                    <div class="card-body d-flex justify-content-between align-items-center">
                                        <div>
                                            <span id="total_fuel" class="h4 d-block font-weight-normal mb-2">0</span>
                                            <span class="font-weight-light">{{__('strings.fuel')}}</span>
                                        </div>
                                        <div class="h2 text-muted">
                                        <i class="fas fa-gas-pump"></i>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-6" style="display: none">
                                <div class="card p-4">
                                    <div class="card-body d-flex justify-content-between align-items-center">
                                        <div>
                                            <span id="total_dist" class="h4 d-block font-weight-normal mb-2">0</span>
                                            <span class="font-weight-light">{{__('strings.distance_traveled')}}</span>
                                        </div>
                                        <div class="h2 text-muted">
                                        <i class="fas fa-tachometer"></i>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

                    </div>
                </div>            
        </div>
    </div>
 </div>
<div class="row">
    <div class="col-md-12 col-sm-12 col-xs-12">
        <div class="card">
            
            <div class="col-md-1 col-sm-1 col-xs-1">                
                <button id="pdf_button" type="button" class="btn btn-primary">
                    <i id="pdfIcon" class="fa fa-file-pdf"></i> &nbsp; PDF
                </button>
            </div>
            <div class="table-responsive">
                             
                <hr>
                <table id="tramas-table" class="table hover mb-0">
                    <thead class="thead-inverse">
                        <tr>
                            <th>ID</th>
                            <th>ALIAS</th>
                            <th>IMEI</th>
                            <th>CMD</th>
                            <th>TRAD</th>
                            <th>LAT</th>
                            <th>LNG</th>
                            <th>VELOCIDAD</th>
                            <th>ESTADO</th>
                            <th>RFID</th>
                            <th>BATERIA</th>
                            {{-- <th>DIR</th> --}}
                            {{-- <th>BAT</th> --}}
                            <th>{{__('strings.date')}}</th>
                            <th>{{__('strings.time')}}</th>
                            <th>S.View</th>
                        </tr>
                    </thead>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script type="text/javascript" src="{{asset('js/daterangepicker.js')}}"></script>
<script src="{{asset('js/leaflet-ant-path.js')}}" type="text/javascript"></script>
<script src="{{asset('js/leaflet.lineextremities.js')}}" type="text/javascript"></script>
<script src="{{asset('js/beautify-marker-icon.js')}}" type="text/javascript"></script>
<script src="{{asset('js/echarts5.6.0.min.js')}}" type="text/javascript"></script>
<script src="{{asset('js/pdfmake.min.js')}}" type="text/javascript"></script>
<script src="{{asset('js/vfs_fonts.js')}}" type="text/javascript"></script>
<script src="{{asset('js/leaflet-image.js')}}" type="text/javascript"></script>
<script>
var map; // leaflet map object
var geoJson; // leaftlet geoJson layer
var path; // leaftlet ant layer
var sMarker; // start marker
var eMarker; // end marker
// chrar objecs
var tChart = null; // temperature chart
var hChart = null; // temperature chart
var table;

var markersLayer;
var lockLayer;
let device = @json($device);


const lockedIcon =  L.icon({
    iconUrl: "{{asset('images/markers/locked.png')}}",
    iconSize:     [24, 24], // size of the icon
    iconAnchor:   [12, 22], // point of the icon which will correspond to marker's location
    popupAnchor:  [0, -6] // point from which the popup should open relative to the iconAnchor
});

const unlockedIcon =  L.icon({
    iconUrl: "{{asset('images/markers/unlocked.png')}}",
    iconSize:     [24, 24], // size of the icon
    iconAnchor:   [12, 22], // point of the icon which will correspond to marker's location
    popupAnchor:  [-4, -6] // point from which the popup should open relative to the iconAnchor
});

$(document).ready(function () {
    initMap();
    initRangePicker();
    initCharts();
    initDataTable({});
    initPdfExporter();
});

function initMap() {
    map = new L.map('map',{attributionControl: true, preferCanvas: true});
    map.setView([{{$device->trama->LAT}}, {{$device->trama->LNG}}], 15);
    L.tileLayer("{{config('app.style_map_uri')}}", {
            maxZoom: 19,
    }).addTo(map);
    
    L.control.fullscreen().addTo(map);
    
    $(document).on('webkitfullscreenchange mozfullscreenchange fullscreenchange', function(e) {
        map.invalidateSize();
    });
    //resize the chart when window resize
    $(window).resize(function () {
            map.invalidateSize();
    });
    
    addLockMarker({!!$device!!});

    markersLayer = L.layerGroup().addTo(map);
    lockLayer = L.layerGroup().addTo(map);
    var overlays = {
        'Estado' : lockLayer
    };
    L.control.layers(null, overlays, {collapsed: false}).addTo(map);
}

function initRangePicker() {
     $('#reportrange').daterangepicker({
        "timePicker": true,
        "timePicker24Hour": true,
        "locale": {
            "format": "YYYY-MM-DD HH:mm",
            "separator": " - ",
            "applyLabel": "Aceptar",
            "cancelLabel": "Cancelar",
            "fromLabel": "De",
            "toLabel": "A",
            "customRangeLabel": "Personalizado",
            "weekLabel": "S",
        }
    });
    function cb(start, end) {
        $('#reportrange span').html(start.format('YYYY-MM-DD HH:mm') + ' - ' + end.format('YYYY-MM-DD HH:mm'));
    }

    $('#reportrange').on('apply.daterangepicker', function (ev, picker) {  
        $('#reportrange span').html(picker.startDate.format('YYYY-MM-DD HH:mm') + ' - ' + picker.endDate.format('YYYY-MM-DD HH:mm'));
        getData(picker.startDate.format('YYYY-MM-DD HH:mm'), picker.endDate.format('YYYY-MM-DD HH:mm'));
    });
    
    // call business trips on load page
    cb(moment().startOf('day'),  moment().endOf('day'));
}

function initCharts() {
    //resize the chart when window resize
    $(window).resize(function () {
        if(tChart != null) {
            tChart.resize();
            hChart.resize();
        }
    });
    tChart = echarts.init(document.getElementById('t_chart'));
    hChart = echarts.init(document.getElementById('h_chart'));
}

function initDataTable() {
    

    table = $('#tramas-table').DataTable({
            processing: true,
            paging: false,
            ordering: false,
            columns: [
                { data: 'ID', name: 'ID', defaultContent: "<i>NO DEFINIDO</i>" },
                { data: 'trama_device.device.ALIAS', name: 'trama_device.device.ALIAS', defaultContent: "<code>NO DEFINIDO</code>"},
                { data: 'IMEI', name: 'IMEI', type: "string", defaultContent: "" },
                { data: 'CMD', name: 'CMD', defaultContent: ""  },
                { data: 'cmd_translate', name: 'cmd_translate', defaultContent: ""  },
                { data: 'LAT', name: 'LAT', defaultContent: ""  },
                { data: 'LNG', name: 'LNG', defaultContent: ""  },
                { data: 'TEMP', name: 'TEMP', defaultContent: ""  },
                { data: 'HUM', name: 'HUM',  defaultContent: "", render: function(state, type, row){ 
                        let status = "{{__('strings.unknown')}}";
                        if(state == 1) {
                            status = "{{__('strings.unlocked')}}";
                        } else if(state == 2) {
                            status = "{{__('strings.locked')}}";
                        } else if(state == 3) {
                            status = "{{__('strings.shear_line')}}";
                        }
                        return status;
                    } 
                },
                { data: 'END', name: 'END', defaultContent: "---" },
                { data: 'BAT', name: 'BAT', render: function(data, type, row){ return data + "%";} },
                { data: 'CREATED_AT', name: 'CREATED_AT', render: function ( data, type, row ) {
                        return moment.utc(data).local().format("YYYY-MM-DD");
                    } 
                },
                { data: 'CREATED_AT', name: 'CREATED_AT', render: function ( data, type, row ) {
                        return moment.utc(data).local().format("HH:mm");
                    } 
                },
                {data:"ID", name:"trama", defaultContent:"<i>{{__('strings.undefined')}}</i>", render: function(data, type, row){
                        if(row) {
                            return '<a href="http://maps.google.com/maps?q=&layer=c&cbll=' + row.LAT + ',' + row.LNG + '" target="_blank">StreetView</a>';
                        }
                        return null;
                }}
                ],
                dom: 'Bfrtip',
                buttons: [
                    'copy', 'excel',
                    /*{
                        extend: 'pdfHtml5',
                        orientation: 'landscape',
                        pageSize: 'A4'
                    }*/
                ],
                language: {
                    url: "{{asset('DataTables/languages')}}/{{App::getLocale()}}.json"
                },
        });
     
}

function initPdfExporter() {
    document.getElementById('pdf_button').onclick = function(){       
        document.getElementById('pdfIcon').className = 'fa fa-circle-notch fa-spin fa-3x';
        if(path) {
            map.fitBounds(path.getBounds());
            map.removeLayer(path);
        }
        if(sMarker) {
           map.removeLayer(sMarker); 
        }
        if(eMarker) {
           map.removeLayer(eMarker); 
        }
        leafletImage(map, function(err, canvas) {
            // now you have canvas
            makePDF(table, canvas.toDataURL());
        });
    };
}


function getData(startDate, endDate) {
    $.showPreloader("{{__('strings.wait_momment')}}");
     $.post( "{{route('get_device_data')}}",{
         imei: "{{$device->IMEI}}",
         start_date: moment(startDate).utc().format('YYYY-MM-DD HH:mm'),
         end_date: moment(endDate).utc().format('YYYY-MM-DD HH:mm')
     }, function( response ) {
         // replace 0's on temp, hum and ph with last data.
         if(response.tramas.length) {

            for(var id in response.tramas) {
                let googleUrl =  '<a href="https://www.google.com/maps/search/?api=1&query=' + response.tramas[id].LAT + ',' + response.tramas[id].LNG + '" target="_blank">Link Google</a>';
                response.tramas[id].GOOGLE_URL = googleUrl;  
                response.tramas[id].TEMP = parseInt(response.tramas[id].TEMP);
                response.tramas[id].HUM = parseInt(response.tramas[id].HUM);
                response.tramas[id].BAT = parseInt(response.tramas[id].BAT);
            }

            // update total fuel
            //let startData = response.tramas[0];
            //let endData  = response.tramas[response.tramas.length-1];
            //let totalFuel = Math.abs(endData.TEMP);
            //let totalDist = Math.abs(startData.END - endData.END);
            //updateTotalFuel(totalFuel);
            //updateTotalDistance(totalDist);

            drawRoute(response.tramas);
            updateCharts(response.tramas);
            table.clear();
            table.rows.add(response.tramas).draw();
        }        
        $.hidePreloader();
    }).fail(function(error){
        $.hidePreloader();
        $.alert("{{__('errors.error')}}");
        table.clear();
        table.rows.add({}).draw();
    });
}

function updateTotalFuel(value) {
    $("#total_fuel").html(value + " LTRS")
}

// the input value is in mtrs
function updateTotalDistance(value) {
    // convert to km
    value = value / 1000;
    $("#total_dist").html(value + " KM")
}

/**
 * Draw trip from given data (tramas). 
 * If the length of data is greater than 1500 or if route service response 
 * with error, the draw route are just the join of given data.
 * @param {type} tramas
 * @returns {undefined}
 */
function drawRoute(tramas) {

    removeRouteLayers();

    var apiUrl = "https://mapas.rtplataforma.com:8444/route/v1/driving/#cords?overview=full&geometries=geojson";
    var waypoints = [];
    
    tramas.forEach(function(trama) {
        let popup = '<div id="content">';
        popup += ' <b>VEL. : </b>' + trama?.TEMP + ' KM/H';
        popup += ' <br /><b>BAT.: </b>' + trama?.BAT + '%';
        popup += ' <br /><b>CMD: </b>' + trama.CMD; 
        popup += ' <br /><b>TRAD: </b>' + trama.cmd_translate;
        popup += ' <br />' + trama.GOOGLE_URL;
        popup += ' <br />' + moment.utc(trama.CREATED_AT).local().format('YYYY/MM/DD HH:mm');
        popup += '</div>';
        
        waypoints.push([trama.LAT, trama.LNG]);
        //markersLayer.addLayer(L.marker([trama.LAT, trama.LNG]).bindPopup(popup));
        if(trama?.HUM == 1) {
            // unloked
            let popup = "<b>IMEI: " + device.IMEI + "</b><br />";
            popup += "<b>ALIAS:</b> " + device.ALIAS + "<br />";
            popup += "<b>VEL:</b> " + device.trama.TEMP + " KM/H<br />";
            popup += "<b>BAT:</b> " + device.trama.BAT + "%<br />";
            popup += '<b>ESTADO: {{__("strings.unlocked")}}</b><br />';
            popup += "<b>Fecha:</b> " + moment.utc(device.trama.CREATED_AT).local().format("YYYY-MM-DD HH:mm") + "<p>";
            lockLayer.addLayer(L.marker([trama.LAT, trama.LNG], {icon: unlockedIcon}).bindPopup(popup));
        } else  if(trama?.HUM == 2) {
            // locked
            let popup = "<b>IMEI: " + device.IMEI + "</b><br />";
            popup += "<b>ALIAS:</b> " + device.ALIAS + "<br />";
            popup += "<b>VEL:</b> " + device.trama.TEMP + " KM/H<br />";
            popup += "<b>BAT:</b> " + device.trama.BAT + "%<br />";
            popup += '<b>ESTADO: {{__("strings.locked")}}</b><br />';
            popup += "<b>Fecha:</b> " + moment.utc(device.trama.CREATED_AT).local().format("YYYY-MM-DD HH:mm") + "<p>";
            lockLayer.addLayer(L.marker([trama.LAT, trama.LNG], {icon: lockedIcon}).bindPopup(popup));
        }
    });
    

    geoJson = L.geoJson({coordinates: waypoints.map(item => [item[1], item[0]]), type: "LineString"},{
        style: {
            weight: 6,
            color: "#42a5f5"
        }
    }).addTo(map);
    
    waypoints = [];
    tramas.forEach(function(trama) {
        //if(trama.LAT != 0 && trama.LNG != 0) {
            waypoints.push([trama.LAT, trama.LNG]);
        //}
    });
    
    // draw start marker
    var options = {
        iconShape: 'circle-dot'
            , borderWidth: 8
            , borderColor: '#000'
    };
    sMarker = L.marker(waypoints[0], { icon: start_flag}).addTo(map).bindPopup("{!!__('strings.start')!!}");

    // draw end marker
    options = {
        iconShape: 'rectangle-dot'
            , borderWidth: 8
            , borderColor: '#000'
    };

    eMarker = L.marker(waypoints[waypoints.length - 1], { icon: end_flag }).addTo(map).bindPopup("{!!__('strings.end')!!}");

    path = L.polyline.antPath(waypoints,
        {"delay":1200,"dashArray":[10,20],"weight":5,"color":"#DDE9FF","pulseColor":"#008DFF","paused":false,"reverse":false}
    ).addTo(map);

    //path.showExtremities('dotM');     
    map.fitBounds(path.getBounds());
}

function removeRouteLayers() {    
    if(geoJson) {
        map.removeLayer(geoJson);
    }
    if(path) {
        map.removeLayer(path);
    }
    if(sMarker) {
       map.removeLayer(sMarker); 
    }
    if(eMarker) {
       map.removeLayer(eMarker); 
    }

    if(markersLayer) {
        markersLayer.clearLayers();
    }
    if(lockLayer) {
        lockLayer.clearLayers();
    }

    
}

function updateCharts(tramas) {

    var serie = [];
    let kernel = [0.0017,	0.0168,	0.0871,	0.2329,	0.3231,	0.2329,	0.0871,	0.0168,	0.0017];
    let kernelSize = Math.floor(kernel.length / 2);
    for(var id in tramas) {
        var milis = moment(moment.utc(tramas[id].CREATED_AT)).local().unix();
       

        serie.push({
            date: milis, 
            temp1: tramas[id].TEMP, 
            hum: tramas[id].HUM, 
            ph: tramas[id].END, 
            cmd: tramas[id].CMD, 
            json:tramas[id]
        });
    }
    tChart.clear();
    hChart.clear();
    // redraw charts
    tChart.setOption(getTempOption(serie));
    hChart.setOption(getHumOption(serie));
}

/**
 * Gets temperature serie's data format 
 * @param {type} data
 * @return {Array}     */
function getTempOption(data) {
    @php    
    @endphp
    var serieName = 'VEL';
    for (var i in data) {
        data[i].cmd = data[i].cmd === 'OFF' ? "<li class='fa fa-lightbulb-o no-ligth' arial-hidden='true'></i>" : "<li class='fa fa-lightbulb-o ligth' arial-hidden='true'></i>";
    }
    var option = {
        tooltip: {
            trigger: 'axis',
            formatter: function (params) {
                var item = data[params[0].dataIndex];
                if (item.json.LAT != 0.00 && item.json.LNG != 0.00) {
                    map.setView([item.json.LAT, item.json.LNG], map.getZoom());
                }
                return  '<b>' + moment.unix(item.date).format("YYYY/MM/DD HH:mm:ss") + '</b><br>'
                        + item.temp1 + ' KM/H<br>'
                        + item.json.cmd_translate;
            },
            backgroundColor: 'rgba(255,255,255,0.9)',
            borderColor: '#e0e0e0',
            borderWidth: 1,
            extraCssText: 'text-align: center',
            textStyle: {
                color: '#000000'
            }
        },
        xAxis: {
            type: 'category',
            boundaryGap: false,
            data: data.map(function (item) {
                return item.date;
            }),
            axisLabel: {
                formatter: function (value, idx) {
                    return moment.unix(value).format("MMM/DD");
                }
            }
        },
        yAxis: {
            name: serieName,
            nameGap: 25,
            type: 'value',
            splitLine: {
                lineStyle: {
                    type: 'dashed'
                }
            }
        },
        toolbox: {
            feature: {
                saveAsImage: {title: 'Save',name: 'chartSpeed',type:'png'}
            }
        },
        series: [
            {
                name: serieName,
                type: 'bar',
                smooth: true,
                symbol: 'circle',
                showSymbol: false,
                symbolSize: 5,
                lineStyle: {
                    normal: {
                        color: '#00B0FF',
                        width: 1,
                        type: 'solid'
                    }
                },
                itemStyle: {
                    normal: {
                        color: '#00B0FF'
                    }
                },
                areaStyle: {
                    normal: {
                        color: new echarts.graphic.LinearGradient(0, 0, 0, 1, [{
                                offset: 0,
                                color: '#e0f2f1'
                            }, {
                                offset: 1,
                                color: '#00B0FF'
                            }])
                    }
                },
                data: data.map(function (item) {
                    return item.temp1
                }),
            }
        ]
    };
    return option;
}

/**
 * Gets humidity serie's data format 
 * @param {type} data
 * @return {Array}     */
function getHumOption(data) {
   
   var serieName = 'ESTADO';
   var temh;
   
   var option = {
       tooltip: {
           trigger: 'axis',
           formatter: function (params) {
               var item = data[params[0].dataIndex];
               if (item.json.LAT != 0.00 && item.json.LNG != 0.00) {
                map.setView([item.json.LAT, item.json.LNG], map.getZoom());
               }
               let status = "{{__('strings.unknown')}}";
                if(item.hum == 1) {
                    status = "{{__('strings.unlocked')}}";
                } else if(item.hum == 2) {
                    status = "{{__('strings.locked')}}";
                } else if(item.hum == 3) {
                    status = "{{__('strings.shear_line')}}";
                }
               return  '<b>' + moment.unix(item.date).format("YYYY/MM/DD HH:mm:ss") + '</b><br>'
                        + status + '<br>'
                        + item.json.END;
           },
           backgroundColor: 'rgba(255,255,255,0.9)',
           borderColor: '#e0e0e0',
           borderWidth: 1,
           extraCssText: 'text-align: center',
           textStyle: {
               color: '#000000'
           }
       },
       xAxis: {
           type: 'category',
           boundaryGap: false,
           data: data.map(function (item) {
               return item.date;
           }),
           axisLabel: {
               formatter: function (value, idx) {
                   return moment.unix(value).format("MMM/DD");
               }
           },
           splitLine: {
               lineStyle: {
                    opacity: 0
               }
           }
       },
       yAxis: {
           name: serieName,
           max:3.3,
           nameGap: 25,
           type: 'value',
           axisLabel: {
                show:false
           },
           splitLine: {
               lineStyle: {
                    opacity: 0
               }
           }
       },
       toolbox: {
           feature: {
               saveAsImage: {title: 'Save',name:'chartState',type:'png'}
           }
       },
       series: [
           {
               name: serieName,
               type: 'line',
               smooth: true,
               symbol: 'circle',
               showSymbol: true,
               itemStyle: {
                   normal: {
                       color: '#E65100'
                   }
               },
               areaStyle: {
                   normal: {
                       color: new echarts.graphic.LinearGradient(0, 0, 0, 1, [{
                               offset: 0,
                               color: '#FFE082'
                           }, {
                               offset: 1,
                               color: '#E65100'
                           }])
                   }
               },
               data: data.map(function (item) {
                   return item.hum
               }),
              
                markLine:{
                    symbol:'none',
                    data:[
                        { 
                            yAxis: 1, 
                            name:'Desbl.', 
                            label: {
                                position:'start',
                                formatter: '{b}'
                            },
                            lineStyle:{
                                color: '#FF0000'
                            }
                        },
                        { 
                            yAxis: 2, 
                            name:'Bloq.', 
                            label: {
                                position:'start',
                                formatter: '{b}'
                            },
                            lineStyle:{
                                color: '#00FF00'
                            }
                        }
                    ]
                }
           }
       ]
   };
   return option;
}

/**
 * Generates pdf document
 * @return {undefined}
 */
function makePDF(datatable, mapDataUrl) {
    var pdfData = [];
    var rows = datatable.data().toArray();

    let status = "{{__('strings.unknown')}}";
    if(device.trama?.HUM == "1") {
        status ="{{__('strings.unlocked')}}";
    } else if(device.trama?.HUM == "2") {
        status = "{{__('strings.locked')}}";
    } else if(device.trama?.HUM == "3") {
        status = "{{__('strings.shear_line')}}";
    }
    
    var dataColum = " VEL";
    var dataColum2 = " ESTADO";

    if(rows.length <= 0) {
        document.getElementById('pdfIcon').className = 'fa fa-file-pdf';
        return;
    }
    //gets first and last data
    var firstData = rows[0];
    var endData = rows[rows.length - 1];

    firstData = {
        ALIAS: firstData.ALIAS,
        DATE: firstData.DATE,
        TIME: firstData.TIME ,
        CMD: firstData.CMD,
        [dataColum]: firstData.TEMP,
        HUM: firstData.HUM,
        LAT: firstData.LAT,
        LNG: firstData.LNG,
        IMEI: firstData.IMEI
    };
    endData = {
        ALIAS: endData.ALIAS,
        DATE: endData.DATE,
        TIME: endData.TIME,
        CMD: endData.CMD,
        [dataColum]: endData.TEMP,
        HUM: endData.HUM,
        LAT: endData.LAT,
        LNG: endData.LNG,
        IMEI: endData.IMEI
    };
    var minTemp = firstData;
    var maxTemp = firstData;
    var minHum = firstData;
    var maxHum = firstData;
    var avgTemp = 0;
    //calculating min, max, mean and generating pdfData json array
    rows.forEach(function (row) {
        // min and max speed
        if (parseFloat(row.TEMP) < parseFloat(minTemp[dataColum])) {
            minTemp = {
                DATE: row.DATE,
                TIME: row.TIME,
                CMD: row.CMD,
                [dataColum]: row.TEMP,
                HUM: row.HUM,
                LAT: row.LAT,
                LNG: row.LNG,
                IMEI: row.IMEI
            };
        }
        
        // min and max speed
        if (parseFloat(row.TEMP) > parseFloat(maxTemp[dataColum])) {
            maxTemp = {
                DATE: row.DATE,
                TIME: row.TIME,
                CMD: row.CMD,
                [dataColum]: row.TEMP,
                HUM: firstData.HUM,
                LAT: row.LAT,
                LNG: row.LNG,
                IMEI: row.IMEI
            };
        }
        

        avgTemp += parseFloat(row.TEMP);
        var timeDate =  moment.utc(row.DATE + " " + row.TIME);
        
        pdfData.push({
                ID: row.ID,   
                FECHA: timeDate.local().format("YYYY-MM-DD"),
                HORA: timeDate.local().format("HH:mm") ,
                CMD: row.CMD,
                [dataColum]: row.TEMP,
                [dataColum2]: row.HUM,
                PIR: row.END,
                LAT: row.LAT,
                LNG: row.LNG
        });
    });

    avgTemp = (avgTemp / pdfData.length);    
    var alias = firstData.IMEI;
    var fileName = "pdfReport_" + alias + '_' + moment().format("YYMMDDhhmmss");
    var createdAt = moment().format("YYYY-MM-DD_HH.mm.ss");
    //calculating elapsed time beetwen fisrt and last trama
    var firstDate = moment(firstData.DATE + ' ' + firstData.TIME);
    var endDate = moment(endData.DATE + ' ' + endData.TIME);
    var elapsedTime = moment.duration(firstDate.diff(endDate));

    function buildTableBody(data) {
        var body = [];
        var labels = [];

        var item0 = data[0];
        for(var label in item0) {
            labels.push(label);
        }
        body.push(labels);

        data.forEach(function (row) {
            var dataRow = [];
            for(var index in row){
                dataRow.push(row[index].toString());
            }
            body.push(dataRow);
        });
        return body;
    }

    function table(data) {
        return {columns: [
                {width: '*', text: ''},
                {
                    style: 'tableExample',
                    width: 'auto',
                    table: {
                        headerRows: 1,
                        body: buildTableBody(data)
                    },
                    layout: 'lightHorizontalLines'
                },
                {width: '*', text: ''}
            ]};
    }
    
    var dd = {
        header:{
                columns: [
                    {
                        text:  '{{ __("strings.file_name") }} : ' + fileName + '\n {{ __("strings.created_at") }}: ' + createdAt, style: 'small',margin: [40, 10, 0, 0]
                    },
                    {
                        text: 'REDTRACK', style: 'tableHeader', alignment: 'right', margin: [0, 10, 40, 0],fontSize: 20, color: 'red', fontStyle: 'open-sans'
                    }
                ]
        },
        footer:function(currentPage, pageCount){
            return {text:'Page ' + currentPage.toString() + ' of ' + pageCount,
                    style: 'small',
                    margin: [40, 10, 0, 0]
            };
        },
        content: [
            {
                style: 'tableExample',
                table: {
                    body: [
                        [                            
                            {text: '{{ __("strings.data_report") }}', border: [false, false, false, false], style: 'header'},
                        ]
                    ]
                }
            },
            {text: '[notas]', style: 'small', margin: [0, 0, 0, 8]},
            {
                columns: [
                    {
                        text: '{{ __("strings.device_configuration") }}', style: 'tableHeader'
                    }
                ]
            },
            {
                style: 'tableExample',
                table: {
                    widths: ['*', '*'],
                    body: [
                        [
                            [
                                {
                                    table: {
                                        widths: ['*', '*'],
                                        body: [
                                            ['{{ __("strings.device") }}: {{$device->ALIAS}}', 'Firmware: 1.0.1'],
                                            ['{{ __("strings.serial_number") }}: {{$device->IMEI}}', '{{ __("strings.interval_cycle") }}: 1hr'],
                                           
                                        ]
                                    },
                                    layout: 'noBorders'
                                }
                            ],
                            [
                                {
                                    table: {
                                        widths: ['*'],
                                        body: [
                                            ['IMEI: {{$device->IMEI}}'],
                                            ['{{ __("strings.hmr_status") }}: ' + status]
                                        ]
                                    },
                                    layout: 'noBorders'
                                }
                            ]
                        ]
                    ]
                }
            },
            {text: '{{ __("strings.device_information") }}', style: 'tableHeader', margin: [0, 10, 0, 0]},
            {
                style: 'tableExample',
                table: {
                    widths: ['*'],
                    body: [
                        [
                            [
                                {
                                    table: {
                                        widths: ['*', '*'],
                                        body: [
                                            ['{{ __("strings.carrier") }}: {{$device->CARRIER}}', '{{ __("strings.bill") }}:  {{$device->INVOICE}}'],
                                            ['{{ __("strings.commodity") }}: {{$device->COMMODITY}}', '{{ __("strings.personalized") }} 1:  {{$device->CUSTOM_1}}'],
                                            ['{{ __("strings.plates") }}: {{$device->PLATES}}' , '{{ __("strings.personalized") }} 2:  {{$device->CUSTOM_2}}'],
                                            ['{{ __("strings.truck") }}: {{$device->TRUCK}}' , '--']
                                        ]
                                    },
                                    layout: 'noBorders'
                                }
                            ]
                        ]
                    ]
                }
            },
            {text: '{{ __("strings.registration_summary") }}', style: 'tableHeader', margin: [0, 10, 0, 0]},
            {
                style: 'tableExample',
                table: {
                    widths: ['*'],
                    body: [
                        [
                            [
                                {
                                    table: {
                                        widths: ['*', '*'],
                                        body: [
                                            ['{{ __("strings.highest_data") }}'+ dataColum +': '+ maxTemp[dataColum] + '@' + maxTemp.DATE + ' ' + maxTemp.TIME, '{{ __("strings.start_time") }}: ' + firstData.DATE + ' ' + firstData.TIME],
                                            ['{{ __("strings.lowest_data") }}'+ dataColum +': '+ minTemp[dataColum] + '@' + minTemp.DATE + ' ' + minTemp.TIME, '{{ __("strings.end_time") }}: ' + endData.DATE + ' ' + endData.TIME],
                                            ['{{ __("strings.data_media") }}'+ dataColum +': ' + avgTemp + dataColum, '{{ __("strings.data_points") }}: ' + pdfData.length],
                                            ['---', '{{ __("strings.length_of_the_trip") }}: ' + elapsedTime.days() + 'd' + elapsedTime.hours() + 'h' + elapsedTime.minutes() + 'm']
                                        ]
                                    },
                                    layout: 'noBorders'
                                }
                            ]
                        ]
                    ]
                }
            },
            {text: 'Tablas', style: 'tableHeader', margin: [0, 8, 0, 8]},
            {
                image: "speedChartImage", margin: [0, 10, 0, 0], width: 480
            },
            {
                image: "stateChartImage", margin: [0, 10, 0, 0], width: 480
            },
            {text: 'Ruta', style: 'tableHeader', margin: [0, 8, 0, 8]},
            {
                image: "mapImage", margin: [0, 10, 0, 0], width: 520
                
            },
            {text: 'Datos', style: 'tableHeader', margin: [0, 8, 0, 8]},
            table(pdfData)
        ],
	    images: {
            mapImage: mapDataUrl,
            speedChartImage: tChart.getDataURL({pixelRatio: 2, backgroundColor: '#fff'}),  
            stateChartImage: hChart.getDataURL({pixelRatio: 2, backgroundColor: '#fff'}), 
        }, 
        styles: {
            header: {
                fontSize: 28,
                bold: true
            },
            subheader: {
                fontSize: 15,
                bold: true
            },
            quote: {
                italics: true
            },
            small: {
                fontSize: 8
            },
            tableExample: {
                margin: [0, 3, 0, 5],
                fontSize: 9
            },
            tableHeader: {
                bold: true,
                fontSize: 13,
                color: 'black'
            }
        }
    };
    
    pdfMake.createPdf(dd).download(fileName + '.pdf',function(){
        document.getElementById('pdfIcon').className = 'fa fa-file-pdf';
    });
}


function addLockMarker(device) {
            // exclude lat,lng zeros
            if(device.trama.LAT == 0 && device.trama.LNG == 0) {
                return;
            }

            console.log('device.trama?.HUM', device.trama?.HUM)
            let icon =  L.icon({
                iconUrl: "{{asset('images/markers/padlock.png')}}",
                iconSize:     [32, 32], // size of the icon
                iconAnchor:   [16, 16], // point of the icon which will correspond to marker's location
                popupAnchor:  [0, -16] // point from which the popup should open relative to the iconAnchor
            });
            if(device.trama?.HUM == 1) {
                icon = unlockedIcon;
            } else  if(device.trama?.HUM == 2) {
                icon = lockedIcon;
            } else {
                icon = unknowIcon;
            }
            
            var popup = "<b>IMEI: " + device.IMEI + "</b><br>";
            popup += "<b>ALIAS:</b> " + device.ALIAS + "<br>";
            popup += "<b>VEL:</b> " + device.trama.TEMP + " KM/H<br>";
            popup += "<b>BAT:</b> " + device.trama.BAT + "%<br>";
            popup += "<b>CMD:</b> " + device.trama.CMD + "<br>";
            popup += "<b>TRAD:</b> " + device.trama.cmd_translate + "<br>";
            popup += "<b>DEVICE:</b> SmartLock<br>";
            popup += "<b>Fecha:</b> " + moment.utc(device.trama.CREATED_AT).local().format("YYYY-MM-DD HH:mm") + "<p>";
          
            popup += '<a href="http://maps.google.com/maps?q=&layer=c&cbll=' + device.trama.LAT + ',' + device.trama.LNG + '" target="_blank">StreetView</a>';                   

            var marker = L.marker([device.trama.LAT, device.trama.LNG], {icon: icon})                    
            .bindPopup(popup)
            .on('click', function(e){
                map.setView(e.latlng, map.zoom);
            })
            .addTo(map);
                
            marker.bindTooltip((device.ALIAS != null && device.alias != "") ? device.ALIAS : device.IMEI, {offset:[0,-13], direction: "top" ,permanent: true});
            deviceMarkers.set(device.IMEI, marker);
        }
</script>
@endpush