@extends('layouts.master')

@section('page_title', 'Income Statement (Profit & Loss)')

@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1>Income Statement</h1>
        <div>
            <a href="#" onclick="window.print()" class="btn btn-secondary">
                <i class="fas fa-print"></i> Print
            </a>
            <a href="{{ route('reports.profit-loss', 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.profit-loss') }}" class="row g-3">
                <div class="col-md-3">
                    <label for="start_date" class="form-label">Start Date</label>
                    <input type="date" class="form-control" id="start_date" name="start_date" 
                           value="{{ request('start_date', date('Y-01-01')) }}">
                </div>
                <div class="col-md-3">
                    <label for="end_date" class="form-label">End Date</label>
                    <input type="date" class="form-control" id="end_date" name="end_date" 
                           value="{{ request('end_date', date('Y-m-d')) }}">
                </div>
                <div class="col-md-3 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">
                Income Statement<br>
                <small class="text-muted">
                    For the period from {{ \Carbon\Carbon::parse($startDate ?? date('Y-01-01'))->format('F j, Y') }} 
                    to {{ \Carbon\Carbon::parse($endDate ?? date('Y-m-d'))->format('F j, Y') }}
                </small>
            </h5>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table">
                    <tbody>
                        <!-- REVENUE SECTION -->
                        <tr>
                            <td colspan="2"><h4 class="text-success mb-3">REVENUE</h4></td>
                        </tr>
                        
                        @php
                            $totalRevenue = 0;
                            $revenueCategories = [
                                'Student Fees' => [],
                                'Grants & Donations' => [],
                                'Other Revenue' => []
                            ];
                            
                            // Group revenue accounts
                            foreach ($revenue ?? [] as $revenueAccount) {
                                if (stripos($revenueAccount->name, 'fee') !== false || stripos($revenueAccount->name, 'tuition') !== false) {
                                    $revenueCategories['Student Fees'][] = $revenueAccount;
                                } elseif (stripos($revenueAccount->name, 'grant') !== false || stripos($revenueAccount->name, 'donation') !== false) {
                                    $revenueCategories['Grants & Donations'][] = $revenueAccount;
                                } else {
                                    $revenueCategories['Other Revenue'][] = $revenueAccount;
                                }
                                $totalRevenue += $revenueAccount->balance ?? 0;
                            }
                        @endphp
                        
                        @foreach($revenueCategories as $categoryName => $categoryRevenue)
                            @if(count($categoryRevenue) > 0)
                                <tr>
                                    <td colspan="2"><h6 class="text-muted mt-2">{{ $categoryName }}</h6></td>
                                </tr>
                                @php $categoryTotal = 0; @endphp
                                @foreach($categoryRevenue as $revenue)
                                    @php $categoryTotal += $revenue->balance ?? 0; @endphp
                                    <tr>
                                        <td class="ps-4">{{ $revenue->name }}</td>
                                        <td class="text-end">{{ number_format($revenue->balance ?? 0, 2) }}</td>
                                    </tr>
                                @endforeach
                                <tr>
                                    <td class="ps-4"><strong>Total {{ $categoryName }}</strong></td>
                                    <td class="text-end border-bottom"><strong>{{ number_format($categoryTotal, 2) }}</strong></td>
                                </tr>
                            @endif
                        @endforeach
                        
                        <tr>
                            <td><h5 class="text-success">TOTAL REVENUE</h5></td>
                            <td class="text-end"><h5 class="text-success border-top border-bottom border-2">{{ number_format($totalRevenue, 2) }}</h5></td>
                        </tr>
                        
                        <!-- EXPENSES SECTION -->
                        <tr>
                            <td colspan="2"><h4 class="text-danger mt-4 mb-3">EXPENSES</h4></td>
                        </tr>
                        
                        @php
                            $totalExpenses = 0;
                            $expenseCategories = [
                                'Personnel Expenses' => [],
                                'Administrative Expenses' => [],
                                'Facilities & Utilities' => [],
                                'Educational Expenses' => [],
                                'Other Expenses' => []
                            ];
                            
                            // Group expense accounts
                            foreach ($expenses ?? [] as $expenseAccount) {
                                if (stripos($expenseAccount->name, 'salary') !== false || stripos($expenseAccount->name, 'wage') !== false || stripos($expenseAccount->name, 'payroll') !== false) {
                                    $expenseCategories['Personnel Expenses'][] = $expenseAccount;
                                } elseif (stripos($expenseAccount->name, 'admin') !== false || stripos($expenseAccount->name, 'office') !== false) {
                                    $expenseCategories['Administrative Expenses'][] = $expenseAccount;
                                } elseif (stripos($expenseAccount->name, 'utilities') !== false || stripos($expenseAccount->name, 'maintenance') !== false || stripos($expenseAccount->name, 'rent') !== false) {
                                    $expenseCategories['Facilities & Utilities'][] = $expenseAccount;
                                } elseif (stripos($expenseAccount->name, 'supplies') !== false || stripos($expenseAccount->name, 'book') !== false || stripos($expenseAccount->name, 'educational') !== false) {
                                    $expenseCategories['Educational Expenses'][] = $expenseAccount;
                                } else {
                                    $expenseCategories['Other Expenses'][] = $expenseAccount;
                                }
                                $totalExpenses += $expenseAccount->balance ?? 0;
                            }
                        @endphp
                        
                        @foreach($expenseCategories as $categoryName => $categoryExpenses)
                            @if(count($categoryExpenses) > 0)
                                <tr>
                                    <td colspan="2"><h6 class="text-muted mt-2">{{ $categoryName }}</h6></td>
                                </tr>
                                @php $categoryTotal = 0; @endphp
                                @foreach($categoryExpenses as $expense)
                                    @php $categoryTotal += $expense->balance ?? 0; @endphp
                                    <tr>
                                        <td class="ps-4">{{ $expense->name }}</td>
                                        <td class="text-end">{{ number_format($expense->balance ?? 0, 2) }}</td>
                                    </tr>
                                @endforeach
                                <tr>
                                    <td class="ps-4"><strong>Total {{ $categoryName }}</strong></td>
                                    <td class="text-end border-bottom"><strong>{{ number_format($categoryTotal, 2) }}</strong></td>
                                </tr>
                            @endif
                        @endforeach
                        
                        <tr>
                            <td><h5 class="text-danger">TOTAL EXPENSES</h5></td>
                            <td class="text-end"><h5 class="text-danger border-top border-bottom border-2">{{ number_format($totalExpenses, 2) }}</h5></td>
                        </tr>
                        
                        <!-- NET INCOME SECTION -->
                        @php
                            $netIncome = $totalRevenue - $totalExpenses;
                            $netIncomeClass = $netIncome >= 0 ? 'text-success' : 'text-danger';
                            $netIncomeLabel = $netIncome >= 0 ? 'NET INCOME (SURPLUS)' : 'NET LOSS (DEFICIT)';
                        @endphp
                        
                        <tr>
                            <td><h4 class="{{ $netIncomeClass }} mt-3">{{ $netIncomeLabel }}</h4></td>
                            <td class="text-end">
                                <h4 class="{{ $netIncomeClass }} border-top border-bottom border-3 border-dark">
                                    {{ number_format($netIncome, 2) }}
                                </h4>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </div>
            
            <!-- Summary and Analysis -->
            <div class="row mt-4">
                <div class="col-md-6">
                    <div class="alert {{ $netIncome >= 0 ? 'alert-success' : 'alert-warning' }}">
                        @if($netIncome >= 0)
                            <i class="fas fa-chart-line"></i> <strong>School is operating at a surplus!</strong>
                            <br>The school's revenue exceeds its expenses.
                        @else
                            <i class="fas fa-exclamation-triangle"></i> <strong>School is operating at a deficit!</strong>
                            <br>The school's expenses exceed its revenue.
                        @endif
                    </div>
                </div>
                <div class="col-md-6">
                    <div class="alert alert-info">
                        <strong>Financial Summary:</strong><br>
                        Total Revenue: {{ number_format($totalRevenue, 2) }}<br>
                        Total Expenses: {{ number_format($totalExpenses, 2) }}<br>
                        Net Margin: {{ $totalRevenue > 0 ? number_format(($netIncome / $totalRevenue) * 100, 1) : '0' }}%
                    </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