[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_207":208,"_209":210},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_61":166,"_16":-7,"_167":-5,"_17":168,"_169":170,"_28":171,"_21":172,"_23":173,"_72":-5,"_174":-5,"_175":-5,"_176":35,"_177":178,"_179":38,"_180":-5,"_181":-5,"_182":183},"routes/_app.x.$handle.$name._index",{"_11":12,"_13":14,"_15":-7,"_16":-7,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-7,"_26":-5,"_27":-5,"_28":29,"_30":31,"_32":-5,"_33":-5,"_34":35,"_36":35,"_37":38},"handle","yoshiokaren","name","yoyaku-app","branchName","version","project",{"_39":107,"_13":14,"_50":108,"_109":-5,"_110":35,"_111":112,"_113":112,"_114":115,"_116":-5,"_117":118,"_119":43,"_120":38,"_121":-5,"_122":-5,"_123":52,"_124":125,"_126":127,"_128":129,"_130":131,"_132":-5,"_133":134,"_135":134,"_136":137,"_138":137,"_139":137,"_140":134,"_141":134,"_142":143,"_144":145,"_146":147,"_148":35},"tags",[],"counts",{"_97":52,"_98":48,"_99":52,"_100":101,"_102":103},"contents",[91,92],"readme","upstream","pull","files",[63,64,65,31],"preview",{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":51,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_59":60,"_61":62},"ahead","behind","showHomeCustomizationHint",false,"showHTTPPreviewSettingsHint","hasHTTPFiles",true,"id","931bca1a-a5f1-4e6d-9619-a172e741615e","main.ts","fileId","1e1e736a-789d-11f1-8f84-1607ee4eb77e","parentId","branchId","6f493242-f0ab-4e59-9e00-dc3b2817f4fc","branchVersion",1,"latest","createdAt",["D",1783275163557],0,"fileType","http","content","// 予約アプリ — 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","deleted","label","children",[],"path",[41],{"_39":86,"_13":76,"_42":69,"_44":-5,"_45":46,"_47":70,"_49":38,"_50":87,"_16":52,"_53":88,"_55":-5,"_57":35,"_58":-5,"_59":89,"_61":90},{"_39":77,"_13":78,"_42":79,"_44":69,"_45":46,"_47":80,"_49":38,"_50":81,"_16":52,"_53":82,"_55":83,"_57":35,"_58":-5,"_59":84,"_61":85},{"_39":66,"_13":67,"_42":68,"_44":69,"_45":46,"_47":70,"_49":38,"_50":71,"_16":52,"_53":72,"_55":73,"_57":35,"_58":-5,"_59":74,"_61":75},"f0b126d5-9458-4323-9373-6c411a7157c3","index.html","22e06f70-789d-11f1-b7b9-1607ee4eb77e","42ac0732-0a78-43d3-a4bc-5b868c928259",2,["D",1783275171531],"file","\n\n \n \n \n 予約フォーム\n \n \n \n \n

\n \n \n\n",[],[76,67],"frontend","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",[],[76,78],"063ad1b2-0048-4d9d-a8dc-917b1a1f0100",["D",1783275171531],"directory",[64,65],[76],{"_39":86,"_13":76,"_42":69,"_44":-5,"_45":46,"_47":70,"_49":38,"_50":95,"_16":52,"_53":88,"_55":-5,"_57":35,"_58":-5,"_61":96},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":93,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_61":94},["D",1783275163557],[41],["D",1783275171531],[76],"pulls","branches","forks","envVars",{"_104":52,"_106":52},"connections",{"_104":52,"_105":52},"count","unfilledCount","emptyCount","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,"_165":161},"org",{"_11":12,"_158":159,"_160":161,"_117":118,"_162":163,"_164":35},"branch",{"_16":80,"_13":149,"_39":46,"_150":107,"_151":-5,"_152":-5,"_153":-5,"_154":-5,"_155":-5,"_156":14,"_157":12},"isOwned","main","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",{"_39":107,"_13":14,"_50":202,"_109":-5,"_110":35,"_111":112,"_113":112,"_114":115,"_116":-5,"_117":118,"_119":43,"_120":38,"_121":-5,"_122":-5,"_123":52,"_124":125,"_126":127,"_128":129,"_130":203,"_132":-5,"_133":134,"_135":134,"_136":137,"_138":137,"_139":137,"_140":134,"_141":134,"_142":204,"_144":205,"_146":206,"_148":35},"tree",[190,193],[190,191,192,193],{"_97":52,"_98":48,"_99":52,"_100":188,"_102":189},[184,185],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_39":86,"_13":76,"_42":69,"_44":-5,"_45":46,"_47":70,"_49":38,"_50":95,"_16":52,"_53":88,"_55":-5,"_57":35,"_58":-5,"_61":187},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":93,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_61":186},[41],[76],{"_104":52,"_106":52},{"_104":52,"_105":52},{"_39":86,"_13":76,"_42":69,"_44":-5,"_45":46,"_47":70,"_49":38,"_50":87,"_16":52,"_53":88,"_55":-5,"_57":35,"_58":-5,"_59":200,"_61":201},{"_39":77,"_13":78,"_42":79,"_44":69,"_45":46,"_47":80,"_49":38,"_50":81,"_16":52,"_53":82,"_55":83,"_57":35,"_58":-5,"_59":198,"_61":199},{"_39":66,"_13":67,"_42":68,"_44":69,"_45":46,"_47":70,"_49":38,"_50":71,"_16":52,"_53":72,"_55":73,"_57":35,"_58":-5,"_59":196,"_61":197},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":51,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_59":194,"_61":195},[],[41],[],[76,67],[],[76,78],[191,192],[76],["D",1783275088408],["D",1789521041830],{"_11":12,"_165":161},{"_11":12,"_158":159,"_160":161,"_117":118,"_162":163,"_164":35},{"_16":80,"_13":149,"_39":46,"_150":107,"_151":-5,"_152":-5,"_153":-5,"_154":-5,"_155":-5,"_156":14,"_157":12},"ctx",{"_142":-5,"_181":240,"_241":242,"_243":244,"_245":35,"_246":35,"_247":35,"_248":38,"_249":-5,"_250":-7,"_251":-7,"_252":52,"_253":35,"_254":35,"_255":-5,"_256":35,"_257":35,"_258":35,"_259":-5},"ENV",{"_211":212,"_213":214,"_215":149,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239},"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"]