@extends('layouts.app')

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

    <form method="POST" action="{{ route('account.report.filter') }}">
        @csrf
        <div class="row mb-3">
            <div class="col">
                <label>From Date:</label>
                <input type="date" name="fromDate" class="form-control" value="{{ request('fromDate') }}" required>
            </div>
            <div class="col">
                <label>To Date:</label>
                <input type="date" name="toDate" class="form-control" value="{{ request('toDate') }}" required>
            </div>
            <div class="col">
                <label>Account:</label>
                <select name="account_id" class="form-control" required>
                    <option value="">Select Account</option>
                    @foreach($accounts as $acc)
                        <option value="{{ $acc->Account_ID }}" {{ request('account_id') == $acc->Account_ID ? 'selected' : '' }}>
                            {{ $acc->Account_Title }}
                        </option>
                    @endforeach
                </select>
            </div>
            <!-- Site dropdown removed as it's not required in this report -->
            <div class="col">
                <label>&nbsp;</label>
                <button type="submit" class="btn btn-primary form-control">Generate</button>
            </div>
        </div>
    </form>

    @isset($data)
    <div class="mb-3 text-end">
        <!-- Updated back route -->
        <a href="{{ route('account.index') }}" class="btn btn-secondary">Back</a> <!-- Back button to the account report index -->
        <button onclick="window.print()" class="btn btn-dark">Print</button>

        <a href="{{ route('account.report.export.pdf', [
            'fromDate'   => request('fromDate'),
            'toDate'     => request('toDate'),
            'account_id' => request('account_id')
        ]) }}" class="btn btn-danger">Export PDF</a>

        <a href="{{ route('account.report.export.excel', [
            'fromDate'   => request('fromDate'),
            'toDate'     => request('toDate'),
            'account_id' => request('account_id')
        ]) }}" class="btn btn-success">Export To Excel</a>

        <a href="#" class="btn btn-info">Crystal Report</a> <!-- Placeholder -->
    </div>

    <div class="table-responsive printableArea">
        <table class="table table-bordered table-striped">
            <thead class="thead-dark">
                <tr>
                    <th>Account Title</th>
                    <th>Voucher ID</th>
                    <th>Debit</th>
                    <th>Credit</th>
                    <th>Voucher Date</th>
                    <th>Remarks</th>
                    <th>Cheque</th>
                    <th>Company</th>
                </tr>
            </thead>
            <tbody>
                @forelse($data as $row)
                <tr>
                    <td>{{ $row->Account_Title }}</td>
                    <td>{{ $row->Voucher }}</td>
@php
    $amount = floatval($row->Amount);
@endphp
                    <td>{{ $amount > 0 ? number_format($amount, 2) : '' }}</td>
                    <td>{{ $amount < 0 ? number_format(abs($amount), 2) : '' }}</td>
                    <td>{{ $row->VoucherDate }}</td>
                    <td>{{ $row->Remarks }}</td>
                    <td>{{ $row->Cheque_No }}</td>
                    <td>{{ $row->Company }}</td>
                </tr>
                @empty
                <tr>
                    <td colspan="10" class="text-center">No data found for the selected filters.</td>
                </tr>
                @endforelse
            </tbody>
        </table>
    </div>
    @endisset
</div>

<style>
@media print {
    body * {
        visibility: hidden;
    }
    .printableArea, .printableArea * {
        visibility: visible;
    }
    .printableArea {
        position: absolute;
        left: 0;
        top: 0;
        width: 100%;
    }
}
</style>
@endsection