@extends('layouts.app')

@section('title')
{{__('Near Expiry Alert')}}
@endsection

@section('breadcrumb')
<div class="content-header">
  <div class="container-fluid">
    <div class="row mb-2">
      <div class="col-sm-6">
        <h1 class="m-0 text-dark">
          <i class="nav-icon fas fa-cubes"></i>   
          {{__('Near Expiry Alert')}}
        </h1>
      </div><!-- /.col -->
      <div class="col-sm-6">
        <ol class="breadcrumb float-sm-right">
          <li class="breadcrumb-item"><a href="{{route('admin.index')}}">{{__('Home')}}</a></li>
          <li class="breadcrumb-item active">{{__('Near Expiry Alert')}}</li>
        </ol>
      </div><!-- /.col -->
    </div><!-- /.row -->
  </div><!-- /.container-fluid -->
</div>
@endsection

@section('content')
<div class="card card-primary card-outline">
  <div class="card-header">
    <h3 class="card-title">{{__('Products')}}</h3>
  </div>
  <!-- /.card-header -->
  <div class="card-body">
    
    <div class="row table-responsive">
      <div class="col-12">
        <table id="near_expiry_table" class="table table table-striped table-bordered"  width="100%">
          <thead  >
            <tr>
              <th>{{__('Product Code')}}</th>
              <th>{{__('Product Type')}}</th>
              <th>{{__('Particulars')}}</th>
              <th>{{__('Product Unit')}}</th>
              <th>{{__('Expiry Date')}}</th>
              <th>{{__('Batch No.')}}</th>
              <th>{{__('Current Quantity')}}</th>
            </tr>
          </thead>
          <tbody>
                @foreach($nearExpiry as $products)
                <tr>
                    <td>
                        {{$products->product->code}}
                    </td>
                    <td>
                        {{$products->product->product_type->name}}
                    </td>
                    <td>
                        {{$products->product->product_category->name}} {{$products->product->name}} {{$products->product->description}} 
                    </td>
                    <td>
                        {{$products->product->product_unit->name}}
                    </td>
                    <td>
                        {{date('F j, Y', strtotime($products->expiry_date))}}
                    </td>
                    <td>
                        {{$products->batch_no}}
                    </td>
                    <td>
                        {{$products->stock_remaining}}
                    </td>
                </tr>
                @endforeach
          </tbody>
        </table>
      </div>
    </div>
  </div>
  <!-- /.card-body -->
</div>


@endsection

@section('scripts')
  {{-- <script src="{{url('js/admin/product_alerts.js')}}"></script> --}}
  <script>
    $("#near_expiry_table").DataTable({
      });

      $('input[type="search"]').on('keyup', function() {
      $('#myTable').DataTable().search($(this).val()).draw();
  });
  </script>
@endsection