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
import { NextResponse } from "next/server";
import Papa from "papaparse";
import { PassThrough } from "node:stream";
import { getJobsIterator } from "@/actions/job.actions";
import { format } from "date-fns";
import { auth } from "@/auth";
import { getWorkplaceTypeLabel } from "@/models/job.model";
import { log } from "@/lib/telemetry";
const FIELDS: string[] = [
"index",
"createdAt",
"applied",
"appliedDate",
"Company",
"JobTitle",
"jobType",
"workplaceType",
"Location",
"JobSource",
"Status",
];
const extractLabel = (field: { label?: string } | undefined): string => {
return field?.label || "N/A";
};
const mapJobType = (type: string | undefined): string => {
switch (type) {
case "FT":
return "Full Time";
case "PT":
return "Part Time";
case "C":
return "Contract";
default:
return "Unknown";
}
};
const transformJobData = (
job: Record<string, any>,
index: number
): Record<string, any> => {
return {
index: index + 1,
createdAt: job.createdAt
? format(new Date(job.createdAt), "yyyy-MM-dd")
: "N/A",
applied: job.applied ? "Yes" : "No",
appliedDate: job.appliedDate
? format(new Date(job.appliedDate), "yyyy-MM-dd")
: "N/A",
Company: extractLabel(job.Company),
JobTitle: extractLabel(job.JobTitle),
jobType: mapJobType(job.jobType),
workplaceType: getWorkplaceTypeLabel(job.workplaceType),
Location: extractLabel(job.Location),
JobSource: extractLabel(job.JobSource),
Status: extractLabel(job.Status),
};
};
export const POST = async () => {
const session = await auth();
if (!session) {
return NextResponse.json({ error: "Unauthorized" }, { status: 401 });
}
const passThrough = new PassThrough();
let isFirstChunk = true;
let hasError = false;
(async () => {
try {
let recordIndex = 0;
for await (const chunk of getJobsIterator()) {
if (hasError) break;
const transformedData = chunk.map((job, idx) =>
transformJobData(job, recordIndex + idx)
);
recordIndex += chunk.length;
const csv = Papa.unparse(
{ fields: FIELDS, data: transformedData },
{
header: isFirstChunk,
}
);
passThrough.write((isFirstChunk ? "" : "\n") + csv);
isFirstChunk = false;
}
} catch (error) {
hasError = true;
log.error("Error streaming jobs CSV", { error: String(error) });
if (error instanceof Error) {
return NextResponse.json(
{
error: error.message ?? "Jobs download failed",
},
{
status: 500,
}
);
}
} finally {
passThrough.end();
}
})();
return new NextResponse(passThrough as any, {
headers: {
"Content-Type": "text/csv",
"Content-Disposition": 'attachment; filename="jobs.csv"',
},
});
};