@extends('admin.layout.app')

@section('more-head')
  <link rel="stylesheet" href="{{asset('admin/bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css')}}">
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.5.2/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">STATS</h3>
           
			<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="table-responsive">
         <table class="table table-bordered" id="example4">
          <thead>
            <tr>
                 <th>No.</th>
                 <th>LBC</th>
                 <th>TOC </th>
                 <th>WAYBILL NO.</th>
                 <th>No. OF BAGS</th>
                 <th>WAYBILL DATE</th>
                 <th>SEASON</th>
                 <th>TRANS. CODE</th>
                 <th>GRADE</th>
                 <th>CAT</th>
                 <th>STATION</th>
                 <th>BUSH WAYBILL</th>
                 <th>TIME CREATED</th>
                 <th>SHED</th>
                 <th>WORK PROGRAM</th>
                 <th>COCOA TYPE</th>
                 <th>SPECIALTY</th>
                 <th>CLIENT</th>
                 <th>PURITY DATE</th>
                 <th>PORT QTY.</th>
                 <th>REJECT.</th>
                 <th>PURITY CAT</th>
                 <th>PURITY GRADE</th>
                 <th>ACTUAL TONNAGE</th>
                 <th>AV. WEIGHT PER BAG</th>
                 <th>OFFLOADING DATE</th>
                 <th>CTOR NUMBER</th>
                 <th>CTOR DATE</th>
                 <th>SUMMARY SHEET REF.</th>
                 <th>SUMMARY SHEET DATE</th>
            </tr>
            
          </thead>
          <tbody>
             @foreach ($internal_waybills as $internal_waybill)
                
                 <tr>
                      <td>{{$loop->index + 1}}.</td>
                      <td>{{$internal_waybill->lbc->name}}</td>
                      <td>{{optional(App\Model\port::find($internal_waybill->bush_delivery['port_id']))->name}} </td>
                      <td>{{$internal_waybill->internal_waybill_no}}</td>
                      <td>{{$internal_waybill->internal_no_of_bags}}</td>
                      <td>{{$internal_waybill->internal_waybill_date}}</td>
                      <td>{{optional(App\Model\season::find($internal_waybill->bush_delivery['season_id']))->name}}</td>
                      <td>{{$internal_waybill->bush_delivery['transaction_code']}}</td>
                      <td>{{$internal_waybill->internal_waybill_grade}}</td>
                      <td>{{optional(App\Model\category::find($internal_waybill->category_id))->name}}</td>
                      <td>{{optional(App\Model\station::find($internal_waybill->station_id))->station_name}}</td>
                      <td>{{$internal_waybill->bush_waybill['bush_waybill_no']}}</td>
                      <td>{{$internal_waybill->created_at}}</td>
                      <td>{{$internal_waybill->shed['name']}}</td>
                      <td>{{$internal_waybill->work_program['program_date']}}</td>

                      <td>{{$internal_waybill->cocoa_type['type_name']}}</td>
                      <td>{{$internal_waybill->specialty_type}}</td>
                      <td>{{$internal_waybill->client_name}}</td>

                      <td>{{$internal_waybill->purity_date}}</td>
                      <td>{{$internal_waybill->purity_no_of_bags_ok}}</td>
                      <td>{{$internal_waybill->rejections}}</td>
                      <td>{{optional(App\Model\category::find($internal_waybill->purity_category_id))->name}}</td>
                      <td>{{$internal_waybill->purity_grade}}</td>
                      <td>{{$internal_waybill->actual_tonnage}}</td>
                      <td>{{$internal_waybill->bag_average}}</td>
                      <td>{{$internal_waybill->offloading_date}}</td>
                      <td>{{$internal_waybill->ctor['ctor_number']}}</td>
                      <td>{{$internal_waybill->ctor['ctor_date']}}</td>
                      <td>{{$internal_waybill->summary_sheet['ref_no']}}</td>
                      <td>{{$internal_waybill->summary_sheet['wpo_stats_user_time']}}</td>
                      
                 </tr>
                    
                 
             @endforeach
          </tbody>
       </table>
     </div>
       <hr> <hr>
      
       </div>
     </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 src="https://code.jquery.com/jquery-3.3.1.js">
   
 </script>

 <script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js">
   
 </script>

 <script src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js">
   
 </script>

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

 <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js">
   
 </script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js">
   
 </script>

 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js">
   
 </script>

 <script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js">
   
 </script>

<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js">
   
 </script>

    <script>
  $(function () {
    
    $('#example4').DataTable( {
        'searching'   : true,
        'paging'      : true,
        'ordering'    : true,
        "pageLength": 50,
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    } );


  })
</script>

@endsection