@extends('layouts.app')

@section('title', 'CBO Performance 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-building me-2"></i>
                        CBO Performance 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.cbo-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="branch_id" class="form-label">Branch</label>
                                            <select name="branch_id" id="branch_id" class="form-select">
                                                <option value="all" {{ $branchId === 'all' ? 'selected' : '' }}>All Branches</option>
                                                @foreach($branches as $branch)
                                                    <option value="{{ $branch->id }}" {{ $branchId == $branch->id ? 'selected' : '' }}>
                                                        {{ $branch->branch_name }}
                                                    </option>
                                                @endforeach
                                            </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.cbo-reports') }}" class="btn btn-outline-secondary">
                                                <i class="fas fa-times me-2"></i>Clear Filters
                                            </a>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- CBO Performance Summary -->
                    <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-chart-bar me-2"></i>CBO Performance Summary
                                    </h5>
                                </div>
                                <div class="card-body">
                                    @if(count($stats) > 0)
                                        <div class="table-responsive">
                                            <table class="table table-striped table-hover">
                                                <thead class="table-dark">
                                                    <tr>
                                                        <th>CBO Name</th>
                                                        <th class="text-center">Members</th>
                                                        <th class="text-center">Groups</th>
                                                        <th class="text-center">Loans</th>
                                                        <th class="text-end">Loan Amount</th>
                                                        <th class="text-center">Actions</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @foreach($stats as $cboStat)
                                                        <tr>
                                                            <td>
                                                                <strong>{{ $cboStat['cbo_name'] }}</strong>
                                                            </td>
                                                            <td class="text-center">
                                                                <span class="badge bg-primary">{{ $cboStat['member_count'] }}</span>
                                                            </td>
                                                            <td class="text-center">
                                                                <span class="badge bg-info">{{ $cboStat['group_count'] }}</span>
                                                            </td>
                                                            <td class="text-center">
                                                                <span class="badge bg-success">{{ $cboStat['loan_count'] }}</span>
                                                            </td>
                                                            <td class="text-end">
                                                                <strong>Rs. {{ number_format($cboStat['loan_amount'], 2) }}</strong>
                                                            </td>
                                                            <td class="text-center">
                                                                <button type="button" class="btn btn-sm btn-outline-info" 
                                                                        onclick="viewCboDetails('{{ $cboStat['cbo_name'] }}')">
                                                                    <i class="fas fa-eye"></i> Details
                                                                </button>
                                                            </td>
                                                        </tr>
                                                    @endforeach
                                                </tbody>
                                                <tfoot class="table-secondary">
                                                    <tr>
                                                        <td><strong>Total</strong></td>
                                                        <td class="text-center">
                                                            <strong>{{ array_sum(array_column($stats, 'member_count')) }}</strong>
                                                        </td>
                                                        <td class="text-center">
                                                            <strong>{{ array_sum(array_column($stats, 'group_count')) }}</strong>
                                                        </td>
                                                        <td class="text-center">
                                                            <strong>{{ array_sum(array_column($stats, 'loan_count')) }}</strong>
                                                        </td>
                                                        <td class="text-end">
                                                            <strong>Rs. {{ number_format(array_sum(array_column($stats, 'loan_amount')), 2) }}</strong>
                                                        </td>
                                                        <td></td>
                                                    </tr>
                                                </tfoot>
                                            </table>
                                        </div>
                                    @else
                                        <div class="text-center py-4">
                                            <i class="fas fa-building fa-3x text-muted mb-3"></i>
                                            <h5 class="text-muted">No CBO data found</h5>
                                            <p class="text-muted">Try adjusting your filter criteria</p>
                                        </div>
                                    @endif
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Performance Metrics -->
                    @if(count($stats) > 0)
                    <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>Member Distribution
                                    </h5>
                                </div>
                                <div class="card-body">
                                    @php
                                        $totalMembers = array_sum(array_column($stats, 'member_count'));
                                        $totalGroups = array_sum(array_column($stats, 'group_count'));
                                    @endphp
                                    <div class="row text-center">
                                        <div class="col-6">
                                            <h3 class="text-primary">{{ $totalMembers }}</h3>
                                            <p class="text-muted">Total Members</p>
                                        </div>
                                        <div class="col-6">
                                            <h3 class="text-info">{{ $totalGroups }}</h3>
                                            <p class="text-muted">Total Groups</p>
                                        </div>
                                    </div>
                                    <div class="progress mb-2">
                                        <div class="progress-bar bg-primary" style="width: 100%"></div>
                                    </div>
                                    <small class="text-muted">Average {{ $totalMembers > 0 ? round($totalMembers / count($stats), 1) : 0 }} members per CBO</small>
                                </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-line me-2"></i>Loan Performance
                                    </h5>
                                </div>
                                <div class="card-body">
                                    @php
                                        $totalLoans = array_sum(array_column($stats, 'loan_count'));
                                        $totalLoanAmount = array_sum(array_column($stats, 'loan_amount'));
                                    @endphp
                                    <div class="row text-center">
                                        <div class="col-6">
                                            <h3 class="text-success">{{ $totalLoans }}</h3>
                                            <p class="text-muted">Total Loans</p>
                                        </div>
                                        <div class="col-6">
                                            <h3 class="text-warning">Rs. {{ number_format($totalLoanAmount, 0) }}</h3>
                                            <p class="text-muted">Total Amount</p>
                                        </div>
                                    </div>
                                    <div class="progress mb-2">
                                        <div class="progress-bar bg-success" style="width: 100%"></div>
                                    </div>
                                    <small class="text-muted">Average {{ $totalLoans > 0 ? round($totalLoans / count($stats), 1) : 0 }} loans per CBO</small>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Top Performing CBOs -->
                    <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-trophy me-2"></i>Top CBOs by Members
                                    </h5>
                                </div>
                                <div class="card-body">
                                    @php
                                        $topMembers = collect($stats)->sortByDesc('member_count')->take(5);
                                    @endphp
                                    @foreach($topMembers as $index => $cbo)
                                        <div class="d-flex justify-content-between align-items-center mb-2">
                                            <div>
                                                @if($index === 0)
                                                    <i class="fas fa-medal text-warning me-2"></i>
                                                @elseif($index === 1)
                                                    <i class="fas fa-medal text-secondary me-2"></i>
                                                @elseif($index === 2)
                                                    <i class="fas fa-medal text-bronze me-2"></i>
                                                @else
                                                    <span class="me-4"></span>
                                                @endif
                                                <strong>{{ $cbo['cbo_name'] }}</strong>
                                            </div>
                                            <span class="badge bg-primary">{{ $cbo['member_count'] }} members</span>
                                        </div>
                                    @endforeach
                                </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>Top CBOs by Loan Amount
                                    </h5>
                                </div>
                                <div class="card-body">
                                    @php
                                        $topLoans = collect($stats)->sortByDesc('loan_amount')->take(5);
                                    @endphp
                                    @foreach($topLoans as $index => $cbo)
                                        <div class="d-flex justify-content-between align-items-center mb-2">
                                            <div>
                                                @if($index === 0)
                                                    <i class="fas fa-medal text-warning me-2"></i>
                                                @elseif($index === 1)
                                                    <i class="fas fa-medal text-secondary me-2"></i>
                                                @elseif($index === 2)
                                                    <i class="fas fa-medal text-bronze me-2"></i>
                                                @else
                                                    <span class="me-4"></span>
                                                @endif
                                                <strong>{{ $cbo['cbo_name'] }}</strong>
                                            </div>
                                            <span class="badge bg-success">Rs. {{ number_format($cbo['loan_amount'], 0) }}</span>
                                        </div>
                                    @endforeach
                                </div>
                            </div>
                        </div>
                    </div>
                    @endif

                    <!-- 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="cbo_reports">
                                        <input type="hidden" name="start_date" value="{{ $startDate }}">
                                        <input type="hidden" name="end_date" value="{{ $endDate }}">
                                        <input type="hidden" name="branch_id" value="{{ $branchId }}">
                                        
                                        <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>

<!-- CBO Details Modal -->
<div class="modal fade" id="cboDetailsModal" tabindex="-1">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">
                    <i class="fas fa-building me-2"></i>
                    CBO Details
                </h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body" id="cboDetailsContent">
                <!-- Content will be loaded here -->
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>
@endsection

@section('scripts')
<script>
function viewCboDetails(cboName) {
    // This would typically make an AJAX call to get CBO details
    // For now, we'll show a placeholder
    const modal = new bootstrap.Modal(document.getElementById('cboDetailsModal'));
    document.getElementById('cboDetailsContent').innerHTML = `
        <div class="text-center py-4">
            <i class="fas fa-spinner fa-spin fa-2x text-muted mb-3"></i>
            <p>Loading CBO details...</p>
        </div>
    `;
    modal.show();
    
    // Simulate loading CBO details
    setTimeout(() => {
        document.getElementById('cboDetailsContent').innerHTML = `
            <div class="row">
                <div class="col-md-6">
                    <h6>CBO Information</h6>
                    <p><strong>Name:</strong> ${cboName}</p>
                    <p><strong>Status:</strong> <span class="badge bg-success">Active</span></p>
                    <p><strong>Formation Date:</strong> 2024-01-01</p>
                </div>
                <div class="col-md-6">
                    <h6>Performance Metrics</h6>
                    <p><strong>Members:</strong> 25</p>
                    <p><strong>Groups:</strong> 4</p>
                    <p><strong>Loans:</strong> 15</p>
                    <p><strong>Total Amount:</strong> Rs. 1,500,000</p>
                </div>
            </div>
        `;
    }, 1000);
}

document.addEventListener('DOMContentLoaded', function() {
    // Auto-submit form when branch filter changes
    const branchSelect = document.getElementById('branch_id');
    branchSelect.addEventListener('change', function() {
        this.closest('form').submit();
    });
});
</script>
@endsection