@extends('admin.layout.app')

@section('more-head')
 <link rel="stylesheet" href="{{ asset('admin/bower_components/datatables.net-bs/css/dataTables.bootstrap.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 hiide">
    <h3 class="box-title">M & E REPORTS</h3>
    <p><span style="color:red; font-weight:bolder; font-size: medium; margin-left: 200px ">DATE BETWEEN
      {{ date('jS F, Y', strtotime($_SESSION['dfrom'])) }} and {{ date('jS F, Y', strtotime($_SESSION['dto'])) }}
      ({{ App\Model\season::find($_SESSION['season'])->name }}) ({{ App\Model\port::find($_SESSION['port'])->name }})
     </span>
    </p>
    <form class="form-inline">
     <div class="form-group col-sm-offset-3 mb-2">
      <input type="text" name="q" placeholder="Search..." class="form-control" />
     </div>
     <input type="submit" class="btn btn-primary mb-4" value="Search" />
     <div class="form-group mx-bg-3 col-sm-offset-3 mb-2">
      <a href="{{ URL::route('me.export') }}" class="btn btn-success" id="batt"> Export To Excel </a>
     </div>
    </form>
    <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">

    <div class="col-md-12 table-responsive">
     <div class="">

      {{--  <div class=" showee">
            <img class="col-md-2" style="width: 150px; height: 100px;" src="{{asset('admin/dist/img/cmclogo.png')}}" class="img-circle" alt="User Image">
            <br> --}}

      <br>

     </div>

    </div>

    <table id="example2" class="table-bordered table-striped table">
     <thead>

      <tr>
       <th>No.</th>
       <th>Transaction Code</th>
       <th>Truck No.</th>
       <th>Registration Date</th>
       <th>First Weight</th>
       <th>First Weight Date</th>
       <th>Second Weight</th>
       <th>Second Weight Date</th>
       <th>Offloading Date</th>
       <th>Duration</th>

      </tr>
     </thead>
     <tbody>

      @foreach ($internal_waybills as $internal_waybill)
       <tr>
        <td>{{ $count++ }}.</td>
        <td>{{ $internal_waybill->bush_delivery->transaction_code }}</td>
        <td>{{ $internal_waybill->bush_delivery->truck_no }}</td>
        <td>
         {{ $internal_waybill->bush_delivery->registration_time ? Carbon\Carbon::parse($internal_waybill->bush_delivery->registration_time)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ $internal_waybill->bush_delivery->first_weight }}</td>
        <td>
         {{ $internal_waybill->bush_delivery->first_weight_date ? Carbon\Carbon::parse($internal_waybill->bush_delivery->first_weight_date)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ $internal_waybill->bush_delivery->second_weight }}</td>
        <td>
         {{ $internal_waybill->bush_delivery->second_weight_date ? Carbon\Carbon::parse($internal_waybill->bush_delivery->second_weight_date)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $internal_waybill->offloading_date ? Carbon\Carbon::parse($internal_waybill->offloading_date)->format('j M Y') : null }}
        </td>
        <td>@php
         $from = Carbon\Carbon::parse($internal_waybill->bush_delivery->registration_time);
         $to = Carbon\Carbon::parse($internal_waybill->offloading_date);
         $try = $from->isSameUnit('day', $to);
         $period = $to->diffInWeekdays($from);
         if ($try) {
             echo '0';
         } else {
             echo $period;
         }
         
        @endphp</td>
       </tr>
      @endforeach

     </tbody>

    </table>
    {!! $internal_waybills->render() !!}
   </div>

   <div class="col-md-12">

   </div>

  </div>

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

  </div>
  <!-- /.box-footer-->
  </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>
  $('#batt').click(function() {
   var button = $(this);
   button.attr('disabled', 'disabled');
  });
  //  $('#batt').click(function(){
  //   var button = $(this);
  //   button.html("Downloading...").attr('disabled', 'disabled');
  //   setTimeout(function() {
  //    button.removeAttr('disabled');
  //  },200000);
  // });

  $(function() {
   $('.showee').hide();
   $('#example1').DataTable()
   $('#example2').DataTable({
    'searching': false,
    'paging': false,
    'ordering': true,
    "scrollX": true,
    "pageLength": 30,
   });


  })
 </script>
@endsection