[{"_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/analytics.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/analytics.ts","extension","id","d7cd72d2-79fb-49be-97c2-2b9d2e83c90b","analytics.ts","fileId","0920dad2-ab26-11f1-ab9f-1607ee4eb77e","parentId","0819cf40-ab26-11f1-87f9-1607ee4eb77e","branchId","964f7637-562b-4945-9c69-b20a92bec2d0","branchVersion",18,"latest",true,"createdAt",["D",1788831527208],"version",0,"fileType","script","content","/**\n * 학습 분석지.\n *\n * 집계는 전부 SQL 로 끝낸다(행을 다 끌어와 JS 에서 도는 방식은 학생 수가 늘면 무너진다).\n * 프론트는 받은 숫자를 그리기만 한다.\n */\nimport { Ctx, json, Router } from \"../lib/http.ts\";\nimport { query, scalar } from \"../lib/sqlite.ts\";\nimport { addDays, dateRange, toLocalDate, weekStart } from \"../lib/time.ts\";\nimport { rangeFromQuery } from \"../lib/validate.ts\";\nimport { targetUserId } from \"./_shared.ts\";\n\nexport interface Summary {\n from: string;\n to: string;\n totals: {\n studyMinutes: number;\n goalMinutes: number;\n planCount: number;\n doneCount: number;\n completionRate: number;\n studyDays: number;\n avgMinutesPerStudyDay: number;\n diaryCount: number;\n avgFocus: number | null;\n };\n daily: Array<\n { date: string; minutes: number; done: number; total: number; focus: number | null }\n >;\n bySubject: Array<\n {\n subjectId: string | null;\n name: string;\n color: string;\n minutes: number;\n done: number;\n total: number;\n }\n >;\n weekly: Array<{ week: string; minutes: number; rate: number }>;\n streak: { current: number; best: number };\n}\n\nexport async function buildSummary(userId: string, from: string, to: string): Promise

{\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","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"]