@extends('layouts.app')

@section('custom-css')
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.24/css/jquery.dataTables.min.css">
@endsection

@section('content')

<div class="page-body"> 
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <h5>Riders Record</h5>
                </div>
                <div class="card-block">
                    <form action="{{route('riderParcelsReport')}}" method="POST">
                        @csrf
                        <div class="row">
                            <div class="col-md-5">
                                <div class="form-group form-static-label form-default">
                                    <input type="date" name="date" id="date" class="form-control" required="required" value="">
                                </div>
                            </div>
                            <div class="col-md-5">
                                <div class="form-group form-static-label form-default">
                                    <input type="date" name="to" id="to" class="form-control" required="required" value="">
                                </div>
                            </div>
                            <div class="col-md-2">
                                <button type="submit" class="btn btn-primary waves-effect waves-light" id="assign_parcel_to_rider">
                                    Submit
                                </button>
                            </div>
                        </div>
                    </form>
                    <div class="text-right">
                        <button id="btnExport" onclick="fnExcelReport();" class="btn btn-primary">Export to Excel</button>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="card-block">
    <div class="page-body display" id="printableArea">
        <div class="card">
            <div class="card-header">
                <h5>Rider Parcels List</h5>
            </div>
            <div class="card-block table-border-style">
                <div class="table-responsive">
                    <table class="table table-hover" id="example">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>Rider Name</th>
                                <th>Category</th>
                                <th>Assigned Supervisor</th>
                                <th>Assigned Area</th>
                                <th>Dispatched Area</th>
                                <th>Fuel Paid</th>
                                <th>Joining Date</th>
                                <th>Joining Days</th>
                                <th>Working Days</th>
                                <th>Total Parcels COD</th>
                                <th>Delivered Parcels COD</th>
                                <th>Cash Submitted</th>
                                <th>Cashier Name</th>
                                <th>Total Parcels</th>
                                <th>Delivered</th>
                                <th>Cancel</th>
                                <th>Re-Attempt</th>
                                <th>Un-Attempted</th>
                                <th>Delivered Ratio</th>
                                <th>Cancel Ratio</th>
                                <th>Re-Attempt Ratio</th>
                                <th>Load Sheet</th>
                                <th>Uniform</th>
                                <th>Bag Code</th>
                                <th>Insurance</th>
                                <th>Medical</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($staffList as $key => $rider)
                            @if(count($rider->totalOrders) > 0)
                            <tr>
                                <td></td>
                                <td>{{$rider->name}} ({{$rider->userDetail ? $rider->userDetail->phone : 'N/A'}})</td>
                                <td>{{ $rider->userDetail->category ? $rider->userDetail->category->category_name : ''}}</td>
                                <td>{{ ($rider->supervisorPerson) ? $rider->supervisorPerson->name : ''}}</td>
                                <td>{{ $rider->riderArea ? $rider->riderArea->name : 'N/A'}} - ({{ $rider->riderArea ? $rider->riderArea->fuel : 0}} Ltr.)</td>
                                <td style="min-width: 180px">
                                    <ul>
                                        @foreach($rider->riderFuelCalculation as $key => $verify)
                                        <li><span style="font-weight: bold;">{{date('d-m-y', strtotime($verify->date))}}:</span> {{$verify->assignedAreaDetails ? $verify->assignedAreaDetails->name : ''}} - {{$verify->fuel}}</li>
                                        @endforeach
                                    </ul>
                                </td>
                                <td style="min-width: 180px">
                                    <ul>
                                        @foreach($rider->verifyFuelCalculation as $key => $verifyfuel)
                                        <li><span style="font-weight: bold;">{{date('d-m-y', strtotime($verifyfuel->date))}}:</span> {{$verifyfuel->first_fuel + $verifyfuel->other_fuel}}</li>
                                        @endforeach
                                    </ul>
                                </td>
                                @if(!empty($rider->userDetail->joining_date))
                                <td>{{date('d-M-Y', strtotime($rider->userDetail ? $rider->userDetail->joining_date : ''))}}</td>
                                <td>{{\Carbon\Carbon::parse($rider->userDetail->joining_date)->diffInDays(\Carbon\Carbon::now())}} Days</td>
                                @else
                                <td></td>
                                <td></td>
                                @endif
                                @if(!empty($_POST['date']))
                                <td>{{\App\Models\OrderAssigned::where('rider_id', $rider->id)->whereDate('created_at','>=', $_POST['date'])->whereDate('created_at','<=',$_POST['to'])->distinct()->count(DB::raw('DATE(created_at)'))}} Days</td>
                                @else
                                <td>1 Day</td>
                                @endif
                                <br />
<b>Warning</b>:  Undefined variable $rider in <b>/home/ahlpk/public_html/admin/resources/views/supervisor/rider-detail.blade.php</b> on line <b>134</b><br />
<br />
<b>Warning</b>:  Attempt to read property "totalOrders" on null in <b>/home/ahlpk/public_html/admin/resources/views/supervisor/rider-detail.blade.php</b> on line <b>134</b><br />
<br />
<b>Warning</b>:  foreach() argument must be of type array|object, null given in <b>/home/ahlpk/public_html/admin/resources/views/supervisor/rider-detail.blade.php</b> on line <b>134</b><br />
<br />
<b>Warning</b>:  Undefined variable $rider in <b>/home/ahlpk/public_html/admin/resources/views/supervisor/rider-detail.blade.php</b> on line <b>138</b><br />
<br />
<b>Warning</b>:  Attempt to read property "deliveredOrders" on null in <b>/home/ahlpk/public_html/admin/resources/views/supervisor/rider-detail.blade.php</b> on line <b>138</b><br />
<br />
<b>Warning</b>:  foreach() argument must be of type array|object, null given in <b>/home/ahlpk/public_html/admin/resources/views/supervisor/rider-detail.blade.php</b> on line <b>138</b><br />
<br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;App\Models\RiderCashCollection&quot; not found in /home/ahlpk/public_html/admin/resources/views/supervisor/rider-detail.blade.php:142
Stack trace:
#0 {main}
  thrown in <b>/home/ahlpk/public_html/admin/resources/views/supervisor/rider-detail.blade.php</b> on line <b>142</b><br />