@extends('layouts/contentLayoutMaster')
@section('title', 'Add Cash Flow Details')
@section('vendor-style')
    <!-- vendor css files -->
    <link rel="stylesheet" href="{{ asset('vendors/css/forms/select/select2.min.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">Add Cash Flow Details</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" action="{{ route('cash-flow.store') }}" method="POST">
                            @csrf
                            <div class="row">

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

                                <div class="col-md-6 col-12">
                                    <label class="form-label">Area Office *</label>
                                    <select class="form-control select2" name="area_office_id" id="area_office_id" onchange="selectRelatedUser()">
                                        <option selected disabled>Please Select Area Office</option>
                                        @foreach ($areaOffices as $areaOffice)
                                            <option value="{{ $areaOffice->id }}" {{ old('area_office_id') == $areaOffice->_id ? 'selected' : '' }}>{{ $areaOffice->name }}
                                            </option>
                                        @endforeach
                                    </select>
                                    @error('area_office_id')
                                        <span class="text-danger">{{ $message }}</span>
                                    @enderror
                                </div>

                                <div class="col-md-6 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="type">Cash Flow Type</label>

                                        <select class="form-select" name="type" id="type" onchange="showPettyCashDropdown()">
                                            <option selected disabled>Please Select Cash Flow Type</option>
                                        </select>

                                        @error('type')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>

                                <div class="col-md-6 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="select2-multiple">Bank * (select area office first)</label>
                                        <select class="form-select" 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-6 col-12" id="petty_cash_wallets_div">
                                    <div class="mb-1">
                                        <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 Collection Point</option>
                                        </select>
                                        @error('petty_cash_wallet_id')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                        <div id="pc-error-message"></div> 
                                    </div>
                                </div>
                                
                                <div class="col-md-6 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="trx_date">Transaction Date *</label>
                                        <input type="date" id="trx_date" class="form-control" placeholder="Trx Date"
                                            name="trx_date" value="{{ old('trx_date') }}" max="{{ date('Y-m-d') }}"/>
                                        @error('trx_date')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>

                                <div class="col-md-6 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-6 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="select2-multiple">User *</label>
                                        <select class="form-select" id="select2-multiple" name="user_id">
                                            <option selected disabled>Please Select User</option>
                                            @foreach ($users as $user)
                                                <option value="{{ $user->id }}">
                                                    {{ $user->name }}
                                                </option>
                                            @endforeach
                                        </select>
                                        @error('user_id')
                                            <span class="text-danger">{{ $message }}</span>
                                        @enderror
                                    </div>
                                </div>
                                
                                
                                <div class="col-md-6 col-12">
                                    <div class="mb-1">
                                        <label class="form-label" for="name-column">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-12">
                                    <button type="submit" class="btn btn-primary me-1">Submit</button>
                                    <button type="reset" class="btn btn-outline-secondary me-1">Reset</button>
                                    <a class="btn btn-outline-secondary cancel-btn"
                                        href="{{ route('cash-flow.index') }}">Cancel</a>
                                </div>
                            </div>
                        </form>
                    </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>
@endsection
@section('page-script')
    <!-- Page js files -->
    <script src="{{ asset('js/scripts/forms/form-select2.js') }}"></script>
    <script>
        // Array of account types
        const accountTypes = [
            { value: "bank", text: "Bank (Add Funds)" },
            { value: "petty_cash", text: "Petty Cash (Get Funds from Bank)" }
        ];
        // Get the select element
        const accountTypeSelect = document.getElementById('type');

        // Dynamically add options
        accountTypes.forEach(function(type) {
            let option = document.createElement('option');
            option.value = type.value;
            option.text = type.text;
            accountTypeSelect.add(option);
        });
    </script>

    <script>
        const users = @json($users);

        function selectRelatedUser() {
            // Get the selected area office ID
            let areaOfficeId = document.getElementById('area_office_id').value;
            console.log('areaOfficeId', areaOfficeId);
            // Get the transfer_to (user) select dropdown
            let transferToSelect = document.getElementById('select2-multiple');
            console.log('transferToSelect', transferToSelect);
            // Remove all options first (except the first "Please Select User" option)
            transferToSelect.innerHTML = '<option selected disabled>Please Select User</option>';
            
            users.forEach(function(user) {
                // Ensure access_level_ids is defined and is an array
                if (Array.isArray(user.access_level_ids)) {
                    // Loop through each access_level_id and check if it matches the areaOfficeId
                    user.access_level_ids.forEach(function(id) {
                        if (id === areaOfficeId) {
                            let option = document.createElement('option');
                            option.value = user._id;
                            option.text = user.name;
                            option.selected = true;
                            transferToSelect.appendChild(option);
                        }
                    });
                } else {
                    console.warn('access_level_ids is not an array for user:', user);
                }
            });

            // Trigger select2 to update (if using Select2)
            $('#select2-multiple').trigger('change');
        }
    </script>
    <script>
        $('#area_office_id').on('change', function() {
            var baseUrl = '{{ URL::to('/') }}';
            var areaOfficeId = $(this).val();
            console.log(areaOfficeId);
            // Make sure a valid Area Office is selected and "Collection Point" is selected in "Level Of Expense"
            
                // 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 matching bank account found for 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);
                        });

                        // Auto-select the first bank account option after adding
                        aoAccountsSelect.prop('selectedIndex', 1);  // Select the first option (index 1 to skip the placeholder)

                        // 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);
                });
        });
    </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>
        // Get petty cash wallets
        $('#area_office_id').on('change', function() {
            var baseUrl = '{{ URL::to('/') }}';
            var areaOfficeId = $(this).val();
            var accountType = $('#type').val();
        console.log(areaOfficeId, 'op');
            // Make sure a valid Area Office is selected and "Collection Point" is selected in "Level Of Expense"
            if (areaOfficeId && accountType === 'petty_cash') {
                // console.log(areaOfficeId, 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,data.length,'ok')
                        // 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 Bank Account.</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);
                            });

                            // 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);
                    });
            }
        });
    </script> --}}

    <script>
        // Variables to store selected areaOfficeId and accountType
        let selectedAreaOfficeId = null;
        let selectedAccountType = null;

        // Function to load petty cash wallets if both conditions are met
        function loadPettyCashWallets() {
            var baseUrl = '{{ URL::to('/') }}';
            
            if (selectedAreaOfficeId && selectedAccountType === 'petty_cash') {
                fetch(baseUrl + `/get-petty-cash-wallets/${selectedAreaOfficeId}`)
                    .then(response => response.json())
                    .then(data => {
                        // Get the petty cash wallets dropdown
                        var pettyCashWalletsSelect = $('#petty_cash_wallet_id');
                        var errorMessageContainer = $('#pc-error-message');

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

                        if (data.length === 0) {
                            // Show an error message if no wallets found
                            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);
                            });

                            // Auto-select the first bank account option after adding
                            pettyCashWalletsSelect.prop('selectedIndex', 1);  // Select the first option (index 1 to skip the placeholder)

                            // 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 petty cash wallets:', error);
                    });
            }
        }

        // Event handler for the Area Office dropdown
        $('#area_office_id').on('change', function() {
            selectedAreaOfficeId = $(this).val();
            loadPettyCashWallets();  // Try to load wallets if account type is already selected
        });

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

            // 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
            }else{
                $('#petty_cash_wallet_id').prop('disabled', false); // Re-enable the dropdown
            }
        });
    </script>
@endsection