@extends('layouts.master')

@section('page_title', 'Balance Sheet Report')

@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1>Balance Sheet</h1>
        <div>
            <a href="#" onclick="window.print()" class="btn btn-secondary">
                <i class="fas fa-print"></i> Print
            </a>
            <a href="{{ route('reports.balance-sheet', array_merge(request()->all(), ['format' => 'pdf'])) }}" class="btn btn-danger">
                <i class="fas fa-file-pdf"></i> PDF
            </a>
        </div>
    </div>

    <!-- Date Filter Form -->
    <div class="card mb-4 no-print">
        <div class="card-body">
            <form method="GET" action="{{ route('reports.balance-sheet') }}" class="row g-3">
                <div class="col-md-4">
                    <label for="as_of_date" class="form-label">As of Date</label>
                    <input type="date" class="form-control" id="as_of_date" name="as_of_date" 
                           value="{{ request('as_of_date', date('Y-m-d')) }}">
                </div>
                <div class="col-md-4 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary">Generate Report</button>
                </div>
            </form>
        </div>
    </div>

    <!-- Report Content -->
    <div class="card">
        <div class="card-header">
            <h5 class="mb-0 text-center">Balance Sheet as of {{ \Carbon\Carbon::parse($asOfDate ?? date('Y-m-d'))->format('F j, Y') }}</h5>
        </div>
        <div class="card-body">
            <div class="row">
                <!-- Assets Column -->
                <div class="col-md-6">
                    <h4 class="text-primary border-bottom pb-2">ASSETS</h4>
                    
                    @php
                        $totalAssets = 0;
                        $assetCategories = [
                            'Current Assets' => [],
                            'Fixed Assets' => [],
                            'Other Assets' => []
                        ];
                        
                        // Group assets by category (this would be better done in the controller)
                        foreach ($assets ?? [] as $asset) {
                            if (stripos($asset->name, 'cash') !== false || stripos($asset->name, 'bank') !== false || stripos($asset->name, 'receivable') !== false || stripos($asset->name, 'inventory') !== false) {
                                $assetCategories['Current Assets'][] = $asset;
                            } elseif (stripos($asset->name, 'building') !== false || stripos($asset->name, 'equipment') !== false || stripos($asset->name, 'furniture') !== false || stripos($asset->name, 'fixed') !== false) {
                                $assetCategories['Fixed Assets'][] = $asset;
                            } else {
                                $assetCategories['Other Assets'][] = $asset;
                            }
                            $totalAssets += $asset->balance ?? 0;
                        }
                    @endphp
                    
                    @foreach($assetCategories as $categoryName => $categoryAssets)
                        @if(count($categoryAssets) > 0)
                            <h6 class="text-secondary mt-3">{{ $categoryName }}</h6>
                            @php $categoryTotal = 0; @endphp
                            @foreach($categoryAssets as $asset)
                                @php $categoryTotal += $asset->balance ?? 0; @endphp
                                <div class="d-flex justify-content-between">
                                    <span class="ms-3">{{ $asset->name }}</span>
                                    <span>{{ number_format($asset->balance ?? 0, 2) }}</span>
                                </div>
                            @endforeach
                            <div class="d-flex justify-content-between border-bottom mb-2">
                                <strong>Total {{ $categoryName }}</strong>
                                <strong>{{ number_format($categoryTotal, 2) }}</strong>
                            </div>
                        @endif
                    @endforeach
                    
                    <div class="d-flex justify-content-between border-top pt-2 mt-3">
                        <h5 class="text-primary">TOTAL ASSETS</h5>
                        <h5 class="text-primary">{{ number_format($totalAssets, 2) }}</h5>
                    </div>
                </div>

                <!-- Liabilities and Equity Column -->
                <div class="col-md-6">
                    <h4 class="text-danger border-bottom pb-2">LIABILITIES & EQUITY</h4>
                    
                    <!-- Liabilities Section -->
                    <h6 class="text-secondary mt-3">LIABILITIES</h6>
                    @php
                        $totalLiabilities = 0;
                        $liabilityCategories = [
                            'Current Liabilities' => [],
                            'Long-term Liabilities' => []
                        ];
                        
                        // Group liabilities by category
                        foreach ($liabilities ?? [] as $liability) {
                            if (stripos($liability->name, 'payable') !== false || stripos($liability->name, 'accrued') !== false || stripos($liability->name, 'current') !== false) {
                                $liabilityCategories['Current Liabilities'][] = $liability;
                            } else {
                                $liabilityCategories['Long-term Liabilities'][] = $liability;
                            }
                            $totalLiabilities += $liability->balance ?? 0;
                        }
                    @endphp
                    
                    @foreach($liabilityCategories as $categoryName => $categoryLiabilities)
                        @if(count($categoryLiabilities) > 0)
                            <div class="text-muted small">{{ $categoryName }}</div>
                            @php $categoryTotal = 0; @endphp
                            @foreach($categoryLiabilities as $liability)
                                @php $categoryTotal += $liability->balance ?? 0; @endphp
                                <div class="d-flex justify-content-between">
                                    <span class="ms-3">{{ $liability->name }}</span>
                                    <span>{{ number_format($liability->balance ?? 0, 2) }}</span>
                                </div>
                            @endforeach
                            <div class="d-flex justify-content-between border-bottom mb-2">
                                <strong>Total {{ $categoryName }}</strong>
                                <strong>{{ number_format($categoryTotal, 2) }}</strong>
                            </div>
                        @endif
                    @endforeach
                    
                    <div class="d-flex justify-content-between mt-2">
                        <strong>Total Liabilities</strong>
                        <strong>{{ number_format($totalLiabilities, 2) }}</strong>
                    </div>
                    
                    <!-- Equity Section -->
                    <h6 class="text-secondary mt-4">EQUITY</h6>
                    @php $totalEquity = 0; @endphp
                    @foreach($equity ?? [] as $equityAccount)
                        @php $totalEquity += $equityAccount->balance ?? 0; @endphp
                        <div class="d-flex justify-content-between">
                            <span class="ms-3">{{ $equityAccount->name }}</span>
                            <span>{{ number_format($equityAccount->balance ?? 0, 2) }}</span>
                        </div>
                    @endforeach
                    
                    <!-- Net Income (calculated from Revenue - Expenses) -->
                    @php
                        $netIncome = ($totalRevenue ?? 0) - ($totalExpenses ?? 0);
                        $totalEquity += $netIncome;
                    @endphp
                    <div class="d-flex justify-content-between">
                        <span class="ms-3">Net Income</span>
                        <span class="{{ $netIncome >= 0 ? 'text-success' : 'text-danger' }}">
                            {{ number_format($netIncome, 2) }}
                        </span>
                    </div>
                    
                    <div class="d-flex justify-content-between border-bottom mb-2">
                        <strong>Total Equity</strong>
                        <strong>{{ number_format($totalEquity, 2) }}</strong>
                    </div>
                    
                    <div class="d-flex justify-content-between border-top pt-2 mt-3">
                        <h5 class="text-danger">TOTAL LIABILITIES & EQUITY</h5>
                        <h5 class="text-danger">{{ number_format($totalLiabilities + $totalEquity, 2) }}</h5>
                    </div>
                </div>
            </div>
            
            <!-- Balance Check -->
            <div class="row mt-4">
                <div class="col-12">
                    @php
                        $difference = $totalAssets - ($totalLiabilities + $totalEquity);
                        $isBalanced = abs($difference) < 0.01;
                    @endphp
                    
                    <div class="alert {{ $isBalanced ? 'alert-success' : 'alert-warning' }}">
                        @if($isBalanced)
                            <i class="fas fa-check-circle"></i> <strong>Balance Sheet is balanced!</strong>
                            <br>Assets = Liabilities + Equity
                        @else
                            <i class="fas fa-exclamation-triangle"></i> <strong>Balance Sheet is out of balance!</strong>
                            <br>Difference: {{ number_format(abs($difference), 2) }}
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<style>
@media print {
    .btn, .no-print {
        display: none !important;
    }
    
    .card {
        border: none !important;
        box-shadow: none !important;
    }
    
    .card-header {
        background: none !important;
        border: none !important;
    }
    
    body {
        -webkit-print-color-adjust: exact;
    }
}
</style>
@endsection