@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' : '' }}>
                            {{ strtoupper($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>

@if(isset($accountTitle) && isset($openingBalance))
    <div class="mb-3">
        <h5><strong>Account Title:</strong> {{ $accountTitle }}</h5>
        <h6><strong>Opening Balance:</strong> {{ number_format($openingBalance, 2) }}</h6>
    </div>
@endif

    <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>Voucher Date</th>
                    <th>Remarks</th>
                    <th>Cheque</th>
                    <th>Debit</th>
                    <th>Credit</th>
<th>Cl. Balance</th> {{-- NEW --}}
                </tr>
            </thead>
            <tbody>
@php
    $balance = 0;
@endphp   
             @forelse($data as $row)
                <tr>
                    <td>{{ $row->Voucher }}</td>

@php
    $amount = floatval($row->Amount);
@endphp
 @php
        $balance += $row->Amount;
    @endphp
                    <td>{{ $row->VoucherDate }}</td>
                    <td>{{ $row->Remarks }}</td>
                    <td>{{ $row->Cheque_No }}</td>
                    <td>{{ $amount > 0 ? number_format($amount, 2) : '' }}</td>
                    <td>{{ $amount < 0 ? number_format(abs($amount), 2) : '' }}</td>

<td>{{ number_format($balance, 2) }}</td> {{-- Cl. Balance --}}
                </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