@extends('layouts.app')

@section('title', 'Financial Reports')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">
                        <i class="fas fa-chart-line me-2"></i>
                        Financial Reports
                    </h4>
                    <div class="card-tools">
                        <a href="{{ route('reports.index') }}" class="btn btn-outline-secondary">
                            <i class="fas fa-arrow-left me-2"></i>Back to Reports
                        </a>
                    </div>
                </div>
                <div class="card-body">
                    @if(session('success'))
                        <div class="alert alert-success alert-dismissible fade show" role="alert">
                            <i class="fas fa-check-circle me-2"></i>
                            {{ session('success') }}
                            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                        </div>
                    @endif

                    <!-- Filter Form -->
                    <div class="row mb-4">
                        <div class="col-md-12">
                            <div class="card">
                                <div class="card-header">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-filter me-2"></i>Filter Options
                                    </h5>
                                </div>
                                <div class="card-body">
                                    <form method="GET" action="{{ route('reports.financial-reports') }}" class="row g-3">
                                        <div class="col-md-4">
                                            <label for="start_date" class="form-label">Start Date</label>
                                            <input type="date" name="start_date" id="start_date" class="form-control" 
                                                   value="{{ $startDate }}">
                                        </div>
                                        <div class="col-md-4">
                                            <label for="end_date" class="form-label">End Date</label>
                                            <input type="date" name="end_date" id="end_date" class="form-control" 
                                                   value="{{ $endDate }}">
                                        </div>
                                        <div class="col-md-4">
                                            <label for="report_type" class="form-label">Report Type</label>
                                            <select name="report_type" id="report_type" class="form-select">
                                                <option value="summary" {{ $reportType === 'summary' ? 'selected' : '' }}>Summary</option>
                                                <option value="detailed" {{ $reportType === 'detailed' ? 'selected' : '' }}>Detailed</option>
                                                <option value="comparative" {{ $reportType === 'comparative' ? 'selected' : '' }}>Comparative</option>
                                            </select>
                                        </div>
                                        <div class="col-12">
                                            <button type="submit" class="btn btn-primary">
                                                <i class="fas fa-search me-2"></i>Apply Filters
                                            </button>
                                            <a href="{{ route('reports.financial-reports') }}" class="btn btn-outline-secondary">
                                                <i class="fas fa-times me-2"></i>Clear Filters
                                            </a>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Key Financial Metrics -->
                    <div class="row mb-4">
                        <div class="col-md-3">
                            <div class="card bg-primary text-white">
                                <div class="card-body text-center">
                                    <h3 class="mb-0">Rs. {{ number_format($stats['total_disbursed'], 2) }}</h3>
                                    <p class="mb-0">Total Disbursed</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card bg-success text-white">
                                <div class="card-body text-center">
                                    <h3 class="mb-0">Rs. {{ number_format($stats['total_collected'], 2) }}</h3>
                                    <p class="mb-0">Total Collected</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card bg-info text-white">
                                <div class="card-body text-center">
                                    <h3 class="mb-0">Rs. {{ number_format($stats['total_interest_collected'], 2) }}</h3>
                                    <p class="mb-0">Interest Collected</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card bg-warning text-dark">
                                <div class="card-body text-center">
                                    <h3 class="mb-0">{{ number_format($stats['collection_rate'], 1) }}%</h3>
                                    <p class="mb-0">Collection Rate</p>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Financial Analysis -->
                    <div class="row mb-4">
                        <div class="col-md-6">
                            <div class="card">
                                <div class="card-header">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-chart-pie me-2"></i>Revenue Breakdown
                                    </h5>
                                </div>
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-md-6">
                                            <h6>Capital Collections</h6>
                                            <p class="text-success">Rs. {{ number_format($stats['total_capital_collected'], 2) }}</p>
                                            <div class="progress mb-2">
                                                @php
                                                    $totalRevenue = $stats['total_collected'];
                                                    $capitalPercent = $totalRevenue > 0 ? ($stats['total_capital_collected'] / $totalRevenue) * 100 : 0;
                                                @endphp
                                                <div class="progress-bar bg-success" style="width: {{ $capitalPercent }}%"></div>
                                            </div>
                                            <small class="text-muted">{{ number_format($capitalPercent, 1) }}% of total revenue</small>
                                        </div>
                                        <div class="col-md-6">
                                            <h6>Interest Collections</h6>
                                            <p class="text-info">Rs. {{ number_format($stats['total_interest_collected'], 2) }}</p>
                                            <div class="progress mb-2">
                                                @php
                                                    $interestPercent = $totalRevenue > 0 ? ($stats['total_interest_collected'] / $totalRevenue) * 100 : 0;
                                                @endphp
                                                <div class="progress-bar bg-info" style="width: {{ $interestPercent }}%"></div>
                                            </div>
                                            <small class="text-muted">{{ number_format($interestPercent, 1) }}% of total revenue</small>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="card">
                                <div class="card-header">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-chart-bar me-2"></i>Performance Metrics
                                    </h5>
                                </div>
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-md-6">
                                            <h6>Collection Efficiency</h6>
                                            <div class="d-flex align-items-center">
                                                <div class="flex-grow-1">
                                                    <div class="progress mb-1">
                                                        <div class="progress-bar bg-{{ $stats['collection_rate'] >= 80 ? 'success' : ($stats['collection_rate'] >= 60 ? 'warning' : 'danger') }}" 
                                                             style="width: {{ min($stats['collection_rate'], 100) }}%"></div>
                                                    </div>
                                                </div>
                                                <div class="ms-2">
                                                    <strong>{{ number_format($stats['collection_rate'], 1) }}%</strong>
                                                </div>
                                            </div>
                                            <small class="text-muted">
                                                @if($stats['collection_rate'] >= 80)
                                                    Excellent performance
                                                @elseif($stats['collection_rate'] >= 60)
                                                    Good performance
                                                @else
                                                    Needs improvement
                                                @endif
                                            </small>
                                        </div>
                                        <div class="col-md-6">
                                            <h6>Portfolio Growth</h6>
                                            <p class="text-primary">Rs. {{ number_format($stats['total_disbursed'], 2) }}</p>
                                            <small class="text-muted">Total portfolio value</small>
                                            
                                            <h6 class="mt-3">Outstanding Amount</h6>
                                            @php
                                                $outstanding = $stats['total_disbursed'] - $stats['total_capital_collected'];
                                            @endphp
                                            <p class="text-warning">Rs. {{ number_format($outstanding, 2) }}</p>
                                            <small class="text-muted">Remaining to be collected</small>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Financial Summary Table -->
                    <div class="row">
                        <div class="col-md-12">
                            <div class="card">
                                <div class="card-header">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-table me-2"></i>Financial Summary
                                    </h5>
                                </div>
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table class="table table-bordered">
                                            <thead class="table-dark">
                                                <tr>
                                                    <th>Metric</th>
                                                    <th class="text-end">Amount (Rs.)</th>
                                                    <th class="text-end">Percentage</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <tr>
                                                    <td><strong>Total Loan Disbursements</strong></td>
                                                    <td class="text-end">{{ number_format($stats['total_disbursed'], 2) }}</td>
                                                    <td class="text-end">100.0%</td>
                                                </tr>
                                                <tr class="table-success">
                                                    <td><strong>Total Collections</strong></td>
                                                    <td class="text-end">{{ number_format($stats['total_collected'], 2) }}</td>
                                                    <td class="text-end">{{ $stats['total_disbursed'] > 0 ? number_format(($stats['total_collected'] / $stats['total_disbursed']) * 100, 1) : 0 }}%</td>
                                                </tr>
                                                <tr class="table-info">
                                                    <td>&nbsp;&nbsp;&nbsp;&nbsp;Interest Collections</td>
                                                    <td class="text-end">{{ number_format($stats['total_interest_collected'], 2) }}</td>
                                                    <td class="text-end">{{ $stats['total_collected'] > 0 ? number_format(($stats['total_interest_collected'] / $stats['total_collected']) * 100, 1) : 0 }}%</td>
                                                </tr>
                                                <tr class="table-warning">
                                                    <td>&nbsp;&nbsp;&nbsp;&nbsp;Capital Collections</td>
                                                    <td class="text-end">{{ number_format($stats['total_capital_collected'], 2) }}</td>
                                                    <td class="text-end">{{ $stats['total_collected'] > 0 ? number_format(($stats['total_capital_collected'] / $stats['total_collected']) * 100, 1) : 0 }}%</td>
                                                </tr>
                                                <tr class="table-danger">
                                                    <td><strong>Outstanding Amount</strong></td>
                                                    <td class="text-end">{{ number_format($stats['total_disbursed'] - $stats['total_capital_collected'], 2) }}</td>
                                                    <td class="text-end">{{ $stats['total_disbursed'] > 0 ? number_format((($stats['total_disbursed'] - $stats['total_capital_collected']) / $stats['total_disbursed']) * 100, 1) : 0 }}%</td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Export Options -->
                    <div class="row mt-4">
                        <div class="col-md-12">
                            <div class="card">
                                <div class="card-header">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-download me-2"></i>Export Options
                                    </h5>
                                </div>
                                <div class="card-body">
                                    <form action="{{ route('reports.export') }}" method="POST" class="row g-3">
                                        @csrf
                                        <input type="hidden" name="report_type" value="financial_reports">
                                        <input type="hidden" name="start_date" value="{{ $startDate }}">
                                        <input type="hidden" name="end_date" value="{{ $endDate }}">
                                        <input type="hidden" name="report_type_filter" value="{{ $reportType }}">
                                        
                                        <div class="col-md-3">
                                            <button type="submit" name="format" value="pdf" class="btn btn-danger w-100">
                                                <i class="fas fa-file-pdf me-2"></i>Export as PDF
                                            </button>
                                        </div>
                                        <div class="col-md-3">
                                            <button type="submit" name="format" value="excel" class="btn btn-success w-100">
                                                <i class="fas fa-file-excel me-2"></i>Export as Excel
                                            </button>
                                        </div>
                                        <div class="col-md-3">
                                            <button type="submit" name="format" value="csv" class="btn btn-info w-100">
                                                <i class="fas fa-file-csv me-2"></i>Export as CSV
                                            </button>
                                        </div>
                                        <div class="col-md-3">
                                            <button type="button" class="btn btn-secondary w-100" onclick="window.print()">
                                                <i class="fas fa-print me-2"></i>Print Report
                                            </button>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('scripts')
<script>
document.addEventListener('DOMContentLoaded', function() {
    // Auto-submit form when report type changes
    const reportTypeSelect = document.getElementById('report_type');
    reportTypeSelect.addEventListener('change', function() {
        this.closest('form').submit();
    });
});
</script>
@endsection