@extends('layouts.master')

@section('page_title', 'Accounting Reports')

@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1>Accounting Reports</h1>
        <div>
            <a href="{{ route('accounts.index') }}" class="btn btn-outline-primary">
                <i class="fas fa-arrow-left"></i> Back to Accounting
            </a>
        </div>
    </div>

    <div class="row">
        <!-- Financial Position Reports -->
        <div class="col-md-6">
            <div class="card">
                <div class="card-header bg-primary text-white">
                    <h5 class="mb-0"><i class="fas fa-balance-scale"></i> Financial Position Reports</h5>
                </div>
                <div class="card-body">
                    <!-- Balance Sheet -->
                    <div class="d-flex justify-content-between align-items-center mb-3 p-3 border rounded">
                        <div>
                            <h6 class="mb-1">Balance Sheet</h6>
                            <p class="mb-0 text-muted small">
                                Assets, Liabilities, and Equity at a specific point in time.
                                Shows the financial position and health of the school.
                            </p>
                        </div>
                        <div>
                            <a href="{{ route('reports.balance-sheet') }}" class="btn btn-outline-primary btn-sm">
                                <i class="fas fa-chart-pie"></i> View
                            </a>
                        </div>
                    </div>

                    <!-- Trial Balance -->
                    <div class="d-flex justify-content-between align-items-center mb-3 p-3 border rounded">
                        <div>
                            <h6 class="mb-1">Trial Balance</h6>
                            <p class="mb-0 text-muted small">
                                Verifies that total debits equal total credits.
                                Essential for ensuring accounting accuracy.
                            </p>
                        </div>
                        <div>
                            <a href="{{ route('reports.trial-balance') }}" class="btn btn-outline-primary btn-sm">
                                <i class="fas fa-list-alt"></i> View
                            </a>
                        </div>
                    </div>

                    <!-- Chart of Accounts -->
                    <div class="d-flex justify-content-between align-items-center p-3 border rounded">
                        <div>
                            <h6 class="mb-1">Chart of Accounts</h6>
                            <p class="mb-0 text-muted small">
                                Complete listing of all accounts organized by type.
                                Reference for account codes and structure.
                            </p>
                        </div>
                        <div>
                            <a href="{{ route('reports.chart-of-accounts') }}" class="btn btn-outline-primary btn-sm">
                                <i class="fas fa-sitemap"></i> View
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- Performance Reports -->
        <div class="col-md-6">
            <div class="card">
                <div class="card-header bg-success text-white">
                    <h5 class="mb-0"><i class="fas fa-chart-line"></i> Performance Reports</h5>
                </div>
                <div class="card-body">
                    <!-- Income Statement -->
                    <div class="d-flex justify-content-between align-items-center mb-3 p-3 border rounded">
                        <div>
                            <h6 class="mb-1">Income Statement (P&L)</h6>
                            <p class="mb-0 text-muted small">
                                Revenue vs expenses over a period of time.
                                Shows whether the school is profitable or running at a deficit.
                            </p>
                        </div>
                        <div>
                            <a href="{{ route('reports.profit-loss') }}" class="btn btn-outline-success btn-sm">
                                <i class="fas fa-chart-bar"></i> View
                            </a>
                        </div>
                    </div>

                    <!-- Cash Flow Statement -->
                    <div class="d-flex justify-content-between align-items-center mb-3 p-3 border rounded">
                        <div>
                            <h6 class="mb-1">Cash Flow Statement</h6>
                            <p class="mb-0 text-muted small">
                                Tracks cash inflows and outflows from operations, investing, and financing.
                                Critical for assessing liquidity and cash management.
                            </p>
                        </div>
                        <div>
                            <a href="{{ route('reports.cash-flow') }}" class="btn btn-outline-success btn-sm">
                                <i class="fas fa-money-bill-wave"></i> View
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- School-Specific Reports -->
    <div class="row mt-4">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header bg-warning text-dark">
                    <h5 class="mb-0"><i class="fas fa-school"></i> School Management Reports</h5>
                </div>
                <div class="card-body">
                    <div class="row">
                        <!-- Fee Collection Report -->
                        <div class="col-md-6">
                            <div class="d-flex justify-content-between align-items-center mb-3 p-3 border rounded">
                                <div>
                                    <h6 class="mb-1">Fee Collection Report</h6>
                                    <p class="mb-0 text-muted small">
                                        Track fee collections by class, term, and payment status.
                                        Monitor collection rates and pending payments.
                                    </p>
                                </div>
                                <div>
                                    <a href="{{ route('reports.fee-collection') }}" class="btn btn-outline-warning btn-sm">
                                        <i class="fas fa-money-check-alt"></i> View
                                    </a>
                                </div>
                            </div>
                        </div>

                        <!-- Student Billing Report -->
                        <div class="col-md-6">
                            <div class="d-flex justify-content-between align-items-center mb-3 p-3 border rounded">
                                <div>
                                    <h6 class="mb-1">Student Billing Report</h6>
                                    <p class="mb-0 text-muted small">
                                        Comprehensive billing analysis with bill items breakdown.
                                        Track payments, discounts, and outstanding amounts.
                                    </p>
                                </div>
                                <div>
                                    <a href="{{ route('reports.student-billing') }}" class="btn btn-outline-warning btn-sm">
                                        <i class="fas fa-file-invoice-dollar"></i> View
                                    </a>
                                </div>
                            </div>
                        </div>

                        <!-- Accounts Receivable -->
                        <div class="col-md-6">
                            <div class="d-flex justify-content-between align-items-center mb-3 p-3 border rounded">
                                <div>
                                    <h6 class="mb-1">Accounts Receivable</h6>
                                    <p class="mb-0 text-muted small">
                                        Outstanding student balances with aging analysis.
                                        Identify overdue accounts and collection priorities.
                                    </p>
                                </div>
                                <div>
                                    <a href="{{ route('reports.accounts-receivable') }}" class="btn btn-outline-danger btn-sm">
                                        <i class="fas fa-exclamation-triangle"></i> View
                                    </a>
                                </div>
                            </div>
                        </div>

                        <!-- Accounts Payable -->
                        <div class="col-md-6">
                            <div class="d-flex justify-content-between align-items-center mb-3 p-3 border rounded">
                                <div>
                                    <h6 class="mb-1">Accounts Payable</h6>
                                    <p class="mb-0 text-muted small">
                                        Outstanding vendor payments with aging analysis.
                                        Manage payment priorities and cash flow planning.
                                    </p>
                                </div>
                                <div>
                                    <a href="{{ route('reports.accounts-payable') }}" class="btn btn-outline-danger btn-sm">
                                        <i class="fas fa-money-bill-alt"></i> View
                                    </a>
                                </div>
                            </div>
                        </div>

                        <!-- Expenditure Report -->
                        <div class="col-md-12">
                            <div class="d-flex justify-content-between align-items-center mb-3 p-3 border rounded">
                                <div>
                                    <h6 class="mb-1">Expenditure Report</h6>
                                    <p class="mb-0 text-muted small">
                                        Comprehensive expense analysis by category with monthly trends.
                                        Includes visual charts and export capabilities for budget planning.
                                    </p>
                                </div>
                                <div>
                                    <a href="{{ route('reports.expenditure') }}" class="btn btn-outline-success btn-sm">
                                        <i class="fas fa-chart-line"></i> View
                                    </a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Detailed Reports -->
    <div class="row mt-4">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header bg-info text-white">
                    <h5 class="mb-0"><i class="fas fa-search"></i> Detailed Transaction Reports</h5>
                </div>
                <div class="card-body">
                    <div class="row">
                        <!-- General Ledger -->
                        <div class="col-md-6">
                            <div class="d-flex justify-content-between align-items-center mb-3 p-3 border rounded">
                                <div>
                                    <h6 class="mb-1">General Ledger</h6>
                                    <p class="mb-0 text-muted small">
                                        Complete record of all transactions by account.
                                        Essential for audits and detailed transaction analysis.
                                    </p>
                                </div>
                                <div>
                                    <a href="{{ route('reports.general-ledger') }}" class="btn btn-outline-info btn-sm">
                                        <i class="fas fa-book"></i> View
                                    </a>
                                </div>
                            </div>
                        </div>

                        <!-- Account Statements -->
                        <div class="col-md-6">
                            <div class="p-3 border rounded">
                                <h6 class="mb-1">Individual Account Statements</h6>
                                <p class="mb-2 text-muted small">
                                    Detailed transaction history for a specific account.
                                </p>
                                <form action="{{ route('reports.account-statement', 'ACCOUNT_ID') }}" method="GET" class="d-flex">
                                    <select name="account_id" class="form-select form-select-sm me-2" required onchange="updateAccountUrl(this)">
                                        <option value="">Select Account</option>
                                        <!-- Accounts will be populated here -->
                                    </select>
                                    <button type="submit" class="btn btn-outline-info btn-sm" disabled id="account-statement-btn">
                                        <i class="fas fa-file-alt"></i> View
                                    </button>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Quick Actions -->
    <div class="row mt-4">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header bg-secondary text-white">
                    <h5 class="mb-0"><i class="fas fa-tools"></i> Quick Actions</h5>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-3">
                            <a href="{{ route('accounts.create') }}" class="btn btn-outline-primary w-100 mb-2">
                                <i class="fas fa-plus"></i><br>Create Account
                            </a>
                        </div>
                        <div class="col-md-3">
                            <a href="{{ route('journal-entries.create') }}" class="btn btn-outline-success w-100 mb-2">
                                <i class="fas fa-edit"></i><br>New Journal Entry
                            </a>
                        </div>
                        <div class="col-md-3">
                            <a href="{{ route('vouchers.create') }}" class="btn btn-outline-warning w-100 mb-2">
                                <i class="fas fa-receipt"></i><br>Create Voucher
                            </a>
                        </div>
                        <div class="col-md-3">
                            <a href="{{ route('accounting-periods.create') }}" class="btn btn-outline-info w-100 mb-2">
                                <i class="fas fa-calendar"></i><br>New Period
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Report Usage Guide -->
    <div class="row mt-4">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <h6 class="mb-0"><i class="fas fa-question-circle"></i> When to Use Each Report</h6>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-3">
                            <h6 class="text-primary">Monthly Financial Review</h6>
                            <ul class="small text-muted">
                                <li>Trial Balance (verify accuracy)</li>
                                <li>Income Statement (performance)</li>
                                <li>Cash Flow Statement (liquidity)</li>
                                <li>Fee Collection Report (revenue)</li>
                            </ul>
                        </div>
                        <div class="col-md-3">
                            <h6 class="text-success">Year-End Reporting</h6>
                            <ul class="small text-muted">
                                <li>Balance Sheet (financial position)</li>
                                <li>Income Statement (annual performance)</li>
                                <li>General Ledger (audit support)</li>
                                <li>Expenditure Report (budget analysis)</li>
                            </ul>
                        </div>
                        <div class="col-md-3">
                            <h6 class="text-info">Daily Operations</h6>
                            <ul class="small text-muted">
                                <li>Account Statements (specific inquiries)</li>
                                <li>Chart of Accounts (reference)</li>
                                <li>Cash Flow (cash management)</li>
                                <li>Student Billing (payment tracking)</li>
                            </ul>
                        </div>
                        <div class="col-md-3">
                            <h6 class="text-warning">Collections & Payables</h6>
                            <ul class="small text-muted">
                                <li>Accounts Receivable (overdue students)</li>
                                <li>Accounts Payable (vendor payments)</li>
                                <li>Fee Collection (revenue tracking)</li>
                                <li>Expenditure Report (expense control)</li>
                            </ul>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<script>
function updateAccountUrl(select) {
    const accountId = select.value;
    const btn = document.getElementById('account-statement-btn');
    const form = select.closest('form');
    
    if (accountId) {
        form.action = form.action.replace('ACCOUNT_ID', accountId);
        btn.disabled = false;
    } else {
        btn.disabled = true;
    }
}

// Load accounts for account statement dropdown
document.addEventListener('DOMContentLoaded', function() {
    // This would typically be populated from the controller
    // For now, we'll leave it as a placeholder
});
</script>
@endsection