@extends('layouts.bootstrap')

@section('title', 'Cash Flow Report')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center mb-4">
                <h1 class="h3 mb-0">
                    <i class="bi bi-graph-up-arrow me-2"></i>Cash Flow Report
                </h1>
                <div class="btn-group" role="group">
                    <a href="{{ route('financial.dashboard') }}" class="btn btn-outline-secondary">
                        <i class="bi bi-arrow-left me-1"></i>Back to Dashboard
                    </a>
                    <button type="button" class="btn btn-primary" onclick="window.print()">
                        <i class="bi bi-printer me-1"></i>Print Report
                    </button>
                </div>
            </div>
        </div>
    </div>

    <!-- Period Selection -->
    <div class="card mb-4">
        <div class="card-body">
            <form method="GET" action="{{ route('financial.cash-flow') }}" class="row g-3">
                <div class="col-md-3">
                    <label for="period" class="form-label">Period</label>
                    <select class="form-select" id="period" name="period" onchange="this.form.submit()">
                        <option value="last_12_months" {{ $period == 'last_12_months' ? 'selected' : '' }}>Last 12 Months</option>
                        <option value="current_year" {{ $period == 'current_year' ? 'selected' : '' }}>Current Year</option>
                        <option value="last_year" {{ $period == 'last_year' ? 'selected' : '' }}>Last Year</option>
                        <option value="last_6_months" {{ $period == 'last_6_months' ? 'selected' : '' }}>Last 6 Months</option>
                    </select>
                </div>
            </form>
        </div>
    </div>

    <!-- Report Header -->
    <div class="card mb-4">
        <div class="card-body text-center">
            <h2 class="mb-1">Product Price Management</h2>
            <h4 class="text-muted mb-3">Cash Flow Statement</h4>
            <p class="mb-0">
                <strong>Period:</strong> {{ $startDate->format('F d, Y') }} to {{ $endDate->format('F d, Y') }}
            </p>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-9">
            <!-- Monthly Cash Flow -->
            <div class="card mb-4">
                <div class="card-header">
                    <h5 class="card-title mb-0">
                        <i class="bi bi-calendar3 me-2"></i>Monthly Cash Flow
                    </h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-striped">
                            <thead>
                                <tr>
                                    <th>Month</th>
                                    <th class="text-end">Cash In (Income)</th>
                                    <th class="text-end">Cash Out (Expenses)</th>
                                    <th class="text-end">Net Cash Flow</th>
                                    <th class="text-end">Running Balance</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php 
                                    $runningBalance = 0;
                                    $totalCashIn = 0;
                                    $totalCashOut = 0;
                                @endphp
                                @foreach($monthlyData as $month => $data)
                                    @php
                                        $cashIn = $data['income'] ?? 0;
                                        $cashOut = $data['expenses'] ?? 0;
                                        $netFlow = $cashIn - $cashOut;
                                        $runningBalance += $netFlow;
                                        $totalCashIn += $cashIn;
                                        $totalCashOut += $cashOut;
                                    @endphp
                                    <tr>
                                        <td>{{ \Carbon\Carbon::parse($month)->format('F Y') }}</td>
                                        <td class="text-end text-success">${{ number_format($cashIn, 2) }}</td>
                                        <td class="text-end text-danger">${{ number_format($cashOut, 2) }}</td>
                                        <td class="text-end {{ $netFlow >= 0 ? 'text-success' : 'text-danger' }}">
                                            ${{ number_format($netFlow, 2) }}
                                        </td>
                                        <td class="text-end {{ $runningBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                            ${{ number_format($runningBalance, 2) }}
                                        </td>
                                    </tr>
                                @endforeach
                                @if(empty($monthlyData))
                                    <tr>
                                        <td colspan="5" class="text-center text-muted">No data available for this period</td>
                                    </tr>
                                @endif
                            </tbody>
                            <tfoot class="table-secondary">
                                <tr>
                                    <th>Total</th>
                                    <th class="text-end text-success">${{ number_format($totalCashIn, 2) }}</th>
                                    <th class="text-end text-danger">${{ number_format($totalCashOut, 2) }}</th>
                                    <th class="text-end {{ ($totalCashIn - $totalCashOut) >= 0 ? 'text-success' : 'text-danger' }}">
                                        ${{ number_format($totalCashIn - $totalCashOut, 2) }}
                                    </th>
                                    <th class="text-end {{ $runningBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                        ${{ number_format($runningBalance, 2) }}
                                    </th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>

            <!-- Cash Flow Summary -->
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title mb-0">
                        <i class="bi bi-bar-chart me-2"></i>Cash Flow Summary
                    </h5>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-4">
                            <div class="card bg-success text-white">
                                <div class="card-body text-center">
                                    <h4 class="mb-0">${{ number_format($totalCashIn, 2) }}</h4>
                                    <small>Total Cash Inflow</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="card bg-danger text-white">
                                <div class="card-body text-center">
                                    <h4 class="mb-0">${{ number_format($totalCashOut, 2) }}</h4>
                                    <small>Total Cash Outflow</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="card {{ ($totalCashIn - $totalCashOut) >= 0 ? 'bg-info' : 'bg-warning' }} text-white">
                                <div class="card-body text-center">
                                    <h4 class="mb-0">${{ number_format($totalCashIn - $totalCashOut, 2) }}</h4>
                                    <small>Net Cash Flow</small>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-lg-3">
            <!-- Key Insights -->
            <div class="card mb-3">
                <div class="card-header">
                    <h6 class="card-title mb-0">
                        <i class="bi bi-lightbulb me-1"></i>Key Insights
                    </h6>
                </div>
                <div class="card-body">
                    <div class="small">
                        @if($totalCashIn > 0)
                            <div class="mb-3">
                                <strong>Cash Flow Ratio:</strong><br>
                                <span class="text-muted">{{ number_format(($totalCashOut / $totalCashIn) * 100, 1) }}% of income spent</span>
                            </div>
                        @endif
                        
                        @php
                            $positiveMonths = collect($monthlyData)->filter(function($data) {
                                return ($data['income'] ?? 0) - ($data['expenses'] ?? 0) > 0;
                            })->count();
                            $totalMonths = count($monthlyData);
                        @endphp
                        
                        @if($totalMonths > 0)
                            <div class="mb-3">
                                <strong>Positive Months:</strong><br>
                                <span class="text-muted">{{ $positiveMonths }} of {{ $totalMonths }} months ({{ number_format(($positiveMonths / $totalMonths) * 100, 1) }}%)</span>
                            </div>
                        @endif

                        @if($totalCashIn > 0 && $totalCashOut > 0)
                            <div class="mb-3">
                                <strong>Average Monthly:</strong><br>
                                <span class="text-success">Income: ${{ number_format($totalCashIn / max(1, $totalMonths), 2) }}</span><br>
                                <span class="text-danger">Expenses: ${{ number_format($totalCashOut / max(1, $totalMonths), 2) }}</span>
                            </div>
                        @endif

                        @if($runningBalance < 0)
                            <div class="alert alert-warning p-2">
                                <small><strong>Warning:</strong> Negative cash flow detected. Consider reviewing expenses.</small>
                            </div>
                        @elseif($runningBalance > 0)
                            <div class="alert alert-success p-2">
                                <small><strong>Good:</strong> Positive cash flow indicates healthy financial position.</small>
                            </div>
                        @endif
                    </div>
                </div>
            </div>

            <!-- Quick Actions -->
            <div class="card">
                <div class="card-header">
                    <h6 class="card-title mb-0">
                        <i class="bi bi-lightning me-1"></i>Quick Actions
                    </h6>
                </div>
                <div class="card-body">
                    <div class="d-grid gap-2">
                        <a href="{{ route('incomes.index') }}" class="btn btn-success btn-sm">
                            <i class="bi bi-plus-circle me-1"></i>Record Income
                        </a>
                        <a href="{{ route('expenses.index') }}" class="btn btn-danger btn-sm">
                            <i class="bi bi-plus-circle me-1"></i>Record Expense
                        </a>
                        <a href="{{ route('financial.profit-loss') }}" class="btn btn-info btn-sm">
                            <i class="bi bi-graph-up me-1"></i>Profit & Loss Report
                        </a>
                        <a href="{{ route('financial.dashboard') }}" class="btn btn-outline-primary btn-sm">
                            <i class="bi bi-speedometer2 me-1"></i>Dashboard
                        </a>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<style>
@media print {
    .btn, .card-header .btn-group, .no-print {
        display: none !important;
    }
    
    .card {
        border: 1px solid #000 !important;
        box-shadow: none !important;
    }
    
    .card-header {
        background-color: #f8f9fa !important;
        color: #000 !important;
    }
    
    .table th, .table td {
        border: 1px solid #000 !important;
    }
}
</style>
@endsection