@extends('admin.layout.app')

@section('more-head')
 <link rel="stylesheet" href="{{ asset('admin/bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css') }}">
@endsection

@section('main-content')
 <section class="content-header">
  <h1>
   WPO EVACUATION
  </h1>

 </section>

 <section class="content">

  <!-- Default box -->
  <div class="box">
   <div class="box-header with-border">
    @if ($type == 'shipment')
     <h3 class="box-title">SHIPMENT</h3>
    @else
     <h3 class="box-title">FACTORY</h3>
    @endif

    @can('operation.accra_mkt', Auth::user())
     <!--  <div class="col-lg-offset-5"><a href="{{ route('wpo_evacuation.create') }}" class="btn btn-success">Add Evacuation</a></div> -->
    @endcan

    <div class="box-tools pull-right">
     <button type="button" class="btn btn-box-tool" data-widget="collapse" data-toggle="tooltip" title="Collapse">
      <i class="fa fa-minus"></i></button>

    </div>
   </div>

   <div class="box-body table-responsive">
    <table id="example1" class="table-bordered table-striped table">
     <thead>
      <tr>
       <th>No.</th>
       <th>MK Number</th>
       <th>Contract Number </th>
       @if ($type == 'shipment')
        <th>SD No.</th>
       @endcan
       <th>Consignee</th>
       <th>Marketing Reference</th>
       <th>Tonnaged to be Evacuated</th>
       <th>Tonnage Evacuated</th>
       @if ($type == 'local')
        <th>Actual Tonnage Evacuated</th>
       @endif
       <th>Letter Date</th>
       <th>Shipment Period</th>
       <th>Port</th>
       {{-- <th>Type</th> --}}
       <th>Shed Allocations</th>
     </tr>
    </thead>
    <tbody>

     @foreach ($wpo_evacuations as $wpo_evacuation)
      <tr>
       <td>{{ $loop->index + 1 }}</td>
       <td>{{ $wpo_evacuation->mk_number }}</td>
       <td>{{ $wpo_evacuation->contract_number }} </td>
       @if ($type == 'shipment')
        @if ($wpo_evacuation->fac->allocation_letter->revise_ref_id != null)
         <td>
          (SD/{{ substr(optional(App\Model\allocation_letter::find($wpo_evacuation->fac->allocation_letter->revise_ref_id))->ref_number, 21) }})
         </td>
        @elseif ($wpo_evacuation->fac->allocation_letter->cancel_ref_id != null)
         <td>
          (SD/{{ substr(optional(App\Model\allocation_letter::find($wpo_evacuation->fac->allocation_letter->cancel_ref_id))->ref_number, 21) }})
         </td>
        @else
         <td> (SD/{{ substr(optional(optional($wpo_evacuation->fac)->allocation_letter)->ref_number, 21) }})</td>
        @endif
       @endif
       <td>{{ $wpo_evacuation->consignee->name }}</td>
       <td>{{ $wpo_evacuation->contract->shipping_instruction?->consignee_reference }}</td>
       <td>{{ $wpo_evacuation->tonnage_to_be_evacuated }}</td>
       <td style="color: brown; font-weight: bold">
        {{ number_format($wpo_evacuation->shed_waybills()->sum('quantity') / 16, 4) }}</td>
       @if ($type == 'local')
        <td style="color: green; font-weight: bold">
         {{ number_format($wpo_evacuation->shed_waybills()->where('contract_id', $wpo_evacuation->contract_id)->get()->sum('net_weight'),4) }}
        </td>
       @endif
       @if ($wpo_evacuation->letter_date != null)
        <td>{{ $wpo_evacuation->letter_date }}</td>
       @else
        <td>{{ optional($wpo_evacuation->wpo_allocation_letters->last())->date }}</td>
       @endif
       <td>{{ $wpo_evacuation->shipping_period }}</td>
       <td>{{ $wpo_evacuation->port->name }}</td>
       {{-- @if ($wpo_evacuation->type == 'shipment')
        <td style="color:darkblue; font-weight:bold;">{{ strtoupper($wpo_evacuation->type) }}</td>
       @else
        <td style="color:darkred; font-weight:bold;">FACTORY</td>
       @endif --}}
       <td>
        <table class="table">

         @foreach ($wpo_evacuation->shed_evacs->unique('date_assigned') as $shed_evac)
          <tr>
           <td>{{ $loop->index + 1 }}.</td>
           <td><b>Shed:</b> <br> {{ $shed_evac->shed->name }}</td>
           <td><b>Date of allocation:</b> <br> {{ $shed_evac->date_assigned }}</td>
           <td><b>Allocated Tonnage:</b> <br> {{ $shed_evac->tonnage_assigned }}</td>
           <td><b>Tonnage Fulfilled:</b> <br> {{ number_format($shed_evac->shed_waybills->sum('quantity') / 16, 4) }}
           </td>
           @if ($type == 'local')
            <td><b>Actual Tonnage Fulfilled:</b> <br>
             {{ number_format($shed_evac->shed_waybills->sum('net_weight'), 4) }}
            </td>
           @endif
          </tr>
         @endforeach

        </table>

       </td>

      </tr>
     @endforeach

    </tbody>
    <tfoot>
     <tr>
      <th>No.</th>
      <th>MK Number</th>
      @if ($type == 'shipment')
       <th>SD No.</th>
      @endcan
      <th>Consignee</th>
      <th>Marketing Reference</th>
      <th>Tonnaged to be Evacuated</th>
      <th>Tonnage Evacuated</th>
      @if ($type == 'local')
       <th>Actual Tonnage Evacuated</th>
      @endif
      <th>Letter Date</th>
      <th>Shipment Period</th>
      <th>Port</th>
      <th>Contract Number </th>
      <th>Type</th>
      <th>Shed Allocations</th>
    </tr>
   </tfoot>
  </table>

 </div>

 <!-- /.box-body -->
 <div class="box-footer">

 </div>

</div>
<!-- /.box -->

</section>

@endsection

@section('more-scripts')
<script src="{{ asset('admin/bower_components/datatables.net/js/jquery.dataTables.min.js') }}"></script>
<script src="{{ asset('admin/bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js') }}"></script>
<script>
 $(function() {
  $('#example1').DataTable()
  $('#example2').DataTable({
   'paging': true,
   'lengthChange': false,
   'searching': false,
   'ordering': true,
   'info': true,
   'autoWidth': false
  })
 })
</script>
@endsection