@extends('layouts.main')

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

@section('content')
    <div class="row col-md-12">
        <div class="row col-md-12">
                <div class="col-md-6">
                            <h4 class="form-section">{{__('strings.quiq_trips_header')}}</h4>

                        <div class="input-group mb-3">
                                        <input type="text" id="daterange" name="daterange" class="form-control"/>
                                        <div class="input-group-append">
                                            <span class="input-group-text">
                                                <i  id="calendar-icon" class="glyphicon glyphicon-calendar fa fa-calendar" style="cursor: pointer;"></i>
                                            </span>
                                        </div>
                        </div>
                </div>
        </div>
    </div>
    <div class="row col-md-12">
    <div class="col-md-12">
                    <ul class="nav nav-tabs" role="tablist">
                        <li class="nav-item">
                            <a class="nav-link active" data-toggle="tab" href="#trips" role="tab" aria-controls="home">
                                <i class="fa fa-taxi"></i>
                                {{__('strings.quiq_report_header')}} &nbsp;
                                <span id="trips_count" style="display:none" class="badge badge-pill badge-success">29</span>
                            </a>
                        </li>

                        <li class="nav-item">
                            <a class="nav-link" data-toggle="tab" href="#extra_trips" role="tab" aria-controls="profile">
                                <i class="fa fa-taxi"></i>
                                {{__('strings.extra_trips')}} &nbsp;
                                <span id="extra_trips_count" style="display:none"  class="badge badge-pill badge-danger">29</span>
                            </a>
                        </li>                        
                    </ul>

                    <div class="tab-content">
                        <div class="tab-pane active match-height" id="trips" role="tabpanel">
                            <div class="card-block">
                                <div class="form-body">
                                        <div class="form-group">                                            
                                                <div class="table-responsive" style="height: 720px;">
                                                <table id="trips-table" class="table hover mb-0">
                                                    <thead class="thead-inverse">
                                                        <tr>
                                                            <th>ID</th>	
                                                            <th>{{__('strings.created_at')}}</th>
                                                            <th>{{__('strings.time_at')}}</th>               	
                                                            <th>STATUS</th>             	
                                                            <th>---</th>
                                                            <th>NIP</th>
                                                            <th>{{__('strings.department')}}</th>
                                                            <th>{{__('strings.driver_name')}}</th>
                                                            <th>Email {{__('strings.driver')}}</th>
                                                            <th>{{__('strings.user_name')}}</th>
                                                            <th>Email {{__('strings.user')}}</th>
                                                            <th>{{__('strings.taxi_type')}}</th>
                                                            <th>{{__('strings.payment')}}</th>
                                                            <th>{{__('strings.passenger')}}</th>
                                                            <th>{{__('strings.start_address')}}</th>
                                                            <th>{{__('strings.trip_addresses')}}</th>
                                                            <th>{{__('strings.company_name')}}</th>
                                                            <th>RFC</th>
                                                            <th>{{__('strings.company_address')}}</th>
                                                            <th>{{__('strings.amount')}}</th>
                                                            <th>IVA</th>
                                                            <th>SubTotal-IVA</th>
                                                            <th>{{__('strings.statal_tax')}}</th>
                                                            <th>SubTotal-{{__('strings.statal_tax')}}</th>
                                                            <th>{{__('strings.company_tax')}}</th>
                                                            <th>SubTotal-{{__('strings.company_tax')}}</th>
                                                            <th>{{__('strings.other_tax')}}</th>
                                                            <th>{{__('strings.base_rates')}}</th>
                                                            <th>{{__('strings.driver_rate')}}</th>
                                                            <th>{{__('strings.supervisor_rate')}}</th>
                                                            <th>{{__('strings.supervisor_rate')}} 2</th>
                                                            <th>{{__('strings.supervisor_rate')}} 3</th>
                                                            <th>{{__('strings.recruiter_rate')}}</th>
                                                            <th>{{__('strings.seller_rate')}}</th>
                                                            <th>{{__('strings.quiq_rate')}}</th>
                                                            <th>{{__('strings.advertising_rate')}}</th>
                                                            <th>{{__('strings.extra_rate')}}</th>
                                                            <th>{{__('strings.supervisor_name')}}</th>
                                                            <th>{{__('strings.supervisor_name')}} 2</th>
                                                            <th>{{__('strings.supervisor_name')}} 3</th>
                                                            <th>{{__('strings.recruiter_name')}}</th>
                                                            <th>{{__('strings.seller_name')}}</th>
                                                            <th>Fecha/Hora Programado</th>
                                                            <th>Fecha/Hora viaje comenzado</th>
                                                            <th>KM</th>
                                                            <th>{{__('strings.passenger')}}</th>
                                                            <th>Clasificación</th>
                                                            <th>Precio Banderazo</th>
                                                            <th>Pasajero Extra</th>
                                                            <th>Comentario Viaje</th>
                                                            <th>Placas</th>
                                                            <th>Placas 2</th>
                                                            <th>{{__('strings.km_local')}}</th>
                                                            <th>{{__('strings.km_foreign')}}</th>
                                                            <th>Min. Espera</th>
                                                            <th>Tarifa x Min.</th>
                                                            <th>Total Espera</th>
                                                            <th>{{__('strings.extra_passengers')}}</th>
                                                            <th>Motivo Cancelación</th>
                                                            <th>Proyecto</th>
                                                            <th>Viaje Emergencia</th>
                                                        </tr>
                                                    </thead>
                                                </table>
                                            </div>
                                        </div>
                                </div>
                            </div>
                        </div>

                        <div class="tab-pane" id="extra_trips" role="tabpanel">
                            <div class="card-block">
                                <div class="form-body">
                                        <div class="form-group">
                                                <div class="table-responsive" style="height: 720px;">
                                                <table id="extra-trips-table" class="table hover mb-0">
                                                    <thead class="thead-inverse">
                                                        <tr>
                                                            <th>ID</th>	    
                                                            <th>{{__('strings.created_at')}}</th>
                                                            <th>{{__('strings.time_at')}}</th>            	
                                                            <th>STATUS</th>
                                                            <th>Eliminar</th>	         	
                                                            <th>NIP</th>
                                                            <th>{{__('strings.department')}}</th>
                                                            <th>{{__('strings.driver_name')}}</th>
                                                            <th>Email {{__('strings.driver')}}</th>
                                                            <th>{{__('strings.user_name')}}</th>
                                                            <th>Email {{__('strings.user')}}</th>
                                                            <th>{{__('strings.taxi_type')}}</th>
                                                            <th>{{__('strings.payment')}}</th>
                                                            <th>{{__('strings.passenger')}}</th>
                                                            <th>{{__('strings.start_address')}}</th>
                                                            <th>{{__('strings.trip_addresses')}}</th>
                                                            <th>{{__('strings.company_name')}}</th>
                                                            <th>RFC</th>
                                                            <th>{{__('strings.company_address')}}</th>
                                                            <th>{{__('strings.amount')}}</th>
                                                            <th>IVA</th>
                                                            <th>SubTotal-IVA</th>
                                                            <th>{{__('strings.statal_tax')}}</th>
                                                            <th>SubTotal-{{__('strings.statal_tax')}}</th>
                                                            <th>{{__('strings.company_tax')}}</th>
                                                            <th>SubTotal-{{__('strings.company_tax')}}</th>
                                                            <th>{{__('strings.other_tax')}}</th>
                                                            <th>{{__('strings.base_rates')}}</th>
                                                            <th>{{__('strings.driver_rate')}}</th>
                                                            <th>{{__('strings.supervisor_rate')}}</th>
                                                            <th>{{__('strings.supervisor_rate')}} 2</th>
                                                            <th>{{__('strings.supervisor_rate')}} 3</th>
                                                            <th>{{__('strings.recruiter_rate')}}</th>
                                                            <th>{{__('strings.seller_rate')}}</th>
                                                            <th>{{__('strings.quiq_rate')}}</th>
                                                            <th>{{__('strings.advertising_rate')}}</th>
                                                            <th>{{__('strings.extra_rate')}}</th>
                                                            <th>{{__('strings.supervisor_name')}}</th>
                                                            <th>{{__('strings.supervisor_name')}} 2</th>
                                                            <th>{{__('strings.supervisor_name')}} 3</th>
                                                            <th>{{__('strings.recruiter_name')}}</th>
                                                            <th>{{__('strings.seller_name')}}</th>
                                                            <th>Fecha/Hora Programado</th>
                                                            <th>Fecha/Hora viaje comenzado</th>
                                                            <th>KM</th>
                                                            <th>{{__('strings.passenger')}}</th>
                                                            <th>Clasificación</th>
                                                            <th>Precio Banderazo</th>
                                                            <th>Pasajero Extra</th>
                                                            <th>Comentario Viaje</th>
                                                            <th>Placas</th>
                                                            <th>Placas 2</th>
                                                            <th>{{__('strings.km_local')}}</th>
                                                            <th>{{__('strings.km_foreign')}}</th>
                                                            <th>{{__('strings.waiting_time')}} hh:mm</th>
                                                            <th>Tarifa x Min.</th>
                                                            <th>Total Espera</th>
                                                            <th>{{__('strings.extra_passengers')}}</th>
                                                            <th>Motivo Cancelación</th>
                                                            <th>Proyecto</th>
                                                            <th>Viaje Emergencia</th>
                                                        </tr>
                                                    </thead>
                                                </table>
                                            </div>
                                        </div>
                                </div>
                            </div>
                        </div>

                    </div>
                </div>
</div>

@endsection

@push('scripts')
<script type="text/javascript" src="{{asset('js/daterangepicker.js')}}"></script>
<script type="text/javascript" src="{{asset('js/numeral.min.js')}}"></script>
<script type="text/javascript" src="{{asset('js/quiq_accountant.js')}}"></script>

<script type="text/javascript">
	var table, extraTable;
$(function() {
	//setting language for moment.js
	moment.locale('es');

    table = $('#trips-table').DataTable({
				responsive: false,
                paging: false,					
				columns: [
				{ data: 'ID_ROUTE'},                                
				{ data: 'CREATED_AT', name: 'CREATED_AT', render: function(data, type, row, meta)
                    {
                        return moment.utc(data).local().format('YYYY-MM-DD');
                    }
                }, 
				{ data: 'CREATED_AT', name: 'CREATED_AT', render: function(data, type, row, meta)
                    {
                        return moment.utc(data).local().format('HH:mm:ss');
                    }
                },   
				{ data: 'ROUTE_STATUS', render: function(value, type, row){
                        return '<a href="#" onclick="updateTripStatus(\'' + row.TOKEN  + '\')">' + value + "</a>";
                }, defaultContent:"N/A"},
                { data: 'ROUTE_STATUS', defaultContent:"N/A"},
                { data: 'business_trip', render: function(business_trip, type, row){
                        if(business_trip)
                            return business_trip.NIP
                        else
                            return null;
                }, defaultContent:"N/A"},
                { data: 'business_trip', render: function(business_trip, type, row){
                        if(business_trip)
                            return business_trip.NIP_DEPARTMENT
                        else
                            return null;
                }, defaultContent:"N/A"},
                { data: 'driver', render: function(data, type, row, meta){
                        if(data) {
                            return data.NAME + " " + data.LAST_NAME; 
                        } else {
                            return "N/A";
                        }
                }},
				{ data: 'driver',render: function(data, type, row, meta){
                        if(data) {
                            return data.EMAIL; 
                        } else {
                            return "N/A";
                        }
                }},
                { data: 'user',render: function(data, type, row, meta){
                        if(data) {
                            return data.NAME + " " + data.LAST_NAME; 
                        } else {
                            return "N/A";
                        }
                }},
                { data: 'user',render: function(data, type, row, meta){
                        if(data) {
                            return data.EMAIL; 
                        } else {
                            return "N/A";
                        }
                }},
                { data: 'driver',render: function(data, type, row, meta){
                        if(data) {
                            return data.TAXI_TYPE; 
                        } else {
                            return "N/A";
                        }
                }},
				{ data: 'invoice', render: function(data, type, row, meta){
						if(data != null) {
							var payment = data.PAYMENT_JSON;
							var image = '';

							switch(payment.DATA.type) {
								case 'EFEC':
									image = '{{asset('images/cash.png')}}';
								break;
								case 'VISA':
									image = '{{asset('images/visa.png')}}';
								break;
								case 'MAST':
									image = '{{asset('images/mast.png')}}';
								break;
								case 'AMEX':
									image = '{{asset('images/amex.png')}}';
								break;
                                                                case 'CRED':
									image = '{{asset('images/cred.png')}}';
								break;
							}
							var html =  "<img class='media-object' src='"+image+"' style='width: 32px;height: 32px;' />"

							+ "</a>"
							+ "<h5 class='media-heading'>" + payment.DATA.alias + " </h5>"
							+ payment.DATA.description;
							return html;
						} else {
							return null;
						}
				}, defaultContent: "<i>Sin Pago</i>"},
                { data: 'business_trip', render: function(trip){
                        if(trip) 
                            return trip.PASSENGERS_NUMBER;
                        else 
                            return "N / A";
                }},
                { data: 'BEGIN_ADDRESS',defaultContent:"N/A"},
                { data: 'business_trip', render: function(trip){
                        if(trip) {
                            var locations = "";
                            
                            for(var i = 1; i <= 4; i++) {
                                if(trip.LOCATIONS["start_address" + i] && trip.LOCATIONS["start_address" + i].address) {
                                        locations += "Direccion inicio #" + i + " - " + trip.LOCATIONS["start_address" + i].passenger  + ", " + trip.LOCATIONS["start_address" + i].address + ". ";
                                }
                                if(trip.LOCATIONS["end_address" + i] && trip.LOCATIONS["end_address" + i].address) {
                                        locations += "Direccion destino #" + i + " - " + trip.LOCATIONS["end_address" + i].passenger  + ", " + trip.LOCATIONS["end_address" + i].address + ". ";
                                }
                            }                                            
                            return locations;
                        }
                        else { 
                            return "N / A";
                        }
                }},
                { data: 'user',render: function(data, type, row, meta){
                    if(data) {
                        return data.COMPANY_NAME; 
                    } else {
                        return "N/A";
                    }
                }},
                { data: 'user',render: function(data, type, row, meta){
                    if(data) {
                        return data.RFC; 
                    } else {
                        return "N/A";
                    }
                }},
                { data: 'user',render: function(data, type, row, meta){
                    if(data) {
                        return data.COMPANY_ADDRESS; 
                    } else {
                        return "N/A";
                    }
                }},
				{ data: 'ID_ROUTE', render: function(business_trip, type, trip) {
                    return GET_TOTAL(trip);
                }},
                {data: 'ID_ROUTE', render: TRIP_IVA, defaultContent:"N/A"},
                {data: 'ID_ROUTE', render: TRIP_SUBTOTAL_IVA, defaultContent:"N/A"}, 
                {data: 'ID_ROUTE', render: TRIP_STATAL_TAX, defaultContent:"N/A"}, 
                {data: 'ID_ROUTE', render: TRIP_SUBTOTAL_STATAL_TAX, defaultContent:"N/A"},
                {data: 'ID_ROUTE', render: TRIP_COMPANY_TAX, defaultContent:"N/A"}, 
                {data: 'ID_ROUTE', render: TRIP_SUBTOTAL_COMPANY_TAX, defaultContent:"N/A"}, 
                {data: 'ID_ROUTE', render: TRIP_OTHER_TAX, defaultContent:"N/A"},             
                {data: 'ID_ROUTE', render: TRIP_BASE_RATE, defaultContent:"N/A"},           
                {data: 'ID_ROUTE', render: TRIP_DRIVER_COMMISSION, defaultContent:"N/A"},   
                {data: 'ID_ROUTE', render: TRIP_SUPERVISOR_COMMISSION, defaultContent:"N/A"},
                {data: 'ID_ROUTE', render: TRIP_SUPERVISOR2_COMMISSION, defaultContent:"N/A"},
                {data: 'ID_ROUTE', render: TRIP_SUPERVISOR3_COMMISSION, defaultContent:"N/A"},
                {data: 'ID_ROUTE', render: TRIP_RECRUITER_COMMISSION, defaultContent:"N/A"},  
                {data: 'ID_ROUTE', render: TRIP_SELLER_COMMISSION, defaultContent:"N/A"},   
                {data: 'ID_ROUTE', render: TRIP_QUIQ_COMMISSION, defaultContent:"N/A"},     
                {data: 'ID_ROUTE', render: TRIP_ADVERTISING_COMMISSION, defaultContent:"N/A"},
                {data: 'ID_ROUTE', render: TRIP_EXTRA_COMMISSION, defaultContent:"N/A"},     
                {data: 'user.SUPERVISOR_NAME', defaultContent:"N/A"},          
                {data: 'user.SUPERVISOR2_NAME', defaultContent:"N/A"},          
                {data: 'user.SUPERVISOR3_NAME', defaultContent:"N/A"},       
                {data: 'user.RECRUITER_NAME', defaultContent:"N/A"},       
                {data: 'user.SELLER_NAME', defaultContent:"N/A"},          
                {data: 'SCHEDULED_AT', defaultContent:"N/A"},          
                {data: 'STARTED_AT', defaultContent:"N/A"},
                { data: 'TRIP_FARE.km', defaultContent: "0" },
                { data: 'business_trip', render: function(trip){
                        if(trip) {
                            var locations = "";
                            
                            for(var i = 1; i <= 5; i++) {
                                if(trip.LOCATIONS["start_address" + i] && trip.LOCATIONS["start_address" + i].passenger) {
                                        locations += "Inicio #" + i + " [" +  (trip.LOCATIONS["start_address" + i].employee_number  || '' ) + "] " + trip.LOCATIONS["start_address" + i].passenger + ". ";
                                }
                            }  
                            for(var i = 1; i <= 5; i++) {
                                if(trip.LOCATIONS["end_address" + i] && trip.LOCATIONS["end_address" + i].passenger) {
                                        locations += "Destino #" + i + " [" + (trip.LOCATIONS["end_address" + i].employee_number  || '' ) + "] " + trip.LOCATIONS["end_address" + i].passenger  + ". ";
                                }
                            }                                            
                            return locations;
                        }
                        else { 
                            return "N / A";
                        }
                }},  
                { data: 'CLASSIFICATION',defaultContent:"Ninguna"},
                { data: 'user.rates.init_rate',defaultContent:""},
                { data: 'user.rates.extra_price',defaultContent:""},
                { data: 'COMMENTS', defaultContent:""},
                { data: 'driver.NUMBER_PLATE', defaultContent:"N/A"},   
                { data: 'PLATE_2', defaultContent:"N/A"},
                { data: 'km_local', defaultContent: '0'},
                { data: 'km_foreign', defaultContent: '0'},
                { data: 'WAITING_MINUTES', defaultContent: '0'},
                { data: 'WAITING_MINUTES_FEE', defaultContent: '0'},
                { data: 'WAITING_MINUTES_TOTAL', defaultContent: '0'},
                { data: 'business_trip', render: function(trip){
                        if(trip) 
                            return trip.PASSENGERS_NUMBER - 1;
                        else 
                            return 0;
                }},
                { data: 'empy', defaultContent:"N/A"},
                { data: 'empy', defaultContent:"N/A"},    
                { data: 'notification', defaultContent:"N/A",  render: function(notification) {
                        try {
                            if(notification?.DATA?.includes('"app_name": "quiq_web_emergency"')) {
                                return "EMERGENCIA";
                            }
                            else {
                                return null;
                            }
                        } catch(err) {

                            return null;
                        }
                    }
                }                                    
            ],
            "columnDefs": [
                { "width": "20%", "targets": '_all' }
            ],
			dom: 'Bfrtip',
			buttons: [
			'copy', 'excel'
			],
			paging: false,
			"language": {
				"url": "{!! asset('Datatables/languages/spanish.json') !!}"
			},
                        createdRow: function( row, data, dataIndex ) {
                            if ( data.ROUTE_STATUS == "CANCELED" ) {
                                $(row).addClass( 'bg-warning bg-lighten-4' );
                            }
                        }
		});
                
    extraTable = $('#extra-trips-table').DataTable({
				responsive: false,
				paging: false,					
				columns: [
				{ data: 'id'},
				{ data: 'route_created_at', render: function(data, type, row, meta)
                    {
                        return moment.utc(data).local().format('YYYY-MM-DD');
                    }
                },   
				{ data: 'route_created_at', render: function(data, type, row, meta)
                    {
                        return moment.utc(data).local().format('HH:mm:ss');
                    }
                }, 
				{ data: 'status', defaultContent:"N/A"},                                
                { data: 'id', render: function(data, type, row, meta){
                    return "<a href='#' onclick='deleteExtraRoute(" + data + ")''>{{__('strings.submit_cancel')}}</a>";   
                }},
                { data: 'nip_name', defaultContent:"N/A"},
                { data: 'nip_department', defaultContent:"N/A"},
                { data: 'driver_name', render: function(data, type, row, meta) {
                        return row.driver_name + " " + row.driver_lastname;
                    }, defaultContent:"N/A"},
				{ data: 'driver_email', defaultContent:"N/A"},
                { data: 'user',render: function(data, type, row, meta){
                        if(data) {
                            return data.NAME + " " + data.LAST_NAME; 
                        } else {
                            return "N/A";
                        }
                }},
                { data: 'user',render: function(data, type, row, meta){
                        if(data) {
                            return data.EMAIL; 
                        } else {
                            return "N/A";
                        }
                }},
                { data: 'taxi_type', defaultContent:"N/A"},
                { data: 'payment_type', defaultContent:"N/A"},
                { data: 'total_passengers', defaultContent:"N/A"},
                { data: 'start_address', defaultContent:"N/A"},
                { data: 'trip_addresses', defaultContent:"N/A"},   
                { data: 'user',render: function(data, type, row, meta){
                    if(data) {
                        return data.COMPANY_NAME; 
                    } else {
                        return "N/A";
                    }
                }},
                { data: 'user',render: function(data, type, row, meta){
                    if(data) {
                        return data.RFC; 
                    } else {
                        return "N/A";
                    }
                }},
                { data: 'user',render: function(data, type, row, meta){
                    if(data) {
                        return data.COMPANY_ADDRESS; 
                    } else {
                        return "N/A";
                    }
                }},
				{data: 'total', defaultContent:"N/A"},          
                {data: 'id', render: TRIP_IVA, defaultContent:"N/A"},
                {data: 'id', render: TRIP_SUBTOTAL_IVA, defaultContent:"N/A"}, 
                {data: 'id', render: TRIP_STATAL_TAX, defaultContent:"N/A"}, 
                {data: 'id', render: TRIP_SUBTOTAL_STATAL_TAX, defaultContent:"N/A"},
                {data: 'id', render: TRIP_COMPANY_TAX, defaultContent:"N/A"}, 
                {data: 'id', render: TRIP_SUBTOTAL_COMPANY_TAX, defaultContent:"N/A"}, 
                {data: 'id', render: TRIP_OTHER_TAX, defaultContent:"N/A"},             
                {data: 'id', render: TRIP_BASE_RATE, defaultContent:"N/A"},           
                {data: 'id', render: TRIP_DRIVER_COMMISSION, defaultContent:"N/A"},   
                {data: 'id', render: TRIP_SUPERVISOR_COMMISSION, defaultContent:"N/A"},
                {data: 'id', render: TRIP_SUPERVISOR2_COMMISSION, defaultContent:"N/A"},
                {data: 'id', render: TRIP_SUPERVISOR3_COMMISSION, defaultContent:"N/A"},
                {data: 'id', render: TRIP_RECRUITER_COMMISSION, defaultContent:"N/A"},  
                {data: 'id', render: TRIP_SELLER_COMMISSION, defaultContent:"N/A"},   
                {data: 'id', render: TRIP_QUIQ_COMMISSION, defaultContent:"N/A"},     
                {data: 'id', render: TRIP_ADVERTISING_COMMISSION, defaultContent:"N/A"},
                {data: 'id', render: TRIP_EXTRA_COMMISSION, defaultContent:"N/A"},     
                {data: 'user.SUPERVISOR_NAME', defaultContent:"N/A"},          
                {data: 'user.SUPERVISOR2_NAME', defaultContent:"N/A"},          
                {data: 'user.SUPERVISOR3_NAME', defaultContent:"N/A"},       
                {data: 'user.RECRUITER_NAME', defaultContent:"N/A"},       
                {data: 'user.SELLER_NAME', defaultContent:"N/A"},  
                { data: 'route_created_at', defaultContent:"N/A"},
                { data: 'route_created_at', defaultContent:"N/A"},
                { data: 'distance', defaultContent: "0" },
                {data: 'passengers', defaultContent:"N/A"},  
                { data: 'classification',defaultContent:"Ninguna"},
                { data: 'user.rates.init_rate',defaultContent:""},
                { data: 'user.rates.extra_price',defaultContent:""},
                { data: 'id',render: function(data, type, row, meta){
                    return "N/A";
                }},
                { data: 'plates', defaultContent: "N/A" },
                { data: 'plates', defaultContent: "N/A" },
                { data: 'km_local', defaultContent: "---"},
                { data: 'km_foreign', defaultContent: "---"},
                { data: 'waiting_time', defaultContent: "---", render: function(data, type, row, meta) {
                            return data.substring(0,5);
                    
                }},
                { data: 'naive_field', defaultContent: "---"},
                { data: 'naive_field', defaultContent: "---"},
                { data: 'extra_passengers', defaultContent: "---"},
                {data: 'cancel_comments', defaultContent:"N/A"},   
                {data: 'project', defaultContent:"N/A"},
                { data: 'empy', defaultContent:"N/A"}            
			],
            "columnDefs": [
                { "width": "20%", "targets": '_all' }
            ],
			dom: 'Bfrtip',
			buttons: [
			'copy', 'excel'
			],
			paging: false,
			"language": {
				"url": "{!! asset('Datatables/languages/spanish.json') !!}"
			},
                        createdRow: function( row, data, dataIndex ) {
                            if ( data.ROUTE_STATUS == "CANCELED" ) {
                                $(row).addClass( 'bg-warning bg-lighten-4' );
                            }
                        }
		});

    $('#daterange').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",
    },
    });
    
    
});
//get click evento on daterangepicker
$('#daterange').on('apply.daterangepicker', function (ev, picker) {       
	getData(picker.startDate.format('YYYY-MM-DD HH:mm'), picker.endDate.format('YYYY-MM-DD HH:mm'));
});
$('#calendar-icon').click(function() {
      $("#daterange").click();
});

function getData(startDate, endDate) {
        $.showPreloader('{{__("strings.loading")}}');
	$.ajax({
            url: "{{route('api_quiq_trips')}}",
            type: "POST",
            contentType: "aplication/json",
            dataType: "json",
            data: JSON.stringify({
                user_token: '{{Auth::user()->token}}',
                start_date: moment(startDate).utc().format('YYYY-MM-DD HH:mm'),
                end_date: moment(endDate).utc().format('YYYY-MM-DD HH:mm'),
            }),
            success: function (json) {
                fillTable(json.data);
                fillExtraTable(json.extra_routes);
                $.hidePreloader();
            },
            error: function (err) {
                    console.log(err);
                    if(table != null) {
                            table.clear().draw();
                    }
                    $.hidePreloader();
            }
        });
}


function fillTable(dataSet) {
    if(dataSet.length > 0 ) {
        $('#trips_count').show();
        $('#trips_count').html(dataSet.length);
    } else {
        $('#trips_count').hide();
    }
    table.clear();
    table.rows.add(dataSet).draw();
}

function fillExtraTable(data) {
    
    if(data.length > 0 ) {
        $('#extra_trips_count').show();
        $('#extra_trips_count').html(data.length);
    } else {
        $('#extra_trips_count').hide();
    }
    extraTable.clear();
    extraTable.rows.add(data).draw();
    
}

function updateTripStatus(tripToken) {
        bootbox.prompt({
            closeButton: false,
            title: "Actualizar status de viaje!",
            inputType: 'select',
            inputOptions: [
                {
                    text: 'FINALIZADO',
                    value: 'FINALIZADA',
                },
                {
                    text: 'EN RUTA',
                    value: 'INROUTE',
                },
                {
                    text: 'CANCELADO',
                    value: 'CANCELED',
                },
                {
                    text: 'INDEFINIDO',
                    value: 'UNDEFINED',
                }
            ],
            callback: function (result) {
                if(result) {
                    $.post("{{route('update_quiq_trip_status')}}", { user_token: '{{Auth::user()->token}}', trip_token: tripToken, trip_status: result} ,function(response){
                        location.reload();
                    }).fail(function(error) {
                        console.log(error);
                        $.alert(error?.responseJSON?.message, 'Error');
                      });
                }
            }
        }).find('.modal-content').css({
                'margin-top': function (){
                var w = $( window ).height();
                var b = $(".modal-dialog").height();
                // should not be (w-h)/2
                var h = (w-b)/2;
                return h+"px";
            }
        });
}

function deleteExtraRoute(tripId) {
    $.prompt("Sin comentarios",'Presiona -Ok- para eliminar el viaje extra, <strong> id: ' + tripId + "</strong>", 
        function(value){
            $.showPreloader('{{__("strings.loading")}}');
            $.post("{{route('delete_quiq_estra_trip')}}", {
            user_token: '{{Auth::user()->token}}',
            trip_id: tripId,
            comments: value,
            }, function(response) {
                $.hidePreloader();
                $.alert(response.message,function(){
                    location.reload();
                })
            }).fail(function(error){
                $.hidePreloader();
                $.alert(error?.responseJSON?.message,'Error');
            });
        });
    /*
    $.confirm('Presiona -Ok- para eliminar el viaje extra, <strong>con id = ' + tripId + "</strong>",function(){
        $.showPreloader('{{__("strings.loading")}}');
        
    });
    */
}
</script>
@endpush