@extends('adminlte::page')

@section('title', 'Dashboard')



@section('content')
    <div class="card card-default">
        <div class="card-header">QB Driver Verification

            <div class="card-tools">
                <button type="button" class="btn btn-sm btn-success" data-toggle="modal" data-target="#import-qb-drivers"
                    style="margin-left: 5px;float:right">
                    <i class="fa fa-download"></i> Import
                </button>
            </div>

        </div>
        <div class="card-body">
            <table class="table table-bordered table-striped table-hover">
                <thead>
                    <th>Driver</th>
                    <th>Type</th>
                    <th>Unit#</th>
                    <th>Carrier</th>
                    <th>CPS data</th>
                    <th>QB data</th>
                    <th>Difference</th>
                    <th>Country</th>
                </thead>

                <tbody>
                    @foreach ($cps as $cps)
                        <tr>
                            {{-- <td><a href="/pilot-statements/{{$statement->id}}">{{$statement->auth_no}}</a></td> --}}
                            <td><a href="/qb-driver-verification/{{ $cps->unit }}?country={{$cps->us_can}}">
                                    @if ($cps->driverInfo != null)
                                        {{ $cps->driverInfo->name }}@else - @endif
                                </a></td>
                            <td>
                                @if ($cps->driverInfo != null)
                                    {{ $cps->driverInfo->type }}@else - @endif
                            </td>
                            <td>{{ $cps->unit }}</td>
                            <td>{{ $cps->carrier->name }}</td>
                            <td style="text-align:right">{{ number_format($cps->ttp2, 2) }}</td>
                            <td>{{number_format(\App\QBDriverVerification::where('unit',$cps->unit)->where('country',$cps->us_can)->where('week_id','>=',2050)->sum('amount'),2)}}</td>
                            <td>{{$cps->unit}}</td>
                            <td>{{ $cps->us_can }}</td>

                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>


    <div class="modal fade" id="import-qb-drivers">
        <div class="modal-dialog">
            <div class="modal-content">
                <form action="/import" method="post" enctype="multipart/form-data">
                    @csrf
                    <div class="modal-header">
                        <h4 class="modal-title">Quickbooks Driver Verification</h4>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">×</span>
                        </button>
                    </div>
                    <div class="modal-body">
                        <input type="hidden" name="report_type" value="qb-verification-drivers">
                        
                        <label for="carrier">Carrier</label>
                        <select name="carrier" class="form-control" id="country">
                            <option value="fulger">Fulger</option>
                            <option value="fulger_usa">Fulger USA</option>
                        </select>

                   

                        <label for="report">Report</label>
                        <input type="file" id="report" name="report" class="form-control" /> <br />
                        <input type="submit" class="btn btn-success" value="Import" />
                    </div>
                </form>

            </div>
        </div>
        <!-- /.modal-content -->
    </div>
@stop