@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>
   OPERATIONS MANAGEMENT SYSTEM
  </h1>

 </section>

 <section class="content">

  <div class="box">
   <div class="box-header with-border hiide">
    <h3 class="box-title">SHIPMENT REPORT</h3>

    <div class="mx-bg-3 col-sm-offset-3 mb-2">
     <a href="{{ URL::route('wpo.release.export') }}" class="btn btn-success" id="batt"> Export To Excel </a>
    </div>
    <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="example2" class="table-bordered table-striped table">
     <thead>

      <tr>
       <th>No.</th>
       <th>BUYER</th>
       <th>SD NO.</th>
       <th>MK NO.</th>
       <th>CONTRACT NO.</th>
       <th>WAYBILL NO.</th>
       <th>WAYBILL DATE</th>
       <th>VESSEL</th>
       <th>COCOA TYPE</th>
       <th>SPECIALTY</th>
       <th>QUANTITY LOADED <br>(BAGS)</th>
       <th>QUANTITY LOADED <br>(EXPECTED TONNAGE)</th>
       <th>QUANTITY LOADED <br>(ACTUAL TONNAGE)</th>
       <th>CROP YEAR REQUESTED</th>
       <th>CROP YEAR UTILIZED</th>
       <th>CATEGORY</th>
       <th>TOC</th>
       <th>SHED ASSIGNED</th>
       <th>SEASON</th>
       {{-- <th>STACK NO</th> --}}
      </tr>
     </thead>
     <tbody>

      @foreach ($shed_waybills as $shed_waybill)
       <tr>
        <td>{{ $count++ }}.</td>
        <td>{{ strtoupper($shed_waybill->consignee->name) }}</td>
        @if (!empty($shed_waybill->wpo_evacuation->fac->allocation_letter->revise_ref_id))
         <td>
          (SD/{{ substr(optional(App\Model\allocation_letter::find($shed_waybill->wpo_evacuation->fac->allocation_letter->revise_ref_id))->ref_number, 21) }})
         </td>
        @elseif (!empty($shed_waybill->wpo_evacuation->fac->allocation_letter->cancel_ref_id))
         <td>
          (SD/{{ substr(optional(App\Model\allocation_letter::find($shed_waybill->wpo_evacuation->fac->allocation_letter->cancel_ref_id))->ref_number, 21) }})
         </td>
        @else
         <td>
          (SD/{{ substr($shed_waybill->wpo_evacuation?->fac->allocation_letter?->ref_number, 21) }})
         </td>
        @endif
        <td>
         {{ $shed_waybill->wpo_evacuation?->sales_advice->mk_number }}
        </td>
        <td>
         {{ strtoupper($shed_waybill->contract->number) }}
        </td>
        <td>
         {{ $shed_waybill->waybill_no }}
        </td>
        <td>
         {{ $shed_waybill->waybill_date }}
        </td>
        <td>
         {{ strtoupper($shed_waybill->wpo_evacuation?->fac->vessel->name) }}
        </td>
        <td>
         {{ strtoupper(optional($shed_waybill->wpo_evacuation?->contract->shipping_instruction->cocoa_type)->type_name) }}
        </td>
        <td>
         {{ $shed_waybill->wpo_evacuation?->contract->shipping_instruction->specialty_type ? strtoupper($shed_waybill->wpo_evacuation?->contract->shipping_instruction->specialty_type) : 'N/A' }}
        </td>
        <td>{{ $shed_waybill->quantity }}</td>
        <td>{{ $shed_waybill->quantity / 16 }}</td>
        <td>{{ $shed_waybill->net_weight ?? $shed_waybill->quantity / 16 }}</td>
        <td>{{ $shed_waybill->wpo_evacuation?->category?->season->name }}</td>
        <td>{{ $shed_waybill->category->season->name }}</td>
        <td>{{ $shed_waybill->category->name }}</td>
        <td>{{ $shed_waybill->port->name }}</td>
        <td>{{ $shed_waybill->shed->name }}</td>
        <td>{{ $shed_waybill->season->name }}</td>
       </tr>
      @endforeach

     </tbody>
    </table>
    Showing {{ $shed_waybills->firstItem() }} to {{ $shed_waybills->lastItem() }}
    of total {{ $shed_waybills->total() }} entries
    {!! $shed_waybills->render() !!}
   </div>
  </div>

 </section>
@endsection

@section('more-scripts')
 <script src="{{ asset('admin/bower_components/datatables.net/js/jquery-3.5.1.js') }}"></script>
 <script src="{{ asset('admin/bower_components/datatables.net/js/jquery.dataTables.min.js') }}"></script>
 <script>
  $('#batt').click(function() {
   var button = $(this);
   button.attr('disabled', 'disabled');
  });
  //  $('#batt').click(function(){
  //   var button = $(this);
  //   button.html("Downloading...").attr('disabled', 'disabled');
  //   setTimeout(function() {
  //    button.removeAttr('disabled');
  //  },200000);
  // });

  $(function() {
   $('.showee').hide();
   $('#example1').DataTable()
   $('#example2').DataTable({
    'paging': false,
    'lengthChange': false,
    'searching': false,
    'ordering': true,
    'info': false,
    'autoWidth': false

   });


  })
 </script>
@endsection