@extends('layouts.default')
@section('content')
@include('select2')

<div class=" well_N ">
  <form action="{{route('issueMaterial')}}" method="post">
    <input type="hidden" name="_token" value="{{ csrf_token() }}">
    <div class="row">
      <div class="col-md-12 ">
        <input type="hidden" value="{{ $material_requisitions->id }}" name="mr_id" id="mr_id">
        <table class="table">
          <thead>
            <th>MR NO</th>
            <th>Finish Good </th>
            <th>Order Qty</th>
            <th>Batch Code</th>
          </thead>
          <tr>
            @php 
          $item = CommonHelper::get_item_by_id($material_requisitions->finish_good_id);
        @endphp
            <td>{{ $material_requisitions->mr_no }}</td>
            <td>{{ $item->item_code . ' -- ' . $item->sub_ic }}</td>
            <td>{{ $material_requisitions->finish_good_qty }}</td>
            <td>{{ ProductionHelper::getNewBatchCode() }}</td>
          </tr>
        </table>
      </div>
      @php
    $production_plane_receipe = ProductionPlaneRecipe::where('master_id', $material_requisitions->id)->where('receipe_id', $material_requisitions->receipt_id)->where('status', 1)->get();

    @endphp
      @foreach($production_plane_receipe as $key_recipe => $recipe)
        @php
        $issuance = MaterialRequisitionData::where('mr_id', $material_requisitions->id)->where('raw_item_id', $recipe->item_id)->where('status', 1)->select(DB::raw('sum(issuance_qty) as issuance_qty'))
        ->first();
    @endphp
        <div class="main_category">
        <div class="col-md-12">
          <table class="table">
          <tbody>
            <tr>
            <td class="hide">
              <label for="">Category</label>
              <select name="category[]" onchange="getOverAllstock(this)" class="form-control category select2"
              id="category">
              @foreach(CommonHelper::get_category()->get() as $category)
          @if($recipe->bom_data_id == $category->id)
        <option selected value="{{$category->id}}">{{$category->main_ic}}</option>
      @endif
        @endforeach
              </select>
            </td>
            <td>
              <label for="">Request Qty</label>
              <input type="text" value="{{$recipe->request_qty}}" readonly class="form-control recipe_qty"
              name="recipe_qty[]" id="required_qty">
            </td>
            <td>
              <label for="">Issued Qty</label>
              <input type="text" readonly class="form-control"
              value="{{isset($issuance->issuance_qty) ? $issuance->issuance_qty : 0}}" name="Issued_qty[]"
              id="Issued_qty">
            </td>
            <td>
              <label for="">Remaining Qty</label>
              <input type="text" readonly class="form-control remaining_qty"
              value="{{isset($issuance->issuance_qty) ? $recipe->request_qty - $issuance->issuance_qty : $recipe->request_qty - 0}}"
              id="remaining_qty">
            </td>
            <td></td>
            <td></td>
            <td></td>
            </tr>
            <tr>
            <th>Product Name</th>
            <th class="col-sm-1">Production Stock</th>
            <th>warehouse</th>
            <th>batch code</th>
            <th>In Stock </th>
            <th>Total Qty issue</th>
            <th>issue date</th>
            </tr>
          </tbody>
          <tbody class="add">
            <tr class="">
            <input type="button" style="background-color: limegreen; color: white; text-align: center;"
              class="btn addRowTrigger hide" data-category-id="{{ $recipe->bom_data_id }}"
              data-item-id="{{ $recipe->item_id }}" data-count="{{ $count }}" value="+">
            </tr>
            <script>
            window.onload = function () {
              // Loop through all instances that require `addRow` on page load
              document.querySelectorAll('.addRowTrigger').forEach((button) => {
              // Extract attributes for category_id, item_id, and count dynamically
              const category_id = button.getAttribute('data-category-id');
              const item_id = button.getAttribute('data-item-id');
              const count = button.getAttribute('data-count');

              // Call the addRow function for each button
              addRow(button, category_id, item_id, count);
              });
            };
            </script>

            @php 
          $count++;
      @endphp
            @if($recipe->bom_data_item_id != 0)
          <tr class="main" id="remove{{$count}}">
          <td class="hide">
            <select class="form-control" name="recipe_item[]">
            @foreach(CommonHelper::get_all_subitem() as $subitem)
        @if($subitem->id == $recipe->bom_data_item_id)
      <option selected value="{{$subitem->id}}">{{$subitem->sub_ic}}</option>
    @endif
      @endforeach
            </select>
          </td>
          <td>
            <select id="item{{$count}}" onchange="getStock1(this)" class="form-control item select2 "
            name="item[]">
            @foreach(CommonHelper::get_all_subitem() as $subitem)
        @if($subitem->id == $recipe->bom_data_item_id)
      <option selected value="{{$subitem->id}}">{{$subitem->sub_ic}}</option>
    @endif
      @endforeach
            </select>
          </td>
          <td>
            <select onchange="getStock1(this)" class="form-control warehouse_id select2" name="warehouse_id[]"
            id="">
            <option value="">Select Warehouse</option>
            @foreach(CommonHelper::get_all_warehouse() as $warehouse)
        <option value="{{$warehouse->id}}">{{$warehouse->name}}</option>
      @endforeach
            </select>
          </td>
          <td>
            <input type="number" readonly class="form-control in_stock" name="in_stock[]" id="">
          </td>
          <td>
            <input type="number" class="form-control required_qty" name="required_qty[]" id="">
          </td>
          <!-- <td>
          @if($count > 1)
        {
        <input type="button" onclick="removes('{{$count}}')" class="btn btn-danger" value="-">
        }
        @endif
        </td> -->
          </tr>
      @endif
          </tbody>
          </table>
        </div>
        </div>

        @if((count($production_plane_receipe) - 1) == $key_recipe)
        <div class="main_category">
        <div class="col-md-12">
          <table class="table">
          <tbody>
          <!-- <tr>
        <td>
          <label for="">Category</label>
          <select name="category[]" onchange="getItemByCategoryRaw(this,this.value)"
          class="form-control category select2" id="category_raw">
          @foreach(CommonHelper::get_sub_category()->get() as $sub_category)
        <option value="{{$sub_category->id}}">{{$sub_category->sub_category_name}}</option>
        @endforeach
          </select>
        </td>
        <td>
          <label for="">Request Qty</label>
          <input type="text" value="0" readonly class="form-control" name="recipe_qty[]" id="required_qty">
        </td>
        <td>
          <label for="">Issued Qty</label>
          <input type="text" readonly class="form-control"
          value="{{isset($issuance->issuance_qty) ? $issuance->issuance_qty : 0}}" name="Issued_qty[]"
          id="Issued_qty">
        </td>
        <td>
          <label for="">Remaining Qty</label>
          <input type="text" readonly class="form-control" value="0" id="">
        </td>
        <td></td>
        <td></td>
        </tr> -->
          <!-- <tr>
        <th>Product Name</th>
        <th>warehouse</th>
        <th>batch code</th>
        <th>In Stock </th>
        <th>Total Qty issue</th>
        <th>issue date</th>
        </tr> -->
          </tbody>

          <!-- <tbody class="add">
        <tr>
        <input type="button" style="background-color: limegreen; color: white; text-align: center;"
          onclick="addRowForRawMaterial(this,'','',{{ $count }})" class="btn" value="add raw material" id="">
        </tr>

        @php 
        $count++;
        @endphp
        @if($recipe->bom_data_item_id != 0)
        <tr class="main" id="remove{{$count}}">
        <td>
        <select id="item{{$count}}" onchange="getStock1(this)" class="form-control item select2 "
        name="item[]">

        @foreach(CommonHelper::get_all_subitem() as $subitem)
        @if($subitem->id == $recipe->bom_data_item_id)
        <option selected value="{{$subitem->id}}">{{$subitem->sub_ic}}</option>
        @endif
        @endforeach
        </select>
        </td>
        <td>
        <select onchange="getStock1(this)" class="form-control warehouse_id select2" name="warehouse_id[]"
        id="">
        <option value="">Select Warehouse</option>
        @foreach(CommonHelper::get_all_warehouse() as $warehouse)
        <option value="{{$warehouse->id}}">{{$warehouse->name}}</option>
        @endforeach
        </select>
        </td>
        <td>
        <input type="number" readonly class="form-control in_stock" name="in_stock[]" id="">
        </td>
        <td>
        <input type="number" class="form-control" name="required_qty[]" id="">
        </td>
        <td>
        @if($count > 1)
        {
        <input type="button" onclick="removes('{{$count}}')" class="btn btn-danger" value="-">
        }
        @endif
        </td>
        </tr>
        @endif
        </tbody> -->
          </table>
        </div>
        </div>
    @endif
    @endforeach
    </div>
    <div class="col-md-12 padtb text-right">
      <div class="col-md-9"></div>
      <div class="col-md-3 my-lab">
        <button type="submit" class="btn btn-primary mr-1 btn-success" data-dismiss="modal">Save</button>
        <button type="button" class="btnn btn-secondary " data-dismiss="modal">Cancel</button>
      </div>
    </div>
  </form>
</div>

<script>

  function getStock1(datas) {
    var ids = $(datas).closest('.main').find('.item').val();
    var warehouse_id = $(datas).closest('.main').find('.warehouse_id').val();
    var batch_code = $(datas).closest('.main').find('.batch_code').val();

    $.ajax({
      url: '