[{"_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/consult.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/consult.ts","extension","id","7fdf68c6-8911-4503-b323-bc8f8a293dbb","consult.ts","fileId","0948c150-ab26-11f1-8eff-1607ee4eb77e","parentId","0819cf40-ab26-11f1-87f9-1607ee4eb77e","branchId","964f7637-562b-4945-9c69-b20a92bec2d0","branchVersion",20,"latest",true,"createdAt",["D",1788831527798],"version",0,"fileType","script","content","/**\n * 학습 상담 신청 / 관리 (신규 기능).\n *\n * 흐름\n * 학생: 신청(requested) → 관리쌤이 슬롯 배정(scheduled) → 상담 후 기록(done)\n * 취소는 양쪽 다 가능(canceled).\n *\n * 슬롯은 \"관리쌤이 열어둔 상담 가능 시간\"이고, 정원(capacity)까지 예약을 받는다.\n */\nimport { isStaff, requireStaff } from \"../lib/auth.ts\";\nimport { badRequest, Ctx, forbidden, json, notFound, Router } from \"../lib/http.ts\";\nimport { exec, one, query, scalar, uuid } from \"../lib/sqlite.ts\";\nimport { nowIso } from \"../lib/time.ts\";\nimport { enumOf, isoOf, optStr, str } from \"../lib/validate.ts\";\nimport { audit, notify } from \"./_shared.ts\";\n\nconst CATEGORIES = [\"study\", \"plan\", \"mental\", \"career\", \"etc\"] as const;\nconst MODES = [\"offline\", \"online\", \"phone\"] as const;\nconst STATUSES = [\"requested\", \"scheduled\", \"done\", \"canceled\"] as const;\n\ninterface ConsultRow {\n id: string;\n user_id: string;\n slot_id: string | null;\n status: string;\n topic: string;\n coach_id: string | null;\n scheduled_at: string | null;\n}\n\ninterface SlotRow {\n id: string;\n coach_id: string;\n start_at: string;\n end_at: string;\n capacity: number;\n status: string;\n}\n\n/** 슬롯의 남은 자리. 취소된 건은 자리를 돌려준다. */\nasync function slotRemaining(slot: SlotRow): Promise {\n const used = Number(\n await scalar(\n \"SELECT COUNT(*) FROM consults WHERE slot_id = ? AND status IN ('requested','scheduled','done')\",\n [slot.id],\n ) ?? 0,\n );\n return Math.max(0, slot.capacity - used);\n}\n\nexport function register(r: Router): void {\n /* ── 학생 ─────────────────────────────────────────── */\n\n /** 예약 가능한 슬롯 (지금 이후, 열려 있고 자리가 남은 것) */\n r.get(\"/api/consults/slots\", \"user\", async (_ctx: Ctx) => {\n const slots = await query(\n `SELECT s.*, u.name AS coach_name\n FROM consult_slots s LEFT JOIN users u ON u.id = s.coach_id\n WHERE s.status = 'open' AND s.start_at >= ?\n ORDER BY s.start_at LIMIT 100`,\n [nowIso()],\n );\n const withRemaining = [];\n for (const s of slots) {\n const remaining = await slotRemaining(s);\n if (remaining > 0) withRemaining.push({ ...s, remaining });\n }\n return json({ slots: withRemaining });\n });\n\n /** 내 신청 목록 (관리쌤은 ?all=1 로 전체) */\n r.get(\"/api/consults\", \"user\", async (ctx: Ctx) => {\n const all = ctx.query.get(\"all\") === \"1\";\n if (all && !isStaff(ctx.user)) throw forbidden(\"전체 목록은 관리자만 볼 수 있습니다.\");\n\n const status = ctx.query.get(\"status\");\n if (status && !STATUSES.includes(status as typeof STATUSES[number])) {\n throw badRequest(\"status 값이 올바르지 않습니다.\");\n }\n\n const where: string[] = [];\n const args: string[] = [];\n if (!all) {\n where.push(\"c.user_id = ?\");\n args.push(ctx.user.id);\n }\n if (status) {\n where.push(\"c.status = ?\");\n args.push(status);\n }\n\n const rows = await query(\n `SELECT c.*, u.name AS student_name, u.grade AS student_grade, u.seat_no,\n co.name AS coach_name,\n s.start_at AS slot_start, s.end_at AS slot_end\n FROM consults c\n JOIN users u ON u.id = c.user_id\n LEFT JOIN users co ON co.id = c.coach_id\n LEFT JOIN consult_slots s ON s.id = c.slot_id\n ${where.length ? `WHERE ${where.join(\" AND \")}` : \"\"}\n ORDER BY CASE c.status WHEN 'requested' THEN 0 WHEN 'scheduled' THEN 1 ELSE 2 END,\n c.created_at DESC\n LIMIT 200`,\n args,\n );\n return json({ consults: rows });\n });\n\n r.get(\"/api/consults/:id\", \"user\", async (ctx: Ctx) => {\n const row = await one(\"SELECT * FROM consults WHERE id = ?\", [ctx.params.id]);\n if (!row) throw notFound();\n if (row.user_id !== ctx.user.id && !isStaff(ctx.user)) throw forbidden();\n return json({ consult: row });\n });\n\n /** 상담 신청 */\n r.post(\"/api/consults\", \"user\", async (ctx: Ctx) => {\n const body = await ctx.body();\n\n // 처리 중인 신청이 이미 있으면 막는다(중복 신청으로 대기열이 오염되는 것 방지).\n const open = await scalar(\n \"SELECT COUNT(*) FROM consults WHERE user_id = ? AND status IN ('requested','scheduled')\",\n [ctx.user.id],\n );\n if (Number(open ?? 0) >= 3) {\n throw badRequest(\"진행 중인 상담 신청이 3건 있습니다. 처리 후 다시 신청해 주세요.\");\n }\n\n const slotId = optStr(body, \"slotId\", 40);\n let scheduledAt: string | null = null;\n if (slotId) {\n const slot = await one(\"SELECT * FROM consult_slots WHERE id = ?\", [slotId]);\n if (!slot || slot.status !== \"open\") throw badRequest(\"선택한 시간을 예약할 수 없습니다.\");\n if (await slotRemaining(slot) <= 0) throw badRequest(\"선택한 시간의 자리가 찼습니다.\");\n scheduledAt = slot.start_at;\n }\n\n const id = uuid();\n const now = nowIso();\n await exec(\n `INSERT INTO consults (id, user_id, slot_id, category, topic, content, mode, preferred_at, status, coach_id, scheduled_at, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n id,\n ctx.user.id,\n slotId,\n enumOf(body, \"category\", CATEGORIES, \"study\"),\n str(body, \"topic\", { required: true, max: 200 }),\n str(body, \"content\", { max: 3000 }),\n enumOf(body, \"mode\", MODES, \"offline\"),\n isoOf(body, \"preferredAt\"),\n slotId ? \"scheduled\" : \"requested\",\n slotId\n ? (await one(\"SELECT * FROM consult_slots WHERE id = ?\", [slotId]))?.coach_id ??\n null\n : null,\n scheduledAt,\n now,\n now,\n ],\n );\n\n // 관리쌤 전원에게 알림 — 대기열을 놓치지 않게.\n const staff = await query<{ id: string }>(\n \"SELECT id FROM users WHERE role IN ('admin','coach') AND status = 'active'\",\n );\n for (const s of staff) {\n await notify(\n s.id,\n \"consult_request\",\n \"새 상담 신청\",\n `${ctx.user.name || \"학생\"} · ${str(body, \"topic\", { max: 200 })}`,\n \"/admin.html#consults\",\n );\n }\n await audit(ctx.user.id, \"consult.create\", id);\n\n return json({ consult: await one(\"SELECT * FROM consults WHERE id = ?\", [id]) }, 201);\n });\n\n /** 학생 취소 / 후기 */\n r.patch(\"/api/consults/:id\", \"user\", async (ctx: Ctx) => {\n const body = await ctx.body();\n const row = await one(\"SELECT * FROM consults WHERE id = ?\", [ctx.params.id]);\n if (!row) throw notFound();\n\n const staff = isStaff(ctx.user);\n if (row.user_id !== ctx.user.id && !staff) throw forbidden();\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.status !== undefined) {\n const status = enumOf(body, \"status\", STATUSES, \"requested\");\n // 학생은 취소만 가능하다. 배정·완료는 관리쌤 몫.\n if (!staff && status !== \"canceled\") throw forbidden(\"상태 변경은 관리쌤만 할 수 있습니다.\");\n if (row.status === \"done\" && !staff) throw badRequest(\"완료된 상담은 변경할 수 없습니다.\");\n put(\"status\", status);\n if (status === \"canceled\") put(\"slot_id\", null);\n }\n if (body.studentFeedback !== undefined) {\n if (row.user_id !== ctx.user.id) throw forbidden(\"후기는 본인만 작성할 수 있습니다.\");\n put(\"student_feedback\", optStr(body, \"studentFeedback\", 2000));\n }\n if (body.topic !== undefined && row.status === \"requested\") {\n put(\"topic\", str(body, \"topic\", { required: true, max: 200 }));\n }\n if (body.content !== undefined && row.status === \"requested\") {\n put(\"content\", str(body, \"content\", { max: 3000 }));\n }\n\n if (staff) {\n if (body.coachNote !== undefined) put(\"coach_note\", optStr(body, \"coachNote\", 3000));\n if (body.scheduledAt !== undefined) put(\"scheduled_at\", isoOf(body, \"scheduledAt\"));\n if (body.slotId !== undefined) put(\"slot_id\", optStr(body, \"slotId\", 40));\n if (body.coachId !== undefined) put(\"coach_id\", optStr(body, \"coachId\", 60));\n }\n\n if (!sets.length) throw badRequest(\"변경할 값이 없습니다.\");\n sets.push(\"updated_at = ?\");\n args.push(nowIso(), ctx.params.id);\n await exec(`UPDATE consults SET ${sets.join(\", \")} WHERE id = ?`, args);\n\n const updated = await one(\"SELECT * FROM consults WHERE id = ?\", [ctx.params.id]);\n\n // 관리쌤이 손댄 경우에만 학생에게 알린다.\n if (staff && row.user_id !== ctx.user.id && body.status !== undefined) {\n const label: Record = {\n scheduled: \"상담 일정이 잡혔어요\",\n done: \"상담이 완료되었어요\",\n canceled: \"상담 신청이 취소되었어요\",\n requested: \"상담 신청이 접수되었어요\",\n };\n await notify(\n row.user_id,\n \"consult_update\",\n label[String(body.status)] ?? \"상담 상태가 변경되었어요\",\n row.topic,\n \"/consult.html\",\n );\n }\n return json({ consult: updated });\n });\n\n /* ── 관리쌤: 슬롯 관리 ───────────────────────────── */\n\n r.get(\"/api/consults/slots/manage\", \"staff\", async (ctx: Ctx) => {\n requireStaff(ctx.user);\n const slots = await query(\n `SELECT s.*, u.name AS coach_name FROM consult_slots s\n LEFT JOIN users u ON u.id = s.coach_id\n ORDER BY s.start_at DESC LIMIT 200`,\n );\n const out = [];\n for (const s of slots) out.push({ ...s, remaining: await slotRemaining(s) });\n return json({ slots: out });\n });\n\n r.post(\"/api/consults/slots\", \"staff\", async (ctx: Ctx) => {\n requireStaff(ctx.user);\n const body = await ctx.body();\n const startAt = isoOf(body, \"startAt\", true)!;\n const endAt = isoOf(body, \"endAt\", true)!;\n if (endAt <= startAt) throw badRequest(\"종료 시각이 시작 시각보다 빠릅니다.\");\n\n const id = uuid();\n await exec(\n `INSERT INTO consult_slots (id, coach_id, start_at, end_at, capacity, status, memo, created_at)\n VALUES (?, ?, ?, ?, ?, 'open', ?, ?)`,\n [\n id,\n optStr(body, \"coachId\", 60) ?? ctx.user.id,\n startAt,\n endAt,\n Math.max(1, Math.min(20, Number(body.capacity ?? 1))),\n optStr(body, \"memo\", 500),\n nowIso(),\n ],\n );\n return json({ slot: await one(\"SELECT * FROM consult_slots WHERE id = ?\", [id]) }, 201);\n });\n\n r.patch(\"/api/consults/slots/:id\", \"staff\", async (ctx: Ctx) => {\n requireStaff(ctx.user);\n const body = await ctx.body();\n const slot = await one(\"SELECT * FROM consult_slots WHERE id = ?\", [ctx.params.id]);\n if (!slot) throw notFound();\n\n const status = enumOf(body, \"status\", [\"open\", \"closed\"] as const, slot.status as \"open\");\n await exec(\"UPDATE consult_slots SET status = ?, capacity = ? WHERE id = ?\", [\n status,\n Math.max(1, Math.min(20, Number(body.capacity ?? slot.capacity))),\n ctx.params.id,\n ]);\n return json({ slot: await one(\"SELECT * FROM consult_slots WHERE id = ?\", [ctx.params.id]) });\n });\n\n r.del(\"/api/consults/slots/:id\", \"staff\", async (ctx: Ctx) => {\n requireStaff(ctx.user);\n const booked = Number(\n await scalar(\n \"SELECT COUNT(*) FROM consults WHERE slot_id = ? AND status IN ('requested','scheduled')\",\n [ctx.params.id],\n ) ?? 0,\n );\n if (booked > 0) throw badRequest(\"예약이 있는 시간은 삭제할 수 없습니다. 먼저 닫아 주세요.\");\n await exec(\"DELETE FROM consult_slots WHERE id = ?\", [ctx.params.id]);\n return json({ ok: true });\n });\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"]