@extends('admin.layout.app')

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

@section('main-content')
 <section class="content-header">
  <h1>
   OPERATIONS MANAGEMENT SYSTEM

  </h1>

 </section>

 <section class="content">

  <!-- Default box -->
  <div class="box">
   <div class="box-header with-border">
    <h3 class="box-title">REJECTED WAYBILLS</h3>
    <hr>
    <form class="form-inline">
     <div class="form-group col-sm-offset-5 mb-2">
      <input type="text" name="q" placeholder="Search..." class="form-control" />
     </div>
     <input type="submit" class="btn btn-primary mb-4" name="export" value="Search" />
    </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 table-responsive">
    <table id="example1" class="table-bordered table-striped table-condensed table" style="width:100%">
     <thead>
      <tr>
       <th>No.</th>
       <th>Waybill Date</th>
       <th>Waybill Number</th>
       <th>LBC</th>
       <th>Season</th>
       <th>Station</th>
       <th>District</th>
       <th>Region</th>
       <th>BUSH QTY</th>
       <th>PORT QTY</th>
       <th>REJECT.</th>
       <th>Fulfilled</th>
       <th>CAT</th>
       <th>GRADE</th>
       <th>SHED</th>
       <th>COCOA TYPE</th>
       <th>SPECIALTY</th>
       <th>CLIENT</th>

      </tr>
     </thead>
     <tbody>

      @foreach ($internal_waybills as $internal_waybill)
       @php
        
        $nwbs = App\Model\internal_waybill::where('ref_int_waybill_id', $internal_waybill->id)->get();
       @endphp
       @if ($nwbs->sum('purity_no_of_bags_ok') != $internal_waybill->purity_no_of_bags_ok)
        <tr>
         <td>{{ $count++ }}.</td>
         <td>{{ \Carbon\Carbon::parse($internal_waybill->internal_waybill_date)->format('d M y') }}</td>
         <td>{{ $internal_waybill->internal_waybill_no }}</td>
         <td>{{ strtoupper(optional($internal_waybill->lbc)->name) }}</td>
         <td>{{ strtoupper(optional(App\Model\season::find($internal_waybill->bush_delivery->season_id))->name) }}</td>
         <td>{{ strtoupper(optional(App\Model\station::find($internal_waybill->audited_station_id))->station_name) }}
         </td>
         <td>{{ strtoupper(App\Model\district::find($internal_waybill->district_id)->district_name) }}</td>
         <td>{{ strtoupper(App\Model\district::find($internal_waybill->district_id)->region->name) }}</td>
         <td>{{ $internal_waybill->internal_no_of_bags }}</td>
         <td>{{ $internal_waybill->purity_no_of_bags_ok }}</td>
         <td style="color: red">{{ $internal_waybill->rejections }}</td>
         <td style="color: green">{{ $nwbs->sum('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->shed->name }}</td>
         <td>{{ $internal_waybill->cocoa_type->type_name }}</td>
         <td>{{ $internal_waybill->specialty_type }}</td>
         <td>{{ strtoupper($internal_waybill->client_name) }}</td>

        </tr>
       @endif
      @endforeach

     </tbody>
     <tfoot>
      <tr>
       <th>No.</th>
       <th>Waybill Date</th>
       <th>Waybill Number</th>
       <th>LBC</th>
       <th>Season</th>
       <th>Station</th>
       <th>District</th>
       <th>Region</th>
       <th>BUSH QTY</th>
       <th>PORT QTY</th>
       <th>REJECT.</th>
       <th>Fulfilled</th>
       <th>CAT</th>
       <th>GRADE</th>
       <th>SHED</th>
       <th>COCOA TYPE</th>
       <th>SPECIALTY</th>
       <th>CLIENT</th>

      </tr>
     </tfoot>
    </table>
    Showing {{ $internal_waybills->firstItem() }} to {{ $internal_waybills->lastItem() }}
    of total {{ $internal_waybills->total() }} entries
    {{ $internal_waybills->links() }}
   </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-3.5.1.js') }}"></script>

 <script src="{{ asset('admin/bower_components/datatables.net/js/jquery.dataTables.min.js') }}"></script>

 <script src="{{ asset('admin/bower_components/datatables.net/js/dataTables.buttons.min.js') }}"></script>

 {{-- <script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.flash.min.js"></script> --}}

 <script src="{{ asset('admin/bower_components/datatables.net/js/jszip.min.js') }}"></script>

 <script src="{{ asset('admin/bower_components/datatables.net/js/pdfmake.min.js') }}"></script>

 <script src="{{ asset('admin/bower_components/datatables.net/js/vfs_fonts.js') }}"></script>

 <script src="{{ asset('admin/bower_components/datatables.net/js/buttons.html5.min.js') }}"></script>

 <script src="{{ asset('admin/bower_components/datatables.net/js/buttons.print.js') }}"></script>

 <script>
  $(function() {
   /*$('#example1').DataTable({

       'paging': true,
        'searching'   : true,
        dom: 'Bfrtip',


   })

     $('#example2').DataTable({
       'paging'      : true,
       'lengthChange': false,
       'searching'   : false,
       'ordering'    : true,
       'info'        : true,
       'autoWidth'   : false
     })*/

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


  })
 </script>
@endsection