@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') }} HMR - HISTORICAL PAGED TEST</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" style="height:650px;">
                            <ul class="nav nav-tabs" role="tablist">
                                <li class="nav-item">
                                    <a class="nav-link active" data-toggle="tab" href="#home" role="tab" aria-controls="home">Gráficas</a>
                                </li>

                                <li class="nav-item">
                                    <a class="nav-link" data-toggle="tab" href="#profile" role="tab" aria-controls="profile">Histórico</a>
                                </li>
                            </ul>

                            <div class="tab-content">
                                <div class="tab-pane active" id="home" role="tabpanel">
                                    <h2 id="mileage" hidden>Distancia Recorrida: 0 km.</h2>
                                    <div style="height: 290px;">
                                            <div id="t_chart" style="width: 100%; height: 290px;"></div>
                                    </div>
                                    <div style="height: 290px; display: none;">
                                            <div id="ph_chart" style="width: 100%; height: 290px;"></div>
                                    </div>
                                    <div style="height: 290px;">
                                            <div id="h_chart" style="width: 100%; height: 290px;"></div>
                                    </div>
                                </div>

                                <div class="tab-pane" id="profile" role="tabpanel">
                                    <div class="table-responsive" style="height: 580px; overflow: auto;" >
                                        <h2 id="dist" hidden>Distancia Recorrida: 0 km.</h2>
                                        <table id="tramas-mini-table" class="table hover mb-0">
                                            <thead class="thead-inverse-mini">
                                                <tr>
                                                    <th>Datos</th>
                                                </tr>
                                            </thead>
                                        </table>
                                    </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" hidden>                
                <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>NIVEL</th>
                            <th>VELOCIDAD</th>
                            <th>ALTITUD</th>
                            <th>REVERSA (MM:SS)</th>
                            <th>REVERSA (RAW)</th>
                            <th>HMR_STATUS</th>
                            <th>EXTRA</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/echarts.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; // humidity chart
var phChart = null;
var table;
var table_mini;

var startStopPoints;
var markersLayer;
var mileage = 0;
var hmrGeocenfe;
var hmrPolygon;
let startDate = null;
let endDate = null;

    
$(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();
    });
    
    addMarker({!!$device!!});

    startStopPoints = L.layerGroup().addTo(map);
    markersLayer = L.layerGroup().addTo(map);

    var overlays = {
            'Reversas' : startStopPoints,
            'Puntos GPS' : markersLayer,
        };
    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'));
        startDate = picker.startDate.format('YYYY-MM-DD HH:mm');
        endDate = 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'));
    startDate = moment().startOf('day').format('YYYY-MM-DD HH:mm');
    endDate =  moment().endOf('day').format('YYYY-MM-DD HH:mm');
}

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

function initDataTable() {
    table_mini = $('#tramas-mini-table').DataTable({
                processing: true,
                paging: false,
                ordering: false,
                columns: [
                    //{ data: 'CMD', name: 'CMD', defaultContent: ""  },              
                    { data: 'CREATED_AT', name: 'CREATED_AT', render: function ( data, type, row ) {    
                            return moment.utc(data).local().format("YYYY-MM-DD") + " / " + moment.utc(data).local().format("HH:mm")
                            + "<br>" + "Nivel: " + row.TEMP + " LTRS" 
                            + "<br>" + "Dist: " + (row?.MILEAGE || 0).toFixed(2) + " km." 
                            //+"<br>"+row.TEMP+value
                            + "<br>" + row.GOOGLE_URL;
                        } 
                    },
                    ],
                    dom: 'Bfrtip',
                    buttons: [
                        'copy', 'excel',{
                            extend: 'pdfHtml5',
                            orientation: 'landscape',
                            pageSize: 'A4'
                        }
                    ],
                    language: {
                        url: "{{asset('DataTables/languages')}}/{{App::getLocale()}}.json"
                    },
            });

    table = $('#tramas-table').DataTable({
            processing: true,
            paging: true,
            ordering: false,
            lengthMenu: [
                [10, 25, 50, -1],
                [10, 25, 50, 'All']
            ],
            serverSide:true,
            ajax: {
                url: "{{route('get_device_data_paged')}}",
                type: "POST",
                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')
                },
                error: function(error, textStatus, errorThrown){
                    console.log(error);
                }                
            },
            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: "", render: function(data, type, trama) { 
                        if(data){
                            return "<font color='black'>" + data + "</font>";
                        }
                        return null
                    } 
                },
                { data: 'HUM', name: 'HUM',  defaultContent: "", render: function(data, type, trama) { 
                        if(data != null){                            
                            return "<font color='black'>" + data + "</font>";
                        }
                        return null
                    } 
                },
                { data: 'BAT', name: 'BAT',  defaultContent: "", render: function(data, type, trama) { 
                        if(data != null){                            
                            return "<font color='black'>" + data + "</font>";
                        }
                        return null
                    } 
                },
                { data: 'REV_MILLIS', name: 'REV_MILLIS', render: function(data, type, row) { 
                        return moment.utc(data).format('mm:ss');
                    } 
                },
                { data: 'REV_MILLIS', name: 'REV_MILLIS', defaultContent: "---"},
                { data: 'HMR_STATUS', name: 'HMR_STATUS', defaultContent: "---" },
                { data: 'END', name: 'END', defaultContent: "---" },
                { 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: '<"top"p>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';
        removeRouteLayers();
        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_paged')}}",{
         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 ) {
        
        response.tramas = response.data;
         // replace 0's on temp, hum and ph with last data.
         if(response.tramas.length) {
            mileage = 0;

            for(var id in response.tramas) {             
                
                // generate google url to each point
                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; 

                if(id > 0 ) {
                        if(response.tramas[id].TEMP == 0){
                            response.tramas[id].TEMP = response.tramas[id - 1].TEMP;
                        }
                        // if current lat, lng are equals to zero, get old, i.e. id - 1 
                        if(Math.floor(response.tramas[id].LAT) == 0){
                            response.tramas[id].LAT = response.tramas[id - 1].LAT;
                            response.tramas[id].LNG = response.tramas[id - 1].LNG;
                        }    
                } 
                 // current mileage
                let raw = response.tramas[id].RAW;
                let values = raw.split(',')[9].split(':');
                let _millis = values[0] || 0;
                let _hmtStatus = values[3] || 'NA';
                console.log('_millis', _millis, values)
                response.tramas[id].REV_MILLIS = parseFloat(_millis);
                response.tramas[id].MILEAGE = mileage;  
                response.tramas[id].HMR_STATUS = _hmtStatus;  
                hmrPolygon = [
                    [values[7] || 0, values[8] || 0],
                    [values[9] || 0, values[10] || 0],
                    [values[11] || 0, values[12] || 0],
                    [values[13] || 0, values[14] || 0],
                ]; 

            }

            document.getElementById("mileage").innerHTML = "{!!__('strings.distance_traveled')!!}:  " + (mileage / 1000).toFixed(2) + " km";
            document.getElementById("dist").innerHTML = "{!!__('strings.distance_traveled')!!}:  " + (mileage / 1000).toFixed(2) + " km";

            drawRoute(response.tramas);
            updateCharts(response.tramas);
            table.clear();
            table.rows.add(response.tramas).draw();
            table_mini.clear();
            table_mini.rows.add(response.tramas).draw();
        } else {
            removeRouteLayers();
            updateCharts([]);
            table.clear();
            table.rows.add({}).draw();
            table_mini.clear();
            table_mini.rows.add({}).draw();
            document.getElementById("mileage").innerHTML = "{!!__('strings.error_distance')!!}";
            document.getElementById("dist").innerHTML = "{!!__('strings.error_distance')!!}";
        }        
        $.hidePreloader();
    }).fail(function(error){
        $.hidePreloader();
        $.alert("{{__('errors.error')}}");
        table.clear();
        table.rows.add({}).draw();
        table_mini.clear();
        table_mini.rows.add({}).draw();
        document.getElementById("mileage").innerHTML = "{!!__('strings.error_distance')!!}";
        document.getElementById("dist").innerHTML = "{!!__('strings.error_distance')!!}";
    });
}

/**
 * Draw trip from given data (tramas). 
 * @param {type} tramas
 * @returns {undefined}
 */
function drawRoute(tramas) {
    var apiUrl = "https://mapas.rtplataforma.com:8444/route/v1/driving/#cords?overview=full&geometries=geojson";
    var waypoints = [];
    
    removeRouteLayers();

    hmrGeofence = L.polygon(hmrPolygon, {color: 'red'}).addTo(map);
    console.log(hmrPolygon)
    
    

    tramas.forEach(function(trama) {
        if(trama.LAT != 0 && trama.LNG != 0) {
            waypoints.push([trama.LAT, trama.LNG]);
            let _popup = '<div id="content">';
                        _popup += ' <b>Litros : </b>' + trama.TEMP;
                        _popup += ' <br><b>KM: </b>' + (trama?.MILEAGE || 0).toFixed(2) + ' km';
                        _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>';
            if(trama.CMD == 'F') {
                var options = {
                    borderColor:"red",
                    iconShape: 'circle-dot',
                    borderWidth: 6,
                };
                startStopPoints.addLayer(L.marker([trama.LAT, trama.LNG], {icon: L.BeautifyIcon.icon(options)}).bindPopup(_popup));
            } else if(trama.CMD == 'G') {
                var options = {
                    borderColor:"green",
                    iconShape: 'circle-dot',
                    borderWidth: 6,
                };
                startStopPoints.addLayer(L.marker([trama.LAT, trama.LNG], {icon: L.BeautifyIcon.icon(options)}).bindPopup(_popup));
            } else if(trama.CMD == '?') {
                var options = {
                    borderColor:"blue",
                    iconShape: 'circle-dot',
                    borderWidth: 4,
                };
                startStopPoints.addLayer(L.marker([trama.LAT, trama.LNG], {icon: L.BeautifyIcon.icon(options)}).bindPopup(_popup));
            }else {
                markersLayer.addLayer(L.marker([trama.LAT, trama.LNG], {}).bindPopup(_popup));
            }
        }
    });
    
    geoJson = L.geoJson({coordinates: waypoints, type: "LineString"},{
        style: {
            weight: 6,
            color: "#42a5f5"
        }
    }).addTo(map);
    
    
    sMarker = L.marker(waypoints[0], { icon: start_flag}).addTo(map).bindPopup("{!!__('strings.start')!!}");

    

    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}
    );

    path.showExtremities('dotM');
    map.addLayer(path);             
    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(startStopPoints) {
        startStopPoints.clearLayers();
    }
    
    if(markersLayer) {
        markersLayer.clearLayers();
    }

    if(hmrGeocenfe) {
       map.removeLayer(hmrGeocenfe)
    }
}

function updateCharts(tramas) {
    var serie = [];
    for(var id in tramas) {
        var milis = moment(moment.utc(tramas[id].CREATED_AT)).local().unix();
        serie.push({
            date: milis, 
            temp1: parseFloat(tramas[id].TEMP), 
            temp2: (parseFloat(tramas[id].TEMP).toFixed(3) * 1.8 + 32).toFixed(3), 
            hum: parseFloat(tramas[id].HUM), 
            ph: parseFloat(tramas[id].END), 
            cmd: tramas[id].CMD, 
            json:tramas[id]});
    }
    tChart.clear();
    hChart.clear();
    phChart.clear();
    // redraw charts
    tChart.setOption(getTempOption(serie));
    hChart.setOption(getHumOption(serie));
    phChart.setOption({});
}

/**
 * Gets temperature serie's data format 
 * @param {type} data
 * @return {Array}     */
function getTempOption(data) {
    var serieName = 'LTRS';
    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) {
                    var popup = '<div id="content">';
                        popup += ' <b>NIVEL: </b>' + item.json.TEMP + ' L.';
                        popup += ' <br><b>DIST: </b>' + (item?.json?.MILEAGE || 0 ).toFixed(2) + ' km';
                        popup += ' <br><b>CMD: </b>' + item.json.CMD; 
                        popup += ' <br><b>TRAD: </b>' + item.json.cmd_translate;
                        popup += ' <br>' + item.json.GOOGLE_URL;
                        popup += ' <br>' + moment.utc(item.json.CREATED_AT).local().format('YYYY/MM/DD HH:mm');
                        popup += '</div>';
                        L.popup()
                        .setLatLng([item.json.LAT, item.json.LNG])
                        .setContent(popup)
                        .openOn(map);
                        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>'
                        + 'Nivel: ' +item.temp1 + ' L.<br>'
                        + 'Dist: ' + (item?.json?.MILEAGE || 0).toFixed(2) + ' km.<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,
            nameLocation: 'middle',
            nameGap: 25,
            type: 'value',
            splitLine: {
                lineStyle: {
                    type: 'dashed'
                }
            }
        },
        toolbox: {
            feature: {
                saveAsImage: {title: 'Save',name:'chart',type:'png'}
            }
        },
        series: [
            {
                name: serieName,
                type: 'line',
                smooth: true,
                symbol: 'circle',
                showSymbol: true,
                showAllSymbol: true,
                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 = 'VEL';
    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) {
                    var popup = '<div id="content">';
                        popup += ' <b>' + serieName + ': </b>' + item.hum + ' km/h';
                        popup += ' <br><b>DIST: </b>' + (item?.json?.MILEAGE || 0).toFixed(2) + ' km';
                        popup += ' <br><b>CMD: </b>' + item.json.CMD; 
                        popup += ' <br><b>TRAD: </b>' + item.json.cmd_translate;
                        popup += ' <br>' + item.json.GOOGLE_URL;
                        popup += ' <br>' + moment.utc(item.json.CREATED_AT).local().format('YYYY/MM/DD HH:mm');
                        popup += '</div>';
                        L.popup()
                        .setLatLng([item.json.LAT, item.json.LNG])
                        .setContent(popup)
                        .openOn(map);
                        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>'
                        + 'Vel: ' +  item.hum + ' km/h<br>'
                        + 'Dist:' + (item?.json?.MILEAGE || 0).toFixed(2) + ' km.<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,
            nameLocation: 'middle',
            nameGap: 25,
            type: 'value',
            splitLine: {
                lineStyle: {
                    type: 'dashed'
                }
            }
        },
        toolbox: {
            feature: {
                saveAsImage: {title: 'Save',name:'chartHum',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: {
                    data: [{type: 'average', name: 'Max.'}]
                }
            }
        ]
    };
    return option;
}

/**
 * Gets ph serie's data format 
 * @param {type} data
 * @return {Array}     */
function getPhOption(data) {
    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) {
                    var popup = '<div id="content">';
                        popup += ' <b>TEMP: </b>' + item.json.TEMP;
                        popup += ' <br><b>HUM: </b>' + item.json.HUM;
                        popup += ' <br><b>BAT: </b>' + item.json.BAT;
                        popup += ' <br><b>PH: </b>' + item.json.END;    
                        popup += ' <br><b>CMD: </b>' + item.json.CMD;
                        popup += ' <br><b>TRAD: </b>' + item.json.cmd_translate;
                        popup += ' <br>' + moment.utc(item.json.CREATED_AT).local().format('YYYY/MM/DD HH:mm');
                        popup += '</div>';
                        L.popup()
                        .setLatLng([item.json.LAT, item.json.LNG])
                        .setContent(popup)
                        .openOn(map);
                        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>'
                        + 'PH: ' + item.ph + '%<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: 'PH',
            nameLocation: 'middle',
            nameGap: 25,
            type: 'value',
            min: -10,
            max: 100,
            splitLine: {
                lineStyle: {
                    type: 'dashed'
                }
            }
        },
        toolbox: {
            feature: {
                saveAsImage: {title: 'Save',name:'chartHum',type:'png'}
            }
        },
        series: [
            {
                name: 'PH',
                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) {
                    if (isNaN(item.ph)) {
                        return 0;
                    }
                    return item.ph;
                }),
                markLine: {
                    data: [{type: 'average', name: 'Max.'}]
                }
            }
        ]
    };
    return option;
}


/**
 * Generates pdf document
 * @return {undefined}
 */
function makePDF(datatable, mapDataUrl) {
    var pdfData = [];
    var rows = datatable.data().toArray();
    console.log(rows);
    var dataColum = "LTRS";
    var dataColumSec = "VEL";

    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];
    //generates json objects
   

    firstData = {
        ALIAS: firstData.ALIAS,
        DATE: firstData.DATE,
        TIME: firstData.TIME ,
        CMD: (firstData.CMD === '1' ? "ON" : "OFF"),
        [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 === '1' ? "ON" : "OFF"),
        [dataColum]: endData.TEMP,
        HUM: firstData.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;
    var avgHum = 0;
    //calculating min, max, mean and generating pdfData json array
    rows.forEach(function (row) {
        console.log(row)
        // min and max temperature
        if (parseFloat(row.TEMP) < parseFloat(minTemp.dataColum)) {
            minTemp = {
                DATE: row.DATE,
                TIME: row.TIME,
                CMD: row.CMD,
                [dataColum]: row.TEMP,
                HUM: firstData.HUM,
                LAT: row.LAT,
                LNG: row.LNG,
                IMEI: row.IMEI
            };
        }
        if (parseFloat(row.TEMP) > parseFloat(maxTemp.dataColum)) {
            maxTemp = {
                DATE: row.DATE,
                TIME: row.TIME,
                CMD: row.CMD,
                [dataColum]: row.TEMP,
                [dataColumSec]: firstData.HUM,
                LAT: row.LAT,
                LNG: row.LNG,
                IMEI: row.IMEI
            };
        }
        
        // min and max humidity
        if (parseFloat(row.HUM) < parseFloat(minHum.HUM)) {
            minHum = {
                DATE: row.DATE,
                TIME: row.TIME,
                CMD: row.CMD,
                [dataColum]: row.TEMP,
                HUM: firstData.HUM,
                LAT: row.LAT,
                LNG: row.LNG,
                IMEI: row.IMEI
            };
        }
        if (parseFloat(row.HUM) > parseFloat(maxHum.HUM)) {
            maxHum = {
                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);
        avgHum += parseFloat(row.HUM);
        var timeDate =  moment.utc(row.DATE + " " + row.TIME);
        
        pdfData.push({
                IMEI: row.IMEI,
                DATE: timeDate.local().format("YYYY-MM-DD"),
                TIME: timeDate.local().format("HH:mm") ,
                CMD: row.CMD,
                [dataColum]: row.TEMP,
                [dataColumSec]: row.HUM,
                MILEAGE: row?.MILEAGE || 0,
                LAT: row.LAT,
                LNG: row.LNG
        });
    });
    avgTemp = (avgTemp / pdfData.length).toFixed(2);
    avgHum = (avgHum / pdfData.length).toFixed(2);
    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") }}: 10 min'],
                                            ['{{ __("strings.serial_model") }}: PD', '']
                                        ]
                                    },
                                    layout: 'noBorders'
                                }
                            ],
                            [
                                {
                                    table: {
                                        widths: ['*'],
                                        body: [
                                            ['{{ __("strings.trip_number") }}: {{$device->IMEI}}']
                                        ]
                                    },
                                    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'
                                }
                            ]
                        ]
                    ]
                }
            },
            
            {
                style: 'tableExample',
                pageBreak: 'after',
                table: {
                    widths: ['*'],
                    body: [
                        [
                            [
                                {
                                    table: {
                                        widths: ['*', '*'],
                                        body: [
                                            ['{{ __("strings.highest_data") }}'+ dataColumSec+': ' + maxHum.HUM + '@' + maxHum.DATE + ' ' + maxHum.TIME, '{{ __("strings.start_time") }}: ' + firstData.DATE + ' ' + firstData.TIME],
                                            ['{{ __("strings.lowest_data") }}'+ dataColumSec +': '+ minHum.HUM + '@' + minHum.DATE + ' ' + minHum.TIME, '{{ __("strings.end_time") }}: ' + endData.DATE + ' ' + endData.TIME],
                                            ['{{ __("strings.data_media") }}'+ dataColumSec +': '+ avgHum + '°%', '{{ __("strings.data_points") }}: ' + pdfData.length],
                                            ['---', '{{ __("strings.length_of_the_trip") }}: ' + elapsedTime.days() + 'd' + elapsedTime.hours() + 'h' + elapsedTime.minutes() + 'm']
                                        ]
                                    },
                                    layout: 'noBorders'
                                }
                            ]
                        ]
                    ]
                }
            },
            {text: 'Tabla de temperatura.', style: 'tableHeader', margin: [0, 8, 0, 8]},
            {
                image: "tempChartImage", margin: [0, 10, 0, 0], width: 480
            },
            {text: 'Tabla de humedad.', style: 'tableHeader', margin: [0, 8, 0, 8]},
            {
                image: "humChartImage",pageBreak: 'after', margin: [0, 10, 0, 0], width: 480
            },
            /*{text: 'Tabla de PH.', style: 'tableHeader', margin: [0, 8, 0, 8]},
            {
                image: "phChartImage",pageBreak: 'after', 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: 'Data.', style: 'tableHeader', margin: [0, 8, 0, 8]},
            table(pdfData)
        ],
	images: {
            mapImage: mapDataUrl,
            tempChartImage: tChart.getDataURL({pixelRatio: 2, backgroundColor: '#fff'}),  
            humChartImage: hChart.getDataURL({pixelRatio: 2, backgroundColor: '#fff'}),   
            //phChartImage: phChart.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';
    });
}
</script>
@endpush