ストック

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_116":-5,"_20":117,"_22":118,"_119":120,"_121":122,"_26":123,"_24":124,"_125":-5,"_126":-5,"_127":56,"_128":129,"_130":53,"_131":-5,"_132":-5,"_133":134},"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","wowkitsunezaru","name","stock-resolver","branchName","main","version","path","main.ts","project",{"_33":60,"_13":14,"_45":61,"_62":-5,"_63":56,"_64":65,"_66":65,"_67":68,"_69":-5,"_70":71,"_72":38,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":56},"tree",[51],"file",{"_33":34,"_35":36,"_37":38,"_13":19,"_39":40,"_41":42,"_17":43,"_44":-5,"_45":46,"_47":48,"_49":-5,"_18":50},"contents",[],"upstream","pull","ahead","behind","envVars","id","8dbdefdf-0d68-40a0-80af-292bcac25423","branchId","c36ad4ff-5e6a-4d69-a252-92546c55f425","fileId","a9bc27d8-b0be-11f1-8dd9-1607ee4eb77e","content","// 商品ストック / SHOPストック（同期版）— Val Town にそのまま貼り付けて使えます。\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n/* ================= バックエンド ================= */\nconst RATES: Record = {\n JPY: 1,\n USD: 155,\n EUR: 168,\n GBP: 198,\n CAD: 114,\n AUD: 103,\n};\nconst toYen = (p: number, cur: string) => Math.round(p * (RATES[cur] || 1));\nconst H = 3600000, D = 86400000, NOW = Date.now();\n\nconst SEED = [\n {\n name: \"ソフビ怪獣グランデウス\",\n brand: \"KAIJU WORKS\",\n genre: \"フィギュア\",\n price: 8800,\n updatedAt: NOW - 2 * D,\n url: \"https://kaijuworks.example/grandeus\",\n origin: \"domestic\",\n fav: true,\n site: \"generic\",\n },\n {\n name: \"真鍮の文鎮（キツネ）\",\n brand: \"手仕事雑貨 tori\",\n genre: \"雑貨\",\n price: 3300,\n updatedAt: NOW - 7 * D,\n url: \"https://tori-zakka.example/fox\",\n origin: \"domestic\",\n site: \"generic\",\n },\n {\n name: \"ソフビ『月夜のキツネザル』\",\n brand: \"WoW工房\",\n genre: \"フィギュア\",\n price: 6600,\n updatedAt: NOW - 6 * H,\n url: \"https://wow-kobo.example/lemur\",\n origin: \"domestic\",\n fav: true,\n site: \"generic\",\n },\n].map((x, i) => ({\n ...x,\n id: \"seed-\" + i,\n pending: false,\n fav: (x as any).fav || false,\n}));\n\nconst SHOP_SEED = [\n {\n id: \"shop-0\",\n name: \"Deus Ex Machina\",\n genre: \"アパレル\",\n url: \"https://jp.deuscustoms.com/\",\n country: \"日本\",\n fav: true,\n updatedAt: NOW - 1 * D,\n },\n {\n id: \"shop-1\",\n name: \"Vinyl Pulse Toys\",\n genre: \"トイ・ホビー\",\n url: \"https://vinylpulse.example/\",\n country: \"アメリカ\",\n updatedAt: NOW - 3 * D,\n },\n];\n\nconst DEFAULT_GENRES: Record = {\n \"フィギュア\": { fg: \"#F0B7A8\", bg: \"#43302B\" },\n \"アパレル\": { fg: \"#8FD9C9\", bg: \"#233E38\" },\n \"雑貨\": { fg: \"#C3AEE6\", bg: \"#352B47\" },\n \"本・図録\": { fg: \"#E4C877\", bg: \"#3C3420\" },\n \"ガジェット\": { fg: \"#9BC2EB\", bg: \"#253749\" },\n \"未分類\": { fg: \"#B8BCC0\", bg: \"#34343A\" },\n};\nconst DEFAULT_SHOP_GENRES: Record = {\n \"アパレル\": { fg: \"#8FD9C9\", bg: \"#233E38\" },\n \"トイ・ホビー\": { fg: \"#F0B7A8\", bg: \"#43302B\" },\n \"雑貨・インテリア\": { fg: \"#C3AEE6\", bg: \"#352B47\" },\n \"ガジェット\": { fg: \"#9BC2EB\", bg: \"#253749\" },\n \"セレクト\": { fg: \"#E4C877\", bg: \"#3C3420\" },\n \"未分類\": { fg: \"#B8BCC0\", bg: \"#34343A\" },\n};\n\nconst TLD_COUNTRY: Record = {\n \"jp\": \"日本\",\n \"co.jp\": \"日本\",\n \"uk\": \"イギリス\",\n \"co.uk\": \"イギリス\",\n \"de\": \"ドイツ\",\n \"fr\": \"フランス\",\n \"it\": \"イタリア\",\n \"es\": \"スペイン\",\n \"au\": \"オーストラリア\",\n \"com.au\": \"オーストラリア\",\n \"ca\": \"カナダ\",\n \"kr\": \"韓国\",\n \"cn\": \"中国\",\n \"tw\": \"台湾\",\n \"hk\": \"香港\",\n \"sg\": \"シンガポール\",\n \"nl\": \"オランダ\",\n \"se\": \"スウェーデン\",\n};\nfunction countryFromHost(host: string): string | null {\n if (!host) return null;\n const parts = host.split(\".\");\n const last2 = parts.slice(-2).join(\".\");\n if (TLD_COUNTRY[last2]) return TLD_COUNTRY[last2];\n return TLD_COUNTRY[parts.slice(-1)[0]] || null;\n}\n\nfunction initialState() {\n return {\n items: SEED,\n shops: SHOP_SEED,\n genres: DEFAULT_GENRES,\n shopGenres: DEFAULT_SHOP_GENRES,\n settings: { amazonTag: \"\" },\n };\n}\nasync function ensureTable() {\n await sqlite.execute(\n \"CREATE TABLE IF NOT EXISTS stock_meta (key TEXT PRIMARY KEY, value TEXT)\",\n );\n}\nasync function readState(): Promise {\n await ensureTable();\n const r = await sqlite.execute(\n \"SELECT value FROM stock_meta WHERE key = 'state'\",\n );\n if (r.rows.length) {\n try {\n return JSON.parse(r.rows[0][0] as string);\n } catch { /* fallthrough */ }\n }\n const s = initialState();\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO stock_meta (key, value) VALUES ('state', ?)\",\n args: [JSON.stringify(s)],\n });\n return s;\n}\nasync function getState(): Promise {\n const s = await readState();\n return new Response(JSON.stringify(s), {\n headers: {\n \"content-type\": \"application/json; charset=utf-8\",\n \"cache-control\": \"no-store\",\n },\n });\n}\nasync function putState(req: Request): Promise {\n await ensureTable();\n const body = await req.text();\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO stock_meta (key, value) VALUES ('state', ?)\",\n args: [body],\n });\n return new Response(JSON.stringify({ ok: true }), {\n headers: { \"content-type\": \"application/json\" },\n });\n}\n\nfunction parseUrl(raw: string, amazonTag: string) {\n let host = \"リンク\";\n try {\n host = new URL(raw.indexOf(\"http\") === 0 ? raw : \"https://\" + raw).hostname\n .replace(/^www\\./, \"\");\n } catch {\n return {\n site: \"generic\",\n brand: \"リンク\",\n overseas: false,\n affiliateUrl: raw,\n };\n }\n if (/(^|\\.)amazon\\./i.test(host)) {\n const m =\n raw.match(\n /\\/(?:dp|gp\\/product|gp\\/aw\\/d|gp\\/offer-listing)\\/([A-Z0-9]{10})/i,\n ) || raw.match(/\\/([A-Z0-9]{10})(?:[/?]|$)/);\n const asin = m ? m[1].toUpperCase() : null;\n const tld = host.replace(/^amazon\\./, \"\");\n const cur = ({\n \"co.jp\": [\"JPY\", \"¥\", false],\n \"com\": [\"USD\", \"$\", true],\n \"co.uk\": [\"GBP\", \"£\", true],\n \"de\": [\"EUR\", \"€\", true],\n \"fr\": [\"EUR\", \"€\", true],\n \"ca\": [\"CAD\", \"C$\", true],\n \"com.au\": [\"AUD\", \"A$\", true],\n } as any)[tld] || [\"JPY\", \"¥\", false];\n let aff = raw;\n if (asin) {\n aff = \"https://www.amazon.\" + tld + \"/dp/\" + asin + \"/\" +\n (amazonTag ? \"?tag=\" + encodeURIComponent(amazonTag) : \"\");\n }\n return {\n site: \"amazon\",\n brand: \"Amazon\" + (cur[2] ? \".\" + tld : \"\"),\n asin,\n overseas: cur[2],\n origCur: cur[1],\n affiliateUrl: aff,\n };\n }\n if (\n /rakuten\\.co\\.jp$/i.test(host) ||\n /rakuten\\.co\\.jp$/i.test(host.replace(/^item\\./, \"\"))\n ) {\n return {\n site: \"rakuten\",\n brand: \"楽天市場\",\n overseas: false,\n affiliateUrl: raw,\n };\n }\n return { site: \"generic\", brand: host, overseas: false, affiliateUrl: raw };\n}\nfunction ogMeta(html: string, p: string): string | null {\n const m =\n html.match(\n new RegExp(\n \"]+property=[\\\"']og:\" + p + \"[\\\"'][^>]+content=[\\\"']([^\\\"']+)\",\n \"i\",\n ),\n ) ||\n html.match(\n new RegExp(\n \"]+content=[\\\"']([^\\\"']+)[\\\"'][^>]+property=[\\\"']og:\" + p +\n \"[\\\"']\",\n \"i\",\n ),\n );\n return m ? decodeEntities(m[1]) : null;\n}\nfunction extractPrice(html: string): { price: number; cur: string } | null {\n const blocks = [\n ...html.matchAll(\n /]+application\\/ld\\+json[^>]*>([\\s\\S]*?)<\\/script>/gi,\n ),\n ];\n for (const b of blocks) {\n try {\n const parsed = JSON.parse(b[1].trim());\n const arr = Array.isArray(parsed) ? parsed : [parsed];\n for (const d of arr) {\n const offers = d?.offers &&\n (Array.isArray(d.offers) ? d.offers[0] : d.offers);\n if (offers?.price) {\n return {\n price: Number(offers.price),\n cur: offers.priceCurrency || \"JPY\",\n };\n }\n }\n } catch { /* skip */ }\n }\n return null;\n}\nfunction decodeEntities(s: string | null): string | null {\n if (!s) return s;\n return s.replace(/&/g, \"&\").replace(/</g, \"<\").replace(/>/g, \">\")\n .replace(/"/g, '\"').replace(/�?39;/g, \"'\").replace(/'/gi, \"'\");\n}\n\nasync function resolve(req: Request): Promise {\n const j = (o: any, status = 200) =>\n new Response(JSON.stringify(o), {\n status,\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n const target = new URL(req.url).searchParams.get(\"url\");\n if (!target) return j({ error: \"url required\" }, 400);\n let name: string | null = null,\n image: string | null = null,\n price: number | null = null;\n let origPrice: number | null = null, origCur: string | null = null;\n try {\n const r = await fetch(target, {\n redirect: \"follow\",\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36\",\n \"Accept\":\n \"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8\",\n \"Accept-Language\": \"ja,en-US;q=0.9,en;q=0.8\",\n },\n });\n const html = await r.text();\n name = ogMeta(html, \"title\");\n image = ogMeta(html, \"image\");\n const pj = extractPrice(html);\n if (pj) {\n if (pj.cur && pj.cur !== \"JPY\") {\n origPrice = pj.price;\n origCur = pj.cur;\n price = toYen(pj.price, pj.cur);\n } else price = pj.price;\n }\n } catch { /* ページが取れなくても他の情報は返す */ }\n let tag = \"\";\n try {\n const s = await readState();\n tag = s?.settings?.amazonTag || \"\";\n } catch { /* ignore */ }\n const info = parseUrl(target, tag);\n if (!origCur) origCur = (info as any).origCur || null;\n const overseas = (info as any).overseas || !!(origCur && origCur !== \"JPY\");\n let host = \"\";\n try {\n host = new URL(target.indexOf(\"http\") === 0 ? target : \"https://\" + target)\n .hostname.replace(/^www\\./, \"\");\n } catch { /* ignore */ }\n return j({\n site: info.site,\n brand: info.brand,\n name,\n image,\n price,\n origPrice,\n origCur,\n overseas,\n affiliateUrl: (info as any).affiliateUrl,\n asin: (info as any).asin || null,\n country: countryFromHost(host),\n host,\n });\n}\n\nexport default async function (req: Request): Promise {\n const path = new URL(req.url).pathname;\n if (path === \"/resolve\") return resolve(req);\n if (path === \"/api/state\" && req.method === \"GET\") return getState();\n if (path === \"/api/state\" && req.method === \"PUT\") return putState(req);\n return new Response(HTML, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\n/* ================= フロント ================= */\nconst HTML = `\n\n\n\n\n\nストック\n\n\n\n\n

\n \n \n

\n 🔗\n \n \n

🔍

\n \n

\n\n\n\n\n\n\n\n\n\n`;","fileType","http",9,"parentId","createdAt",["D",1789618546605],"branchVersion",10,"label",[19],{"_33":34,"_13":19,"_37":38,"_44":-5,"_35":36,"_47":48,"_52":53,"_45":54,"_17":43,"_41":42,"_39":40,"_55":56,"_49":-5,"_57":58,"_18":59},"latest",true,["D",1789618546605],"deleted",false,"children",[],[19],"3b5a2368-c571-423a-894d-d2d5cbc112ba",["D",1789446836287],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","182f626d-ac56-4e4a-80a8-4092d62da6c7","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0a354-5c89-7617-bb7e-c8b09b358baa","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_115":111},"org",{"_11":12,"_108":109,"_110":111,"_70":71,"_112":113,"_114":56},"branch",{"_17":48,"_13":16,"_33":36,"_100":60,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","智洋村上","avatar","https://lh3.googleusercontent.com/a/ACg8ocKgBOot1AmwgKn11-QhfQWKGbUhzzhZNkKcbMJLlIE5VNoSzyL9ng=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":60,"_13":14,"_45":150,"_62":-5,"_63":56,"_64":65,"_66":65,"_67":68,"_69":-5,"_70":71,"_72":38,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":151,"_95":152,"_97":153,"_99":56},[147],"files",[147],"counts",{"_137":77,"_138":139,"_140":77,"_32":141,"_142":143},[],{"_33":34,"_13":19,"_37":38,"_44":-5,"_35":36,"_47":48,"_52":53,"_45":135,"_17":43,"_41":42,"_39":40,"_55":56,"_49":-5,"_18":136},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1789618546605],[19],"pulls","branches",1,"forks",{"_144":77,"_146":77},"connections",{"_144":77,"_145":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":19,"_37":38,"_44":-5,"_35":36,"_47":48,"_52":53,"_45":54,"_17":43,"_41":42,"_39":40,"_55":56,"_49":-5,"_57":148,"_18":149},[],[19],["D",1789446836287],{"_11":12,"_115":111},{"_11":12,"_108":109,"_110":111,"_70":71,"_112":113,"_114":56},{"_17":48,"_13":16,"_33":36,"_100":60,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_132":187,"_188":189,"_190":191,"_192":56,"_193":56,"_194":56,"_195":53,"_196":-5,"_197":-7,"_198":-7,"_199":77,"_200":56,"_201":56,"_202":-5,"_203":56,"_204":56,"_205":56,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":16,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

設定

編集

ジャンルを管理