@extends('adminlte::page')


@section('content')

@if ($message = Session::get('success'))
<div class="alert alert-success">
  <p>{{ $message }}</p>
</div>
@endif


<div class="col-md-9 mx-auto">
  <div class="card">
    <div class="card-header">
      <h3 class="card-title"><b>CPS transaction #{{$rep->auth_code}} ; Date: {{$rep->date->format('m/d/Y')}}; RT: {{$rep->ttp2+$rep->total_discount}};FP: {{$rep->merchant}}; FPC1 : @if($rep->fpc1()==0)<span style="color:green">{{$rep->fpc1()}}</span> @else <span style="color:red">{{$rep->fpc1()}}</span> @endif</b></h3>
      <a href="/reports/{{$rep->id}}/edit" class="btn bt-sm btn-warning" style="float:right"> <i class="fa fa-edit"></i> Edit</a>
    </div>
    <!-- /.card-header -->
    <div class="card-body">



      <div id="accordion">
        <!-- we are adding the .class so bootstrap.js collapse plugin detects it -->
        <div class="card card-primary">
          <div class="card-header">
            <h4 class="card-title">
              <a data-toggle="collapse" data-parent="#accordion" href="#collapseOne" class="collapsed" aria-expanded="true">
                CPS Info
              </a>
            </h4>
          </div>

          <div id="collapseOne" class="panel-collapse in collapse" style="">
            <div class="card-body">

              <table class="table table-bordered table-hover table-striped">
                <tr>
                  <td>Report ID</td>
                  <td>{{$rep->report_id}}</td>
                </tr>
                <tr>
                  <td>Direct billing</td>
                  <td>{{$rep->direct_billing}}</td>
                </tr>
                <tr>
                  <td>Auth code</td>
                  <td>{{$rep->auth_code}}</td>
                </tr>
                <tr>
                  <td>Invoice</td>
                  <td>{{$rep->invoice}}</td>
                </tr>
                <tr>
                  <td>Date</td>
                  <td>{{$rep->date}}</td>
                </tr>
                <tr>
                  <td>Fuel provider</td>
                  <td>{{$rep->fuel_provider}}</td>
                </tr>
                @if($rep->fuel_provider=='pilot')
                <tr>
                  <td>Pilot Independent</td>
                  <td>{{$rep->pilot_independent}}</td>
                </tr>
                @endif
                <tr>
                  <td>Country</td>
                  <td>{{$rep->us_can}}</td>
                </tr>
                <tr>
                  <td>Driver</td>
                  <td>{{$rep->driver}}</td>
                </tr>
                <tr>
                  <td>Unit</td>
                  <td>{{$rep->unit}}</td>
                </tr>
                <tr>
                  <td>Carrier</td>
                  <td>{{$rep->carrier->name}}</td>
                </tr>
                <tr>
                  <td>TTP2</td>
                  <td>{{$rep->ttp2}}</td>
                </tr>
                <tr>
                  <td>Discount</td>
                  <td>{{$rep->total_discount}}</td>
                </tr>
                <tr>
                  <td>Retail total</td>
                  <td>{{$rep->ttp2+$rep->total_discount}}</td>
                </tr>
                <tr>
                  <td>Merchant ID</td>
                  <td>{{$rep->merchant_id}}</td>
                </tr>
                <tr>
                  <td>Merchant</td>
                  <td>{{$rep->merchant}}</td>
                </tr>
                <tr>
                  <td>Volume</td>
                  <td>{{$rep->volume}}</td>
                </tr>
                <tr>
                  <td>Price</td>
                  <td>{{$rep->price}}</td>
                </tr>
              </table>
            </div>
          </div>
        </div>
        <div class="card card-danger">
          <div class="card-header">
            <h4 class="card-title">
              <a data-toggle="collapse" data-parent="#accordion" href="#collapseTwo" class="collapsed" aria-expanded="false">
                FP Statement transaction @if($rep->fuel_provider=='loves') {{\App\LovesStatement::where('report_id', '=', $rep->id)->sum('net_amount')}} $
                @elseif($rep->fuel_provider=='pilot') ({{$rep->pilotStatement->count()}}) {{$rep->pilotStatement->sum('retail_total')}} $@endif
              </a>
            </h4>
          </div>
          <div id="collapseTwo" class="panel-collapse collapse">
            <div class="card-body">
              @if($rep->fuel_provider=='pilot')

              @if($rep->pilotStatement->count()>0)

              <table class="table table-bordered table-hover">
                <tr>
                  <th>Fuel provider</th>
                  <th>Auth#</th>
                  <th>Ticket#</th>
                  <th>Invoice#</th>
                  <th>Date</th>
                  <th>Location</th>
                  <th>Country</th>
                  <th>Fuel cost</th>
                  <th>Fuel units</th>
                  <th>Invoice total</th>
                  <th>Retail total</th>
                  <th>FP Savings</th>
                  <!-- <th>FP Savings per Q</th> -->
                  <th>Edit</th>
                  <th>Unlink</th>


                </tr>
                @foreach($rep->pilotStatement as $statement)
                <tr>
                  <td>Pilot</td>
                  <td><a href="/pilot-statements/{{$statement->id}}">{{$statement->auth_no}}</a></td>
                  <td>{{$statement->ticket_no}}</td>
                  <td>{{$statement->invoice_no}}</td>
                  <td>{{$statement->billing_date}}</td>
                  <td>{{$statement->location}}</td>
                  <td>{{$statement->country}}</td>
                  <td>{{$statement->fuel_cost}}</td>
                  <td>{{$statement->fuel_units}}</td>
                  <td>{{$statement->invoice_total}}</td>
                  <td>{{$statement->retail_total}}</td>
                  <td>{{$statement->retail_total-$statement->invoice_total}}</td>
                  {{-- <td>{{($statement->retail_total-$statement->invoice_total)/$statement->fuel_units}}</td> --}}
                  <td><a href="/pilot-statements/{{$statement->id}}/edit" class="btn btn-warning"> <i class="fa fa-edit"></i> Edit</a></td>
                  <td><a href="/pilot-statements/{{$statement->id}}/unlink" class="btn btn-danger" onclick="return confirm('Are you sure')"> <i class="fa fa-trash"></i> Unlink</a></td>

                </tr>

                @endforeach
              </table>
              @endif

              @endif

              @if($rep->fuel_provider=='loves')

              @if(!empty($rep->lovesStatement()))

              <table class="table table-bordered table-hover">
                <tr>
                  <th>Fuel provider</th>
                  <th>Auth#</th>
                  <th>Unit#</th>
                  <th>Invoice#</th>
                  <th>Date</th>
                  <th>Location</th>
                  <th>Store</th>
                  <th>Retail total</th>
                  <th>Edit</th>
                  <th>Unlink</th>

                </tr>
                @foreach(\App\LovesStatement::where('report_id', '=', $rep->id)->get() as $statement)
                <tr>
                  <td>Loves</td>
                  <td><a href="/loves-statements/{{$statement->id}}">{{$statement->authorisation_no}}</a></td>
                  <td>{{$statement->unit}}</td>
                  <td>{{$statement->invoice_no}}</td>
                  <td>{{$statement->date}}</td>
                  <td>{{$statement->location}}</td>
                  <td>{{$statement->store}}</td>
                  <td>{{$statement->net_amount}}</td>
                  <td><a href="/loves-statements/{{$statement->id}}/edit" class="btn btn-sm btn-warning"> <i class="fa fa-edit"></i> Edit</a></td>
                  <td><a href="/loves-statements/{{$statement->id}}/unlink" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure?')"><i class="fa fa-trash"></i> Unlink</a></td>

                </tr>
                @endforeach
              </table>
              @endif

              @endif
            </div>
          </div>
        </div>
        @if($rep->direct_billing=='N')
        <div class="card card-success">
          <div class="card-header">
            <h4 class="card-title">
              @if($rep->direct_billing=='N')
              <a data-toggle="collapse" data-parent="#accordion" href="#collapseThree" class="collapsed" aria-expanded="false">
                Indirect billing ({{$rep->indirectBilling->count()}}) Total: {{$rep->indirectBilling->sum('total')}} $
              </a>@endif
            </h4>
          </div>
          <div id="collapseThree" class="panel-collapse collapse">
            <div class="card-body">
              <table class="table table-bordered table-hover">
                <tr>
                  <th>Auth#</th>
                  <th>Unit#</th>
                  <th>Invoice#</th>
                  <th>Date</th>
                  <th>Location</th>
                  <th>State</th>
                  <th>total</th>
                  <th>Edit</th>
                  <th>Unlink</th>

                </tr>
                @foreach($rep->indirectBilling as $statement)
                <tr>
                  <td>{{$statement->auth_code}}</a></td>
                  <td>{{$statement->unit}}</td>
                  <td>{{$statement->invoice}}</td>
                  <td>{{$statement->date}}</td>
                  <td>{{$statement->location}}</td>
                  <td>{{$statement->state}}</td>
                  <td>{{$statement->total}}</td>

                  <td><a href="/loves-statements/{{$statement->id}}/edit-indirect-billing" class="btn btn-sm btn-warning"> <i class="fa fa-edit"></i> Edit</a></td>
                  <td><a href="/loves-statements/{{$statement->id}}/unlink-indirect-billing" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure?')"><i class="fa fa-trash"></i> Unlink</a></td>





                </tr>

                @endforeach
              </table>
            </div>
          </div>
        </div>
        @endif
      </div>
      <!-- /.card -->

      <div class="card card-success">
        <div class="card-header">
          <h4 class="card-title">
            <a data-toggle="collapse" data-parent="#accordion" href="#discount" class="collapsed" aria-expanded="true">
              Discount
            </a>
          </h4>
        </div>

        <div id="discount" class="panel-collapse in collapse" style="">
          <div class="card-body">

            <table class="table table-bordered table-hover table-striped">
              <tr>
                <th>Start date</th>
                <td>{{$rep->currentDiscountProfile()->start_date}}</td>
                <th>End date</th>
                <td>{{$rep->currentDiscountProfile()->end_date}}</td>
              </tr>

              <tr>
                <th>Pilot US discount type</th>
                <td>{{$rep->currentDiscountProfile()->pilot_us_discount_type}}</td>
                <th>Pilot US</th>
                <td>{{$rep->currentDiscountProfile()->pilot_usd}}</td>
              </tr>


              <tr>
                <th>Pilot CAD discount type</th>
                <td>{{$rep->currentDiscountProfile()->pilot_cad_discount_type}}</td>
                <th>Pilot CAD</th>
                <td>{{$rep->currentDiscountProfile()->pilot_cad}}</td>
              </tr>


              <tr>
                <th>Loves discount type</th>
                <td>{{$rep->currentDiscountProfile()->loves_us_discount_type}}</td>
                <th>Loves</th>
                <td>{{$rep->currentDiscountProfile()->loves_usd}}</td>
              </tr>

              <tr>
                <th>Reefer included</th>
                <td>{{$rep->currentDiscountProfile()->reefer_discount}}</td>
                <th>Discount computation</th>
                <td>{{$rep->discount_computation}}</td>
              </tr>

              <tr>
                <th>Discount</th>
                <td>{{$rep->total_discount}}</td>
                <th>TTP2</th>
                <td>{{$rep->ttp2}}</td>
              </tr>

              <tr>
                <th>Truck volume</th>
                <td>{{$rep->volume}}</td>
                <th>Reefer volume</th>
                <td>{{$rep->reefer_volume}}</td>
              </tr>
              <tr>
                <th>Discount computation</th>
                <td>{{$rep->discount_computation}}</td>
                <td><a href="/reports/{{$rep->id}}/recalculate_discount" class="btn btn-success">Recalculate discount</a></td>
              <td></td>
              </tr>
            </table>
          </div>
        </div>
      </div>
    </div>

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



@stop

@section('css')

@stop

@section('js')
<script>
  $(function() {
    $(".datatables").DataTable();
  });
</script>
@stop