@extends('layouts/contentLayoutMaster')
@section('title', 'Edit General Expense')
@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')
    <!-- Basic multiple Column Form section start -->
    <section id="multiple-column-form">
        @if ($users->contains('_id', auth()->user()->_id) || 
                        optional($aoBankAccount)->area_acc_officer === auth()->user()->_id || 
                        optional($pettyCashWallet)->user_id === auth()->user()->_id)
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header border-bottom">
                            <h4 class="card-title">Account Balances</h4>
                        </div>
                        <div class="card-datatable table-responsive">
                            <table class="table table-bordered table-striped">
                                <tbody>
                                    @php
                                        $bankBalance = $aoBankAccount ? "{$aoBankAccount->bank_acc_title} (Balance: " . ($aoBankAccount->amount ?? 0) . ")" : null;
                                        $pettyCashBalance = $pettyCashWallet ? "{$pettyCashWallet->title} (Balance: " . ($pettyCashWallet->amount ?? 0) . ")" : null;
                                    @endphp
                                    <tr>
                                        <th>Bank Balance</th>
                                        <td>
                                            {{$bankBalance ?? ''}} 
                                            @if(empty($aoBankAccount))
                                                <small class="text-danger">No record added for bank account.</small>
                                            @endif
                                        </td>
                                        
                                    </tr>
                                    <tr>
                                        <th>Petty Cash Balance</th>
                                        <td>
                                            {{ $pettyCashBalance ?? ''}}
                                            @if(empty($pettyCashWallet))
                                                <small class="text-danger">No record added for petty cash.</small>
                                            @endif
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        @endif
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">
                        <h4 class="card-title">Edit General Expense</h4>
                    </div>
                    <div class="card-body">
                        @if ($message = Session::get('success'))
                            <div class="demo-spacing-0 my-2">
                                <div class="alert alert-success alert-dismissible fade show" role="alert">
                                    <div class="alert-body">{{ $message }}</div>
                                    <button type="button" class="btn-close" data-bs-dismiss="alert"
                                        aria-label="Close"></button>
                                </div>
                            </div>
                        @endif
                        @if ($errorMessage = Session::get('errorMessage'))
                            <div class="demo-spacing-0 my-2">
                                <div class="alert alert-danger alert-dismissible fade show" role="alert">
                                    <div class="alert-body">{{ $errorMessage }}</div>
                                    <button type="button" class="btn-close" data-bs-dismiss="alert"
                                        aria-label="Close"></button>
                                </div>
                            </div>
                        @endif
                        <form class="form">
                            @csrf
                            @method('PUT')
                            <div class="row">

                                <input type="hidden" name="status" id="status" value="0">
                                <input type="hidden" name="GEId" id="GEId" value="{{$generalExpenseId}}">

                                <div class="col-md-4 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="code">Code</label>
                                        <input type="text" id="code" class="form-control" placeholder="MCC Code"
                                            name="code" value="{{ old('code', $generalExpense->code) }}" disabled maxlength="7" />
                                    </div>
                                </div>

                                <div class="col-md-4 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="exp_date">Expense Date *</label>
                                        <input type="date" id="exp_date" class="form-control" placeholder="Trx Date"
                                            name="exp_date" max="{{ date('Y-m-d') }}"/>
                                        @error('exp_date')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>

                                <div class="col-md-4 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="select2-multiple">Expense Category *</label>
                                        <select class="form-select" id="expense_category_id" name="expense_category_id">
                                            <option selected disabled>Please Select Category</option>
                                            @foreach ($expenseCategories as $category)
                                                <option value="{{ $category->id }}" {{$generalExpense->expense_category_id == $category->id ? 'selected' : ''}}>
                                                    {{ $category->category_name }}
                                                </option>
                                            @endforeach
                                        </select>
                                        @error('expense_category_id')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>

                                <div class="col-md-4 col-12">
                                    <div class="mb-1">
                                        <label class="form-label">Level Of Expense *</label>
                                        <select class="form-control select2" name="level_of_expense" id="level_of_expense" onchange="showCollectionPoints()">
                                            <option selected disabled>Please Select Level Of Expense</option>
                                            <option value="area_office" {{$generalExpense->level_of_expense == 'area_office' ? 'selected' : ''}}>Area Office</option>
                                            <option value="mcc" {{$generalExpense->level_of_expense == 'mcc' ? 'selected' : ''}}>Collection Point</option>
                                        </select>
                                    </div>
                                </div>
                                
                                <div class="col-md-4 col-12">
                                    <div class="mb-1">
                                        <label class="form-label">Area Office</label>
                                        <select class="form-control select2" name="area_office_id" id="area_office_id">
                                            <option value="" selected disabled>Please Select Area Office</option>
                                            @foreach ($areaOffices as $areaOffice)
                                                <option value="{{ $areaOffice->id }}" {{$generalExpense->area_office_id == $areaOffice->id ? 'selected' : ''}}>{{ $areaOffice->name }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                                {{-- @if($generalExpense->level_of_expense == 'mcc') --}}
                                    <div class="col-md-4 col-12" id="collection_point_div">
                                        <label class="form-label">Collection Point</label>
                                        <select class="form-control select2" name="collection_point_id" id="collection_point_id">
                                            <option value="" selected disabled>Please Select Collection Point</option>
                                        </select>
                                        @error('collection_point_id')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                {{-- @endif --}}

                                <div class="col-md-4 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="type">Expense From *</label>
                                        {{-- onchange="showPettyCashDropdown()" --}}
                                        <select class="form-select" name="type" id="type">
                                            <option selected disabled>Please Select Type</option>
                                        </select>

                                        @error('type')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>
                                
                                <div class="col-md-4 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="select2-multiple">Bank *</label>
                                        <select class="form-select select2" id="bank_id" name="bank_id">
                                            <option selected disabled>Please Select Bank Account</option>
                                        </select>
                                        @error('bank_id')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                    <div id="error-message"></div> 
                                </div>

                                <div class="col-md-4 col-12" id="petty_cash_wallets_div">
                                    <label class="form-label">Petty Cash Wallets</label>
                                    <select class="form-control select2" name="petty_cash_wallet_id" id="petty_cash_wallet_id">
                                        <option value="" selected disabled>Please Select Petty Cash Wallet</option>
                                    </select>
                                    @error('petty_cash_wallet_id')
                                        <span class="text-danger">{{ $message }}</span>
                                    @enderror
                                    <div id="pc-error-message"></div> 
                                </div>

                                <div class="col-md-4 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="amount">Amount *</label>
                                        <input type="text" id="amount" class="form-control" placeholder="Amount"
                                            name="amount" value="{{ old('amount') }}"/>
                                        @error('amount')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>

                                <div class="col-md-4 col-12">
                                    <div class="mb-2">
                                        <label class="form-label" for="remarks">Remarks *</label>
                                        <input type="text" id="remarks" class="form-control" placeholder="remarks"
                                            name="remarks" value="{{ old('remarks') }}"/>
                                        @error('remarks')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>

                                <div class="col-md-4 col-12">
                                    <div class="mt-2">
                                        <a id="addExpense" class="btn btn-primary" onclick="submitForm()">Add</a>
                                    </div>
                                </div>

                                <div class="card-datatable table-responsive mb-3">
                                    <table class="table" id="expense_table">
                                        <thead>
                                            <tr>
                                                {{-- <th>S.NO.</th> --}}
                                                <th>Expense Date</th>
                                                <th>Expense Category</th>
                                                <th>Level Of Expense</th>
                                                <th>Area Office</th>
                                                <th>Collection Point</th>
                                                <th>Expense From</th>
                                                <th>Bank</th>
                                                <th>Petty Cash Wallet</th>
                                                <th>Amount</th>
                                                <th>Remarks</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $count = count($genExpenseBatch); 
                                                $totalAmount = 0
                                            @endphp
                                            @foreach ($genExpenseBatch as $key => $batch)
                                                {{$totalAmount += $batch->amount}}
                                                <tr id="row_{{ $batch->id }}" class="generalexpense_tr">
                                                    {{-- <td>{{ $key + 1 }}</td> --}}
                                                    <td>{{ $batch->exp_date }}</td>
                                                    <td>{{ $batch->expenseCategory ? $batch->expenseCategory->category_name : 'N/A' }}</td>
                                                    <td>{{ $batch->level_of_expense == 'area_office' ? 'Area Office' : 'Collection Point'}}</td>
                                                    <td>{{ $batch->areaOffice ? $batch->areaOffice->ao_name : 'N/A' }}</td>
                                                    <td>{{ $batch->collectionPoint ? $batch->collectionPoint->name : 'N/A' }}</td>
                                                    <td>{{ $batch->type == 'bank' ? 'Bank' : 'Petty Cash' }}</td>
                                                    <td>{{ $batch->bankAccount ? $batch->bankAccount->bank_acc_title : 'N/A' }}</td>
                                                    <td>{{ $batch->pettyCashWallet ? $batch->pettyCashWallet->title : 'N/A' }}</td>
                                                    <td>{{ $batch->amount }}</td>
                                                    <td>{{ $batch->remarks }}</td>
                                                    <td>
                                                        <div class="d-flex">
                                                            <button type="button" onclick="delRecord('{{ $batch->id }}')" class="btn btn-icon btn-danger btn-sm me-1">
                                                                <i data-feather="trash"></i>
                                                            </button>
                                                            <a href="{{ route('general-expense.edit', $batch->id) }}" class="btn btn-icon btn-primary btn-sm">
                                                                <i data-feather="edit"></i>
                                                            </a>
                                                        </div>
                                                    </td>
                                                </tr>
                                            @endforeach
            
                                            <tr id="empty_tr" style="display: {{ $count == 0 ? '' : 'none' }}">
                                                <td colspan="8" class="text-center">No Data Found</td>
                                            </tr>
            
                                        </tbody>
                                    </table>
                                </div>
                                
                                <div class="col-12 d-flex align-items-center">
                                    <a href="{{ route('setDraftSuccessMessage') }}" class="btn btn-primary me-1">Save as Draft</a>
                                    <button type="button" class="btn btn-primary me-1" onclick="setPendingFlag()" data-general-expense-id="{{ $generalExpenseId }}" id="submitBatch">Submit for Approval</button>
                                    <div class="ms-auto">
                                        <strong>Total Amount: </strong> <span id="totalAmount">{{ $totalAmount }}</span>
                                    </div>
                                    {{-- <button type="reset" class="btn btn-outline-secondary me-1">Reset</button>
                                    <a class="btn btn-outline-secondary cancel-btn"
                                        href="{{ route('general-expense-category.index') }}">Cancel</a> --}}
                                </div>
                            </div>
                        </form>

                        <div class="col-md-4 col-12 mt-2">
                            <!-- File Upload Input -->
                            <div class="mb-2">
                                <label class="form-label" for="file"><h5><strong>Update File (Upload image or pdf)</strong></h5></label>
                                <input type="file" id="file" class="form-control" name="file" accept="image/jpeg, image/png, image/jpg, application/pdf" onchange="previewUploadedFile(event)" />
                                @error('file')
                                    <span class="text-danger">{{ $message }}</span>
                                @enderror
                            </div>
                        
                            <!-- File Preview Container -->
                            <div class="mb-2" id="preview-container">
                                <label class="form-label" for="file-preview">File Preview</label><br>
                        
                                <!-- Image Preview -->
                                <img id="imagePreview" style="max-width: 100%; height: auto; border: 1px solid #ddd; padding: 5px; display: none;" />
                        
                                <!-- PDF Preview -->
                                <a id="pdfPreview" href="#" target="_blank" style="display: none; font-size: 16px;"></a>
                        
                                <!-- Show existing file if available -->
                                @if (isset($generalExpense->file_url))
                                    @php
                                        $fileUrl = $generalExpense->file_url;
                                        $fileExtension = pathinfo($fileUrl, PATHINFO_EXTENSION);
                                    @endphp
                        
                                    @if (in_array($fileExtension, ['jpeg', 'jpg', 'png']))
                                        <!-- Show existing image -->
                                        <img src="{{ $fileUrl }}" id="existingImage" style="max-width: 100%; height: auto; border: 1px solid #ddd; padding: 5px;" />
                                    @elseif ($fileExtension === 'pdf')
                                        <!-- Show link to existing PDF -->
                                        <a href="{{ $fileUrl }}" id="existingPdf" target="_blank" style="display: inline-block; font-size: 16px;">View Existing PDF</a>
                                    @endif
                                @endif
                            </div>
                        
                            <!-- Submit Button -->
                            <button type="button" id="updateFileBtn" class="btn btn-primary" onclick="updateFile()">Update File</button>
                        </div>
                        
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!-- Basic Floating Label Form section end -->
@endsection
@section('vendor-script')
    <!-- vendor files -->
    <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>
@endsection
@section('page-script')
    <!-- Page js files -->
    <script src="{{ asset('js/scripts/forms/form-select2.js') }}"></script>
    <script>
        var isPageLoad = true;
        function showCollectionPoints() {
            var selectedValue = document.getElementById('level_of_expense').value;
            var collectionPointDiv = document.getElementById('collection_point_div');
            // var collectionPointSelect = document.getElementById('collection_point_id');
            var collectionPointSelect = $('#collection_point_id');
            var areaOfficeSelect = $('#area_office_id');
            
            if (selectedValue === 'mcc') {
                if(!isPageLoad)
                {
                    areaOfficeSelect.val(null).trigger('change');
                }
                // Remove 'd-none' class if "Collection Point" is selected
                collectionPointDiv.classList.remove('d-none');
                
            } else if (selectedValue === 'area_office') {
                // Reset the "Collection Point" dropdown and add 'd-none' class if "Area Office" is selected
                if(!isPageLoad)
                {
                    collectionPointSelect.val(null).trigger('change'); // Reset to the first option
                    areaOfficeSelect.val(null).trigger('change');
                } // Reset to the first option
                collectionPointDiv.classList.add('d-none');
            }
        }
    </script>

    <script>
        $('#area_office_id').on('change', function() {
            var baseUrl = '{{ URL::to('/') }}';
            var areaOfficeId = $(this).val();
            var levelOfExpense = $('#level_of_expense').val();
            
            // Make sure a valid Area Office is selected and "Collection Point" is selected in "Level Of Expense"
            if (areaOfficeId && levelOfExpense === 'mcc') {
                // console.log(areaOfficeId, levelOfExpense);
                // Make an AJAX request to get the collection points for the selected Area Office
                fetch(baseUrl +`/get-ao-collection-points/${areaOfficeId}`)
                    .then(response => response.json())
                    .then(data => {
                        console.log(data)
                        // Get the collection points dropdown
                        var collectionPointsSelect = $('#collection_point_id');
                        
                        // Clear the current options
                        collectionPointsSelect.html('<option value="" selected disabled>Please Select Collection Point</option>');
                        
                        // Add the new options from the fetched data
                        data.forEach(function(collectionPoint) {
                            var option = $('<option>', {
                                value: collectionPoint._id,
                                text: collectionPoint.name
                            });
                            collectionPointsSelect.append(option);
                        });

                        // Trigger select2 to refresh the dropdown options
                        collectionPointsSelect.trigger('change.select2');

                        if (!collectionPointsSelect.hasClass('select2-hidden-accessible')) {
                            collectionPointsSelect.select2();  // Reinitialize select2 if needed
                        }
                    })
                    .catch(error => {
                        console.error('Error fetching collection points:', error);
                    });
            }
        });
    </script>

    <script>
        function setDraftFlag() {
            // Set the flag to '0' when Save as Draft is clicked
            document.getElementById('status').value = 0;
        }

        function setPendingFlag() {
            // Set the flag to '2' when Submit is clicked
            document.getElementById('status').value = 2;
        }
    </script>

    <script>
        let selectedAreaOfficeId = null;
        let selectedAccountType = null;

        function loadBankAccounts() {
        // $('#area_office_id').on('change', function() {
            var baseUrl = '{{ URL::to('/') }}';
            var areaOfficeId = $('#area_office_id').val();
            var accountType = $('#type').val();
            // console.log(areaOfficeId);
            // Make sure a valid Area Office is selected and "Collection Point" is selected in "Level Of Expense"
            console.log(selectedAreaOfficeId, selectedAccountType);
                if (areaOfficeId && accountType === 'bank') {
                    // console.log(areaOfficeId, levelOfExpense);
                    // Make an AJAX request to get the collection points for the selected Area Office
                    fetch(baseUrl +`/get-ao-bank-accounts/${areaOfficeId}`)
                        .then(response => response.json())
                        .then(data => {
                        console.log(data)
                        // Get the collection points dropdown
                        var aoAccountsSelect = $('#bank_id');
                        var errorMessageContainer = $('#error-message');
                        
                        // Clear the current options
                        aoAccountsSelect.html('<option value="" selected disabled>Please Select Bank Account</option>');
                        errorMessageContainer.html('');

                        if (data.length === 0) {
                            // If no bank accounts are returned, show an error message  
                            errorMessageContainer.html('<span class="text-danger">No bank account added against the selected Area Office.</span>');
                        } else {
                            // Add the new options from the fetched data
                            data.forEach(function(aoAccount) {
                                var amount = aoAccount.amount ? aoAccount.amount : 0;
                                var option = $('<option>', {
                                    value: aoAccount._id,
                                    text: aoAccount.bank_acc_title + ' (Balance: ' + amount + ')'
                                });
                                aoAccountsSelect.append(option);
                            });

                            aoAccountsSelect.prop('selectedIndex', 1);

                            // Trigger select2 to refresh the dropdown options
                            aoAccountsSelect.trigger('change.select2');
                        }

                        if (!aoAccountsSelect.hasClass('select2-hidden-accessible')) {
                            aoAccountsSelect.select2();  // Reinitialize select2 if needed
                        }
                    })
                    .catch(error => {
                        console.error('Error fetching ao accounts:', error);
                    });
                } else {
                        console.log("No valid Area Office selected.");
                }
        }
        // });

        // Get petty cash wallets
        function loadPettyCashWallets() {
        // $('#bank_id').on('change', function() {
            var baseUrl = '{{ URL::to('/') }}';
            // var bankId = $(this).val();
            var accountType = $('#type').val();
            var areaOfficeId = $('#area_office_id').val();
           
            // Make sure a valid Area Office is selected and "Collection Point" is selected in "Level Of Expense"
            if (areaOfficeId && accountType === 'petty_cash') {
                // console.log(bankId, levelOfExpense);
                // Make an AJAX request to get the collection points for the selected Area Office
                fetch(baseUrl +`/get-petty-cash-wallets/${areaOfficeId}`)
                    .then(response => response.json())
                    .then(data => {
                        console.log(data)
                        // Get the collection points dropdown
                        var pettyCashWalletsSelect = $('#petty_cash_wallet_id');
                        var errorMessageContainer = $('#pc-error-message');

                        // Clear the current options
                        pettyCashWalletsSelect.html('<option value="" selected disabled>Please Select Collection Point</option>');
                        errorMessageContainer.html('');

                        if (data.length === 0) {
                            // If no bank accounts are returned, show an error message  
                            errorMessageContainer.html('<span class="text-danger">No matching Petty Cash Wallet found for the selected Area Office.</span>');
                        } else {
                            // Add the new options from the fetched data
                            data.forEach(function(pettyCashWallet) {
                                var amount = pettyCashWallet.amount ? pettyCashWallet.amount : 0;
                                var option = $('<option>', {
                                    value: pettyCashWallet._id,
                                    text: pettyCashWallet.title + ' (Balance: ' + amount + ')'
                                });
                                pettyCashWalletsSelect.append(option);
                            });

                            pettyCashWalletsSelect.prop('selectedIndex', 1);

                            // Trigger select2 to refresh the dropdown options
                            pettyCashWalletsSelect.trigger('change.select2');
                        }

                        if (!pettyCashWalletsSelect.hasClass('select2-hidden-accessible')) {
                            pettyCashWalletsSelect.select2();  // Reinitialize select2 if needed
                        }
                    })
                    .catch(error => {
                        console.error('Error fetching collection points:', error);
                    });
            }
        }
        // });

        $('#area_office_id').on('change', function() {
            selectedAreaOfficeId = $(this).val();
            loadPettyCashWallets();  // Try to load wallets if account type is already selected
            loadBankAccounts();
        });

        $('#type').on('change', function() {
            selectedAccountType = $(this).val();
            loadPettyCashWallets();  // Try to load wallets if area office is already selected
            loadBankAccounts();

            // Clear petty cash wallets if "bank" is selected
            if (selectedAccountType === 'bank') {
                var pettyCashWalletsSelect = $('#petty_cash_wallet_id');
                pettyCashWalletsSelect.html('<option value="" selected disabled>Select Wallet</option>');
                pettyCashWalletsSelect.prop('disabled', true);
                $('#pc-error-message').html(''); // Clear any error messages
                pettyCashWalletsSelect.trigger('change.select2'); // Refresh select2

                // Enable Bank dropdown
                var bankAccountSelect = $('#bank_id');
                bankAccountSelect.prop('disabled', false);
                bankAccountSelect.trigger('change.select2'); // Refresh select2
            }

            if (selectedAccountType === 'petty_cash') {
                var bankAccountSelect = $('#bank_id');
                bankAccountSelect.html('<option value="" selected disabled>Select Bank Account</option>');
                bankAccountSelect.prop('disabled', true);
                $('#error-message').html(''); // Clear any error messages
                bankAccountSelect.trigger('change.select2'); // Refresh select2

                // Enable Wallet dropdown
                var pettyCashWalletsSelect = $('#petty_cash_wallet_id');
                pettyCashWalletsSelect.prop('disabled', false);
                pettyCashWalletsSelect.trigger('change.select2'); // Refresh select2
            }
        });

        // var isPageLoad = true;
        // // show and hide petty cash wallets dropdown
        // function showPettyCashDropdown() {
        //     var selectedValue = document.getElementById('type').value;
        //     var pettyCashWalletsDiv = document.getElementById('petty_cash_wallets_div');
        //     // var collectionPointSelect = document.getElementById('collection_point_id');
        //     var pettyCashSelect = $('#petty_cash_wallet_id');
        //     if (selectedValue === 'petty_cash') {
        //         // areaOfficeSelect.val(null).trigger('change');
        //         // Remove 'd-none' class if "Collection Point" is selected
        //         pettyCashWalletsDiv.classList.remove('d-none');
                
        //     } else if (selectedValue === 'bank') {
        //         // Reset the "Collection Point" dropdown and add 'd-none' class if "Area Office" is selected
        //         if(!isPageLoad)
        //         {
        //             pettyCashSelect.val(null).trigger('change'); // Reset to the first option
        //         }
        //         pettyCashWalletsDiv.classList.add('d-none');
        //     }
        // }
        // window.onload = function() {
        //     showPettyCashDropdown();
        //     showCollectionPoints();
        // };
    </script>

    <script>
        // Account type
        const accountTypes = [
            { value: "bank", text: "Bank" },
            { value: "petty_cash", text: "Petty Cash" }
        ];
        // Get the select element
        const accountTypeSelect = document.getElementById('type');
        const selectedType = "{{ $generalExpense->type }}";
        // Dynamically add options
        accountTypes.forEach(function(type) {
            let option = document.createElement('option');
            option.value = type.value;
            option.text = type.text;

            if (type.value === selectedType) {
                option.selected = true;
            }

            accountTypeSelect.add(option);
        });
        // Account type
    </script>

    <script>
        document.getElementById('amount').addEventListener('input', function(event) {
            var amount = event.target.value;
            var regex = /^[0-9]*\.?[0-9]+$/; // Valid float regex
            if (!regex.test(amount)) {
                event.target.setCustomValidity("Please enter a valid amount.");
            } else if (parseFloat(amount) < 0) {
                event.target.setCustomValidity("Opening balance cannot be negative.");
            } else {
                event.target.setCustomValidity(""); // Reset the error message
            }
        });
    </script>

    <script>
        // Function to preview the uploaded file (Image or PDF)
        function previewUploadedFile(event) {
            const file = event.target.files[0];  // Get the selected file
            const maxImageSize = 1024 * 1024;    // 1MB in bytes for images
            const maxPdfSize = 2 * 1024 * 1024;  // 5MB in bytes for PDFs

            if (file) {
                const fileType = file.type;
                const imagePreview = document.getElementById('imagePreview');
                const pdfPreview = document.getElementById('pdfPreview');
                const existingImage = document.getElementById('existingImage');
                const existingPdf = document.getElementById('existingPdf');

                // Hide the existing file previews
                if (existingImage) existingImage.style.display = 'none';
                if (existingPdf) existingPdf.style.display = 'none';

                if (fileType.startsWith('image/')) {
                    if (file.size > maxImageSize) {
                        alert('The selected image size exceeds 1 MB. Please choose a smaller image.');
                        event.target.value = ''; // Clear the file input
                        imagePreview.style.display = 'none';  // Hide image preview
                        pdfPreview.style.display = 'none';    // Hide PDF preview
                        return;
                    }

                    const reader = new FileReader();
                    reader.onload = function(e) {
                        // Show image preview and hide PDF preview
                        imagePreview.src = e.target.result;  
                        imagePreview.style.display = 'block';
                        pdfPreview.style.display = 'none';
                    };
                    reader.readAsDataURL(file);  // Read the file as a data URL (base64)

                } else if (fileType === 'application/pdf') {
                    if (file.size > maxPdfSize) {
                        alert('The selected PDF size exceeds 2 MB. Please choose a smaller PDF.');
                        event.target.value = ''; // Clear the file input
                        imagePreview.style.display = 'none';  // Hide image preview
                        pdfPreview.style.display = 'none';    // Hide PDF preview
                        return;
                    }

                    const fileURL = URL.createObjectURL(file);
                    
                    // Show PDF preview as a link and hide image preview
                    pdfPreview.href = fileURL;
                    pdfPreview.style.display = 'inline-block';
                    pdfPreview.textContent = 'View PDF';
                    imagePreview.style.display = 'none';
                }
            }
        }

        function updateFile() {
            const formData = new FormData();
            const fileInput = document.getElementById('file');
            const file = fileInput.files[0];

            if (!file) {
                alert('Please select a file to upload.');
                return;
            }

            // Append the file to the form data
            formData.append('file', file);

            // Append the code to the form data
            formData.append('generalExpenseId', '{{ $generalExpenseId }}');  // Add the code here

            // Make AJAX request to update the file and send the code along
            $.ajax({
                url: '{{ route("update.general.expense.file") }}',  // Replace with your update route
                type: 'POST',
                data: formData,
                processData: false,  // Do not process data (required for FormData)
                contentType: false,  // Do not set content-type (required for FormData)
                headers: {
                    'X-CSRF-TOKEN': '{{ csrf_token() }}'  // Include CSRF token for security
                },
                success: function(response) {
                    if(response.success == true) {
                        alert('File updated successfully!');
                        // You can refresh the page or update the preview here
                        location.reload();  // Reload the page to show the updated file
                    }else{
                        alert('Error updating file: ' + response.message);
                    }
                },
                error: function(xhr, status, error) {
                    alert('Error updating file: ' + error);
                }
            });
        }
    </script>

    <script>
        $('#created_counter').text('{{ $count }}');

        function delRecord(id) {
            Swal.fire({
                title: 'Are you sure?',
                text: "You won't be able to revert this!",
                icon: 'warning',
                showCancelButton: true,
                confirmButtonColor: '#3085d6',
                cancelButtonColor: '#d33',
                confirmButtonText: 'Yes, delete it!'
            }).then((result) => {
                if (result.isConfirmed) {
                    $.ajax({
                        type: "get",
                        dataType: 'JSON',
                        url: '{{ route('general.expense.del') }}',
                        data: {
                            id: id
                        },
                        success: function(response) {
                            if (response.success) {
                                $('#row_' + id).remove();
                                let counter = parseInt($('#created_counter').text()) - 1;
                                $('#created_counter').text(counter);
                                if (counter < 1) {
                                    $('#empty_tr').show();
                                    $('#sbt_tr').hide();
                                }

                                Swal.fire(
                                    'Done!',
                                    response.message,
                                    'success'
                                ).then(() => {
                                    // Reload the window after the alert is closed
                                    window.location.reload();
                                });
                            } else {
                                Swal.fire(
                                    'Oops!',
                                    response.message,
                                    'error'
                                )
                            }
                        }
                    });
                }
            })
        }
    </script>

    <script>
        function submitForm() {
            if(validateForm())
            {
                // Get form field values
                let GEId = $('#GEId').val();
                let code = $('#code').val();
                let exp_date = $('#exp_date').val();
                let expense_category_id = $('#expense_category_id').val();
                let expense_category = $('#expense_category_id option:selected').text();
                let level_of_expense = $('#level_of_expense').val();
                let area_office = $('#area_office_id option:selected').text();
                let area_office_id = $('#area_office_id').val();
                let expense_from = $('#type').val();
                let collection_point_id = $('#collection_point_id').val();
                let collection_point = $('#collection_point_id option:selected').text();
                let type = $('#type').val();
                let bank_id = $('#bank_id').val();
                let bank = $('#bank_id option:selected').text().replace(/\(.*?\)/g, '').trim();
                let petty_cash_wallet = $('#petty_cash_wallet_id option:selected').text().replace(/\(.*?\)/g, '').trim();
                let petty_cash_wallet_id = $('#petty_cash_wallet_id').val();
                let amount = $('#amount').val();
                let remarks = $('#remarks').val();

                if(level_of_expense == 'area_office') {
                    collection_point = 'N/A';
                }

                if(expense_from == 'bank') {
                    petty_cash_wallet = 'N/A';
                } else {
                    bank = 'N/A';
                }
                $('.sbt_btn').toggleClass("btn-danger", "btn-primary");
                // $('.spinner').toggleClass("d-none","d-inline");

                $.ajax('{{ route('expense.add') }}', {
                    type: 'get',
                    data: {
                        general_expense_id: GEId,
                        expense_category_id: expense_category_id,
                        expense_category: expense_category,
                        exp_date: exp_date,
                        level_of_expense: level_of_expense,
                        area_office_id: area_office_id,
                        area_office: area_office,
                        type: type,
                        bank_id: bank_id,
                        bank: bank,
                        petty_cash_wallet_id: petty_cash_wallet_id,
                        petty_cash_wallet: petty_cash_wallet,
                        collection_point_id: collection_point_id,
                        collection_point: collection_point,
                        amount: amount,
                        remarks: remarks
                    },
                    success: function(response) {
                        if (response.success == true) {
                            showAlert('success', response.message);
                            location.reload();
                            $('#expense_table').find('tbody').prepend(response.data);
                            $('#created_counter').text(parseInt($('#created_counter').text()) + 1);
                            $('#sbt_tr').show();
                            $('#empty_tr').hide();
                        } else {
                            showAlert('error', response.message);
                        }
                        $('.sbt_btn').toggleClass("btn-danger", "btn-primary");
                        // $('.spinner').toggleClass("d-none","d-inline");
                    },
                    error: function(jqXhr, textStatus, errorMessage) {
                        alert('Error Occurred')
                    }
                });

            }else{
                return false;
            }
        }

        function validateForm() {
            let exp_date = $('#exp_date').val();
            let expense_category_id = $('#expense_category_id').val();
            let level_of_expense = $('#level_of_expense').val();
            let area_office_id = $('#area_office_id').val();
            let collection_point_id = $('#collection_point_id').val();
            let amount = $('#amount').val();
            let type = $('#type').val();
            let petty_cash_wallet_id = $('#petty_cash_wallet_id').val();
            let bank_id = $('#bank_id').val();
            let remarks = $('#remarks').val();

            if (!exp_date) {
                showAlert('error', 'Expense Date is required');
                $('#exp_date').addClass('is-invalid');
                return false;
            } else {
                $('#exp_date').removeClass('is-invalid');
            }

            if (!expense_category_id) {
                showAlert('error', 'Expense Category is required');
                $('#expense_category_id').addClass('is-invalid');
                return false;
            } else {
                $('#expense_category_id').removeClass('is-invalid');
            }

            if (!level_of_expense) {
                showAlert('error', 'Level of Expense is required');
                $('#level_of_expense').addClass('is-invalid');
                return false;
            } else {
                $('#level_of_expense').removeClass('is-invalid');
            }

            if (!area_office_id) {
                showAlert('error', 'Area Office is required');
                $('#area_office_id').addClass('is-invalid');
                return false;
            } else {
                $('#area_office_id').removeClass('is-invalid');
            }

            if (level_of_expense === 'mcc' && !collection_point_id) {
                showAlert('error', 'Collection Point is required when Level of Expense is MCC');
                $('#collection_point_id').addClass('is-invalid');
                return false;
            } else {
                $('#collection_point_id').removeClass('is-invalid');
            }

            if (!amount || isNaN(amount) || parseFloat(amount) < 0 || !Number.isInteger(parseFloat(amount))) {
                showAlert('error', 'Amount must be a valid number greater than or equal to 0');
                $('#amount').addClass('is-invalid');
                return false;
            } else {
                $('#amount').removeClass('is-invalid');
            }

            if (!type) {
                showAlert('error', 'Type is required');
                $('#type').addClass('is-invalid');
                return false;
            } else {
                $('#type').removeClass('is-invalid');
            }

            if (type === 'petty_cash' && !petty_cash_wallet_id) {
                showAlert('error', 'Petty Cash Wallet is required when Type is Petty Cash');
                $('#petty_cash_wallet_id').addClass('is-invalid');
                return false;
            } else {
                $('#petty_cash_wallet_id').removeClass('is-invalid');
            }

            if (type === 'bank' && !bank_id) {
                showAlert('error', 'Bank is required when Type is Bank');
                $('#bank_id').addClass('is-invalid');
                return false;
            } else {
                $('#bank_id').removeClass('is-invalid');
            }

            if (!remarks) {
                showAlert('error', 'Remarks are required');
                $('#remarks').addClass('is-invalid');
                return false;
            } else {
                $('#remarks').removeClass('is-invalid');
            }

            return true;
        }

        $('#submitBatch').on('click', function (e) {
            e.preventDefault(); // Prevent the default behavior of form submission
            
            // Assuming you have the generalExpenseId available in the button's data attribute
            let generalExpenseId = $(this).data('general-expense-id'); 

            $.ajax({
                url: '{{ route("general.expense.batch.submit", ":generalExpenseId") }}'.replace(':generalExpenseId', generalExpenseId),
                method: 'GET', // Since your route uses GET method
                dataType: 'json',
                success: function (response) {
                    if (response.success && response.redirect_url) {
                        // Redirect to the specified route
                        window.location.href = response.redirect_url;
                    } else {
                        alert('Error: ' + response.message); // Show error message
                    }
                },
                error: function (xhr, status, error) {
                    console.error('AJAX Error:', error);
                    alert('Failed to submit the batch. Please try again.');
                }
            });
        });

    </script>

@endsection