[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_104":86,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","5d23079c-8838-11f1-9b3d-1607ee4eb77e","name","fileType","http","content","import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst STAGES = [\"Applied\", \"Screening\", \"Interview\", \"Offer\", \"Hired\"] as const;\n\nconst LOST_REASONS = [\"Rejected\", \"They declined\", \"Ghosted\", \"Bad timing\", \"Needs remote\", \"Other\"] as const;\n\nconst PEOPLE = [\"Sawyer\", \"Alp\", \"Andy\"] as const;\n\nconst GRADES = [\"Strong yes\", \"Yes\", \"Neutral\", \"No\", \"Strong no\"] as const;\n\nconst MEETINGS = [\"In-person\", \"Video\", \"Phone\"] as const;\n\nawait sqlite.batch([\n\t`CREATE TABLE IF NOT EXISTS ats_people (\n\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\tname TEXT NOT NULL,\n\t\temail TEXT DEFAULT '',\n\t\tnotes TEXT DEFAULT '',\n\t\tcreated_at TEXT DEFAULT (datetime('now')),\n\t\tupdated_at TEXT DEFAULT (datetime('now'))\n\t)`,\n\t`CREATE TABLE IF NOT EXISTS ats_roles (\n\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\ttitle TEXT NOT NULL,\n\t\tarchived INTEGER DEFAULT 0,\n\t\tcreated_at TEXT DEFAULT (datetime('now'))\n\t)`,\n\t`CREATE TABLE IF NOT EXISTS ats_applications (\n\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\tperson_id INTEGER NOT NULL,\n\t\trole_id INTEGER NOT NULL,\n\t\tstage TEXT NOT NULL DEFAULT 'Applied',\n\t\towner TEXT DEFAULT '',\n\t\tgrade TEXT DEFAULT '',\n\t\tnotes TEXT DEFAULT '',\n\t\tcreated_at TEXT DEFAULT (datetime('now')),\n\t\tupdated_at TEXT DEFAULT (datetime('now')),\n\t\tUNIQUE(person_id, role_id)\n\t)`,\n\t`CREATE TABLE IF NOT EXISTS ats_stage_owners (\n\t\trole_id INTEGER NOT NULL,\n\t\tstage TEXT NOT NULL,\n\t\towner TEXT NOT NULL DEFAULT '',\n\t\tUNIQUE(role_id, stage)\n\t)`,\n\t`CREATE TABLE IF NOT EXISTS ats_events (\n\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\tperson_id INTEGER NOT NULL,\n\t\trole_id INTEGER,\n\t\tauthor TEXT DEFAULT '',\n\t\tkind TEXT NOT NULL DEFAULT 'note',\n\t\tbody TEXT NOT NULL,\n\t\tcreated_at TEXT DEFAULT (datetime('now'))\n\t)`,\n]);\n\ntry {\n\tawait sqlite.execute(`ALTER TABLE ats_applications ADD COLUMN meeting TEXT DEFAULT ''`);\n} catch {\n\t// column already exists\n}\n\ntry {\n\tawait sqlite.execute(`ALTER TABLE ats_applications ADD COLUMN lost_reason TEXT DEFAULT ''`);\n} catch {\n\t// column already exists\n}\n\nconst app = new Hono();\n\napp.use(\"*\", async (c, next) => {\n\tawait next();\n\tc.header(\"cache-control\", \"no-store\");\n});\n\nconst asPerson = (r: any) => ({ id: r[0], name: r[1], email: r[2], notes: r[3] });\n\nconst asRole = (r: any) => ({ id: r[0], title: r[1], archived: !!r[2] });\n\nconst logEvent = async (e: {\n\tperson_id: number;\n\trole_id?: number | null;\n\tauthor?: string;\n\tkind: \"note\" | \"system\";\n\tbody: string;\n}) => {\n\tawait sqlite.execute({\n\t\tsql: \"INSERT INTO ats_events (person_id, role_id, author, kind, body) VALUES (?, ?, ?, ?, ?)\",\n\t\targs: [e.person_id, e.role_id ?? null, PEOPLE.includes(e.author as any) ? e.author : \"\", e.kind, e.body],\n\t});\n};\n\nconst getRoleTitle = async (roleId: number) => {\n\tconst rs = await sqlite.execute({ sql: \"SELECT title FROM ats_roles WHERE id = ?\", args: [roleId] });\n\treturn (rs.rows[0]?.[0] as string) ?? \"?\";\n};\n\nconst asApplication = (r: any) => ({\n\tid: r[0],\n\tperson_id: r[1],\n\trole_id: r[2],\n\tstage: r[3],\n\towner: r[4],\n\tgrade: r[5],\n\tnotes: r[6],\n\tmeeting: r[7],\n\tlost_reason: r[8],\n});\n\napp.get(\"/api/state\", async (c) => {\n\tconst [people, roles, applications, stageOwners, events] = await sqlite.batch([\n\t\t\"SELECT id, name, email, notes FROM ats_people ORDER BY name\",\n\t\t\"SELECT id, title, archived FROM ats_roles ORDER BY created_at\",\n\t\t\"SELECT id, person_id, role_id, stage, owner, grade, notes, meeting, lost_reason FROM ats_applications ORDER BY updated_at DESC\",\n\t\t\"SELECT role_id, stage, owner FROM ats_stage_owners\",\n\t\t\"SELECT id, person_id, role_id, author, kind, body, created_at FROM ats_events ORDER BY id DESC\",\n\t]);\n\treturn c.json({\n\t\tpeople: people.rows.map(asPerson),\n\t\troles: roles.rows.map(asRole),\n\t\tapplications: applications.rows.map(asApplication),\n\t\tstage_owners: stageOwners.rows.map((r: any) => ({ role_id: r[0], stage: r[1], owner: r[2] })),\n\t\tevents: events.rows.map((r: any) => ({\n\t\t\tid: r[0],\n\t\t\tperson_id: r[1],\n\t\t\trole_id: r[2],\n\t\t\tauthor: r[3],\n\t\t\tkind: r[4],\n\t\t\tbody: r[5],\n\t\t\tcreated_at: r[6],\n\t\t})),\n\t});\n});\n\napp.put(\"/api/stage-owners\", async (c) => {\n\tconst b = await c.req.json();\n\tconst roleId = Number(b.role_id);\n\tif (!roleId || !STAGES.includes(b.stage)) return c.json({ error: \"bad input\" }, 400);\n\tif (b.owner !== \"\" && !PEOPLE.includes(b.owner)) return c.json({ error: \"bad owner\" }, 400);\n\tawait sqlite.execute({\n\t\tsql: \"INSERT INTO ats_stage_owners (role_id, stage, owner) VALUES (?, ?, ?) ON CONFLICT(role_id, stage) DO UPDATE SET owner = excluded.owner\",\n\t\targs: [roleId, b.stage, b.owner],\n\t});\n\treturn c.json({ ok: true });\n});\n\napp.post(\"/api/roles\", async (c) => {\n\tconst b = await c.req.json();\n\tif (!b.title?.trim()) return c.json({ error: \"title required\" }, 400);\n\tconst rs = await sqlite.execute({\n\t\tsql: \"INSERT INTO ats_roles (title) VALUES (?) RETURNING id\",\n\t\targs: [b.title.trim()],\n\t});\n\treturn c.json({ id: rs.rows[0][0] }, 201);\n});\n\napp.patch(\"/api/roles/:id\", async (c) => {\n\tconst b = await c.req.json();\n\tconst fields: string[] = [];\n\tconst args: unknown[] = [];\n\tif (typeof b.title === \"string\" && b.title.trim()) {\n\t\tfields.push(\"title = ?\");\n\t\targs.push(b.title.trim());\n\t}\n\tif (b.archived !== undefined) {\n\t\tfields.push(\"archived = ?\");\n\t\targs.push(b.archived ? 1 : 0);\n\t}\n\tif (fields.length === 0) return c.json({ error: \"no fields\" }, 400);\n\targs.push(Number(c.req.param(\"id\")));\n\tawait sqlite.execute({ sql: `UPDATE ats_roles SET ${fields.join(\", \")} WHERE id = ?`, args });\n\treturn c.json({ ok: true });\n});\n\nconst findOrCreatePerson = async (person: { name?: string; email?: string }) => {\n\tconst name = person.name?.trim() ?? \"\";\n\tconst email = person.email?.trim() ?? \"\";\n\tif (!name) return null;\n\tconst existing = await sqlite.execute({\n\t\tsql: \"SELECT id FROM ats_people WHERE (email != '' AND email = ?) OR lower(name) = lower(?) LIMIT 1\",\n\t\targs: [email, name],\n\t});\n\tif (existing.rows.length > 0) return existing.rows[0][0] as number;\n\tconst rs = await sqlite.execute({\n\t\tsql: \"INSERT INTO ats_people (name, email) VALUES (?, ?) RETURNING id\",\n\t\targs: [name, email],\n\t});\n\treturn rs.rows[0][0] as number;\n};\n\napp.post(\"/api/people\", async (c) => {\n\tconst b = await c.req.json();\n\tconst id = await findOrCreatePerson(b);\n\tif (id === null) return c.json({ error: \"name required\" }, 400);\n\treturn c.json({ id }, 201);\n});\n\napp.patch(\"/api/people/:id\", async (c) => {\n\tconst b = await c.req.json();\n\tconst fields: string[] = [];\n\tconst args: unknown[] = [];\n\tfor (const key of [\"name\", \"email\", \"notes\"]) {\n\t\tif (typeof b[key] === \"string\") {\n\t\t\tfields.push(`${key} = ?`);\n\t\t\targs.push(b[key]);\n\t\t}\n\t}\n\tif (fields.length === 0) return c.json({ error: \"no fields\" }, 400);\n\tfields.push(\"updated_at = datetime('now')\");\n\targs.push(Number(c.req.param(\"id\")));\n\tawait sqlite.execute({ sql: `UPDATE ats_people SET ${fields.join(\", \")} WHERE id = ?`, args });\n\treturn c.json({ ok: true });\n});\n\napp.delete(\"/api/people/:id\", async (c) => {\n\tconst id = Number(c.req.param(\"id\"));\n\tawait sqlite.execute({ sql: \"DELETE FROM ats_applications WHERE person_id = ?\", args: [id] });\n\tawait sqlite.execute({ sql: \"DELETE FROM ats_events WHERE person_id = ?\", args: [id] });\n\tawait sqlite.execute({ sql: \"DELETE FROM ats_people WHERE id = ?\", args: [id] });\n\treturn c.json({ ok: true });\n});\n\napp.post(\"/api/applications\", async (c) => {\n\tconst b = await c.req.json();\n\tconst roleId = Number(b.role_id);\n\tif (!roleId) return c.json({ error: \"role_id required\" }, 400);\n\tlet personId = b.person_id ? Number(b.person_id) : null;\n\tif (!personId) personId = await findOrCreatePerson(b.person ?? {});\n\tif (!personId) return c.json({ error: \"person required\" }, 400);\n\tconst owner = PEOPLE.includes(b.owner) ? b.owner : \"\";\n\tconst stage = STAGES.includes(b.stage) ? b.stage : \"Applied\";\n\tconst grade = GRADES.includes(b.grade) ? b.grade : \"\";\n\tconst notes = typeof b.notes === \"string\" ? b.notes : \"\";\n\tconst lostReason = LOST_REASONS.includes(b.lost_reason) ? b.lost_reason : \"\";\n\ttry {\n\t\tawait sqlite.execute({\n\t\t\tsql: \"INSERT INTO ats_applications (person_id, role_id, stage, owner, grade, notes, lost_reason) VALUES (?, ?, ?, ?, ?, ?, ?)\",\n\t\t\targs: [personId, roleId, stage, owner, grade, notes, lostReason],\n\t\t});\n\t} catch {\n\t\treturn c.json({ error: \"already in this role\" }, 409);\n\t}\n\tconst title = await getRoleTitle(roleId);\n\tawait logEvent({\n\t\tperson_id: personId,\n\t\trole_id: roleId,\n\t\tauthor: b.author,\n\t\tkind: \"system\",\n\t\tbody: `Added to ${title} in ${stage}`,\n\t});\n\treturn c.json({ ok: true }, 201);\n});\n\napp.post(\"/api/events\", async (c) => {\n\tconst b = await c.req.json();\n\tconst personId = Number(b.person_id);\n\tconst body = typeof b.body === \"string\" ? b.body.trim() : \"\";\n\tif (!personId || !body) return c.json({ error: \"person_id and body required\" }, 400);\n\tawait logEvent({\n\t\tperson_id: personId,\n\t\trole_id: b.role_id ? Number(b.role_id) : null,\n\t\tauthor: b.author,\n\t\tkind: \"note\",\n\t\tbody,\n\t});\n\treturn c.json({ ok: true }, 201);\n});\n\napp.delete(\"/api/events/:id\", async (c) => {\n\tawait sqlite.execute({ sql: \"DELETE FROM ats_events WHERE id = ?\", args: [Number(c.req.param(\"id\"))] });\n\treturn c.json({ ok: true });\n});\n\napp.patch(\"/api/applications/:id\", async (c) => {\n\tconst b = await c.req.json();\n\tconst appId = Number(c.req.param(\"id\"));\n\tconst before = await sqlite.execute({\n\t\tsql: \"SELECT person_id, role_id, stage, grade, meeting, lost_reason FROM ats_applications WHERE id = ?\",\n\t\targs: [appId],\n\t});\n\tif (before.rows.length === 0) return c.json({ error: \"not found\" }, 404);\n\tconst prev = {\n\t\tperson_id: before.rows[0][0] as number,\n\t\trole_id: before.rows[0][1] as number,\n\t\tstage: (before.rows[0][2] as string) ?? \"\",\n\t\tgrade: (before.rows[0][3] as string) ?? \"\",\n\t\tmeeting: (before.rows[0][4] as string) ?? \"\",\n\t\tlost_reason: (before.rows[0][5] as string) ?? \"\",\n\t};\n\tconst fields: string[] = [];\n\tconst args: unknown[] = [];\n\tif (b.stage !== undefined) {\n\t\tif (!STAGES.includes(b.stage)) return c.json({ error: \"bad stage\" }, 400);\n\t\tfields.push(\"stage = ?\");\n\t\targs.push(b.stage);\n\t}\n\tif (b.owner !== undefined) {\n\t\tif (b.owner !== \"\" && !PEOPLE.includes(b.owner)) return c.json({ error: \"bad owner\" }, 400);\n\t\tfields.push(\"owner = ?\");\n\t\targs.push(b.owner);\n\t}\n\tif (b.grade !== undefined) {\n\t\tif (b.grade !== \"\" && !GRADES.includes(b.grade)) return c.json({ error: \"bad grade\" }, 400);\n\t\tfields.push(\"grade = ?\");\n\t\targs.push(b.grade);\n\t}\n\tif (b.meeting !== undefined) {\n\t\tif (b.meeting !== \"\" && !MEETINGS.includes(b.meeting)) return c.json({ error: \"bad meeting\" }, 400);\n\t\tfields.push(\"meeting = ?\");\n\t\targs.push(b.meeting);\n\t}\n\tif (b.lost_reason !== undefined) {\n\t\tif (b.lost_reason !== \"\" && !LOST_REASONS.includes(b.lost_reason)) return c.json({ error: \"bad lost_reason\" }, 400);\n\t\tfields.push(\"lost_reason = ?\");\n\t\targs.push(b.lost_reason);\n\t}\n\tif (typeof b.notes === \"string\") {\n\t\tfields.push(\"notes = ?\");\n\t\targs.push(b.notes);\n\t}\n\tif (fields.length === 0) return c.json({ error: \"no fields\" }, 400);\n\tfields.push(\"updated_at = datetime('now')\");\n\targs.push(appId);\n\tawait sqlite.execute({ sql: `UPDATE ats_applications SET ${fields.join(\", \")} WHERE id = ?`, args });\n\n\tconst title = await getRoleTitle(prev.role_id);\n\tconst changes: string[] = [];\n\tif (b.stage !== undefined && b.stage !== prev.stage) changes.push(`Moved from ${prev.stage} to ${b.stage} in ${title}`);\n\tif (b.lost_reason !== undefined && b.lost_reason !== prev.lost_reason) {\n\t\tchanges.push(b.lost_reason ? `Out of funnel for ${title}: ${b.lost_reason}` : `Back in the funnel for ${title}`);\n\t}\n\tif (b.grade !== undefined && b.grade !== prev.grade) {\n\t\tchanges.push(b.grade ? `Graded ${b.grade} for ${title}` : `Cleared grade for ${title}`);\n\t}\n\tif (b.meeting !== undefined && b.meeting !== prev.meeting && b.meeting) changes.push(`Met ${b.meeting} for ${title}`);\n\tif (b.owner !== undefined && b.owner !== \"\") changes.push(`Assigned to ${b.owner} for ${title}`);\n\tfor (const body of changes) {\n\t\tawait logEvent({ person_id: prev.person_id, role_id: prev.role_id, author: b.author, kind: \"system\", body });\n\t}\n\treturn c.json({ ok: true });\n});\n\napp.delete(\"/api/applications/:id\", async (c) => {\n\tawait sqlite.execute({\n\t\tsql: \"DELETE FROM ats_applications WHERE id = ?\",\n\t\targs: [Number(c.req.param(\"id\"))],\n\t});\n\treturn c.json({ ok: true });\n});\n\napp.get(\"/\", (c) =>\n\tc.html(`\n\n\n\n\nMini ATS\n\n\n\n

\n\t

Mini ATS

\n\t

\n\t\t\n\t\t

\n\t

Viewing as

\n\n

\n\n\n`));\n\nexport default app.fetch;\n","import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst STAGES = [\"Applied\", \"Screening\", \"Interview\", \"Offer\", \"Hired\"] as const;\n\nconst LOST_REASONS = [\"Rejected\", \"They declined\", \"Ghosted\", \"Bad timing\", \"Needs remote\", \"Other\"] as const;\n\nconst PEOPLE = [\"Sawyer\", \"Alp\", \"Andy\"] as const;\n\nconst GRADES = [\"Strong yes\", \"Yes\", \"Neutral\", \"No\", \"Strong no\"] as const;\n\nconst MEETINGS = [\"In-person\", \"Video\", \"Phone\"] as const;\n\nawait sqlite.batch([\n\t`CREATE TABLE IF NOT EXISTS ats_people (\n\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\tname TEXT NOT NULL,\n\t\temail TEXT DEFAULT '',\n\t\tnotes TEXT DEFAULT '',\n\t\tcreated_at TEXT DEFAULT (datetime('now')),\n\t\tupdated_at TEXT DEFAULT (datetime('now'))\n\t)`,\n\t`CREATE TABLE IF NOT EXISTS ats_roles (\n\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\ttitle TEXT NOT NULL,\n\t\tarchived INTEGER DEFAULT 0,\n\t\tcreated_at TEXT DEFAULT (datetime('now'))\n\t)`,\n\t`CREATE TABLE IF NOT EXISTS ats_applications (\n\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\tperson_id INTEGER NOT NULL,\n\t\trole_id INTEGER NOT NULL,\n\t\tstage TEXT NOT NULL DEFAULT 'Applied',\n\t\towner TEXT DEFAULT '',\n\t\tgrade TEXT DEFAULT '',\n\t\tnotes TEXT DEFAULT '',\n\t\tcreated_at TEXT DEFAULT (datetime('now')),\n\t\tupdated_at TEXT DEFAULT (datetime('now')),\n\t\tUNIQUE(person_id, role_id)\n\t)`,\n\t`CREATE TABLE IF NOT EXISTS ats_stage_owners (\n\t\trole_id INTEGER NOT NULL,\n\t\tstage TEXT NOT NULL,\n\t\towner TEXT NOT NULL DEFAULT '',\n\t\tUNIQUE(role_id, stage)\n\t)`,\n\t`CREATE TABLE IF NOT EXISTS ats_events (\n\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\tperson_id INTEGER NOT NULL,\n\t\trole_id INTEGER,\n\t\tauthor TEXT DEFAULT '',\n\t\tkind TEXT NOT NULL DEFAULT 'note',\n\t\tbody TEXT NOT NULL,\n\t\tcreated_at TEXT DEFAULT (datetime('now'))\n\t)`,\n]);\n\ntry {\n\tawait sqlite.execute(`ALTER TABLE ats_applications ADD COLUMN meeting TEXT DEFAULT ''`);\n} catch {\n\t// column already exists\n}\n\ntry {\n\tawait sqlite.execute(`ALTER TABLE ats_applications ADD COLUMN lost_reason TEXT DEFAULT ''`);\n} catch {\n\t// column already exists\n}\n\nconst app = new Hono();\n\napp.use(\"*\", async (c, next) => {\n\tawait next();\n\tc.header(\"cache-control\", \"no-store\");\n});\n\nconst asPerson = (r: any) => ({ id: r[0], name: r[1], email: r[2], notes: r[3] });\n\nconst asRole = (r: any) => ({ id: r[0], title: r[1], archived: !!r[2] });\n\nconst logEvent = async (e: {\n\tperson_id: number;\n\trole_id?: number | null;\n\tauthor?: string;\n\tkind: \"note\" | \"system\";\n\tbody: string;\n}) => {\n\tawait sqlite.execute({\n\t\tsql: \"INSERT INTO ats_events (person_id, role_id, author, kind, body) VALUES (?, ?, ?, ?, ?)\",\n\t\targs: [e.person_id, e.role_id ?? null, PEOPLE.includes(e.author as any) ? e.author : \"\", e.kind, e.body],\n\t});\n};\n\nconst getRoleTitle = async (roleId: number) => {\n\tconst rs = await sqlite.execute({ sql: \"SELECT title FROM ats_roles WHERE id = ?\", args: [roleId] });\n\treturn (rs.rows[0]?.[0] as string) ?? \"?\";\n};\n\nconst asApplication = (r: any) => ({\n\tid: r[0],\n\tperson_id: r[1],\n\trole_id: r[2],\n\tstage: r[3],\n\towner: r[4],\n\tgrade: r[5],\n\tnotes: r[6],\n\tmeeting: r[7],\n\tlost_reason: r[8],\n});\n\napp.get(\"/api/state\", async (c) => {\n\tconst [people, roles, applications, stageOwners, events] = await sqlite.batch([\n\t\t\"SELECT id, name, email, notes FROM ats_people ORDER BY name\",\n\t\t\"SELECT id, title, archived FROM ats_roles ORDER BY created_at\",\n\t\t\"SELECT id, person_id, role_id, stage, owner, grade, notes, meeting, lost_reason FROM ats_applications ORDER BY updated_at DESC\",\n\t\t\"SELECT role_id, stage, owner FROM ats_stage_owners\",\n\t\t\"SELECT id, person_id, role_id, author, kind, body, created_at FROM ats_events ORDER BY id DESC\",\n\t]);\n\treturn c.json({\n\t\tpeople: people.rows.map(asPerson),\n\t\troles: roles.rows.map(asRole),\n\t\tapplications: applications.rows.map(asApplication),\n\t\tstage_owners: stageOwners.rows.map((r: any) => ({ role_id: r[0], stage: r[1], owner: r[2] })),\n\t\tevents: events.rows.map((r: any) => ({\n\t\t\tid: r[0],\n\t\t\tperson_id: r[1],\n\t\t\trole_id: r[2],\n\t\t\tauthor: r[3],\n\t\t\tkind: r[4],\n\t\t\tbody: r[5],\n\t\t\tcreated_at: r[6],\n\t\t})),\n\t});\n});\n\napp.put(\"/api/stage-owners\", async (c) => {\n\tconst b = await c.req.json();\n\tconst roleId = Number(b.role_id);\n\tif (!roleId || !STAGES.includes(b.stage)) return c.json({ error: \"bad input\" }, 400);\n\tif (b.owner !== \"\" && !PEOPLE.includes(b.owner)) return c.json({ error: \"bad owner\" }, 400);\n\tawait sqlite.execute({\n\t\tsql: \"INSERT INTO ats_stage_owners (role_id, stage, owner) VALUES (?, ?, ?) ON CONFLICT(role_id, stage) DO UPDATE SET owner = excluded.owner\",\n\t\targs: [roleId, b.stage, b.owner],\n\t});\n\treturn c.json({ ok: true });\n});\n\napp.post(\"/api/roles\", async (c) => {\n\tconst b = await c.req.json();\n\tif (!b.title?.trim()) return c.json({ error: \"title required\" }, 400);\n\tconst rs = await sqlite.execute({\n\t\tsql: \"INSERT INTO ats_roles (title) VALUES (?) RETURNING id\",\n\t\targs: [b.title.trim()],\n\t});\n\treturn c.json({ id: rs.rows[0][0] }, 201);\n});\n\napp.patch(\"/api/roles/:id\", async (c) => {\n\tconst b = await c.req.json();\n\tconst fields: string[] = [];\n\tconst args: unknown[] = [];\n\tif (typeof b.title === \"string\" && b.title.trim()) {\n\t\tfields.push(\"title = ?\");\n\t\targs.push(b.title.trim());\n\t}\n\tif (b.archived !== undefined) {\n\t\tfields.push(\"archived = ?\");\n\t\targs.push(b.archived ? 1 : 0);\n\t}\n\tif (fields.length === 0) return c.json({ error: \"no fields\" }, 400);\n\targs.push(Number(c.req.param(\"id\")));\n\tawait sqlite.execute({ sql: `UPDATE ats_roles SET ${fields.join(\", \")} WHERE id = ?`, args });\n\treturn c.json({ ok: true });\n});\n\nconst findOrCreatePerson = async (person: { name?: string; email?: string }) => {\n\tconst name = person.name?.trim() ?? \"\";\n\tconst email = person.email?.trim() ?? \"\";\n\tif (!name) return null;\n\tconst existing = await sqlite.execute({\n\t\tsql: \"SELECT id FROM ats_people WHERE (email != '' AND email = ?) OR lower(name) = lower(?) LIMIT 1\",\n\t\targs: [email, name],\n\t});\n\tif (existing.rows.length > 0) return existing.rows[0][0] as number;\n\tconst rs = await sqlite.execute({\n\t\tsql: \"INSERT INTO ats_people (name, email) VALUES (?, ?) RETURNING id\",\n\t\targs: [name, email],\n\t});\n\treturn rs.rows[0][0] as number;\n};\n\napp.post(\"/api/people\", async (c) => {\n\tconst b = await c.req.json();\n\tconst id = await findOrCreatePerson(b);\n\tif (id === null) return c.json({ error: \"name required\" }, 400);\n\treturn c.json({ id }, 201);\n});\n\napp.patch(\"/api/people/:id\", async (c) => {\n\tconst b = await c.req.json();\n\tconst fields: string[] = [];\n\tconst args: unknown[] = [];\n\tfor (const key of [\"name\", \"email\", \"notes\"]) {\n\t\tif (typeof b[key] === \"string\") {\n\t\t\tfields.push(`${key} = ?`);\n\t\t\targs.push(b[key]);\n\t\t}\n\t}\n\tif (fields.length === 0) return c.json({ error: \"no fields\" }, 400);\n\tfields.push(\"updated_at = datetime('now')\");\n\targs.push(Number(c.req.param(\"id\")));\n\tawait sqlite.execute({ sql: `UPDATE ats_people SET ${fields.join(\", \")} WHERE id = ?`, args });\n\treturn c.json({ ok: true });\n});\n\napp.delete(\"/api/people/:id\", async (c) => {\n\tconst id = Number(c.req.param(\"id\"));\n\tawait sqlite.execute({ sql: \"DELETE FROM ats_applications WHERE person_id = ?\", args: [id] });\n\tawait sqlite.execute({ sql: \"DELETE FROM ats_events WHERE person_id = ?\", args: [id] });\n\tawait sqlite.execute({ sql: \"DELETE FROM ats_people WHERE id = ?\", args: [id] });\n\treturn c.json({ ok: true });\n});\n\napp.post(\"/api/applications\", async (c) => {\n\tconst b = await c.req.json();\n\tconst roleId = Number(b.role_id);\n\tif (!roleId) return c.json({ error: \"role_id required\" }, 400);\n\tlet personId = b.person_id ? Number(b.person_id) : null;\n\tif (!personId) personId = await findOrCreatePerson(b.person ?? {});\n\tif (!personId) return c.json({ error: \"person required\" }, 400);\n\tconst owner = PEOPLE.includes(b.owner) ? b.owner : \"\";\n\tconst stage = STAGES.includes(b.stage) ? b.stage : \"Applied\";\n\tconst grade = GRADES.includes(b.grade) ? b.grade : \"\";\n\tconst notes = typeof b.notes === \"string\" ? b.notes : \"\";\n\tconst lostReason = LOST_REASONS.includes(b.lost_reason) ? b.lost_reason : \"\";\n\ttry {\n\t\tawait sqlite.execute({\n\t\t\tsql: \"INSERT INTO ats_applications (person_id, role_id, stage, owner, grade, notes, lost_reason) VALUES (?, ?, ?, ?, ?, ?, ?)\",\n\t\t\targs: [personId, roleId, stage, owner, grade, notes, lostReason],\n\t\t});\n\t} catch {\n\t\treturn c.json({ error: \"already in this role\" }, 409);\n\t}\n\tconst title = await getRoleTitle(roleId);\n\tawait logEvent({\n\t\tperson_id: personId,\n\t\trole_id: roleId,\n\t\tauthor: b.author,\n\t\tkind: \"system\",\n\t\tbody: `Added to ${title} in ${stage}`,\n\t});\n\treturn c.json({ ok: true }, 201);\n});\n\napp.post(\"/api/events\", async (c) => {\n\tconst b = await c.req.json();\n\tconst personId = Number(b.person_id);\n\tconst body = typeof b.body === \"string\" ? b.body.trim() : \"\";\n\tif (!personId || !body) return c.json({ error: \"person_id and body required\" }, 400);\n\tawait logEvent({\n\t\tperson_id: personId,\n\t\trole_id: b.role_id ? Number(b.role_id) : null,\n\t\tauthor: b.author,\n\t\tkind: \"note\",\n\t\tbody,\n\t});\n\treturn c.json({ ok: true }, 201);\n});\n\napp.delete(\"/api/events/:id\", async (c) => {\n\tawait sqlite.execute({ sql: \"DELETE FROM ats_events WHERE id = ?\", args: [Number(c.req.param(\"id\"))] });\n\treturn c.json({ ok: true });\n});\n\napp.patch(\"/api/applications/:id\", async (c) => {\n\tconst b = await c.req.json();\n\tconst appId = Number(c.req.param(\"id\"));\n\tconst before = await sqlite.execute({\n\t\tsql: \"SELECT person_id, role_id, stage, grade, meeting, lost_reason FROM ats_applications WHERE id = ?\",\n\t\targs: [appId],\n\t});\n\tif (before.rows.length === 0) return c.json({ error: \"not found\" }, 404);\n\tconst prev = {\n\t\tperson_id: before.rows[0][0] as number,\n\t\trole_id: before.rows[0][1] as number,\n\t\tstage: (before.rows[0][2] as string) ?? \"\",\n\t\tgrade: (before.rows[0][3] as string) ?? \"\",\n\t\tmeeting: (before.rows[0][4] as string) ?? \"\",\n\t\tlost_reason: (before.rows[0][5] as string) ?? \"\",\n\t};\n\tconst fields: string[] = [];\n\tconst args: unknown[] = [];\n\tif (b.stage !== undefined) {\n\t\tif (!STAGES.includes(b.stage)) return c.json({ error: \"bad stage\" }, 400);\n\t\tfields.push(\"stage = ?\");\n\t\targs.push(b.stage);\n\t}\n\tif (b.owner !== undefined) {\n\t\tif (b.owner !== \"\" && !PEOPLE.includes(b.owner)) return c.json({ error: \"bad owner\" }, 400);\n\t\tfields.push(\"owner = ?\");\n\t\targs.push(b.owner);\n\t}\n\tif (b.grade !== undefined) {\n\t\tif (b.grade !== \"\" && !GRADES.includes(b.grade)) return c.json({ error: \"bad grade\" }, 400);\n\t\tfields.push(\"grade = ?\");\n\t\targs.push(b.grade);\n\t}\n\tif (b.meeting !== undefined) {\n\t\tif (b.meeting !== \"\" && !MEETINGS.includes(b.meeting)) return c.json({ error: \"bad meeting\" }, 400);\n\t\tfields.push(\"meeting = ?\");\n\t\targs.push(b.meeting);\n\t}\n\tif (b.lost_reason !== undefined) {\n\t\tif (b.lost_reason !== \"\" && !LOST_REASONS.includes(b.lost_reason)) return c.json({ error: \"bad lost_reason\" }, 400);\n\t\tfields.push(\"lost_reason = ?\");\n\t\targs.push(b.lost_reason);\n\t}\n\tif (typeof b.notes === \"string\") {\n\t\tfields.push(\"notes = ?\");\n\t\targs.push(b.notes);\n\t}\n\tif (fields.length === 0) return c.json({ error: \"no fields\" }, 400);\n\tfields.push(\"updated_at = datetime('now')\");\n\targs.push(appId);\n\tawait sqlite.execute({ sql: `UPDATE ats_applications SET ${fields.join(\", \")} WHERE id = ?`, args });\n\n\tconst title = await getRoleTitle(prev.role_id);\n\tconst changes: string[] = [];\n\tif (b.stage !== undefined && b.stage !== prev.stage) changes.push(`Moved from ${prev.stage} to ${b.stage} in ${title}`);\n\tif (b.lost_reason !== undefined && b.lost_reason !== prev.lost_reason) {\n\t\tchanges.push(b.lost_reason ? `Out of funnel for ${title}: ${b.lost_reason}` : `Back in the funnel for ${title}`);\n\t}\n\tif (b.grade !== undefined && b.grade !== prev.grade) {\n\t\tchanges.push(b.grade ? `Graded ${b.grade} for ${title}` : `Cleared grade for ${title}`);\n\t}\n\tif (b.meeting !== undefined && b.meeting !== prev.meeting && b.meeting) changes.push(`Met ${b.meeting} for ${title}`);\n\tif (b.owner !== undefined && b.owner !== \"\") changes.push(`Assigned to ${b.owner} for ${title}`);\n\tfor (const body of changes) {\n\t\tawait logEvent({ person_id: prev.person_id, role_id: prev.role_id, author: b.author, kind: \"system\", body });\n\t}\n\treturn c.json({ ok: true });\n});\n\napp.delete(\"/api/applications/:id\", async (c) => {\n\tawait sqlite.execute({\n\t\tsql: \"DELETE FROM ats_applications WHERE id = ?\",\n\t\targs: [Number(c.req.param(\"id\"))],\n\t});\n\treturn c.json({ ok: true });\n});\n\napp.get(\"/\", (c) =>\n\tc.html(`\n\n\n\n\nMini ATS\n\n\n\n

\n\t

Mini ATS

\n\t

\n\t\t\n\t\t

\n\t

Viewing as

\n\n

\n\n\n`));\n\nexport default app.fetch;\n","createdAt",["D",1785017386827],"branchVersion","branchId","5a7d57eb-74d9-48a3-b178-163a90d765c3","id","04c0f7c6-4c1f-4b9e-aab6-d9c106c4ea6d","mini-ats",["D",1784991101203],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Simple ATS for candidate tracking","imageUrl","9f5b2c99-966e-4045-8d52-ec0106bbec23","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","d187c0c4-be62-436b-95a1-8e9a7449c340","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",25,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","sawyeraltman","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybndOSkVHc0U0QnJqZkRma3pwMW9KSm44b3QifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":150,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":151,"_80":152,"_82":153,"_84":25},"tree",[145],"files",[145],"counts",{"_134":62,"_135":136,"_137":62,"_138":139,"_140":141},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"a0e04e38-3fc3-4829-931f-58cd8e7ded51","parentId","latest",["D",1785017386827],12,"label",[28],"pulls","branches",1,"forks","envVars",{"_142":136,"_144":62},"connections",{"_142":62,"_143":62},"count","unfilledCount","emptyCount",{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":146,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_147":148,"_27":149},["D",1785017386827],"children",[],[28],["D",1784991101203],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_123":187,"_188":189,"_190":191,"_192":25,"_193":25,"_194":25,"_195":58,"_196":-5,"_197":-7,"_198":-7,"_199":62,"_200":25,"_201":25,"_202":-5,"_203":25,"_204":25,"_205":25,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":86,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v13