@extends('layouts.bootstrap')

@section('title', 'Profit & Loss 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 me-2"></i>Profit & Loss 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.profit-loss') }}" 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="current_year" {{ $period == 'current_year' ? 'selected' : '' }}>Current Year</option>
                        <option value="last_year" {{ $period == 'last_year' ? 'selected' : '' }}>Last Year</option>
                        <option value="current_month" {{ $period == 'current_month' ? 'selected' : '' }}>Current Month</option>
                        <option value="last_month" {{ $period == 'last_month' ? 'selected' : '' }}>Last Month</option>
                        <option value="custom" {{ $period == 'custom' ? 'selected' : '' }}>Custom Range</option>
                    </select>
                </div>
                @if($period == 'custom')
                    <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') }}">
                    </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') }}">
                    </div>
                    <div class="col-md-3">
                        <label class="form-label">&nbsp;</label>
                        <div class="d-grid">
                            <button type="submit" class="btn btn-primary">Generate Report</button>
                        </div>
                    </div>
                @endif
            </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">Profit & Loss 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-8">
            <!-- Income Section -->
            <div class="card mb-4">
                <div class="card-header bg-success text-white">
                    <h5 class="card-title mb-0">
                        <i class="bi bi-arrow-up-circle me-2"></i>Revenue (Income)
                    </h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-sm">
                            <tbody>
                                @php $totalIncome = 0; @endphp
                                @foreach($incomeByCategory as $category => $amount)
                                    @php $totalIncome += $amount; @endphp
                                    <tr>
                                        <td>{{ \App\Models\Income::getCategoryDisplayName($category) }}</td>
                                        <td class="text-end">${{ number_format($amount, 2) }}</td>
                                    </tr>
                                @endforeach
                                @if(empty($incomeByCategory))
                                    <tr>
                                        <td colspan="2" class="text-center text-muted">No income recorded for this period</td>
                                    </tr>
                                @endif
                            </tbody>
                            <tfoot class="table-success">
                                <tr>
                                    <th>Total Revenue</th>
                                    <th class="text-end">${{ number_format($totalIncome, 2) }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>

            <!-- Expenses Section -->
            <div class="card mb-4">
                <div class="card-header bg-danger text-white">
                    <h5 class="card-title mb-0">
                        <i class="bi bi-arrow-down-circle me-2"></i>Expenses
                    </h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-sm">
                            <tbody>
                                @php $totalExpenses = 0; @endphp
                                @foreach($expensesByCategory as $category => $amount)
                                    @php $totalExpenses += $amount; @endphp
                                    <tr>
                                        <td>{{ \App\Models\Expense::getCategoryDisplayName($category) }}</td>
                                        <td class="text-end">${{ number_format($amount, 2) }}</td>
                                    </tr>
                                @endforeach
                                @if(empty($expensesByCategory))
                                    <tr>
                                        <td colspan="2" class="text-center text-muted">No expenses recorded for this period</td>
                                    </tr>
                                @endif
                            </tbody>
                            <tfoot class="table-danger">
                                <tr>
                                    <th>Total Expenses</th>
                                    <th class="text-end">${{ number_format($totalExpenses, 2) }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>

            <!-- Net Profit/Loss -->
            <div class="card">
                <div class="card-header {{ $totalIncome - $totalExpenses >= 0 ? 'bg-success' : 'bg-warning' }} text-white">
                    <h5 class="card-title mb-0">
                        <i class="bi bi-calculator me-2"></i>Net {{ $totalIncome - $totalExpenses >= 0 ? 'Profit' : 'Loss' }}
                    </h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-sm">
                            <tbody>
                                <tr>
                                    <td><strong>Total Revenue</strong></td>
                                    <td class="text-end"><strong>${{ number_format($totalIncome, 2) }}</strong></td>
                                </tr>
                                <tr>
                                    <td><strong>Total Expenses</strong></td>
                                    <td class="text-end"><strong>(${{ number_format($totalExpenses, 2) }})</strong></td>
                                </tr>
                            </tbody>
                            <tfoot class="{{ $totalIncome - $totalExpenses >= 0 ? 'table-success' : 'table-warning' }}">
                                <tr>
                                    <th>Net {{ $totalIncome - $totalExpenses >= 0 ? 'Profit' : 'Loss' }}</th>
                                    <th class="text-end">
                                        ${{ number_format($totalIncome - $totalExpenses, 2) }}
                                    </th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                    
                    @if($totalIncome > 0)
                        <div class="mt-3">
                            <small class="text-muted">
                                Profit Margin: {{ number_format((($totalIncome - $totalExpenses) / $totalIncome) * 100, 1) }}%
                            </small>
                        </div>
                    @endif
                </div>
            </div>
        </div>

        <div class="col-lg-4">
            <!-- Summary Cards -->
            <div class="card mb-3">
                <div class="card-header">
                    <h6 class="card-title mb-0">
                        <i class="bi bi-info-circle me-1"></i>Summary
                    </h6>
                </div>
                <div class="card-body">
                    <div class="row text-center">
                        <div class="col-12 mb-3">
                            <div class="border-bottom pb-2">
                                <h5 class="text-success mb-0">${{ number_format($totalIncome, 2) }}</h5>
                                <small class="text-muted">Total Revenue</small>
                            </div>
                        </div>
                        <div class="col-12 mb-3">
                            <div class="border-bottom pb-2">
                                <h5 class="text-danger mb-0">${{ number_format($totalExpenses, 2) }}</h5>
                                <small class="text-muted">Total Expenses</small>
                            </div>
                        </div>
                        <div class="col-12">
                            <h4 class="{{ $totalIncome - $totalExpenses >= 0 ? 'text-success' : 'text-warning' }} mb-0">
                                ${{ number_format($totalIncome - $totalExpenses, 2) }}
                            </h4>
                            <small class="text-muted">Net {{ $totalIncome - $totalExpenses >= 0 ? 'Profit' : 'Loss' }}</small>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Key Metrics -->
            <div class="card mb-3">
                <div class="card-header">
                    <h6 class="card-title mb-0">
                        <i class="bi bi-graph-up me-1"></i>Key Metrics
                    </h6>
                </div>
                <div class="card-body">
                    <div class="small">
                        @if($totalIncome > 0)
                            <div class="d-flex justify-content-between mb-2">
                                <span>Profit Margin:</span>
                                <strong>{{ number_format((($totalIncome - $totalExpenses) / $totalIncome) * 100, 1) }}%</strong>
                            </div>
                            <div class="d-flex justify-content-between mb-2">
                                <span>Expense Ratio:</span>
                                <strong>{{ number_format(($totalExpenses / $totalIncome) * 100, 1) }}%</strong>
                            </div>
                        @endif
                        <div class="d-flex justify-content-between mb-2">
                            <span>Income Categories:</span>
                            <strong>{{ count($incomeByCategory) }}</strong>
                        </div>
                        <div class="d-flex justify-content-between">
                            <span>Expense Categories:</span>
                            <strong>{{ count($expensesByCategory) }}</strong>
                        </div>
                    </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.cash-flow') }}" class="btn btn-info btn-sm">
                            <i class="bi bi-graph-up me-1"></i>Cash Flow 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