{\n const [minutesRow] = await query<{ m: number }>(\n \"SELECT COALESCE(SUM(minutes),0) AS m FROM study_sessions WHERE user_id = ? AND date BETWEEN ? AND ? AND ended_at IS NOT NULL\",\n [userId, from, to],\n );\n const [planRow] = await query<{ total: number; done: number; goal: number }>(\n `SELECT COUNT(*) AS total,\n COALESCE(SUM(CASE WHEN status = 'done' THEN 1 ELSE 0 END), 0) AS done,\n COALESCE(SUM(goal_minutes), 0) AS goal\n FROM plans WHERE user_id = ? AND date BETWEEN ? AND ?`,\n [userId, from, to],\n );\n\n const dailyMinutes = await query<{ date: string; m: number }>(\n `SELECT date, COALESCE(SUM(minutes),0) AS m\n FROM study_sessions\n WHERE user_id = ? AND date BETWEEN ? AND ? AND ended_at IS NOT NULL\n GROUP BY date`,\n [userId, from, to],\n );\n const dailyPlans = await query<{ date: string; total: number; done: number }>(\n `SELECT date, COUNT(*) AS total,\n COALESCE(SUM(CASE WHEN status = 'done' THEN 1 ELSE 0 END), 0) AS done\n FROM plans WHERE user_id = ? AND date BETWEEN ? AND ? GROUP BY date`,\n [userId, from, to],\n );\n const dailyFocus = await query<{ date: string; focus: number | null }>(\n \"SELECT date, focus_score AS focus FROM diaries WHERE user_id = ? AND date BETWEEN ? AND ?\",\n [userId, from, to],\n );\n\n const minutesMap = new Map(dailyMinutes.map((r) => [r.date, Number(r.m)]));\n const planMap = new Map(dailyPlans.map((r) => [r.date, r]));\n const focusMap = new Map(dailyFocus.map((r) => [r.date, r.focus]));\n\n const daily = dateRange(from, to).map((date) => ({\n date,\n minutes: minutesMap.get(date) ?? 0,\n done: Number(planMap.get(date)?.done ?? 0),\n total: Number(planMap.get(date)?.total ?? 0),\n focus: focusMap.get(date) ?? null,\n }));\n\n const bySubjectRows = await query<\n {\n subject_id: string | null;\n name: string | null;\n color: string | null;\n minutes: number;\n total: number;\n done: number;\n }\n >(\n `SELECT p.subject_id,\n s.name, s.color,\n COALESCE(SUM(p.actual_minutes), 0) AS minutes,\n COUNT(*) AS total,\n COALESCE(SUM(CASE WHEN p.status = 'done' THEN 1 ELSE 0 END), 0) AS done\n FROM plans p LEFT JOIN subjects s ON s.id = p.subject_id\n WHERE p.user_id = ? AND p.date BETWEEN ? AND ?\n GROUP BY p.subject_id, s.name, s.color\n ORDER BY minutes DESC`,\n [userId, from, to],\n );\n\n const bySubject = bySubjectRows.map((r) => ({\n subjectId: r.subject_id,\n name: r.name ?? \"미지정\",\n color: r.color ?? \"#94a3b8\",\n minutes: Number(r.minutes),\n done: Number(r.done),\n total: Number(r.total),\n }));\n\n // 주간 집계 — 일별 결과를 주 단위로 접는다.\n const weekMap = new Map();\n for (const d of daily) {\n const wk = weekStart(d.date);\n const cur = weekMap.get(wk) ?? { minutes: 0, done: 0, total: 0 };\n cur.minutes += d.minutes;\n cur.done += d.done;\n cur.total += d.total;\n weekMap.set(wk, cur);\n }\n const weekly = [...weekMap.entries()]\n .sort(([a], [b]) => a.localeCompare(b))\n .map(([week, v]) => ({\n week,\n minutes: v.minutes,\n rate: v.total ? Math.round((v.done / v.total) * 100) : 0,\n }));\n\n // 연속 학습일 — 구간 안에서만 계산한다.\n let current = 0;\n let best = 0;\n for (const d of daily) {\n if (d.minutes > 0) {\n current += 1;\n best = Math.max(best, current);\n } else current = 0;\n }\n // 오늘 아직 공부 전이면 현재 연속이 0으로 보일 수 있다 — 마지막 날이 0이면 그 앞까지로 본다.\n if (daily.length && daily[daily.length - 1].minutes === 0) {\n let back = 0;\n for (let i = daily.length - 2; i >= 0 && daily[i].minutes > 0; i--) back++;\n current = back;\n }\n\n const studyDays = daily.filter((d) => d.minutes > 0).length;\n const focusValues = dailyFocus.map((r) => r.focus).filter((v): v is number =>\n typeof v === \"number\"\n );\n const diaryCount = Number(\n await scalar(\"SELECT COUNT(*) FROM diaries WHERE user_id = ? AND date BETWEEN ? AND ?\", [\n userId,\n from,\n to,\n ]) ?? 0,\n );\n const studyMinutes = Number(minutesRow?.m ?? 0);\n const planTotal = Number(planRow?.total ?? 0);\n const planDone = Number(planRow?.done ?? 0);\n\n return {\n from,\n to,\n totals: {\n studyMinutes,\n goalMinutes: Number(planRow?.goal ?? 0),\n planCount: planTotal,\n doneCount: planDone,\n completionRate: planTotal ? Math.round((planDone / planTotal) * 100) : 0,\n studyDays,\n avgMinutesPerStudyDay: studyDays ? Math.round(studyMinutes / studyDays) : 0,\n diaryCount,\n avgFocus: focusValues.length\n ? Math.round((focusValues.reduce((a, b) => a + b, 0) / focusValues.length) * 10) / 10\n : null,\n },\n daily,\n bySubject,\n weekly,\n streak: { current, best },\n };\n}\n\nexport function register(r: Router): void {\n r.get(\"/api/analytics/summary\", \"user\", async (ctx: Ctx) => {\n const userId = targetUserId(ctx);\n const today = toLocalDate();\n const { from, to } = rangeFromQuery(ctx.query, addDays(today, -27), today);\n return json(await buildSummary(userId, from, to));\n });\n\n /** 직전 동일 길이 구간과 비교 — \"지난주보다 얼마나\" 를 보여주기 위한 것 */\n r.get(\"/api/analytics/compare\", \"user\", async (ctx: Ctx) => {\n const userId = targetUserId(ctx);\n const today = toLocalDate();\n const { from, to } = rangeFromQuery(ctx.query, addDays(today, -6), today);\n const span = dateRange(from, to).length;\n const prevTo = addDays(from, -1);\n const prevFrom = addDays(prevTo, -(span - 1));\n\n const [cur, prev] = await Promise.all([\n buildSummary(userId, from, to),\n buildSummary(userId, prevFrom, prevTo),\n ]);\n return json({ current: cur, previous: prev });\n });\n}\n",[],[137,210],"4db72583-ffc0-4289-b9ca-3bf3ba195b50","admin.ts","0a4fc5d0-ab26-11f1-ba6d-1607ee4eb77e",26,["D",1788831527223],"/**\n * 관리자 / 관리쌤 화면용 API.\n */\nimport { requireAdmin, requireStaff } from \"../lib/auth.ts\";\nimport { badRequest, Ctx, json, notFound, Router } from \"../lib/http.ts\";\nimport { exec, one, query } from \"../lib/sqlite.ts\";\nimport { addDays, nowIso, toLocalDate } from \"../lib/time.ts\";\nimport { enumOf, optStr, str } from \"../lib/validate.ts\";\nimport { audit, notify } from \"./_shared.ts\";\nimport { buildSummary } from \"./analytics.ts\";\nimport { migrate } from \"../db/migrate.ts\";\n\nexport function register(r: Router): void {\n /** 오늘의 운영 현황 — 관리자 대시보드 첫 화면 */\n r.get(\"/api/admin/overview\", \"staff\", async (ctx: Ctx) => {\n requireStaff(ctx.user);\n const today = toLocalDate();\n\n const [students] = await query<{ c: number }>(\n \"SELECT COUNT(*) AS c FROM users WHERE role = 'student' AND status = 'active'\",\n );\n const [studiedToday] = await query<{ c: number }>(\n \"SELECT COUNT(DISTINCT user_id) AS c FROM study_sessions WHERE date = ?\",\n [today],\n );\n const [diariesToday] = await query<{ c: number }>(\n \"SELECT COUNT(*) AS c FROM diaries WHERE date = ? AND content <> ''\",\n [today],\n );\n const [pendingComments] = await query<{ c: number }>(\n \"SELECT COUNT(*) AS c FROM diaries WHERE coach_comment IS NULL AND date >= ?\",\n [addDays(today, -14)],\n );\n const [openConsults] = await query<{ c: number }>(\n \"SELECT COUNT(*) AS c FROM consults WHERE status IN ('requested','scheduled')\",\n );\n const [minutesToday] = await query<{ m: number }>(\n \"SELECT COALESCE(SUM(minutes),0) AS m FROM study_sessions WHERE date = ? AND ended_at IS NOT NULL\",\n [today],\n );\n\n return json({\n today,\n stats: {\n activeStudents: Number(students?.c ?? 0),\n studiedToday: Number(studiedToday?.c ?? 0),\n diariesToday: Number(diariesToday?.c ?? 0),\n pendingComments: Number(pendingComments?.c ?? 0),\n openConsults: Number(openConsults?.c ?? 0),\n studyMinutesToday: Number(minutesToday?.m ?? 0),\n },\n });\n });\n\n /**\n * 학생 목록 + 오늘 진도.\n * 화면에서 학생마다 API 를 또 부르지 않도록 한 번에 붙여서 준다.\n */\n r.get(\"/api/admin/students\", \"staff\", async (ctx: Ctx) => {\n requireStaff(ctx.user);\n const today = toLocalDate();\n const q = (ctx.query.get(\"q\") ?? \"\").trim();\n const like = `%${q}%`;\n\n const rows = await query(\n `SELECT u.id, u.name, u.email, u.grade, u.school, u.target, u.seat_no, u.status, u.role,\n u.last_login_at, u.coach_id,\n (SELECT COALESCE(SUM(s.minutes),0) FROM study_sessions s\n WHERE s.user_id = u.id AND s.date = ? AND s.ended_at IS NOT NULL) AS minutes_today,\n (SELECT COUNT(*) FROM plans p WHERE p.user_id = u.id AND p.date = ?) AS plans_today,\n (SELECT COUNT(*) FROM plans p WHERE p.user_id = u.id AND p.date = ? AND p.status = 'done') AS done_today,\n (SELECT COUNT(*) FROM diaries d WHERE d.user_id = u.id AND d.date = ? AND d.content <> '') AS diary_today\n FROM users u\n WHERE u.role = 'student' ${\n q ? \"AND (u.name LIKE ? OR u.email LIKE ? OR u.seat_no LIKE ?)\" : \"\"\n }\n ORDER BY u.status, u.name\n LIMIT 300`,\n q ? [today, today, today, today, like, like, like] : [today, today, today, today],\n );\n return json({ students: rows, today });\n });\n\n /** 학생 1명 상세 — 프로필 + 기간 분석 + 최근 일기 */\n r.get(\"/api/admin/students/:id\", \"staff\", async (ctx: Ctx) => {\n requireStaff(ctx.user);\n const user = await one(\"SELECT * FROM users WHERE id = ?\", [ctx.params.id]);\n if (!user) throw notFound(\"학생을 찾을 수 없습니다.\");\n\n const today = toLocalDate();\n const from = ctx.query.get(\"from\") ?? addDays(today, -27);\n const summary = await buildSummary(ctx.params.id, from, ctx.query.get(\"to\") ?? today);\n const diaries = await query(\n \"SELECT * FROM diaries WHERE user_id = ? ORDER BY date DESC LIMIT 10\",\n [ctx.params.id],\n );\n const consults = await query(\n \"SELECT * FROM consults WHERE user_id = ? ORDER BY created_at DESC LIMIT 10\",\n [ctx.params.id],\n );\n return json({ user, summary, diaries, consults });\n });\n\n /** 학생 정보 수정 (좌석·담당쌤·상태·권한) */\n r.patch(\"/api/admin/students/:id\", \"staff\", async (ctx: Ctx) => {\n requireStaff(ctx.user);\n const body = await ctx.body();\n const user = await one<{ id: string }>(\"SELECT id FROM users WHERE id = ?\", [ctx.params.id]);\n if (!user) throw notFound(\"학생을 찾을 수 없습니다.\");\n\n const sets: string[] = [];\n const args: (string | null)[] = [];\n const put = (c: string, v: string | null) => {\n sets.push(`${c} = ?`);\n args.push(v);\n };\n\n if (body.seatNo !== undefined) put(\"seat_no\", optStr(body, \"seatNo\", 20));\n if (body.grade !== undefined) put(\"grade\", optStr(body, \"grade\", 20));\n if (body.school !== undefined) put(\"school\", optStr(body, \"school\", 60));\n if (body.target !== undefined) put(\"target\", optStr(body, \"target\", 120));\n if (body.phone !== undefined) put(\"phone\", optStr(body, \"phone\", 30));\n if (body.coachId !== undefined) put(\"coach_id\", optStr(body, \"coachId\", 60));\n if (body.status !== undefined) {\n put(\"status\", enumOf(body, \"status\", [\"active\", \"paused\", \"left\"] as const, \"active\"));\n }\n // 권한 변경은 관리자만.\n if (body.role !== undefined) {\n requireAdmin(ctx.user);\n put(\"role\", enumOf(body, \"role\", [\"student\", \"coach\", \"admin\"] as const, \"student\"));\n }\n\n if (!sets.length) throw badRequest(\"변경할 값이 없습니다.\");\n sets.push(\"updated_at = ?\");\n args.push(nowIso(), ctx.params.id);\n await exec(`UPDATE users SET ${sets.join(\", \")} WHERE id = ?`, args);\n await audit(ctx.user.id, \"student.update\", ctx.params.id, body);\n\n return json({ user: await one(\"SELECT * FROM users WHERE id = ?\", [ctx.params.id]) });\n });\n\n /** 관리쌤 목록 (담당 배정 셀렉트박스용) */\n r.get(\"/api/admin/staff\", \"staff\", async (ctx: Ctx) => {\n requireStaff(ctx.user);\n const rows = await query(\n \"SELECT id, name, email, role FROM users WHERE role IN ('coach','admin') ORDER BY name\",\n );\n return json({ staff: rows });\n });\n\n /** 공지 — 전체 또는 지정 학생에게 알림을 보낸다 */\n r.post(\"/api/admin/notices\", \"staff\", async (ctx: Ctx) => {\n requireStaff(ctx.user);\n const body = await ctx.body();\n const title = str(body, \"title\", { required: true, max: 120 });\n const message = str(body, \"body\", { max: 1000 });\n const targets = Array.isArray(body.studentIds) && body.studentIds.length\n ? (body.studentIds as string[]).slice(0, 500)\n : (await query<{ id: string }>(\n \"SELECT id FROM users WHERE role = 'student' AND status = 'active'\",\n )).map((r) => r.id);\n\n for (const id of targets) await notify(id, \"notice\", title, message, \"/index.html\");\n await audit(ctx.user.id, \"notice.send\", undefined, { title, count: targets.length });\n return json({ sent: targets.length });\n });\n\n /** 마이그레이션 실행 (Val Town 최초 세팅/스키마 추가 시) */\n r.post(\"/api/admin/migrate\", \"admin\", async (ctx: Ctx) => {\n requireAdmin(ctx.user);\n const result = await migrate();\n await audit(ctx.user.id, \"db.migrate\", undefined, result);\n return json(result);\n });\n\n r.get(\"/api/admin/audit\", \"admin\", async (ctx: Ctx) => {\n requireAdmin(ctx.user);\n const rows = await query(\n `SELECT a.*, u.name AS actor_name FROM audit_logs a\n LEFT JOIN users u ON u.id = a.actor_id\n ORDER BY a.created_at DESC LIMIT 200`,\n );\n return json({ logs: rows });\n });\n}\n",[],[137,218],"5432eda6-3455-4b48-aa81-236fbe678efe","_shared.ts","09507b02-ab26-11f1-9183-1607ee4eb77e",21,["D",1788831527798],"/**\n * 라우트 공통 헬퍼.\n */\nimport { isStaff } from \"../lib/auth.ts\";\nimport { Ctx, forbidden, notFound } from \"../lib/http.ts\";\nimport { exec, one, query, uuid } from \"../lib/sqlite.ts\";\nimport { nowIso } from \"../lib/time.ts\";\nimport { DEFAULT_SUBJECTS } from \"../db/schema.ts\";\n\n/**\n * 조회/수정 대상 학생을 정한다.\n * - 학생 : 항상 본인\n * - 관리쌤/관리자 : ?studentId= 로 다른 학생을 지정할 수 있다\n *\n * 학생이 남의 데이터를 보려고 studentId 를 넣으면 403.\n */\nexport function targetUserId(ctx: Ctx): string {\n const requested = ctx.query.get(\"studentId\");\n if (!requested || requested === ctx.user.id) return ctx.user.id;\n if (!isStaff(ctx.user)) throw forbidden(\"다른 학생의 데이터에 접근할 수 없습니다.\");\n return requested;\n}\n\n/** 본문에 studentId 가 들어오는 POST/PATCH 용 */\nexport function targetUserIdFromBody(ctx: Ctx, body: Record): string {\n const requested = typeof body.studentId === \"string\" ? body.studentId : null;\n if (!requested || requested === ctx.user.id) return ctx.user.id;\n if (!isStaff(ctx.user)) throw forbidden(\"다른 학생의 데이터를 수정할 수 없습니다.\");\n return requested;\n}\n\nexport interface SubjectRow {\n id: string;\n user_id: string;\n name: string;\n color: string;\n sort_order: number;\n archived: number;\n}\n\n/** 과목이 하나도 없는 신규 학생에게 기본 과목을 깔아준다. */\nexport async function ensureSubjects(userId: string): Promise {\n const rows = await query(\n \"SELECT * FROM subjects WHERE user_id = ? AND archived = 0 ORDER BY sort_order, name\",\n [userId],\n );\n if (rows.length) return rows;\n\n const now = nowIso();\n for (let i = 0; i < DEFAULT_SUBJECTS.length; i++) {\n const s = DEFAULT_SUBJECTS[i];\n await exec(\n \"INSERT INTO subjects (id, user_id, name, color, sort_order, archived, created_at) VALUES (?, ?, ?, ?, ?, 0, ?)\",\n [uuid(), userId, s.name, s.color, i, now],\n );\n }\n return await query(\n \"SELECT * FROM subjects WHERE user_id = ? AND archived = 0 ORDER BY sort_order, name\",\n [userId],\n );\n}\n\n/** 소유자 확인 후 행을 돌려준다. 없거나 남의 것이면 404/403. */\nexport async function ownedRow(\n table: string,\n id: string,\n ctx: Ctx,\n): Promise {\n const row = await one(`SELECT * FROM ${table} WHERE id = ?`, [id]);\n if (!row) throw notFound();\n if (row.user_id && row.user_id !== ctx.user.id && !isStaff(ctx.user)) {\n throw forbidden(\"본인 데이터만 수정할 수 있습니다.\");\n }\n return row;\n}\n\nexport async function notify(\n userId: string,\n type: string,\n title: string,\n body?: string,\n link?: string,\n): Promise {\n await exec(\n \"INSERT INTO notifications (id, user_id, type, title, body, link, created_at) VALUES (?, ?, ?, ?, ?, ?, ?)\",\n [uuid(), userId, type, title, body ?? null, link ?? null, nowIso()],\n );\n}\n\nexport async function audit(\n actorId: string,\n action: string,\n target?: string,\n meta?: unknown,\n): Promise {\n await exec(\n \"INSERT INTO audit_logs (id, actor_id, action, target, meta, created_at) VALUES (?, ?, ?, ?, ?, ?)\",\n [uuid(), actorId, action, target ?? null, meta ? JSON.stringify(meta) : null, nowIso()],\n );\n}\n",[],[137,226],["D",1788831524911],[236,237,238,239,240,241,242],[19],{"_40":100,"_13":101,"_43":102,"_45":46,"_47":48,"_49":103,"_51":52,"_53":261,"_17":105,"_56":57,"_58":106,"_60":61,"_62":-5,"_125":262,"_18":263},{"_40":93,"_13":94,"_43":95,"_45":46,"_47":48,"_49":96,"_51":52,"_53":258,"_17":55,"_56":57,"_58":98,"_60":61,"_62":-5,"_125":259,"_18":260},{"_40":86,"_13":87,"_43":88,"_45":46,"_47":48,"_49":89,"_51":52,"_53":255,"_17":55,"_56":57,"_58":91,"_60":61,"_62":-5,"_125":256,"_18":257},{"_40":78,"_13":79,"_43":80,"_45":46,"_47":48,"_49":81,"_51":52,"_53":252,"_17":83,"_56":57,"_58":84,"_60":61,"_62":-5,"_125":253,"_18":254},{"_40":71,"_13":72,"_43":73,"_45":46,"_47":48,"_49":74,"_51":52,"_53":249,"_17":55,"_56":57,"_58":76,"_60":61,"_62":-5,"_125":250,"_18":251},{"_40":64,"_13":65,"_43":66,"_45":46,"_47":48,"_49":67,"_51":52,"_53":246,"_17":55,"_56":57,"_58":69,"_60":61,"_62":-5,"_125":247,"_18":248},{"_40":41,"_13":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":243,"_17":55,"_56":57,"_58":59,"_60":61,"_62":-5,"_125":244,"_18":245},["D",1788831526112],[],[19,42],["D",1788831526935],[],[19,65],["D",1788831526144],[],[19,72],["D",1788831720182],[],[19,79],["D",1788831526436],[],[19,87],["D",1788831526216],[],[19,94],["D",1788841392119],[],[19,101],"1ab759e0-0152-48e1-8407-330dbb0c8088","db","07c0dc82-ab26-11f1-8306-1607ee4eb77e",["D",1788831525229],[270,271,272],[265],{"_40":289,"_13":290,"_43":291,"_45":266,"_47":48,"_49":292,"_51":52,"_53":293,"_17":55,"_56":57,"_58":294,"_60":61,"_62":-5,"_125":295,"_18":296},{"_40":281,"_13":282,"_43":283,"_45":266,"_47":48,"_49":284,"_51":52,"_53":285,"_17":55,"_56":57,"_58":286,"_60":61,"_62":-5,"_125":287,"_18":288},{"_40":273,"_13":274,"_43":275,"_45":266,"_47":48,"_49":276,"_51":52,"_53":277,"_17":55,"_56":57,"_58":278,"_60":61,"_62":-5,"_125":279,"_18":280},"3f856cc0-45ce-4120-bb92-946ca18a1a71","seed.ts","08c5d4ca-ab26-11f1-ba0e-1607ee4eb77e",14,["D",1788831526931],"/**\n * 로컬 개발용 시드. 운영에서는 실행하지 않는다.\n * deno task seed\n */\nimport \"../lib/env.ts\";\nimport { exec, one, query, uuid } from \"../lib/sqlite.ts\";\nimport { addDays, nowIso, toLocalDate } from \"../lib/time.ts\";\nimport { migrate } from \"./migrate.ts\";\nimport { DEFAULT_SUBJECTS } from \"./schema.ts\";\n\nconst STUDENT_ID = \"dev-student\";\nconst ADMIN_ID = \"dev-admin\";\n\nasync function upsertUser(\n id: string,\n name: string,\n role: string,\n extra: Record = {},\n) {\n const now = nowIso();\n const exists = await one(\"SELECT id FROM users WHERE id = ?\", [id]);\n if (exists) {\n await exec(\"UPDATE users SET name = ?, role = ?, updated_at = ? WHERE id = ?\", [\n name,\n role,\n now,\n id,\n ]);\n return;\n }\n await exec(\n `INSERT INTO users (id, email, name, role, status, school, grade, target, seat_no, created_at, updated_at)\n VALUES (?, ?, ?, ?, 'active', ?, ?, ?, ?, ?, ?)`,\n [\n id,\n `${id}@dev.local`,\n name,\n role,\n extra.school ?? null,\n extra.grade ?? null,\n extra.target ?? null,\n extra.seat ?? null,\n now,\n now,\n ],\n );\n}\n\nconst result = await migrate();\nconsole.log(\"마이그레이션:\", result.applied.length ? result.applied.join(\", \") : \"이미 적용됨\");\n\nawait upsertUser(ADMIN_ID, \"김관리\", \"admin\");\nawait upsertUser(STUDENT_ID, \"이학생\", \"student\", {\n school: \"로드맵고\",\n grade: \"고2\",\n target: \"서울대 컴퓨터공학과\",\n seat: \"A-14\",\n});\n\n// 과목\nconst subjectIds: string[] = [];\nfor (let i = 0; i < DEFAULT_SUBJECTS.length; i++) {\n const s = DEFAULT_SUBJECTS[i];\n const existing = await one<{ id: string }>(\n \"SELECT id FROM subjects WHERE user_id = ? AND name = ?\",\n [STUDENT_ID, s.name],\n );\n if (existing) {\n subjectIds.push(existing.id);\n continue;\n }\n const id = uuid();\n await exec(\n \"INSERT INTO subjects (id, user_id, name, color, sort_order, archived, created_at) VALUES (?, ?, ?, ?, ?, 0, ?)\",\n [id, STUDENT_ID, s.name, s.color, i, nowIso()],\n );\n subjectIds.push(id);\n}\n\n// 최근 14일 계획·세션·일기\nconst today = toLocalDate();\nconst already = await query(\"SELECT id FROM plans WHERE user_id = ? LIMIT 1\", [STUDENT_ID]);\nif (already.length) {\n console.log(\"이미 시드 데이터가 있습니다. 계획 생성은 건너뜁니다.\");\n} else {\n const titles = [\n [\"수능특강 독서 3강\", 60],\n [\"수학 미적분 유형편 20문항\", 90],\n [\"영단어 Day 12\", 30],\n [\"한국사 근현대 개념\", 45],\n [\"기출 오답 정리\", 50],\n ] as const;\n\n for (let d = 13; d >= 0; d--) {\n const date = addDays(today, -d);\n const count = 2 + (d % 3);\n for (let i = 0; i < count; i++) {\n const [title, goal] = titles[(d + i) % titles.length];\n const planId = uuid();\n const done = Math.random() > 0.3;\n const actual = done ? goal + Math.round((Math.random() - 0.5) * 20) : Math.round(goal * 0.4);\n const now = nowIso();\n\n await exec(\n `INSERT INTO plans (id, user_id, date, subject_id, title, goal_minutes, actual_minutes, status, priority, sort_order, created_by, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, 2, ?, ?, ?, ?)`,\n [\n planId,\n STUDENT_ID,\n date,\n subjectIds[(d + i) % subjectIds.length],\n title,\n goal,\n Math.max(0, actual),\n done ? \"done\" : \"todo\",\n i,\n STUDENT_ID,\n now,\n now,\n ],\n );\n if (actual > 0) {\n await exec(\n `INSERT INTO study_sessions (id, user_id, plan_id, date, started_at, ended_at, minutes, source, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, 'manual', ?)`,\n [\n uuid(),\n STUDENT_ID,\n planId,\n date,\n `${date}T10:00:00.000Z`,\n `${date}T11:00:00.000Z`,\n Math.max(0, actual),\n now,\n ],\n );\n }\n }\n\n if (d % 2 === 0) {\n await exec(\n `INSERT INTO diaries (id, user_id, date, mood, focus_score, content, keep_note, problem_note, try_note, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n uuid(),\n STUDENT_ID,\n date,\n 3 + (d % 3 === 0 ? 1 : 0),\n 3 + (d % 2),\n \"오늘은 수학에 시간을 많이 썼다. 미적분 유형이 아직 손에 안 익는다.\",\n \"계획한 분량을 거의 다 했다.\",\n \"쉬는 시간이 길어졌다.\",\n \"타이머를 켜고 50분 단위로 끊어보기.\",\n nowIso(),\n nowIso(),\n ],\n );\n }\n }\n console.log(\"계획·세션·일기 시드 완료\");\n}\n\nconsole.log(`\n시드 완료.\n 학생 토큰 : dev:${STUDENT_ID}:student\n 관리자 토큰: dev:${ADMIN_ID}:admin\n .env 에 AUTH_MODE=dev 로 두면 이 토큰으로 로그인할 수 있습니다.\n`);\n",[],[265,274],"4e4d5d4e-b2ed-4987-a594-9336aa870866","schema.ts","08b2b3b8-ab26-11f1-ba0e-1607ee4eb77e",12,["D",1788831526757],"/**\n * 스키마 SSOT.\n *\n * 규칙\n * - id 는 전부 TEXT(UUID). 자동증가 정수를 쓰지 않는다(환경 간 이관이 쉬움).\n * - 날짜는 'YYYY-MM-DD'(KST 기준), 시각은 ISO8601 UTC 문자열.\n * - 마이그레이션은 append-only. 기존 항목을 수정하지 말고 뒤에 추가한다.\n */\n\nexport interface Migration {\n id: string;\n statements: string[];\n}\n\nexport const MIGRATIONS: Migration[] = [\n {\n id: \"0001_init\",\n statements: [\n `CREATE TABLE IF NOT EXISTS users (\n id TEXT PRIMARY KEY, -- Firebase uid\n email TEXT,\n name TEXT NOT NULL DEFAULT '',\n phone TEXT,\n role TEXT NOT NULL DEFAULT 'student', -- student | coach | admin\n status TEXT NOT NULL DEFAULT 'active', -- active | paused | left\n school TEXT,\n grade TEXT,\n target TEXT, -- 목표 대학/시험\n seat_no TEXT, -- 독서실 좌석\n photo_url TEXT,\n coach_id TEXT, -- 담당 관리쌤\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL,\n last_login_at TEXT\n )`,\n `CREATE INDEX IF NOT EXISTS idx_users_role ON users(role, status)`,\n `CREATE INDEX IF NOT EXISTS idx_users_coach ON users(coach_id)`,\n\n `CREATE TABLE IF NOT EXISTS subjects (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n color TEXT NOT NULL DEFAULT '#4f46e5',\n sort_order INTEGER NOT NULL DEFAULT 0,\n archived INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_subjects_user ON subjects(user_id, archived, sort_order)`,\n\n `CREATE TABLE IF NOT EXISTS plans (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n date TEXT NOT NULL, -- YYYY-MM-DD\n subject_id TEXT,\n title TEXT NOT NULL,\n goal_minutes INTEGER NOT NULL DEFAULT 0,\n actual_minutes INTEGER NOT NULL DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'todo', -- todo | doing | done | skipped\n priority INTEGER NOT NULL DEFAULT 2, -- 1 높음 2 보통 3 낮음\n memo TEXT,\n sort_order INTEGER NOT NULL DEFAULT 0,\n created_by TEXT NOT NULL, -- 학생 본인 또는 관리쌤 uid\n completed_at TEXT,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_plans_user_date ON plans(user_id, date)`,\n `CREATE INDEX IF NOT EXISTS idx_plans_subject ON plans(subject_id)`,\n\n `CREATE TABLE IF NOT EXISTS study_sessions (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n plan_id TEXT,\n date TEXT NOT NULL,\n started_at TEXT NOT NULL,\n ended_at TEXT,\n minutes INTEGER NOT NULL DEFAULT 0,\n source TEXT NOT NULL DEFAULT 'timer', -- timer | manual\n created_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_sessions_user_date ON study_sessions(user_id, date)`,\n `CREATE INDEX IF NOT EXISTS idx_sessions_open ON study_sessions(user_id, ended_at)`,\n\n `CREATE TABLE IF NOT EXISTS diaries (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n date TEXT NOT NULL,\n mood INTEGER, -- 1..5\n focus_score INTEGER, -- 1..5\n content TEXT NOT NULL DEFAULT '',\n keep_note TEXT, -- 잘한 점\n problem_note TEXT, -- 아쉬운 점\n try_note TEXT, -- 내일 할 것\n coach_comment TEXT,\n coach_id TEXT,\n commented_at TEXT,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE UNIQUE INDEX IF NOT EXISTS uq_diary_user_date ON diaries(user_id, date)`,\n\n `CREATE TABLE IF NOT EXISTS schedule_events (\n id TEXT PRIMARY KEY,\n user_id TEXT, -- NULL 이면 전체 공지 일정\n title TEXT NOT NULL,\n type TEXT NOT NULL DEFAULT 'etc', -- exam | class | consult | holiday | etc\n start_at TEXT NOT NULL, -- ISO UTC\n end_at TEXT,\n all_day INTEGER NOT NULL DEFAULT 0,\n location TEXT,\n memo TEXT,\n created_by TEXT NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_events_user_start ON schedule_events(user_id, start_at)`,\n\n `CREATE TABLE IF NOT EXISTS chat_threads (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n title TEXT NOT NULL DEFAULT '새 대화',\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_threads_user ON chat_threads(user_id, updated_at DESC)`,\n\n `CREATE TABLE IF NOT EXISTS chat_messages (\n id TEXT PRIMARY KEY,\n thread_id TEXT NOT NULL,\n user_id TEXT NOT NULL,\n role TEXT NOT NULL, -- user | assistant\n content TEXT NOT NULL,\n tokens_in INTEGER NOT NULL DEFAULT 0,\n tokens_out INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_messages_thread ON chat_messages(thread_id, created_at)`,\n `CREATE INDEX IF NOT EXISTS idx_messages_user_day ON chat_messages(user_id, created_at)`,\n\n `CREATE TABLE IF NOT EXISTS consult_slots (\n id TEXT PRIMARY KEY,\n coach_id TEXT NOT NULL,\n start_at TEXT NOT NULL,\n end_at TEXT NOT NULL,\n capacity INTEGER NOT NULL DEFAULT 1,\n status TEXT NOT NULL DEFAULT 'open', -- open | closed\n memo TEXT,\n created_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_slots_start ON consult_slots(start_at, status)`,\n\n `CREATE TABLE IF NOT EXISTS consults (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n slot_id TEXT,\n category TEXT NOT NULL DEFAULT 'study', -- study | plan | mental | career | etc\n topic TEXT NOT NULL,\n content TEXT NOT NULL DEFAULT '',\n mode TEXT NOT NULL DEFAULT 'offline', -- offline | online | phone\n preferred_at TEXT,\n status TEXT NOT NULL DEFAULT 'requested', -- requested | scheduled | done | canceled\n coach_id TEXT,\n scheduled_at TEXT,\n coach_note TEXT,\n student_feedback TEXT,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_consults_user ON consults(user_id, created_at DESC)`,\n `CREATE INDEX IF NOT EXISTS idx_consults_status ON consults(status, created_at DESC)`,\n\n `CREATE TABLE IF NOT EXISTS notifications (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n type TEXT NOT NULL,\n title TEXT NOT NULL,\n body TEXT,\n link TEXT,\n read_at TEXT,\n created_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_notif_user ON notifications(user_id, read_at, created_at DESC)`,\n\n `CREATE TABLE IF NOT EXISTS audit_logs (\n id TEXT PRIMARY KEY,\n actor_id TEXT,\n action TEXT NOT NULL,\n target TEXT,\n meta TEXT,\n created_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_audit_created ON audit_logs(created_at DESC)`,\n ],\n },\n];\n\nexport const DEFAULT_SUBJECTS: Array<{ name: string; color: string }> = [\n { name: \"국어\", color: \"#ef4444\" },\n { name: \"수학\", color: \"#3b82f6\" },\n { name: \"영어\", color: \"#10b981\" },\n { name: \"탐구\", color: \"#f59e0b\" },\n { name: \"기타\", color: \"#8b5cf6\" },\n];\n",[],[265,282],"42980979-1a80-46a5-b031-ae98396bf820","migrate.ts","08b84e36-ab26-11f1-84f5-1607ee4eb77e",13,["D",1788831526829],"/**\n * 마이그레이션 실행기.\n * 적용된 마이그레이션 id 를 _migrations 에 기록해 멱등하게 만든다.\n *\n * 로컬: deno task migrate\n * Val Town: /api/admin/migrate (관리자) 또는 이 파일을 한 번 실행하는 val\n */\nimport \"../lib/env.ts\";\nimport { exec, execScript, query } from \"../lib/sqlite.ts\";\nimport { nowIso } from \"../lib/time.ts\";\nimport { MIGRATIONS } from \"./schema.ts\";\n\nexport async function migrate(): Promise<{ applied: string[]; skipped: string[] }> {\n await exec(\n `CREATE TABLE IF NOT EXISTS _migrations (\n id TEXT PRIMARY KEY,\n applied_at TEXT NOT NULL\n )`,\n );\n\n const done = new Set(\n (await query<{ id: string }>(\"SELECT id FROM _migrations\")).map((r) => r.id),\n );\n\n const applied: string[] = [];\n const skipped: string[] = [];\n\n for (const m of MIGRATIONS) {\n if (done.has(m.id)) {\n skipped.push(m.id);\n continue;\n }\n await execScript(m.statements);\n await exec(\"INSERT INTO _migrations (id, applied_at) VALUES (?, ?)\", [m.id, nowIso()]);\n applied.push(m.id);\n }\n\n return { applied, skipped };\n}\n\nif (import.meta.main) {\n const result = await migrate();\n console.log(\"적용:\", result.applied.length ? result.applied.join(\", \") : \"(없음)\");\n console.log(\"건너뜀:\", result.skipped.length ? result.skipped.join(\", \") : \"(없음)\");\n}\n",[],[265,290],"130359c1-3f85-42d1-853e-43f5d0e94aab","crons","07f16262-ab26-11f1-87f9-1607ee4eb77e",3,["D",1788831525524],[304],[298],{"_40":305,"_13":306,"_43":307,"_45":299,"_47":48,"_49":308,"_51":52,"_53":309,"_17":55,"_56":310,"_58":311,"_60":61,"_62":-5,"_125":312,"_18":313},"1cf511e8-e749-44bd-bc68-e750233a04ea","daily.ts","08df94be-ab26-11f1-ba6d-1607ee4eb77e",16,["D",1788831527099],"interval","/**\n * 매일 도는 크론 (Val Town Cron Val 로 등록. 권장 22:00 KST = 13:00 UTC).\n *\n * 하는 일\n * 1. 켜둔 채 잊은 타이머 정리 (12시간 상한으로 마감)\n * 2. 오늘 공부일기를 안 쓴 학생에게 알림\n * 3. 내일 상담이 잡힌 학생·관리쌤에게 알림\n *\n * Val Town 에서는 이 파일의 default export 가 스케줄러에 의해 호출된다.\n */\nimport \"../lib/env.ts\";\nimport { exec, query, uuid } from \"../lib/sqlite.ts\";\nimport { addDays, nowIso, toLocalDate } from \"../lib/time.ts\";\n\nasync function notify(userId: string, type: string, title: string, body: string, link: string) {\n await exec(\n \"INSERT INTO notifications (id, user_id, type, title, body, link, created_at) VALUES (?, ?, ?, ?, ?, ?, ?)\",\n [uuid(), userId, type, title, body, link, nowIso()],\n );\n}\n\nexport default async function daily(): Promise<\n { closedTimers: number; diaryReminders: number; consultReminders: number }\n> {\n const today = toLocalDate();\n const now = nowIso();\n\n // 1) 방치된 타이머 마감\n const openSessions = await query<{ id: string; started_at: string; plan_id: string | null }>(\n \"SELECT id, started_at, plan_id FROM study_sessions WHERE ended_at IS NULL\",\n );\n for (const s of openSessions) {\n const raw = Math.round((Date.now() - new Date(s.started_at).getTime()) / 60000);\n const minutes = Math.max(0, Math.min(raw, 720));\n await exec(\"UPDATE study_sessions SET ended_at = ?, minutes = ? WHERE id = ?\", [\n now,\n minutes,\n s.id,\n ]);\n if (s.plan_id) {\n await exec(\n `UPDATE plans SET actual_minutes =\n (SELECT COALESCE(SUM(minutes),0) FROM study_sessions WHERE plan_id = ? AND ended_at IS NOT NULL)\n WHERE id = ?`,\n [s.plan_id, s.plan_id],\n );\n }\n }\n\n // 2) 오늘 공부한 기록은 있는데 일기를 안 쓴 학생\n const missingDiary = await query<{ id: string; name: string }>(\n `SELECT u.id, u.name FROM users u\n WHERE u.role = 'student' AND u.status = 'active'\n AND EXISTS (SELECT 1 FROM study_sessions s WHERE s.user_id = u.id AND s.date = ?)\n AND NOT EXISTS (SELECT 1 FROM diaries d WHERE d.user_id = u.id AND d.date = ? AND d.content <> '')`,\n [today, today],\n );\n for (const u of missingDiary) {\n await notify(\n u.id,\n \"diary_reminder\",\n \"오늘 공부일기를 아직 안 썼어요\",\n \"5분이면 충분해요. 오늘 하루를 정리해 볼까요?\",\n `/diary.html?date=${today}`,\n );\n }\n\n // 3) 내일 상담 안내\n const tomorrow = addDays(today, 1);\n const consults = await query<\n { id: string; user_id: string; coach_id: string | null; topic: string; scheduled_at: string }\n >(\n `SELECT id, user_id, coach_id, topic, scheduled_at FROM consults\n WHERE status = 'scheduled' AND scheduled_at >= ? AND scheduled_at < ?`,\n [`${tomorrow}T00:00:00.000Z`, `${addDays(tomorrow, 1)}T00:00:00.000Z`],\n );\n for (const c of consults) {\n await notify(c.user_id, \"consult_reminder\", \"내일 상담이 있어요\", c.topic, \"/consult.html\");\n if (c.coach_id) {\n await notify(\n c.coach_id,\n \"consult_reminder\",\n \"내일 상담 일정\",\n c.topic,\n \"/admin.html#consults\",\n );\n }\n }\n\n return {\n closedTimers: openSessions.length,\n diaryReminders: missingDiary.length,\n consultReminders: consults.length,\n };\n}\n\nif (import.meta.main) console.log(await daily());\n",[],[298,306],"19e69952-e1a2-467a-8d0c-9197e6be008a",["D",1788831523479],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","관리형 독서실 학습 관리 API","imageUrl","userId","62e039ee-902a-49bb-8a64-406c241f4c74","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a07e6b-1ded-75cb-baf4-27bab987c121","tursoName","19e69952e1a2467a8d0c9197e6be008a","tursoHostname","19e69952e1a2467a8d0c9197e6be008a-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789529498250],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_370":366},"org",{"_11":12,"_364":12,"_365":366,"_324":325,"_367":368,"_369":61},"branch",{"_17":103,"_13":16,"_40":48,"_356":314,"_357":-5,"_358":-5,"_359":-5,"_360":-5,"_361":-5,"_362":14,"_363":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://lh3.googleusercontent.com/a/ACg8ocIP-2ZbzXrHkL2_NvgLmOKbrq2boZbhR3VJZY8_uH0a2c56-zs=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_40":314,"_13":14,"_53":496,"_316":-5,"_317":61,"_318":319,"_320":319,"_321":322,"_323":-5,"_324":325,"_326":80,"_327":52,"_328":-5,"_329":-5,"_330":55,"_331":332,"_333":334,"_335":336,"_337":497,"_339":-5,"_340":341,"_342":341,"_343":344,"_345":344,"_346":344,"_347":341,"_348":341,"_349":498,"_351":499,"_353":500,"_355":61},[415,417,421,429,440,441],"files",[415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441],"counts",{"_406":55,"_407":83,"_408":55,"_32":409,"_410":411},[392,393,394,395,396,397,398],{"_40":108,"_47":48,"_43":46,"_13":19,"_58":-5,"_56":109,"_17":55,"_45":-5,"_53":390,"_49":83,"_62":-5,"_18":391},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788831524911],[19],{"_40":100,"_13":101,"_43":102,"_45":46,"_47":48,"_49":103,"_51":52,"_53":104,"_17":105,"_56":57,"_58":106,"_60":61,"_62":-5,"_18":405},{"_40":93,"_13":94,"_43":95,"_45":46,"_47":48,"_49":96,"_51":52,"_53":97,"_17":55,"_56":57,"_58":98,"_60":61,"_62":-5,"_18":404},{"_40":86,"_13":87,"_43":88,"_45":46,"_47":48,"_49":89,"_51":52,"_53":90,"_17":55,"_56":57,"_58":91,"_60":61,"_62":-5,"_18":403},{"_40":78,"_13":79,"_43":80,"_45":46,"_47":48,"_49":81,"_51":52,"_53":82,"_17":83,"_56":57,"_58":84,"_60":61,"_62":-5,"_18":402},{"_40":71,"_13":72,"_43":73,"_45":46,"_47":48,"_49":74,"_51":52,"_53":75,"_17":55,"_56":57,"_58":76,"_60":61,"_62":-5,"_18":401},{"_40":64,"_13":65,"_43":66,"_45":46,"_47":48,"_49":67,"_51":52,"_53":68,"_17":55,"_56":57,"_58":69,"_60":61,"_62":-5,"_18":400},{"_40":41,"_13":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_17":55,"_56":57,"_58":59,"_60":61,"_62":-5,"_18":399},[19,42],[19,65],[19,72],[19,79],[19,87],[19,94],[19,101],"pulls","branches","forks",{"_412":50,"_414":55},"connections",{"_412":55,"_413":55},"count","unfilledCount","emptyCount",{"_40":297,"_13":298,"_43":299,"_45":-5,"_47":48,"_49":300,"_51":52,"_53":301,"_17":55,"_56":109,"_58":-5,"_60":61,"_62":-5,"_125":494,"_18":495},{"_40":305,"_13":306,"_43":307,"_45":299,"_47":48,"_49":308,"_51":52,"_53":309,"_17":55,"_56":310,"_58":311,"_60":61,"_62":-5,"_125":492,"_18":493},{"_40":264,"_13":265,"_43":266,"_45":-5,"_47":48,"_49":105,"_51":52,"_53":267,"_17":55,"_56":109,"_58":-5,"_60":61,"_62":-5,"_125":490,"_18":491},{"_40":289,"_13":290,"_43":291,"_45":266,"_47":48,"_49":292,"_51":52,"_53":293,"_17":55,"_56":57,"_58":294,"_60":61,"_62":-5,"_125":488,"_18":489},{"_40":281,"_13":282,"_43":283,"_45":266,"_47":48,"_49":284,"_51":52,"_53":285,"_17":55,"_56":57,"_58":286,"_60":61,"_62":-5,"_125":486,"_18":487},{"_40":273,"_13":274,"_43":275,"_45":266,"_47":48,"_49":276,"_51":52,"_53":277,"_17":55,"_56":57,"_58":278,"_60":61,"_62":-5,"_125":484,"_18":485},{"_40":108,"_13":19,"_43":46,"_45":-5,"_47":48,"_49":83,"_51":52,"_53":233,"_17":55,"_56":109,"_58":-5,"_60":61,"_62":-5,"_125":482,"_18":483},{"_40":100,"_13":101,"_43":102,"_45":46,"_47":48,"_49":103,"_51":52,"_53":261,"_17":105,"_56":57,"_58":106,"_60":61,"_62":-5,"_125":480,"_18":481},{"_40":93,"_13":94,"_43":95,"_45":46,"_47":48,"_49":96,"_51":52,"_53":258,"_17":55,"_56":57,"_58":98,"_60":61,"_62":-5,"_125":478,"_18":479},{"_40":86,"_13":87,"_43":88,"_45":46,"_47":48,"_49":89,"_51":52,"_53":255,"_17":55,"_56":57,"_58":91,"_60":61,"_62":-5,"_125":476,"_18":477},{"_40":78,"_13":79,"_43":80,"_45":46,"_47":48,"_49":81,"_51":52,"_53":252,"_17":83,"_56":57,"_58":84,"_60":61,"_62":-5,"_125":474,"_18":475},{"_40":71,"_13":72,"_43":73,"_45":46,"_47":48,"_49":74,"_51":52,"_53":249,"_17":55,"_56":57,"_58":76,"_60":61,"_62":-5,"_125":472,"_18":473},{"_40":64,"_13":65,"_43":66,"_45":46,"_47":48,"_49":67,"_51":52,"_53":246,"_17":55,"_56":57,"_58":69,"_60":61,"_62":-5,"_125":470,"_18":471},{"_40":41,"_13":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":243,"_17":55,"_56":57,"_58":59,"_60":61,"_62":-5,"_125":468,"_18":469},{"_40":136,"_13":137,"_43":138,"_45":-5,"_47":48,"_49":139,"_51":52,"_53":140,"_17":55,"_56":109,"_58":-5,"_60":61,"_62":-5,"_125":466,"_18":467},{"_40":225,"_13":226,"_43":227,"_45":138,"_47":48,"_49":228,"_51":52,"_53":229,"_17":55,"_56":57,"_58":230,"_60":61,"_62":-5,"_125":464,"_18":465},{"_40":217,"_13":218,"_43":219,"_45":138,"_47":48,"_49":220,"_51":52,"_53":221,"_17":55,"_56":57,"_58":222,"_60":61,"_62":-5,"_125":462,"_18":463},{"_40":209,"_13":210,"_43":211,"_45":138,"_47":48,"_49":212,"_51":52,"_53":213,"_17":55,"_56":57,"_58":214,"_60":61,"_62":-5,"_125":460,"_18":461},{"_40":201,"_13":202,"_43":203,"_45":138,"_47":48,"_49":204,"_51":52,"_53":205,"_17":55,"_56":57,"_58":206,"_60":61,"_62":-5,"_125":458,"_18":459},{"_40":193,"_13":194,"_43":195,"_45":138,"_47":48,"_49":196,"_51":52,"_53":197,"_17":55,"_56":57,"_58":198,"_60":61,"_62":-5,"_125":456,"_18":457},{"_40":185,"_13":186,"_43":187,"_45":138,"_47":48,"_49":188,"_51":52,"_53":189,"_17":55,"_56":57,"_58":190,"_60":61,"_62":-5,"_125":454,"_18":455},{"_40":177,"_13":178,"_43":179,"_45":138,"_47":48,"_49":180,"_51":52,"_53":181,"_17":55,"_56":57,"_58":182,"_60":61,"_62":-5,"_125":452,"_18":453},{"_40":169,"_13":170,"_43":171,"_45":138,"_47":48,"_49":172,"_51":52,"_53":173,"_17":55,"_56":57,"_58":174,"_60":61,"_62":-5,"_125":450,"_18":451},{"_40":161,"_13":162,"_43":163,"_45":138,"_47":48,"_49":164,"_51":52,"_53":165,"_17":55,"_56":57,"_58":166,"_60":61,"_62":-5,"_125":448,"_18":449},{"_40":153,"_13":154,"_43":155,"_45":138,"_47":48,"_49":156,"_51":52,"_53":157,"_17":55,"_56":57,"_58":158,"_60":61,"_62":-5,"_125":446,"_18":447},{"_40":128,"_13":129,"_43":130,"_45":-5,"_47":48,"_49":131,"_51":52,"_53":132,"_17":55,"_56":57,"_58":133,"_60":61,"_62":-5,"_125":444,"_18":445},{"_40":118,"_13":119,"_43":120,"_45":-5,"_47":48,"_49":121,"_51":52,"_53":122,"_17":83,"_56":123,"_58":124,"_60":61,"_62":-5,"_125":442,"_18":443},[],[119],[],[129],[],[137,154],[],[137,162],[],[137,170],[],[137,178],[],[137,186],[],[137,194],[],[137,202],[],[137,210],[],[137,218],[],[137,226],[430,431,432,433,434,435,436,437,438,439],[137],[],[19,42],[],[19,65],[],[19,72],[],[19,79],[],[19,87],[],[19,94],[],[19,101],[422,423,424,425,426,427,428],[19],[],[265,274],[],[265,282],[],[265,290],[418,419,420],[265],[],[298,306],[416],[298],["D",1788831523479],["D",1789529498250],{"_11":12,"_370":366},{"_11":12,"_364":12,"_365":366,"_324":325,"_367":368,"_369":61},{"_17":103,"_13":16,"_40":48,"_356":314,"_357":-5,"_358":-5,"_359":-5,"_360":-5,"_361":-5,"_362":14,"_363":12},"ctx",{"_349":-5,"_387":534,"_535":536,"_537":538,"_539":61,"_540":61,"_541":61,"_542":52,"_543":-5,"_544":-7,"_545":-7,"_546":55,"_547":61,"_548":61,"_549":-5,"_550":61,"_551":61,"_552":61,"_553":-5},"ENV",{"_505":506,"_507":508,"_509":16,"_510":511,"_512":513,"_514":515,"_516":517,"_518":519,"_520":521,"_522":523,"_524":525,"_526":527,"_528":529,"_530":531,"_532":533},"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"]