@extends('layouts.master')

@section('page_title', 'Accounts Receivable Report')

@section('content')
<div class="container-fluid">
    <!-- Filter Section -->
    <div class="card mb-4 no-print">
        <div class="card-header">
            <h5 class="mb-0">Accounts Receivable Filters</h5>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('reports.accounts-receivable') }}" class="row g-3">
                <div class="col-md-3">
                    <label for="as_of_date" class="form-label">As of Date</label>
                    <input type="date" class="form-control" id="as_of_date" name="as_of_date" 
                           value="{{ $asOfDate }}" 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="aging_days" class="form-label">Aging Period (Days)</label>
                    <select class="form-select" id="aging_days" name="aging_days">
                        <option value="30" {{ $agingDays == 30 ? 'selected' : '' }}>30 Days</option>
                        <option value="60" {{ $agingDays == 60 ? 'selected' : '' }}>60 Days</option>
                        <option value="90" {{ $agingDays == 90 ? 'selected' : '' }}>90 Days</option>
                    </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>Accounts Receivable Report</h2>
            <p class="text-muted mb-0">As of: {{ Carbon\Carbon::parse($asOfDate)->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>Outstanding Bills:</strong> {{ $receivables->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($receivables->sum('outstanding_amount'), 2) }}</h3>
                            <p class="mb-0">Total Outstanding</p>
                        </div>
                        <div>
                            <i class="fas fa-exclamation-circle 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">{{ $agingSummary['Current']['count'] ?? 0 }}</h3>
                            <p class="mb-0">Current (0-30 days)</p>
                        </div>
                        <div>
                            <i class="fas fa-check-circle 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">{{ ($agingSummary['31-60 Days']['count'] ?? 0) + ($agingSummary['61-90 Days']['count'] ?? 0) }}</h3>
                            <p class="mb-0">31-90 Days</p>
                        </div>
                        <div>
                            <i class="fas fa-clock 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">{{ $agingSummary['Over 90 Days']['count'] ?? 0 }}</h3>
                            <p class="mb-0">Over 90 Days</p>
                        </div>
                        <div>
                            <i class="fas fa-times-circle fa-2x opacity-75"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Aging Summary -->
    <div class="card mb-4">
        <div class="card-header">
            <h5 class="mb-0">Aging Summary</h5>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-striped">
                    <thead>
                        <tr>
                            <th>Aging Category</th>
                            <th class="text-center">Number of Bills</th>
                            <th class="text-end">Outstanding Amount</th>
                            <th class="text-end">Percentage</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php $totalOutstanding = $receivables->sum('outstanding_amount'); @endphp
                        @foreach(['Current', '31-60 Days', '61-90 Days', 'Over 90 Days'] as $category)
                        @php 
                            $count = $agingSummary[$category]['count'] ?? 0;
                            $amount = $agingSummary[$category]['total'] ?? 0;
                            $percentage = $totalOutstanding > 0 ? ($amount / $totalOutstanding) * 100 : 0;
                        @endphp
                        <tr class="{{ $category == 'Over 90 Days' ? 'table-danger' : ($category == 'Current' ? 'table-success' : 'table-warning') }}">
                            <td><strong>{{ $category }}</strong></td>
                            <td class="text-center">{{ $count }}</td>
                            <td class="text-end">${{ number_format($amount, 2) }}</td>
                            <td class="text-end">{{ number_format($percentage, 1) }}%</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr class="table-primary">
                            <th>Total</th>
                            <th class="text-center">{{ $receivables->count() }}</th>
                            <th class="text-end">${{ number_format($totalOutstanding, 2) }}</th>
                            <th class="text-end">100.0%</th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>

    <!-- Detailed Receivables -->
    <div class="card">
        <div class="card-header">
            <h5 class="mb-0">Outstanding Receivables Detail</h5>
        </div>
        <div class="card-body">
            @if($receivables->count() > 0)
                <div class="table-responsive">
                    <table class="table table-striped table-hover" id="receivablesTable">
                        <thead>
                            <tr>
                                <th>Student ID</th>
                                <th>Student Name</th>
                                <th>Class</th>
                                <th>Term</th>
                                <th class="text-end">Bill Amount</th>
                                <th class="text-end">Payments</th>
                                <th class="text-end">Discounts</th>
                                <th class="text-end">Outstanding</th>
                                <th class="text-center">Days</th>
                                <th>Aging</th>
                                <th>Bill Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($receivables->sortBy('aging_category') as $receivable)
                            <tr class="{{ $receivable->aging_category == 'Over 90 Days' ? 'table-danger' : ($receivable->aging_category == 'Current' ? '' : 'table-warning') }}">
                                <td><code>{{ $receivable->student_username }}</code></td>
                                <td>{{ $receivable->student_name }}</td>
                                <td><span class="badge bg-primary">{{ $receivable->class_name }}</span></td>
                                <td>{{ $receivable->term_name ?? 'N/A' }}</td>
                                <td class="text-end">${{ number_format($receivable->total_amount, 2) }}</td>
                                <td class="text-end text-success">${{ number_format($receivable->payments_received, 2) }}</td>
                                <td class="text-end text-warning">${{ number_format($receivable->discounts_applied, 2) }}</td>
                                <td class="text-end">
                                    <strong class="text-danger">${{ number_format($receivable->outstanding_amount, 2) }}</strong>
                                </td>
                                <td class="text-center">
                                    <span class="badge bg-{{ $receivable->days_outstanding > 90 ? 'danger' : ($receivable->days_outstanding > 30 ? 'warning' : 'success') }}">
                                        {{ $receivable->days_outstanding }}
                                    </span>
                                </td>
                                <td>
                                    <span class="badge bg-{{ $receivable->aging_category == 'Over 90 Days' ? 'danger' : ($receivable->aging_category == 'Current' ? 'success' : 'warning') }}">
                                        {{ $receivable->aging_category }}
                                    </span>
                                </td>
                                <td>{{ Carbon\Carbon::parse($receivable->bill_date)->format('M d, Y') }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr class="table-primary">
                                <th colspan="7">Grand Total</th>
                                <th class="text-end">${{ number_format($receivables->sum('outstanding_amount'), 2) }}</th>
                                <th colspan="3"></th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            @else
                <div class="alert alert-success">
                    <i class="fas fa-check-circle"></i>
                    <strong>Excellent News!</strong><br>
                    No outstanding receivables found. All bills have been paid in full!
                </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