@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">
    <h3 class="box-title">TRUCK REPORT <span class="text-danger">
      @if ($_SESSION['consignee'] == 'all')
       ALL FACTORIES
      @else
       ({{ App\Model\consignee::find($_SESSION['consignee'])->name }})
      @endif
     </span></h3>
    <div class="form-group mx-bg-3 col-sm-offset-3 mb-2">
     <a href="{{ URL::route('research.export') }}" class="btn btn-success" id="batt"> Export To Excel </a>
    </div>

    <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>Factory</th>
       <th>Truck Number</th>
       <th>Transaction Code</th>
       {{-- <th>MK Number</th>
       <th>Contract Number</th> --}}
       <th>CMC First Weight</th>
       <th>CMC Second Weight</th>
       <th>CMC Net Weight</th>
       <th>CMC Tare Weight</th>
       <th>CMC Delivery Date</th>
       {{-- <th>CDN NO.</th> --}}
       <th>CMC No. of Bags</th>
       <th>Factory First Weight</th>
       <th>Factory Second Weight</th>
       <th>Factory Net Weight</th>
       <th>Factory Tare Weight</th>
       <th>FACTORY Confirmation Date</th>
       <th>Factory No. of Bags</th>
       <th>Average Tare Weight</th>
       <th>Status</th>
      </tr>
     </thead>
     <tbody>

      @foreach ($evac_trucks as $evac_truck)
       <tr>
        <td>{{ $loop->index + 1 }}.</td>
        <td> {{ $evac_truck->consignee->name }}</td>
        <td>{{ strtoupper($evac_truck->truck->truck_no) }}</td>
        <td>{{ $evac_truck->transaction_code }}</td>
        <td>{{ $evac_truck->wpo_evacuation->mk_number }}</td>
        <td>{{ $evac_truck->wpo_evacuation->contract_number }}</td>
        <td>{{ $evac_truck->first_weight }}</td>
        <td>{{ $evac_truck->second_weight }}</td>
        <td style="color:indigo; font-weight: bold;">{{ $evac_truck->net_weight }}</td>
        <td>{{ $evac_truck->net_weight - $evac_truck->shed_waybills()->sum('quantity') }}</td>
        <td>
         {{ $evac_truck->second_weight_date ? Carbon\Carbon::parse($evac_truck->second_weight_date)->format('Y-m-d h:ia') : null }}
        </td>
        {{-- <td>
         @foreach ($evac_truck->shed_waybills as $sw)
          {{ optional($sw->cdn)->cdn_number }}<br>
         @endforeach

        </td> --}}
        <td>{{ number_format($cmc_bags = $evac_truck->shed_waybills()->sum('quantity')) }}</td>

        <td>{{ $evac_truck->factory_first_weight }}</td>
        <td>{{ $evac_truck->factory_second_weight }}</td>
        <td style="color:indigo; font-weight: bold;">{{ $evac_truck->factory_net_weight }}</td>
        <td>{{ $evac_truck->factory_net_weight - $evac_truck->factory_bags }}</td>
        <td>
         {{ $evac_truck->factory_user_time ? Carbon\Carbon::parse($evac_truck->factory_user_time)->format('Y-m-d h:ia') : null }}
        </td>
        <td>{{ $evac_truck->factory_bags }}</td>
        <td>
         {{ ($evac_truck->net_weight -
             $evac_truck->shed_waybills()->sum('quantity') +
             ($evac_truck->factory_net_weight - $evac_truck->factory_bags)) /
             2 }}
        </td>
        <td>
         @switch(true)
          @case($evac_truck->factory_bags == $cmc_bags && $cmc_bags > 0)
           <span class="label label-success">Ok</span>
          @break;
          @case($evac_truck->factory_bags == 0 || $evac_truck->factory_bags == null)
           <span class="label label-warning">Pending</span>
          @break;
          @case($evac_truck->factory_bags != $cmc_bags)
           <span class="label label-danger">Kindly Reconcile</span>
          @break;

          @default
         @endswitch
        </td>
       </tr>
      @endforeach

     </tbody>
     <tfoot>
      <tr>
       <th>No.</th>
       <th>Factory</th>
       <th>Truck Number</th>
       <th>Transaction Code</th>
       {{-- <th>MK Number</th>
       <th>Contract Number</th> --}}
       <th>CMC First Weight</th>
       <th>CMC Second Weight</th>
       <th>CMC Net Weight</th>
       <th>CMC Tare Weight</th>
       <th>CMC Delivery Date</th>
       {{-- <th>CDN NO.</th> --}}
       <th>CMC No. of Bags</th>
       <th>Factory First Weight</th>
       <th>Factory Second Weight</th>
       <th>Factory Net Weight</th>
       <th>Factory Tare Weight</th>
       <th>FACTORY Confirmation Date</th>
       <th>Factory No. of Bags</th>
       <th>Average Tare Weight</th>
       <th>Status</th>
      </tr>
     </tfoot>
    </table>
    Showing {{ $evac_trucks->firstItem() }} to {{ $evac_trucks->lastItem() }}
    of total {{ $evac_trucks->total() }} entries
    {{ $evac_trucks->links() }}
   </div>

   <!-- /.box-body -->
   <div class="box-footer">
   </div>
  </div>
 </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>
  $(function() {
   $('#example1').DataTable()
   $('#example2').DataTable({
    'paging': false,
    'lengthChange': false,
    'searching': false,
    'ordering': true,
    'info': false,
    'autoWidth': false
   });

   $('#batt').click(function() {
    var button = $(this);
    button.attr('disabled', 'disabled');
   });
  })
 </script>
@endsection