@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">CLAIMS REPORT</h3>

      {{--   <div class="form-group mb-2 col-sm-offset-3">
          <input type="text" name="q" placeholder="Search..."  class="form-control"/>
      </div>
      <input type="submit" class="btn btn-primary mb-4" value="Search"/> --}}
      <div class="form-group mx-bg-3 mb-2 col-sm-offset-5">
        <form role="form" method="post" action="{{ route('account.export') }}" enctype="multipart/form-data" id="myFormId">
          {{csrf_field()}}
          <input type="hidden" name="dfrom" value="{{$request->dfrom}}">
          <input type="hidden" name="dto" value="{{$request->dto}}">
          <input type="hidden" name="season_id" value="{{$request->season_id}}">
          <button type="submit" class="btn btn-primary" id="batt"> Export To Excel </button>
          
        </form>
      </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">



      <div class="col-md-12 table-responsive">
        <table id="example2" class="table table-bordered table-striped">
          <thead>

            <tr>
              <th>No.</th>
              <th>Type</th>
              <th>Bush Delivery Bags</th>
              <th>Registration Time</th>
              <th>Truck No.</th>
              <th>Transaction_Code</th>
              <th>First Weight</th>
              <th>Second Weight</th>
              <th>BW Bags</th>
              <th>BW No</th>
              <th>BW Date</th>
              <th>BW Grade</th>
              <th>Seal No</th>
              <th>QCC EVAC DATE</th>
              <th>QCC EVAC CERT No</th>
              <th>BUSH CATEGORY</th>
              <th>Bush Client Name</th>
              <th>Bush Speciality Type</th>
              <th>IW No</th>
              <th>IW bags</th>
              <th>IW Date</th>
              <th>IW CATEGORY</th>
              <th>IW COCOA TYPE</th>
              <th>SHED NAME</th>
              <th>Purity Date</th>
              <th>Purity No</th>
              <th>Purity Grade</th>
              <th>Purity Cat</th>
              <th>Purity bags</th>
              <th>Warehouse</th>
              <th>Leftover</th>
              <th>Excess</th>
              <th>Rejections</th>
              <th>Type</th>
              <th>NAKED BEANS TONNAGE</th>
              <th>Region</th>
              <th>DISTRICT NAME</th>
              <th>STATION NAME</th>
              <th>Offloading Date</th>
              <th>Audited Station</th>
              <th>Audited bags</th>
              <th>Audited Grade</th>
              <th>Audited Net Weight</th>
              <th>Audited Weight Per Bag</th>
              <th>Audited Actual Tonnage</th>
              <th>Audited Purity No</th>
              <th>Audited Purity Date</th>
              <th>Audited Evacuation Rate</th>
              <th>Audited Producer Price</th>
              <th>Audited Buyers Margin</th>
              <th>Audited Evacuation Cost</th>
              <th>IW Client Name</th>
              <th>IW Speciality Type</th>
              <th>IW Grade</th>
              <th>CTOR No</th>
              <th>CTOR Date</th>
              <th>REF No</th>
              <th>Claim REF</th>
              <th>Claim Date</th>
              <th>Bank</th>
              <th>LBC Inv</th>
              <th>Total Bags</th>
              <th>Total Claims</th>
              <th>TOC</th>
              <th>LICENSED BUYER</th>
              <th>Crop Season</th>



            </tr>
          </thead>
          <tbody>

           @foreach ($internal_waybills as $internal_waybill)

           <tr>
             <td>{{$count++}}.</td>
             <td>{{$internal_waybill->bush_delivery->type}}</td>
             <td style="font-weight: bold; color: darkcyan;">{{$internal_waybill->bush_delivery->no_bags}}</td>
             <td>{{Carbon\Carbon::parse($internal_waybill->bush_delivery->registration_time)->format('j M Y g:i a')}}</td>
             <td>{{$internal_waybill->bush_delivery->truck_no}}</td>
             <td>{{$internal_waybill->bush_delivery->transaction_code}}</td>
             <td>{{$internal_waybill->bush_delivery->first_weight}}</td>
             <td>{{$internal_waybill->bush_delivery->second_weight}}</td>
             <td>{{$internal_waybill->bush_waybill->bush_no_of_bags}}</td>
             <td>{{$internal_waybill->bush_waybill->bush_waybill_no}}</td>
             <td>{{Carbon\Carbon::parse($internal_waybill->bush_waybill->bush_waybill_date)->format('j M Y')}}</td>
             <td>{{$internal_waybill->bush_waybill->bush_grade}}</td>
             <td>{{$internal_waybill->bush_waybill->seal_no}}</td>
             <td>{{Carbon\Carbon::parse($internal_waybill->bush_waybill->qcc_evac_date)->format('j M Y')}}</td>
             <td>{{$internal_waybill->bush_waybill->qcc_evac_cert_no}}</td>
             <td>{{$internal_waybill->bush_waybill->category->name}}</td>
             <td>{{$internal_waybill->bush_waybill->client_name}}</td>
             <td>{{$internal_waybill->bush_waybill->specialty_type}}</td>
             <td>{{$internal_waybill->internal_waybill_no}}</td>
             <td>{{$internal_waybill->internal_no_of_bags}}</td>
             <td>{{Carbon\Carbon::parse($internal_waybill->internal_waybill_date)->format('j M Y')}}</td>
             <td>{{$internal_waybill->category->name}}</td>
             <td>{{$internal_waybill->cocoa_type->type_name}}</td>
             <td>{{$internal_waybill->shed->name}}</td>
             <td>{{Carbon\Carbon::parse($internal_waybill->purity_date)->format('j M Y')}}</td>
             <td>{{$internal_waybill->purity_number}}</td>
             <td>{{$internal_waybill->purity_grade}}</td>
             <td>{{APP\Model\category::find($internal_waybill->purity_category_id)->name}}</td>
             <td>{{$internal_waybill->purity_no_of_bags_ok}}</td>
             <td>{{optional($internal_waybill->warehouse)->name}}</td>
             <td>{{$internal_waybill->left_over}}</td>
             <td>{{$internal_waybill->excess}}</td>
             <td>{{$internal_waybill->rejections}}</td>
             <td>{{$internal_waybill->type}}</td>
             <td>{{$internal_waybill->naked_tonnage_ok}}</td>
             <td>{{optional($internal_waybill->bush_waybill->district->region)->name}}</td>
             <td>{{optional($internal_waybill->bush_waybill->district)->district_name}}</td>
             <td>{{optional($internal_waybill->bush_waybill->station)->station_name}}</td>
             <td>{{Carbon\Carbon::parse($internal_waybill->offloading_date)->format('j M Y')}}</td>
             <td>{{App\Model\station::find($internal_waybill->audited_station_id)->station_name}}</td>
             <td>{{$internal_waybill->audited_no_bags}}</td>
             <td>{{$internal_waybill->audited_grade}}</td>
             <td>{{$internal_waybill->audited_net_weight}}</td>
             <td>{{$internal_waybill->audited_weight_per_bag}}</td>
             <td>{{$internal_waybill->audited_actual_tonnage}}</td>
             <td>{{$internal_waybill->audited_purity_number}}</td>
             <td>{{Carbon\Carbon::parse($internal_waybill->audited_purity_date)->format('j M Y')}}</td>
             <td>{{$internal_waybill->audited_evacuation_rate}}</td>
             <td>{{$internal_waybill->audited_producer_price}}</td>
             <td>{{$internal_waybill->audited_buyers_margin}}</td>
             <td>{{$internal_waybill->audited_evacuation_cost}}</td>
             <td>{{$internal_waybill->client_name}}</td>
             <td>{{$internal_waybill->specialty_type}}</td>
             <td>{{$internal_waybill->internal_waybill_grade}}</td>
             <td>{{optional($internal_waybill->ctor)->ctor_number}}</td>
             <td>{{Carbon\Carbon::parse(optional($internal_waybill->ctor)->ctor_date)->format('j M Y')}}</td>
             <td>{{$internal_waybill->summary_sheet->ref_no}}</td>
             <td>{{$internal_waybill->claim->claim_ref}}</td>
             <td>{{Carbon\Carbon::parse($internal_waybill->claim->claim_date)->format('j M Y')}}</td>
             <td>{{$internal_waybill->claim->bank->name}}</td>
             <td>{{$internal_waybill->claim->lbc_invoice}}</td>
             <td>{{$internal_waybill->claim->total_bags}}</td>
             <td>{{$internal_waybill->claim->total_claim}}</td>
             <td>{{$internal_waybill->bush_delivery->port->name}}</td>
             <td>{{optional($internal_waybill->claim->lbc)->name}}</td>
             <td>{{optional($internal_waybill->claim->season)->name}}</td>

             @endforeach

           </tbody>
         </table>
         {!! $internal_waybills->render() !!}
       </div>

       <div class="col-md-12">


       </div>


     </div>

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

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

 </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>
   $('#myFormId').submit(function(){
    $("#batt", this)
    .html("Downloading...")
    .attr('disabled', 'disabled');
    return true;
  });

   $(function () {
     $('.showee').hide();
     $('#example1').DataTable()
     $('#example2').DataTable( {
      'searching'   : false,
      'paging'      : false,
      'ordering'    : true,
      "scrollX"     : true,
      "pageLength"  : 30,

    } );

   })
 </script>
 @endsection