@extends('admin.layouts.master')

@section('title', 'Academy Analytics & Dashboard')

@push('styles')
    <link rel="stylesheet" href="{{ asset('assets/libs/apexcharts/apexcharts.css') }}">
    <style>
        .avatar-rounded {
            border-radius: 50%;
        }

        .table-icon {
            cursor: pointer;
            transition: all 0.2s;
        }

        .table-icon:hover {
            transform: translateY(-2px);
            color: var(--bs-primary);
        }

        .progress-xs {
            height: 4px;
        }

        .bg-gradient-primary {
            background: linear-gradient(135deg, #4f46e5 0%, #3730a3 100%);
        }
    </style>
@endpush

@section('content')
    <div class="d-flex align-items-center justify-content-between page-header-breadcrumb flex-wrap gap-2 mb-4">
        <div>
            <ol class="breadcrumb mb-1">
                <li class="breadcrumb-item"><a href="javascript:void(0);">Dashboards</a></li>
                <li class="breadcrumb-item active" aria-current="page">Command Center</li>
            </ol>
            <h1 class="page-title fw-bold fs-20 mb-0">Academy Command Center</h1>
        </div>
        <div class="d-flex align-items-center gap-2 flex-wrap">
            <div class="form-group">
                <div class="input-group shadow-sm">
                    <div class="input-group-text bg-white border-0"> <i class="ri-calendar-line text-muted"></i> </div>
                    <input type="text" class="form-control border-0" id="daterange" value="{{ now()->format('M Y') }}"
                        readonly>
                </div>
            </div>
            <div class="btn-list">
                <button class="btn btn-primary btn-wave shadow-sm">
                    <i class="ri-file-chart-line me-1"></i> Export Master Report
                </button>
            </div>
        </div>
    </div>
    <div class="row g-3 mb-3">
        <div class="col-xxl-3 col-xl-6 col-md-6">
            <div class="card custom-card border-0 shadow-sm overflow-hidden h-100">
                <div class="card-body">
                    <div class="d-flex align-items-start justify-content-between mb-2">
                        <div>
                            <span class="text-muted text-uppercase fs-12 fw-bold mb-1 d-block">Total Revenue</span>
                            <h3 class="fw-bolder mb-0 text-dark">₹{{ number_format($totalRevenue) }}</h3>
                        </div>
                        <div class="avatar avatar-md bg-success-transparent text-success rounded-3">
                            <i class="ri-money-rupee-circle-fill fs-4"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-xxl-3 col-xl-6 col-md-6">
            <div class="card custom-card border-0 shadow-sm overflow-hidden h-100">
                <div class="card-body">
                    <div class="d-flex align-items-start justify-content-between mb-2">
                        <div>
                            <span class="text-muted text-uppercase fs-12 fw-bold mb-1 d-block">Total Bookings</span>
                            <h3 class="fw-bolder mb-0 text-dark">{{ number_format($totalBookings) }}</h3>
                        </div>
                        <div class="avatar avatar-md bg-primary-transparent text-primary rounded-3">
                            <i class="ri-book-read-fill fs-4"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-xxl-3 col-xl-6 col-md-6">
            <div class="card custom-card border-0 shadow-sm overflow-hidden h-100">
                <div class="card-body">
                    <div class="d-flex align-items-start justify-content-between mb-2">
                        <div>
                            <span class="text-muted text-uppercase fs-12 fw-bold mb-1 d-block">Certificates Issued</span>
                            <h3 class="fw-bolder mb-0 text-dark">{{ number_format($totalCertificates) }}</h3>
                        </div>
                        <div class="avatar avatar-md bg-warning-transparent text-warning rounded-3">
                            <i class="ri-award-fill fs-4"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-xxl-3 col-xl-6 col-md-6">
            <div class="card custom-card border-0 shadow-sm overflow-hidden bg-gradient-primary text-white h-100">
                <div class="card-body pb-0">
                    <div class="d-flex align-items-start justify-content-between mb-2">
                        <div>
                            <span class="text-white opacity-75 text-uppercase fs-12 fw-bold mb-1 d-block">Active
                                Batches</span>
                            <h3 class="fw-bolder mb-0 text-white">{{ $activeBatchesCount }}</h3>
                        </div>
                        <div class="avatar avatar-md bg-white bg-opacity-25 text-white rounded-3">
                            <i class="ri-ship-2-fill fs-4 text-dark"></i>
                        </div>
                    </div>
                    <div class="mt-3 text-white opacity-75 fs-13 pb-3">
                        <span class="fw-bold text-white">{{ $studentsOnCampus }}</span> Students Confirmed
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="row g-3 mb-3">
        <div class="col-xl-8">
            <div class="card custom-card shadow-sm border-0 h-100">
                <div class="card-header justify-content-between border-bottom-0 pb-0">
                    <div class="card-title fw-bold">Revenue & Enrollment Trends ({{ now()->year }})</div>
                </div>
                <div class="card-body">
                    <div id="enrollment-revenue-chart" style="min-height: 320px;"></div>
                </div>
            </div>
        </div>

        <div class="col-xl-4">
            <div class="card custom-card shadow-sm border-0 h-100">
                <div class="card-header justify-content-between border-bottom-0 pb-0">
                    <div class="card-title fw-bold">Booking Sources</div>
                </div>
                <div class="card-body d-flex flex-column justify-content-center">
                    <div id="booking-sources-chart" class="d-flex justify-content-center mb-3"></div>

                    <ul class="list-group list-group-flush border-0 mt-2">
                        <li class="list-group-item d-flex justify-content-between align-items-center px-0 py-2 border-0">
                            <div class="d-flex align-items-center gap-2">
                                <span class="avatar avatar-xs bg-primary rounded-circle"></span>
                                <span class="fw-medium text-muted">Website</span>
                            </div>
                            <span class="fw-bold">{{ $sourcePercentages['website'] }}% <span
                                    class="text-muted fw-normal ms-1">({{ $sources['website'] }})</span></span>
                        </li>
                        <li class="list-group-item d-flex justify-content-between align-items-center px-0 py-2 border-0">
                            <div class="d-flex align-items-center gap-2">
                                <span class="avatar avatar-xs bg-info rounded-circle"></span>
                                <span class="fw-medium text-muted">Mobile App</span>
                            </div>
                            <span class="fw-bold">{{ $sourcePercentages['app'] }}% <span
                                    class="text-muted fw-normal ms-1">({{ $sources['app'] }})</span></span>
                        </li>
                        <li class="list-group-item d-flex justify-content-between align-items-center px-0 py-2 border-0">
                            <div class="d-flex align-items-center gap-2">
                                <span class="avatar avatar-xs bg-warning rounded-circle"></span>
                                <span class="fw-medium text-muted">Corporate/Agents</span>
                            </div>
                            <span class="fw-bold">{{ $sourcePercentages['corporate'] }}% <span
                                    class="text-muted fw-normal ms-1">({{ $sources['corporate'] }})</span></span>
                        </li>
                        <li class="list-group-item d-flex justify-content-between align-items-center px-0 py-2 border-0">
                            <div class="d-flex align-items-center gap-2">
                                <span class="avatar avatar-xs bg-danger rounded-circle"></span>
                                <span class="fw-medium text-muted">Walk-in/Manual</span>
                            </div>
                            <span class="fw-bold">{{ $sourcePercentages['manual'] }}% <span
                                    class="text-muted fw-normal ms-1">({{ $sources['manual'] }})</span></span>
                        </li>
                    </ul>
                </div>
            </div>
        </div>
    </div>

    <div class="row g-3 mb-3">
        <div class="col-xl-4 col-md-6">
            <div class="card custom-card shadow-sm border-0 h-100">
                <div class="card-header border-bottom border-light">
                    <div class="card-title fw-bold">Payment Collection Status</div>
                </div>
                <div class="card-body">
                    <div class="mb-4">
                        <div class="d-flex justify-content-between align-items-end mb-2">
                            <div>
                                <span class="d-block fs-13 text-muted mb-1">Fully Paid</span>
                                <h5 class="fw-bold mb-0">₹{{ number_format($financials['paid_amount']) }}</h5>
                            </div>
                            <span class="badge bg-success-transparent text-success">{{ $financials['paid_perc'] }}%</span>
                        </div>
                        <div class="progress progress-sm">
                            <div class="progress-bar bg-success" style="width: {{ $financials['paid_perc'] }}%"></div>
                        </div>
                    </div>

                    <div class="mb-4">
                        <div class="d-flex justify-content-between align-items-end mb-2">
                            <div>
                                <span class="d-block fs-13 text-muted mb-1">Partial (EMI Active)</span>
                                <h5 class="fw-bold mb-0">₹{{ number_format($financials['partial_amount']) }}</h5>
                            </div>
                            <span class="badge bg-info-transparent text-info">{{ $financials['partial_perc'] }}%</span>
                        </div>
                        <div class="progress progress-sm">
                            <div class="progress-bar bg-info" style="width: {{ $financials['partial_perc'] }}%"></div>
                        </div>
                    </div>

                    <div>
                        <div class="d-flex justify-content-between align-items-end mb-2">
                            <div>
                                <span class="d-block fs-13 text-muted mb-1">Pending Dues</span>
                                <h5 class="fw-bold mb-0 text-danger">₹{{ number_format($financials['pending_amount']) }}
                                </h5>
                            </div>
                            <span
                                class="badge bg-danger-transparent text-danger">{{ $financials['pending_perc'] }}%</span>
                        </div>
                        <div class="progress progress-sm">
                            <div class="progress-bar bg-danger" style="width: {{ $financials['pending_perc'] }}%"></div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-4 col-md-6">
            <div class="card custom-card shadow-sm border-0 h-100">
                <div class="card-header justify-content-between border-bottom border-light">
                    <div class="card-title fw-bold">Document Verification Queue</div>
                    <span class="badge bg-danger rounded-pill">{{ $pendingDocsCount }} Pending</span>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-hover text-nowrap mb-0 border-0">
                            <tbody>
                                @forelse($pendingDocs as $doc)
                                    <tr>
                                        <td class="ps-3 border-0 border-bottom border-light">
                                            <div class="d-flex align-items-center gap-2">
                                                <span class="avatar avatar-sm rounded-circle">
                                                    <img src="{{ $doc->student->avatar_url ?? 'https://ui-avatars.com/api/?name=' . urlencode($doc->student->name) }}"
                                                        alt="">
                                                </span>
                                                <div><span
                                                        class="d-block fw-bold text-dark fs-13">{{ $doc->student->name ?? 'Unknown' }}</span>
                                                </div>
                                            </div>
                                        </td>
                                        <td class="border-0 border-bottom border-light">
                                            <span class="badge bg-warning-subtle text-warning">
                                                <i class="ri-file-text-line"></i> {{ $doc->document_name }}
                                            </span>
                                        </td>
                                        <td class="pe-3 text-end border-0 border-bottom border-light">
                                            <button class="btn btn-xs btn-primary">Verify</button>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="3" class="text-center p-4 text-muted border-0">All documents are
                                            verified! 🎉</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-4 col-md-12">
            <div class="card custom-card shadow-sm border-0 h-100">
                <div class="card-header border-bottom border-light justify-content-between">
                    <div class="card-title fw-bold">Upcoming Batches & Occupancy</div>
                    <a href="#" class="btn btn-sm btn-light text-primary fw-medium">View All</a>
                </div>
                <div class="card-body p-0">
                    <ul class="list-group list-group-flush border-0">
                        @forelse($upcomingBatches as $batch)
                            <li
                                class="list-group-item p-3 border-0 border-bottom border-light d-flex justify-content-between align-items-center">
                                <div>
                                    <h6 class="fw-bold mb-1 text-dark">{{ $batch->course->name ?? 'Course' }} <span
                                            class="badge bg-light text-dark border ms-2">{{ $batch->batch_code }}</span>
                                    </h6>
                                    <span class="fs-12 text-muted">
                                        <i class="ri-calendar-line me-1"></i> {{ $batch->start_date->format('d M, Y') }}
                                        @if ($batch->instructor)
                                            &nbsp;|&nbsp; <i class="ri-user-star-line me-1"></i>
                                            {{ $batch->instructor->name }}
                                        @endif
                                    </span>
                                </div>
                                <div class="text-end" style="min-width: 80px;">
                                    <span
                                        class="d-block fw-bold {{ $batch->percent_full > 80 ? 'text-danger' : 'text-success' }} mb-1">
                                        {{ $batch->booked_seats }} / {{ $batch->total_seats }}
                                    </span>
                                    <div class="progress progress-sm" style="height: 6px;">
                                        <div class="progress-bar {{ $batch->percent_full > 80 ? 'bg-danger' : 'bg-success' }}"
                                            style="width: {{ $batch->percent_full }}%"></div>
                                    </div>
                                </div>
                            </li>
                        @empty
                            <li class="list-group-item border-0 p-4 text-center text-muted">No upcoming batches found.</li>
                        @endforelse
                    </ul>
                </div>
            </div>
        </div>
    </div>

    <div class="row">
        <div class="col-xl-12">
            <div class="card custom-card shadow-sm border-0">
                <div class="card-header justify-content-between border-bottom border-light py-3">
                    <div class="card-title fw-bold">Recent Booking Ledger</div>
                    <div class="d-flex gap-2">
                        <button class="btn btn-sm btn-primary fw-medium text-nowrap"><i class="ri-add-line me-1"></i> New
                            Booking</button>
                    </div>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-hover align-middle text-nowrap mb-0">
                            <thead class="bg-light text-muted fs-12 text-uppercase">
                                <tr>
                                    <th class="ps-4">Booking ID & Date</th>
                                    <th>Student Details</th>
                                    <th>Course / Package</th>
                                    <th>Source</th>
                                    <th>Total Amount</th>
                                    <th>Payment Status</th>
                                </tr>
                            </thead>
                            <tbody class="border-top-0">
                                @forelse($recentBookings as $booking)
                                    <tr>
                                        <td class="ps-4">
                                            <span class="fw-bold text-primary d-block">{{ $booking->booking_code }}</span>
                                            <span
                                                class="text-muted fs-11">{{ $booking->created_at->format('M d, h:i A') }}</span>
                                        </td>
                                        <td>
                                            <div class="d-flex flex-column">
                                                <span
                                                    class="fw-bold text-dark fs-13">{{ $booking->student->name ?? 'Unknown Student' }}</span>
                                                <span class="fs-11 text-muted">INDoS:
                                                    {{ $booking->student->indos_no ?? 'N/A' }}</span>
                                            </div>
                                        </td>
                                        <td>
                                            <div class="d-flex flex-column">
                                                <span
                                                    class="fw-bold text-dark fs-13">{{ $booking->course->name ?? 'Package/Multiple' }}</span>
                                                @if ($booking->courseBatch)
                                                    <span
                                                        class="fs-11 text-primary">{{ $booking->courseBatch->batch_code }}</span>
                                                @endif
                                            </div>
                                        </td>
                                        <td>
                                            <span class="badge bg-light text-dark border text-capitalize">
                                                <i class="ri-link-m text-primary me-1"></i> {{ $booking->source }}
                                            </span>
                                        </td>
                                        <td>
                                            <div class="d-flex flex-column">
                                                <span
                                                    class="fw-bolder text-dark">₹{{ number_format($booking->total_amount) }}</span>
                                                @if ($booking->payment_status === 'partial')
                                                    <span
                                                        class="fs-11 text-success">₹{{ number_format($booking->paid_amount) }}
                                                        Paid</span>
                                                @endif
                                            </div>
                                        </td>
                                        <td>
                                            <span
                                                class="badge bg-{{ $booking->payment_status_badge }}-transparent text-{{ $booking->payment_status_badge }} border border-{{ $booking->payment_status_badge }}-subtle px-2 text-capitalize">
                                                {{ $booking->payment_status }}
                                            </span>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="6" class="text-center p-4">No recent bookings found.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('scripts')
    <script src="{{ asset('assets/libs/apexcharts/apexcharts.min.js') }}"></script>
    <script>
        document.addEventListener("DOMContentLoaded", function() {

            // 1. Revenue & Enrollment Area Chart
            if (document.getElementById('enrollment-revenue-chart')) {
                var revenueOptions = {
                    series: [{
                        name: 'Revenue (₹)',
                        type: 'area',
                        data: @json($revenueData)
                    }, {
                        name: 'Enrollments',
                        type: 'line',
                        data: @json($enrollmentData)
                    }],
                    chart: {
                        height: 320,
                        type: 'line',
                        toolbar: {
                            show: false
                        },
                        fontFamily: 'inherit'
                    },
                    stroke: {
                        width: [0, 3],
                        curve: 'smooth'
                    },
                    colors: ['#4f46e5', '#ffb703'],
                    fill: {
                        type: ['gradient', 'solid'],
                        gradient: {
                            shadeIntensity: 1,
                            opacityFrom: 0.3,
                            opacityTo: 0.05,
                            stops: [0, 90, 100]
                        }
                    },
                    dataLabels: {
                        enabled: false
                    },
                    labels: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov',
                        'Dec'
                    ],
                    yaxis: [{
                            title: {
                                text: 'Revenue (₹)'
                            },
                            labels: {
                                formatter: function(value) {
                                    return "₹" + (value / 100000).toFixed(1) + "L";
                                }
                            }
                        },
                        {
                            opposite: true,
                            title: {
                                text: 'Total Enrollments'
                            }
                        }
                    ],
                    legend: {
                        position: 'top',
                        horizontalAlign: 'right'
                    },
                    grid: {
                        borderColor: '#f1f5f9',
                        strokeDashArray: 4
                    }
                };

                var revChart = new ApexCharts(document.querySelector("#enrollment-revenue-chart"), revenueOptions);
                revChart.render();
            }

            // 2. Booking Sources Donut Chart
            if (document.getElementById('booking-sources-chart')) {
                var sourceOptions = {
                    series: [
                        {{ $sourcePercentages['website'] }},
                        {{ $sourcePercentages['app'] }},
                        {{ $sourcePercentages['corporate'] }},
                        {{ $sourcePercentages['manual'] }}
                    ],
                    labels: ['Website', 'Mobile App', 'Corporate/Agents', 'Manual/Walk-in'],
                    chart: {
                        type: 'donut',
                        height: 240,
                        fontFamily: 'inherit'
                    },
                    colors: ['#4f46e5', '#0dcaf0', '#ffc107', '#dc3545'],
                    plotOptions: {
                        pie: {
                            donut: {
                                size: '70%',
                                labels: {
                                    show: true,
                                    name: {
                                        show: true,
                                        fontSize: '12px',
                                        color: '#64748b'
                                    },
                                    value: {
                                        show: true,
                                        fontSize: '20px',
                                        fontWeight: 700,
                                        color: '#0f172a',
                                        formatter: function(val) {
                                            return val + "%"
                                        }
                                    },
                                    total: {
                                        show: true,
                                        showAlways: true,
                                        label: 'Website',
                                        fontSize: '12px',
                                        fontWeight: 500,
                                        color: '#64748b',
                                        formatter: function(w) {
                                            return w.globals.seriesTotals[0] + "%"
                                        }
                                    }
                                }
                            }
                        }
                    },
                    dataLabels: {
                        enabled: false
                    },
                    legend: {
                        show: false
                    },
                    stroke: {
                        show: false
                    }
                };

                var sourceChart = new ApexCharts(document.querySelector("#booking-sources-chart"), sourceOptions);
                sourceChart.render();
            }
        });
    </script>
@endpush