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 { APP_CONSTANTS } from "@/lib/constants";
import { getReferenceEntityList } from "./referenceList";
export const getAllJobLocations = async (): Promise<any | undefined> => {
try {
const user = await requireUser();
const list = await prisma.location.findMany({
where: {
createdBy: user.id,
},
});
return list;
} catch (error) {
const msg = "Failed to fetch job location list. ";
return handleError(error, msg);
}
};
export const getJobLocationsList = async (
page: number = 1,
limit: number = APP_CONSTANTS.RECORDS_PER_PAGE,
countBy?: string,
search?: string,
): Promise<any | undefined> => {
try {
const user = await requireUser();
return await getReferenceEntityList({
model: prisma.location,
userId: user.id,
fkField: "locationId",
appliedRelation: "jobsApplied",
page,
limit,
countBy,
search,
});
} catch (error) {
const msg = "Failed to fetch job location list. ";
return handleError(error, msg);
}
};
export const deleteJobLocationById = async (
locationId: string
): Promise<any | undefined> => {
try {
const user = await requireUser();
const experiences = await prisma.workExperience.count({
where: {
locationId,
},
});
if (experiences > 0) {
throw new Error(
`Job location cannot be deleted due to its use in experience section of one of the resume! `
);
}
const educations = await prisma.education.count({
where: {
locationId,
},
});
if (educations > 0) {
throw new Error(
`Job location cannot be deleted due to its use in education section of one of the resume! `
);
}
const jobs = await prisma.job.count({
where: {
locationId,
userId: user.id,
},
});
if (jobs > 0) {
throw new Error(
`Location cannot be deleted due to ${jobs} number of associated jobs! `
);
}
// Optional relation, so the Prisma default is SetNull; same reasoning as
// the company guard — nothing at the database level blocks this.
const contacts = await prisma.contact.count({
where: { locationId, createdBy: user.id },
});
if (contacts > 0) {
throw new Error(
`Location cannot be deleted due to ${contacts} associated contact${contacts === 1 ? "" : "s"}! `
);
}
const res = await prisma.location.delete({
where: {
id: locationId,
createdBy: user.id,
},
});
return { res, success: true };
} catch (error) {
const msg = "Failed to delete job location.";
return handleError(error, msg);
}
};