@extends('admin.layout.master')
@section('title','ALLOCATION MANAGEMENT')
@section('custom_style')
<style>
   .table-wrp {
  max-width: 100%;
  max-height: calc(100vh - 270px);
  overflow: scroll;
  position: relative;
}

table {
  position: relative;
  border-collapse: collapse;
  border-collapse: separate;
  border-spacing: 0;
}

td,
th {
  padding: 10px;
}

thead th {
  position: -webkit-sticky; /* for Safari */
  position: sticky;
  top: 0;
  background: rgb(255, 255, 255);
  color: rgb(0, 0, 0);
  z-index: 1;
  border: 1px solid red;
  text-align: center;
}

thead th:first-child {
  
  z-index: 2;
}

tbody th:first-child{
  position: -webkit-sticky; /* for Safari */
  position: sticky;
  left: 0;
  background: #FFF;
  z-index: 3;
}

tbody th:nth-child(2){
  position: -webkit-sticky; /* for Safari */
  position: sticky;
  
  left: 31px;
  background: #FFF;
  z-index: 3;
}
tbody th:nth-child(3) {
  position: -webkit-sticky; /* for Safari */
  position: sticky;
  left: 104px;
  background: #FFF;
  z-index: 3;
}
tbody th:nth-child(4) {
  position: -webkit-sticky; /* for Safari */
  position: sticky;
  left: 163px;
  background: #FFF;
  z-index: 3;
}


 .first-head-tr th:nth-child(1){
  position: -webkit-sticky; /* for Safari */
  position: sticky;
  left: 0;
  background: #FFF;
  z-index: 4;
}
 .first-head-tr th:nth-child(2) {
  position: -webkit-sticky; /* for Safari */
  position: sticky;
  
  left: 31px;
  background: #FFF;
  z-index: 4;
}
 .first-head-tr th:nth-child(3) {
  position: -webkit-sticky; /* for Safari */
  position: sticky;
  left: 104px;
  background: #FFF;
  z-index: 4;
  }
 .first-head-tr th:nth-child(4) {
  position: -webkit-sticky; /* for Safari */
  position: sticky;
  left: 163px;
  background: #FFF;
  z-index: 4;
}



tr td:last-child{
 position: -webkit-sticky; /* for Safari */
  position: sticky;
  right: 0;
  background: rgb(255, 255, 255);
  z-index: 0;
  
}
.second-head-tr > th{
    top:43px;
}

.first-head-tr th:nth-child(1){

}
</style>
@endsection
@section ('content')
<div class="card sina-card mb-0">
    <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="row justify-content-end">
                <div class="input-group col-3">
                    <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> --}}
                    <select name="category_code" id="category_code" style="width: 100%" 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 class="col-3">
                    <label for="product_id">Product</label>
                    <div class="input-group">
                        <div class="input-group input-group-append">
                        <select name="product_id"  style="width: 85%" 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>
                        <button type="submit" style="width:15%;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-1 pl-0">
                    <label></label>
                    <div class="input-group">
                        <div class="input-group input-group-append">
                            <input type="date" class="form-control bsdatepicker" id="start_date" name="start_date" value="{{Request()->start_date?date('Y-m-d',strtotime(Request()->start_date)):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="end_date" name="end_date" value="{{Request()->end_date?date('Y-m-d',strtotime(Request()->end_date)):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>
                {{-- <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>
       <hr>
        <form id="form" method="post" action="{{ route('order.mass_allocation_store') }}" name="form" enctype="multipart/form-data">
            @csrf
            <div class="table-wrp">
                <table>
                  <thead>
                    @php
                        $tr='<tr class="second-head-tr">';
                    @endphp
                    <tr class="first-head-tr">
                        <th rowspan="2">#</th>
                        <th rowspan="2">PRODUCT</th>
                        <th rowspan="2">STOCK</th>
                        <th rowspan="2">ORDER</th>
                        @forelse ($showRooms as $a=>$showRoomGroup)
                        @if($a!='')
                             <th colspan="2" class="text-center" >{{$showRoomGroup->first()->showroom->name_eng}}</th>  
                            @php
                                $tr.='<th>OrderQty</th><th>Allot. Qty</th>';
                            @endphp  
                        @endif
                            @empty
                        @endforelse
                        <th rowspan="2">Allocated</th>
                        <th rowspan="2">Closing</th>
                        <th rowspan="2">Action</th>
                    </tr>
                    {!! $tr.'</tr>' !!}
                  </thead>
                  <tbody>
                    @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
                    <td id="allocated{{$i}}">{{$item->where('transaction_type','!=',3)->sum('allocated_qty') }}</td>
                    <td id="closing{{$i}}">{{ $closing }}</td>
                    <td><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></td>
                   
                </tr>
                @empty
                @endforelse
                   
           
                  </tbody>
                </table>
              </div>
              <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