{% extends 'base.html' %}
{% load static %}
{% block title %}Consolidated Financial Reports – Haven Grazuri{% endblock %}

{% block extra_css %}
<style>
.report-card{background:#fff;border-radius:14px;padding:1.6rem;box-shadow:0 2px 8px rgba(0,0,0,.1);border:1px solid #e5e7eb;transition:all .2s;height:100%;}
.report-card:hover{transform:translateY(-3px);box-shadow:0 6px 18px rgba(0,0,0,.13);}
.report-card .icon{font-size:2.5rem;margin-bottom:.8rem;display:block;}
.report-card h5{font-weight:700;color:#1f2937;margin-bottom:.5rem;}
.report-card p{color:#6b7280;font-size:.88rem;margin-bottom:1rem;}
.page-hero{background:linear-gradient(135deg,#00308a,#1e40af);color:#fff;border-radius:16px;padding:2rem;margin-bottom:2rem;}
.feature-tag{display:inline-block;background:rgba(255,255,255,.15);border:1px solid rgba(255,255,255,.25);color:#fff;padding:3px 10px;border-radius:20px;font-size:.75rem;font-weight:600;margin-right:4px;margin-bottom:4px;}
.report-feature{font-size:.8rem;color:#6b7280;margin-bottom:4px;display:flex;align-items:center;gap:6px;}
.report-feature::before{content:'✓';color:#10b981;font-weight:700;}
.btn-open{padding:11px 18px;border-radius:8px;font-weight:700;transition:all .2s;font-size:.9rem;}
.btn-open:hover{transform:translateY(-2px);}
.quick-links-bar{background:#f8fafc;border:1px solid #e5e7eb;border-radius:10px;padding:16px 20px;margin-bottom:24px;display:flex;gap:10px;flex-wrap:wrap;align-items:center;}
.quick-pdf-btn{padding:8px 16px;border-radius:8px;font-weight:700;text-decoration:none;display:inline-flex;align-items:center;gap:6px;transition:all .2s;font-size:.82rem;white-space:nowrap;}
.quick-pdf-btn:hover{transform:translateY(-2px);box-shadow:0 3px 10px rgba(0,0,0,.2);}
</style>
{% endblock %}

{% block content %}
<div class="container-fluid px-4 py-4">

  <div class="page-hero">
    <div class="d-flex align-items-center gap-3 mb-2">
      <span style="font-size:3rem;">📊</span>
      <div>
        <h1 class="h3 fw-bold mb-1">Consolidated Financial Reports</h1>
        <p class="opacity-80 mb-0">Haven Grazuri Investment Limited — Management Accounting Suite</p>
      </div>
    </div>
    <div class="mt-3">
      <span class="feature-tag">Double-Entry Accounting</span>
      <span class="feature-tag">Date-Range Filtering</span>
      <span class="feature-tag">PDF Export</span>
      <span class="feature-tag">Excel/CSV Export</span>
      <span class="feature-tag">IFRS Standards</span>
      <span class="feature-tag">Microfinance KPIs</span>
    </div>
  </div>

  <!-- Quick PDF Download Bar -->
  <div class="quick-links-bar">
    <span style="font-weight:700;color:#374151;font-size:.88rem;white-space:nowrap;">📄 Quick PDF Downloads:</span>
    <a href="{% url 'reports:chart_of_accounts_pdf' %}" class="quick-pdf-btn" style="background:#dc2626;color:#fff;" target="_blank">
      📕 Chart of Accounts
    </a>
    <a href="{% url 'reports:trial_balance_pdf' %}" class="quick-pdf-btn" style="background:#059669;color:#fff;" target="_blank">
      ⚖️ Trial Balance
    </a>
    <a href="{% url 'reports:income_statement_pdf' %}" class="quick-pdf-btn" style="background:#7c3aed;color:#fff;" target="_blank">
      💰 Income Statement
    </a>
    <a href="{% url 'reports:balance_sheet_pdf' %}" class="quick-pdf-btn" style="background:#0284c7;color:#fff;" target="_blank">
      🏦 Balance Sheet
    </a>
  </div>

  <!-- Main Report Cards -->
  <div class="row g-4">

    <!-- 1. Chart of Accounts -->
    <div class="col-md-6 col-xl-4">
      <div class="report-card text-center">
        <span class="icon">📊</span>
        <h5>Chart of Accounts</h5>
        <p>Complete general ledger account listing with live balances. Browse all assets, liabilities, equity, income and expense accounts with descriptions and subtype groupings.</p>
        <div class="text-start mb-3">
          <div class="report-feature">Live balances as of any date</div>
          <div class="report-feature">Type & status filtering</div>
          <div class="report-feature">Search by code, name, or description</div>
          <div class="report-feature">Per-account ledger drill-down</div>
          <div class="report-feature">4 PDF report types available</div>
        </div>
        <a href="{% url 'reports:chart_of_accounts' %}" class="btn btn-open btn-primary w-100">
          Open Chart of Accounts →
        </a>
      </div>
    </div>

    <!-- 2. Trial Balance -->
    <div class="col-md-6 col-xl-4">
      <div class="report-card text-center">
        <span class="icon">⚖️</span>
        <h5>Trial Balance</h5>
        <p>Lists all account debit and credit balances as of a selected date. Confirms your books are mathematically accurate — total debits must equal total credits.</p>
        <div class="text-start mb-3">
          <div class="report-feature">Select any date for balance</div>
          <div class="report-feature">Automatic balance check (balanced/unbalanced)</div>
          <div class="report-feature">Shows debit vs credit by account</div>
          <div class="report-feature">PDF & Excel/CSV export</div>
          <div class="report-feature">Prerequisite for financial statements</div>
        </div>
        <a href="{% url 'reports:trial_balance' %}" class="btn btn-open w-100" style="background:#059669;color:#fff;border:none;">
          Open Trial Balance →
        </a>
      </div>
    </div>

    <!-- 3. Income Statement -->
    <div class="col-md-6 col-xl-4">
      <div class="report-card text-center">
        <span class="icon">💰</span>
        <h5>Income Statement (Profit & Loss)</h5>
        <p>Shows all revenue earned and expenses incurred in a period. Tells you whether the business made a profit or loss, and exactly where each came from.</p>
        <div class="text-start mb-3">
          <div class="report-feature">Custom date range (start → end)</div>
          <div class="report-feature">Revenue by account category</div>
          <div class="report-feature">Expenses by category (staff, ops, tech...)</div>
          <div class="report-feature">Profit margin & expense ratio KPIs</div>
          <div class="report-feature">PDF & Excel/CSV export</div>
        </div>
        <a href="{% url 'reports:income_statement' %}" class="btn btn-open w-100" style="background:#7c3aed;color:#fff;border:none;">
          Open Income Statement →
        </a>
      </div>
    </div>

    <!-- 4. Balance Sheet -->
    <div class="col-md-6 col-xl-4">
      <div class="report-card text-center">
        <span class="icon">🏦</span>
        <h5>Balance Sheet</h5>
        <p>A snapshot of everything owned (assets), owed (liabilities), and net worth (equity) at a specific date. The fundamental financial health check.</p>
        <div class="text-start mb-3">
          <div class="report-feature">Select any historical date</div>
          <div class="report-feature">Assets by subtype (current, fixed, loan portfolio)</div>
          <div class="report-feature">Full liability breakdown (statutory, tax, borrowings)</div>
          <div class="report-feature">Equity ratio & debt-to-equity ratio</div>
          <div class="report-feature">Accounting equation verification (A = L + E)</div>
        </div>
        <a href="{% url 'reports:balance_sheet' %}" class="btn btn-open w-100" style="background:#0284c7;color:#fff;border:none;">
          Open Balance Sheet →
        </a>
      </div>
    </div>

    <!-- 5. Cash Flow Statement -->
    <div class="col-md-6 col-xl-4">
      <div class="report-card text-center">
        <span class="icon">💧</span>
        <h5>Cash Flow Statement</h5>
        <p>Tracks actual cash movement into and out of the business. Splits cash flows into operating, investing, and financing activities to show liquidity position.</p>
        <div class="text-start mb-3">
          <div class="report-feature">Operating, investing & financing sections</div>
          <div class="report-feature">Custom date range filtering</div>
          <div class="report-feature">Cash opening & closing balance reconciliation</div>
          <div class="report-feature">Non-cash adjustments (depreciation add-back)</div>
          <div class="report-feature">PDF & Excel/CSV export</div>
        </div>
        <a href="{% url 'reports:cash_flow_statement' %}" class="btn btn-open w-100" style="background:#0f766e;color:#fff;border:none;">
          Open Cash Flow →
        </a>
      </div>
    </div>

    <!-- 6. Loan Aging Report -->
    <div class="col-md-6 col-xl-4">
      <div class="report-card text-center">
        <span class="icon">⏳</span>
        <h5>Loan Aging Report</h5>
        <p>All active loans bucketed by days overdue. Critical for monitoring portfolio quality, provisioning for loan losses, and identifying high-risk borrowers.</p>
        <div class="text-start mb-3">
          <div class="report-feature">7 aging buckets (Current to 365+ days)</div>
          <div class="report-feature">PAR (Portfolio at Risk) ratio</div>
          <div class="report-feature">Branch & product filtering</div>
          <div class="report-feature">Borrower contact details</div>
          <div class="report-feature">CSV export per bucket</div>
        </div>
        <a href="{% url 'reports:loan_aging' %}" class="btn btn-open w-100" style="background:#d97706;color:#fff;border:none;">
          Open Loan Aging →
        </a>
      </div>
    </div>

  </div>

  <!-- Additional Reports Row -->
  <div class="row g-4 mt-2">

    <div class="col-md-6 col-xl-3">
      <div class="report-card text-center" style="border-color:#0ea5e9;">
        <span class="icon" style="font-size:2rem;">🔄</span>
        <h5>SasaPay Reconciliation</h5>
        <p>Money in (C2B), money out (B2C disbursements), IPN log status, unmatched payments and net control account position.</p>
        <a href="{% url 'reports:sasapay_reconciliation' %}" class="btn btn-open btn-outline-primary w-100">Open Report →</a>
      </div>
    </div>

    <div class="col-md-6 col-xl-3">
      <div class="report-card text-center" style="border-color:#10b981;">
        <span class="icon" style="font-size:2rem;">📈</span>
        <h5>Profit & Loss (Detailed)</h5>
        <p>Detailed P&L with branch filtering, loan portfolio breakdown, and direct calculation from loan records.</p>
        <a href="{% url 'reports:profit_and_loss' %}" class="btn btn-open btn-outline-success w-100">Open Report →</a>
      </div>
    </div>

    <div class="col-md-6 col-xl-3">
      <div class="report-card text-center" style="border-color:#8b5cf6;">
        <span class="icon" style="font-size:2rem;">🏛</span>
        <h5>Financial Statements</h5>
        <p>Simplified balance sheet view: gross portfolio, NPL, cumulative income, expenses and net equity overview.</p>
        <a href="{% url 'reports:financial_statements' %}" class="btn btn-open btn-outline-secondary w-100">Open Report →</a>
      </div>
    </div>

    <div class="col-md-6 col-xl-3">
      <div class="report-card text-center" style="border-color:#f59e0b;">
        <span class="icon" style="font-size:2rem;">📊</span>
        <h5>Reports Dashboard</h5>
        <p>Main reports hub with loan performance, collections, delinquency, disbursements and demographic analytics.</p>
        <a href="{% url 'reports:reports_dashboard' %}" class="btn btn-open btn-outline-warning w-100">Open Dashboard →</a>
      </div>
    </div>

  </div>

  <!-- Accounting Standards Note -->
  <div class="alert alert-info mt-4" style="background:#e0f2fe;border:1px solid #0284c7;border-radius:10px;">
    <div class="row align-items-center">
      <div class="col-md-1 text-center" style="font-size:2.5rem;">📚</div>
      <div class="col-md-11">
        <h6 class="fw-bold" style="color:#0369a1;">Accounting Standards & Compliance</h6>
        <p class="small mb-1" style="color:#0c4a6e;">
          These reports follow <strong>double-entry bookkeeping</strong> principles and are structured in accordance with 
          <strong>IFRS for SMEs</strong> and <strong>CGAP Microfinance Reporting Standards</strong>. All entries follow the 
          fundamental accounting equation: <strong>Assets = Liabilities + Equity</strong>.
        </p>
        <p class="small mb-0" style="color:#0c4a6e;">
          <strong>Key accounts covered:</strong> Loan portfolio, allowance for credit losses, interest receivable, 
          PAYE/NHIF/NSSF payables, bank charges, M-Pesa transaction fees, depreciation, and all operational overhead categories.
        </p>
      </div>
    </div>
  </div>

</div>
{% endblock %}