@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   &nbsp;  &nbsp;  &nbsp;  &nbsp;  &nbsp; <span style="color:red; font-weight:bolder; font-size: medium;">SEASON :({{App\Model\season::find($_SESSION['season'])->name}}) </span> </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="example2">
        <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>
         </tr>

       </thead>
       <tbody>

        @foreach ($results as $result)

        <tr>

          <td>{{$result->LBC}}</td>
          <td>{{$result->N0_OF_SUMMARIES}}</td>
          <td>{{$result->TOTAL_TONNAGE_OF_SUMMARIES}}</td>
          <td>{{$result->No_OF_BAGS}}</td>
          <td>{{$result->NO_OF_AUDITED_SUMMARIES}}</td>
          <td>{{$result->TOTAL_AUDITED_TONNAGE_OF_SUMMARIES}}</td>
          <td>{{$result->AUDITED_NO_OF_BAGS}}</td>
        </tr>
        @endforeach
      </tbody>
    </table>
  </div>
  <hr> <hr>

</div>

<!-- /.box-body -->
<div class="box-footer">

</div>


</div>
<!-- /.box -->

</section>

@endsection

@section('more-scripts')
<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()
    $('#example2').DataTable( {
      'searching'   : true,
      'paging'      : true,
      'ordering'    : false,
      'autoWidth'   : true,
      "pageLength": 50,
      "columnDefs": [
        {"className": "dt-left", "targets": "_all"}
        ],
      dom: 'Bfrtip',
      buttons: [
      {
        extend: 'excelHtml5',
        title: 'STATS Report',
        customize: function( xlsx ) {
          var sheet = xlsx.xl.worksheets['sheet1.xml'];

          $('row c', sheet).attr( 's', '50' );
        }
      },
      {
        extend: 'pdfHtml5',
        title: 'STATS Report'
      },
      'print'
      ]
    } );

  })
</script>

@endsection