@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">OFFLOADINGS SUMMARY</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>{{App\Model\port::find($uport_id)->name}}</th>
         <th>N0. OF SUMMARIES </th>
         <th>TOTAL TONNAGE OF SUMMARIES</th>
         <th>No. OF BAGS</th>
         <th>NO. OF AUDITED SUMMARIES</th>
         <th>TOTAL AUDITED TONNAGE OF SUMMARIES </th>
         <th>AUDITED NO. OF BAGS</th>
         <th>SEASON</th>
       </tr>

     </thead>
     <tbody>
       @foreach ($summary_sheets as $lbc_id => $sheets)
       @foreach ($lbcs as $lbc)
       @foreach ($seasons as $season)

       @if ($lbc->id == $lbc_id )
       <tr>
        <td>{{$lbc->name}}</td>
        <td>{{$sheets->where('lbc_id',$lbc->id)->where('season_id',$season->id)->count()}}</td>
        <td>{{number_format(App\Model\internal_waybill::where('lbc_id',$lbc->id)->where('port_id',$uport_id)->where('season_id',$season->id)->whereNotNull('summary_sheet_id')->where('summary_sheet_status',3)->sum('actual_tonnage'),4)}}</td>
        <td>{{number_format(App\Model\internal_waybill::where('lbc_id',$lbc->id)->where('port_id',$uport_id)->where('season_id',$season->id)->whereNotNull('summary_sheet_id')->where('summary_sheet_status',3)->sum('purity_no_of_bags_ok'))}}</td>
        <td>{{$sheets->whereNotNull('toc_audit_toc_certifier_id')->where('lbc_id',$lbc->id)->where('season_id',$season->id)->count()}}</td>
        <td>{{number_format(App\Model\internal_waybill::where('lbc_id',$lbc->id)->whereNotNull('audit_toc_authorizer_id')->where('port_id', $uport_id)->where('season_id', $season->id)->whereNotNull('summary_sheet_id')->where('summary_sheet_status',3)->sum('audited_actual_tonnage'),4)}}</td>
        <td>{{number_format(App\Model\internal_waybill::where('lbc_id',$lbc->id)->whereNotNull('audit_toc_authorizer_id')->where('port_id', $uport_id)->where('season_id', $season->id)->whereNotNull('summary_sheet_id')->where('summary_sheet_status',3)->sum('audited_no_bags'))}}</td>
        <td>{{$season->name}}</td>
      </tr>

      @endif
      @endforeach

      @endforeach

      @endforeach
      @foreach ($seasons as $season)

      <tr>
        <td></td>
        <th style="color: red;">TOTAL FOR ({{$season->name}})</th>
        <th>{{number_format(App\Model\internal_waybill::where('port_id',$uport_id)->where('season_id',$season->id)->whereNotNull('summary_sheet_id')->where('summary_sheet_status',3)->sum('actual_tonnage'),4)}}</th>
        <th>{{number_format(App\Model\internal_waybill::where('port_id',$uport_id)->where('season_id',$season->id)->where('summary_sheet_status',3)->sum('purity_no_of_bags_ok'))}}</th>
        <th></th>
        <th>{{number_format(App\Model\internal_waybill::whereNotNull('audit_toc_authorizer_id')->where('port_id', $uport_id)->where('season_id', $season->id)->whereNotNull('summary_sheet_id')->where('summary_sheet_status',3)->sum('audited_actual_tonnage'),4)}}</th>
        <th>{{number_format(App\Model\internal_waybill::whereNotNull('audit_toc_authorizer_id')->where('port_id', $uport_id)->where('season_id', $season->id)->whereNotNull('summary_sheet_id')->where('summary_sheet_status',3)->sum('audited_no_bags'))}}</th>
        <th></th>
      </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 () {
    /*$('#example1').DataTable({

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

  })

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

    $('#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'    : false,
      "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