@extends('layouts.master')

@section('page_title', 'Fee Collection Report')

@section('content')
<div class="container-fluid">
    <!-- Filter Section -->
    <div class="card mb-4 no-print">
        <div class="card-header">
            <h5 class="mb-0">Fee Collection Report Filters</h5>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('reports.fee-collection') }}" 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="{{ $startDate }}" required>
                </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="{{ $endDate }}" required>
                </div>
                <div class="col-md-3">
                    <label for="class_id" class="form-label">Class</label>
                    <select class="form-select" id="class_id" name="class_id">
                        <option value="">All Classes</option>
                        @foreach($classes as $class)
                            <option value="{{ $class->id }}" {{ $classId == $class->id ? 'selected' : '' }}>
                                {{ $class->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3">
                    <label for="term_id" class="form-label">Term</label>
                    <select class="form-select" id="term_id" name="term_id">
                        <option value="">All Terms</option>
                        @foreach($terms as $term)
                            <option value="{{ $term->id }}" {{ $termId == $term->id ? 'selected' : '' }}>
                                {{ $term->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-12 d-flex gap-2">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-search"></i> Generate Report
                    </button>
                    <button type="button" class="btn btn-success" onclick="window.print()">
                        <i class="fas fa-print"></i> Print Report
                    </button>
                    <button type="button" class="btn btn-info" onclick="exportToExcel()">
                        <i class="fas fa-file-excel"></i> Export to Excel
                    </button>
                </div>
            </form>
        </div>
    </div>

    <!-- Report Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h2>Fee Collection Report</h2>
            <p class="text-muted mb-0">Period: {{ Carbon\Carbon::parse($startDate)->format('M d, Y') }} - {{ Carbon\Carbon::parse($endDate)->format('M d, Y') }}</p>
        </div>
        <div class="text-end">
            <p class="mb-0"><strong>Generated:</strong> {{ Carbon\Carbon::now()->format('M d, Y g:i A') }}</p>
            <p class="mb-0"><strong>Total Students:</strong> {{ $feeCollections->count() }}</p>
        </div>
    </div>

    <!-- Summary Cards -->
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card bg-primary text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">${{ number_format($feeCollections->sum('total_paid'), 2) }}</h3>
                            <p class="mb-0">Total Collected</p>
                        </div>
                        <div>
                            <i class="fas fa-money-bill-wave fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-success text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">{{ $feeCollections->count() }}</h3>
                            <p class="mb-0">Students Paid</p>
                        </div>
                        <div>
                            <i class="fas fa-users fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-info text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">${{ $feeCollections->count() > 0 ? number_format($feeCollections->avg('total_paid'), 2) : '0.00' }}</h3>
                            <p class="mb-0">Average Payment</p>
                        </div>
                        <div>
                            <i class="fas fa-calculator fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-warning text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">{{ $feeCollections->sum('payment_count') }}</h3>
                            <p class="mb-0">Total Transactions</p>
                        </div>
                        <div>
                            <i class="fas fa-receipt fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Class Summary -->
    @if($classSummary->count() > 0)
    <div class="card mb-4">
        <div class="card-header">
            <h5 class="mb-0">Summary by Class</h5>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-striped">
                    <thead>
                        <tr>
                            <th>Class</th>
                            <th class="text-center">Students</th>
                            <th class="text-end">Total Collected</th>
                            <th class="text-end">Average per Student</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($classSummary as $summary)
                        <tr>
                            <td><strong>{{ $summary->class_name }}</strong></td>
                            <td class="text-center">{{ $summary->student_count }}</td>
                            <td class="text-end">${{ number_format($summary->total_collected, 2) }}</td>
                            <td class="text-end">${{ number_format($summary->avg_payment, 2) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr class="table-primary">
                            <th>Total</th>
                            <th class="text-center">{{ $classSummary->sum('student_count') }}</th>
                            <th class="text-end">${{ number_format($classSummary->sum('total_collected'), 2) }}</th>
                            <th class="text-end">${{ $classSummary->count() > 0 ? number_format($classSummary->avg('avg_payment'), 2) : '0.00' }}</th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>
    @endif

    <!-- Detailed Collections -->
    <div class="card">
        <div class="card-header">
            <h5 class="mb-0">Detailed Fee Collections</h5>
        </div>
        <div class="card-body">
            @if($feeCollections->count() > 0)
                <div class="table-responsive">
                    <table class="table table-striped table-hover" id="feeCollectionTable">
                        <thead>
                            <tr>
                                <th>Student ID</th>
                                <th>Student Name</th>
                                <th>Class</th>
                                <th>Section</th>
                                <th class="text-end">Amount Paid</th>
                                <th class="text-center">Payments</th>
                                <th>First Payment</th>
                                <th>Last Payment</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($feeCollections as $collection)
                            <tr>
                                <td><code>{{ $collection->student_id }}</code></td>
                                <td>{{ $collection->student_name }}</td>
                                <td><span class="badge bg-primary">{{ $collection->class_name }}</span></td>
                                <td>{{ $collection->section_name ?? 'N/A' }}</td>
                                <td class="text-end">
                                    <strong>${{ number_format($collection->total_paid, 2) }}</strong>
                                </td>
                                <td class="text-center">
                                    <span class="badge bg-info">{{ $collection->payment_count }}</span>
                                </td>
                                <td>{{ Carbon\Carbon::parse($collection->first_payment)->format('M d, Y') }}</td>
                                <td>{{ Carbon\Carbon::parse($collection->last_payment)->format('M d, Y') }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr class="table-success">
                                <th colspan="4">Grand Total</th>
                                <th class="text-end">${{ number_format($feeCollections->sum('total_paid'), 2) }}</th>
                                <th class="text-center">{{ $feeCollections->sum('payment_count') }}</th>
                                <th colspan="2"></th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            @else
                <div class="alert alert-warning">
                    <i class="fas fa-exclamation-triangle"></i>
                    <strong>No Data Found</strong><br>
                    No fee collections found for the selected criteria and date range.
                </div>
            @endif
        </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>

<script>
function exportToExcel() {
    // Get table data
    const table = document.getElementById('feeCollectionTable');
    const rows = table.querySelectorAll('tr');
    
    let csvContent = '';
    rows.forEach(row => {
        const cells = row.querySelectorAll('th, td');
        const rowData = Array.from(cells).map(cell => {
            return '"' + cell.textContent.trim().replace(/"/g, '""') + '"';
        });
        csvContent += rowData.join(',') + '\n';
    });
    
    // Create download
    const blob = new Blob([csvContent], { type: 'text/csv' });
    const url = window.URL.createObjectURL(blob);
    const a = document.createElement('a');
    a.href = url;
    a.download = 'fee_collection_report_{{ Carbon\Carbon::now()->format("Y_m_d") }}.csv';
    document.body.appendChild(a);
    a.click();
    document.body.removeChild(a);
    window.URL.revokeObjectURL(url);
}
</script>
@endsection