@extends('adminlte::page')

@section('content')
    <div class="card">
        <div class="card-header">
            <h3 class="card-title"><b>Unlinked pilot statements </b> </h3>
            <a href="/unlinked-pilot-statements?export" class="btn btn-sm btn-success" style="float:right">Export</a>
        </div>
        <!-- /.card-header -->
        <div class="card-body">

            <table class="table table-striped table-bordered">
                <tr >
                    <thead style="text-align: center">
                    <th>Auth#</th>
                    <th>Invoice#</th>
                    <th>Ticket #</th>
                    <th>Date</th>
                    <th>Location</th>
                    <th>Country</th>
                    <th>Volume</th>
                    <th>Retail total</th>
                    </thead>
                </tr>
                    @foreach($pilot_statements as $pilot)
                        <tr>
                         <td><a href="/pilot-statements/{{$pilot->id}}">{{$pilot->auth_no}}</a></td>
                         <td>{{$pilot->invoice_no}}</td>
                         <td>{{$pilot->ticket_no}}</td>
                         <td>{{$pilot->billing_date}}</td>
                         <td>{{$pilot->location}}</td>
                         <td>{{$pilot->country}}</td>
                        <td>{{$pilot->fuel_units}}</td>
                         <td>{{$pilot->retail_total}}</td>
                        </tr>
                    @endforeach
            </table>

            <h3 style="padding:10px">Transactions in CPS but not in Pilot Statements {{$cps_not_linked->count()}}</h3>
            <table class="table table-striped table-bordered">
                <tr >
                    <thead style="text-align: center">
                    <th>Auth#</th>
                    <th>Invoice#</th>
                    <th>Date</th>
                    <th>Merchant</th>
                    <th>Country</th>
                    <th>Total</th>
                    </thead>
                </tr>
                    @foreach($cps_not_linked as $cps)
                        <tr>
                         <td><a href="/reports/{{$cps->id}}">{{$cps->auth_code}}</a></td>
                         <td>{{$cps->invoice}}</td>
                         <td>{{$cps->date}}</td>
                         <td>{{$cps->merchant}}</td>
                         <td>{{$cps->us_can}}</td>
                         <td>{{$cps->total}}</td>
                        </tr>
                    @endforeach
            </table>


        <h3 style="padding: 10px">Transactions are in CPS, but the Total does not equal to the FP-RT ({{count($cps_linked_duplicates)}})</h3>
        <table class="table table-striped table-bordered">
                <tr >
                    <thead style="text-align: center">
                    <th>Auth#</th>
                    <th>Invoice#</th>
                    <th>Date</th>
                    <th>Merchant</th>
                    <th>Country</th>
                    <th>Volume</th>
                    <th>Total</th>
                    <th>FP-RT</th>
                    <th>Difference</th>
                    </thead>
                </tr>
                    @foreach($cps_linked_duplicates as $cps)
                        <tr>
                         <td><a href="/reports/{{$cps->id}}">{{$cps->auth_code}}</a></td>
                         <td>{{$cps->invoice}}</td>
                         <td>{{$cps->date}}</td>
                         <td>{{$cps->merchant}}</td>
                         <td>{{$cps->us_can}}</td>
                         <td>{{$cps->volume}}</td>
                         <td>{{$cps->total}}</td>
                         <td>{{$cps->pilotStatement->sum('retail_total')}}</td>
                         <td>{{$cps->total-$cps->pilotStatement->sum('retail_total')}}</td>
                        </tr>
                    @endforeach
            </table>

        </div>
        <!-- /.card-body -->
    </div>
@stop

@section('css')

@stop

@section('js')

@stop