2b:null 2c:["$","title",null,{"children":"[FFXIV] Special Shop List by Currency | UnluckyNinja | Observable"}] 31:Tbc5,getShopsByCost = function(id){ // count +60, SpecialShopItemCategory +120, hq +180 const receive = [ { start: 1, end: 60, }, { start: 241, end: 300, } ] // count +60, hq +120, CollectabilityRating +180 const cost = [ { start: 481, end: 540, }, { start: 721, end: 780, }, { start: 961, end: 1020, } ] const questItem = { start: 1201, end: 1260 } const achievementUnlock = { start: 1441, end: 1500, } const questUnlock = 1623 const result = [] function check(rowIndex, num){ const item = specialShopCSV[rowIndex] const receive0 = receive[0].start + num + 1 const receive1 = receive[1].start + num + 1 const cost0 = cost[0].start + num + 1 const cost1 = cost[1].start + num + 1 const cost2 = cost[2].start + num + 1 const quest = questItem.start + num const achievement = achievementUnlock.start + num const receive0Count = receive0 + 60 const receive1Count = receive1 + 60 const cost0Count = cost0 + 60 const cost1Count = cost1 + 60 const cost2Count = cost2 + 60 const receive0HQ = receive0 + 180 const receive1HQ = receive1 + 180 const cost0HQ = cost0 + 120 const cost1HQ = cost1 + 120 const cost2HQ = cost2 + 120 const cost0CollectabilityRating = cost0 + 180 const cost1CollectabilityRating = cost1 + 180 const cost2CollectabilityRating = cost2 + 180 if(item[cost0] === `${id}` || item[cost1] === `${id}` || item[cost2] === `${id}`){ const receiveArr = [] const costArr = [] if(item[receive0] !== '0') { receiveArr.push({ id: item[receive0], count: item[receive0Count], hq: item[receive0HQ]}) } if(item[receive1] !== '0') { receiveArr.push({ id: item[receive1], count: item[receive1Count], hq: item[receive1HQ]}) } if(item[cost0] !== '0') { costArr.push({ id: item[cost0], count: item[cost0Count], hq: item[cost0HQ], rating: item[cost0CollectabilityRating] }) } if(item[cost1] !== '0') { costArr.push({ id: item[cost1], count: item[cost1Count], hq: item[cost1HQ], rating: item[cost1CollectabilityRating] }) } if(item[cost2] !== '0') { costArr.push({ id: item[cost2], count: item[cost2Count], hq: item[cost2HQ], rating: item[cost2CollectabilityRating] }) } result.push({ key: item[0], label: item[1], order: num, questUnlock: item[questUnlock], // unlock the shop, not just one item quest: item[quest], achievement: item[achievement], receive: receiveArr, cost: costArr }) } } specialShopCSV.forEach((it,rowIndex)=>{ for(let i = 0; i < 60; i++){ check(rowIndex, i) } }) return result }32:Tbb0,getShopsByGain = function(id){ // count +60, SpecialShopItemCategory +120, hq +180 const receive = [ { start: 1, end: 60, }, { start: 241, end: 300, } ] // count +60, hq +120, CollectabilityRating +180 const cost = [ { start: 481, end: 540, }, { start: 721, end: 780, }, { start: 961, end: 1020, } ] const questItem = { start: 1201, end: 1260 } const achievementUnlock = { start: 1441, end: 1500, } const questUnlock = 1623 const result = [] function check(rowIndex, num){ const item = specialShopCSV[rowIndex] const receive0 = receive[0].start + num + 1 const receive1 = receive[1].start + num + 1 const cost0 = cost[0].start + num + 1 const cost1 = cost[1].start + num + 1 const cost2 = cost[2].start + num + 1 const quest = questItem.start + num const achievement = achievementUnlock.start + num const receive0Count = receive0 + 60 const receive1Count = receive1 + 60 const cost0Count = cost0 + 60 const cost1Count = cost1 + 60 const cost2Count = cost2 + 60 const receive0HQ = receive0 + 180 const receive1HQ = receive1 + 180 const cost0HQ = cost0 + 120 const cost1HQ = cost1 + 120 const cost2HQ = cost2 + 120 const cost0CollectabilityRating = cost0 + 180 const cost1CollectabilityRating = cost1 + 180 const cost2CollectabilityRating = cost2 + 180 if(item[receive0] === `${id}` || item[receive1] === `${id}`){ const receiveArr = [] const costArr = [] if(item[receive0] !== '0') { receiveArr.push({ id: item[receive0], count: item[receive0Count], hq: item[receive0HQ]}) } if(item[receive1] !== '0') { receiveArr.push({ id: item[receive1], count: item[receive1Count], hq: item[receive1HQ]}) } if(item[cost0] !== '0') { costArr.push({ id: item[cost0], count: item[cost0Count], hq: item[cost0HQ], rating: item[cost0CollectabilityRating] }) } if(item[cost1] !== '0') { costArr.push({ id: item[cost1], count: item[cost1Count], hq: item[cost1HQ], rating: item[cost1CollectabilityRating] }) } if(item[cost2] !== '0') { costArr.push({ id: item[cost2], count: item[cost2Count], hq: item[cost2HQ], rating: item[cost2CollectabilityRating] }) } result.push({ key: item[0], label: item[1], order: num, questUnlock: item[questUnlock], // unlock the shop, not just one item quest: item[quest], achievement: item[achievement], receive: receiveArr, cost: costArr }) } } specialShopCSV.forEach((it,rowIndex)=>{ for(let i = 0; i < 60; i++){ check(rowIndex, i) } }) return result }33:Tbc0,shopMap = { // count +60, SpecialShopItemCategory +120, hq +180 const receive = [ { start: 1, end: 60, }, { start: 241, end: 300, } ] // count +60, hq +120, CollectabilityRating +180 const cost = [ { start: 481, end: 540, }, { start: 721, end: 780, }, { start: 961, end: 1020, } ] const questItem = { start: 1201, end: 1260 } const achievementUnlock = { start: 1741, end: 1800, } const questUnlock = 2043 const result = [] function check(rowIndex, num){ const item = specialShopCSV[rowIndex] const receive0 = receive[0].start + num + 1 const receive1 = receive[1].start + num + 1 const cost0 = cost[0].start + num + 1 const cost1 = cost[1].start + num + 1 const cost2 = cost[2].start + num + 1 const quest = questItem.start + num + 1 const achievement = achievementUnlock.start + num + 1 const receive0Count = receive0 + 60 const receive1Count = receive1 + 60 const cost0Count = cost0 + 60 const cost1Count = cost1 + 60 const cost2Count = cost2 + 60 const receive0HQ = receive0 + 180 const receive1HQ = receive1 + 180 const cost0HQ = cost0 + 120 const cost1HQ = cost1 + 120 const cost2HQ = cost2 + 120 const cost0CollectabilityRating = cost0 + 180 const cost1CollectabilityRating = cost1 + 180 const cost2CollectabilityRating = cost2 + 180 // if(item[receive0] === `${id}` || item[receive1] === `${id}`){ const receiveArr = [] const costArr = [] if(item[receive0] !== '0') { receiveArr.push({ id: item[receive0], count: item[receive0Count], hq: item[receive0HQ]}) } if(item[receive1] !== '0') { receiveArr.push({ id: item[receive1], count: item[receive1Count], hq: item[receive1HQ]}) } if(item[cost0] !== '0') { costArr.push({ id: item[cost0], count: item[cost0Count], hq: item[cost0HQ], rating: item[cost0CollectabilityRating] }) } if(item[cost1] !== '0') { costArr.push({ id: item[cost1], count: item[cost1Count], hq: item[cost1HQ], rating: item[cost1CollectabilityRating] }) } if(item[cost2] !== '0') { costArr.push({ id: item[cost2], count: item[cost2Count], hq: item[cost2HQ], rating: item[cost2CollectabilityRating] }) } result.push({ key: item[0], label: item[1], order: num, questUnlock: item[questUnlock], // unlock the shop, not just one item quest: item[quest], achievement: item[achievement], receive: receiveArr, cost: costArr }) // } } specialShopCSV.forEach((it,rowIndex)=>{ for(let i = 0; i < 60; i++){ check(rowIndex, i) } }) return d3.group(result, d=>d.key) }34:[] 2f:{"id":"618dcf86d688669a","slug":null,"title":"[FFXIV] Special Shop List by Currency","thumbnail":"2d5845beb745bbe2aa9696b2646e1e92eeeb88e24bb3f23520febecb3fe250a7","access_level":"public","create_time":"$D2023-06-21T05:07:59.426Z","update_time":"$D2026-03-04T13:31:18.820Z","view_time":null,"first_public_time":"$D2023-06-21T05:07:59.426Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"ebb6118c9a990a2c","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":"starter_2024"},"version":404,"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":0,"collection":{"id":"618097a6397b7b90","slug":"ffxiv","title":"FFXIV","owner":{"id":"ebb6118c9a990a2c","login":"unluckyninja","name":"UnluckyNinja"}},"type":"notebook","body":{"title":"[FFXIV] Special Shop List by Currency","cells":[{"id":0,"value":"# [FFXIV] Special Shop List by Currency","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":126,"value":"viewof serverType = Inputs.radio(new Map([['国服', 'zh'], ['国际服（en）', 'en']]), {label: '运营地区', value: 'zh'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":100,"value":"viewof currencyID = Inputs.text({label: '输入货币的物品ID', value: 31135 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"viewof selectedShop = Inputs.select(groupedShops, {label: '查看商店', format: d=>`${d[0]}: ${d[1][0].label}`})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"viewof debugShopID = Inputs.text({label: '调试用，输入商店ID查看商店物品', value: '' })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":237,"value":"viewof table = Inputs.table((debugShopID ? shopMap.get(debugShopID) : null) || selectedShop || [], {\n layout: 'auto',\n columns: [\n 'order',\n 'receive',\n 'cost',\n 'questUnlock',\n 'quest',\n 'achievement',\n ],\n header: {\n order: '序号',\n receive: '获得',\n cost: '消耗',\n questUnlock: '解锁商店所需任务',\n quest: '兑换所需任务',\n achievement: '解锁兑换所需成就',\n },\n format: {\n receive: (list)=>htl.html`${list.map(it=>`${it.count}x ${itemsInfo.get(it.id).name}`).join('
')}`,\n cost: (list)=>htl.html`${list.map(it=>`${it.count}x ${itemsInfo.get(it.id).name}`).join('
')}`,\n achievement: (d)=>d > 0 ? htl.html`${achievementInfo[d].name}` : '',\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"groupedShops = d3.group(shops, d=>d.key)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"itemsInfo = {\n const db = serverType === 'zh' ? itemdb_cn : itemdb\n const items = await db.query(`select items.\"key: #\" as id, \"9: Name\" as name, items.\"22: IsUntradable\" as untradable from items where list_contains([${allItems.join(',')}], id)`)\n const result = new Map()\n for (const item of items){\n result.set(item.id, item)\n }\n return result\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":211,"value":"allItems = [...d3.group(shops.flatMap(it=>[...it.receive, ...it.cost]), d=>d.id).keys()]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":370,"value":"

\n## Debug","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":365,"value":"debugShop = shopMap.get(debugShopID)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":180,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":278,"value":"### 用于什么值得卖工具的生成器","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":108,"value":"JSON (`{ id: cost }`)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":140,"value":"viewof filterUntradeable = Inputs.toggle({label: '过滤不可交易物品'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"viewof currentShopOnly = Inputs.toggle({label: '仅当前商店'})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"

\n${JSON.stringify(Object.fromEntries(midresult4.map(it => [it.receive[0].id, it.cost[0].count/it.receive[0].count])), null, 2)}\n

","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":74,"value":"midresult4 = (currentShopOnly ? selectedShop : midresult).filter(row=>{\n const id = row.receive[0].id\n return midresult3[id] !== undefined\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"// 过滤不可交易物品\nmidresult3 = Object.fromEntries(midresult2.filter(it=>{\n if (!filterUntradeable) {\n return !!it.name // 不过滤不可交易时仅过滤无名称物品\n } else {\n return it.untradable === 'False' && !!it.name\n }\n}).map(it=>[it.id, it.untradable !== 'False']))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"midresult2 = {\n const db = serverType === 'zh' ? itemdb_cn : itemdb\n const list = [...d3.group(midresult.flatMap(it=>[...it.receive]), d=>d.id).keys()]\n return (await db.query(`select items.\"key: #\" as id, \"9: Name\" as name, items.\"22: IsUntradable\" as untradable from items where list_contains([${list.join(',')}], id)`))\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"debug2 = shops.filter(it=> it.cost.length > 1 )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"debug1 = shops.filter(it=> it.receive.length > 1 )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"midresult = {\n return shops.filter(it=> it.receive.length === 1 )\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"shops = debugShop || getShopsByCost(currencyID)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":305,"value":"gainShops = getShopsByGain('36218')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":302,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":359,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":382,"value":"debugSpecialShopColumn = {\n const lineend0 = specialShopCSVraw.indexOf('\\n')\n const lineend1 = specialShopCSVraw.indexOf('\\n', lineend0+1)\n const headers = specialShopCSVraw.slice(lineend0, lineend1).split(',')\n return Inputs.table(headers.map((it,idx)=>[idx, it]), {layout: 'auto'})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"specialShopCSV = {\n return parseCSV(specialShopCSVraw)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":283,"value":"achievementInfo = {\n const map = {}\n for (const item of achievementCSV){\n map[item[0]] = {\n id: item[0],\n name: item[2],\n description: item[3]\n }\n }\n return map\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"achievementCSV = {\n const en = 'https://raw.githubusercontent.com/xivapi/ffxiv-datamining/master/csv/Achievement.csv'\n const zh = 'https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/Achievement.csv'\n const target = serverType === 'zh' ? zh : en\n return parseCSV(await (await fetch(target)).text())\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":377,"value":"specialShopCSVraw = {\n // 'https://docs.google.com/spreadsheets/d/e/2PACX-1vSw2F2SwSSYTbsROX7MgF2sOZ_XfpDsd84BBw5zuodPDyvoYjGTaZNqhf-MX3DY1fJbXUeDJYW4YtQj/pub?gid=843459945&single=true&output=csv'\n const en = 'https://raw.githubusercontent.com/xivapi/ffxiv-datamining/master/csv/SpecialShop.csv'\n const zh = 'https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/SpecialShop.csv'\n const target = serverType === 'zh' ? zh : en\n return await (await fetch(target)).text()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"function parseCSV(text) {\n const lineend0 = text.indexOf('\\n') // key,0,1 ...\n const lineend1 = text.indexOf('\\n', lineend0 + 1) // #, Name, ...\n const lineend2 = text.indexOf('\\n', lineend1 + 1) // int,str, ...\n // const lineend3 = text.indexOf('\\n', lineend2 + 1) // 0, '', ... , some files don't start with 0\n const idxes = text.slice(0, lineend0).split(',')\n const labels = text.slice(lineend0 + 1, lineend1).split(',')\n return d3.csvParseRows(text.slice(lineend2 + 1))\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"import { itemdb, itemdb_cn } from '1ef1dad66b92c723'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 30:"$2f:body"