@extends('backend.layouts.app')
@section('backend_title', 'Admin Brand Create')

@section('backend_content')

    <div class="my-4 row">
        <div class="col-lg-12 col-md-12 col-12">
            <div class="card">
                <!-- Card header -->
                <div class="pb-0 card-header">
                    <div class="d-lg-flex justify-content-between">
                        <div>
                            <h5 class="mb-0">Bank Ledger</h5>
                        </div>
                    </div>
                </div>
                <div class="px-0 pb-0 card-body">
                    <form action="{{ route('income_Expense_ladger') }}" method="GET">
                        <div class="row">
                            <div class="col-lg-2 col-md-4 col-11 ms-4 mb-3">
                                <label> Ledger Type</label>
                                <select class="form-control" id="tr_type">
                                    <option value="" selected>Select any one</option>
                                    <option value="withdraw">Payment</option>
                                    <option value="deposit">Receive</option>
                                </select>
                            </div>

                            <div class="col-lg-2 col-md-4 col-11 ms-4 mb-3">
                                <label> Ledger Head</label>
                                <select name="tr_id" class="form-control" id="tr_id">
                                    <option value="" selected>Select any one</option>
                                </select>
                            </div>
                            <div class="col-lg-2 col-md-4 col-11 ms-4 mb-3">
                                <label for="date_from">Filter From Date</label>
                                <input type="date" name="date_from" class="form-control"
                                    value="{{ old('date_from', request()->date_from) }}">
                            </div>

                            <div class="col-lg-2 col-md-4 col-11 ms-4 mb-3">
                                <label for="date_to">Filter To Date</label>
                                <input type="date" name="date_to" class="form-control"
                                    value="{{ old('date_to', request()->date_to) }}">
                            </div>
                            <div class="col-lg-1 col-md-4 col-11 mb-3 ms-4 d-flex align-items-end">
                                <button type="submit" class="btn btn-primary mb-0">Filter</button>
                            </div>
                        </div>
                    </form>

                    <!-- Responsive Table -->
                    <div class="table-responsive">
                        <table class="table table-hover" id="products-list">
                            <thead>
                                <tr>
                                    <th class="fs-6">Sl No.</th>
                                    <th class="fs-6">Tr. Date</th>
                                    <th class="fs-6">Tr. Number</th>
                                    <th class="fs-6">Payment Type</th>
                                    <th class="fs-6">Tr. Head</th>
                                    <th class="fs-6">Tr. Description</th>
                                    <th class="fs-6">Amount In</th>
                                    <th class="fs-6">Amount Out</th>
                                </tr>
                            </thead>
                            <tbody>
                                @isset($margedValue)
                                @php $i = 1; @endphp
                                    @forelse ($margedValue as $key => $item)
                                        <tr>
                                            <td>{{ $i }}</td>
                                            <td>{{ $item->tr_date }}</td>
                                            <td>{{ $item->tr_number }}</td>
                                            <td>{{ $item->bank_accounts ? 'Bank Payment' : 'Cash Payment' }}</td>
                                            <td>
                                                {{ $item->expenses && $item->expenses?->id == $item->expense_id
                                                    ? $item->expenses?->head_of_expense
                                                    : ($item->incomes && $item->incomes?->id == $item->income_id
                                                        ? $item->incomes?->head_of_income
                                                        : '') }}
                                            </td>
                                            <td>
                                                <textarea disabled cols="40" rows="1">{{ $item->note }}</textarea>
                                            </td>
                                            <td class="text-center">{{ number_format($item->amount_in, 2, '.', ',') }}</td>
                                            <td class="text-center">{{ number_format($item->amount_out, 2, '.', ',') }}</td>
                                        </tr>
                                        @php $i++; @endphp
                                    @empty
                                        <tr>
                                            <td colspan="8" class="text-left">Data Not Found!!</td>
                                        </tr>
                                    @endforelse
                                @endisset

                                <tr>
                                    <th colspan="5"></th>
                                    <th class="text-end">Total : </th>
                                    <th class="text-center">{{ number_format($totalIn, 2, '.', ',') }}</th>
                                    <th class="text-center">{{ number_format($totalOut, 2, '.', ',') }}</th>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <script>
        document.getElementById('tr_type').addEventListener('change', function() {
            var trType = this.value;
            var trIdSelect = document.getElementById('tr_id');
            var expenseList = @json($expenseList);
            var incomeList = @json($incomeList);

            // Clear the existing options in Transaction Head dropdown
            trIdSelect.innerHTML = '<option value="" selected>Select any one</option>';

            if (trType === 'withdraw') {
                // Populate with expense list
                expenseList.forEach(function(expense) {
                    var option = document.createElement('option');
                    option.value = 'expense_' + expense.id;
                    option.text = expense.head_of_expense;
                    trIdSelect.appendChild(option);
                });
            } else if (trType === 'deposit') {
                // Populate with income list
                incomeList.forEach(function(income) {
                    var option = document.createElement('option');
                    option.value = 'income_' + income.id;
                    option.text = income.head_of_income;
                    trIdSelect.appendChild(option);
                });
            }
        });
    </script>

@endsection

@section('backend_scripts')

@endsection