@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">

  <div class="box">
   <div class="box-header with-border">
    <h3 class="box-title">MK DELIVERIES <span class="text-danger">
      ({{ App\Model\consignee::find($_SESSION['consignee'])->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="box-body table-responsive">
    <table class="table-bordered table-striped table" id="example2">
     <thead>
      <tr>
       <th>No.</th>
       <th>Waybill No</th>
       <th>MK Number</th>
       <th>Contract Number</th>
       <th>Transaction Code</th>
       <th>CMC First Weight</th>
       <th>CMC Second Weight</th>
       <th>CMC Net Weight</th>
       <th>CMC Delivery Date</th>
       <th>CMC No. of Bags</th>
       <th>Factory First Weight</th>
       <th>Factory Second Weight</th>
       <th>Factory Net Weight</th>
       <th>FACTORY Confirmation Date</th>
       <th>Factory No. of Bags</th>

      </tr>
     </thead>
     <tbody>

      @foreach ($shed_waybills as $shed_waybill)
       <tr>
        <td>{{ $loop->index + 1 }}.</td>
        <td> {{ $shed_waybill->waybill_no }}</td>
        <td>{{ $shed_waybill->sales_advice->mk_number }}</td>
        <td>{{ $shed_waybill->contract->number }}</td>
        <td>{{ $shed_waybill->evac_truck->transaction_code }}</td>
        <td>{{ $shed_waybill->evac_truck->first_weight }}</td>
        <td>{{ $shed_waybill->evac_truck->second_weight }}</td>
        <td>{{ $shed_waybill->net_weight * 1000 + $shed_waybill->quantity }}</td>
        <td>
         {{ $shed_waybill->evac_truck->second_weight_date ? Carbon\Carbon::parse($shed_waybill->evac_truck->second_weight_date)->format('Y-m-d h:ia') : null }}
        </td>
        <td>{{ $shed_waybill->quantity }}</td>
        <td>{{ $shed_waybill->evac_truck->factory_first_weight }}</td>
        <td>{{ $shed_waybill->evac_truck->factory_second_weight }}</td>
        <td>{{ $shed_waybill->evac_truck->factory_net_weight }}</td>
        <td>
         {{ $shed_waybill->evac_truck->factory_user_time ? Carbon\Carbon::parse($shed_waybill->evac_truck->factory_user_time)->format('Y-m-d h:ia') : null }}
        </td>
        <td>{{ $shed_waybill->evac_truck->factory_bags }}</td>
       </tr>
      @endforeach

     </tbody>
     <tfoot>
      <tr>
       <th>No.</th>
       <th>Waybill No</th>
       <th>MK Number</th>
       <th>Contract Number</th>
       <th>Transaction Code</th>
       <th>CMC First Weight</th>
       <th>CMC Second Weight</th>
       <th>CMC Net Weight</th>
       <th>CMC Delivery Date</th>
       <th>CMC No. of Bags</th>
       <th>Factory First Weight</th>
       <th>Factory Second Weight</th>
       <th>Factory Net Weight</th>
       <th>FACTORY Confirmation Date</th>
       <th>Factory No. of Bags</th>
      </tr>
     </tfoot>
    </table>
   </div>

   <!-- /.box-body -->
   <div class="box-footer">
   </div>
  </div>
 </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: 'MK Deliveries Report',
      customize: function(xlsx) {
       var sheet = xlsx.xl.worksheets['sheet1.xml'];

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

  })
 </script>
@endsection