[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_144":145,"_146":147},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_85":67,"_86":31,"_65":-7,"_87":-5,"_13":88,"_89":90,"_11":91,"_92":93,"_94":95,"_96":-5,"_97":-5,"_98":-5,"_99":26,"_100":101,"_102":38,"_103":-5,"_104":-5,"_105":106},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":50,"_51":50,"_52":53,"_54":53,"_55":53,"_56":50,"_57":50,"_58":59,"_60":61,"_62":63,"_64":26},"query","handle","studyaddict26afk","id","50cebcec-0d98-4111-b5cc-7bcb8cfd2ddd","name","studyaddict-chat","createdAt",["D",1787549925310],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","","imageUrl","userId","a01b5f14-fafc-47a9-ac50-251459312caf","pinnedFileId","be1575be-9f7e-11f1-90ff-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a03245-89da-75aa-9f52-cf943e71befd","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_16":17,"_84":80},"org",{"_16":17,"_77":78,"_79":80,"_33":34,"_81":82,"_83":26},"branch",{"_65":66,"_20":67,"_18":68,"_69":19,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":21,"_76":17},"isOwned","version",32,"main","6d8e48ff-2d11-4c27-be58-58f6f908abfd","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","studyaddict26-afk","avatar","https://avatars.githubusercontent.com/u/316571584?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","path","adoptOrgId",{"_18":19,"_20":21,"_22":140,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":50,"_51":50,"_52":53,"_54":53,"_55":53,"_56":50,"_57":50,"_58":141,"_60":142,"_62":143,"_64":26},"tree",[135],[135],"counts",{"_124":42,"_125":126,"_127":42,"_128":129,"_130":131},"contents",[107],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_18":108,"_20":109,"_110":36,"_111":-5,"_112":68,"_113":66,"_114":38,"_22":115,"_65":116,"_117":118,"_119":120,"_121":26,"_122":-5,"_86":123},"fa657b39-6ecd-4490-ba3d-3391a78ee3f5","new-file-7107.ts","fileId","parentId","branchId","branchVersion","latest",["D",1789104726277],27,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst ALLOWED_ORIGIN = \"https://studyaddict26-afk.github.io\";\n\nconst DATA_BASE_URL = \"https://studyaddict26-afk.github.io/chatbot-data/\";\n\nconst MODEL = \"claude-haiku-4-5-20251001\";\nconst MAX_TOKENS = 2048;\n\nconst SUBJECT_DATA_FILE: Record = {\n diary: \"data-diary.txt\",\n mathexam: \"data-mathexam.txt\",\n engexam: \"data-engexam.txt\",\n schedule: \"data-schedule.txt\",\n plan: \"data-plan.txt\",\n};\n\nconst CHAT_DATA_FILES: { label: string; file: string }[] = [\n { label: \"학습 계획\", file: \"data-plan.txt\" },\n { label: \"수학\", file: \"data-math.txt\" },\n { label: \"국어\", file: \"data-korean.txt\" },\n { label: \"영어\", file: \"data-english.txt\" },\n];\n\nconst VALID_SUBJECTS = new Set([\"chat\", \"diary\", \"mathexam\", \"engexam\", \"schedule\", \"plan\"]);\n\nconst SUBJECT_HINTS: Record = {\n chat: \"지금 학생은 특정 과목을 정하지 않고, 학습 계획이나 수학·국어·영어 등 궁금한 것을 자유롭게 질문하고 있다. 아래 자료 중 질문과 관련 있는 과목의 내용을 참고해 답하라.\",\n diary: \"지금 학생은 오늘 하루의 공부 일기를 작성하고 있다.\",\n mathexam: \"지금 학생은 우리 동네 수학 내신 기출에 대해 질문하고 있다.\",\n engexam: \"지금 학생은 우리 동네 영어 내신 기출에 대해 질문하고 있다.\",\n schedule: \"지금 학생은 '내 스케줄 관리하기' 페이지에서, 자신의 독서실 이용 스케줄(고정/돌발)을 챗봇과의 대화로 정하고 있다.\",\n plan: \"지금 학생은 '플래너 작성하기' 페이지에서, 오늘 하루 계획을 어떻게 세우면 좋을지 AI와 상담하고 있다. 이 챗봇은 계획을 대신 저장해주지 않는다 — 학생이 이 페이지의 플래너에 직접 과목/내용을 추가하도록, 방향과 우선순위 조언만 준다.\",\n};\n\nconst SCHEDULE_SUBJECT = \"schedule\";\nconst PLAN_SUBJECT = \"plan\";\n\nfunction kstTodayStr(): string {\n const kst = new Date(Date.now() + 9 * 60 * 60 * 1000);\n if (kst.getUTCHours() < 6) kst.setUTCDate(kst.getUTCDate() - 1);\n const pad = (n: number) => String(n).padStart(2, \"0\");\n return `${kst.getUTCFullYear()}-${pad(kst.getUTCMonth() + 1)}-${pad(kst.getUTCDate())}`;\n}\n\nasync function loadSubjectData(subject: string): Promise {\n if (subject === \"chat\") {\n const parts = await Promise.all(CHAT_DATA_FILES.map(f => loadText(f.file)));\n return CHAT_DATA_FILES.map((f, i) => `[${f.label} 자료]\\n${parts[i]}`).join(\"\\n\\n\");\n }\n return loadText(SUBJECT_DATA_FILE[subject]);\n}\n\nconst RECOMMEND_CONSULT_PROMPT = `너는 학생의 최근 분석지 내용을 참고해서, 학습 상담 신청서를\n작성하기 직전에 어떤 종류의 상담이 이 학생에게 맞을지 짧게 추천하는 AI다.\n\n## 원칙\n- 분석지에 나온 내용만 근거로 삼는다. 지어내지 않는다.\n- 구체적인 문제 풀이법을 알려주지 않는다.\n- 2~3문장으로, 어떤 상담(과목/영역)이 좋을지 추천하고 그 이유를 짧게 덧붙인다.\n- 존댓말, 담백한 말투를 쓴다.\n\n<분석지>\n{REPORT}\n`;\n\nconst CONFIRM_STYLE_SUBJECTS = [\"diary\"];\n\nfunction corsHeaders() {\n return {\n \"Access-Control-Allow-Origin\": ALLOWED_ORIGIN,\n \"Access-Control-Allow-Methods\": \"POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n };\n}\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { ...corsHeaders(), \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n}\n\nasync function loadText(filename: string) {\n const res = await fetch(DATA_BASE_URL + filename + \"?t=\" + Date.now());\n if (!res.ok) throw new Error(\"자료 파일을 불러오지 못했습니다: \" + filename);\n return res.text();\n}\n\nasync function ensureTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_chat_history (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n student_id TEXT NOT NULL,\n subject TEXT NOT NULL,\n role TEXT NOT NULL,\n content TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`);\n try {\n await sqlite.execute(`ALTER TABLE holo_chat_history ADD COLUMN chat_date TEXT`);\n } catch {\n }\n await sqlite.execute(`UPDATE holo_chat_history SET chat_date = substr(created_at, 1, 10) WHERE chat_date IS NULL`);\n}\n\nfunction rowsToMessages(result: any) {\n const rows = (result && result.rows) || [];\n return rows.map((r: any) => {\n if (Array.isArray(r)) return { role: r[0], content: r[1] };\n return { role: r.role, content: r.content };\n });\n}\n\nfunction rowsToObjects(result: any, keys: string[]) {\n const rows = (result && result.rows) || [];\n return rows.map((r: any) => {\n if (Array.isArray(r)) {\n const obj: any = {};\n keys.forEach((k, i) => (obj[k] = r[i]));\n return obj;\n }\n return r;\n });\n}\n\nfunction buildDayPlanBlock(planRows: any[]) {\n const fmt = (r: any) => {\n const mark = Number(r.done) ? \"✅\" : \"❌\";\n const subj = r.subject ? `(${r.subject}) ` : \"\";\n return `${mark} [${r.block}] ${subj}${r.text}`;\n };\n const initial = planRows.filter((r: any) => Number(r.is_initial) !== 0).map((r: any) => fmt({ ...r, text: r.original_text }));\n const later = planRows.filter((r: any) => Number(r.is_initial) === 0).map(fmt);\n if (!initial.length && !later.length) return \"(기록 없음)\";\n let out = \"[최초 계획]\\n\" + (initial.length ? initial.join(\"\\n\") : \"(없음)\");\n if (later.length) out += \"\\n\\n[수정한 계획]\\n\" + later.join(\"\\n\");\n return out;\n}\nfunction buildDayDiaryBlock(q1: string, q2: string, q3: string, q4: string, free: string) {\n const parts: string[] = [];\n if (q1) parts.push(\"1. 오늘 하루 공부는 어땠나요? \" + q1);\n if (q2) parts.push(\"2. 집중이 안 됐던 순간: \" + q2);\n if (q3) parts.push(\"3. 잘 풀렸던 부분: \" + q3);\n if (q4) parts.push(\"4. 막혔던 개념/문제: \" + q4);\n if (free) parts.push(\"자유 기록: \" + free);\n return parts.length ? parts.join(\"\\n\") : \"(기록 없음)\";\n}\nfunction buildDayChatBlock(rawTexts: string[]) {\n return rawTexts.length ? rawTexts.map((t, i) => `${i + 1}. ${t}`).join(\"\\n\") : \"(기록 없음)\";\n}\n\nasync function saveTurn(studentId: string, subject: string, role: string, content: string, chatDate: string) {\n await sqlite.execute({\n sql: \"INSERT INTO holo_chat_history (student_id, subject, role, content, created_at, chat_date) VALUES (?, ?, ?, ?, ?, ?)\",\n args: [studentId, subject, role, content, new Date().toISOString(), chatDate],\n });\n}\n\nasync function ensureWorryTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_worries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n student_id TEXT NOT NULL,\n subject TEXT NOT NULL,\n raw_text TEXT NOT NULL,\n ai_summary TEXT NOT NULL,\n image_data TEXT,\n created_at TEXT NOT NULL\n )`);\n try {\n await sqlite.execute(`ALTER TABLE holo_worries ADD COLUMN chat_date TEXT`);\n } catch {\n }\n await sqlite.execute(`UPDATE holo_worries SET chat_date = substr(created_at, 1, 10) WHERE chat_date IS NULL`);\n}\n\nasync function saveWorry(\n studentId: string,\n subject: string,\n rawText: string,\n aiSummary: string,\n imageDataUrl: string | null,\n chatDate: string,\n) {\n await sqlite.execute({\n sql: \"INSERT INTO holo_worries (student_id, subject, raw_text, ai_summary, image_data, created_at, chat_date) VALUES (?, ?, ?, ?, ?, ?, ?)\",\n args: [studentId, subject, rawText, aiSummary, imageDataUrl, new Date().toISOString(), chatDate],\n });\n}\n\nasync function ensureReportTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_reports (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n student_id TEXT NOT NULL,\n period_start TEXT NOT NULL,\n period_end TEXT NOT NULL,\n worry_count INTEGER NOT NULL,\n content TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`);\n try {\n await sqlite.execute(`ALTER TABLE holo_reports ADD COLUMN report_type TEXT NOT NULL DEFAULT 'weekly'`);\n } catch {\n }\n}\n\nasync function ensurePlanTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_plans (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n student_id TEXT NOT NULL,\n plan_date TEXT NOT NULL,\n block TEXT NOT NULL,\n subject TEXT,\n text TEXT NOT NULL,\n original_text TEXT NOT NULL,\n done INTEGER NOT NULL DEFAULT 0,\n active INTEGER NOT NULL DEFAULT 1,\n edited_at TEXT,\n created_at TEXT NOT NULL\n )`);\n try {\n await sqlite.execute(`ALTER TABLE holo_plans ADD COLUMN is_initial INTEGER NOT NULL DEFAULT 1`);\n } catch {\n }\n}\n\nasync function loadPlanForPromptByDate(studentId: string | null, date: string): Promise {\n if (!studentId) return \"(로그인 정보가 없어 계획을 불러올 수 없습니다.)\";\n try {\n await ensurePlanTable();\n const result = await sqlite.execute({\n sql: \"SELECT block, subject, text, done FROM holo_plans WHERE student_id = ? AND plan_date = ? AND active = 1 ORDER BY id ASC\",\n args: [studentId, date],\n });\n const rows = rowsToObjects(result, [\"block\", \"subject\", \"text\", \"done\"]);\n if (!rows.length) return `(${date}에 세운 계획이 없습니다.)`;\n const byBlock: Record = { \"오전\": [], \"오후\": [], \"저녁\": [] };\n rows.forEach((r: any) => {\n const line = (r.subject ? `[${r.subject}] ` : \"\") + r.text + (Number(r.done) ? \" (완료)\" : \" (미완료)\");\n if (byBlock[r.block]) byBlock[r.block].push(line);\n });\n return Object.entries(byBlock)\n .map(([block, lines]) => `${block}: ` + (lines.length ? lines.join(\", \") : \"없음\"))\n .join(\"\\n\");\n } catch (e) {\n console.error(\"loadPlanForPromptByDate error\", e);\n return \"(계획을 불러오는 중 오류가 발생했습니다.)\";\n }\n}\nasync function loadTodayPlanForPrompt(studentId: string | null): Promise {\n return loadPlanForPromptByDate(studentId, kstTodayStr());\n}\n\nasync function loadStudentHabitsForPrompt(studentId: string | null): Promise {\n if (!studentId) return \"(로그인 정보가 없어 불러올 수 없습니다.)\";\n try {\n await ensureWorryTable();\n const result = await sqlite.execute({\n sql: \"SELECT raw_text, chat_date FROM holo_worries WHERE student_id = ? AND subject = ? AND length(raw_text) >= 15 ORDER BY id DESC LIMIT 15\",\n args: [studentId, PLAN_SUBJECT],\n });\n const rows = rowsToObjects(result, [\"raw_text\", \"chat_date\"]);\n if (!rows.length) return \"(아직 기록된 내용이 없습니다.)\";\n return rows.reverse().map((r: any) => `- (${r.chat_date}) ${r.raw_text}`).join(\"\\n\");\n } catch (e) {\n console.error(\"loadStudentHabitsForPrompt error\", e);\n return \"(불러오는 중 오류가 발생했습니다.)\";\n }\n}\n\nasync function ensurePlanSubmissionTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_plan_submissions (\n student_id TEXT NOT NULL,\n submit_date TEXT NOT NULL,\n submitted_at TEXT NOT NULL,\n PRIMARY KEY (student_id, submit_date)\n )`);\n}\n\nasync function ensureNoteTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_notes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n student_id TEXT NOT NULL,\n note_date TEXT NOT NULL,\n text TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`);\n}\n\nasync function ensureSpecialNoteTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_special_notes (\n student_id TEXT NOT NULL,\n note_date TEXT NOT NULL,\n text TEXT NOT NULL DEFAULT '',\n updated_at TEXT NOT NULL,\n PRIMARY KEY (student_id, note_date)\n )`);\n}\n\nasync function ensureDiaryEntryTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_diary_entries (\n student_id TEXT NOT NULL,\n entry_date TEXT NOT NULL,\n q1 TEXT NOT NULL DEFAULT '',\n q2 TEXT NOT NULL DEFAULT '',\n q3 TEXT NOT NULL DEFAULT '',\n free_text TEXT NOT NULL DEFAULT '',\n updated_at TEXT NOT NULL,\n PRIMARY KEY (student_id, entry_date)\n )`);\n try {\n await sqlite.execute(`ALTER TABLE holo_diary_entries ADD COLUMN q4 TEXT NOT NULL DEFAULT ''`);\n } catch {\n }\n}\n\nasync function ensureDayRecordTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_day_records (\n student_id TEXT NOT NULL,\n record_date TEXT NOT NULL,\n plan_text TEXT NOT NULL DEFAULT '',\n diary_text TEXT NOT NULL DEFAULT '',\n chat_text TEXT NOT NULL DEFAULT '',\n created_at TEXT NOT NULL,\n PRIMARY KEY (student_id, record_date)\n )`);\n}\n\nasync function ensureScheduleTables() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_schedule_fixed_days (\n student_id TEXT NOT NULL,\n weekday INTEGER NOT NULL,\n entry_time TEXT,\n outing_time TEXT,\n reentry_time TEXT,\n exit_time TEXT,\n reason TEXT,\n updated_at TEXT NOT NULL,\n PRIMARY KEY (student_id, weekday)\n )`);\n try {\n await sqlite.execute(`ALTER TABLE holo_schedule_fixed_days ADD COLUMN blocks_json TEXT`);\n } catch {\n }\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS holo_schedule_adhoc (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n student_id TEXT NOT NULL,\n event_date TEXT NOT NULL,\n start_time TEXT NOT NULL,\n end_time TEXT NOT NULL,\n note TEXT,\n created_at TEXT NOT NULL\n )`);\n}\n\nfunction deriveScheduleEvents(blocks: { start: string; end: string }[]): { label: string; time: string }[] {\n if (!blocks.length) return [];\n const sorted = [...blocks].sort((a, b) => a.start.localeCompare(b.start));\n const events: { label: string; time: string }[] = [{ label: \"최초 입실\", time: sorted[0].start }];\n for (let i = 0; i < sorted.length - 1; i++) {\n events.push({ label: \"외출\", time: sorted[i].end });\n events.push({ label: \"재입실\", time: sorted[i + 1].start });\n }\n events.push({ label: \"퇴실\", time: sorted[sorted.length - 1].end });\n return events;\n}\n\nfunction legacyFieldsToBlocks(entry: string | null, outing: string | null, reentry: string | null, exit: string | null) {\n if (!entry || !exit) return [];\n if (outing && reentry) return [{ start: entry, end: outing }, { start: reentry, end: exit }];\n return [{ start: entry, end: exit }];\n}\n\nfunction blocksToLegacyFields(blocks: { start: string; end: string }[]) {\n if (!blocks || !blocks.length) return { entry_time: null, outing_time: null, reentry_time: null, exit_time: null };\n const sorted = [...blocks].sort((a, b) => a.start.localeCompare(b.start));\n const entry_time = sorted[0].start;\n const exit_time = sorted[sorted.length - 1].end;\n if (sorted.length === 2) {\n return { entry_time, outing_time: sorted[0].end, reentry_time: sorted[1].start, exit_time };\n }\n return { entry_time, outing_time: null, reentry_time: null, exit_time };\n}\n\nasync function upsertFixedScheduleDay(studentId: string, d: any) {\n const weekday = Number(d.weekday);\n if (!Number.isInteger(weekday) || weekday < 0 || weekday > 6) return;\n const blocks = Array.isArray(d.blocks)\n ? d.blocks\n .filter((b: any) => b && b.start && b.end)\n .map((b: any) => ({ start: String(b.start).trim(), end: String(b.end).trim() }))\n : [];\n if (!blocks.length) return;\n const reason = d.reason ? String(d.reason).trim().slice(0, 100) : null;\n const legacy = blocksToLegacyFields(blocks);\n await sqlite.execute({\n sql: `INSERT INTO holo_schedule_fixed_days\n (student_id, weekday, entry_time, outing_time, reentry_time, exit_time, reason, blocks_json, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(student_id, weekday) DO UPDATE SET\n entry_time = excluded.entry_time, outing_time = excluded.outing_time,\n reentry_time = excluded.reentry_time, exit_time = excluded.exit_time,\n reason = excluded.reason, blocks_json = excluded.blocks_json, updated_at = excluded.updated_at`,\n args: [\n studentId, weekday,\n legacy.entry_time, legacy.outing_time, legacy.reentry_time, legacy.exit_time,\n reason, JSON.stringify(blocks), new Date().toISOString(),\n ],\n });\n}\n\nasync function insertAdhocScheduleFromChat(studentId: string, d: any) {\n const eventDate = d.date ? String(d.date).trim() : null;\n const startTime = d.start ? String(d.start).trim() : null;\n const endTime = d.end ? String(d.end).trim() : null;\n const note = d.note ? String(d.note).trim().slice(0, 100) : null;\n if (!eventDate || !startTime || !endTime) return;\n await sqlite.execute({\n sql: \"INSERT INTO holo_schedule_adhoc (student_id, event_date, start_time, end_time, note, created_at) VALUES (?, ?, ?, ?, ?, ?)\",\n args: [studentId, eventDate, startTime, endTime, note, new Date().toISOString()],\n });\n}\n\nasync function extractAndSaveScheduleJson(studentId: string | null, answer: string): Promise {\n const match = answer.match(/```SCHEDULE_JSON\\s*([\\s\\S]*?)```/);\n if (!match) return answer;\n const idx = answer.indexOf(match[0]);\n const cleaned = (answer.slice(0, idx) + answer.slice(idx + match[0].length)).trim();\n if (!studentId) return cleaned;\n try {\n const data = JSON.parse(match[1]);\n const fixed = Array.isArray(data.fixed) ? data.fixed : [];\n const adhoc = Array.isArray(data.adhoc) ? data.adhoc : [];\n for (const d of fixed) await upsertFixedScheduleDay(studentId, d);\n for (const a of adhoc) await insertAdhocScheduleFromChat(studentId, a);\n } catch (e) {\n console.error(\"schedule chat JSON parse/save error\", e, match[1]);\n }\n return cleaned;\n}\n\nfunction extractPlanDateJson(answer: string): { text: string; date: string | null } {\n const match = answer.match(/```PLAN_DATE_JSON\\s*([\\s\\S]*?)```/);\n if (!match) return { text: answer, date: null };\n const idx = answer.indexOf(match[0]);\n const cleaned = (answer.slice(0, idx) + answer.slice(idx + match[0].length)).trim();\n try {\n const data = JSON.parse(match[1]);\n const date = typeof data.date === \"string\" && /^\\d{4}-\\d{2}-\\d{2}$/.test(data.date) ? data.date : null;\n return { text: cleaned, date };\n } catch (e) {\n console.error(\"plan date json parse error\", e, match[1]);\n return { text: cleaned, date: null };\n }\n}\n\nfunction extractAnalyzeDateJson(answer: string): { text: string; date: string | null } {\n const match = answer.match(/```ANALYZE_DATE_JSON\\s*([\\s\\S]*?)```/);\n if (!match) return { text: answer, date: null };\n const idx = answer.indexOf(match[0]);\n const cleaned = (answer.slice(0, idx) + answer.slice(idx + match[0].length)).trim();\n try {\n const data = JSON.parse(match[1]);\n const date = typeof data.date === \"string\" && /^\\d{4}-\\d{2}-\\d{2}$/.test(data.date) ? data.date : null;\n return { text: cleaned, date };\n } catch (e) {\n console.error(\"analyze date json parse error\", e, match[1]);\n return { text: cleaned, date: null };\n }\n}\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: corsHeaders() });\n }\n if (req.method !== \"POST\") {\n return json({ error: \"Method Not Allowed\" }, 405);\n }\n\n let body: any;\n try {\n body = await req.json();\n } catch {\n return json({ error: \"잘못된 요청입니다.\" }, 400);\n }\n\n try {\n await ensureTable();\n await ensureWorryTable();\n await ensureReportTable();\n await ensurePlanTable();\n await ensurePlanSubmissionTable();\n await ensureNoteTable();\n await ensureSpecialNoteTable();\n await ensureDiaryEntryTable();\n await ensureDayRecordTable();\n await ensureScheduleTables();\n } catch (e) {\n console.error(\"table init error\", e);\n }\n\n if (body.action === \"history\") {\n const subject = VALID_SUBJECTS.has(body.subject) ? body.subject : null;\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const date = body.date && /^\\d{4}-\\d{2}-\\d{2}$/.test(String(body.date)) ? String(body.date) : kstTodayStr();\n if (!subject || !studentId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"SELECT role, content FROM holo_chat_history WHERE student_id = ? AND subject = ? AND chat_date = ? ORDER BY id ASC LIMIT 200\",\n args: [studentId, subject, date],\n });\n return json({ messages: rowsToMessages(result) });\n } catch (e) {\n console.error(\"history fetch error\", e);\n return json({ messages: [] });\n }\n }\n\n if (body.action === \"delete_history\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n if (!studentId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n await sqlite.execute({\n sql: \"DELETE FROM holo_chat_history WHERE student_id = ?\",\n args: [studentId],\n });\n await sqlite.execute({\n sql: \"DELETE FROM holo_worries WHERE student_id = ?\",\n args: [studentId],\n });\n await sqlite.execute({\n sql: \"DELETE FROM holo_reports WHERE student_id = ?\",\n args: [studentId],\n });\n await sqlite.execute({\n sql: \"DELETE FROM holo_plans WHERE student_id = ?\",\n args: [studentId],\n });\n await sqlite.execute({\n sql: \"DELETE FROM holo_notes WHERE student_id = ?\",\n args: [studentId],\n });\n await sqlite.execute({\n sql: \"DELETE FROM holo_special_notes WHERE student_id = ?\",\n args: [studentId],\n });\n await sqlite.execute({\n sql: \"DELETE FROM holo_diary_entries WHERE student_id = ?\",\n args: [studentId],\n });\n return json({ ok: true });\n } catch (e) {\n console.error(\"history delete error\", e);\n return json({ error: \"삭제 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"reports\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n if (!studentId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"SELECT id, period_start, period_end, worry_count, content, report_type, created_at FROM holo_reports WHERE student_id = ? ORDER BY id DESC LIMIT 100\",\n args: [studentId],\n });\n const rows = (result.rows || []).map((r: any) =>\n Array.isArray(r)\n ? { id: r[0], period_start: r[1], period_end: r[2], worry_count: r[3], content: r[4], report_type: r[5], created_at: r[6] }\n : r\n );\n return json({ reports: rows });\n } catch (e) {\n console.error(\"reports fetch error\", e);\n return json({ reports: [] });\n }\n }\n\n if (body.action === \"recommend_consult\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n if (!studentId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"SELECT content, report_type FROM holo_reports WHERE student_id = ? ORDER BY (report_type = 'weekly') DESC, id DESC LIMIT 1\",\n args: [studentId],\n });\n const row = (result.rows || [])[0];\n const reportContent = row ? (Array.isArray(row) ? row[0] : row.content) : null;\n if (!reportContent) {\n return json({ recommendation: null });\n }\n const apiKey = Deno.env.get(\"ANTHROPIC_API_KEY\");\n const res = await fetch(\"https://api.anthropic.com/v1/messages\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"x-api-key\": apiKey ?? \"\",\n \"anthropic-version\": \"2023-06-01\",\n },\n body: JSON.stringify({\n model: MODEL,\n max_tokens: 300,\n system: [{ type: \"text\", text: RECOMMEND_CONSULT_PROMPT.replace(\"{REPORT}\", reportContent) }],\n messages: [{ role: \"user\", content: \"위 분석지를 참고해서, 이 학생에게 어떤 상담을 추천하면 좋을지 말해줘.\" }],\n }),\n });\n const data = await res.json();\n if (!res.ok) {\n console.error(\"recommend_consult Anthropic error\", data);\n return json({ recommendation: null });\n }\n return json({ recommendation: data.content?.[0]?.text || null });\n } catch (e) {\n console.error(\"recommend_consult error\", e);\n return json({ recommendation: null });\n }\n }\n\n if (body.action === \"plan_list\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const planDate = body.date ? String(body.date).trim() : null;\n if (!studentId || !planDate) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"SELECT id, block, subject, text, original_text, done, active, edited_at, created_at, is_initial FROM holo_plans WHERE student_id = ? AND plan_date = ? ORDER BY id ASC\",\n args: [studentId, planDate],\n });\n const rows = (result.rows || []).map((r: any) =>\n Array.isArray(r)\n ? { id: r[0], block: r[1], subject: r[2], text: r[3], original_text: r[4], done: r[5], active: r[6], edited_at: r[7], created_at: r[8], is_initial: r[9] }\n : r\n );\n return json({ items: rows });\n } catch (e) {\n console.error(\"plan_list error\", e);\n return json({ items: [] });\n }\n }\n\n if (body.action === \"plan_add\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const planDate = body.date ? String(body.date).trim() : null;\n const block = body.block ? String(body.block).trim() : null;\n const text = body.text ? String(body.text).trim().slice(0, 300) : null;\n const subject = body.subject ? String(body.subject).trim().slice(0, 40) : null;\n const isInitial = body.isInitial === false ? 0 : 1; // 명시적으로 false로 온 경우만 \"나중에 추가한 것\"\n if (!studentId || !planDate || !block || !text) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const now = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO holo_plans (student_id, plan_date, block, subject, text, original_text, done, active, created_at, is_initial) VALUES (?, ?, ?, ?, ?, ?, 0, 1, ?, ?)\",\n args: [studentId, planDate, block, subject, text, text, now, isInitial],\n });\n return json({ ok: true, id: result.lastInsertRowid != null ? Number(result.lastInsertRowid) : null });\n } catch (e) {\n console.error(\"plan_add error\", e);\n return json({ error: \"계획 추가 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"plan_toggle\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const itemId = body.itemId;\n if (!studentId || !itemId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n await sqlite.execute({\n sql: \"UPDATE holo_plans SET done = 1 - done WHERE id = ? AND student_id = ?\",\n args: [itemId, studentId],\n });\n return json({ ok: true });\n } catch (e) {\n console.error(\"plan_toggle error\", e);\n return json({ error: \"처리 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"plan_edit\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const itemId = body.itemId;\n const text = body.text ? String(body.text).trim().slice(0, 300) : null;\n const subject = body.subject !== undefined ? String(body.subject).trim().slice(0, 40) : null;\n if (!studentId || !itemId || !text) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n if (subject !== null) {\n await sqlite.execute({\n sql: \"UPDATE holo_plans SET text = ?, subject = ?, edited_at = ? WHERE id = ? AND student_id = ?\",\n args: [text, subject, new Date().toISOString(), itemId, studentId],\n });\n } else {\n await sqlite.execute({\n sql: \"UPDATE holo_plans SET text = ?, edited_at = ? WHERE id = ? AND student_id = ?\",\n args: [text, new Date().toISOString(), itemId, studentId],\n });\n }\n return json({ ok: true });\n } catch (e) {\n console.error(\"plan_edit error\", e);\n return json({ error: \"수정 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"plan_delete\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const itemId = body.itemId;\n if (!studentId || !itemId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n await sqlite.execute({\n sql: \"UPDATE holo_plans SET active = 0 WHERE id = ? AND student_id = ?\",\n args: [itemId, studentId],\n });\n return json({ ok: true });\n } catch (e) {\n console.error(\"plan_delete error\", e);\n return json({ error: \"삭제 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"plan_submit_mark\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const date = body.date ? String(body.date).trim() : null;\n if (!studentId || !date) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n await sqlite.execute({\n sql: \"INSERT INTO holo_plan_submissions (student_id, submit_date, submitted_at) VALUES (?, ?, ?) \" +\n \"ON CONFLICT(student_id, submit_date) DO UPDATE SET submitted_at = excluded.submitted_at\",\n args: [studentId, date, new Date().toISOString()],\n });\n return json({ ok: true });\n } catch (e) {\n console.error(\"plan_submit_mark error\", e);\n return json({ error: \"제출 처리 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"note_list\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const noteDate = body.date ? String(body.date).trim() : null;\n if (!studentId || !noteDate) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"SELECT id, text, created_at FROM holo_notes WHERE student_id = ? AND note_date = ? ORDER BY id ASC\",\n args: [studentId, noteDate],\n });\n const rows = (result.rows || []).map((r: any) =>\n Array.isArray(r) ? { id: r[0], text: r[1], created_at: r[2] } : r\n );\n return json({ notes: rows });\n } catch (e) {\n console.error(\"note_list error\", e);\n return json({ error: \"메모를 불러오지 못했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"note_add\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const noteDate = body.date ? String(body.date).trim() : null;\n const text = body.text ? String(body.text).trim().slice(0, 300) : null;\n if (!studentId || !noteDate || !text) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const now = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO holo_notes (student_id, note_date, text, created_at) VALUES (?, ?, ?, ?)\",\n args: [studentId, noteDate, text, now],\n });\n return json({ ok: true, id: result.lastInsertRowid != null ? Number(result.lastInsertRowid) : null });\n } catch (e) {\n console.error(\"note_add error\", e);\n return json({ error: \"메모 추가 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"note_delete\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const itemId = body.itemId;\n if (!studentId || !itemId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n await sqlite.execute({\n sql: \"DELETE FROM holo_notes WHERE id = ? AND student_id = ?\",\n args: [itemId, studentId],\n });\n return json({ ok: true });\n } catch (e) {\n console.error(\"note_delete error\", e);\n return json({ error: \"삭제 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"special_note_get\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const noteDate = body.date ? String(body.date).trim() : null;\n if (!studentId || !noteDate) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"SELECT text FROM holo_special_notes WHERE student_id = ? AND note_date = ?\",\n args: [studentId, noteDate],\n });\n const row = (result.rows || [])[0] as any;\n const text = row ? (Array.isArray(row) ? row[0] : row.text) : \"\";\n return json({ text: text || \"\" });\n } catch (e) {\n console.error(\"special_note_get error\", e);\n return json({ error: \"특이사항을 불러오지 못했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"special_note_save\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const noteDate = body.date ? String(body.date).trim() : null;\n const text = typeof body.text === \"string\" ? body.text.slice(0, 1000) : null;\n if (!studentId || !noteDate || text === null) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const now = new Date().toISOString();\n await sqlite.execute({\n sql: \"INSERT INTO holo_special_notes (student_id, note_date, text, updated_at) VALUES (?, ?, ?, ?) \" +\n \"ON CONFLICT(student_id, note_date) DO UPDATE SET text = excluded.text, updated_at = excluded.updated_at\",\n args: [studentId, noteDate, text, now],\n });\n return json({ ok: true });\n } catch (e) {\n console.error(\"special_note_save error\", e);\n return json({ error: \"저장 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"diary_get\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const entryDate = body.date ? String(body.date).trim() : null;\n if (!studentId || !entryDate) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"SELECT q1, q2, q3, q4, free_text FROM holo_diary_entries WHERE student_id = ? AND entry_date = ?\",\n args: [studentId, entryDate],\n });\n const row = (result.rows || [])[0] as any;\n if (!row) return json({ q1: \"\", q2: \"\", q3: \"\", q4: \"\", free: \"\" });\n const [q1, q2, q3, q4, free_text] = Array.isArray(row) ? row : [row.q1, row.q2, row.q3, row.q4, row.free_text];\n return json({ q1: q1 || \"\", q2: q2 || \"\", q3: q3 || \"\", q4: q4 || \"\", free: free_text || \"\" });\n } catch (e) {\n console.error(\"diary_get error\", e);\n return json({ error: \"공부일기를 불러오지 못했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"diary_save\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const entryDate = body.date ? String(body.date).trim() : null;\n if (!studentId || !entryDate) return json({ error: \"잘못된 요청입니다.\" }, 400);\n const q1 = typeof body.q1 === \"string\" ? body.q1.slice(0, 800) : \"\";\n const q2 = typeof body.q2 === \"string\" ? body.q2.slice(0, 800) : \"\";\n const q3 = typeof body.q3 === \"string\" ? body.q3.slice(0, 800) : \"\";\n const q4 = typeof body.q4 === \"string\" ? body.q4.slice(0, 800) : \"\";\n const free = typeof body.free === \"string\" ? body.free.slice(0, 800) : \"\";\n try {\n const now = new Date().toISOString();\n await sqlite.execute({\n sql: \"INSERT INTO holo_diary_entries (student_id, entry_date, q1, q2, q3, q4, free_text, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?) \" +\n \"ON CONFLICT(student_id, entry_date) DO UPDATE SET q1 = excluded.q1, q2 = excluded.q2, q3 = excluded.q3, q4 = excluded.q4, free_text = excluded.free_text, updated_at = excluded.updated_at\",\n args: [studentId, entryDate, q1, q2, q3, q4, free, now],\n });\n return json({ ok: true });\n } catch (e) {\n console.error(\"diary_save error\", e);\n return json({ error: \"저장 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"schedule_fixed_get\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n if (!studentId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"SELECT weekday, entry_time, outing_time, reentry_time, exit_time, reason, blocks_json FROM holo_schedule_fixed_days WHERE student_id = ?\",\n args: [studentId],\n });\n const rows = rowsToObjects(result, [\"weekday\", \"entry_time\", \"outing_time\", \"reentry_time\", \"exit_time\", \"reason\", \"blocks_json\"]);\n const days: Record = {};\n for (const r of rows) {\n let blocks: { start: string; end: string }[] = [];\n if (r.blocks_json) {\n try { blocks = JSON.parse(r.blocks_json); } catch { blocks = []; }\n } else {\n blocks = legacyFieldsToBlocks(r.entry_time, r.outing_time, r.reentry_time, r.exit_time);\n }\n r.events = deriveScheduleEvents(blocks);\n days[String(r.weekday)] = r;\n }\n return json({ days });\n } catch (e) {\n console.error(\"schedule_fixed_get error\", e);\n return json({ days: {} });\n }\n }\n\n if (body.action === \"schedule_fixed_save_all\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const days = Array.isArray(body.days) ? body.days : null;\n if (!studentId || !days) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const now = new Date().toISOString();\n const keepWeekdays = days.map((d: any) => Number(d.weekday)).filter((n: number) => Number.isInteger(n));\n if (keepWeekdays.length) {\n const placeholders = keepWeekdays.map(() => \"?\").join(\",\");\n await sqlite.execute({\n sql: `DELETE FROM holo_schedule_fixed_days WHERE student_id = ? AND weekday NOT IN (${placeholders})`,\n args: [studentId, ...keepWeekdays],\n });\n } else {\n await sqlite.execute({ sql: \"DELETE FROM holo_schedule_fixed_days WHERE student_id = ?\", args: [studentId] });\n }\n for (const d of days) {\n const weekday = Number(d.weekday);\n if (!Number.isInteger(weekday) || weekday < 0 || weekday > 6) continue;\n const entry = d.entry ? String(d.entry).trim() : null;\n const outing = d.outing ? String(d.outing).trim() : null;\n const reentry = d.reentry ? String(d.reentry).trim() : null;\n const exit = d.exit ? String(d.exit).trim() : null;\n const reason = d.reason ? String(d.reason).trim().slice(0, 100) : null;\n const blocks = legacyFieldsToBlocks(entry, outing, reentry, exit);\n await sqlite.execute({\n sql: `INSERT INTO holo_schedule_fixed_days\n (student_id, weekday, entry_time, outing_time, reentry_time, exit_time, reason, blocks_json, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(student_id, weekday) DO UPDATE SET\n entry_time = excluded.entry_time, outing_time = excluded.outing_time,\n reentry_time = excluded.reentry_time, exit_time = excluded.exit_time,\n reason = excluded.reason, blocks_json = excluded.blocks_json, updated_at = excluded.updated_at`,\n args: [studentId, weekday, entry, outing, reentry, exit, reason, JSON.stringify(blocks), now],\n });\n }\n return json({ ok: true });\n } catch (e) {\n console.error(\"schedule_fixed_save_all error\", e);\n return json({ error: \"고정 스케줄 저장 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"schedule_adhoc_list\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n if (!studentId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"SELECT id, event_date, start_time, end_time, note FROM holo_schedule_adhoc WHERE student_id = ? ORDER BY event_date ASC, start_time ASC\",\n args: [studentId],\n });\n return json({ items: rowsToObjects(result, [\"id\", \"event_date\", \"start_time\", \"end_time\", \"note\"]) });\n } catch (e) {\n console.error(\"schedule_adhoc_list error\", e);\n return json({ items: [] });\n }\n }\n\n if (body.action === \"schedule_adhoc_add\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const eventDate = body.eventDate ? String(body.eventDate).trim() : null;\n const startTime = body.startTime ? String(body.startTime).trim() : null;\n const endTime = body.endTime ? String(body.endTime).trim() : null;\n const note = body.note ? String(body.note).trim().slice(0, 100) : null;\n if (!studentId || !eventDate || !startTime || !endTime) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"INSERT INTO holo_schedule_adhoc (student_id, event_date, start_time, end_time, note, created_at) VALUES (?, ?, ?, ?, ?, ?)\",\n args: [studentId, eventDate, startTime, endTime, note, new Date().toISOString()],\n });\n return json({ ok: true, id: result.lastInsertRowid != null ? Number(result.lastInsertRowid) : null });\n } catch (e) {\n console.error(\"schedule_adhoc_add error\", e);\n return json({ error: \"돌발 스케줄 추가 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"schedule_adhoc_delete\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const itemId = body.itemId;\n if (!studentId || !itemId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n await sqlite.execute({\n sql: \"DELETE FROM holo_schedule_adhoc WHERE id = ? AND student_id = ?\",\n args: [itemId, studentId],\n });\n return json({ ok: true });\n } catch (e) {\n console.error(\"schedule_adhoc_delete error\", e);\n return json({ error: \"삭제 중 오류가 발생했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"schedule_today\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const date = body.date ? String(body.date).trim() : null; // \"YYYY-MM-DD\"\n const weekday = Number.isInteger(body.weekday) ? body.weekday : null; // 0=일 ~ 6=토\n if (!studentId || !date || weekday === null) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const [fixedResult, adhocResult] = await Promise.all([\n sqlite.execute({\n sql: \"SELECT entry_time, outing_time, reentry_time, exit_time, blocks_json FROM holo_schedule_fixed_days WHERE student_id = ? AND weekday = ?\",\n args: [studentId, weekday],\n }),\n sqlite.execute({\n sql: \"SELECT start_time, end_time FROM holo_schedule_adhoc WHERE student_id = ? AND event_date = ?\",\n args: [studentId, date],\n }),\n ]);\n const fixedRows = rowsToObjects(fixedResult, [\"entry_time\", \"outing_time\", \"reentry_time\", \"exit_time\", \"blocks_json\"]);\n const fixedRow = fixedRows[0] || null;\n let fixedBlocks: { start: string; end: string }[] = [];\n if (fixedRow && fixedRow.blocks_json) {\n try { fixedBlocks = JSON.parse(fixedRow.blocks_json); } catch { fixedBlocks = []; }\n } else if (fixedRow) {\n fixedBlocks = legacyFieldsToBlocks(fixedRow.entry_time, fixedRow.outing_time, fixedRow.reentry_time, fixedRow.exit_time);\n }\n const adhocBlocks = rowsToObjects(adhocResult, [\"start_time\", \"end_time\"]).map((r: any) => ({\n start: r.start_time, end: r.end_time,\n }));\n const events = deriveScheduleEvents([...fixedBlocks, ...adhocBlocks]);\n return json({ date, events });\n } catch (e) {\n console.error(\"schedule_today error\", e);\n return json({ error: \"오늘의 스케줄을 불러오지 못했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"today_status\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const date = body.date ? String(body.date).trim() : null;\n if (!studentId || !date) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const [planResult, diaryResult, chatResult] = await Promise.all([\n sqlite.execute({\n sql: \"SELECT COUNT(*) as cnt FROM holo_plan_submissions WHERE student_id = ? AND submit_date = ?\",\n args: [studentId, date],\n }),\n sqlite.execute({\n sql: \"SELECT q1, q2, q3, q4 FROM holo_diary_entries WHERE student_id = ? AND entry_date = ?\",\n args: [studentId, date],\n }),\n sqlite.execute({\n sql: \"SELECT COUNT(*) as cnt FROM holo_worries WHERE student_id = ? AND subject = 'chat' AND chat_date = ?\",\n args: [studentId, date],\n }),\n ]);\n const planRow = (planResult.rows || [])[0] as any;\n const hasPlan = planRow ? Number(Array.isArray(planRow) ? planRow[0] : planRow.cnt) > 0 : false;\n const diaryRow = (diaryResult.rows || [])[0] as any;\n const [dq1, dq2, dq3, dq4] = diaryRow\n ? (Array.isArray(diaryRow) ? diaryRow : [diaryRow.q1, diaryRow.q2, diaryRow.q3, diaryRow.q4])\n : [\"\", \"\", \"\", \"\"];\n const hasDiary = !!(dq1 && dq2 && dq3 && dq4);\n const chatRow = (chatResult.rows || [])[0] as any;\n const hasChat = chatRow ? Number(Array.isArray(chatRow) ? chatRow[0] : chatRow.cnt) > 0 : false;\n return json({ hasPlan, hasDiary, hasChat });\n } catch (e) {\n console.error(\"today_status error\", e);\n return json({ error: \"상태를 불러오지 못했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"week_score\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const date = body.date ? String(body.date).trim() : null; // \"YYYY-MM-DD\" (오늘)\n const joinDate = body.joinDate ? String(body.joinDate).trim() : null; // \"YYYY-MM-DD\" 학생 가입일(있으면)\n if (!studentId || !date) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const [y, m, d] = date.split(\"-\").map(Number);\n const pad = (n: number) => String(n).padStart(2, \"0\");\n const firstWeekday = new Date(y, m - 1, 1).getDay(); // 0=일요일\n const firstSunday = 1 + ((7 - firstWeekday) % 7);\n let weekStartDay = d <= firstSunday ? 1 : firstSunday + 1 + (Math.ceil((d - firstSunday) / 7) - 2) * 7;\n let weekStartStr = `${y}-${pad(m)}-${pad(weekStartDay)}`;\n if (joinDate && /^\\d{4}-\\d{2}-\\d{2}$/.test(joinDate) && joinDate > weekStartStr && joinDate <= date) {\n weekStartDay = Number(joinDate.split(\"-\")[2]);\n weekStartStr = joinDate;\n }\n const dayCount = d - weekStartDay + 1;\n\n const [planResult, diaryResult, chatResult] = await Promise.all([\n sqlite.execute({\n sql: \"SELECT submit_date FROM holo_plan_submissions WHERE student_id = ? AND submit_date >= ? AND submit_date <= ?\",\n args: [studentId, weekStartStr, date],\n }),\n sqlite.execute({\n sql: \"SELECT entry_date, q1, q2, q3, q4 FROM holo_diary_entries WHERE student_id = ? AND entry_date >= ? AND entry_date <= ?\",\n args: [studentId, weekStartStr, date],\n }),\n sqlite.execute({\n sql:\n \"SELECT chat_date as d, COUNT(*) as cnt FROM holo_worries WHERE student_id = ? AND subject = 'chat' AND chat_date >= ? AND chat_date <= ? GROUP BY d\",\n args: [studentId, weekStartStr, date],\n }),\n ]);\n\n const rowsToObjs = (result: any, keys: string[]) =>\n (result.rows || []).map((r: any) => {\n if (Array.isArray(r)) {\n const obj: any = {};\n keys.forEach((k, i) => (obj[k] = r[i]));\n return obj;\n }\n return r;\n });\n\n const planDates = new Set(rowsToObjs(planResult, [\"submit_date\"]).map((r: any) => r.submit_date));\n const diaryDates = new Set(\n rowsToObjs(diaryResult, [\"entry_date\", \"q1\", \"q2\", \"q3\", \"q4\"])\n .filter((r: any) => r.q1 && r.q2 && r.q3 && r.q4)\n .map((r: any) => r.entry_date),\n );\n const chatDates = new Set(rowsToObjs(chatResult, [\"d\", \"cnt\"]).map((r: any) => r.d));\n\n let sum = 0;\n for (let day = weekStartDay; day <= d; day++) {\n const dateStr = `${y}-${pad(m)}-${pad(day)}`;\n sum += (planDates.has(dateStr) ? 1 : 0) + (diaryDates.has(dateStr) ? 1 : 0) + (chatDates.has(dateStr) ? 1 : 0);\n }\n const avgScore = dayCount > 0 ? Math.round((sum / dayCount) * 10) / 10 : 0;\n return json({ avgScore, days: dayCount });\n } catch (e) {\n console.error(\"week_score error\", e);\n return json({ error: \"주간 점수를 불러오지 못했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"month_week_scores\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const ym = body.ym && /^\\d{4}-\\d{2}$/.test(String(body.ym).trim()) ? String(body.ym).trim() : null;\n const joinDate = body.joinDate ? String(body.joinDate).trim() : null;\n if (!studentId || !ym) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const [y, m] = ym.split(\"-\").map(Number);\n const pad = (n: number) => String(n).padStart(2, \"0\");\n const daysInMonth = new Date(y, m, 0).getDate();\n const monthStartStr = `${y}-${pad(m)}-01`;\n const monthEndStr = `${y}-${pad(m)}-${pad(daysInMonth)}`;\n const todayStr = kstTodayStr();\n if (monthStartStr > todayStr) return json({ weeks: [] }); // 이 달 전체가 아직 시작 전\n const effectiveEndStr = monthEndStr < todayStr ? monthEndStr : todayStr;\n const rangeStartStr = joinDate && /^\\d{4}-\\d{2}-\\d{2}$/.test(joinDate) && joinDate > monthStartStr ? joinDate : monthStartStr;\n if (rangeStartStr > effectiveEndStr) return json({ weeks: [] }); // 가입일이 이 달 안에서도 아직 안 됨\n\n const [planResult, diaryResult, chatResult] = await Promise.all([\n sqlite.execute({\n sql: \"SELECT DISTINCT submit_date FROM holo_plan_submissions WHERE student_id = ? AND submit_date >= ? AND submit_date <= ?\",\n args: [studentId, rangeStartStr, effectiveEndStr],\n }),\n sqlite.execute({\n sql: \"SELECT entry_date, q1, q2, q3, q4 FROM holo_diary_entries WHERE student_id = ? AND entry_date >= ? AND entry_date <= ?\",\n args: [studentId, rangeStartStr, effectiveEndStr],\n }),\n sqlite.execute({\n sql: \"SELECT DISTINCT chat_date as d FROM holo_worries WHERE student_id = ? AND subject = 'chat' AND chat_date >= ? AND chat_date <= ?\",\n args: [studentId, rangeStartStr, effectiveEndStr],\n }),\n ]);\n\n const planDates = new Set(rowsToObjects(planResult, [\"submit_date\"]).map((r: any) => r.submit_date));\n const diaryDates = new Set(\n rowsToObjects(diaryResult, [\"entry_date\", \"q1\", \"q2\", \"q3\", \"q4\"])\n .filter((r: any) => r.q1 && r.q2 && r.q3 && r.q4)\n .map((r: any) => r.entry_date),\n );\n const chatDates = new Set(rowsToObjects(chatResult, [\"d\"]).map((r: any) => r.d));\n\n const firstWeekday = new Date(y, m - 1, 1).getDay();\n const firstSunday = 1 + ((7 - firstWeekday) % 7);\n const lastWeek = firstSunday >= daysInMonth ? 1 : 1 + Math.ceil((daysInMonth - firstSunday) / 7);\n const weeks: { week: number; avgScore: number; days: number }[] = [];\n for (let w = 1; w <= lastWeek; w++) {\n const startDay = w === 1 ? 1 : firstSunday + 1 + (w - 2) * 7;\n const endDay = w === 1 ? Math.min(firstSunday, daysInMonth) : Math.min(startDay + 6, daysInMonth);\n const wStartStr = `${y}-${pad(m)}-${pad(startDay)}`;\n const wEndStr = `${y}-${pad(m)}-${pad(endDay)}`;\n if (wStartStr > effectiveEndStr) continue; // 이 주는 통째로 아직 시작 전\n if (wEndStr < rangeStartStr) continue; // 이 주는 통째로 가입 전\n const clampStartDay = wStartStr < rangeStartStr ? Number(rangeStartStr.split(\"-\")[2]) : startDay;\n const clampEndDay = wEndStr > effectiveEndStr ? Number(effectiveEndStr.split(\"-\")[2]) : endDay;\n const dayCount = clampEndDay - clampStartDay + 1;\n let sum = 0;\n for (let day = clampStartDay; day <= clampEndDay; day++) {\n const dateStr = `${y}-${pad(m)}-${pad(day)}`;\n sum += (planDates.has(dateStr) ? 1 : 0) + (diaryDates.has(dateStr) ? 1 : 0) + (chatDates.has(dateStr) ? 1 : 0);\n }\n weeks.push({ week: w, avgScore: dayCount > 0 ? Math.round((sum / dayCount) * 10) / 10 : 0, days: dayCount });\n }\n return json({ weeks });\n } catch (e) {\n console.error(\"month_week_scores error\", e);\n return json({ error: \"주차별 점수를 불러오지 못했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"ranking_scores\") {\n const period = body.period === \"week\" ? \"week\" : \"today\";\n const date = body.date ? String(body.date).trim() : null; // \"오늘\"(새벽 6시 기준 학습일, 프론트가 계산해서 보냄)\n const studentIds = Array.isArray(body.studentIds)\n ? Array.from(new Set(body.studentIds.map((id: any) => String(id).trim()).filter(Boolean)))\n : [];\n if (!date || !studentIds.length) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n let rangeStart = date;\n let dayCount = 1;\n if (period === \"week\") {\n const [y, m, d] = date.split(\"-\").map(Number);\n const dow = new Date(y, m - 1, d).getDay(); // 0=일 1=월 ... 6=토\n const mondayOffset = dow === 0 ? 6 : dow - 1;\n const monday = new Date(y, m - 1, d - mondayOffset);\n const pad = (n: number) => String(n).padStart(2, \"0\");\n rangeStart = `${monday.getFullYear()}-${pad(monday.getMonth() + 1)}-${pad(monday.getDate())}`;\n dayCount = mondayOffset + 1;\n }\n const inClause = \"(\" + studentIds.map(() => \"?\").join(\",\") + \")\";\n const [planResult, diaryResult, chatResult] = await Promise.all([\n sqlite.execute({\n sql: `SELECT student_id, submit_date FROM holo_plan_submissions WHERE submit_date >= ? AND submit_date <= ? AND student_id IN ${inClause}`,\n args: [rangeStart, date, ...studentIds],\n }),\n sqlite.execute({\n sql: `SELECT student_id, entry_date, q1, q2, q3, q4 FROM holo_diary_entries WHERE entry_date >= ? AND entry_date <= ? AND student_id IN ${inClause}`,\n args: [rangeStart, date, ...studentIds],\n }),\n sqlite.execute({\n sql: `SELECT DISTINCT student_id, chat_date FROM holo_worries WHERE subject = 'chat' AND chat_date >= ? AND chat_date <= ? AND student_id IN ${inClause}`,\n args: [rangeStart, date, ...studentIds],\n }),\n ]);\n const planSet = new Set(rowsToObjects(planResult, [\"student_id\", \"submit_date\"]).map((r: any) => r.student_id + \"|\" + r.submit_date));\n const diarySet = new Set(\n rowsToObjects(diaryResult, [\"student_id\", \"entry_date\", \"q1\", \"q2\", \"q3\", \"q4\"])\n .filter((r: any) => r.q1 && r.q2 && r.q3 && r.q4)\n .map((r: any) => r.student_id + \"|\" + r.entry_date),\n );\n const chatSet = new Set(rowsToObjects(chatResult, [\"student_id\", \"chat_date\"]).map((r: any) => r.student_id + \"|\" + r.chat_date));\n\n const pad2 = (n: number) => String(n).padStart(2, \"0\");\n const [ry, rm, rd] = rangeStart.split(\"-\").map(Number);\n const scores: Record = {};\n for (const id of studentIds) {\n let sum = 0;\n for (let i = 0; i < dayCount; i++) {\n const day = new Date(ry, rm - 1, rd + i);\n const dStr = `${day.getFullYear()}-${pad2(day.getMonth() + 1)}-${pad2(day.getDate())}`;\n const key = id + \"|\" + dStr;\n sum += (planSet.has(key) ? 1 : 0) + (diarySet.has(key) ? 1 : 0) + (chatSet.has(key) ? 1 : 0);\n }\n scores[id] = period === \"week\" ? Math.round((sum / dayCount) * 10) / 10 : sum;\n }\n return json({ scores });\n } catch (e) {\n console.error(\"ranking_scores error\", e);\n return json({ error: \"랭킹 점수를 불러오지 못했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"day_list\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n if (!studentId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const [planDatesResult, diaryDatesResult] = await Promise.all([\n sqlite.execute({\n sql: \"SELECT DISTINCT plan_date FROM holo_plans WHERE student_id = ?\",\n args: [studentId],\n }),\n sqlite.execute({\n sql: \"SELECT DISTINCT entry_date FROM holo_diary_entries WHERE student_id = ?\",\n args: [studentId],\n }),\n ]);\n const rowsToVals = (result: any) =>\n (result.rows || []).map((r: any) => (Array.isArray(r) ? r[0] : Object.values(r)[0]));\n const dateSet = new Set([...rowsToVals(planDatesResult), ...rowsToVals(diaryDatesResult)]);\n const dates = Array.from(dateSet).sort().reverse();\n\n const days = await Promise.all(dates.map(async (date) => {\n const [planResult, diaryResult, chatResult] = await Promise.all([\n sqlite.execute({\n sql: \"SELECT COUNT(*) as cnt FROM holo_plan_submissions WHERE student_id = ? AND submit_date = ?\",\n args: [studentId, date],\n }),\n sqlite.execute({\n sql: \"SELECT q1, q2, q3, q4 FROM holo_diary_entries WHERE student_id = ? AND entry_date = ?\",\n args: [studentId, date],\n }),\n sqlite.execute({\n sql: \"SELECT COUNT(*) as cnt FROM holo_worries WHERE student_id = ? AND subject = 'chat' AND chat_date = ?\",\n args: [studentId, date],\n }),\n ]);\n const planRow = (planResult.rows || [])[0] as any;\n const planCount = planRow ? Number(Array.isArray(planRow) ? planRow[0] : planRow.cnt) : 0;\n const diaryRow = (diaryResult.rows || [])[0] as any;\n const [dq1, dq2, dq3, dq4] = diaryRow\n ? (Array.isArray(diaryRow) ? diaryRow : [diaryRow.q1, diaryRow.q2, diaryRow.q3, diaryRow.q4])\n : [\"\", \"\", \"\", \"\"];\n const hasDiary = !!(dq1 && dq2 && dq3 && dq4);\n const chatRow = (chatResult.rows || [])[0] as any;\n const chatCount = chatRow ? Number(Array.isArray(chatRow) ? chatRow[0] : chatRow.cnt) : 0;\n\n const hasPlan = planCount > 0;\n const hasChat = chatCount > 0;\n const score = (hasPlan ? 1 : 0) + (hasDiary ? 1 : 0) + (hasChat ? 1 : 0);\n\n return { date, hasPlan, hasDiary, hasChat, score };\n }));\n\n return json({ days });\n } catch (e) {\n console.error(\"day_list error\", e);\n return json({ error: \"기록을 불러오지 못했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"day_detail\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n const date = body.date ? String(body.date).trim() : null;\n if (!studentId || !date) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const stored = await sqlite.execute({\n sql: \"SELECT plan_text, diary_text, chat_text FROM holo_day_records WHERE student_id = ? AND record_date = ?\",\n args: [studentId, date],\n });\n const storedRows = rowsToObjects(stored, [\"plan_text\", \"diary_text\", \"chat_text\"]);\n if (storedRows.length) {\n const r = storedRows[0] as any;\n return json({ plan: r.plan_text, diary: r.diary_text, chat: r.chat_text });\n }\n\n const [planResult, diaryResult, chatResult] = await Promise.all([\n sqlite.execute({\n sql: \"SELECT block, subject, text, original_text, done, is_initial FROM holo_plans WHERE student_id = ? AND plan_date = ? AND active = 1 ORDER BY id ASC\",\n args: [studentId, date],\n }),\n sqlite.execute({\n sql: \"SELECT q1, q2, q3, q4, free_text FROM holo_diary_entries WHERE student_id = ? AND entry_date = ?\",\n args: [studentId, date],\n }),\n sqlite.execute({\n sql: \"SELECT raw_text FROM holo_worries WHERE student_id = ? AND subject = 'chat' AND chat_date = ? ORDER BY id ASC\",\n args: [studentId, date],\n }),\n ]);\n\n const planRows = rowsToObjects(planResult, [\"block\", \"subject\", \"text\", \"original_text\", \"done\", \"is_initial\"]);\n const diaryRows = rowsToObjects(diaryResult, [\"q1\", \"q2\", \"q3\", \"q4\", \"free_text\"]);\n const d = (diaryRows[0] || {}) as any;\n const chatRows = rowsToObjects(chatResult, [\"raw_text\"]);\n\n return json({\n plan: buildDayPlanBlock(planRows),\n diary: buildDayDiaryBlock(d.q1 || \"\", d.q2 || \"\", d.q3 || \"\", d.q4 || \"\", d.free_text || \"\"),\n chat: buildDayChatBlock(chatRows.map((r: any) => r.raw_text)),\n });\n } catch (e) {\n console.error(\"day_detail error\", e);\n return json({ error: \"불러오지 못했습니다.\" }, 500);\n }\n }\n\n if (body.action === \"worries\") {\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n if (!studentId) return json({ error: \"잘못된 요청입니다.\" }, 400);\n try {\n const result = await sqlite.execute({\n sql: \"SELECT subject, raw_text, ai_summary, created_at FROM holo_worries WHERE student_id = ? ORDER BY id DESC LIMIT 200\",\n args: [studentId],\n });\n const rows = (result.rows || []).map((r: any) =>\n Array.isArray(r)\n ? { subject: r[0], raw_text: r[1], ai_summary: r[2], created_at: r[3] }\n : r\n );\n return json({ worries: rows });\n } catch (e) {\n console.error(\"worries fetch error\", e);\n return json({ worries: [] });\n }\n }\n\n const subject = VALID_SUBJECTS.has(body.subject) ? body.subject : null;\n const messages = Array.isArray(body.messages) ? body.messages : [];\n const studentId = body.studentId ? String(body.studentId).trim() : null;\n\n if (!subject || !messages.length) {\n return json({ error: \"잘못된 요청입니다.\" }, 400);\n }\n\n const trimmed: any[] = messages.slice(-20).map((m: any) => ({\n role: m.role === \"assistant\" ? \"assistant\" : \"user\",\n content: String(m.content || \"\").slice(0, 2000),\n }));\n\n const lastUserText: string | null = trimmed.length ? trimmed[trimmed.length - 1].content : null;\n const image = body.image;\n if (image && image.data && trimmed.length) {\n const last = trimmed[trimmed.length - 1];\n if (last.role === \"user\") {\n last.content = [\n { type: \"image\", source: { type: \"base64\", media_type: image.mediaType || \"image/jpeg\", data: image.data } },\n { type: \"text\", text: last.content },\n ];\n }\n }\n\n const isConfirmStyle = CONFIRM_STYLE_SUBJECTS.includes(subject);\n\n const promptFile = subject === SCHEDULE_SUBJECT\n ? \"system-prompt-schedule.txt\"\n : subject === PLAN_SUBJECT\n ? \"system-prompt-plan.txt\"\n : (isConfirmStyle ? \"system-prompt-worry.txt\" : \"system-prompt.txt\");\n\n let systemPromptTemplate: string, subjectData: string;\n try {\n [systemPromptTemplate, subjectData] = await Promise.all([\n loadText(promptFile),\n loadSubjectData(subject),\n ]);\n } catch (e) {\n console.error(e);\n return json({ error: \"학습 자료를 불러오지 못했습니다. 잠시 후 다시 시도해주세요.\" });\n }\n\n const todayPlanText = subject === PLAN_SUBJECT ? await loadTodayPlanForPrompt(studentId) : \"\";\n const studentHabitsText = subject === PLAN_SUBJECT ? await loadStudentHabitsForPrompt(studentId) : \"\";\n\n const studentBranch = body.studentBranch ? String(body.studentBranch).trim() : \"\";\n const studentGrade = body.studentGrade ? String(body.studentGrade).trim() : \"\";\n const studentInfoText = (studentBranch || studentGrade)\n ? `관 유형: ${studentBranch || \"확인되지 않음\"} / 학년: ${studentGrade || \"확인되지 않음\"}`\n : \"확인되지 않음\";\n\n const system =\n systemPromptTemplate\n .replace(\"{DATA}\", subjectData)\n .replace(\"{TODAY}\", kstTodayStr())\n .replace(\"{TODAY_PLAN}\", todayPlanText)\n .replace(\"{STUDENT_HABITS}\", studentHabitsText)\n .replace(\"{STUDENT_INFO}\", studentInfoText) +\n \"\\n\\n## 현재 질문 과목\\n\" +\n SUBJECT_HINTS[subject];\n\n const apiKey = Deno.env.get(\"ANTHROPIC_API_KEY\");\n\n try {\n const res = await fetch(\"https://api.anthropic.com/v1/messages\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"x-api-key\": apiKey ?? \"\",\n \"anthropic-version\": \"2023-06-01\",\n },\n body: JSON.stringify({\n model: MODEL,\n max_tokens: MAX_TOKENS,\n system: [{ type: \"text\", text: system, cache_control: { type: \"ephemeral\" } }],\n messages: trimmed,\n }),\n });\n\n const data = await res.json();\n if (!res.ok) {\n console.error(\"Anthropic API error\", data);\n return json({ error: \"AI 응답 중 오류가 발생했습니다.\", status: res.status, debug: data });\n }\n let answer = data.content?.[0]?.text || \"답변을 생성하지 못했습니다.\";\n let planDate: string | null = null;\n let evidenceChoice = false;\n\n if (subject === SCHEDULE_SUBJECT) {\n const evMatch = answer.match(/```EVIDENCE_CHOICE\\s*```/);\n if (evMatch) {\n evidenceChoice = true;\n const idx = answer.indexOf(evMatch[0]);\n answer = (answer.slice(0, idx) + answer.slice(idx + evMatch[0].length)).trim();\n }\n try {\n answer = await extractAndSaveScheduleJson(studentId, answer);\n } catch (e) {\n console.error(\"schedule json save error\", e);\n }\n } else if (subject === PLAN_SUBJECT) {\n const analyzeExtracted = extractAnalyzeDateJson(answer);\n if (analyzeExtracted.date) {\n try {\n const datePlanText = await loadPlanForPromptByDate(studentId, analyzeExtracted.date);\n const followupMessages = [\n ...trimmed,\n { role: \"assistant\", content: analyzeExtracted.text || \"네, 확인해볼게요.\" },\n {\n role: \"user\",\n content:\n `[시스템 자동 안내] ${analyzeExtracted.date}에 세운 계획은 다음과 같습니다:\\n` +\n datePlanText +\n `\\n위 계획 자료를 참고해서, 방금 요청하신 대로 이 날짜의 계획이 괜찮은지 분석해서 ` +\n `답변해주세요. 학생한테 계획 내용을 다시 말해달라고 하지 마세요. 이번 답변에는 ` +\n `ANALYZE_DATE_JSON이나 PLAN_DATE_JSON 블록을 포함하지 마세요.`,\n },\n ];\n const followupRes = await fetch(\"https://api.anthropic.com/v1/messages\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"x-api-key\": apiKey ?? \"\",\n \"anthropic-version\": \"2023-06-01\",\n },\n body: JSON.stringify({\n model: MODEL,\n max_tokens: MAX_TOKENS,\n system: [{ type: \"text\", text: system, cache_control: { type: \"ephemeral\" } }],\n messages: followupMessages,\n }),\n });\n const followupData = await followupRes.json();\n if (followupRes.ok && followupData.content?.[0]?.text) {\n answer = extractPlanDateJson(extractAnalyzeDateJson(followupData.content[0].text).text).text;\n } else {\n console.error(\"plan analyze followup error\", followupData);\n answer = \"계획을 분석하는 중 문제가 생겼어요. 잠시 후 다시 시도해주세요.\";\n }\n } catch (e) {\n console.error(\"plan analyze followup fetch error\", e);\n answer = \"계획을 분석하는 중 문제가 생겼어요. 잠시 후 다시 시도해주세요.\";\n }\n } else {\n const extracted = extractPlanDateJson(answer);\n answer = extracted.text;\n planDate = extracted.date;\n }\n }\n\n if (studentId) {\n try {\n const chatDate = body.date && /^\\d{4}-\\d{2}-\\d{2}$/.test(String(body.date)) ? String(body.date) : kstTodayStr();\n if (lastUserText) await saveTurn(studentId, subject, \"user\", lastUserText, chatDate);\n await saveTurn(studentId, subject, \"assistant\", answer, chatDate);\n if (lastUserText && subject !== SCHEDULE_SUBJECT) {\n const imageDataUrl = image && image.data ? \"data:\" + (image.mediaType || \"image/jpeg\") + \";base64,\" + image.data : null;\n await saveWorry(studentId, subject, lastUserText, answer, imageDataUrl, chatDate);\n }\n } catch (e) {\n console.error(\"history/worry save error\", e);\n }\n }\n\n return json({ answer, planDate, evidenceChoice });\n } catch (e) {\n console.error(e);\n return json({ error: \"서버 오류가 발생했습니다.\" }, 500);\n }\n}","deleted","label",[109],"pulls","branches",1,"forks","envVars",{"_132":126,"_134":42},"connections",{"_132":42,"_133":42},"count","unfilledCount","emptyCount",{"_18":108,"_20":109,"_110":36,"_111":-5,"_112":68,"_113":66,"_114":38,"_22":136,"_65":116,"_117":118,"_119":120,"_121":26,"_122":-5,"_137":138,"_86":139},["D",1789104726277],"children",[],[109],["D",1787549925310],{"_16":17,"_84":80},{"_16":17,"_77":78,"_79":80,"_33":34,"_81":82,"_83":26},{"_65":66,"_20":67,"_18":68,"_69":19,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":21,"_76":17},"ctx",{"_58":-5,"_104":177,"_178":179,"_180":181,"_182":26,"_183":26,"_184":26,"_185":38,"_186":-5,"_187":-7,"_188":-7,"_189":42,"_190":26,"_191":26,"_192":-5,"_193":26,"_194":26,"_195":26,"_196":-5},"ENV",{"_148":149,"_150":151,"_152":67,"_153":154,"_155":156,"_157":158,"_159":160,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176},"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"]

Search