@extends('adminlte::page')

@section('content')
<div class="card">
    <div class="card-header">
        <h3 class="card-title"><b>Search </b> </h3>
    </div>
    <div class="card-body">
        <form action="" method="get" class="form-inline">

        <label for="from">Date From</label>
        <input type="date" name="from" id='from' value="{{request()->input('from')}}" class="form-control" style="width:170px"/>
            <label for="to">Date To</label>
        <input type="date" name="to" id='to' class="form-control" value="{{request()->input('to')}}" style="width:170px"/>
            <div class="form-group">
                <label for="country">Country</label>
                <select name="country" id="country" class="form-control" style="margin-right:5px">
                <option value="">All</option>    
                <option value="US" @if(request()->input('country')=='US') selected @endif>US</option>
                    <option value="CAN" @if(request()->input('country')=='CAN') selected @endif>CAN</option>
                </select>
            </div>
            <div class="form-group">
                <label for="unit">Unit#</label>
                <input type="text" name="unit" class="form-control" style="width:80px;margin-left:5px;margin-right:5px"
                    value="{{request()->input('unit')}}">
            </div>
            <input type="submit" value="Search" class="btn btn-success" style="margin-right:5px" />
            <input type="submit" class="btn btn-info" name="ifta_export_excel" style="margin-right:5px" value="Export XLS" />
         

        </form>
    </div>
</div>
<!-- /.card-body -->
</div>

<table class="table table-striped table-bordered" id="summary">
    <thead style="text-align: center">
        <th>Date</th>
        <th>Unit#</th>
        <th>Unit# S</th>
        <th>Driver name</th>
        <th>Card#</th>
        <th>Fuel provider</th>
        <th>Truck volume</th>
        <th>DEF Volume</th>
        <th>State</th>
        <th>Country</th>
    </thead>
    <tbody>
        @foreach($report as $carrier)
        <tr>
            <td>{{$carrier->date->format('d/m/Y')}}</a></td>
            <td>{{$carrier->unit}}</td>
            <td>@if($carrier->unit!=''){{$carrier->unit}} @else {{$carrier->auto_completed_unit}} @endif</td>
            <td>{{$carrier->driver}}</td>
            <td>@if($carrier->fuel_provider=='pilot' && isset($carrier->pilotStatement->first()->card_no)){{substr($carrier->pilotStatement->first()->card_no,-8)}}@else - @endif</td>
            <td>{{$carrier->fuel_provider}}</td>
            <td>{{$carrier->volume}}</td>
            <td> @if($carrier->fuel_provider=='pilot'){{$carrier->pilotStatement->where('fuel_type','=',140)->sum('fuel_units')}} @else @if($carrier->def<$carrier->def2){{$carrier->def}} @else {{$carrier->def2}} @endif @endif</td>
            <td>{{array_reverse(explode(",",$carrier->merchant))[0]}}</td>
            <td>{{$carrier->us_can}}</td>
            
        </tr>
        @endforeach
    </tbody>
</table>

{{$report->appends(request()->input())->links()}}

@stop


@section('css')
<link rel="stylesheet" href="//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://unpkg.com/multiple-select@1.5.2/dist/multiple-select.min.css">

<style>
    .loading {
        width: 300px;
        padding: 20px;
        background: orange;
        color: white;
        text-align: center;
        margin: 0 auto;
    }

    .modal {
        position: fixed;
        top: 1% !important;
        left: 5%;
    }

</style>

@stop
@section('js')
<script src="https://unpkg.com/multiple-select@1.5.2/dist/multiple-select.min.js"></script>

<script>
    $(function () {
        $("#summary").DataTable({
            "paging": false,
            "searching": false,
            "bInfo": false
        });
        $('#week_id').multipleSelect();

    });
</script>
@stop