import prisma from '@/lib/prisma';

export class ApplicationService {
    static async applyToJob(data: {
        jobId: string;
        candidateId: string;
        coverLetter?: string;
        cvLink?: string;
        yearsOfExperience?: number;
    }) {
        return prisma.application.create({
            data: {
                job_id: data.jobId,
                candidate_id: data.candidateId,
                cover_letter: data.coverLetter,
                cv_link: data.cvLink,
                years_of_experience: data.yearsOfExperience,
            }
        });
    }

    static async getApplicationsForCandidate(candidateId: string) {
        const apps = await prisma.application.findMany({
            where: { candidate_id: candidateId },
            include: {
                job: {
                    include: {
                        skills: { include: { skill: true } }
                    }
                }
            },
            orderBy: { applied_at: 'desc' }
        });

        return apps.map(app => ({
            id: app.id,
            jobId: app.job_id,
            candidateId: app.candidate_id,
            status: app.status as 'pending' | 'reviewing' | 'interview' | 'rejected' | 'accepted' | 'withdrawn',
            appliedAt: app.applied_at.toISOString(),
            updatedAt: app.updated_at.toISOString(),
            coverLetter: app.cover_letter,
            resumeUrl: app.resume_url,
            cvLink: app.cv_link,
            notes: app.notes,
            job: {
                id: app.job.id,
                title: app.job.title,
                company: app.job.company,
                location: [app.job.city, app.job.state, app.job.country].filter(Boolean).join(", ") || app.job.work_location_type || "Remote",
                type: app.job.type,
            }
        }));
    }

    static async getApplicationsForJob(jobId: string) {
        const apps = await prisma.application.findMany({
            where: { job_id: jobId },
            include: {
                candidate: {
                    include: {
                        profile: true,
                        skills: { include: { skill: true } }
                    }
                }
            },
            orderBy: { applied_at: 'desc' }
        });

        return apps.map(app => ({
            id: app.id,
            jobId: app.job_id,
            candidateId: app.candidate_id,
            status: app.status as 'pending' | 'reviewing' | 'interview' | 'rejected' | 'accepted' | 'withdrawn',
            appliedAt: app.applied_at.toISOString(),
            updatedAt: app.updated_at.toISOString(),
            coverLetter: app.cover_letter,
            resumeUrl: app.resume_url,
            cvLink: app.cv_link,
            yearsOfExperience: app.years_of_experience,
            notes: app.notes,
            candidate: {
                id: app.candidate.id,
                name: app.candidate.name,
                email: app.candidate.email,
                avatarUrl: app.candidate.avatar_url,
                title: app.candidate.profile?.headline,
                skills: app.candidate.skills.map(us => us.skill.name),
            }
        }));
    }
}
