[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_192":193,"_194":195},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_146":-5,"_20":147,"_22":148,"_149":150,"_151":152,"_26":153,"_24":154,"_155":-5,"_156":-5,"_157":53,"_158":159,"_160":45,"_161":-5,"_162":-5,"_163":164},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","yoshiokaren","name","yoyaku-app","branchName","main","version","path","frontend/index.html","project",{"_33":88,"_13":14,"_46":89,"_90":-5,"_91":53,"_92":93,"_94":93,"_95":96,"_97":-5,"_98":99,"_100":61,"_101":45,"_102":-5,"_103":-5,"_104":48,"_105":106,"_107":108,"_109":110,"_111":112,"_113":-5,"_114":115,"_116":115,"_117":118,"_119":118,"_120":118,"_121":115,"_122":115,"_123":124,"_125":126,"_127":128,"_129":53},"tree",[57,58],"file",{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_18":55},"contents",[],"upstream","pull","ahead","behind","envVars","id","f0b126d5-9458-4323-9373-6c411a7157c3","index.html","fileId","22e06f70-789d-11f1-b7b9-1607ee4eb77e","parentId","42ac0732-0a78-43d3-a4bc-5b868c928259","branchId","6f493242-f0ab-4e59-9e00-dc3b2817f4fc","branchVersion",2,"latest",true,"createdAt",["D",1783275171531],0,"fileType","content","\n\n \n \n \n 予約フォーム\n \n \n \n \n

\n \n \n\n","deleted",false,"label",[56,35],"frontend",{"_33":69,"_13":56,"_36":39,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":70,"_17":48,"_49":71,"_50":-5,"_52":53,"_54":-5,"_66":72,"_18":73},{"_33":59,"_13":60,"_36":61,"_38":-5,"_40":41,"_42":62,"_44":45,"_46":63,"_17":48,"_49":64,"_50":65,"_52":53,"_54":-5,"_66":67,"_18":68},"931bca1a-a5f1-4e6d-9619-a172e741615e","main.ts","1e1e736a-789d-11f1-8f84-1607ee4eb77e",1,["D",1783275163557],"http","// 予約アプリ — HTTP val (Hono + SQLite)\n// Learn more: https://docs.val.town/vals/http/\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n/* ───────────── 設定（ここを変えれば営業時間・枠が変わります） ───────────── */\nconst CONFIG = {\n openHour: 10, // 営業開始（時）\n closeHour: 18, // 営業終了（時）— この時刻の開始枠は作りません\n slotMinutes: 60, // 1枠の長さ（分）\n openWeekdays: [1, 2, 3, 4, 5, 6], // 予約可能な曜日 0=日 … 6=土\n daysAhead: 30, // 何日先まで予約可能か\n};\n\n/* ───────────── DB 初期化 ───────────── */\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS reservations (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n slot TEXT NOT NULL UNIQUE,\n name TEXT NOT NULL,\n contact TEXT NOT NULL,\n notes TEXT,\n created_at TEXT NOT NULL\n)`);\n\n/* ───────────── ユーティリティ ───────────── */\nfunction slotsForDate(dateStr: string): string[] {\n const [y, m, d] = dateStr.split(\"-\").map(Number);\n const dow = new Date(Date.UTC(y, m - 1, d)).getUTCDay();\n if (!CONFIG.openWeekdays.includes(dow)) return [];\n const out: string[] = [];\n for (let min = CONFIG.openHour * 60; min < CONFIG.closeHour * 60; min += CONFIG.slotMinutes) {\n const hh = String(Math.floor(min / 60)).padStart(2, \"0\");\n const mm = String(min % 60).padStart(2, \"0\");\n out.push(`${hh}:${mm}`);\n }\n return out;\n}\n\nfunction isValidDate(dateStr: string): boolean {\n return /^\\d{4}-\\d{2}-\\d{2}$/.test(dateStr) && !Number.isNaN(Date.parse(dateStr));\n}\n\n/* ───────────── アプリ ───────────── */\nconst app = new Hono();\n\n// フロントエンド配信\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\", import.meta.url));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// ソース表示\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// 指定日の空き枠を返す\napp.get(\"/api/slots\", async (c) => {\n const date = c.req.query(\"date\") ?? \"\";\n if (!isValidDate(date)) return c.json({ error: \"invalid date\" }, 400);\n const all = slotsForDate(date);\n const taken = await sqlite.execute({\n sql: \"SELECT slot FROM reservations WHERE slot LIKE ?\",\n args: [`${date}T%`],\n });\n const takenSet = new Set(taken.rows.map((r: any) => String(r.slot)));\n const slots = all.map((t) => ({ time: t, available: !takenSet.has(`${date}T${t}`) }));\n return c.json({ date, slots });\n});\n\n// 予約作成\napp.post(\"/api/reservations\", async (c) => {\n const body = await c.req.json().catch(() => null);\n if (!body) return c.json({ error: \"invalid body\" }, 400);\n const { date, time, name, contact, notes } = body as Record;\n\n if (!isValidDate(date) || !/^\\d{2}:\\d{2}$/.test(time ?? \"\")) {\n return c.json({ error: \"日付または時間の形式が不正です\" }, 400);\n }\n if (!slotsForDate(date).includes(time)) {\n return c.json({ error: \"その時間は予約枠外です\" }, 400);\n }\n if (!name?.trim()) return c.json({ error: \"お名前を入力してください\" }, 400);\n if (!contact?.trim()) return c.json({ error: \"メールまたは電話を入力してください\" }, 400);\n\n const slot = `${date}T${time}`;\n try {\n await sqlite.execute({\n sql: \"INSERT INTO reservations (slot, name, contact, notes, created_at) VALUES (?, ?, ?, ?, ?)\",\n args: [slot, name.trim(), contact.trim(), (notes ?? \"\").trim(), new Date().toISOString()],\n });\n } catch (e: any) {\n if (String(e?.message ?? e).includes(\"UNIQUE\")) {\n return c.json({ error: \"申し訳ありません。その枠は先ほど埋まりました。別の時間をお選びください。\" }, 409);\n }\n throw e;\n }\n return c.json({ ok: true, slot });\n});\n\n// 管理用：予約一覧（本番では認証を追加してください。valtown:oauth スキル参照）\napp.get(\"/api/reservations\", async (c) => {\n const rows = await sqlite.execute(\n \"SELECT id, slot, name, contact, notes, created_at FROM reservations ORDER BY slot ASC\",\n );\n return c.json({ reservations: rows.rows });\n});\n\n// 設定をフロントに渡す\napp.get(\"/api/config\", (c) =>\n c.json({ daysAhead: CONFIG.daysAhead, slotMinutes: CONFIG.slotMinutes }),\n);\n\n// エラー時にフルスタックトレースを出す\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[60],"063ad1b2-0048-4d9d-a8dc-917b1a1f0100",["D",1783275171531],"directory",[74,75],[56],{"_33":79,"_13":80,"_36":81,"_38":39,"_40":41,"_42":82,"_44":45,"_46":83,"_17":48,"_49":84,"_50":85,"_52":53,"_54":-5,"_66":86,"_18":87},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":76,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_66":77,"_18":78},["D",1783275171531],[],[56,35],"6190b916-402e-4ee0-9ef0-272ed64b0959","app.tsx","30e0b382-789d-11f1-9e9e-1607ee4eb77e",3,["D",1783275195031],"script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0\";\n\ntype Slot = { time: string; available: boolean };\n\nconst WEEKDAYS = [\"日\", \"月\", \"火\", \"水\", \"木\", \"金\", \"土\"];\n\nfunction buildDates(daysAhead: number): string[] {\n const out: string[] = [];\n const base = new Date();\n for (let i = 0; i < daysAhead; i++) {\n const d = new Date(base);\n d.setDate(base.getDate() + i);\n const s = `${d.getFullYear()}-${String(d.getMonth() + 1).padStart(2, \"0\")}-${String(d.getDate()).padStart(2, \"0\")}`;\n out.push(s);\n }\n return out;\n}\n\nfunction labelForDate(s: string): string {\n const [y, m, d] = s.split(\"-\").map(Number);\n const dow = new Date(y, m - 1, d).getDay();\n return `${m}/${d}（${WEEKDAYS[dow]}）`;\n}\n\nfunction App() {\n const [dates, setDates] = useState([]);\n const [date, setDate] = useState(\"\");\n const [slots, setSlots] = useState([]);\n const [time, setTime] = useState(\"\");\n const [name, setName] = useState(\"\");\n const [contact, setContact] = useState(\"\");\n const [notes, setNotes] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const [msg, setMsg] = useState<{ type: \"ok\" | \"err\"; text: string } | null>(null);\n const [done, setDone] = useState<{ date: string; time: string } | null>(null);\n\n useEffect(() => {\n fetch(\"/api/config\")\n .then((r) => r.json())\n .then((cfg) => {\n const ds = buildDates(cfg.daysAhead ?? 30);\n setDates(ds);\n setDate(ds[0] ?? \"\");\n });\n }, []);\n\n useEffect(() => {\n if (!date) return;\n setTime(\"\");\n setSlots([]);\n fetch(`/api/slots?date=${date}`)\n .then((r) => r.json())\n .then((d) => setSlots(d.slots ?? []));\n }, [date]);\n\n async function submit(e: React.FormEvent) {\n e.preventDefault();\n setMsg(null);\n if (!time) return setMsg({ type: \"err\", text: \"時間を選択してください\" });\n setLoading(true);\n try {\n const res = await fetch(\"/api/reservations\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ date, time, name, contact, notes }),\n });\n const data = await res.json();\n if (!res.ok) {\n setMsg({ type: \"err\", text: data.error ?? \"予約に失敗しました\" });\n fetch(`/api/slots?date=${date}`).then((r) => r.json()).then((d) => setSlots(d.slots ?? []));\n } else {\n setDone({ date, time });\n }\n } catch {\n setMsg({ type: \"err\", text: \"通信エラーが発生しました\" });\n } finally {\n setLoading(false);\n }\n }\n\n if (done) {\n return (\n \n

✅

ご予約ありがとうございます

\n {labelForDate(done.date)} {done.time} で承りました。\n

\n {\n setDone(null);\n setName(\"\");\n setContact(\"\");\n setNotes(\"\");\n setTime(\"\");\n }}\n >\n 続けて予約する\n \n

\n \n );\n }\n\n return (\n \n

\n 日付\n setDate(e.target.value)}\n >\n {dates.map((d) => (\n \n ))}\n \n

\n\n

\n 時間\n {slots.length === 0 ? (\n

この日は予約枠がありません。

\n ) : (\n

\n {slots.map((s) => (\n setTime(s.time)}\n className={\n \"px-2 py-2 rounded text-sm border transition \" +\n (!s.available\n ? \"bg-gray-100 text-gray-400 cursor-not-allowed line-through\"\n : time === s.time\n ? \"bg-gray-800 text-white border-gray-800\"\n : \"bg-white hover:border-gray-800\")\n }\n >\n {s.time}\n \n ))}\n

\n )}\n

\n\n

\n お名前 *\n setName(e.target.value)}\n />\n

\n\n

\n メール / 電話 *\n setContact(e.target.value)}\n />\n

\n\n

\n 備考・ご要望\n setNotes(e.target.value)}\n />\n

\n\n {msg && (\n

\n {msg.text}\n

\n )}\n\n \n {loading ? \"送信中…\" : time ? `${labelForDate(date)} ${time} で予約する` : \"時間を選択してください\"}\n \n \n

\n );\n}\n\nfunction Shell({ children }: { children: React.ReactNode }) {\n return (\n

ご予約

ご希望の日時を選んでお申し込みください。

{children}

\n view source\n

\n );\n}\n\ncreateRoot(document.getElementById(\"root\")!).render();\n",[],[56,80],"48eeeb9e-1384-41be-8bae-bbf375670800",["D",1783275088408],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","日時予約フォーム (Hono + SQLite + React)","imageUrl","userId","2e5f3a11-3ecf-4768-a436-abfe0467880b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f3378-c037-7109-869d-8900c383fcb3","tursoName","48eeeb9e138441be8baebbf375670800","tursoHostname","48eeeb9e138441be8baebbf375670800-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789521041830],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_145":141},"org",{"_11":12,"_138":139,"_140":141,"_98":99,"_142":143,"_144":53},"branch",{"_17":82,"_13":16,"_33":41,"_130":88,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":14,"_137":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","吉岡蓮","avatar","https://lh3.googleusercontent.com/a/ACg8ocJoAQzKMObUH_Y10IrLwHP-VLUVThbIP7Q-p0QkGvJB2Re_AQ=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":88,"_13":14,"_46":187,"_90":-5,"_91":53,"_92":93,"_94":93,"_95":96,"_97":-5,"_98":99,"_100":61,"_101":45,"_102":-5,"_103":-5,"_104":48,"_105":106,"_107":108,"_109":110,"_111":188,"_113":-5,"_114":115,"_116":115,"_117":118,"_119":118,"_120":118,"_121":115,"_122":115,"_123":189,"_125":190,"_127":191,"_129":53},[175,178],"files",[175,176,177,178],"counts",{"_166":48,"_167":62,"_168":48,"_32":169,"_170":171},[],{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_18":165},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[56,35],"pulls","branches","forks",{"_172":48,"_174":48},"connections",{"_172":48,"_173":48},"count","unfilledCount","emptyCount",{"_33":69,"_13":56,"_36":39,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":70,"_17":48,"_49":71,"_50":-5,"_52":53,"_54":-5,"_66":185,"_18":186},{"_33":79,"_13":80,"_36":81,"_38":39,"_40":41,"_42":82,"_44":45,"_46":83,"_17":48,"_49":84,"_50":85,"_52":53,"_54":-5,"_66":183,"_18":184},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":76,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_66":181,"_18":182},{"_33":59,"_13":60,"_36":61,"_38":-5,"_40":41,"_42":62,"_44":45,"_46":63,"_17":48,"_49":64,"_50":65,"_52":53,"_54":-5,"_66":179,"_18":180},[],[60],[],[56,35],[],[56,80],[176,177],[56],["D",1783275088408],["D",1789521041830],{"_11":12,"_145":141},{"_11":12,"_138":139,"_140":141,"_98":99,"_142":143,"_144":53},{"_17":82,"_13":16,"_33":41,"_130":88,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":14,"_137":12},"ctx",{"_123":-5,"_162":225,"_226":227,"_228":229,"_230":53,"_231":53,"_232":53,"_233":45,"_234":-5,"_235":-7,"_236":-7,"_237":48,"_238":53,"_239":53,"_240":-5,"_241":53,"_242":53,"_243":53,"_244":-5},"ENV",{"_196":197,"_198":199,"_200":16,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]