@php
    use App\Product;
    use App\BusinessLocation;
    use Illuminate\Support\Facades\DB;

    $main_product = DB::table('product_locations')
        ->where('product_id', $product->product_id)
        ->where('location_id', $location_id)
        ->first();

@endphp
<tr class="product_row">
    <td>
        <span id="span_prodcut_name">{{ $product->product_name }} ({{ $product->sub_sku }})</span>
        <br>
        <small><strong>Re-order level:</strong> {{ $main_product->product_re_order_level }}
            {{ $product->unit }}</small>
        <input type="hidden" name="" id="product_id" value="{{ $product->product_id }}">
        <input type="hidden" name="" id="variation_id" value="{{ $product->variation_id }}">
        <input type="hidden" name="" id="location_from_current_stock" value="{{ $product->qty_available }}">
        <input type="hidden" class="form-control" name="" id="re_order_level"
            value="{{ $main_product->product_re_order_level }}" disabled>
    </td>
    <td>
        <span class="qty_available_column">{{ number_format($product->qty_available, 2) }}</span>
        <span>{{ $product->unit }}</span>
    </td>
    @php
        $user_id = request()->session()->get('user.id');
        // $business_locations = BusinessLocation::where('business_locations.id', '!=', $location_id)->orderBy('id', 'ASC');
        // $business_locations = $business_locations->get();
        // $business_locations = UserAccessStockTransferLocation::where('id', '!=', $location_id)->where('location_type', 'to')->get();
        // $permitted_locations = auth()->user()->permitted_locations();
        // if ($permitted_locations != 'all') {
        //     $business_locations->whereIn('id', $permitted_locations);
        // }
        if ($is_admin) {
            $business_locations = BusinessLocation::where('id', '!=', $location_id)
                ->orderBy('id', 'ASC')
                ->where('is_stock_location', '0')
                ->select('business_locations.*', 'business_locations.id as location_id')
                ->Active();
            $business_locations = $business_locations->get();
        } else {
            $business_locations = BusinessLocation::join(
                'user_access_stock_transfer_locations',
                'user_access_stock_transfer_locations.location_id',
                '=',
                'business_locations.id',
            )
                ->where('is_stock_location', '0')
                ->where('business_locations.id', '!=', $location_id)
                ->where('user_access_stock_transfer_locations.user_id', '=', $user_id)
                ->where('user_access_stock_transfer_locations.location_type', 'to')
                ->orderBy('business_locations.id', 'ASC')
                ->select('business_locations.*', 'user_access_stock_transfer_locations.location_id as location_id')
                ->get();
        }
    @endphp
    @foreach ($business_locations as $business_location)
        {{-- @if ($business_location->is_stock_location == '0') --}}
        <td>
            <div class="input-group input-number">
                <span class="input-group-btn"><button type="button" class="btn btn-default btn-flat qty_down"><i
                            class="fa fa-minus text-danger"></i></button></span>
                <input type="text" data-min="0" class="form-control reorder_quantity input_number mousetrap"
                    name="reorder_quantity[]" value="0" style="min-width: 100px;">
                <span class="input-group-btn"><button type="button" class="btn btn-default btn-flat qty_up"><i
                            class="fa fa-plus text-success"></i></button></span>
            </div>
            @php
                $qty_available = Product::leftJoin(
                    'variation_location_details as VLD',
                    'VLD.product_id',
                    '=',
                    'products.id',
                )
                    ->where('VLD.product_id', $product->product_id)
                    ->where('VLD.location_id', $business_location->location_id)
                    ->sum('VLD.qty_available');

                $product_location = DB::table('product_locations')
                    ->where('product_id', $product->product_id)
                    ->where('location_id', $business_location->location_id)
                    ->first();

                $color = 'red';
                if (!empty($product_location->product_max_order_level)) {
                    $product_max_order_level = $product_location->product_max_order_level;
                } else {
                    $product_max_order_level = 0;
                }
                if (!empty($product_location->product_re_order_level)) {
                    $product_re_order_level = $product_location->product_re_order_level;
                } else {
                    $product_re_order_level = 0;
                }
                if ($qty_available <= $product_max_order_level && $qty_available >= $product_re_order_level) {
                    $color = 'green';
                }

            @endphp

            <input type="hidden" id="previous_quantity" value="{{ number_format($qty_available, 2) }}">

            <small class="text_color" style="font-weight: bold; color: {{ $color }}"><strong>Current
                    Stock:</strong> <span class="span_current_qty">{{ number_format($qty_available, 2) }}</span>
                {{ $product->unit }}</small>
            <br>

            <small><strong>Re-order level:</strong> <span class="span_re_order_level">
                    @if (!empty($product_location->product_re_order_level))
                        {{ $product_location->product_re_order_level }}
                    @endif
                </span>
                {{ $product->unit }}</small>
            <br>
            <small><strong>Max-order level:</strong> <span class="span_max_order_level">
                    @if (!empty($product_location->product_max_order_level))
                        {{ $product_location->product_max_order_level }}
                    @endif
                </span>
                {{ $product->unit }}</small>
            <br>

            @php
                $requirement = 0;

                if ($product_re_order_level > $qty_available) {
                    $requirement = $product_re_order_level - $qty_available;
                }
            @endphp

            <small><strong>Requirement:</strong>
                <span class="span_requirement">{{ number_format($requirement, 2) }}</span>
            </small>
            <small>{{ $product->unit }}</small>
            <input type="hidden" name="location_id[]" id="" value="{{ $business_location->location_id }}">
            <input type="hidden" name="product_id[]" value="{{ $product->product_id }}">
            <input type="hidden" name="variation_id[]" value="{{ $product->variation_id }}">
            <input type="hidden" name="last_purchased_price[]" id=""
                value="{{ $product->last_purchased_price }}">
        </td>
        {{-- @endif --}}
    @endforeach

    <td class="text-center">
        <i class="fa fa-trash remove_product_row cursor-pointer" aria-hidden="true"></i>
    </td>
    <td>
        <input type="hidden" id="row_valid" value="@if ($product->re_order_level > $product->qty_available) 0 @else 1 @endif">
    </td>
</tr>