Job application tracker and AI-powered job search assistant. Helps job seekers manage their search journey with AI resume review, job matching, task logging, and application analytics, all while keeping your data private.
TypeScript ai-agentai-resume-analyzerapplication-trackerapplication-tracking-systematscareerjob-applicationjob-automationjob-huntingjob-searchjob-seeker-toolsjob-trackerjob-trackingjobsearchjobseekersmcpollamaresumeresume-reviewself-hosted
"use server";
import prisma from "@/lib/db";
import { handleError } from "@/lib/utils";
import { requireUser } from "../shared";
import { resolveContactRole } from "@/lib/jobs/resolve";
import { assertInterviewStage, assertStageOwned } from "./shared";
const INTERVIEWER_ROLE_LABEL = "Interviewer";
const INTERVIEWER_INCLUDE = {
Contact: {
select: {
id: true,
name: true,
title: true,
email: true,
phone: true,
linkedinUrl: true,
Company: { select: { id: true, label: true } },
},
},
};
export const linkStageInterviewer = async (
stageId: string,
contactId: string,
): Promise<any | undefined> => {
try {
const user = await requireUser();
// Two sides, checked independently: JobStageInterviewer has no owner
// column, so owning the stage is not permission to attach this contact.
const [stage, contact] = await Promise.all([
assertStageOwned(stageId, user.id),
prisma.contact.count({ where: { id: contactId, createdBy: user.id } }),
]);
if (contact === 0) throw new Error("Contact not found");
assertInterviewStage(stage);
// The job's Contacts tab stays the single roster of everyone involved.
// Resolve-or-create: the seeded role is renameable and deletable. Resolved
// outside the transaction, which it must never run inside (D4).
const role = await resolveContactRole(INTERVIEWER_ROLE_LABEL, user.id);
// Both writes together: a stage link without its roster entry leaves the
// Contacts tab disagreeing with the stage's interviewers for good.
const data = await prisma.$transaction(async (tx: any) => {
const link = await tx.jobStageInterviewer.create({
data: { stageId, contactId },
include: INTERVIEWER_INCLUDE,
});
const existing = await tx.jobContact.findFirst({
where: { jobId: stage.jobId, contactId, roleId: role.id },
select: { id: true },
});
if (!existing) {
await tx.jobContact.create({
data: { jobId: stage.jobId, contactId, roleId: role.id },
});
}
return link;
});
return { success: true, data };
} catch (error: any) {
if (error?.code === "P2002") {
return {
success: false,
message: "That contact is already an interviewer on this stage.",
};
}
return handleError(error, "Failed to link interviewer.");
}
};
export const unlinkStageInterviewer = async (
linkId: string,
): Promise<any | undefined> => {
try {
const user = await requireUser();
// The JobContact is deliberately left in place: the person may hold other
// roles on this job, and unlinking a stage is not unlinking the job.
const res = await prisma.jobStageInterviewer.deleteMany({
where: {
id: linkId,
Stage: { Job: { userId: user.id } },
Contact: { createdBy: user.id },
},
});
if (res.count === 0) throw new Error("Interviewer link not found");
return { success: true };
} catch (error) {
return handleError(error, "Failed to unlink interviewer.");
}
};