@extends('layouts.master')

@section('page_title', 'Student Billing Report')

@section('content')
<div class="container-fluid">
    <!-- Filter Section -->
    <div class="card mb-4 no-print">
        <div class="card-header">
            <h5 class="mb-0">Student Billing Report Filters</h5>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('reports.student-billing') }}" class="row g-3">
                <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-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="student_id" class="form-label">Student</label>
                    <select class="form-select" id="student_id" name="student_id">
                        <option value="">All Students</option>
                        @foreach($students as $student)
                            <option value="{{ $student->id }}" {{ $studentId == $student->id ? 'selected' : '' }}>
                                {{ $student->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3 d-flex align-items-end 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
                    </button>
                </div>
            </form>
        </div>
    </div>

    <!-- Report Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h2>Student Billing Report</h2>
            <p class="text-muted mb-0">
                @if($termId)
                    Term: {{ $terms->firstWhere('id', $termId)->name ?? 'Unknown' }}
                @else
                    All Terms
                @endif
            </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 Bills:</strong> {{ $studentBills->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($studentBills->sum('total_amount'), 2) }}</h3>
                            <p class="mb-0">Total Billed</p>
                        </div>
                        <div>
                            <i class="fas fa-file-invoice-dollar 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">${{ number_format($studentBills->sum('payments'), 2) }}</h3>
                            <p class="mb-0">Total Paid</p>
                        </div>
                        <div>
                            <i class="fas fa-money-check 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">${{ number_format($studentBills->sum('discounts'), 2) }}</h3>
                            <p class="mb-0">Total Discounts</p>
                        </div>
                        <div>
                            <i class="fas fa-percentage fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-danger text-white">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h3 class="mb-0">${{ number_format($studentBills->sum('total_amount') - $studentBills->sum('payments') - $studentBills->sum('discounts'), 2) }}</h3>
                            <p class="mb-0">Outstanding</p>
                        </div>
                        <div>
                            <i class="fas fa-exclamation-triangle fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Student Bills -->
    <div class="card">
        <div class="card-header">
            <h5 class="mb-0">Student Bills Breakdown</h5>
        </div>
        <div class="card-body">
            @if($studentBills->count() > 0)
                @foreach($studentBills as $bill)
                <div class="border rounded p-3 mb-4">
                    <!-- Bill Header -->
                    <div class="row align-items-center mb-3">
                        <div class="col-md-6">
                            <h6 class="mb-1"><strong>{{ $bill->student_name }}</strong></h6>
                            <p class="text-muted mb-0">
                                ID: {{ $bill->student_username }} | 
                                Class: {{ $bill->class_name }}{{ $bill->section_name ? ' - ' . $bill->section_name : '' }}
                            </p>
                        </div>
                        <div class="col-md-6 text-end">
                            <h5 class="mb-1 text-primary">${{ number_format($bill->total_amount, 2) }}</h5>
                            <p class="text-muted mb-0">Bill Total</p>
                        </div>
                    </div>

                    <!-- Bill Items Breakdown -->
                    @if($bill->items && $bill->items->count() > 0)
                    <div class="row">
                        <div class="col-md-8">
                            <h6>Bill Items:</h6>
                            <div class="table-responsive">
                                <table class="table table-sm">
                                    <thead>
                                        <tr>
                                            <th>Item</th>
                                            <th class="text-end">Amount</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach($bill->items as $item)
                                        <tr>
                                            <td>{{ $item->name }}</td>
                                            <td class="text-end">${{ number_format($item->amount, 2) }}</td>
                                        </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr class="table-light">
                                            <th>Subtotal</th>
                                            <th class="text-end">${{ number_format($bill->items->sum('amount'), 2) }}</th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <!-- Payment Summary -->
                            <div class="card">
                                <div class="card-header py-2">
                                    <h6 class="mb-0">Payment Summary</h6>
                                </div>
                                <div class="card-body py-2">
                                    <div class="d-flex justify-content-between mb-1">
                                        <span>Total Billed:</span>
                                        <span>${{ number_format($bill->total_amount, 2) }}</span>
                                    </div>
                                    <div class="d-flex justify-content-between mb-1 text-success">
                                        <span>Payments:</span>
                                        <span>-${{ number_format($bill->payments, 2) }}</span>
                                    </div>
                                    <div class="d-flex justify-content-between mb-1 text-warning">
                                        <span>Discounts:</span>
                                        <span>-${{ number_format($bill->discounts, 2) }}</span>
                                    </div>
                                    <hr class="my-2">
                                    <div class="d-flex justify-content-between">
                                        <strong>Outstanding:</strong>
                                        <strong class="{{ ($bill->total_amount - $bill->payments - $bill->discounts) > 0 ? 'text-danger' : 'text-success' }}">
                                            ${{ number_format($bill->total_amount - $bill->payments - $bill->discounts, 2) }}
                                        </strong>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    @endif
                </div>
                @endforeach
            @else
                <div class="alert alert-warning">
                    <i class="fas fa-exclamation-triangle"></i>
                    <strong>No Data Found</strong><br>
                    No student bills found for the selected criteria.
                </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>
@endsection