@extends('layouts.app')

@section('content')
<div class="container">
    <h2>Ledger Report</h2>

    <!-- Ledger Report Criteria Selection Form -->
    <form method="GET" action="{{ url('/ledger_report') }}" class="mb-4">
        <div class="row">
            <!-- Account Selection -->
            <div class="col-md-4">
                <label for="account_id">Account Name:</label>
                <select name="account_id" class="form-control" required>
                    <option value="">Select Account</option>
                    @foreach($accounts as $account)
                        <option value="{{ $account->Account_ID }}" 
                            {{ request('account_id') == $account->Account_ID ? 'selected' : '' }}>
                            {{ $account->Account_Title }}
                        </option>
                    @endforeach
                </select>
            </div>

            <!-- From Date -->
            <div class="col-md-3">
                <label for="from_date">From Date:</label>
                <input type="date" name="from_date" class="form-control" value="{{ request('from_date') }}" required>
            </div>

            <!-- To Date -->
            <div class="col-md-3">
                <label for="to_date">To Date:</label>
                <input type="date" name="to_date" class="form-control" value="{{ request('to_date') }}" required>
            </div>

            <!-- Submit Button -->
            <div class="col-md-2 d-flex align-items-end">
                <button type="submit" class="btn btn-primary w-100">Generate Report</button>
            </div>
        </div>
    </form>

    <!-- Ledger Report Table -->
    @if(isset($ledgerEntries) && count($ledgerEntries) > 0)
        <table class="table table-bordered">
            <thead>
                <tr>
                    <th>Account ID</th>
                    <th>Account Title</th>
                    <th>Voucher Type</th>
                    <th>Voucher Date</th>
                    <th>Remarks</th>
                    <th>Debit</th>
                    <th>Credit</th>
                    <th>Narration</th>
                </tr>
            </thead>
            <tbody>
                @foreach($ledgerEntries as $entry)
                    <tr>
                        <td>{{ $entry->Account_ID }}</td>
                        <td>{{ $entry->Account_Text }}</td>
                        <td>{{ $entry->VoucherType }}</td>
                        <td>{{ $entry->VoucherDate }}</td>
                        <td>{{ $entry->Remarks }}</td>
                        <td>{{ $entry->entryType == 'D' ? $entry->Amount : 0 }}</td>
                        <td>{{ $entry->entryType == 'C' ? $entry->Amount : 0 }}</td>
                        <td>{{ $entry->Entry_Narration ?? 'N/A' }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    @else
        <p class="text-center text-danger">No records found for the selected criteria.</p>
    @endif
</div>
@endsection