@extends('admin-layouts.vertical', ['title' => 'Fees Report'])

{{-- @section('css')
    @vite(['node_modules/simple-datatables/dist/style.css'])
@endsection --}}

@section('content')
<div class="row justify-content-center">
    <div class="col-12">
        <div class="card">
            <div class="card-header">
                <div class="row align-items-center">
                    <div class="col">
                        <h4 class="card-title">Fees Report</h4>
                    </div>
                </div>
            </div>

            <div class="card-body">
                {{-- Success Message --}}
                @if (session('success'))
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        {{ session('success') }}
                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                    </div>
                @endif

                {{-- Error Messages --}}
                @if ($errors->any())
                    <div class="alert alert-danger d-none    alert-dismissible fade show" role="alert">
                        <h6><strong>Error:</strong></h6>
                        <ul class="mb-0">
                            @foreach ($errors->all() as $error)
                                <li>{{ $error }}</li>
                            @endforeach
                        </ul>
                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                    </div>
                @endif

                {{-- Filter Form --}}
                <div class="card mb-4">
                    <div class="card-header">
                        <h6 class="card-title mb-0">Report Filters</h6>
                    </div>
                    <div class="card-body">
                        <form method="POST" action="{{ route('reports.fees.generate') }}" id="reportForm">
                            @csrf
                            <div class="row">
                                <div class="col-md-4">
                                    <div class="mb-3">
                                        <label for="year_id" class="form-label">Academic Year</label>
                                        <select class="form-select" id="year_id" name="year_id">
                                            <option value="">All Academic Years</option>
                                            @foreach($academicYears as $year)
                                                <option value="{{ $year->id }}" 
                                                    {{ old('year_id', $request->year_id) == $year->id ? 'selected' : '' }}>
                                                    {{ \Carbon\Carbon::parse($year->from_date)->format('Y') }} - 
                                                    {{ \Carbon\Carbon::parse($year->to_date)->format('Y') }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                                <div class="col-md-4">
                                    <div class="mb-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 }}" 
                                                    {{ old('term_id', $request->term_id) == $term->id ? 'selected' : '' }}>
                                                    {{ $term->term_name }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                                <div class="col-md-4">
                                    <div class="mb-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 }}" 
                                                    {{ old('class_id', $request->class_id) == $class->id ? 'selected' : '' }}>
                                                    {{ $class->class_name }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                                <div class="col-md-4">
                                    <div class="mb-3">
                                        <label for="section_id" class="form-label">Section</label>
                                        <select class="form-select" id="section_id" name="section_id">
                                            <option value="">All Sections</option>
                                            @foreach($sections as $section)
                                                <option value="{{ $section->id }}" 
                                                    {{ old('section_id', $request->section_id) == $section->id ? 'selected' : '' }}>
                                                    {{ $section->sec_name }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                                <div class="col-md-4">
                                    <div class="mb-3">
                                        <label for="status" class="form-label">Status</label>
                                        <select class="form-select" id="status" name="status">
                                            <option value="">All Status</option>
                                            <option value="pending" {{ old('status', $request->status) == 'pending' ? 'selected' : '' }}>Pending</option>
                                            <option value="paid" {{ old('status', $request->status) == 'paid' ? 'selected' : '' }}>Paid</option>
                                            <option value="partially_paid" {{ old('status', $request->status) == 'partially_paid' ? 'selected' : '' }}>Partially Paid</option>
                                            <option value="overdue" {{ old('status', $request->status) == 'overdue' ? 'selected' : '' }}>Overdue</option>
                                        </select>
                                    </div>
                                </div>

                                <div class="col-md-4">
                                    <div class="mb-3">
                                        <label for="from_date" class="form-label">From Date</label>
                                        <input type="date" class="form-control" id="from_date" name="from_date" 
                                               value="{{ old('from_date', $request->from_date) }}">
                                    </div>
                                </div>

                                <div class="col-md-4">
                                    <div class="mb-3">
                                        <label for="to_date" class="form-label">To Date</label>
                                        <input type="date" class="form-control" id="to_date" name="to_date" 
                                               value="{{ old('to_date', $request->to_date) }}">
                                    </div>
                                </div>

                                <div class="col-12">
                                    <div class="text-end">
                                        <button type="submit" class="btn btn-primary" name="generate_report" value="1">
                                            <i class="fas fa-search"></i> Generate Report
                                        </button>
                                        <a href="{{ route('reports.fees') }}" class="btn btn-secondary">
                                            <i class="fas fa-refresh"></i> Clear Filters
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>

                {{-- Report Results --}}
                @if($reports->count() > 0)
                    {{-- Summary Statistics --}}
                    <div class="row mb-4">
                        <div class="col-md-3">
                            <div class="card text-center">
                                <div class="card-body">
                                    <h5 class="text-primary">{{ $summary['total_records'] }}</h5>
                                    <p class="card-text">Total Records</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card text-center">
                                <div class="card-body">
                                    <h5 class="text-info">₹{{ number_format($summary['total_fees'], 2) }}</h5>
                                    <p class="card-text">Total Fees</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card text-center">
                                <div class="card-body">
                                    <h5 class="text-success">₹{{ number_format($summary['total_paid'], 2) }}</h5>
                                    <p class="card-text">Total Paid</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card text-center">
                                <div class="card-body">
                                    <h5 class="text-danger">₹{{ number_format($summary['total_pending'], 2) }}</h5>
                                    <p class="card-text">Total Pending</p>
                                </div>
                            </div>
                        </div>
                    </div>

                    {{-- Report Table --}}
                    <div class="table-responsive">
                        <table class="table datatable" id="datatable_1">
                            <thead class="table-light">
                                <tr>
                                    <th>S.No</th>
                                    <th>Student Name</th>
                                    <th>Academic Year</th>
                                    <th>Term</th>
                                    <th>Class</th>
                                    <th>Section</th>
                                    <th>Fees Amount</th>
                                    <th>Paid Amount</th>
                                    <th>Remaining</th>
                                    <th>Status</th>
                                    <th>Due Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($reports as $report)
                                    @php
                                        $paidAmount = $report->subPayments->where('status', 'completed')->sum('amount');
                                        $remainingAmount = $report->fees_amount - $paidAmount;
                                    @endphp
                                    <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ $report->student->student_name ?? 'N/A' }}</td>
                                        <td>
                                            {{ \Carbon\Carbon::parse($report->academicYear->from_date)->format('Y') }} - 
                                            {{ \Carbon\Carbon::parse($report->academicYear->to_date)->format('Y') }}
                                        </td>
                                        <td>{{ $report->term->term_name ?? '-' }}</td>
                                        <td>{{ $report->classRoom->class_name ?? '-' }}</td>
                                        <td>{{ $report->section->sec_name ?? '-' }}</td>
                                        <td>₹{{ number_format($report->fees_amount, 2) }}</td>
                                        <td>₹{{ number_format($paidAmount, 2) }}</td>
                                        <td>₹{{ number_format($remainingAmount, 2) }}</td>
                                        <td>
                                            @switch($report->status)
                                                @case('paid')
                                                    <span class="badge bg-success">Paid</span>
                                                    @break
                                                @case('partially_paid')
                                                    <span class="badge bg-warning">Partially Paid</span>
                                                    @break
                                                @case('overdue')
                                                    <span class="badge bg-danger">Overdue</span>
                                                    @break
                                                @default
                                                    <span class="badge bg-secondary">Pending</span>
                                            @endswitch
                                        </td>
                                        <td>{{ $report->due_date ? $report->due_date->format('d-m-Y') : '-' }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>

                    {{-- Export Options --}}
                    <div class="text-end mt-3">
                        <button type="button" class="btn btn-success btn-sm" onclick="exportToExcel()">
                            <i class="fas fa-file-excel"></i> Export to Excel
                        </button>
                        <button type="button" class="btn btn-danger btn-sm" onclick="exportToPDF()">
                            <i class="fas fa-file-pdf"></i> Export to PDF
                        </button>
                    </div>

                @elseif($request->isMethod('post') || $request->has('generate_report'))
                    <div class="alert alert-info text-center">
                        <h5><i class="fas fa-info-circle"></i> No Records Found</h5>
                        <p>No fees records match your selected criteria. Please adjust your filters and try again.</p>
                    </div>
                @endif

            </div><!--end card-body-->
        </div><!--end card-->
    </div><!--end col-->
</div><!--end row-->
@endsection

@section('scripts')
<script>
function exportToExcel() {
    // Add export to Excel functionality
    alert('Excel export functionality to be implemented');
}

function exportToPDF() {
    // Add export to PDF functionality
    alert('PDF export functionality to be implemented');
}
</script>
@endsection