⚠ 初期設定エラー

環境変数 DASHBOARD_KEY が設定されていません。

`,\n 500,\n );\n }\n if (key !== expected) {\n return new Response(\"Unauthorized — ?key=xxx を URL に付けてください\", {\n status: 401,\n });\n }\n\n // データ取得\n let data: DashboardData | null = null;\n try {\n data = (await blob.getJSON(BLOB_KEY)) as DashboardData;\n } catch (_e) { /* 初回はデータ無し */ }\n if (!data) {\n data = {\n totals: [],\n daily: [],\n updated: \"(まだデータがアップロードされていません)\",\n total_amount: 0,\n total_donors: 0,\n };\n }\n\n // 除外リスト取得 (旧形式互換: type 無し = user)\n let excludes: ExcludedEntry[] = [];\n try {\n excludes = ((await blob.getJSON(EXCLUDE_BLOB_KEY)) as ExcludedEntry[]) ??\n [];\n } catch (_e) {\n excludes = [];\n }\n for (const e of excludes) {\n if (!e.type) e.type = \"user\";\n }\n const excludedUserIds = new Set(\n excludes.filter((e) => e.type === \"user\").map((e) => e.id),\n );\n const excludedDates = new Set(\n excludes.filter((e) => e.type === \"date\").map((e) => e.id),\n );\n\n const path = url.pathname.replace(/\\/+$/, \"\");\n\n // POST /upload → Python pusher\n if (path === \"/upload\" && req.method === \"POST\") {\n let payload: any;\n try {\n payload = await req.json();\n } catch (e) {\n return new Response(\"invalid JSON\", { status: 400 });\n }\n if (!payload || typeof payload !== \"object\") {\n return new Response(\"expected JSON object\", { status: 400 });\n }\n await blob.setJSON(BLOB_KEY, payload);\n return jsonResp({\n ok: true,\n saved: true,\n totals_count: (payload.totals || []).length,\n daily_count: (payload.daily || []).length,\n updated: payload.updated || null,\n });\n }\n\n // POST /exclude → 除外リストに追加\n if (path === \"/exclude\" && req.method === \"POST\") {\n const body = await req.json().catch(() => null);\n const targetId = (body?.id ?? \"\").toString().trim();\n const type = ((body?.type ?? \"user\").toString().trim()) as \"user\" | \"date\";\n if (!targetId) return new Response(\"missing id\", { status: 400 });\n const alreadyIn = excludes.some((e) =>\n e.id === targetId && (e.type ?? \"user\") === type\n );\n if (!alreadyIn) {\n if (type === \"user\") {\n const donor = (data.totals || []).find((t) => t.id === targetId);\n excludes.push({\n type: \"user\",\n id: targetId,\n username: donor?.username ?? \"(不明)\",\n removed_at: new Date().toISOString(),\n });\n } else {\n excludes.push({\n type: \"date\",\n id: targetId,\n label: targetId,\n removed_at: new Date().toISOString(),\n });\n }\n await blob.setJSON(EXCLUDE_BLOB_KEY, excludes);\n }\n return jsonResp({ ok: true, excluded_count: excludes.length });\n }\n\n // POST /restore → 除外リストから除去\n if (path === \"/restore\" && req.method === \"POST\") {\n const body = await req.json().catch(() => null);\n const targetId = (body?.id ?? \"\").toString().trim();\n const type = ((body?.type ?? \"user\").toString().trim()) as \"user\" | \"date\";\n if (!targetId) return new Response(\"missing id\", { status: 400 });\n excludes = excludes.filter((e) =>\n !(e.id === targetId && (e.type ?? \"user\") === type)\n );\n await blob.setJSON(EXCLUDE_BLOB_KEY, excludes);\n return jsonResp({ ok: true, excluded_count: excludes.length });\n }\n\n // POST /refresh-avatar → YouTube チャンネルから最新アバターを取得して image_url 上書き\n if (path === \"/refresh-avatar\" && req.method === \"POST\") {\n const body = await req.json().catch(() => null);\n const targetId = (body?.id ?? \"\").toString().trim();\n if (!targetId) return new Response(\"missing id\", { status: 400 });\n if (!targetId.startsWith(\"cid:\")) {\n return jsonResp({\n ok: false,\n error: \"channel_id 付きユーザーのみ (cid:UC... 形式) 対応\",\n });\n }\n const channelId = targetId.slice(4);\n const newUrl = await fetchYouTubeAvatar(channelId);\n if (!newUrl) {\n return jsonResp({\n ok: false,\n error: \"YouTube から avatar URL を取得できませんでした\",\n });\n }\n // blob の totals + daily 内全部の image_url を更新\n let updated = 0;\n for (const t of (data.totals || [])) {\n if (t.id === targetId) {\n t.image_url = newUrl;\n updated++;\n }\n }\n for (const d of (data.daily || [])) {\n for (const u of (d.donors || [])) {\n if (u.id === targetId) {\n u.image_url = newUrl;\n updated++;\n }\n }\n }\n await blob.setJSON(BLOB_KEY, data);\n return jsonResp({ ok: true, updated, new_url: newUrl });\n }\n\n // /api → JSON (除外適用前の生データ)\n if (path === \"/api\") {\n return new Response(JSON.stringify({ data, excludes }, null, 2), {\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n }\n\n // /excluded → 除外リスト管理画面\n if (path === \"/excluded\") {\n return html(renderExcluded(excludes));\n }\n\n // ここから先は除外フィルタを適用したデータ\n const filtered = filterData(data, excludedUserIds, excludedDates);\n\n // /daily → 日別ランキング (折りたたみ)\n if (path === \"/daily\") {\n const openDate = url.searchParams.get(\"open\") ?? \"\";\n return html(renderDaily(filtered, openDate));\n }\n\n // /user/ → 個別履歴\n const userMatch = path.match(/^\\/user\\/(.+)$/);\n if (userMatch) {\n return html(renderUser(data, decodeURIComponent(userMatch[1])));\n }\n\n // / → 総合ランキング\n return html(renderTotals(filtered, excludes.length));\n}\n\n// =========== ユーティリティ ===========\n\nfunction filterData(\n data: DashboardData,\n excludedUserIds: Set,\n excludedDates: Set,\n): DashboardData {\n if (excludedUserIds.size === 0 && excludedDates.size === 0) return data;\n // 除外日付の合計 (totals の再計算で引く必要があるため)\n const dateExcludedSubtractByUser = new Map();\n for (const d of (data.daily || [])) {\n if (!excludedDates.has(d.date)) continue;\n for (const u of (d.donors || [])) {\n const prev = dateExcludedSubtractByUser.get(u.id) ?? 0;\n dateExcludedSubtractByUser.set(u.id, prev + (u.amount || 0));\n }\n }\n // totals: 除外ユーザーを弾く + 除外日付の金額を total から引く + daily から除外日付を削る\n const totals = (data.totals || [])\n .filter((t) => !excludedUserIds.has(t.id))\n .map((t) => {\n const subtract = dateExcludedSubtractByUser.get(t.id) ?? 0;\n const newTotal = Math.max(0, (t.total || 0) - subtract);\n const newDaily: Record = {};\n for (const [date, amt] of Object.entries(t.daily || {})) {\n if (!excludedDates.has(date)) newDaily[date] = amt;\n }\n return {\n ...t,\n total: newTotal,\n count: Object.keys(newDaily).length,\n daily: newDaily,\n };\n })\n .filter((t) => t.total > 0) // 全部の日が除外されたユーザーは消す\n .sort((a, b) => b.total - a.total);\n // daily: 除外日付を消す + 各日内の除外ユーザーも消す\n const daily = (data.daily || [])\n .filter((d) => !excludedDates.has(d.date))\n .map((d) => {\n const donors = (d.donors || []).filter((u) => !excludedUserIds.has(u.id));\n const total = donors.reduce((s, u) => s + (u.amount || 0), 0);\n return { date: d.date, donors, total };\n })\n .filter((d) => d.donors.length > 0);\n const total_amount = totals.reduce((s, t) => s + (t.total || 0), 0);\n return {\n totals,\n daily,\n updated: data.updated,\n total_amount,\n total_donors: totals.length,\n };\n}\n\nfunction jsonResp(obj: any): Response {\n return new Response(JSON.stringify(obj), {\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n}\n\nfunction html(body: string, status = 200): Response {\n return new Response(body, {\n status,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction escape(s: string): string {\n return (s ?? \"\")\n .toString()\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\nfunction yen(n: number): string {\n try {\n return \"¥\" + Math.round(n).toLocaleString();\n } catch {\n return \"¥0\";\n }\n}\n\n// YouTube チャンネルページから最新のアバター URL を取得 (og:image を解析)\nasync function fetchYouTubeAvatar(channelId: string): Promise {\n try {\n const res = await fetch(\n `https://www.youtube.com/channel/${encodeURIComponent(channelId)}`,\n {\n headers: {\n // YouTube の地域/言語振り分けで HTML 構造が変わらないよう固定\n \"Accept-Language\": \"ja,en;q=0.5\",\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 \" +\n \"(KHTML, like Gecko) Chrome/120.0 Safari/537.36\",\n },\n },\n );\n if (!res.ok) return null;\n const html = await res.text();\n // 1) og:image を優先\n let m = html.match(/ 0) {\n return `https://www.youtube.com/channel/${encodeURIComponent(cid)}`;\n }\n }\n // username しか無い場合は YouTube 検索フォールバック\n return `https://www.youtube.com/results?search_query=${\n encodeURIComponent(username)\n }`;\n}\n\nconst COMMON_CSS = `\n\n`;\n\nconst COMMON_JS = `\n\n`;\n\nfunction navBarPlaceholder(active: string): string {\n return ``;\n}\n\nfunction renderTotals(data: DashboardData, excludedCount: number): string {\n const totals = (data.totals || []).slice(0, 100);\n const rows = totals.map((t, i) => {\n const rcls = i === 0 ? \"r1\" : i === 1 ? \"r2\" : i === 2 ? \"r3\" : \"\";\n const safeId = escape(t.id);\n const safeUn = escape(t.username);\n const ytUrl = ytChannelUrl(t.id, t.username);\n const isCid = t.id.startsWith(\"cid:\");\n return `\n ${i + 1}\n \n 📺\n \n

\n ${safeUn}\n ${yen(t.total)}\n ${t.count}日\n \n ${\n isCid\n ? ``\n : \"\"\n }\n \n \n `;\n }).join(\"\");\n\n const excludedNote = excludedCount > 0\n ? `

\n (除外中 ${excludedCount} 件 — 復活管理)\n

`\n : \"\";\n\n return `\n \n \n 💰 投げ銭ダッシュボード\n ${COMMON_CSS}\n \n

💰 0まで寝ない投げ銭ダッシュボード

最終更新: ${escape(data.updated)}

全期間合計

${\n yen(data.total_amount)\n }

投げてくれた人数

${data.total_donors}

記録日数

${data.daily.length}

\n ${navBarPlaceholder(\"totals\")}\n

🏆 総合ランキング (TOP 100)

\n ${excludedNote}\n \n \n ${\n rows ||\n ``\n }

#	📺		ユーザー	累積	日数
データ無し

\n ${COMMON_JS}\n `;\n}\n\nfunction renderDaily(data: DashboardData, openDate: string): string {\n const days = (data.daily || []).slice(0, 90);\n const sections = days.map((d) => {\n const isOpen = (openDate === d.date) || (openDate === \"\" && d === days[0]);\n const rows = (d.donors || []).slice(0, 50).map((u, i) => {\n const safeId = escape(u.id);\n const safeUn = escape(u.username);\n const ytUrl = ytChannelUrl(u.id, u.username);\n const isCidDaily = u.id.startsWith(\"cid:\");\n return `\n ${i + 1}\n \n 📺\n \n

\n ${safeUn}\n ${yen(u.amount)}\n \n ${\n isCidDaily\n ? ``\n : \"\"\n }\n \n \n `;\n }).join(\"\");\n const safeDate = escape(d.date);\n return `

\n \n 📅 ${safeDate}\n \n 合計 ${yen(d.total)} / ${d.donors.length}人\n \n \n \n

\n ${\n rows ||\n ``\n }

この日のデータ無し

`;\n }).join(\"\");\n\n return `\n \n \n 📅 デイリー\n ${COMMON_CSS}\n \n

📅 デイリーランキング

最終更新: ${escape(data.updated)}

📌 日付をクリックで開閉 / 右端 🗑 で「その日」を丸ごと除外

\n ${navBarPlaceholder(\"daily\")}\n ${\n sections ||\n `

データ無し

`\n }\n ${COMMON_JS}\n `;\n}\n\nfunction renderUser(data: DashboardData, userId: string): string {\n const donor = (data.totals || []).find((t) => t.id === userId);\n if (!donor) {\n return `\n ${COMMON_CSS}\n ${navBarPlaceholder(\"\")}\n

ユーザーが見つかりません

\n ← 戻る\n ${COMMON_JS}\n `;\n }\n const dailyEntries = Object.entries(donor.daily || {})\n .sort((a, b) => b[0].localeCompare(a[0]));\n const rows = dailyEntries.map(([date, amt]) =>\n `\n ${escape(date)}\n ${yen(amt)}\n `\n ).join(\"\");\n const safeId = escape(donor.id);\n const safeUn = escape(donor.username);\n const ytUrl = ytChannelUrl(donor.id, donor.username);\n const isCid = donor.id.startsWith(\"cid:\");\n return `\n \n \n ${safeUn}\n ${COMMON_CSS}\n \n ${navBarPlaceholder(\"\")}\n

\n 📺\n

👤 ${safeUn}

\n ${\n isCid\n ? ``\n : \"\"\n }\n \n

\n ${\n !isCid\n ? `

⚠ channel_id 無しのため YouTube は検索結果ページが開きます

`\n : \"\"\n }\n

累積合計

${\n yen(donor.total)\n }

投げ銭日数

${donor.count}日

初回

${\n escape(donor.first_seen)\n }

最終

${\n escape(donor.last_seen)\n }

📅 日別履歴

\n ${rows}

日付	金額

← 総合に戻る

\n ${COMMON_JS}\n `;\n}\n\nfunction renderExcluded(excludes: ExcludedEntry[]): string {\n const userExcludes = excludes.filter((e) => (e.type ?? \"user\") === \"user\");\n const dateExcludes = excludes.filter((e) => e.type === \"date\");\n\n const userRows = userExcludes.length === 0\n ? `なし`\n : userExcludes.map((e) => {\n const safeUn = escape(e.username || \"(不明)\");\n const safeId = escape(e.id);\n return `\n ${safeUn}\n ${safeId}\n ${escape((e.removed_at || \"\").slice(0, 10))}\n \n `;\n }).join(\"\");\n\n const dateRows = dateExcludes.length === 0\n ? `なし`\n : dateExcludes.map((e) => {\n const safeDate = escape(e.id);\n return `\n 📅 ${safeDate}\n ${escape((e.removed_at || \"\").slice(0, 10))}\n \n `;\n }).join(\"\");\n\n return `\n \n \n 🗑 除外リスト\n ${COMMON_CSS}\n \n

🗑 除外リスト管理

削除したユーザー / 日付をここから復活できます。

\n ${navBarPlaceholder(\"excluded\")}\n\n

👤 除外ユーザー (${userExcludes.length})

\n \n \n ${userRows}\n

ユーザー	id	削除日

\n\n

📅 除外日付 (${dateExcludes.length})

\n \n \n ${dateRows}\n

日付	除外日

\n\n ${COMMON_JS}\n `;\n}","deleted","label",[115],"pulls",1,"forks","envVars",{"_137":131,"_139":54},"connections",{"_137":54,"_138":54},"count","unfilledCount","emptyCount",{"_20":114,"_13":115,"_116":48,"_117":-5,"_118":21,"_119":30,"_120":50,"_22":141,"_29":122,"_123":124,"_125":126,"_127":38,"_128":-5,"_142":143,"_90":144},["D",1782347886498],"children",[],[115],["D",1782343207971],{"_11":12,"_88":84},{"_11":12,"_82":-5,"_83":84,"_45":46,"_85":86,"_87":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"ctx",{"_70":-5,"_110":182,"_183":184,"_185":186,"_187":38,"_188":38,"_189":38,"_190":50,"_191":-5,"_192":-7,"_193":-7,"_194":54,"_195":38,"_196":38,"_197":-5,"_198":38,"_199":38,"_200":38,"_201":-5},"ENV",{"_153":154,"_155":156,"_157":26,"_158":159,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181},"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"]

Branches1

Branches
1