@extends('admin.layouts.app')

@section('content')

@php
    use Illuminate\Support\Facades\DB;
    use Illuminate\Support\Facades\Schema;

    $totalUsersValue = class_exists(\App\Models\User::class) ? \App\Models\User::count() : 0;
    $totalMoviesValue = class_exists(\App\Models\Movie::class) ? \App\Models\Movie::count() : 0;

    $activeSubsValue = 0;
    if (Schema::hasTable('subscriptions')) {
        try {
            if (Schema::hasColumn('subscriptions', 'status')) {
                $activeSubsValue = DB::table('subscriptions')
                    ->whereIn('status', ['active', 'ACTIVE', 'Active'])
                    ->count();
            } elseif (Schema::hasColumn('subscriptions', 'is_active')) {
                $activeSubsValue = DB::table('subscriptions')->where('is_active', 1)->count();
            } else {
                $activeSubsValue = DB::table('subscriptions')->count();
            }
        } catch (\Throwable $e) {
            $activeSubsValue = 0;
        }
    } elseif (Schema::hasTable('user_subscriptions')) {
        try {
            if (Schema::hasColumn('user_subscriptions', 'status')) {
                $activeSubsValue = DB::table('user_subscriptions')
                    ->whereIn('status', ['active', 'ACTIVE', 'Active'])
                    ->count();
            } elseif (Schema::hasColumn('user_subscriptions', 'is_active')) {
                $activeSubsValue = DB::table('user_subscriptions')->where('is_active', 1)->count();
            } else {
                $activeSubsValue = DB::table('user_subscriptions')->count();
            }
        } catch (\Throwable $e) {
            $activeSubsValue = 0;
        }
    }

    $monthlyRevenueValue = 0;
    $weeklyRevenueValue = 0;

    foreach (['transactions', 'payments'] as $table) {
        if (!Schema::hasTable($table)) {
            continue;
        }

        try {
            $monthlyQuery = DB::table($table);
            $weeklyQuery = DB::table($table);

            if (Schema::hasColumn($table, 'status')) {
                $statuses = ['success', 'successful', 'paid', 'completed', 'SUCCESS'];
                $monthlyQuery->whereIn('status', $statuses);
                $weeklyQuery->whereIn('status', $statuses);
            }

            if (Schema::hasColumn($table, 'created_at')) {
                $monthlyQuery->whereBetween('created_at', [now()->startOfMonth(), now()->endOfMonth()]);
                $weeklyQuery->whereBetween('created_at', [now()->startOfWeek(), now()->endOfWeek()]);
            }

            if (Schema::hasColumn($table, 'amount')) {
                $monthlyRevenueValue = (float) $monthlyQuery->sum('amount');
                $weeklyRevenueValue = (float) $weeklyQuery->sum('amount');
                break;
            }
        } catch (\Throwable $e) {
            $monthlyRevenueValue = 0;
            $weeklyRevenueValue = 0;
        }
    }

    $recentTransactions = collect();
    foreach (['transactions', 'payments'] as $table) {
        if (!Schema::hasTable($table)) {
            continue;
        }

        try {
            $query = DB::table($table);

            if (Schema::hasColumn($table, 'created_at')) {
                $query->orderByDesc('created_at');
            } elseif (Schema::hasColumn($table, 'id')) {
                $query->orderByDesc('id');
            }

            $recentTransactions = $query->limit(8)->get();
            break;
        } catch (\Throwable $e) {
            $recentTransactions = collect();
        }
    }

    $latestUsers = class_exists(\App\Models\User::class)
        ? \App\Models\User::latest()->take(8)->get()
        : collect();

    $weeklyChartLabels = ['This Week'];
    $weeklyChartData = [$weeklyRevenueValue];
@endphp

<div class="mt-6 space-y-10">

    <div class="flex flex-col md:flex-row md:justify-between md:items-center gap-4">
        <div>
            <h1 class="text-2xl font-bold">Admin Dashboard</h1>
            <p class="text-sm text-gray-400 mt-1">
                Live platform overview for users, content, subscriptions, and revenue.
            </p>
        </div>

        <a href="{{ route('admin.movies.create') }}"
           class="inline-flex items-center justify-center bg-red-600 hover:bg-red-700 px-5 py-2.5 rounded-xl font-semibold transition shadow-lg shadow-red-900/20">
            + Add New Movie
        </a>
    </div>

    <div class="grid grid-cols-1 sm:grid-cols-2 xl:grid-cols-4 gap-6">

        <div class="bg-gray-800 p-6 rounded-2xl shadow-lg">
    <h3 class="text-gray-400 text-sm uppercase">Total Users</h3>
    <p class="text-3xl font-bold mt-2">{{ \App\Models\User::count() }}</p>
</div>

<div class="bg-gray-800 p-6 rounded-2xl shadow-lg">
    <h3 class="text-gray-400 text-sm uppercase">Total Movies</h3>
    <p class="text-3xl font-bold mt-2">{{ \App\Models\Movie::count() }}</p>
</div>

<div class="bg-gray-800 p-6 rounded-2xl shadow-lg">
    <h3 class="text-gray-400 text-sm uppercase">Active Subs</h3>
    <p class="text-3xl font-bold mt-2">{{ $activeSubscriptions ?? 0 }}</p>
</div>

<div class="bg-gray-800 p-6 rounded-2xl shadow-lg">
    <h3 class="text-gray-400 text-sm uppercase">Monthly Revenue</h3>
    <p class="text-3xl font-bold mt-2">
        GH₵{{ number_format($monthlyRevenue ?? 0, 2) }}
    </p>
</div>

    </div>

    <div class="grid grid-cols-1 xl:grid-cols-2 gap-6">

        <div class="bg-gray-900 p-6 rounded-2xl shadow-lg border border-white/5">
            <div class="flex items-center justify-between gap-4 mb-4">
                <div>
                    <h2 class="text-lg font-semibold">Monthly Revenue</h2>
                    <p class="text-sm text-gray-400">Current month earnings snapshot</p>
                </div>
                <div class="text-right">
                    <p class="text-xs uppercase tracking-wide text-gray-500">Total</p>
                    <p class="text-xl font-bold text-white">GH₵{{ number_format((float) $monthlyRevenueValue, 2) }}</p>
                </div>
            </div>
            <canvas id="monthlyChart"></canvas>
        </div>

        <div class="bg-gray-900 p-6 rounded-2xl shadow-lg border border-white/5">
            <div class="flex items-center justify-between gap-4 mb-4">
                <div>
                    <h2 class="text-lg font-semibold">Weekly Revenue</h2>
                    <p class="text-sm text-gray-400">Track income flow across the week</p>
                </div>
                <div class="text-right">
                    <p class="text-xs uppercase tracking-wide text-gray-500">This Week</p>
                    <p class="text-xl font-bold text-white">GH₵{{ number_format((float) $weeklyRevenueValue, 2) }}</p>
                </div>
            </div>
            <canvas id="weeklyChart"></canvas>
        </div>

    </div>

    <div class="grid grid-cols-1 xl:grid-cols-2 gap-6">

        <div class="bg-gray-900 p-6 rounded-2xl shadow-lg border border-white/5">
            <div class="flex items-center justify-between gap-4 mb-4">
                <div>
                    <h2 class="text-lg font-semibold">Recent Transactions</h2>
                    <p class="text-sm text-gray-400">Latest payment activity on the platform</p>
                </div>
            </div>

            <div class="overflow-x-auto">
                <table class="w-full text-left text-sm">
                    <thead class="text-gray-400 border-b border-gray-700">
                        <tr>
                            <th class="py-3 pr-4">User</th>
                            <th class="py-3 pr-4">Amount</th>
                            <th class="py-3">Status</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($recentTransactions as $transaction)
                            @php
                                $transactionUserName =
                                    $transaction->user_name
                                    ?? $transaction->name
                                    ?? $transaction->email
                                    ?? 'N/A';

                                $transactionStatus = strtolower((string)($transaction->status ?? 'pending'));
                            @endphp

                            <tr class="border-b border-gray-800">
                                <td class="py-3 pr-4">
                                    <div class="font-medium text-white">{{ $transactionUserName }}</div>
                                    @if(!empty($transaction->email))
                                        <div class="text-xs text-gray-500">{{ $transaction->email }}</div>
                                    @endif
                                </td>

                                <td class="py-3 pr-4 font-semibold text-white">
                                    GH₵{{ number_format((float)($transaction->amount ?? 0), 2) }}
                                </td>

                                <td class="py-3">
                                    <span class="px-2.5 py-1 rounded-lg text-xs font-semibold
                                        @if(in_array($transactionStatus, ['success', 'successful', 'paid', 'completed']))
                                            bg-green-600 text-white
                                        @elseif(in_array($transactionStatus, ['failed', 'cancelled', 'canceled']))
                                            bg-red-600 text-white
                                        @else
                                            bg-yellow-600 text-white
                                        @endif
                                    ">
                                        {{ ucfirst($transaction->status ?? 'pending') }}
                                    </span>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="3" class="py-6 text-center text-gray-500">
                                    No transactions found
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>

        <div class="bg-gray-900 p-6 rounded-2xl shadow-lg border border-white/5">
            <div class="flex items-center justify-between gap-4 mb-4">
                <div>
                    <h2 class="text-lg font-semibold">Latest Users</h2>
                    <p class="text-sm text-gray-400">Most recently registered accounts</p>
                </div>
            </div>

            <ul class="space-y-3">
                @forelse($latestUsers as $user)
                    <li class="flex justify-between items-center border-b border-gray-800 pb-3 gap-4">
                        <div class="min-w-0">
                            <p class="font-semibold truncate">{{ $user->name ?? 'User' }}</p>
                            <p class="text-gray-400 text-xs truncate">{{ $user->email ?? 'No email' }}</p>
                        </div>

                        <span class="text-xs text-gray-500 whitespace-nowrap">
                            @if(!empty($user->created_at))
                                {{ $user->created_at->diffForHumans() }}
                            @endif
                        </span>
                    </li>
                @empty
                    <li class="text-gray-500 text-sm">
                        No users found
                    </li>
                @endforelse
            </ul>
        </div>

    </div>

</div>

@endsection

@push('scripts')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
document.addEventListener('DOMContentLoaded', function () {

    document.querySelectorAll('.counter').forEach(counter => {
        let target = parseInt(counter.dataset.target) || 0;
        let count = 0;
        let duration = 800;
        let steps = 60;
        let increment = target / steps;
        let currentStep = 0;

        function updateCounter() {
            currentStep++;
            count += increment;

            if (currentStep < steps) {
                counter.innerText = Math.ceil(count).toLocaleString();
                requestAnimationFrame(updateCounter);
            } else {
                counter.innerText = target.toLocaleString();
            }
        }

        if (target > 0) {
            updateCounter();
        } else {
            counter.innerText = '0';
        }
    });

    const monthlyCtx = document.getElementById('monthlyChart');
    if (monthlyCtx) {
        new Chart(monthlyCtx, {
            type: 'bar',
            data: {
                labels: ['This Month'],
                datasets: [{
                    label: 'Revenue (GH₵)',
                    data: [{{ (float) $monthlyRevenueValue }}],
                    backgroundColor: '#e50914',
                    borderRadius: 10,
                    maxBarThickness: 90
                }]
            },
            options: {
                responsive: true,
                plugins: {
                    legend: { display: false }
                },
                scales: {
                    x: {
                        ticks: { color: '#9ca3af' },
                        grid: { display: false }
                    },
                    y: {
                        ticks: { color: '#9ca3af' },
                        grid: { color: 'rgba(255,255,255,0.06)' }
                    }
                }
            }
        });
    }

    const weeklyCtx = document.getElementById('weeklyChart');
    if (weeklyCtx) {
        new Chart(weeklyCtx, {
            type: 'line',
            data: {
                labels: {!! json_encode($weeklyChartLabels) !!},
                datasets: [{
                    label: 'Weekly Revenue',
                    data: {!! json_encode($weeklyChartData) !!},
                    borderColor: '#e50914',
                    backgroundColor: 'rgba(229, 9, 20, 0.08)',
                    fill: true,
                    tension: 0.4,
                    pointBackgroundColor: '#e50914',
                    pointBorderColor: '#e50914',
                    pointRadius: 4
                }]
            },
            options: {
                responsive: true,
                plugins: {
                    legend: { display: false }
                },
                scales: {
                    x: {
                        ticks: { color: '#9ca3af' },
                        grid: { display: false }
                    },
                    y: {
                        ticks: { color: '#9ca3af' },
                        grid: { color: 'rgba(255,255,255,0.06)' }
                    }
                }
            }
        });
    }

});
</script>
@endpush