@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" type="text/css" href="{{asset('admin/bower_components/select2/dist/css/select2.min.css')}}">
  <link rel="stylesheet" href="{{asset('admin/dist/css/AdminLTE.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">COCOA DELIVERIES BY LBC - CATEGORY BASIS <br>{{strtoupper(App\Model\port::find($user_port_id)->name)}} TOC</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="box-body table-responsive">
        <div class="col-md-offset-1 col-md-6">
               <form method="post" action="{{ route('lbc_deliveries.dates') }}" class="form-horizontal">
                {{csrf_field()}} {{method_field('POST')}}
                <div class="form-group">
                  <label for="dfrom">Purity Date From:</label>
                  <input type="date" class="form-control" name="dfrom" required>
                </div>
                <div class="form-group">
                  <label for="dto">Purity Date To:</label>
                  <input type="date" class="form-control" name="dto" required>
                </div>
                <div class="form-group">
                  <label for="season_id">Select Season:</label> <br>
                  <select name="season_id" class="select2 form-control" style="width:100%;" required>
                    <option value="" selected disabled>Select Season</option>
                    @foreach ($seasons as $season)
                    <option value="{{$season->id}}">{{$season->name}}</option>
                    @endforeach
                  </select>
                  <br> <br>
                </div>

                <div class="form-group">
                  <button type="submit" class="btn btn-success">Submit</button>
                </div>
              </form>
                  
                 </div>

                 <div class="col-md-12">
                   <hr>
                      <table class="table table-bordered" id="example2">
                        <thead>
                         <tr>
                          <th>LBC</th>
                          @foreach ($categorys as $category)
                          <th>{{$category->name}}</th>
                          @endforeach
                          <th>TOTAL</th>  
                        </tr>
                      </thead>
                      <tbody>
                        @foreach ($lbcs as $lbc)
                        <tr>
                          <td>{{$lbc->name}}</td>
                          @foreach ($categorys as $category)
                          <!-- <th>{{--$internal_waybills->where('season_id',3)->where('purity_category_id',$category->id)->where('lbc_id',$lbc->id)->sum('purity_no_of_bags_ok')--}}</th> -->
                          <td>
                           {{App\Model\category::find($category->id)->internal_waybills()->where('port_id', $user_port_id)->where('purity_category_id',$category->id)->where('lbc_id',$lbc->id)->sum('purity_no_of_bags_ok')/16}}
                         </td>
                         @endforeach
                         <th>
                          {{App\Model\internal_waybill::where('lbc_id',$lbc->id)->where('port_id', $user_port_id)->sum('purity_no_of_bags_ok')/16}}
                        </th>

                      </tr>
                      @endforeach  


                    </tbody>






                  </table>

            </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 src="{{asset('admin/bower_components/select2/dist/js/select2.full.min.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
    })*/
    $('.select2').select2();

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

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

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

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


  })
</script>

@endsection