@extends('layouts.master')
@section('page_title', 'Bulk Edit Product')
@section('title', 'Bulk Products Details')
@section('main_item', 'Bulk Products')
@section('sub_item', 'Edit Products')
@section('content')
    <div class="col-md-12">
        <div class="card card-border">
            <form action="{{ route('products.bulk_product_update') }}" method="post">
                @csrf
                <div class="card-body">
                    <h4 class="card-title mt-0">Bulk Edit</h4>
                    @foreach ($products as $key => $product)
                        <div class="card card-border">
                            <div class="card-body">
                                <h4 class="card-title mt-0">{{ $product->product_name }}</h4>
                                <div class="row">
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label style="font-weight: bold" for="product_name">Product Name</label>
                                            <input type="hidden" name="products[{{ $key }}][product_id]"
                                                value="{{ $product->id }}">
                                            <input type="text" class="form-control" placeholder="Product Name"
                                                id="product_name" name="products[{{ $key }}][product_name]"
                                                required="" value="{{ $product->product_name }}">
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label style="font-weight: bold" for="category">Category</label>
                                            <select class="form-control required_combo" id="category" name="products[{{ $key }}][category_id]" required>
                                                <option value="">Select</option>
                                                @foreach ($categories as $category)
                                                    @if ($category->id == $product->category_id)
                                                        <option value="{{ $category->id }}" selected>{{ $category->category_name }}
                                                        </option>
                                                    @else
                                                        <option value="{{ $category->id }}">{{ $category->category_name }}</option>
                                                    @endif
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label style="font-weight: bold" for="sub_category_id">Sub Category</label>
                                            <select class="form-control select2" id="sub_category_id" name="products[{{ $key }}][sub_category_id][]" multiple="multiple">
                                                @php
                                                    $selected_subcategories = $product_has_sub_categories[$product->id] ?? [];
                                                    $available_subcategories = $sub_categories[$product->id] ?? collect();
                                                @endphp
                                    
                                                @foreach ($available_subcategories as $sub_category)
                                                    <option value="{{ $sub_category->id }}" 
                                                        {{ in_array($sub_category->id, $selected_subcategories) ? 'selected' : '' }}>
                                                        {{ $sub_category->sub_category_name }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label style="font-weight: bold" for="unit">Unit</label>
                                            <select class="form-control required_combo" id="unit" name="products[{{ $key }}][unit_id]" required>
                                                <option value="">Select</option>
                                                @foreach ($units as $unit)
                                                    @if ($unit->id == $product->unit_id)
                                                        <option value="{{ $unit->id }}" selected>
                                                            {{ $unit->actual_name . ' (' . $unit->short_name . ')' }}</option>
                                                    @else
                                                        <option value="{{ $unit->id }}">
                                                            {{ $unit->actual_name . ' (' . $unit->short_name . ')' }}</option>
                                                    @endif
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label style="font-weight: bold" for="sku">SKU</label>
                                            <input type="text" class="form-control" placeholder="SKU" id="sku" name="products[{{ $key }}][sku]"
                                                value="{{ $product->sku }}">
                                        </div>
                                    </div>
                                    <div class="col-md-4 mt-4">
                                        <div class="custom-control custom-checkbox">
                                            <input type="checkbox" class="custom-control-input"
                                                id="allow_woocommerce_sync{{ $key }}"
                                                data-parsley-multiple="groups" data-parsley-mincheck="1"
                                                name="products[{{ $key }}][allow_woocommerce_sync]"
                                                @if ($product->allow_woocommerce_sync) checked @endif>
                                            <label class="custom-control-label"
                                                for="allow_woocommerce_sync{{ $key }}">Allow
                                                Woocomerce
                                                Sync</label>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label style="font-weight: bold" for="reorder_level">Re-order Level</label>
                                            <input type="number" step="0.01" class="form-control"
                                                placeholder="Re-order Level" id="reorder_level"
                                                name="products[{{ $key }}][reorder_level]" required=""
                                                value="{{ $product->reorder_level }}">
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label style="font-weight: bold">Warranty Period Type</label>
                                            <select class="form-control" id="warranty_select"
                                                name="products[{{ $key }}][warranty_select]">
                                                <option value="">Select</option>
                                                <option value="month"
                                                    {{ (old('warranty_select') ? old('warranty_select') : $product->warranty_select ?? '') == 'month' ? 'selected' : '' }}>
                                                    Month</option>
                                                <option value="year"
                                                    {{ (old('warranty_select') ? old('warranty_select') : $product->warranty_select ?? '') == 'year' ? 'selected' : '' }}>
                                                    Year</option>
                                                <option value="day"
                                                    {{ (old('warranty_select') ? old('warranty_select') : $product->warranty_select ?? '') == 'day' ? 'selected' : '' }}>
                                                    Day</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label style="font-weight: bold">Warranty Period</label>
                                            <input type="number" step="0.01" class="form-control"
                                                placeholder="Warranty Period" id="warranty_period"
                                                name="products[{{ $key }}][warranty_period]"
                                                value="{{ $product->warranty_period }}">
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="required" style="font-weight: bold" for="activate_code">business
                                                Location</label>                                            
                                            <select class="form-control select2" id="location_id" name="products[{{ $key }}][location_id][]" multiple="multiple" required>
                                                @foreach ($users_access_location as $business_location)
                                                    @php
                                                        $selected_locations = $product_has_business_locations[$product->id] ?? [];
                                                    @endphp
                                        
                                                    <option value="{{ $business_location->id }}"
                                                        {{ in_array($business_location->id, $selected_locations) ? 'selected' : '' }}>
                                                        {{ $business_location->name }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    @php
                                        $stock = App\Stock::where('product_id', $product->id)->first();
                                    @endphp
                                    @if (empty($product->attribute_id))
                                        <div class="col-md-4">
                                            <div class="form-group">
                                                <label style="font-weight: bold" for="unit_cost">Unit Cost</label>
                                                <input type="hidden" id="stock_id"
                                                    name="products[{{ $key }}][stock_id]"
                                                    value="{{ $stock->id }}">
                                                <input type="hidden" id="product_type"
                                                    name="products[{{ $key }}][product_type]" value="single">
                                                <input type="number" step="0.01" class="form-control"
                                                    placeholder="Unit Cost" id="unit_cost"
                                                    name="products[{{ $key }}][unit_cost]" required=""
                                                    value="{{ $stock->unit_cost }}">
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <div class="form-group">
                                                <label style="font-weight: bold" for="unit_price">Selling Price</label>
                                                <input type="number" step="0.01" class="form-control"
                                                    placeholder="Selling Price" id="unit_price"
                                                    name="products[{{ $key }}][unit_price]" required=""
                                                    value="{{ $stock->unit_price }}">
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <div class="form-group">
                                                <label style="font-weight: bold" for="available_qty">Availabel
                                                    Quantity</label>
                                                <input type="number" step="0.01" class="form-control"
                                                    placeholder="Available Quantity" id="qty"
                                                    name="products[{{ $key }}][qty]" required=""
                                                    @if (!empty($stock->qty)) value="{{ $stock->qty }}" @else value="0" @endif>
                                            </div>
                                        </div>
                                        
                                    @else
                                        
                                        <div class="col-md-4">
                                            <div class="form-group">
                                                <label style="font-weight: bold" for="secondary_mobile">Attribute</label>
                                                <select class="form-control" id="att_id" data-product-id="{{ $product->id }}" name="attribute_id" required>
                                                    <option value="{{ $product->attribute_id }}">
                                                        {{ $product->attribute->attribute_name }}</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-4 pt-4" id="attri_btn">
                                            <div class="form-group">
                                                <a class="btn btn-primary attribute-btn" data-product-id="{{ $product->id }}" style="color: white;">Add Attribute</a>
                                            </div>
                                        </div>
                                        <div class="col-md-12">
                                            <div class="table-responsive">
                                                <table id="attribute-table"
                                                    class="table table-bordered mb-0 table-centered">
                                                    <thead class="thead-dark">
                                                        <tr>
                                                            <th>Variation</th>
                                                            <th>Variation Value</th>
                                                            {{-- <th>Sub Variation Value</th> --}}
                                                            <th>Quantity</th>
                                                            <th>Unit Price</th>
                                                            <th>Selling Price</th>
                                                            <th>Second Price</th>
                                                        </tr>
                                                    </thead>
                                                    @php
                                                        $child_products = App\Product::where('parent_product_id', $product->id)
                                                                            ->orWhere('id', $product->id)
                                                                            ->get();
                                                    @endphp
                                                    <tbody class="attribute-value-tbody" data-product-id="{{ $product->id }}">

                                                        @foreach ($child_products as $child_key => $child_product)
                                                            @php
                                                                $attribute = App\Attribute::find($child_product->attribute_id);
                                                            @endphp
                                                            <tr>
                                                                <td>{{ $attribute->attribute_name }}</td>
                                                                <td>{{ $child_product->attribute_value }}</td>
                                                                <td>
                                                                    <div>
                                                                        <input type="hidden" name="attribute_values[{{ $key }}][{{ $child_key }}][product_id]" value="{{ $child_product->id }}">
                                                                        <input type="hidden" name="attribute_values[{{ $key }}][{{ $child_key }}][attribute_value_id]" value="{{ $child_product->attribute_value_id }}">
                                                                        <input type="hidden" name="attribute_values[{{ $key }}][{{ $child_key }}][attribute_value]" value="{{ $child_product->attribute_value }}">
                                                                        <input class="form-control" type="number" name="attribute_values[{{ $key }}][{{ $child_key }}][qty]" value="{{ $child_product->stock->qty }}">
                                                                    </div>
                                                                </td>
                                                                <td>
                                                                    <div>
                                                                        <input type="number" step="0.01" class="form-control" name="attribute_values[{{ $key }}][{{ $child_key }}][unit_cost]" value="{{ $child_product->stock->unit_cost }}">
                                                                    </div>
                                                                </td>
                                                                <td>
                                                                    <div>
                                                                        <input type="number" step="0.01" class="form-control" name="attribute_values[{{ $key }}][{{ $child_key }}][unit_price]" value="{{ $child_product->stock->unit_price }}">
                                                                    </div>
                                                                </td>
                                                                <td>
                                                                    <div>
                                                                        <input type="number" step="0.01" class="form-control" name="attribute_values[{{ $key }}][{{ $child_key }}][second_price]" value="{{ $child_product->stock->second_price }}">
                                                                    </div>
                                                                </td>
                                                            </tr>
                                                        @endforeach
                                                    </tbody>
                                                </table>
                                                <!--end /table-->
                                            </div>
                                            <!--end /tableresponsive-->
                                        </div>
                                    @endif
                  
                                </div>
                            </div>
                            <!--end card -body-->
                        </div>
                        <!--end card-->
                    @endforeach
                </div>
                <!--end card -body-->
                <p class="card-footer bg-light m-0">
                    <button type="submit" class="btn btn-primary">Bulk Update</button>
                </p>
            </form>
        </div>
        <!--end card-->
    </div>
    <!--end col-->
@endsection
@section('scripts')
    <script>
        $(document).on('click', "#attribute-value-tbody input[type='number']", function() {
            $(this).select();
        });
        $(document).on('click', '.attribute-btn', function () {
            let productId = $(this).data('product-id');
            let parentBlock = $(this).closest('.col-md-12');
            let attributeTable = parentBlock.find('.attribute-value-tbody[data-product-id="' + productId + '"]'); // Find matching table

            let id = parentBlock.find('#att_id[data-product-id="' + productId + '"]').val();
            if (!id) {
                attributeTable.empty();
                return false;
            }
            let url = "{{ route('products.get_attribute_values', ':id') }}";
            url = url.replace(':id', id);

            let lastKey = attributeTable.find('tr').length;

            let allProducts = $('.attribute-btn');
            let p_key = allProducts.index(this);            

            $.ajax({
                method: 'GET',
                url: url,
                data: { 
                    key: lastKey, 
                    p_key: p_key,
                    parent: productId,
                },
                success: function (result) {
                    attributeTable.append(result);
                },
            });
        });
        $(document).on('click', 'button.apply-all-qty', function() {
            var val = $(this).closest('tr').find('.qty').val();            
            var target_class = $(this).data('target-class');
            $(this).closest('tbody').find('tr').each(function() {
                element = $(this).find(target_class);
                element.val(val);
                element.change();
            });
        });
        $(document).on('click', 'button.apply-all-cost', function() {
            var val = $(this).closest('tr').find('.unit_cost').val();
            var target_class = $(this).data('target-class');
            $(this).closest('tbody').find('tr').each(function() {
                element = $(this).find(target_class);
                element.val(val);
                element.change();
            });
        });
        $(document).on('click', 'button.apply-all-price', function() {
            var val = $(this).closest('tr').find('.unit_price').val();
            var target_class = $(this).data('target-class');
            $(this).closest('tbody').find('tr').each(function() {
                element = $(this).find(target_class);
                element.val(val);
                element.change();
            });
        });
        $(document).on('click', '#remove-value', function() {
            this.closest('tr').remove();
        })
        $(document).on('change', '#category', function() {
            let id = $(this).val();
            let select = '<option value="">Select</option>'
            if (id !== '') {
                let url = "{{ route('categories.get_sub_categories', ':id') }}";
                url = url.replace(':id', id);
                $.ajax({
                    method: 'GET',
                    url: url,
                    success: function(response) {
                        $('#sub_category_id').empty().html(response);
                    },
                    error: function(response) {
                        $('#sub_category_id').empty();
                    }
                });
            } else {
                $('#sub_category_id').empty();
            }
        });
    </script>
@endsection