@extends('layouts/contentLayoutMaster')

@section('title', 'Add Revenue Item ')

@section('vendor-style')
    {{-- vendor css files --}}
    <link rel="stylesheet" href="{{ asset('vendors/css/forms/select/select2.min.css') }}">
    <link rel="stylesheet" href="{{ asset('vendors/css/tables/datatable/dataTables.bootstrap5.min.css') }}">
    <link rel="stylesheet" href="{{ asset('vendors/css/tables/datatable/buttons.bootstrap5.min.css') }}">
    <link rel="stylesheet" href="{{ asset('vendors/css/extensions/sweetalert2.min.css') }}">
    <link rel="stylesheet" href="{{ asset('/css/custom.css') }}">
@endsection
@section('content')

    <!-- Column Search -->
    <section id="column-search-datatable">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="row border-bottom py-2">
                        <div class="col-3">
                            <h4 class="card-title pt-1 my-auto ps-2">{{ $selectedStore ? $selectedStore->name : '' }}</h4>
                        </div>
                        <div class="col-6"></div>
                        {{-- <div class="col-3">
                            <a href="{{ route('price.created.export') }}" class="btn btn-primary my-auto">
                                Export Prices
                            </a>
                        </div> --}}
                    </div>
                    <div class="card-body">
                        <form method="post" id="storeStockForm" style="position: relative">
                            @csrf
                                <div class="row ">
                                    <div class="col-4 pe-0">
                                        {{-- <label class="form-label">Select Store</label>
                                        <select id="store" name="store_id" data-placeholder="Store" class="select2 form-select" required>
                                            <option value="" selected disabled>Select Store</option>
                                            @foreach ($stores as $store)
                                                <option {{ $storeId == $store->_id ? 'selected' : '' }} value="{{ $store->id }}">
                                                    {{ ucfirst($store->name) }}
                                                </option>
                                            @endforeach
                                        </select> --}}
                                        <input type="hidden" id="store" name="store_id" value="{{ $storeId }}">
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-2 pe-0">
                                        <label class="form-label" for="ref_no">Reference No</label>
                                        <input type="text" id="ref_no" class="form-control" placeholder="Ref No"
                                            name="ref_no" value="{{ old('ref_no') }}" step="any" required/>
                                        @error('ref_no')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                    <div class="col-4 pe-0">
                                        <label class="form-label">Select Item</label>
                                        <select id="item" name="item_id" data-placeholder="Item" class="select2 form-select" 
                                            onchange="getDropdownData('packing_search',this.value);" required>

                                            <option value="" selected disabled>Select Item</option>
                                            
                                            @foreach ($items as $item)
                                                <option {{ old('item_id') == $item->_id ? 'selected' : '' }} value="{{ $item->_id }}">
                                                    {{ $item->code .' '. ucfirst($item->name) }}
                                                    {{-- @if(isset($item->foc) && ($item->foc == 1 || $item->foc == '1'))
                                                    (FOC)
                                                @endif --}}
                                                </option>
                                            @endforeach

                                        </select>
                                    </div>
                                </div>
                                <div class="row mt-1 d-flex align-items-end">
                                    
                                    
                                    <div class="col-2 pe-0">
                                        <label class="form-label">Unit of Measure (UOM)</label>
                                        <select id="packing_search" name="packing" data-placeholder="UOM" class="select2 form-select" required readonly>                                    
                                        </select>
                                    </div>
                                    <div class="col-2 pe-0">
                                            <label class="form-label" for="quantity">Quantity</label>
                                            <input type="number" min="0" id="quantity" class="form-control" placeholder="Quantity"
                                                name="quantity" value="{{ old('quantity') }}" step="any" />
                                            @error('quantity')
                                                <span class="text-danger">{{ $message }}</span>
                                            @enderror
                                    </div>
                                    <div class="col-2 pe-0">
                                        <label class="form-label" for="price" id="unitPriceLabel">Price Per Unit</label>
                                        <input type="number" id="pricePerUom" class="form-control" placeholder="Price Per Uom" step="any"
                                            name="pricePerUom" value="{{ old('price') }}" />
                                        @error('pricePerUom')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                    <div class="col-2 pe-0">
                                        <label class="form-label" for="price">Total Price</label>
                                        <input type="number" min="0" id="price" class="form-control" style="font-weight:bold; color:rgb(41, 197, 69)" placeholder="Price"
                                            name="price" value="{{ old('price') }}" readonly step="any" />
                                        @error('price')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                    {{-- <div class="col-2 pe-0">
                                        <label class="form-label" for="price">Current Rate - <span id="unitUom" style="color:#1c9edf;font-weight:bold">UOM</span></label>
                                        <input type="number" min="0" id="tprice" class="form-control" style="font-weight:bold; color:rgb(41, 158, 197)" placeholder="Unit Rate"
                                            name="tprice" value="{{ old('tprice') }}" readonly step="any" />
                                        @error('tprice')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div> --}}
                                        <div class="col-3 pe-0 m-0 text-center d-flex flex-column justify-content-center">
                                            <label class="form-label mb-1" for="price" style="font-weight:bold">Average Weighted Rate Per Unit</label>
                                            <div class="row p-0 m-0 w-100 ps-1 pe-1">
                                                <div class="col-6 ps-0 pe-0">
                                                    <label class="form-label" for="pwa">Previous </label>
                                                    <input type="number" min="0" id="pwa" class="form-control text-center" placeholder="Previous Rate"
                                                        name="pwa" value="{{ old('pwa') }}" readonly style="border-radius:0.375rem 0px  0px 0.375rem; background-color:#e8f7ff" />
                                                        <input type="hidden" min="1" id="pQuantity" class="form-control" placeholder="Previous Quantity"
                                                        name="pQuantity"  />
                                                    @error('pwa')
                                                        <span class="text-danger">{{ $message }}</span>
                                                    @enderror
                                                </div>
                                                <div class="col-6 ps-0 pe-0">
                                                    <label class="form-label" for="cwa">Current</label>
                                                    <input type="number" min="0" id="cwa" class="form-control text-center" placeholder="Current Rate"
                                                        name="cwa" value="" readonly style="border-radius:0px 0.375rem 0.375rem 0px;" />
                                                    @error('cwa')
                                                        <span class="text-danger">{{ $message }}</span>
                                                    @enderror
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-1 pe-0 d-flex justify-content-start align-items-center" style="padding-top: 22px">
                                            <a class="btn btn-sm btn-secondary" style="min-width: 68px; padding:10px; position: absolute;top: -72px;" onclick="resetForm()">Reset</a>
                                            <input type="submit" value="Submit" class="btn btn-sm btn-primary ">
                                        </div>
                                    
                        </form>
                    </div>
                    <div class="card-datatable table-responsive">
                        <table class="table" id="stock_table">
                            <thead>
                                <tr>
                                    <th>No.</th>
                                    <th>SAP Code</th>
                                    <th>Store</th>
                                    <th>Code</th>
                                    <th>Item</th>
                                    <th>FOC</th>
                                    <th>Total Quantity</th>
                                    <th>Weighted Avg Rate</th>
                                    {{-- <th>Action</th> --}}
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        </div>
    </section>


@endsection

@section('vendor-script')

    <script src="{{ asset('vendors/js/forms/select/select2.full.min.js') }}"></script>
    <script src="{{ asset('vendors/js/tables/datatable/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('vendors/js/tables/datatable/dataTables.bootstrap5.min.js') }}"></script>
    <script src="{{ asset('vendors/js/tables/datatable/datatables.buttons.min.js') }}"></script>
    <script src="{{ asset('vendors/js/tables/datatable/buttons.bootstrap5.min.js') }}"></script>
    <script src="{{ asset('vendors/js/extensions/sweetalert2.all.min.js') }}"></script>
    <script src="{{ asset('/js/custom.js') }}"></script>
    <script>
        $(document).ready(function() {
            $(".select2").select2({
                allowClear: true,
                // dropdownPosition: 'TOP'
            });
        });





        var table;
        $(document).ready(function() {
            $(".select2").select2({});
            table = $('#stock_table').DataTable({
                processing: true,
                serverSide: true,
                paging: true,
                ajax: {
                    // headers: {
                    //     'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    // },
                    url: "{{ route('inventory.get.revenue-store.stock') }}",
                    data: function(d) {
                        // '_token': '{{ csrf_token() }}',
                        d.page = (d.start / d.length) + 1; // DataTables calculates the page number based on start
                        d.length = d.length; // Page length (number of rows per page)
                        d.search = d.search.value;
                        d.id = $('#store').val();
                        // d.type = $('#type option:selected').val();
                        // d.area_office = $('#area_office option:selected').val();
                        // d.plant = $('#plant option:selected').val();
                        // d.serial_number = $('#serial_number').val();
                    }
                },
                columns: [{
                        data: 'DT_RowIndex',
                        name: 'DT_RowIndex'
                    },
                    {
                        data: 'sap_code',
                        name: 'sap_code'
                    },
                    {
                        data: 'store',
                        name: 'store'
                    },
                    {
                        data: 'code',
                        name: 'code'
                    },
                    {
                        data: 'item',
                        name: 'item'
                    },
                    {
                        data: 'foc',
                        name: 'foc'
                    },
                    {
                        data: 'quantity',
                        name: 'quantity',
                        className: 'text-center text-primary'
                    },
                    {
                        data: 'wRate',
                        name: 'wRate',
                        className: 'text-center text-success'
                    },
                    // {
                    //     data: 'action',
                    //     name: 'action'
                    // },

                ],
                dom: '<"d-flex justify-content-between align-items-center header-actions text-nowrap mx-1 row mt-75"' +
                    '<"col-sm-12 col-lg-4 d-flex justify-content-center justify-content-lg-start" l>' +
                    '<"col-sm-12 col-lg-8"<"dt-action-buttons d-flex align-items-center justify-content-lg-end justify-content-center flex-md-nowrap flex-wrap"<"me-1"f>>>' +
                    '><"text-nowrap" t>' +
                    '<"d-flex justify-content-between mx-2 row mb-1"' +
                    '<"col-sm-12 col-md-6"i>' +
                    '<"col-sm-12 col-md-6"p>' +
                    '>',
                language: {
                    paginate: {
                        // remove previous & next text from pagination
                        previous: '&nbsp;',
                        next: '&nbsp;'
                    }
                }
            });
            $(".search-input").on('change', function() {
                table.ajax.reload();
            });
            $('#serial_number').on('input', function() {
                table.ajax.reload();
            });
        });





    function getDropdownData(input_id, id) {

        $('#price, #quantity, #cwa, #packing_search, #pricePerUom').val('');
 
        $.ajax('{{ route('inventory.get.revenue-items.packing') }}', {
            type: 'get',
            data: {
                id: id,
                type: input_id
            },
            success: function(data) {
                if (data.success == true) {
                    
                    if(data.foc === 1)
                    {
                        $('#price,#packing_search,#pricePerUom').prop('readonly', true);
                        $('#price,#pricePerUom').val(0);
                    }
                    else
                    {
                        $('#price,#packing_search,#pricePerUom').prop('readonly', false);
                        $('#price,#pricePerUom').val('');
                    }

                    $('#' + input_id).html(data.data);
                    getProductAvgRate();
                }
            },
            error: function(jqXhr, textStatus, errorMessage) {
                alert('Error Occurred')
            }
        });
    }

    function getProductAvgRate() {

        var store_id = $('#store').val();
        var item_id = $('#item').val();
 
        $.ajax('{{ route('inventory.get.revenue-items.avgRate') }}', {
            type: 'get',
            data: {
                item_id: item_id,
                store_id: store_id
            },
            success: function(data) {
                if (data.success == true) {
                    $('#pwa').val(data.data['pRate']);
                    $('#pQuantity').val(data.data['pQuantity']);
                }
            },
            error: function(jqXhr, textStatus, errorMessage) {
                alert('Error Occurred')
            }
        });
    }


    $('#packing_search').on('change', function () {

        $('#price, #quantity, #pricePerUom').val('');
        $('#cwa').val('');

        var text = $(this).find(':selected').text(); 
    })


    $('#price, #quantity, #pricePerUom').on('input', function () {

        var totalPrice = parseFloat($('#pricePerUom').val()) * parseFloat($('#quantity').val());
        $('#price').val(totalPrice);

        if($('#price').val() !== '' && $('#quantity').val() !== '') {


            var packingSize = $('#packing_search').val();
            var cPrice = parseFloat($('#price').val());
            var cQuantity = parseFloat($('#quantity').val());
            var pRate = $('#pwa').val() ? parseFloat($('#pwa').val()) : 0;
            var pQuantity = $('#pQuantity').val() ? parseFloat($('#pQuantity').val()) : 0;
            var cwa = parseFloat($('#cwa').val()); // Ensure `cwa` is properly referenced

            let uomQuantity = 0;

            // If packing is other than a single UOM
            if (packingSize && packingSize !== 'uom') {
                packingSize = parseInt(packingSize, 10);
                uomQuantity = packingSize ? cQuantity * packingSize : cQuantity;
            } else {
                uomQuantity = cQuantity;
            }

            if((pRate == '' || pRate == null || pRate == undefined) && (pQuantity == '' || pQuantity == null || pQuantity == undefined)){
                
                var newRate = cPrice/uomQuantity; 
         
            } else {

                var pricePerUom = cPrice / uomQuantity;

                var num1 = (pQuantity * pRate) + (uomQuantity * pricePerUom);
                var num2 = pQuantity + uomQuantity;
                var newRate = num1 / num2;
                $('#cwa').val(newRate.toFixed(2)); // Optional: Round to 2 decimal places
            }
        }
    });


    $('#storeStockForm').on('submit', function (e) {
            e.preventDefault(); // Prevent the default form submission

            let formData = $(this).serialize(); // Serialize form data

            var difference = calculatePercentageDiff();
            var ref_no = $('#ref_no').val(); 

            $quantity = $('#quantity').val();
            $pricePerUom = $('#pricePerUom').val();

            if($quantity == '0' || $quantity == 0 || $quantity == '' || $quantity == null || $quantity == undefined || $pricePerUom == '0' ||  $pricePerUom == 0 ||  $pricePerUom == '' ||  $pricePerUom == null ||  $pricePerUom == undefined)
            {
             alert('Validation Error Occured !'); 
             return;  
            }

            if($quantity < 0 || $pricePerUom < 0)
            {
             alert('Negative values are not allowed !'); 
             return;  
            }

            if(difference > 10)
            {
                var icon = 'error';
                var text = '<p>The Rate Difference between old and new rate for this item is <strong style="color:red; font-size:18px">'+difference+' % </strong> </span>. <br> <br> Do you still want to proceed ! <br> <small style="color:red"> ( You will be responsible for your Action ) </small></p>'
            }
            else
            {
                var icon = 'info'
                var text = '<p>The Weighted Avg Rate difference between old and new rate for this item is <strong style="color:#3085d6; font-size:18px" > '+difference+' % </strong> <br> <br> Do you want to proceed !</p>'
            }


            Swal.fire({
                title: 'Are you Sure?',
                html: text ,
                icon: icon,
                showCancelButton: true,
                confirmButtonColor: '#3085d6',
                cancelButtonColor: '#d33',
                confirmButtonText: 'Yes'
            }).then((result) => {
                if (result.isConfirmed) {

                    $.ajax({
                        url: "{{ route('inventory.revenue-store-stock.store') }}", // Your Laravel route
                        method: "POST",
                        data: formData,
                        success: function(response) {
                            if (response.success == true) {
                                showAlert('success', response.message);
                                $('#price, #quantity, #cwa, #pwa, #pricePerUom').val('');
                                $('#packing_search, #item').val('').trigger('change');
                                table.ajax.reload();

                            } else {
                                showAlert('error', response.message);
                            }

                        },
                        error: function(xhr) {
                            if (xhr.status === 422) {
                                let message = xhr.responseJSON?.message || 'Validation failed';
                                showAlert('error', message);
                            } else {
                                showAlert('error', 'An unexpected error occurred');
                            }
                        }
                    });
                }
            })
        });


        function resetForm()
        {
            $('#price, #quantity, #cwa, #pwa, #pricePerUom').val('');
            $('#packing_search, #item').val('').trigger('change');
            table.ajax.reload();
        }
    
        function calculatePercentageDiff() {

            var packingValue = $('#packing_search').val();
            var cQuantity = parseFloat($('#quantity').val());
            var cPrice = parseFloat($('#price').val());
            var nPrice = 0;    
            
            if(packingValue == 'uom')
            {
                nPrice = cPrice / cQuantity ;
                nPrice = parseFloat(nPrice);
            }
            else
            {
                nPrice = cPrice / (cQuantity * parseFloat(packingValue));
            }

            
            var cwa = nPrice;
            // var cwa = parseFloat($('#cwa').val());
            var pwa = $('#pwa').val() ? parseFloat($('#pwa').val()) : 0;

            // Calculate absolute difference
            var absoluteDifference = Math.abs(cwa - pwa);

            // Calculate average of the two values
            var average = (cwa + pwa) / 2;

            if(pwa == 0)
            {
                var percentageDifference = 0;
            }
            else
            {
                // Calculate percentage difference
                // var percentageDifference = (absoluteDifference / average) * 100;
                var percentageDifference = (absoluteDifference / pwa) * 100;
            }
            // Output the result
            return percentageDifference.toFixed(2);
        }


    </script>
@endsection