2d:null 2e:["$","title",null,{"children":"[FFXIV] FF14国服物品市场价格速查 | UnluckyNinja | Observable"}] 33:T453,viewof selectedItem = Inputs.table(searchResult, { columns: ['id', 'name', 'itemLevel', 'shopPrice', 'description', 'inShop'], multiple: false, layout: 'fixed', header: { id: "ID", name: '物品名', itemLevel: '物品品级', shopPrice: 'NPC售价(金币)', description: '物品说明', inShop: '相关链接', }, width: { id: 48, name: 140, itemLevel: 64, shopPrice: 100, inShop: 210, }, align: { id: 'right', itemLevel: 'right', shopPrice: 'right', }, format: { shopPrice: (v,i,data)=> data[i].inShop ? v : '无', description: (d)=> htl.html`${d}`, inShop: (v,i,datas) => { const id = parseInt(datas[i].id) const isItem = id > 1000 || id < 20 return htl.html` 灰机Wiki GarlandData Universalis` } } })34:[{"id":"25ef2a1846cf75ea207e53607110a277d4ee7cfb84305a92e03823b11ddf8cbeefd96601c414bb1d467419e6994d1b5aac2980df56b144944b0739d30b6e2cbd","href":"https://static.observableusercontent.com/files/25ef2a1846cf75ea207e53607110a277d4ee7cfb84305a92e03823b11ddf8cbeefd96601c414bb1d467419e6994d1b5aac2980df56b144944b0739d30b6e2cbd","name":"FFXIV_Lodestone_SSF.woff","type":"font/woff","lastModified":1671457700823.821,"size":16304}] 31:{"id":"8eb58b632fff1136","slug":"ffxiv-market-cn","title":"[FFXIV] FF14国服物品市场价格速查","thumbnail":"c4a05e6d08347ea778e0b9f0dc35c0b64128b71eba619fd42376b14775fd2c9a","access_level":"public","create_time":"$D2022-12-17T05:12:16.082Z","update_time":"$D2024-10-02T09:06:02.084Z","view_time":null,"first_public_time":"$D2022-12-17T05:12:16.082Z","has_unpublished_edits":null,"fork":false,"stars":3,"starred":false,"owner":{"type":"team","id":"ebb6118c9a990a2c","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":"starter_2024"},"version":467,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"4df1f6fd87aa7295","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":null}],"members":[{"type":"individual","id":"4df1f6fd87aa7295","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"618097a6397b7b90","slug":"ffxiv","title":"FFXIV","owner":{"id":"ebb6118c9a990a2c","login":"unluckyninja","name":"UnluckyNinja"}},"type":"notebook","body":{"title":"[FFXIV] FF14国服物品市场价格速查","cells":[{"id":0,"value":"# [FFXIV] FF14国服物品市场价格速查","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":105,"value":"## 1. 搜索并选择物品 \n初次打开页面请等待数据加载 \n如果要搜索多个物品，建议保持页面开启 \n若出现英文红字报错可以尝试刷新重试","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":45,"value":"viewof search = Inputs.text({placeholder: '物品名，空格分隔关键词，例如“陈旧的地图”'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"## 2. 在售一览","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":37,"value":"viewof selectedWorld = {\n const options = datacenters.flatMap((region)=>{\n return region.worlds.map(w=>{\n return {\n region: region.region,\n section: region.name,\n world: w,\n dcObj: region,\n }\n })\n })\n const store = useStorage('selectedWorld', 0)\n const input = Inputs.select(options, { format: (it)=> `${it.region}-${it.section}-${worlds[it.world]}`, value: options[store.value], label: '选择服务器'})\n input.addEventListener('input',(e)=>{\n store.value = e.target.value\n })\n return input\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"listSizeView = Inputs.range([10, 100], {step: 1, value: 20, label: '查询在售条目数量（单价升序）'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":395,"value":"viewof HQonly = Inputs.toggle({label: '仅查询HQ物品'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":130,"value":"selectedServerOptionView = Inputs.radio(serverOptions, {\n format: (it,i)=>{\n if (i === 0) return it\n return worlds[it]\n },\n value: serverOptions[0]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"{\n if(!selectedItem) return md`**请先在步骤1中搜索并选择物品**`\n return md``\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"{\n return Inputs.table(selectedItemMarketListings, {\n columns: [\n \"itemName\",\n \"pricePerUnit\",\n \"quantity\",\n \"total\",\n \"retainerName\",\n \"worldName\"\n ],\n layout: \"auto\",\n maxWidth: \"640px\",\n header: {\n itemName: \"物品名\",\n pricePerUnit: \"单价\",\n total: \"总计\",\n quantity: \"数量\",\n retainerName: \"雇员名\",\n worldName: \"服务器\"\n },\n format: {\n itemName: (d, i, datas) => htl.html`${d + (datas[i].hq ? '' : '')}`\n }\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"### 历史交易一览","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":315,"value":"{\n return Inputs.table(selectedItemMarketHistory, {\n columns: [\n \"itemName\",\n \"pricePerUnit\",\n \"quantity\",\n \"total\",\n \"buyerName\",\n \"worldName\",\n \"timestamp\"\n ],\n layout: \"auto\",\n maxWidth: \"640px\",\n header: {\n itemName: \"物品名\",\n pricePerUnit: \"单价\",\n total: \"总计\",\n quantity: \"数量\",\n buyerName: \"购买玩家名\",\n worldName: \"服务器\",\n timestamp: \"购买时间\",\n },\n format: {\n itemName: (d, i, datas) => htl.html`${d + (datas[i].hq ? '' : '')}`,\n timestamp: d => new Date(d*1000).toLocaleString('zh-CN')\n }\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"## 附录","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":267,"value":"此工具使用了Universalis提供的API\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":335,"value":" ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":154,"value":"listSize = debounce(listSizeView, 500)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"serverOptions = {\n return [selectedWorld.section, ...selectedWorld.dcObj.worlds]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"selectedServerOption = debounce(selectedServerOptionView)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":386,"value":"selectedItem","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":306,"value":"selectedItemMarketInfo = {\n if(!selectedItem) return {}\n const options = { \n listings: listSize,\n entries: 10,\n }\n if (selectedItem.canBeHQ && HQonly){\n options.hq = true\n }\n return await fetchMarket(selectedServerOption, selectedItem.id, options)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":165,"value":"selectedItemMarketListings = {\n if(!selectedItem) return []\n const result = await selectedItemMarketInfo\n return result.listings.map(it=>{\n return Object.assign({\n worldName: typeof selectedServerOption === \"number\" ? worlds[selectedServerOption] : selectedServerOption,\n itemName: selectedItem.name\n }, it)\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":324,"value":"selectedItemMarketHistory = {\n if(!selectedItem) return []\n const result = await selectedItemMarketInfo\n return result.recentHistory.map(it=>{\n return Object.assign({\n worldName: typeof selectedServerOption === \"number\" ? worlds[selectedServerOption] : selectedServerOption,\n itemName: selectedItem.name\n }, it)\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"searchResult = {\n if (search == null) return []\n const words = search.split(/\\s+/)\n const query = `select items.\"key: #\" as id, \"9: Name\" as name, \"11: Level{Item}\" as itemLevel, \"25: Price{Mid}\" as shopPrice, \"8: Description\" as description, IF(shop_items.\"0: Item\" is null, false, true) as inShop, IF(\"27: CanBeHq\" = 'False', false, true) as canBeHQ from items left join ( select \"0: Item\" from shop_items group by shop_items.\"0: Item\" ) as shop_items on items.\"key: #\" = shop_items.\"0: Item\" where name != '' and \"22: IsUntradable\" = 'False' and ${Array(words.length).fill('name like ?').join(' and ')}`\n return itemdb_cn.query(query, words.map(it=>`%${it}%`))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":111,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":331,"value":"ffxiv_lodestone_ssf = FileAttachment(\"FFXIV_Lodestone_SSF.woff\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"import {itemdb_cn} from \"1ef1dad66b92c723\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"datacenters = {\n const json = await fetchJSON('https://universalis.app/api/v2/data-centers')\n return json\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"worlds = {\n const entries = (await fetchJSON('https://universalis.app/api/v2/worlds')).map(obj=> [obj.id, obj.name])\n return Object.fromEntries(entries)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"fetchMarket = async (server, items, options)=>{\n const url = `https://universalis.app/api/v2/${server}/${Array.isArray(items) ? items.join(',') : items}`\n const queries = {\n ...options,\n }\n const querystring = new URLSearchParams(queries).toString()\n return await fetchJSON(`${url}?${querystring}`)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"fetchJSON = async (url)=> {\n return await fetch(url).then(res=>{\n mutable error = spawnError(false)\n return res.json()\n }).catch(e=>{\n mutable error = spawnError(true, `无法从地址获取数据： ${url}, Universalis 可能正在维护`)\n throw e\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"mutable error = ({\n value: false,\n message: '',\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"spawnError = (value, message = '')=>{\n return {\n value,\n message\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"useStorage = (id, ...options) => {\n return VueUse.useStorage(`8eb58b632fff1136-${id}`, ...options)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"import { debounce } from '@mbostock/debouncing-input'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"import { VueUse } from '@unluckyninja/vue'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 32:"$31:body"