@php 
    $colspan = 15;
    $custom_labels = json_decode(session('business.custom_labels'), true);
@endphp
<style>
    .form-control{
        height: 25px;
    }
    #bulk_product_table {
        overflow-y: auto;
        height: 300px;
        display: block;
    }
	table {
		text-align: left;
		position: relative;
	}
	  
	#bulk_product_table th {
		position: sticky;
		z-index: 1;
		top: 200;
	}
    thead {
        position: -webkit-sticky; 
        position: sticky; 
        top: 0px; 
        z-index: 200;
        background-color: gray;
        color: #ffffff;
    }
</style>
@php
$currency_precision = session('business.currency_precision', 2);
$quantity_precision = session('business.quantity_precision', 2);
@endphp
<div class="table-responsive">
<div class="col-md-12">
    <table class="table table-borderless table-responsive" id="bulk_product_table">
        <thead>
            <tr>
                <!-- <th><input type="checkbox" id="select-all-row-discount" data-table-id="bulk_product_table"></th> -->
                <th>Updation</th>
          
                <th width="350">@lang('sale.product')</th>
                {{--  <th>Unit</th>  --}}
                <th>MRP</th>
                <th>Disc(%)</th>
                <th>Avail Qty</th>
                <th>Physical Qty</th>
                <th>Balance</th>
                <th>Reasons</th>
                <th>Action</th>
            </tr>
        </thead>
        <tbody>
            @if ($productList)
                @if (isset($productList[0]['ends_at']))
                @php
                    $startDate = $productList[0]['starts_at'];
                    $endDate = $productList[0]['ends_at'];
                @endphp
                    <script>
                        document.getElementById("starts_at").value = '{{@format_datetime($startDate)}}';
                        document.getElementById("ends_at").value = '{{@format_datetime($endDate)}}';
                    </script>
                @endif
                @foreach ($productList as $row)
                    <tr>
                        
                        <input type="hidden" name="location_id_{{ $loop->index }}" id="location_id_{{ $loop->index }}" value="{{ $row['location_id'] }}" class="form-control" >
                        <input type="hidden" name="variation_id_{{ $loop->index }}" id="variation_id_{{ $loop->index }}" value="{{ $row['variation_id'] }}" class="form-control" >
                        <input type="hidden" name="product_id_{{ $loop->index }}" id="product_id_{{ $loop->index }}" value="{{ $row['product_id'] }}" class="form-control" >
                        <input type="hidden" name="vld_id_{{ $loop->index }}" id="vld_id_{{ $loop->index }}" value="{{ $row['vld_id'] }}" class="form-control" >
                       <td>
                       <input type="text" name="product_id[{{ $row['vld_updated_at'] }}]"  value="{{ $row['vld_updated_at'] }}" class="form-control" disabled >

                       </td>
                     
                        <td>
                            <input type="hidden" name="sku[{{ $row['product_id'] }}]" value="{!! $row['sku'] !!}" class="form-control" disabled>
                       
                            <input type="hidden" name="sku[{{ $row['product_id'] }}]" value="{!! $row['sub_sku'] !!}" title="{!! $row['sub_sku'] !!}" class="form-control" disabled >
                        
                       
                            <input type="text" name="name[{{ $row['product_id'] }}]" value="{!! $row['name'] !!}" title="{!! $row['name'] !!}" class="form-control" disabled >
                      <br> <p>SKU- {{$row['sku']}},  Sub Sku-{!! $row['sub_sku'] !!}</p>
                        </td>
                        {{--  <td>
                            <input type="text" name="avl_qty" value="{!! $row['avl_qty'] !!}" class="form-control"  disabled>
                        </td>  --}}
                        <td>
                            {!! Form::text('mrp[' . $row['product_id'] . ']', @num_format($row['mrp']), ['class' => 'form-control input_number inline_mrp', 'disabled']) !!}
                        </td>
                        <td>
                            {!! Form::text('discount['. $row['product_id'] .']', @num_format($row['discount']), ['class' => 'form-control input_number inline_discount']) !!}
                        </td>
                        <td>
                                <input type="text" name="avl_qty_{{ $loop->index }}" id="avl_qty_{{ $loop->index }}" value="{{ $row['avl_qty'] }}" class="form-control" disabled>
                         </td>
                          <td>
                                <input type="text" name="phy_qty_{{ $loop->index }}" id="phy_qty_{{ $loop->index }}" value="0.00" required class="form-control" onchange="calculate_stock({{ $loop->index }})">
                          </td>
                          <td>
                                <input type="text" name="balance_{{ $loop->index }}" id="balance_{{ $loop->index }}" value="0.00" class="form-control" readonly>
                          </td>
                          <td>
                             <select class="form-control"   name="reasons_{{ $loop->index }}" id="reasons_{{ $loop->index }}" style="height:30px;width:100px;" >
                             @foreach($reasons as $reason)
                                  <option value="{{ $reason->name }}" selected>{{ $reason->name }}</option>
                            @endforeach
                           </select>
                           <label style="font-size:12px;display:none" name="reasons_msg_{{ $loop->index }}" id="reasons_msg_{{ $loop->index }}" ></label>
                          </td>
                        <td>
                          <!-- <button type="button" class="btn btn-primary" title="Adjustment" ><i class="fa fa-adjust" aria-hidden="true"></i></button> -->
                          <a href="#" class="btn btn-primary" id="{{ $row['product_id'] }}" onclick="adjustment(this, {{ $loop->index }})" title="Quantity Adjustment"><i class="fa fa-adjust" aria-hidden="true"></i></a>;
                          <a href="/stock-updation-history-log?product_id={{ $row['product_id'] }}" class="btn btn-warning" id="{{ $row['product_id'] }}" title="Stock Updation History Log" ><i class="fa fa-history" aria-hidden="true"></i></a>;
                        </td>
                    </tr>
                @endforeach
                <tr>
                    <td colspan="8"><span id="total_selected"></span></td>
                </tr>
            @else
            <tr>
                <td colspan="8" class="text-danger">No item found!</td>
            </tr>
            @endif
        </tbody>
    </table>
    </div>
</div>

<script>
    function calculate_stock(index) {
        var avl_qty = parseFloat(document.getElementById("avl_qty_" + index).value) || 0;
        var phy_qty = parseFloat(document.getElementById("phy_qty_" + index).value) || 0;
        document.getElementById("balance_" + index).value = (phy_qty - avl_qty).toFixed(2);
        var balance = document.getElementById("balance_" + index).value;
        if(balance<0){
            document.getElementById("balance_" + index).style.color = "red";
        }else{
            document.getElementById("balance_" + index).style.color = "green";
        }

        //====================  Reason ===============================
        var selectElement = document.getElementById("reasons_" + index);
        var msgElement = document.getElementById("reasons_msg_" + index);

        if (balance < 0) {
            selectElement.value = "physical stock less than available stock";
            msgElement.innerText = "physical stock less than available stock";
            msgElement.style.display = "block";
            msgElement.style.color = "red";
        } else if (balance > 0) {
            selectElement.value = "physical stock is greater than available stock";
            msgElement.innerText = "physical stock is greater than available stock";
            msgElement.style.display = "block";
            msgElement.style.color = "green";
        } else {
            selectElement.value = "physical stock ok";
            msgElement.innerText = "physical stock ok";
            msgElement.style.display = "block";
            msgElement.style.color = "blue";
        }
     }
    
    function adjustment(v, index) {
        var product_id = v.id;
        var location_id = document.getElementById("location_id_" + index).value;
        var vld_id = document.getElementById("vld_id_" + index).value;
        var variation_id = document.getElementById("variation_id_" + index).value;
        var avl_qty = parseFloat(document.getElementById("avl_qty_" + index).value) || 0;
        var phy_qty = parseFloat(document.getElementById("phy_qty_" + index).value) || 0;
       
        var balance_qty = document.getElementById("balance_" + index).value || 0;
        var reasons = document.getElementById("reasons_" + index).value || 0;
        // if (phy_qty === 0) {
        //          alert("Physical Quantity can not be Zero");
        //         return; 
        // }
       $.ajax({
            type: 'POST',
            url: "{{ route('stock-updation-adjustment') }}",
            data: {
                _token: "{{ csrf_token() }}",
                product_id: product_id,
                vld_id: vld_id,
                location_id:location_id,
                variation_id:variation_id,
                avl_qty: avl_qty,
                phy_qty: phy_qty,
                balance_qty: balance_qty,
                reasons: reasons
            },
            dataType: 'json',
            success: function(data) {
                console.log(data);
                if (data != '') {
                  alert(data);
                } else {
                   
                }
            }
        });
    }

//      function logHistory(v) {
//         var product_id = v.id;
//         alert(product_id);

//         $.ajax({
//             type: 'GET',
//             url: "{{ route('stock-updation-history-log') }}",
//             data: {
//                product_id: product_id,
//             },
//          // dataType: 'json',
//          success: function(data) {
//             console.log("Test  Success");
//             console.log(data);
//             alert(data.message);
//          },
//          error: function(request, error) {
//             console.log("Test  Error");
//             var error_message = arguments[2];
//             alert(" Error: " + error_message);
//          },
//       });
//    }
</script>