@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: var(--cl-primary);
           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>{{__('obs.stock')}} {{__('obs.shortage')}} {{__('obs.list')}}</h4>
            </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 mb-3 justify-content-end">
                        <div class="input-group col">
                            <input type="hidden" name="search" value="1">
                            <label for="party">{{__('obs.party')}}</label>
                            <select class="party form-control" style="width: 100%" name="party" id="party" onchange="setVendor()"> 
                               
                            </select>
                        </div>
                        <div class="input-group col">
                            <label for="product_id">{{__('obs.product')}}</label>
                            <select class="product_live form-control" style="width: 100%" name="product_id" id="product_id"> 
                               
                            </select>
                        </div> 
                        <div class="input-group col">
                            <label for="category_id">{{__('obs.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="col-4 pl-0">
                            <label>Date</label>
                            <div class="input-group">
                                <div class="input-group input-group-append">
                                    {!!getDateInput('date_from','date_from',Request()->date_from)!!}
                                    <label class="input-group-text" style="height: 24px; margin-left: -2px; margin-right: -2px">{{__('obs.date_to')}}</label>
                                    {!!getDateInput('date_to','date_to',Request()->date_to)!!}
                                    <button type="submit" style="height: 24px; margin-left: -2px" class="btn btn-pill btn-sm btn-hover btn-danger">
                                        <i class="fa fa-search"></i>
                                    </button>
                                </div>
                            </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%">{{__('obs.sl')}}</th>
                                <th width="65%">{{'Product Name'}}</th>
                                <th width="10%">{{'Reorder Level'}}</th>
                                <th width="10%">{{__('obs.instock')}}</th>
                                {{-- <th><input type="checkbox" name="checkbox_all" id="checkbox_all" onclick="checkAll()" value="1"></th> --}}
                                <th width="10%">{{__('obs.requisition')}} {{__('obs.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>
                    <div class="d-flex" style="position: fixed;top:90%;right:2px;">
                        <button class="btn btn-sina-submit" type="submit"><i class="fa fa-save"></i> {{__('obs.add')}} {{__('obs.requisition')}} </button>
                        <button class="btn btn-sina-submit" type="button" onclick="submitPo()"><i class="fa fa-save"></i> {{__('obs.make')}} {{__('obs.po')}} </button>
                    </div>
                </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