[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_108":109,"_110":111},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","marketadapter","name","roadmap-api","path","routes/planner.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":38,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/marketadapter/roadmap-api/code/routes/planner.ts","extension","id","937fa45b-caf5-4b57-99f8-361706e0ab0a","planner.ts","fileId","09dab6e6-ab26-11f1-a201-1607ee4eb77e","parentId","0819cf40-ab26-11f1-87f9-1607ee4eb77e","branchId","964f7637-562b-4945-9c69-b20a92bec2d0","branchVersion",25,"latest",true,"createdAt",["D",1788831528381],"version",0,"fileType","script","content","/**\n * 플래너 — 일별 계획 + 공부 타이머.\n *\n * 실제 공부 시간은 study_sessions 가 원장(ledger)이고,\n * plans.actual_minutes 는 화면용 합계 캐시다. 세션이 끝날 때마다 다시 계산해 채운다.\n */\nimport { badRequest, Ctx, json, notFound, Router } from \"../lib/http.ts\";\nimport { exec, one, query, scalar, uuid } from \"../lib/sqlite.ts\";\nimport { addDays, nowIso, toLocalDate } from \"../lib/time.ts\";\nimport { dateOf, enumOf, int, optStr, str } from \"../lib/validate.ts\";\nimport { audit, ensureSubjects, ownedRow, targetUserId, targetUserIdFromBody } from \"./_shared.ts\";\n\nconst STATUSES = [\"todo\", \"doing\", \"done\", \"skipped\"] as const;\n\ninterface PlanRow {\n id: string;\n user_id: string;\n date: string;\n subject_id: string | null;\n title: string;\n goal_minutes: number;\n actual_minutes: number;\n status: string;\n priority: number;\n memo: string | null;\n sort_order: number;\n}\n\ninterface SessionRow {\n id: string;\n user_id: string;\n plan_id: string | null;\n date: string;\n started_at: string;\n ended_at: string | null;\n minutes: number;\n}\n\n/** plans.actual_minutes 를 세션 합계로 다시 계산한다. */\nasync function recalcPlanMinutes(planId: string): Promise {\n const total = await scalar(\n \"SELECT COALESCE(SUM(minutes), 0) FROM study_sessions WHERE plan_id = ? AND ended_at IS NOT NULL\",\n [planId],\n );\n const minutes = Number(total ?? 0);\n await exec(\"UPDATE plans SET actual_minutes = ?, updated_at = ? WHERE id = ?\", [\n minutes,\n nowIso(),\n planId,\n ]);\n return minutes;\n}\n\nasync function runningSession(userId: string): Promise {\n return await one(\n \"SELECT * FROM study_sessions WHERE user_id = ? AND ended_at IS NULL ORDER BY started_at DESC LIMIT 1\",\n [userId],\n );\n}\n\nexport function register(r: Router): void {\n /* ── 과목 ─────────────────────────────────────────── */\n\n r.get(\"/api/subjects\", \"user\", async (ctx: Ctx) => {\n const userId = targetUserId(ctx);\n return json({ subjects: await ensureSubjects(userId) });\n });\n\n r.post(\"/api/subjects\", \"user\", async (ctx: Ctx) => {\n const body = await ctx.body();\n const userId = targetUserIdFromBody(ctx, body);\n const id = uuid();\n const order = Number(\n await scalar(\"SELECT COALESCE(MAX(sort_order), -1) + 1 FROM subjects WHERE user_id = ?\", [\n userId,\n ]) ?? 0,\n );\n await exec(\n \"INSERT INTO subjects (id, user_id, name, color, sort_order, archived, created_at) VALUES (?, ?, ?, ?, ?, 0, ?)\",\n [\n id,\n userId,\n str(body, \"name\", { required: true, max: 30 }),\n str(body, \"color\", { max: 20, default: \"#4f46e5\" }),\n order,\n nowIso(),\n ],\n );\n return json({ subject: await one(\"SELECT * FROM subjects WHERE id = ?\", [id]) }, 201);\n });\n\n r.patch(\"/api/subjects/:id\", \"user\", async (ctx: Ctx) => {\n const body = await ctx.body();\n await ownedRow(\"subjects\", ctx.params.id, ctx);\n const name = optStr(body, \"name\", 30);\n const color = optStr(body, \"color\", 20);\n const sets: string[] = [];\n const args: (string | number | null)[] = [];\n if (name) sets.push(\"name = ?\"), args.push(name);\n if (color) sets.push(\"color = ?\"), args.push(color);\n if (typeof body.sortOrder === \"number\") {\n sets.push(\"sort_order = ?\"), args.push(int(body, \"sortOrder\", { min: 0, max: 999 }));\n }\n if (!sets.length) throw badRequest(\"변경할 값이 없습니다.\");\n args.push(ctx.params.id);\n await exec(`UPDATE subjects SET ${sets.join(\", \")} WHERE id = ?`, args);\n return json({ subject: await one(\"SELECT * FROM subjects WHERE id = ?\", [ctx.params.id]) });\n });\n\n /** 과목은 실제로 지우지 않는다 — 지난 계획이 참조하고 있어서 통계가 깨진다. */\n r.del(\"/api/subjects/:id\", \"user\", async (ctx: Ctx) => {\n await ownedRow(\"subjects\", ctx.params.id, ctx);\n await exec(\"UPDATE subjects SET archived = 1 WHERE id = ?\", [ctx.params.id]);\n return json({ ok: true });\n });\n\n /* ── 하루 플래너 ──────────────────────────────────── */\n\n r.get(\"/api/planner\", \"user\", async (ctx: Ctx) => {\n const userId = targetUserId(ctx);\n const date = ctx.query.get(\"date\") ?? toLocalDate();\n\n const plans = await query(\n \"SELECT * FROM plans WHERE user_id = ? AND date = ? ORDER BY sort_order, created_at\",\n [userId, date],\n );\n const subjects = await ensureSubjects(userId);\n const sessions = await query(\n \"SELECT * FROM study_sessions WHERE user_id = ? AND date = ? ORDER BY started_at\",\n [userId, date],\n );\n\n const goal = plans.reduce((s, p) => s + p.goal_minutes, 0);\n const actual = sessions\n .filter((s) => s.ended_at)\n .reduce((s, x) => s + x.minutes, 0);\n const done = plans.filter((p) => p.status === \"done\").length;\n\n return json({\n date,\n plans,\n subjects,\n sessions,\n running: await runningSession(userId),\n summary: {\n goalMinutes: goal,\n actualMinutes: actual,\n total: plans.length,\n done,\n rate: plans.length ? Math.round((done / plans.length) * 100) : 0,\n },\n });\n });\n\n r.post(\"/api/planner/plans\", \"user\", async (ctx: Ctx) => {\n const body = await ctx.body();\n const userId = targetUserIdFromBody(ctx, body);\n const date = dateOf(body, \"date\", toLocalDate());\n const id = uuid();\n const now = nowIso();\n const order = Number(\n await scalar(\n \"SELECT COALESCE(MAX(sort_order), -1) + 1 FROM plans WHERE user_id = ? AND date = ?\",\n [userId, date],\n ) ?? 0,\n );\n\n await exec(\n `INSERT INTO plans\n (id, user_id, date, subject_id, title, goal_minutes, actual_minutes, status, priority, memo, sort_order, created_by, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, 0, 'todo', ?, ?, ?, ?, ?, ?)`,\n [\n id,\n userId,\n date,\n optStr(body, \"subjectId\", 40),\n str(body, \"title\", { required: true, max: 200 }),\n int(body, \"goalMinutes\", { min: 0, max: 1440, default: 0 }),\n int(body, \"priority\", { min: 1, max: 3, default: 2 }),\n optStr(body, \"memo\", 1000),\n order,\n ctx.user.id,\n now,\n now,\n ],\n );\n return json({ plan: await one(\"SELECT * FROM plans WHERE id = ?\", [id]) }, 201);\n });\n\n r.patch(\"/api/planner/plans/:id\", \"user\", async (ctx: Ctx) => {\n const body = await ctx.body();\n const plan = await ownedRow(\"plans\", ctx.params.id, ctx);\n\n const sets: string[] = [];\n const args: (string | number | null)[] = [];\n const put = (col: string, val: string | number | null) => {\n sets.push(`${col} = ?`);\n args.push(val);\n };\n\n if (body.title !== undefined) put(\"title\", str(body, \"title\", { required: true, max: 200 }));\n if (body.subjectId !== undefined) put(\"subject_id\", optStr(body, \"subjectId\", 40));\n if (body.goalMinutes !== undefined) {\n put(\"goal_minutes\", int(body, \"goalMinutes\", { min: 0, max: 1440 }));\n }\n if (body.memo !== undefined) put(\"memo\", optStr(body, \"memo\", 1000));\n if (body.priority !== undefined) put(\"priority\", int(body, \"priority\", { min: 1, max: 3 }));\n if (body.sortOrder !== undefined) {\n put(\"sort_order\", int(body, \"sortOrder\", { min: 0, max: 999 }));\n }\n if (body.date !== undefined) put(\"date\", dateOf(body, \"date\"));\n if (body.status !== undefined) {\n const status = enumOf(body, \"status\", STATUSES, \"todo\");\n put(\"status\", status);\n put(\"completed_at\", status === \"done\" ? nowIso() : null);\n }\n /** 타이머 없이 직접 시간을 입력하는 경우 — 보정 세션으로 기록해 원장을 유지한다. */\n if (body.actualMinutes !== undefined) {\n const target = int(body, \"actualMinutes\", { min: 0, max: 1440 });\n const diff = target - plan.actual_minutes;\n if (diff !== 0) {\n const now = nowIso();\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 [uuid(), plan.user_id, plan.id, plan.date, now, now, diff, now],\n );\n }\n put(\"actual_minutes\", target);\n }\n\n if (!sets.length) throw badRequest(\"변경할 값이 없습니다.\");\n sets.push(\"updated_at = ?\");\n args.push(nowIso(), ctx.params.id);\n await exec(`UPDATE plans SET ${sets.join(\", \")} WHERE id = ?`, args);\n\n return json({ plan: await one(\"SELECT * FROM plans WHERE id = ?\", [ctx.params.id]) });\n });\n\n r.del(\"/api/planner/plans/:id\", \"user\", async (ctx: Ctx) => {\n await ownedRow(\"plans\", ctx.params.id, ctx);\n await exec(\"UPDATE study_sessions SET plan_id = NULL WHERE plan_id = ?\", [ctx.params.id]);\n await exec(\"DELETE FROM plans WHERE id = ?\", [ctx.params.id]);\n return json({ ok: true });\n });\n\n /** 어제(또는 지정일) 계획을 오늘로 복사 — 미완료 항목만. */\n r.post(\"/api/planner/copy\", \"user\", async (ctx: Ctx) => {\n const body = await ctx.body();\n const userId = targetUserIdFromBody(ctx, body);\n const to = dateOf(body, \"to\", toLocalDate());\n const from = dateOf(body, \"from\", addDays(to, -1));\n const onlyUnfinished = body.onlyUnfinished !== false;\n\n const src = await query(\n `SELECT * FROM plans WHERE user_id = ? AND date = ? ${\n onlyUnfinished ? \"AND status <> 'done'\" : \"\"\n } ORDER BY sort_order`,\n [userId, from],\n );\n if (!src.length) return json({ copied: 0 });\n\n let order = Number(\n await scalar(\n \"SELECT COALESCE(MAX(sort_order), -1) + 1 FROM plans WHERE user_id = ? AND date = ?\",\n [userId, to],\n ) ?? 0,\n );\n const now = nowIso();\n for (const p of src) {\n await exec(\n `INSERT INTO plans\n (id, user_id, date, subject_id, title, goal_minutes, actual_minutes, status, priority, memo, sort_order, created_by, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, 0, 'todo', ?, ?, ?, ?, ?, ?)`,\n [\n uuid(),\n userId,\n to,\n p.subject_id,\n p.title,\n p.goal_minutes,\n p.priority,\n p.memo,\n order++,\n ctx.user.id,\n now,\n now,\n ],\n );\n }\n return json({ copied: src.length });\n });\n\n /* ── 타이머 ───────────────────────────────────────── */\n\n r.get(\"/api/planner/timer\", \"user\", async (ctx: Ctx) => {\n return json({ running: await runningSession(targetUserId(ctx)) });\n });\n\n r.post(\"/api/planner/timer/start\", \"user\", async (ctx: Ctx) => {\n const body = await ctx.body();\n const userId = targetUserIdFromBody(ctx, body);\n\n // 이미 돌고 있는 타이머가 있으면 먼저 닫는다(브라우저를 그냥 닫은 경우 대비).\n const open = await runningSession(userId);\n if (open) await stopSession(open);\n\n const planId = optStr(body, \"planId\", 40);\n if (planId) {\n const plan = await one(\"SELECT * FROM plans WHERE id = ? AND user_id = ?\", [\n planId,\n userId,\n ]);\n if (!plan) throw notFound(\"해당 계획을 찾을 수 없습니다.\");\n await exec(\n \"UPDATE plans SET status = 'doing', updated_at = ? WHERE id = ? AND status = 'todo'\",\n [\n nowIso(),\n planId,\n ],\n );\n }\n\n const id = uuid();\n const now = nowIso();\n await exec(\n `INSERT INTO study_sessions (id, user_id, plan_id, date, started_at, minutes, source, created_at)\n VALUES (?, ?, ?, ?, ?, 0, 'timer', ?)`,\n [id, userId, planId, toLocalDate(), now, now],\n );\n return json({ session: await one(\"SELECT * FROM study_sessions WHERE id = ?\", [id]) }, 201);\n });\n\n r.post(\"/api/planner/timer/stop\", \"user\", async (ctx: Ctx) => {\n const body = await ctx.body();\n const userId = targetUserIdFromBody(ctx, body);\n const open = await runningSession(userId);\n if (!open) throw badRequest(\"실행 중인 타이머가 없습니다.\");\n\n const minutes = await stopSession(open);\n return json({\n session: await one(\"SELECT * FROM study_sessions WHERE id = ?\", [open.id]),\n minutes,\n });\n });\n\n /** 타이머 없이 공부 시간만 기록 */\n r.post(\"/api/planner/sessions\", \"user\", async (ctx: Ctx) => {\n const body = await ctx.body();\n const userId = targetUserIdFromBody(ctx, body);\n const date = dateOf(body, \"date\", toLocalDate());\n const minutes = int(body, \"minutes\", { required: true, min: 1, max: 1440 });\n const planId = optStr(body, \"planId\", 40);\n const now = nowIso();\n\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 [uuid(), userId, planId, date, now, now, minutes, now],\n );\n if (planId) await recalcPlanMinutes(planId);\n return json({ ok: true, minutes }, 201);\n });\n\n r.del(\"/api/planner/sessions/:id\", \"user\", async (ctx: Ctx) => {\n const session = await ownedRow(\"study_sessions\", ctx.params.id, ctx);\n await exec(\"DELETE FROM study_sessions WHERE id = ?\", [ctx.params.id]);\n if (session.plan_id) await recalcPlanMinutes(session.plan_id);\n await audit(ctx.user.id, \"session.delete\", ctx.params.id);\n return json({ ok: true });\n });\n}\n\n/** 열린 세션을 닫고 분을 계산해 저장한다. */\nasync function stopSession(session: SessionRow): Promise {\n const ended = new Date();\n const started = new Date(session.started_at);\n // 12시간을 넘기면 타이머를 켜둔 채 잊은 것으로 보고 상한을 건다.\n const raw = Math.round((ended.getTime() - started.getTime()) / 60000);\n const minutes = Math.max(0, Math.min(raw, 720));\n\n await exec(\"UPDATE study_sessions SET ended_at = ?, minutes = ? WHERE id = ?\", [\n ended.toISOString(),\n minutes,\n session.id,\n ]);\n if (session.plan_id) await recalcPlanMinutes(session.plan_id);\n return minutes;\n}\n","deleted",false,"label",[47,24],"routes","19e69952-e1a2-467a-8d0c-9197e6be008a",["D",1788831523479],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","관리형 독서실 학습 관리 API","imageUrl","userId","62e039ee-902a-49bb-8a64-406c241f4c74","pinnedFileId","08a8e9dc-ab26-11f1-b9b1-1607ee4eb77e","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",{"_9":10,"_107":103},"org",{"_9":10,"_101":10,"_102":103,"_58":59,"_104":105,"_106":44},"branch",{"_37":91,"_11":92,"_22":30,"_93":48,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":12,"_100":10},"isOwned",33,"main","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","ctx",{"_84":-5,"_141":142,"_143":144,"_145":146,"_147":44,"_148":44,"_149":44,"_150":34,"_151":-5,"_152":-7,"_153":-7,"_154":38,"_155":44,"_156":44,"_157":-5,"_158":44,"_159":44,"_160":44,"_161":-5},"ENV",{"_112":113,"_114":115,"_116":92,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138,"_139":140},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]