@extends('layouts.app')

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

    {{-- Back Button --}}
    <a href="{{ url()->previous() }}" class="btn btn-secondary mb-3">Back</a>

    {{-- Filter Form --}}
    <form method="POST" action="{{ url('account-report/filter') }}" class="row g-3 mb-4">
        @csrf
        <div class="col-md-3">
            <label for="account_id" class="form-label">Account</label>
            <select name="account_id" id="account_id" class="form-select" required>
                <option value="">-- Select Account --</option>
                @foreach ($accounts as $account)
<option value="{{ $account->Account_ID }}">{{ $account->Account_Title }}</option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3">
            <label for="fromDate" class="form-label">From Date</label>
            <input type="date" name="fromDate" id="fromDate" class="form-control" required>
        </div>
        <div class="col-md-3">
            <label for="toDate" class="form-label">To Date</label>
            <input type="date" name="toDate" id="toDate" class="form-control" required>
        </div>
        <div class="col-md-3 align-self-end">
            <button type="submit" class="btn btn-primary w-100">Filter Report</button>
        </div>
    </form>

    {{-- Export & Print Buttons --}}
    @if(isset($data))
    <div class="mb-3">
        <a href="#" onclick="window.print()" class="btn btn-outline-dark">Print</a>

        <form action="{{ url('account-report/export-pdf') }}" method="POST" style="display:inline;">
            @csrf
            <input type="hidden" name="account_id" value="{{ request('account_id') }}">
            <input type="hidden" name="fromDate" value="{{ request('fromDate') }}">
            <input type="hidden" name="toDate" value="{{ request('toDate') }}">
            <button type="submit" class="btn btn-outline-danger">Export PDF</button>
        </form>

        <form action="{{ url('account-report/export-excel') }}" method="POST" style="display:inline;">
            @csrf
            <input type="hidden" name="account_id" value="{{ request('account_id') }}">
            <input type="hidden" name="fromDate" value="{{ request('fromDate') }}">
            <input type="hidden" name="toDate" value="{{ request('toDate') }}">
            <button type="submit" class="btn btn-outline-success">Export Excel</button>
        </form>
    </div>
    @endif

    {{-- Report Table --}}
    @if(isset($data) && count($data) > 0)
    <table class="table table-bordered table-striped">
        <thead class="table-dark">
            <tr>
                <th>#</th>
                <th>Voucher ID</th>
                <th>Voucher Date</th>
                <th>Account Title</th>
                <th>Debit</th>
                <th>Credit</th>
                <th>Remarks</th>
                <th>Site</th>
                <th>Company</th>
            </tr>
        </thead>
        <tbody>
            @foreach($data as $i => $row)
                <tr>
                    <td>{{ $i + 1 }}</td>
                    <td>{{ $row->Voucher_ID }}</td>
                    <td>{{ $row->Voucher_Date }}</td>
                    <td>{{ $row->Account_Title }}</td>
                    <td>{{ number_format($row->Debit, 2) }}</td>
                    <td>{{ number_format($row->Credit, 2) }}</td>
                    <td>{{ $row->Remarks }}</td>
                    <td>{{ $row->Site }}</td>
                    <td>{{ $row->Company }}</td>
                </tr>
            @endforeach
        </tbody>
    </table>
    @elseif(isset($data))
        <div class="alert alert-warning">
            No records found for selected filters.
        </div>
    @endif
</div>
@endsection