@extends('admin.layout.master')
@section('title','ALLOCATION MANAGEMENT')
@section('custom_style')
<style>
    input[type=text],input[type=file],input[type=number] 
        {
            height: 35px !important;
        }
    .table thead th,.table thead td {
            border: 1px solid black !important;
            text-align: center;
            vertical-align: middle;
        }
    th:first-child
        {
            position:sticky;
            left:0px;
            background-color:white;
        }
    th:nth-child(2)
        {
            position:sticky;
            left:2.5%;
            background-color:white;
        }
    th:nth-child(3)
        {
            position:sticky;
            left:14.5%;
            background-color:white;
        }
    th:nth-child(4)
        {
            position:sticky;
            left:20%;
            background-color:white;
        }
    th:last-child
        {
            position:sticky;
            right:0px;
            background-color:white;
        }
#fixed_head_top
        {
            position: sticky;
            top: 0;
        }
</style>
@endsection
@section ('content')
<div class="card sina-card">
    <div class="card-header card-header-s">
        <h4>ALLOCATION</h4>
    </div>
    <div class="card-body">   
        <input type="hidden" name="" id="csrf-token" value="{{ Session::token() }}" />
        <form id="form" method="get" action="{{ route('order.allocation') }}" name="form" enctype="multipart/form-data">
            @csrf
            <div class="tab-pane active" id="tabs-1" role="tabpanel">
                <div class="row mb-1">
                    
                    <div class="col-md-5 col-12 d-flex flex-wrap pr-0 mb-3">
                        <div class="col-4 px-0">
                            <label for="pay_type">CATEGORY</label>
                        </div>
                        
                    
                        <div class="col-8 px-0">
                            <select name="category_code" id="category_code" class="form-control select2" onchange="getProduct()">
                                @forelse ($products->GroupBy('category_id') as $category_id=>$category)
                                <option value="{{$category->first()->category->code}}" data-category_id="{{$category_id}}">{{$category->first()->category->name_eng}}</option>
                                @empty  
                                @endforelse
                            </select>
                        </div>
                    </div>
                    <div class="col-md-5 col-12 d-flex flex-wrap pr-0 mb-3">
                        <div class="col-4 px-0">
                            <label for="pay_type">PRODUCT NAME</label>
                        </div>
                        
                    
                        <div class="col-8 px-0">
                            <select name="product_id" id="product_id" class="form-control select2">
                                <option value="0">SELECT PRODUCT</option>
                            @forelse ($products as $product)
                            <option value="{{$product->id}}">{{$product->name_eng}}</option>
                            @empty
                                
                            @endforelse
                            </select>
                    </div>
                </div>
                <div class="col-md-1 col-12 d-flex flex-wrap pr-0 mb-3">
                    <button type="submit">Search</button>
                </div>
            </div>
        </form>
       
        <form id="form" method="post" action="{{ route('order.mass_allocation_store') }}" name="form" enctype="multipart/form-data">
            <div class="table-responsive">
                    @csrf
                    <table class="table table-hover table-striped table-bordered" style="max-height:100px;overflow">
                    <thead id="fixed_head_top">
                            @php
                                $tr='<tr >';
                            @endphp
                        <tr >
                            <th rowspan="2" width="10%">#</th>
                            <th rowspan="2" width="20%">PRODUCT</th>
                            <th rowspan="2" width="10%">STOCK</th>
                            <th rowspan="2" width="10%">ORDER</th>
                            @forelse ($showRooms as $a=>$showRoomGroup)
                            @if($a!='')
                                 <th colspan="2" class="text-center" >{{$showRoomGroup->first()->showroom->name_eng}}</th>  
                                @php
                                    $tr.='<td>OrderQty</td><td>Allot. Qty</td>';
                                @endphp  
                            @endif
                                @empty
                            @endforelse
                            <th rowspan="2" width="10%">Allocated</th>
                            <th rowspan="2" width="10%">Closing</th>
                            <th rowspan="2" width="10%">Action</th>
                        </tr>
                        {!! $tr.'</tr>' !!}
                    </thead>
                    <tbody id="tbl_body">
                        @php
                            $p=1;
                        @endphp
                        @forelse ($orderedProduct as $i=>$item)
                        
                        <tr id="tr{{$p}}">
                            <th>{{ ($p++) }}</th>
                            <th>
                                {{ $item->first()->product->name_eng }}
                            </th>
                            <th id="getStockQty{{$i}}">
                                {{ $transactions->where('product_id',$i)->where('dr_cr',1)->sum('quantity')-$transactions->where('product_id',$i)->where('dr_cr',2)->sum('quantity') }}
                            </th>
                            <th>
                                {{ $transactions->where('product_id',$i)->where('transaction_type','!=',3)->sum('order_qty') }}
                            </th>
                            @forelse ($showRooms as $k=>$showRoom)
                            @if($k!='')
                                <input type="hidden" name="showroom[]" value="{{$k}}" class="shoowroom-{{$i}}">
                                <td>{{ $item->where('party_id',$k)->where('transaction_type','!=',3)->sum('order_qty') }}</td>
                                <td><input style="width:50px;" type="number" id="quantity-{{$k}}-{{$i}}" class="showroom_wise_allocation-{{$i}} text-right" name="qty[{{$k}}][{{$i}}]" onkeyup="getSum({{$i}})" value="{{$item->where('party_id',$k)->where('transaction_type','!=',3)->sum('allocated_qty') }}"></td>    
                            @endif
                            @empty
                                
                            @endforelse
                            @php
                               $closing= ($transactions->where('product_id',$i)->where('dr_cr',1)->sum('quantity')-$transactions->where('product_id',$i)->where('dr_cr',2)->sum('quantity')) - $item->where('transaction_type','!=',3)->sum('allocated_qty');
                            @endphp
                            <th id="allocated{{$i}}">{{$item->where('transaction_type','!=',3)->sum('allocated_qty') }}</th>
                            <th id="closing{{$i}}">{{ $closing }}</th>
                            <th><button type="button" class="btn-info submit_allocation_try" id="submit_allocation{{$i}}" @if($closing<0?1:0) disabled="disabled" @endif onclick="setAllocationForProduct({{$i}})">Submit</button></th>
                           
                        </tr>
                        @empty
                        @endforelse
                        
                    </tbody>
                </table>
            </div>
            
            <hr>
            
            <div class="row pb-0  modal-footer">
                <input class="btn-sina-submit" type="submit" id="save" value="save" onclick="return confirm('are you sure?');">
            </div>
        </form>
    </div>
</div>
@endsection
@section('script')
<script>
    let productColleection=@json($products);
    $(document).ready(function() {
       $('.select2').select2();
    });
    function getProduct(){
        var category_code = $('#category_code').find('option:selected'); 
        var category_id = category_code.attr("data-category_id");

        var str=`<option value="0">SELECT PRODUCT</option>`;
        for (let index = 0; index < productColleection.length; index++) {
            productColleection[index].id
            if(category_id==productColleection[index].category_id){
               str+=`<option value="`+productColleection[index].id+`">`+productColleection[index].name_eng+`</option>`;
            }
        }
        $('#product_id').html(str);
    }
    function getSum(i){
        var sum=0;
        var stock=parseFloat($('#getStockQty'+i).text());
        //alert(stock);
        $('.showroom_wise_allocation-'+i).each(function(){
            sum += parseFloat(this.value);
        });
        $('#allocated'+i).text(sum);
        $('#closing'+i).text((stock-sum));
        if(stock<sum){
            $('#submit_allocation'+i).attr('disabled',true);
            $('#save').attr('disabled',true);
        }else{
            $('#submit_allocation'+i).attr('disabled',false);
            $('.submit_allocation_try').each(function(){
                $('#save').attr('disabled',true);
                if(!($(this).attr('disabled'))){
                    $('#save').attr('disabled',false);
                }
            })
        }
    }
function deleteRow(id){
    if(confirm('are you sure?')){
// $('.showroom_wise_allocation_qty').
        $.ajax({
                type: "GET",
                // url: "{{route('order.cart_remove')}}",
                data: {
                    cart_id:id,
                },
                success: function (data) {
                    $('#tr'+id).remove();
                },
                error: function (response) {
                },
            });
    }
}
function setAllocationForProduct(i){
    var showrooms=[];
    var qtys=[];
    var pids=[];
    if(confirm('are you sure?')){
    $('.shoowroom-'+i).each(function(){
        //showrooms.push(this.value);
        var showroom=this.value;
        if(showroom){
         var quantity=$('#quantity-'+showroom+'-'+i).val();
         qtys.push(quantity);
         showrooms.push(showroom);
         pids.push(i);
        }
    });
       console.log(qtys);
       console.log(showrooms);
       console.log(pids);
        $.ajax({
                type: "GET",
                url: "{{route('order.store_allocation')}}",
                data: {
                    product_id:pids,
                    showrooms:showrooms,
                    quantity:qtys,
                },
                success: function (data) {
                    $('#tr'+id).remove();
                },
                error: function (response) {
                },
            });
    }
}
</script>
@stop