@extends('layouts.master')
@section('title', 'Balance Sheet')

@section('content')
<div class="container-fluid py-3">
    <div class="d-flex justify-content-between align-items-center mb-3 no-print">
        <h4 class="mb-0">Balance Sheet</h4>
        <div class="d-flex gap-2">
            <button onclick="window.print()" class="btn btn-secondary btn-sm"><i class="fas fa-print me-1"></i> Print</button>
            <a href="?export=pdf&from_date={{ $from ?? '' }}&to_date={{ $to }}" class="btn btn-danger btn-sm"><i class="fas fa-file-pdf me-1"></i> Download PDF</a>
            <a href="?export=excel&from_date={{ $from ?? '' }}&to_date={{ $to }}" class="btn btn-success btn-sm"><i class="fas fa-file-excel me-1"></i> Download Excel</a>
        </div>
    </div>

    <form method="GET" class="row g-2 mb-3 no-print">
        <!-- Balance sheet is generally cumulative up to a date, so from_date is less relevant, but kept for UI structure if needed -->
        <div class="col-md-3">
            <label class="form-label mb-1">To Date</label>
            <input type="date" class="form-control" name="to_date" value="{{ $to }}">
        </div>
        <div class="col-md-3 d-flex align-items-end">
            <button class="btn btn-primary">Run</button>
        </div>
    </form>

    <div class="card shadow-sm">
        <div class="card-body p-0">
            <div style="background:#4e73df;color:#fff;padding:12px 16px;font-weight:700;">
                {{ $companyName ?? 'Company Name' }} <span style="float:right;">Balance Sheet</span>
            </div>
            <div class="p-3">
                <table class="table table-bordered table-sm mb-0">
                    <thead style="background-color: #4e73df; color: #fff;">
                        <tr>
                            <th>Assets</th>
                            <th class="text-end">Amount</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr class="table-light"><td colspan="2"><strong>Current Assets</strong></td></tr>
                        @if(count($grouped['Current Assets']) > 0)
                            @foreach($grouped['Current Assets'] as $r)
                                <tr><td style="padding-left: 30px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @endif
                        <tr><td style="padding-left: 20px;"><em>Total current assets</em></td><td class="text-end border-top border-dark border-bottom"><strong>{{ number_format($currentAssets, 2) }}</strong></td></tr>

                        <tr class="table-light"><td colspan="2"><strong>Fixed (Long-Term) Assets</strong></td></tr>
                        @if(count($grouped['Fixed Assets']) > 0)
                            @foreach($grouped['Fixed Assets'] as $r)
                                <tr><td style="padding-left: 30px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @endif
                        <tr><td style="padding-left: 20px;"><em>Total fixed assets</em></td><td class="text-end border-top border-dark border-bottom"><strong>{{ number_format($fixedAssets, 2) }}</strong></td></tr>

                        <tr class="table-light"><td colspan="2"><strong>Other Assets</strong></td></tr>
                        @if(count($grouped['Other Assets']) > 0)
                            @foreach($grouped['Other Assets'] as $r)
                                <tr><td style="padding-left: 30px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @endif
                        <tr><td style="padding-left: 20px;"><em>Total Other Assets</em></td><td class="text-end border-top border-dark border-bottom"><strong>{{ number_format($otherAssets, 2) }}</strong></td></tr>

                        <tr class="table-secondary"><td><strong>Total Assets</strong></td><td class="text-end" style="border-bottom: 3px double #000;"><strong>{{ number_format($totalAssets, 2) }}</strong></td></tr>

                        <tr class="table-primary"><td colspan="2"><strong>Liabilities and Owner's Equity</strong></td></tr>
                        
                        <tr class="table-light"><td colspan="2"><strong>Current Liabilities</strong></td></tr>
                        @if(count($grouped['Current Liabilities']) > 0)
                            @foreach($grouped['Current Liabilities'] as $r)
                                <tr><td style="padding-left: 30px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @endif
                        <tr><td style="padding-left: 20px;"><em>Total current liabilities</em></td><td class="text-end border-top border-dark border-bottom"><strong>{{ number_format($currentLiabilities, 2) }}</strong></td></tr>

                        <tr class="table-light"><td colspan="2"><strong>Long-Term Liabilities</strong></td></tr>
                        @if(count($grouped['Long-Term Liabilities']) > 0)
                            @foreach($grouped['Long-Term Liabilities'] as $r)
                                <tr><td style="padding-left: 30px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @endif
                        <tr><td style="padding-left: 20px;"><em>Total long-term liabilities</em></td><td class="text-end border-top border-dark border-bottom"><strong>{{ number_format($longTermLiabilities, 2) }}</strong></td></tr>

                        <tr class="table-light"><td colspan="2"><strong>Owner's Equity</strong></td></tr>
                        @if(count($grouped['Owner\'s Equity']) > 0)
                            @foreach($grouped['Owner\'s Equity'] as $r)
                                <tr><td style="padding-left: 30px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @endif
                        <tr><td style="padding-left: 20px;"><em>Total owner's equity</em></td><td class="text-end border-top border-dark border-bottom"><strong>{{ number_format($totalEquity, 2) }}</strong></td></tr>

                        <tr class="table-secondary"><td><strong>Total Liabilities and Owner's Equity</strong></td><td class="text-end" style="border-bottom: 3px double #000;"><strong>{{ number_format($totalLE, 2) }}</strong></td></tr>

                        @if(abs($totalAssets - $totalLE) > 0.01)
                            <tr class="table-warning"><td colspan="2"><strong>Warning:</strong> Balance Sheet does not balance (Difference: {{ number_format(abs($totalAssets - $totalLE), 2) }}).</td></tr>
                        @endif

                        <tr class="table-primary"><td colspan="2"><strong>Common Financial Ratios</strong></td></tr>
                        <tr><td>Debt Ratio (Total Liabilities / Total Assets)</td><td class="text-end">{{ number_format($debtRatio, 2) }}</td></tr>
                        <tr><td>Current Ratio (Current Assets / Current Liabilities)</td><td class="text-end">{{ number_format($currentRatio, 2) }}</td></tr>
                        <tr><td>Working Capital (Current Assets - Current Liabilities)</td><td class="text-end">{{ number_format($workingCapital, 2) }}</td></tr>
                        <tr><td>Assets-to-Equity Ratio (Total Assets / Owner's Equity)</td><td class="text-end">{{ number_format($assetsToEquity, 2) }}</td></tr>
                        <tr><td>Debt-to-Equity Ratio (Total Liabilities / Owner's Equity)</td><td class="text-end">{{ number_format($debtToEquity, 2) }}</td></tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<style>
@media print {
    .no-print { display:none !important; }
    body { background:#fff !important; }
    .card { border:none !important; box-shadow:none !important; }
}
</style>
@endsection