[{"_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/admin.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/admin.ts","extension","id","4db72583-ffc0-4289-b9ca-3bf3ba195b50","admin.ts","fileId","0a4fc5d0-ab26-11f1-ba6d-1607ee4eb77e","parentId","0819cf40-ab26-11f1-87f9-1607ee4eb77e","branchId","964f7637-562b-4945-9c69-b20a92bec2d0","branchVersion",26,"latest",true,"createdAt",["D",1788831527223],"version",0,"fileType","script","content","/**\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","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"]