@extends('adminlte::page')

@section('content')


<div class="row">
          <div class="col-12">
            <!-- Custom Tabs -->
            <div class="card">
              <div class="card-header d-flex p-0">
                <ul class="nav nav-pills p-2">
                  <li class="nav-item"><a class="nav-link active" href="#tab_1" data-toggle="tab">Unlinked pilot statements ({{$pilot_statements->count()}})</a></li>
                  <li class="nav-item"><a class="nav-link" href="#tab_2" data-toggle="tab">Failed pilot transactions ({{$failed_pilot_statements->where('failed','=','Y')->count()}})</a></li>
                </ul>
              </div><!-- /.card-header -->
              <div class="card-body">
                <div class="tab-content">
                  <div class="tab-pane active" id="tab_1">
                      <a href="/unlinked-pilot-statements?export" class="btn btn-sm btn-success" style="float:right">Export</a> <br/><br/>

                     <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>
                    <th>Failed</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>
                        <td>{{$pilot->failed}} </td>
                        </tr>
                    @endforeach
            </table>

                  </div>
                  <!-- /.tab-pane -->
                  <div class="tab-pane" id="tab_2">
                    <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>
                    <th>Failed</th>
                    </thead>
                </tr>
                    @foreach($failed_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>
                         <td>{{$pilot->failed}} </td>
                        </tr>
                    @endforeach
            </table>

                  </div>
                 
                  <!-- /.tab-pane -->
                </div>
                <!-- /.tab-content -->
              </div><!-- /.card-body -->
            </div>
            <!-- ./card -->
          </div>
          <!-- /.col -->
        </div>


<h3 style="text-align:center">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;text-align:center">Transactions are in CPS, but the Total does not equal to the FP-RT ({{count($cps_linked_duplicates)}}) (only results from last 30 days are displayed <a href="/unlinked-pilot-statements?show_all" class="btn btn-info">Show all</a>)</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>

@stop

@section('css')

@stop

@section('js')

@stop