import { NextResponse } from "next/server";
import { getCurrentUser } from "@/lib/auth";
import { prisma } from "@/lib/prisma";
import { Prisma } from "@prisma/client";

export async function GET(request: Request) {
    try {
        const currentUser = await getCurrentUser();
        // Check admin permissions
        if (!currentUser || currentUser.role !== 'admin') {
            return NextResponse.json({ error: "Unauthorized" }, { status: 401 });
        }

        const { searchParams } = new URL(request.url);
        const page = parseInt(searchParams.get('page') || '1');
        const limit = parseInt(searchParams.get('limit') || '10');
        const search = searchParams.get('search') || '';
        const sort = searchParams.get('sort') || 'urgent';
        const dateRange = searchParams.get('dateRange') || 'all';
        const workType = searchParams.get('workType') || 'all';
        const employerStatus = searchParams.get('employerStatus') || 'all';
        const urgentOnly = searchParams.get('urgentOnly') === 'true';

        // We assume "pending" status for jobs awaiting moderation
        const where: Prisma.JobWhereInput = {
            status: 'pending',
            deleted_at: null // Exclude soft-deleted jobs
        };

        if (urgentOnly) {
            const twentyFourHoursAgo = new Date(Date.now() - 24 * 60 * 60 * 1000);
            where.posted_at = { lt: twentyFourHoursAgo };
        }

        if (workType !== 'all') {
            where.work_location_type = workType;
        }

        if (employerStatus !== 'all') {
            where.employer = {
                is_active: employerStatus === 'active'
            };
        }

        if (dateRange !== 'all') {
            const now = new Date();
            let gteDate = new Date();
            if (dateRange === 'today') gteDate.setHours(0, 0, 0, 0);
            if (dateRange === 'week') gteDate.setDate(now.getDate() - 7);
            if (dateRange === 'month') gteDate.setMonth(now.getMonth() - 1);

            where.posted_at = {
                ...((where.posted_at as any) || {}),
                gte: gteDate
            };
        }

        if (search) {
            where.OR = [
                { title: { contains: search, mode: 'insensitive' } },
                { company: { contains: search, mode: 'insensitive' } },
            ];
        }

        // Sorting Logic
        let orderBy: Prisma.JobOrderByWithRelationInput = { posted_at: 'asc' }; // default urgent = oldest first

        if (sort === 'newest') {
            orderBy = { posted_at: 'desc' };
        } else if (sort === 'oldest') {
            orderBy = { posted_at: 'asc' };
        } else if (sort === 'companyAsc') {
            orderBy = { company: 'asc' };
        } else if (sort === 'salaryHigh') {
            orderBy = { salary_max: { sort: 'desc', nulls: 'last' } as any };
        } else if (sort === 'salaryLow') {
            orderBy = { salary_min: { sort: 'asc', nulls: 'last' } as any };
        }

        const skip = (page - 1) * limit;

        const [jobs, total] = await Promise.all([
            prisma.job.findMany({
                where,
                include: {
                    employer: {
                        select: {
                            id: true,
                            name: true,
                            email: true,
                            is_active: true,
                            avatar_url: true,
                        }
                    }
                },
                orderBy,
                skip,
                take: limit,
            }),
            prisma.job.count({ where })
        ]);

        return NextResponse.json({
            data: jobs,
            meta: {
                total,
                page,
                limit,
                totalPages: Math.ceil(total / limit)
            }
        });
    } catch (error: any) {
        console.error("Error fetching moderation queue:", error);
        return NextResponse.json(
            { error: "Internal server error", details: error.message },
            { status: 500 }
        );
    }
}
