@extends('layouts.app')
@section('title') {{'Minimum Stock Report'}} @endsection
@section('content')

    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading">
                Minimum Stock Report
                <a href="{{ url('/LowStockReport') }}" class="pull-right"> Back</a>
            </div>

            <div class="panel-body">

                @if (Session::has('msg'))
                    <div class="alert alert-info">{{ Session::get('msg') }}</div>
                @endif
                <div class="form-group mb-3">
                    
                    <form method="get"  action="">
                    <div class="col-md-3">
                        Search By Sub Category
                       <select onchange="this.form.submit()" name="department" id="department" data-live-search="true" class="form-control selectpicker">
                            <option value=""> All </option>
                            @if(isset($search_departments_list))
                                @foreach($search_departments_list as $val)
                                    <option value="{{ $val->id}}"  @if(isset($_GET['department']) && $_GET['department'] == $val->id) selected="selected" @endif>  {{ $val->department_name }} </option>
                                @endforeach
                            @endif
                        </select>
                    </div> 
                    </form>                 
                </div>
                <br><br>

<div class="form-group mt-1" style="width:100%; overflow: scroll;" >
 
                <table id="myTable" class="table table-striped table-hover mt-3">
                    <thead class="header" id="myHeader">
                    <tr>
                        <th> S.N.</th>
                        <th> ID </th>
                        <th> Item Name</th>
                        <th> Present Stock </th>
                        <th> Minimum Stock Limit </th>
                    </tr>
                    </thead>
                    <tbody>
                    @php $i=1; @endphp

                    @foreach($product_list as $row)
                        @php

                          
                          $Opening_stock = 0;
                          $product_received = $row->product_received;
                          $pur_return = $row->pur_return;
                          $product_return = $row->product_return;
                          $product_sales = $row->product_sales;
                          $product_in = $row->product_in;
                          $product_out = $row->product_out;

                          $Physical_stock = $product_received - $pur_return + $product_return - $product_sales + $product_in - $product_out;
                          if (isset($row->rs)){
                            if($row->rs==0)
                                $cls='bg-success';
                            else
                                $cls='bg-danger';
                          }else
                            $cls='bg-danger';


                        @endphp

                        @if($Physical_stock<=$row->low_s_q)
                            <tr class="{!! $cls !!}" title="@if($row->rs==0){{ $row->rid }}@else @endif">
                                <td >{{$i++}}</td>
                                <td >{{$row->id}}</td>
                                <td >{{$row->product_name}}</td>
                                <td >{{ number_format($Physical_stock,2) }} </td>
                                <td >{{ $row->low_s_q }} </td>
                            </tr>
                        @endif

                    @endforeach
                    </tbody>
                </table>



            </div>
            </div>
        </div>
    </div>
<style>
    .bg-danger td {
        background-color: #ff7582 !important;
    }
    table.table.text-center.table-striped.table-hover.fixedHeader .header tr th {
        position: sticky;
        top: 0;
        /* width: 109%; */
        background: #D9E5D8;
    }

    table#myTable thead#myHeader{
        position: sticky;
        top: 0;
        /* width: 109%; */
        background: #D9E5D8;
    }
    table.table.text-center.table-striped.table-hover.fixedHeader .header tr:last-child th{
        top: 32px;
    }
</style>
@endsection