@extends('master')
@section('content')
    <div class="page-wrapper">
        <div class="content">
            <div class="page-header">
                <div class="page-title">
                    <h4>{{ __('sitelabel.CreatenewStockOpeningBalance') }}</h4>
                </div>
            </div>

            @if ($errors->any())
                <div class="alert alert-danger alert-dismissible fade show" role="alert">
                    <ul>
                        @foreach ($errors->all() as $error)
                            <li>{{ $error }}</li>
                        @endforeach
                    </ul>
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                </div>
            @endif

            <form method="post" action="{{ url('/stockopeningbalanceprocess') }}" enctype="multipart/form-data">
                @csrf
                <div class="card">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.Month') }}</label>
                                    <select class="form-control" name="cmbMonth" id="cmbMonth">
                                        <option value="-1">{{ __('sitelabel.SelectMonth') }}</option>
                                        @foreach (['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'] as $month)
                                            <option value="{{ $month }}">{{ $month }}</option>
                                        @endforeach
                                    </select>
                                    <span class="text-danger">
                                        @error('cmbMonth')
                                            {{ $message }}
                                        @enderror
                                    </span>
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.Year') }}</label>
                                    <select class="form-control" name="cmbYear" id="cmbYear">
                                        <option value="-1">{{ __('sitelabel.SelectYear') }}</option>
                                        @for ($year = 2024; $year <= 2040; $year++)
                                            <option value="{{ $year }}">{{ $year }}</option>
                                        @endfor
                                    </select>
                                    <span class="text-danger">
                                        @error('cmbYear')
                                            {{ $message }}
                                        @enderror
                                    </span>
                                </div>
                            </div>
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.Warehouse') }}</label>
                                    <select class="form-control" name="cmbWarehouse" id="cmbWarehouse" required>
                                        <option value="-1">{{ __('sitelabel.SelectWarehouse') }}</option>
                                        @foreach ($warehouse as $item)
                                            <option value="{{ $item->Id }}">{{ $item->Name }}</option>
                                        @endforeach
                                    </select>
                                    <span class="text-danger">
                                        @error('cmbWarehouse')
                                            {{ $message }}
                                        @enderror
                                    </span>
                                </div>
                            </div>
                            <!-- New Packing dropdown -->
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.Packing') }}</label>
                                    <select class="form-control" name="cmbPacking" id="cmbPacking" required>
                                        <option value="-1">{{ __('sitelabel.SelectPacking') }}</option>
                                        @foreach ($packingOptions as $packing)
                                            <option value="{{ $packing->Id }}">{{ $packing->Name }}</option>
                                        @endforeach
                                    </select>
                                    <span class="text-danger">
                                        @error('cmbPacking')
                                            {{ $message }}
                                        @enderror
                                    </span>
                                </div>
                            </div>

                            <!-- New Shade dropdown -->
                            <div class="col-lg-3 col-sm-6 col-12">
                                <div class="form-group">
                                    <label>{{ __('sitelabel.Shade') }}</label>
                                    <select class="form-control" name="cmbShade" id="cmbShade" required>
                                        <option value="-1">{{ __('sitelabel.SelectShade') }}</option>
                                        @foreach ($shadeOptions as $shade)
                                            <option value="{{ $shade->Id }}">{{ $shade->Name }}</option>
                                        @endforeach
                                    </select>
                                    <span class="text-danger">
                                        @error('cmbShade')
                                            {{ $message }}
                                        @enderror
                                    </span>
                                </div>
                            </div>

                            <div class="col-lg-12">
                                <button type="button" id="loadproducts"
                                    class="btn btn-my-primary">{{ __('sitelabel.LoadProducts') }}</button>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="card" id="products-card" style="display: none">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-lg-12">
                                <table class="table table-bordered" id="productsTable">
                                    <thead style="background-color: #0F163D">
                                        <tr>
                                            <th style="color: #fff">{{ __('sitelabel.Product') }}</th>
                                            <th style="color: #fff">{{ __('sitelabel.PurchasePrice') }}</th>
                                            <th style="color: #fff">{{ __('sitelabel.Quantity') }}</th>
                                            <th style="color: #fff">{{ __('sitelabel.Total') }}</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($products as $item)
                                            <tr>
                                                <td>
                                                    <input type="hidden" class="form-control product-name"
                                                        name="products[{{ $loop->index }}][id]"
                                                        value="{{ $item->Id }}">
                                                    <input type="text" class="form-control product-name"
                                                        name="products[{{ $loop->index }}][name]"
                                                        value="{{ $item->Name }}" readonly>
                                                </td>
                                                <td>
                                                    <input type="number" class="form-control purchase-price"
                                                        name="products[{{ $loop->index }}][price]" step="0.01"
                                                        value="{{ $item->PurchasePrice }}">
                                                </td>
                                                <td>
                                                    <input type="number" class="form-control quantity"
                                                        name="products[{{ $loop->index }}][quantity]" step="0.01"
                                                        value="0">
                                                </td>
                                                <td>
                                                    <input type="text" class="form-control total"
                                                        name="products[{{ $loop->index }}][total]" readonly>
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td colspan="2" class="text-end">
                                                <strong>{{ __('sitelabel.GrandTotal') }}</strong>
                                            </td>
                                            <td>
                                                <input type="text" class="form-control text-end" name="txtGrandQuantity"
                                                    id="txtGrandQuantity" readonly>
                                            </td>
                                            <td>
                                                <input type="text" class="form-control text-end" name="txtGrandTotal"
                                                    id="txtGrandTotal" readonly>
                                            </td>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>

                        <!-- Submit -->
                        <div class="row mt-4">
                            <div class="col-lg-12">
                                <button type="submit" class="btn btn-primary" id="savenewButton" name="save_data"
                                    value="1" disabled>{{ __('sitelabel.SaveAndNew') }}</button>
                                <button type="submit" class="btn btn-primary" id="saveButton" name="save"
                                    disabled>{{ __('sitelabel.Save') }}</button>
                                <button type="button" class="btn btn-dark"
                                    onclick="javascript:window.location='{{ url('/stockopeningbalance') }}';">{{ __('sitelabel.Back') }}</button>
                            </div>
                        </div>
                    </div>
                </div>
            </form>
        </div>
    </div>
@endsection

@section('script')
    <script>
        $(document).ready(function() {
            $('#cmbYear, #cmbMonth, #cmbWarehouse, #cmbShade, #cmbPacking').select2({
                theme: "bootstrap-5",
            });

            // Function to format numbers with 2 decimal places
            function formatNumber(number) {
                return new Intl.NumberFormat('en-US', {
                    minimumFractionDigits: 2,
                    maximumFractionDigits: 2
                }).format(number);
            }

            // Function to calculate row total
            function calculateRowTotal(row) {
                const price = parseFloat($(row).find('.purchase-price').val()) || 0;
                const quantity = parseFloat($(row).find('.quantity').val()) || 0;
                const total = price * quantity;
                $(row).find('.total').val(formatNumber(total));
            }

            // Function to calculate grand totals
            function calculateGrandTotals() {
                let grandTotal = 0;
                let grandQuantity = 0;

                $('#productsTable tbody tr').each(function() {
                    const quantity = parseFloat($(this).find('.quantity').val()) || 0;
                    const total = parseFloat($(this).find('.total').val().replace(/,/g, '')) || 0;

                    grandQuantity += quantity;
                    grandTotal += total;
                });

                $('#txtGrandQuantity').val(formatNumber(grandQuantity));
                $('#txtGrandTotal').val(formatNumber(grandTotal));

                // Enable/disable save buttons based on if there are any quantities entered
                const hasQuantities = grandQuantity > 0;
                $('#saveButton, #savenewButton').prop('disabled', !hasQuantities);
            }

            // Load Products Button Click Handler
            $('#loadproducts').on('click', function() {
                const month = $('#cmbMonth').val();
                const year = $('#cmbYear').val();
                const warehouse = $('#cmbWarehouse').val();
                const packing = $('#cmbPacking').val();
                const shade = $('#cmbShade').val();

                // Validate dropdowns
                if (month === "-1") {
                    alert('{{ __('sitelabel.PleaseSelectMonth') }}');
                    return;
                }
                if (year === "-1") {
                    alert('{{ __('sitelabel.PleaseSelectYear') }}');
                    return;
                }
                if (warehouse === "-1") {
                    alert('{{ __('sitelabel.PleaseSelectWarehouse') }}');
                    return;
                }
                if (packing === "-1") {
                    alert('{{ __('sitelabel.PleaseSelectPacking') }}');
                    return;
                }
                if (shade === "-1") {
                    alert('{{ __('sitelabel.PleaseSelectShade') }}');
                    return;
                }

                // AJAX call to get stock opening products
                $.ajax({
                    url: '{{ url('/api/getStockOpeningProducts') }}',
                    method: 'GET',
                    data: {
                        month: month,
                        year: year,
                        packing: packing,
                        shade: shade,
                        warehouse: warehouse
                    },
                    success: function(response) {
                        // Always show the products table
                        $('#products-card').css('display', 'block');
                        console.log(response);

                        // Reset table if existing data found
                        if (response.hasExistingData) {
                            $('#productsTable tbody tr').each(function(index) {
                                const productId = $(this).find('input[name$="[id]"]')
                                    .val();
                                const existingProduct = response.data.find(item => item
                                    .Id == productId);

                                if (existingProduct) {
                                    $(this).find('.purchase-price').val(existingProduct
                                        .PurchasePrice);
                                    $(this).find('.quantity').val(existingProduct
                                        .Quantity);
                                    $(this).find('.total').val(formatNumber(
                                        existingProduct.Total));
                                } else {
                                    $(this).find('.quantity').val(0);
                                    $(this).find('.total').val(formatNumber(0));
                                }
                            });
                        } else {
                            // Reset quantities if no existing data
                            $('#productsTable tbody tr').each(function() {
                                $(this).find('.quantity').val(0);
                                $(this).find('.total').val(formatNumber(0));
                            });
                        }

                        // Recalculate totals
                        calculateGrandTotals();
                    },
                    error: function() {
                        alert('{{ __('sitelabel.ErrorLoadingProducts') }}');
                    }
                });
            });

            // Bind events to quantity and price inputs
            $('#productsTable').on('input', '.quantity, .purchase-price', function() {
                calculateRowTotal($(this).closest('tr'));
                calculateGrandTotals();
            });
        });
    </script>
@endsection