@extends('layouts.main')

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

<div class="row" >
    <div class="col-md-12" >
            <div class="card">    
                <div class="card-header">
                    <h1>{{ __('strings.historical') }}</h1>
                </div>

                <div class="col-md-12">
                    <div class="col-md-4 mb-4">
                        <div>{{$device->IMEI}}</div>
                        <div class="text-muted small">{{__('device_imei')}}</div>
                    </div>

                    <div class="col-md-4 mb-4">
                        <div>{{$device->ALIAS}}</div>
                        <div class="text-muted small">{{__('alias')}} </div>
                    </div>

                    <div class="col-md-4 mb-4">
                        <div>{{$device->trama->TEMP}}</div>
                        <div class="text-muted small">{{__('strings.temp_alert')}} </div>
                    </div>

                    <div class="col-md-4 mb-4">
                        <div id='device_datetime'></div>
                        <div class="text-muted small">{{__('date_time')}} </div>
                    </div>
                </div>
                <hr/>

                <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-12 col-sm-12 col-xs-12" style="height:650px;">
                            

                                    <div>
                                            <div id="t_chart" style="width: 100%; height: 490px;"></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>TEMP</th>
                            <th>{{__('strings.date')}}</th>
                            <th>{{__('strings.time')}}</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/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 table;

var startStopPoints;

    
$(document).ready(function () {
    //initMap();
    initRangePicker();
    initCharts();
    initDataTable({});
    initPdfExporter();
    updateCharts([]);

    document.getElementById("device_datetime").innerHTML = moment.utc('{{$device->trama->CREATED_AT}}').local().format("YYYY-MM-DD HH:mm");
});


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();
        }
    });
    tChart = echarts.init(document.getElementById('t_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: 'TEMP', name: 'TEMP',  defaultContent: "", render: function(data, type, trama) { 
                        if(data){
                            var value =  parseFloat(data).toFixed(2) + "ºC";
                            return "<font color='black'>" + value + "</font>";
                        }
                        return null
                    } 
                },
                { 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");
                    } 
                }
                ],
                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';

        let image = document.getElementById('birmex');
        let birmexImage = getDataUrl(image);
        makePDF(table, birmexImage);
    };
}

function getDataUrl(img) {
   // Create canvas
   const canvas = document.createElement('canvas');
   const ctx = canvas.getContext('2d');
   // Set width and height
   canvas.width = img.width;
   canvas.height = img.height;
   // Draw the image
   ctx.drawImage(img, 0, 0);
   return canvas.toDataURL('image/png');
}


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) {  
                response.tramas[id].DATE = moment(moment.utc(response.tramas[id].CREATED_AT)).local().format("YYYY-MM-DD"); 
                response.tramas[id].TIME = moment(moment.utc(response.tramas[id].CREATED_AT)).local().format("HH:mm");     

               if(response.tramas[id].TEMP == 85) {response.tramas.TEMP = 0; }
               if(id > 0 ) {
                    // Set current values equal to latest (id - 1) if there are equal to zero                    
                    if(response.tramas[id].TEMP == 0) {
                        response.tramas[id].TEMP = response.tramas[id - 1].TEMP;
                    }
                    if(response.tramas[id].trama_device == null) {
                        response.tramas[id].trama_device = response.tramas[id - 1].trama_device;
                    }      
               } 
            }
            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 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();
    // redraw charts
    tChart.setOption(getTempOption(serie));
}

/**
 * Gets temperature serie's data format 
 * @param {type} data
 * @return {Array}     */
function getTempOption(data) {
    var serieName = 'TEMP';
    var option = {
        tooltip: {
            trigger: 'axis',
            formatter: function (params) {
                var item = data[params[0].dataIndex];
                return  '<b>' + moment.unix(item.date).format("YYYY/MM/DD HH:mm:ss") + '</b><br>'
                        + item.temp1 + '°C<br>'
                        + item.temp2 + '°F<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;
}

/**
 * Generates pdf document
 * @return {undefined}
 */
function makePDF(datatable, birmex) {
    var pdfData = [];
    var rows = datatable.data().toArray();
    var dataColum = " TEMP_C";
    var dataColumSec = " HUM";

    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 === '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 avgTemp = 0;
    //calculating min, max, mean and generating pdfData json array
    rows.forEach(function (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
            };
        }
        
        avgTemp += parseFloat(row.TEMP);
        var timeDate =  moment.utc(row.DATE + " " + row.TIME);
        
        pdfData.push({
                DATE: row.DATE,
                TIME: row.TIME,
                CMD: row.CMD,
                [dataColum]: row.TEMP,
                [dataColumSec]: row.HUM,
                LAT: row.LAT,
                LNG: row.LNG,
                IMEI: row.IMEI
        });
    });
    avgTemp = (avgTemp / 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]
                    },
                    {
                        image: "birmex", margin: 10, width: 90, alignment: 'right', 
                    }
                ]
        },
        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'
                                }
                            ]
                        ]
                    ]
                }
            },
            {text: 'Tabla de temperatura.', style: 'tableHeader', margin: [0, 8, 0, 8]},
            {
                image: "tempChartImage", margin: [0, 10, 0, 0], width: 480
            },
            {text: 'Data.', style: 'tableHeader', margin: [0, 8, 0, 8]},
            table(pdfData)
        ],
	    images: {
            tempChartImage: tChart.getDataURL({pixelRatio: 2, backgroundColor: '#fff'}),  
            birmex: birmex
        }, 
        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