31:[] 2f:{"title":"Multisig Playground","cells":[{"id":0,"value":"title = md`# Multisig Playground`","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"viewof ids = text({placeholder: \"f address\", description: \"ActorIDs of the multisig (comma separated)\", value: 'f0117, f0118'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":93,"value":"viewof selectedDate = date({\n min: \"2020-08-24\",\n max: d3.utcFormat(\"%Y-%m-%d\")(new Date()),\n description: \"Either pick a date or leave it empty for latest block\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":160,"value":"md`Showing results for epoch \\`${selectedEpoch}\\``","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"tableResult = multisig_table(interestingMultisigs.map(prepareForTable))","pinned":false,"hidden":false,"mode":"ojs"},{"id":200,"value":"summaryText = md`Showing the summary`","pinned":false,"hidden":false,"mode":"ojs"},{"id":189,"value":"summary = multisig_table([({...sum})])","pinned":false,"hidden":false,"mode":"ojs"},{"id":233,"value":"download = DOM.download(serialize(interestingMultisigs.map(prepareForTable)), `snapshot-epoch-${selectedEpoch}.csv`, \"Download CSV\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":22,"value":"md`\n---\n\n---\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":32,"value":"multisigIds = ids.split(',').map(d => d.trim())","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"allMultiSigs = getMultisigs(selectedEpoch)","pinned":false,"hidden":false,"mode":"ojs"},{"id":29,"value":"interestingMultisigs = allMultiSigs\n .data\n .Height\n .ParentStateRoot\n .Actors\n .AllOf\n .filter(d => multisigIds.includes(d.Key) || d.Value.Head.Signers.All.some(d => multisigIds.includes(d)))\n .map(MultiSigState)","pinned":false,"hidden":false,"mode":"ojs"},{"id":166,"value":"sum = interestingMultisigs.reduce((acc, {Key, Computed, Value}) => ({\n AvailableBalance: acc.AvailableBalance + Computed.AvailableBalance,\n Spent: acc.Spent + Computed.Spent,\n Balance: acc.Balance + Value.Balance / 1e18,\n}), {AvailableBalance: 0, Spent: 0, Balance: 0})","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"api = \"https://graphql.decentralized.app/graphql\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":228,"value":"import {serialize} from \"@palewire/saving-csv\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"gql = function (strings){\n let query = strings[0] + \"\", i = 0, n = arguments.length;\n while (++i < n) query += arguments[i] + \"\" + strings[i];\n\n const opts = {\n headers: {\n 'Content-Type': 'application/json',\n 'Accept': 'application/json',\n },\n method: 'post',\n body: JSON.stringify({query})\n };\n\n return fetch(api, opts).then(r=>r.json())\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"MultiSigState = d => ({...d, Computed: {\n BlockRate: +d.Value.Head.InitialBalance/d.Value.Head.UnlockDuration/1e18,\n HourRate: (+d.Value.Head.InitialBalance/d.Value.Head.UnlockDuration/1e18)*2*60,\n InitialBalance: +d.Value.Head.InitialBalance/1e18,\n AvailableBalance: (() => {\n if (!d.Value.Head.UnlockDuration) return +d.Value.Balance/1e18\n let remaining = d.Value.Head.StartEpoch + d.Value.Head.UnlockDuration - selectedEpoch\n if (remaining < 0) remaining = 0\n const locked = Math.ceil(+d.Value.Head.InitialBalance * remaining / d.Value.Head.UnlockDuration)\n return (+d.Value.Balance - locked)/1e18\n })(),\n Spent: d.Value.Head.InitialBalance > 0 ? (d.Value.Head.InitialBalance - d.Value.Balance)/1e18 : 0\n }})","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"getMultisigs = (h) => gql`\nquery query {\n Height(at: ${h}) {\n Height\n ParentStateRoot {\n Version\n Actors {\n AllOf(type: \"multisigActor\") {\n Key\n Value {\n Balance\n Head {\n ... on MultisigV0State {\n NextTxnID\n StartEpoch\n InitialBalance\n UnlockDuration\n Signers {\n All\n }\n }\n }\n }\n }\n }\n }\n }\n}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":119,"value":"selectedEpoch = !selectedDate ? expectedEpoch : getFilecoinExpectedHeight(new Date(`${selectedDate} 00:00:00Z`).getTime())","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"expectedEpoch = getFilecoinExpectedHeight(Date.now())","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"function getFilecoinExpectedHeight (at) {\n const filGenesis = new Date('2020-08-24 22:00:00Z').getTime()\n return Math.floor((at - filGenesis) / 1000 / 30)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":181,"value":"prepareForTable = ({Key, Computed, Value}) => ({\n Key,\n AvailableBalance: Computed.AvailableBalance,\n Spent: Computed.Spent,\n Balance: Value.Balance / 1e18,\n NextTxnID: Value.Head.NextTxnID,\n Signers: Value.Head.Signers.All.length\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"multisig_table = (actors) => table(actors\n .sort((a, b) => b.Balance - a.Balance), {\n sortable: true,\n columns: {\n AvailableBalance: {\n title: 'Available',\n formatter(val, i) {\n return d3.format(',.0f')(val);\n// return html`

\n//

${i == 0 ? d3.format('.0%')(val / 100) : val}\n//

`;\n }\n },\n Key: {\n formatter(val) {\n return html`${val}`;\n }\n },\n Balance: {\n formatter(val) {\n return d3.format(',.0f')(val);\n }\n },\n Spent: {\n formatter(val) {\n return d3.format(',.0f')(val);\n }\n }\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"import {table} from \"@tmcw/tables\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":62,"value":"import {text} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":90,"value":"import {date} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}