{{-- <x-backend.layouts.master>
    <!-- packages/YourVendor/ProductionTracking/resources/views/jobs/edit.blade.php -->
    <!--message show in .swl sweet alert-->
    @if (session('message'))
        <script>
            Swal.fire({
                icon: 'success',
                title: 'Success',
                text: "{{ session('message') }}",
                showConfirmButton: false,
                timer: 2000
            });
        </script>
    @endif

    <x-backend.layouts.elements.errors />
    <div class="container">
        <h1 class="text-center">Update Sewing Balance</h1>
        <form action="{{ route('sewing_balances_store', $jobs_no) }}" method="POST">
            @csrf

            <div class="row p-1">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">
                            <input type="hidden" name="created_by" value="{{ auth()->user()->id }}">
                            <input type="hidden" name="division_id" value="2">
                            <input type="hidden" name="division_name" value="Factory">
                            <input type="hidden" name="company_id" value="3">
                            <input type="hidden" name="company_name" value="FAL - Factory">
                            <table class="table">
                                <tbody>
                                    <tr>
                                        <td class="create_label_column">Job No</td>
                                        <td class="create_input_column">
                                            <input type="text" name="job_no" class="form-control"
                                                placeholder="Job No" value="{{ $jobs_no }}" readonly>
                                        </td>
                                        <td class="create_label_column">Buyer</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->buyer }}
                                        </td>
                                        <td class="create_label_column">Style</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->style }}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="create_label_column">PO</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->po }}
                                        </td>
                                        <td class="create_label_column">Department</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->department }}
                                        </td>
                                        <td class="create_label_column">Item</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->item }}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="create_label_column">Destination</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->destination }}
                                        </td>
                                        <td class="create_label_column">Order Quantity</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->order_quantity }}
                                        </td>
                                        <td class="create_label_column">Sweing Balance</td>
                                        <td class="create_input_column">
                                            <input type="number" name="sewing_balance" class="form-control"
                                                placeholder="Sewing Balance"
                                                value="{{ $old_sewing_basic_info->sewing_balance }}" required readonly
                                                id="sewing_balance">
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="create_label_column">Production Plan</td>
                                        <td class="create_input_column">
                                            <input type="month" name="production_plan" class="form-control"
                                                placeholder="Production Plan" required
                                                value="{{ $old_sewing_basic_info->production_plan }}">
                                        </td>
                                        <td class="create_label_column">Target SMV</td>
                                        <td class="create_input_column">
                                            <input type="number" step="0.01" name="target_smv" class="form-control"
                                                placeholder="Target SMV" value="{{ $basic_info->target_smv }}" required
                                                readonly id="target_smv">
                                        </td>
                                        <td class="create_label_column">Production Min Balance</td>
                                        <td class="create_input_column">
                                            <input type="number" step="0.01" name="production_min_balance"
                                                class="form-control" placeholder="Production Min Balance" required
                                                readonly id="production_min_balance"
                                                value="{{ $old_sewing_basic_info->production_min_balance }}">
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                            <table class="table table-bordered mt-2 text-center" id="colorWayTable">
                                <thead>
                                    <tr>
                                        <th>Color</th>
                                        <th>Size</th>
                                        <th>Remain Quantity</th>
                                        <th>Sewing Quantity</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($old_sewing_balances as $color)
                                        <tr>
                                            <input type="hidden" name="color_id[]" value="{{ $color->id }}">
                                            <td>
                                                <input type="text" name="color[]" class="form-control"
                                                    placeholder="Color" value="{{ $color->color }}" readonly>
                                            </td>
                                            <td>
                                                <input type="text" name="size[]" class="form-control"
                                                    placeholder="Size" value="{{ $color->size }}" readonly>
                                            </td>
                                            <td>
                                                @php
                                                    $total_sewing_qty = 0;
                                                    $order_qty = $color_sizes_qties
                                                        ->where('id', $color->job_id)
                                                        ->sum('color_quantity');
                                                    $remaining_qty = $old_sewing_balances
                                                        ->where('color_id', $color->id)
                                                        ->sum('sewing_balance');
                                                    if ($remaining_qty > 0) {
                                                        $total_sewing_qty = $remaining_qty;
                                                    } else {
                                                        $total_sewing_qty = 0;
                                                    }
                                                    $remain_qty = $order_qty - $total_sewing_qty;

                                                @endphp
                                                <input type="number" name="color_quantity[]" class="form-control"
                                                    placeholder="Quantity" value="{{ $remain_qty }}" readonly>
                                            </td>
                                            <td>
                                                <input type="number" name="sewing_quantity[]"
                                                    class="form-control sewing_quantity" placeholder="Sewing Quantity"
                                                    value="{{ $color->sewing_balance }}">
                                                <input type="hidden" name="old_sewing_quantity[]"
                                                    value="{{ $color->sewing_balance }}">
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>

                            <div class="button-container">
                                <a href="{{ route('jobs.index') }}" class="btn btn-outline-secondary">
                                    <i class="fas fa-arrow-left"></i> Cancel
                                </a>
                                <button type="submit" id="saveButton" class="btn btn-outline-success">
                                    <i class="fas fa-save"></i> Update Balance
                                </button>

                            </div>
        </form>
    </div>

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>

 

    <script>
        $(document).ready(function() {
            $('#style-select').select2();
            $('#po-select').select2();
            $('#department-select').select2();

            calculateSewingBalance();
            calculateProductionMinBalance();

            $('.sewing_quantity').on('input', function() {
                const maxQuantity = parseInt($(this).closest('tr').find('[name="color_quantity[]"]')
                .val()) || 0;
                let sewingQuantity = parseInt($(this).val()) || 0;

                if (sewingQuantity > maxQuantity) {
                    sewingQuantity = maxQuantity;
                }

                $(this).val(sewingQuantity);

                calculateSewingBalance();
                calculateProductionMinBalance();
            });

            function calculateSewingBalance() {
                let totalSewingQuantity = 0;
                $('.sewing_quantity').each(function() {
                    totalSewingQuantity += parseInt($(this).val()) || 0;
                });
                $('#sewing_balance').val(totalSewingQuantity);
            }

            function calculateProductionMinBalance() {
                const sewingBalance = parseInt($('#sewing_balance').val()) || 0;
                const targetSmv = parseFloat($('#target_smv').val()) || 0;
                const productionMinBalance = (sewingBalance * targetSmv).toFixed(2);
                $('#production_min_balance').val(productionMinBalance);
            }
        });
    </script>
</x-backend.layouts.master> --}}

<x-backend.layouts.master>
    <!-- Sweet Alert for Success Messages -->
    @if (session('message'))
        <script>
            Swal.fire({
                icon: 'success',
                title: 'Success',
                text: "{{ session('message') }}",
                showConfirmButton: false,
                timer: 2000
            });
        </script>
    @endif

    <!-- Display Validation Errors -->
    <x-backend.layouts.elements.errors />

    <div class="container">
        <h1 class="text-center">Update Sewing Balance</h1>

        <!-- Form for Updating Sewing Balance -->
        <form action="{{ route('sewing_balances.update', $job_no) }}" method="POST">
            @csrf
            @method('PUT')

            <div class="row p-1">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">
                            <!-- Hidden Inputs for System Data -->
                            <input type="hidden" name="created_by" value="{{ auth()->user()->id }}">
                            <input type="hidden" name="division_id" value="2">
                            <input type="hidden" name="division_name" value="Factory">
                            <input type="hidden" name="company_id" value="3">
                            <input type="hidden" name="company_name" value="FAL - Factory">

                            <!-- Job Information Table -->
                            <table class="table">
                                <tbody>
                                    <tr>
                                        <td class="create_label_column">Job No</td>
                                        <td class="create_input_column">
                                            <input type="text" name="job_no" class="form-control"
                                                placeholder="Job No" value="{{ $jobs_no }}" readonly>
                                        </td>
                                        <td class="create_label_column">Buyer</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->buyer }}
                                        </td>
                                        <td class="create_label_column">Style</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->style }}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="create_label_column">PO</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->po }}
                                        </td>
                                        <td class="create_label_column">Department</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->department }}
                                        </td>
                                        <td class="create_label_column">Item</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->item }}
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="create_label_column">Destination</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->destination }}
                                        </td>
                                        <td class="create_label_column">Order Quantity</td>
                                        <td class="create_input_column">
                                            {{ $basic_info->order_quantity }}
                                        </td>
                                        <td class="create_label_column">Sewing Balance</td>
                                        <td class="create_input_column">
                                            <input type="number" name="sewing_balance" class="form-control"
                                                placeholder="Sewing Balance"
                                                value="{{ $old_sewing_basic_info->sewing_balance }}" required readonly
                                                id="sewing_balance">
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="create_label_column">Production Plan</td>
                                        <td class="create_input_column">
                                            <input type="month" name="production_plan" class="form-control"
                                                placeholder="Production Plan" required
                                                value="{{ $old_sewing_basic_info->production_plan }}">
                                        </td>
                                        <td class="create_label_column">Target SMV</td>
                                        <td class="create_input_column">
                                            <input type="number" step="0.01" name="target_smv" class="form-control"
                                                placeholder="Target SMV" value="{{ $basic_info->target_smv }}" required
                                                readonly id="target_smv">
                                        </td>
                                        <td class="create_label_column">Production Min Balance</td>
                                        <td class="create_input_column">
                                            <input type="number" step="0.01" name="production_min_balance"
                                                class="form-control" placeholder="Production Min Balance" required
                                                readonly id="production_min_balance"
                                                value="{{ $old_sewing_basic_info->production_min_balance }}">
                                        </td>
                                    </tr>
                                </tbody>
                            </table>

                            <!-- Color/Sizes Quantities Table -->
                            <table class="table table-bordered mt-2 text-center" id="colorWayTable">
                                <thead>
                                    <tr>
                                        <th>Color</th>
                                        <th>Size</th>
                                        <th>Remain Quantity</th>
                                        <th>Sewing Quantity</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($old_sewing_balances as $balance)
                                        @php
                                            $job = $color_sizes_qties->firstWhere('color', $balance->color)
                                                ->firstWhere('size', $balance->size);
                                            $remaining = $job->color_quantity 
                                                - $job->sewingPlans->sum('total_sewing_quantity');
                                        @endphp
                                        <tr>
                                            <input type="hidden" name="color_id[]" value="{{ $balance->id }}">
                                            <td>
                                                <input type="text" name="color[]" class="form-control"
                                                    value="{{ $balance->color }}" readonly>
                                            </td>
                                            <td>
                                                <input type="text" name="size[]" class="form-control"
                                                    value="{{ $balance->size }}" readonly>
                                            </td>
                                            <td>
                                                <input type="number" class="form-control"
                                                    value="{{ $remaining }}" readonly>
                                            </td>
                                            <td>
                                                <input type="number" name="sewing_quantity[]"
                                                    class="form-control sewing_quantity" 
                                                    value="{{ $balance->sewing_balance }}"
                                                    data-max="{{ $remaining }}">
                                                <input type="hidden" name="old_sewing_quantity[]"
                                                    value="{{ $balance->sewing_balance }}">
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>

                            <!-- Form Buttons -->
                            <div class="button-container">
                                <a href="{{ route('jobs.index') }}" class="btn btn-outline-secondary">
                                    <i class="fas fa-arrow-left"></i> Cancel
                                </a>
                                <button type="submit" id="saveButton" class="btn btn-outline-success">
                                    <i class="fas fa-save"></i> Update Balance
                                </button>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </form>
    </div>

    <!-- Scripts -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>

    <!-- JavaScript for Dynamic Calculations -->
    <script>
        $(document).ready(function() {
            // Initialize Select2 for dropdowns
            $('#style-select').select2();
            $('#po-select').select2();
            $('#department-select').select2();

            // Calculate initial totals
            calculateSewingBalance();
            calculateProductionMinBalance();

            // Event listener for sewing quantity input
            $('.sewing_quantity').on('input', function() {
                const max = parseInt($(this).data('max')) || 0;
                let value = parseInt($(this).val()) || 0;

                // Validate input
                if (value > max) {
                    value = max;
                    Swal.fire('Warning', 'Cannot exceed remaining quantity', 'warning');
                }

                if (value < 0) {
                    value = 0;
                }

                $(this).val(value);
                calculateTotals();
            });

            // Function to calculate total sewing balance
            function calculateSewingBalance() {
                let total = 0;
                $('.sewing_quantity').each(function() {
                    total += parseInt($(this).val()) || 0;
                });
                $('#sewing_balance').val(total);
            }

            // Function to calculate production minutes balance
            function calculateProductionMinBalance() {
                const sewingBalance = parseInt($('#sewing_balance').val()) || 0;
                const smv = parseFloat($('#target_smv').val()) || 0;
                $('#production_min_balance').val((sewingBalance * smv).toFixed(2));
            }

            // Combined function for both calculations
            function calculateTotals() {
                calculateSewingBalance();
                calculateProductionMinBalance();
            }
        });
    </script>
</x-backend.layouts.master>