@extends('layouts.master')

@section('page_title', 'Cash Flow Statement')

@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1>Cash Flow Statement</h1>
        <div>
            <a href="#" onclick="window.print()" class="btn btn-secondary">
                <i class="fas fa-print"></i> Print
            </a>
            <a href="{{ route('reports.cash-flow', 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.cash-flow') }}" 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">
                Cash Flow 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>
                        <!-- OPERATING ACTIVITIES -->
                        <tr>
                            <td colspan="2"><h4 class="text-primary mb-3">CASH FLOWS FROM OPERATING ACTIVITIES</h4></td>
                        </tr>
                        
                        <tr>
                            <td class="ps-4">Cash Receipts from Students (Fees, etc.)</td>
                            <td class="text-end">{{ number_format($operatingInflows ?? 0, 2) }}</td>
                        </tr>
                        
                        <tr>
                            <td class="ps-4">Cash Payments for Operating Expenses</td>
                            <td class="text-end">({{ number_format($operatingOutflows ?? 0, 2) }})</td>
                        </tr>
                        
                        <tr>
                            <td><strong>Net Cash from Operating Activities</strong></td>
                            <td class="text-end border-bottom">
                                <strong class="{{ ($netOperatingCashFlow ?? 0) >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ number_format($netOperatingCashFlow ?? 0, 2) }}
                                </strong>
                            </td>
                        </tr>
                        
                        <!-- INVESTING ACTIVITIES -->
                        <tr>
                            <td colspan="2"><h4 class="text-info mt-4 mb-3">CASH FLOWS FROM INVESTING ACTIVITIES</h4></td>
                        </tr>
                        
                        @if(isset($investingActivities) && $investingActivities->count() > 0)
                            @foreach($investingActivities as $activity)
                                <tr>
                                    <td class="ps-4">{{ $activity->name }}</td>
                                    <td class="text-end">
                                        {{ $activity->period_activity >= 0 ? '' : '(' }}{{ number_format(abs($activity->period_activity), 2) }}{{ $activity->period_activity >= 0 ? '' : ')' }}
                                    </td>
                                </tr>
                            @endforeach
                        @else
                            <tr>
                                <td class="ps-4 text-muted">No significant investing activities</td>
                                <td class="text-end">0.00</td>
                            </tr>
                        @endif
                        
                        <tr>
                            <td><strong>Net Cash from Investing Activities</strong></td>
                            <td class="text-end border-bottom">
                                <strong class="{{ ($netInvestingCashFlow ?? 0) >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ ($netInvestingCashFlow ?? 0) >= 0 ? '' : '(' }}{{ number_format(abs($netInvestingCashFlow ?? 0), 2) }}{{ ($netInvestingCashFlow ?? 0) >= 0 ? '' : ')' }}
                                </strong>
                            </td>
                        </tr>
                        
                        <!-- FINANCING ACTIVITIES -->
                        <tr>
                            <td colspan="2"><h4 class="text-warning mt-4 mb-3">CASH FLOWS FROM FINANCING ACTIVITIES</h4></td>
                        </tr>
                        
                        @if(isset($financingActivities) && $financingActivities->count() > 0)
                            @foreach($financingActivities as $activity)
                                <tr>
                                    <td class="ps-4">{{ $activity->name }}</td>
                                    <td class="text-end">{{ number_format($activity->balance ?? 0, 2) }}</td>
                                </tr>
                            @endforeach
                        @else
                            <tr>
                                <td class="ps-4 text-muted">No significant financing activities</td>
                                <td class="text-end">0.00</td>
                            </tr>
                        @endif
                        
                        <tr>
                            <td><strong>Net Cash from Financing Activities</strong></td>
                            <td class="text-end border-bottom">
                                <strong class="{{ ($netFinancingCashFlow ?? 0) >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ number_format($netFinancingCashFlow ?? 0, 2) }}
                                </strong>
                            </td>
                        </tr>
                        
                        <!-- NET CHANGE IN CASH -->
                        <tr>
                            <td colspan="2" class="pt-4"></td>
                        </tr>
                        
                        <tr>
                            <td><strong>Net Change in Cash and Cash Equivalents</strong></td>
                            <td class="text-end border-bottom">
                                <strong class="{{ ($netCashFlowChange ?? 0) >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ ($netCashFlowChange ?? 0) >= 0 ? '' : '(' }}{{ number_format(abs($netCashFlowChange ?? 0), 2) }}{{ ($netCashFlowChange ?? 0) >= 0 ? '' : ')' }}
                                </strong>
                            </td>
                        </tr>
                        
                        <tr>
                            <td>Cash and Cash Equivalents at Beginning of Period</td>
                            <td class="text-end">{{ number_format($beginningCash ?? 0, 2) }}</td>
                        </tr>
                        
                        <tr>
                            <td><h5>Cash and Cash Equivalents at End of Period</h5></td>
                            <td class="text-end">
                                <h5 class="border-top border-bottom border-3 border-dark">
                                    {{ number_format($endingCash ?? 0, 2) }}
                                </h5>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </div>
            
            <!-- Cash Accounts Breakdown -->
            @if(isset($cashAccounts) && $cashAccounts->count() > 0)
                <div class="mt-4">
                    <h6>Cash and Cash Equivalents Include:</h6>
                    <div class="table-responsive">
                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th>Account</th>
                                    <th class="text-end">Balance</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($cashAccounts as $cashAccount)
                                    <tr>
                                        <td>{{ $cashAccount->name }}</td>
                                        <td class="text-end">{{ number_format($cashAccount->balance ?? 0, 2) }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            @endif
            
            <!-- Analysis -->
            <div class="row mt-4">
                <div class="col-md-6">
                    <div class="alert {{ ($netCashFlowChange ?? 0) >= 0 ? 'alert-success' : 'alert-warning' }}">
                        @if(($netCashFlowChange ?? 0) >= 0)
                            <i class="fas fa-arrow-up"></i> <strong>Positive Cash Flow!</strong>
                            <br>The school generated more cash than it used.
                        @else
                            <i class="fas fa-arrow-down"></i> <strong>Negative Cash Flow!</strong>
                            <br>The school used more cash than it generated.
                        @endif
                    </div>
                </div>
                <div class="col-md-6">
                    <div class="alert alert-info">
                        <strong>Liquidity Analysis:</strong><br>
                        Operating Cash Flow: {{ number_format($netOperatingCashFlow ?? 0, 2) }}<br>
                        Ending Cash Position: {{ number_format($endingCash ?? 0, 2) }}<br>
                        @php
                            $monthsOfExpenses = ($operatingOutflows ?? 0) > 0 ? ($endingCash ?? 0) / (($operatingOutflows ?? 0) / 12) : 0;
                        @endphp
                        Cash Runway: {{ number_format($monthsOfExpenses, 1) }} months
                    </div>
                </div>
            </div>
            
            <!-- Key Insights -->
            <div class="mt-3">
                <div class="alert alert-light">
                    <h6><i class="fas fa-lightbulb"></i> Key Insights:</h6>
                    <ul class="mb-0">
                        <li><strong>Operating Activities:</strong> 
                            @if(($netOperatingCashFlow ?? 0) >= 0)
                                School's day-to-day operations are generating positive cash flow.
                            @else
                                School's operations are consuming cash - review revenue collection and expense management.
                            @endif
                        </li>
                        <li><strong>Cash Position:</strong> 
                            @if(($endingCash ?? 0) >= ($operatingOutflows ?? 0) / 12)
                                School has sufficient cash reserves for operations.
                            @else
                                Consider improving cash collection or reducing expenses to improve liquidity.
                            @endif
                        </li>
                    </ul>
                </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