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 { STAGE_DETAIL_INCLUDE } from "./jobStage/shared";
// The same include the Timeline tab uses, so a row from this list is a
// complete JobStage and can be handed straight to AddStageDialog.
const INTERVIEW_LIST_INCLUDE = {
...STAGE_DETAIL_INCLUDE,
Job: {
select: {
id: true,
JobTitle: { select: { label: true } },
Company: { select: { id: true, label: true } },
},
},
};
const buildInterviewWhere = (
userId: string,
search?: string,
stageTypeId?: string,
companyId?: string,
) => {
const where: any = {
Job: { userId },
StageType: { Status: { value: "interview" } },
};
const and: any[] = [];
if (stageTypeId) and.push({ stageTypeId });
if (companyId) and.push({ Job: { companyId } });
if (search) {
and.push({
OR: [
{ Job: { JobTitle: { label: { contains: search } } } },
{ Job: { Company: { label: { contains: search } } } },
{ StageType: { label: { contains: search } } },
{ interviewers: { some: { Contact: { name: { contains: search } } } } },
],
});
}
if (and.length > 0) where.AND = and;
return where;
};
export const getInterviewList = async (
page: number = 1,
limit: number = APP_CONSTANTS.RECORDS_PER_PAGE,
search?: string,
stageTypeId?: string,
companyId?: string,
): Promise<any | undefined> => {
try {
const user = await requireUser();
const where = buildInterviewWhere(user.id, search, stageTypeId, companyId);
// Ordering stays in the query because the list is server-paged.
// Undated rounds sort last. SQLite has no NULLS LAST and
// Prisma's `nulls` option is unsupported there, so the dated rows are
// paged first and the undated ones continue the list once they run out.
const and = where.AND ?? [];
const datedWhere = { ...where, AND: [...and, { occurredAt: { not: null } }] };
const undatedWhere = { ...where, AND: [...and, { occurredAt: null }] };
const skip = (page - 1) * limit;
const [total, datedTotal] = await Promise.all([
prisma.jobStage.count({ where }),
prisma.jobStage.count({ where: datedWhere }),
]);
const datedTake = Math.min(limit, Math.max(0, datedTotal - skip));
const dated =
datedTake > 0
? await prisma.jobStage.findMany({
where: datedWhere,
skip,
take: datedTake,
include: INTERVIEW_LIST_INCLUDE,
orderBy: [{ occurredAt: "desc" }, { createdAt: "desc" }],
})
: [];
const undatedTake = limit - dated.length;
const undated =
undatedTake > 0 && total > datedTotal
? await prisma.jobStage.findMany({
where: undatedWhere,
skip: Math.max(0, skip - datedTotal),
take: undatedTake,
include: INTERVIEW_LIST_INCLUDE,
orderBy: { createdAt: "desc" },
})
: [];
return { data: [...dated, ...undated], total };
} catch (error) {
return handleError(error, "Failed to fetch interviews. ");
}
};
// Options come from rows that exist, not from the Library: offering every
// stage type and every company would mostly offer empty results.
export const getInterviewFilterOptions = async (): Promise<any | undefined> => {
try {
const user = await requireUser();
const rows = await prisma.jobStage.findMany({
where: {
Job: { userId: user.id },
StageType: { Status: { value: "interview" } },
},
select: {
stageTypeId: true,
StageType: { select: { label: true, sortOrder: true } },
Job: { select: { companyId: true, Company: { select: { label: true } } } },
},
});
const roundMap = new Map<string, { label: string; sortOrder: number }>();
const companyMap = new Map<string, string>();
for (const row of rows) {
roundMap.set(row.stageTypeId, {
label: row.StageType.label,
sortOrder: row.StageType.sortOrder,
});
companyMap.set(row.Job.companyId, row.Job.Company.label);
}
const rounds = [...roundMap.entries()]
.sort(
(a, b) =>
a[1].sortOrder - b[1].sortOrder || a[1].label.localeCompare(b[1].label),
)
.map(([id, v]) => ({ id, label: v.label }));
const companies = [...companyMap.entries()]
.sort((a, b) => a[1].localeCompare(b[1]))
.map(([id, label]) => ({ id, label }));
return { rounds, companies };
} catch (error) {
return handleError(error, "Failed to fetch interview filters. ");
}
};