@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">({{App\Model\consignee::find($_SESSION['consignee'])->name}})</span></h3>

      <form class="form-inline">
        <div class="form-group mb-2 col-sm-offset-4">
          <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 mb-2 col-sm-offset-3">
          <a href="{{ URL::route('research.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 table-responsive">
      <table id="example2" class="table table-bordered table-striped ">
        <thead>

          <tr>
            <th>No.</th>
            <th>Truck No.</th>
            <th>Transaction Code</th>
            <th>First Weight</th>
            <th>Second Weight</th>
            <th>Net Weight</th>
            <th>No. of Bags</th>
            <th>MK.</th>
            <th>MK.Tonnage</th>
            <th>Contract No.</th>
            <th>Contract Tonnage</th>
            <th>Tonnage Delivered</th>
            <th>Tonnage Left</th>
            <th>Factory First Weight</th>
            <th>Factory Second Weight</th>
            <th>Factory Net Weight</th>
            <th>Factory Bags</th>
            <th>Net Weight Status</th>
            <th>Bags Status</th>
          </tr>
        </thead>
        <tbody>

          @foreach ($evac_trucks as $evac_truck)

          <tr>
           <td>{{$loop->index + 1}}.</td>
           <td>{{$evac_truck->truck->truck_no}}</td>
           <td>{{$evac_truck->transaction_code}}</td>
           <td>{{$evac_truck->first_weight}}</td>
           <td>{{$evac_truck->second_weight}}</td>
           <td>{{$evac_truck->net_weight}}</td>
           <td>{{$evac_truck->shed_waybills()->sum('quantity')}}</td>
           <td>{{$evac_truck->wpo_evacuation->mk_number}}</td>
           <td>{{$evac_truck->wpo_evacuation->sales_advice->tonnage}}</td>
           <td>{{$evac_truck->wpo_evacuation->contract_number}}</td>
           @foreach ($evac_truck->shed_waybills as $shed_waybill)
           <td>{{$shed_waybill->contract->tonnage}}</td>
           <td>{{$shed_waybill->contract->shed_waybills()->sum('net_weight')}}</td>
           <td>{{$shed_waybill->sales_advice->tonnage - $shed_waybill->contract->shed_waybills()->sum('net_weight')}}</td>
           @endforeach
           <td style="color: blue;">{{$evac_truck->factory_first_weight}}</td>
           <td style="color: blue;">{{$evac_truck->factory_second_weight}}</td>
           <td style="color: blue;">{{$evac_truck->factory_net_weight}}</td>
           <td>{{$evac_truck->factory_bags}}</td>
           <td>
            @php
            $cmc_net_weight = $evac_truck->net_weight;
            $fac_net_weight = $evac_truck->factory_net_weight;
            $diff_net_weight = $cmc_net_weight - $fac_net_weight;
            @endphp
            @if ($diff_net_weight > 100)

            <span class="label label-danger">FLAGGED</span>

            @else
            <span class="label label-success">ACCEPTED</span>
            @endif
          </td>
          <td>
            @if($evac_truck->factory_bags != null)
            Confirmed
            @else
            Unconfirmed
            @endif
          </td>

          @endforeach
        </tbody>

      </table>
      {!! $evac_trucks->render() !!}
    </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>
  $('#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').html("Export To Excel");
  //  },200000);
  // });


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

  } );


 })

</script>
@endsection