@extends('admin.layout.master')
@section('title','SHOTAGE STOCK')
@section ('content')
 
<style>
    td.lastCat {
        border-bottom: 1px solid red;
    }
    .table th, .table td {
            padding: 0px 5px;
            color: black;
        }
    .table th {
           background: #ab3535;
           padding: 5px !important;
           color: white !important;
        }
</style>
    <div class="card sina-card">
        <div class="card-header card-header-s d-flex flex-wrap align-items-center">
            <div class="col-md-6 col-12 pl-0">
                <h4>Stock Shortage List</h4>
            </div>
            {{-- 
            <div class="pl-0 pl-md-3 mt-md-0 mt-2 col-md-2 col-12 d-flex justify-content-md-end justify-content-start text-white pr-0">
                <label for="report_type">Search Type</label>
            </div>
            <div  class="pl-0 pl-md-3 col-md-4 col-12 d-flex"> 
                <select class="form-control select_2" style="width: 100%" name="report_type" id="report_type">
                    <option value="1" selected>Category</option>
                    <option value="2">Category & Product</option>
                </select>
            </div>
            --}}
        </div>
        <div class="card-body">
            
            <form method="get" action="{{route('prepurchase.short_stock_list')}}" name="filter_form" id="filter_form">
             
                {{-- <div class="row mb-1"> --}}
                    <div class="row justify-content-end">
                        <div class="input-group col-2">
                            <label for="party">Party</label>
                            <select class="party form-control" style="width: 100%" name="party" id="party" onchange="setVendor()"> 
                               
                            </select>
                        </div>
                        <div class="input-group col-2">
                            <label for="product_id">Product</label>
                            <select class="product_live form-control" style="width: 100%" name="product_id[]" id="product_id"> 
                               
                            </select>
                        </div> 
                        <div class="input-group col-2">
                            <label for="category_id">Category</label>
                            <select class="form-control select_2" style="width: 100%" name="category_code" id="category_id"> 
                                <option value="" selected> -- Select Category -- </option>
                                @forelse ($categories as $cat)
                                    <option value="{{$cat->code}}" > {{$cat->name_eng .' ('. $cat->code.')'}} </option>
                                   
                                    @forelse ($cat->child as $sub_cat)
                                        <option value="{{$sub_cat->code}}">&nbsp;&nbsp; {{$sub_cat->name_eng}}</option>
                                        
                                        @forelse ($sub_cat->child as $sub_sub_cat)
                                            <option value="{{$sub_sub_cat->code}}">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {{$sub_sub_cat->name_eng}}</option>
                                        @empty
                                            
                                        @endforelse
                                    @empty
                                        
                                    @endforelse
                                @empty
                                    
                                @endforelse
                            </select>
                        </div>
                        {{-- <div class="input-group col-1 pl-0"> --}}
                        <div class="col-4 pl-0">
                            <label>Date</label>
                            <div class="input-group">
                                <div class="input-group input-group-append">
                                    <input type="date" class="form-control bsdatepicker" id="date_from" name="date_from" value="{{Request()->date_from?date('Y-m-d',strtotime(Request()->date_from)):date('Y-m-d')}}">
                                    <label class="input-group-text" style="height: 28px; margin-left: -2px; margin-right: -2px">To</label>
                                    <input type="date" class="form-control bsdatepicker" id="date_to" name="date_to" value="{{Request()->date_to?date('Y-m-d',strtotime(Request()->date_to)):date('Y-m-d')}}"> 
                            
                                    <button type="submit" style="height: 28px; margin-left: -2px" class="btn btn-pill btn-sm btn-hover btn-danger">
                                        <i class="fa fa-search"></i>
                                    </button>
                                </div>
                            </div>
                        </div>
                        {{-- <div class="col-md-3 col-12 flex-wrap pr-0 mb-2">
                            <label for="date_from">Date From</label>
                            <input type="text" name="date_from" id="date_from" value="{{date('Y/m/d')}}">
                        </div>
                        <div class="col-md-3 col-12 flex-wrap pr-0 ">
                            <label for="date_to">Date To</label>
                            <input type="text" name="date_to" id="date_to" value="{{date('Y/m/d')}}">
                        </div> 

                        <div class="col-md-1 col-1 flex-wrap pr-0 text-center mb-2 pt-1"> 
                            <button class="btn btn-sm btn-outline-info font-weight-bold d-flex" name="filter" id="filter">
                                <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-filter pt-1" viewBox="0 0 16 16">
                                    <path d="M6 10.5a.5.5 0 0 1 .5-.5h3a.5.5 0 0 1 0 1h-3a.5.5 0 0 1-.5-.5zm-2-3a.5.5 0 0 1 .5-.5h7a.5.5 0 0 1 0 1h-7a.5.5 0 0 1-.5-.5zm-2-3a.5.5 0 0 1 .5-.5h11a.5.5 0 0 1 0 1h-11a.5.5 0 0 1-.5-.5z"/>
                                </svg>&nbsp;Filter
                            </button>
                        </div> --}}
                    </div>
                {{-- </div> --}}
            </form>
            <div class="table-responsive"  id="print">
                <form method="post" action="{{route('prepurchase.requisition_store')}}" name="filter_form" id="filter_form_data">
                    @csrf
                    <table class="table table-striped table-bordered dataTable" id="tbl_data">
                        <input type="hidden" name="type" id="" value="1">
                        <input type="hidden" name="vendor_id" id="vendor_id" value="{{Request()->party}}">
                        <thead>
                            <tr>
                                <th width="5%">SL</th>
                                <th width="65%">{{'Product Name'}}</th>
                                <th width="10%">{{'Reorder Level'}}</th>
                                <th width="10%">InSTOCK</th>
                                {{-- <th><input type="checkbox" name="checkbox_all" id="checkbox_all" onclick="checkAll()" value="1"></th> --}}
                                <th width="10%">Requisition Qty</th>
                                
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $g=1;
                                $p=1;
                            @endphp
                            @if(count($products)>0)
                            @forelse ($products->groupBy('cat_code') as $cat=>$categoryProducts)
                                {{-- <tr>
                                    <td>{{$g}}</td>
                                    <td colspan="5" class="text-center" style="border: dashed green 2px;">{{$categoryProducts->first()->catByCatCode?$categoryProducts->first()->catByCatCode->name_eng:$cat}}</td>
                                    <td style="display: none"></td>
                                    <td style="display: none"></td>
                                    <td style="display: none"></td>
                                </tr> --}}
                                @forelse ($categoryProducts as $product)
                                @php
                                    $stk=array_key_exists($product->id,$stocks)?$stocks[$product->id]:0;
                                    $reorder_level=$product->reorder_level??1;    
                                @endphp
                                    @if($stk <= $reorder_level)
                                        <tr>
                                            <td>{{$g}}.{{$p++}}</td>
                                            <td>{{ $product->name_eng }}</td>
                                            <td class="text-right">{{ $product->reorder_level }}</td>
                                            <td class="text-right">{{$stk}}</td>
                                            <input type="hidden" name="product_id[{{$product->id}}]" value="{{$product->id}}">
                                            {{-- <td class="text-right"><input type="checkbox" name="product_id[{{$product->id}}]" class="check_field form-check-input" id="" value="{{$product->id}}"></td> --}}
                                            <td class="text-right"><input type="number" name="quantity[{{$product->id}}]" class="form-control-sm"></td>
                                            
                                        </tr>
                                    @endif
                                @empty
                                    
                                @endforelse
                                @php
                                    $g++;
                                @endphp
                            @empty
                                
                            @endforelse
                            @endif
                        </tbody>
                        
                    </table>
                    <button style="position: fixed;top:90%;right:2px;" class="btn-sina-submit" type="submit"><i class="fa fa-save"></i> Add Requisition </button>
                    <button style="position: fixed;top:95%;right:2px;" class="btn btn-danger" type="button" onclick="submitPo()"><i class="fa fa-save"></i> Make PO </button>
                </form>
            </div>
            <div class="d-flex justify-content-end pt-2">
                {{-- {!! $invoices->links() !!} --}}
            </div>
        </div>
    </div>
    
@endsection

@section('script') 
<script>
    const store_setting = @json(store_info());
</script>
    <script type="text/javascript">
    $(document).ready(function() {
        $('#tbl_data').dataTable( {
            "paging": false,
            "columnDefs": [ {
                "orderable": false,
                // "visible": false, 
                'targets': [0,3,4],
            } ]
        } );
    // var date = new Date()
    // console.log(new Date(new Date(date.getFullYear(), date.getMonth(), date.getDate())));
    // $('#date_from').datepicker({  
    //     uiLibrary: 'bootstrap4', format: 'yyyy/mm/dd'
    // }); 
    // $('#date_to').datepicker({ 
    //     uiLibrary: 'bootstrap4', format: 'yyyy/mm/dd'
    // }); 
    
    select2('select_2');
    transactionProductSearch('product_live','transaction',true); //Select2

});
// function checkAll(){
//    var check= $('#checkbox_all').val();
//    if(check==1){
//        $('.check_field').each(function(){
//            $(this).attr('checked',true);
//         });
//     $('#checkbox_all').val(0);
//    }else{
//        $('.check_field').each(function(){
//            $(this).attr('checked',false);
//         });
//     $('#checkbox_all').val(1);
//    }
// }
function submitPo(){
    let route_url="{{route('prepurchase.po_store_shortlist')}}";
    $('#filter_form_data').attr('action',route_url);
    $('#filter_form_data').submit();
}
function setVendor(){
    let party_ledger=$('party').val();
    $('#vendor_id').val(party_ledger);
}
 

    </script>
    <script type="text/javascript" src="{{ asset('inventory/blade_js/common.js') }}"></script>
    <script>
        partySearch('party',1);
    </script>
@endsection