@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">M & E REPORTS</h3>
    <form class="form-inline">
     <div class="form-group col-sm-offset-3 mb-2">
      <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 col-sm-offset-3 mb-2">
      <a href="{{ URL::route('me.export') }}" class="btn btn-success" id="batt"> Export To Excel </a>
     </div>
    </form>
    <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">
     <div class="">

      {{-- <div class=" showee">
            <img class="col-md-2" style="width: 150px; height: 100px;" src="{{asset('admin/dist/img/cmclogo.png')}}" class="img-circle" alt="User Image">
            <br> --}}

      <br>

     </div>

    </div>

    <table id="example2" class="table-bordered table-striped table">
     <thead>

      <tr>
       <th>No.</th>
       <th>LICENSED BUYER</th>
       <th>TOC</th>
       <th>Sheds</th>
       <th>Bush Delivery bags</th>
       <th>Truck No</th>
       <th>BD created at</th>
       <th>Registration Time</th>
       <th>Check-in</th>
       <th>Transaction code</th>
       <th>Crop Year</th>
       <th>BW bags</th>
       <th>BW No</th>
       <th>Bush Category</th>
       <th>Bush Waybill Grade</th>
       <th>Station</th>
       <th>District</th>
       <th>Region</th>
       <th>First Weight</th>
       <th>First Weight Date</th>
       <th>Second Weight</th>
       <th>Second Weight Date</th>
       <th>BW Date</th>
       <th>QCC EVAC CERT No</th>
       <th>BW created at</th>
       <th>IW No</th>
       <th>IW ID</th>
       <th>Referral IW No</th>
       <th>Referral IW ID</th>
       <th>IW_bags</th>
       <th>IW Date</th>
       <th>IW Created at</th>
       <th>Offloading Date</th>
       <th>Purity Date</th>
       <th>Purity No.</th>
       <th>Short/Excess</th>
       <th>Purity No. Bags</th>
       <th>Purity Cat</th>
       <th>Purity Grade</th>
       <th>ACTUAL COCOA TYPE</th>
       <th>SPECIALTY</th>
       <th>ACTUAL TONNAGE</th>
       <th>CTOR NO.</th>
       <th>CTOR DATE</th>
       <th>CTOR ceated at</th>
       <th>Summary sheet wpo user time</th>
       <th>Summary REF no.</th>
       <th>Summary Sheet created at</th>
       <th>Summary Sheet wpo supervisor time</th>
       {{-- <th>Toc audit secretary time</th> --}}
       <th>Summary sheet audit user time</th>
       <th>Summary sheet audit supervisor time</th>
       <th>Summary sheet audit authorizer time</th>
       <th>Summary sheet audit certifier time</th>
       <th>Audit Status</th>
       <th>Audited bags</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>Claim Ref.</th>
       <th>Claim Date</th>
       <th>Claim created at</th>
       <th>LBC Inv</th>
       <th>Total Bags</th>
       <th>Total Tonnage</th>
       <th>Total Claims</th>
       <th>Prepared_By_Time</th>
       <th>Supervised_By_Time</th>
       <th>Approved_By_time</th>
       <th>Authorized_By_time</th>
       {{-- <th>Accra audit secretary time</th> --}}
       <th>Claims Vetted By time</th>
       <th>Claims validated by time</th>
       <th>Claims certified by time</th>

      </tr>
     </thead>
     <tbody>

      @foreach ($internal_waybills as $internal_waybill)
       <tr>
        <td>{{ $count++ }}.</td>
        <td>{{ $internal_waybill->lbc->name }}</td>
        <td style="font-weight: bold; color: darkcyan;">{{ $internal_waybill->bush_delivery->port->name }}</td>
        <td>{{ optional($internal_waybill->shed)->name }}</td>
        <td>{{ $internal_waybill->bush_delivery->no_bags }}</td>
        <td>{{ $internal_waybill->bush_delivery->truck_no }}</td>
        <td>
         {{ $internal_waybill->bush_delivery->created_at ? Carbon\Carbon::parse($internal_waybill->bush_delivery->created_at)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $internal_waybill->bush_delivery->registration_time ? Carbon\Carbon::parse($internal_waybill->bush_delivery->registration_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $internal_waybill->bush_delivery->checkin ? Carbon\Carbon::parse($internal_waybill->bush_delivery->checkin)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ $internal_waybill->bush_delivery->transaction_code }}</td>
        <td>{{ $internal_waybill->bush_delivery->season->name }}</td>
        <td>{{ $internal_waybill->bush_waybill->bush_no_of_bags }}</td>
        <td>{{ $internal_waybill->bush_waybill->bush_waybill_no }}</td>
        <td>{{ optional($internal_waybill->bush_waybill->category)->name }}</td>
        <td>{{ $internal_waybill->bush_waybill->bush_grade }}</td>
        <td>{{ $internal_waybill->bush_waybill->station->station_name }}</td>
        <td>{{ $internal_waybill->bush_waybill->district->district_name }}</td>
        <td>{{ $internal_waybill->bush_waybill->district->region->name }}</td>
        <td>{{ $internal_waybill->bush_delivery->first_weight }}</td>
        <td>
         {{ $internal_waybill->bush_delivery->first_weight_date ? Carbon\Carbon::parse($internal_waybill->bush_delivery->first_weight_date)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ $internal_waybill->bush_delivery->second_weight }}</td>
        <td>
         {{ $internal_waybill->bush_delivery->second_weight_date ? Carbon\Carbon::parse($internal_waybill->bush_delivery->second_weight_date)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $internal_waybill->bush_waybill->bush_waybill_date ? Carbon\Carbon::parse($internal_waybill->bush_waybill->bush_waybill_date)->format('j M Y') : null }}
        </td>
        <td>{{ $internal_waybill->bush_waybill->qcc_evac_cert_no }}</td>
        <td>
         {{ $internal_waybill->bush_waybill->created_at ? Carbon\Carbon::parse($internal_waybill->bush_waybill->created_at)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ $internal_waybill->internal_waybill_no }}</td>
        <td>{{ $internal_waybill->id }}</td>
        <td>{{ optional(App\Model\internal_waybill::find($internal_waybill->ref_int_waybill_id))->internal_waybill_no }}
        </td>
        <td>{{ $internal_waybill->ref_int_waybill_id }}
        </td>
        <td>{{ $internal_waybill->internal_no_of_bags }}</td>
        <td>
         {{ $internal_waybill->internal_waybill_date ? Carbon\Carbon::parse($internal_waybill->internal_waybill_date)->format('j M Y') : null }}
        </td>
        <td>
         {{ $internal_waybill->created_at ? Carbon\Carbon::parse($internal_waybill->created_at)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $internal_waybill->offloading_date ? Carbon\Carbon::parse($internal_waybill->offloading_date)->format('j M Y') : null }}
        </td>
        <td>
         {{ $internal_waybill->purity_date ? Carbon\Carbon::parse($internal_waybill->purity_date)->format('j M Y') : null }}
        </td>
        <td>{{ $internal_waybill->purity_number }}</td>
        <td>{{ $internal_waybill->excess }}</td>
        <td>{{ $internal_waybill->purity_no_of_bags_ok }}</td>
        <td>{{ optional(App\Model\category::find($internal_waybill->purity_category_id))->name }}</td>
        <td>{{ $internal_waybill->purity_grade }}</td>
        <td>{{ $internal_waybill->cocoa_type->type_name }}</td>
        <td>{{ $internal_waybill->specialty_type }}</td>
        <td>{{ $internal_waybill->actual_tonnage }}</td>
        <td>{{ optional($internal_waybill->ctor)->ctor_number }}</td>
        <td>
         {{ optional($internal_waybill->ctor)->ctor_date ? Carbon\Carbon::parse(optional($internal_waybill->ctor)->ctor_date)->format('j M Y') : null }}
        </td>
        <td>
         {{ optional($internal_waybill->ctor)->created_at ? Carbon\Carbon::parse(optional($internal_waybill->ctor)->created_at)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $internal_waybill->wpo_stats_user_time ? Carbon\Carbon::parse($internal_waybill->wpo_stats_user_time)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ optional($internal_waybill->summary_sheet)->ref_no }}</td>
        <td>
         {{ optional($internal_waybill->summary_sheet)->created_at ? Carbon\Carbon::parse(optional($internal_waybill->summary_sheet)->created_at)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $internal_waybill->wpo_stats_supervisor_time ? Carbon\Carbon::parse($internal_waybill->wpo_stats_supervisor_time)->format('j M Y g:i a') : null }}
        </td>
        {{-- <td>{{$internal_waybill->Toc_audit_secretary_time}}</td> --}}
        <td>
         {{ $internal_waybill->audit_toc_user_time ? Carbon\Carbon::parse($internal_waybill->audit_toc_user_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $internal_waybill->audit_toc_supervisor_time ? Carbon\Carbon::parse($internal_waybill->audit_toc_supervisor_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $internal_waybill->audit_toc_authorizer_time ? Carbon\Carbon::parse($internal_waybill->audit_toc_authorizer_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($internal_waybill->summary_sheet)->toc_audit_certifier_time ? Carbon\Carbon::parse($internal_waybill->summary_sheet['toc_audit_certifier_time'])->format('j M Y g:i a') : null }}
        </td>
        <td>{{ optional($internal_waybill->summary_sheet)->audit_status }}</td>
        <td>{{ $internal_waybill->audited_no_bags }}</td>
        <td>{{ $internal_waybill->audited_weight_per_bag }}</td>
        <td>{{ $internal_waybill->audited_actual_tonnage }}</td>
        <td>{{ $internal_waybill->audited_purity_number }}</td>
        <td>
         {{ $internal_waybill->audited_purity_date ? Carbon\Carbon::parse($internal_waybill->audited_purity_date)->format('j M Y') : null }}
        </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>{{ optional($internal_waybill->claim)->claim_ref }}</td>
        <td>
         {{ optional($internal_waybill->claim)->claim_date ? Carbon\Carbon::parse(optional($internal_waybill->claim)->claim_date)->format('j M Y') : null }}
        </td>
        <td>
         {{ optional($internal_waybill->claim)->created_at ? Carbon\Carbon::parse(optional($internal_waybill->claim)->created_at)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ optional($internal_waybill->claim)->lbc_invoice }}</td>
        <td>{{ optional($internal_waybill->claim)->total_bags }}</td>
        <td>{{ optional($internal_waybill->claim)->total_tonnage }}</td>
        <td>{{ optional($internal_waybill->claim)->total_claim }}</td>
        <td>
         {{ optional($internal_waybill->claim)->prepared_by_time ? Carbon\Carbon::parse(optional($internal_waybill->claim)->prepared_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($internal_waybill->claim)->supervised_by_time ? Carbon\Carbon::parse(optional($internal_waybill->claim)->supervised_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($internal_waybill->claim)->approved_by_time ? Carbon\Carbon::parse(optional($internal_waybill->claim)->approved_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($internal_waybill->claim)->authorized_by_time ? Carbon\Carbon::parse(optional($internal_waybill->claim)->authorized_by_time)->format('j M Y g:i a') : null }}
        </td>
        {{-- <td>{{$internal_waybill->Accra_audit_secretary_time}}</td> --}}
        <td>
         {{ optional($internal_waybill->claim)->vetted_by_time ? Carbon\Carbon::parse(optional($internal_waybill->claim)->vetted_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($internal_waybill->claim)->validated_by_time ? Carbon\Carbon::parse(optional($internal_waybill->claim)->validated_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($internal_waybill->claim)->certified_by_time ? Carbon\Carbon::parse(optional($internal_waybill->claim)->certified_by_time)->format('j M Y g:i a') : null }}
        </td>
       </tr>
      @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>
  $('#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').html("Export To Excel");
  //  },200000);
  // });


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

   });


  })
 </script>
@endsection