diff options
Diffstat (limited to 'users/wpcarro/ynabsql')
| -rw-r--r-- | users/wpcarro/ynabsql/dataviz/components.js | 235 | ||||
| -rw-r--r-- | users/wpcarro/ynabsql/dataviz/index.css | 1 | ||||
| -rw-r--r-- | users/wpcarro/ynabsql/dataviz/index.html | 17 |
3 files changed, 250 insertions, 3 deletions
diff --git a/users/wpcarro/ynabsql/dataviz/components.js b/users/wpcarro/ynabsql/dataviz/components.js new file mode 100644 index 000000000000..40653189785e --- /dev/null +++ b/users/wpcarro/ynabsql/dataviz/components.js @@ -0,0 +1,235 @@ +const usd = new Intl.NumberFormat('en-US', { + style: 'currency', + currency: 'USD', +}); + +const categories = data.data.transactions.reduce((xs, x) => { xs[x.Category] = null; return xs; }, {}); + +function sortTransactions(transactions) { + return [...transactions].sort((x, y) => { + if (x.Outflow < y.Outflow) { + return 1; + } else if (x.Outflow > y.Outflow) { + return -1; + } else { + return 0; + } + }); +} + +function transactionKey(x) { + const keys = [ + 'Account', + 'Flag', + 'Date', + 'Payee', + 'Category', + 'Memo', + 'Outflow', + 'Inflow', + 'Cleared', + ]; + return keys.map(k => x[k]).join('|'); +} + +class App extends React.Component { + constructor(props) { + super(props); + const query = 'Account:/checking/ after:"01/01/2022" before:"01/01/2023"'; + + this.state = { + query, + transactions: select(query, data.data.transactions), + saved: {}, + focus: { + 1000: false, + 100: false, + 10: false, + 1: false, + 0.1: false, + }, + }; + } + + render() { + const sum = this.state.transactions.reduce((acc, { Outflow }) => acc + Outflow, 0); + const savedSum = Object.values(this.state.saved).reduce((acc, sum) => acc + sum, 0); + + return ( + <div className="container"> + <select> + {Object.keys(categories).map(x => ( + <option value={x} key={x}>{x}</option> + ))} + </select> + <Input + query={this.state.query} + onChange={query => this.setState({ + query, + })} + onFilter={() => this.setState({ + transactions: select(this.state.query, data.data.transactions), + })} + onSave={() => this.setState({ + saved: { ...this.state.saved, [this.state.query]: sum } + })} + /> + <AggregateTable + focus={this.state.focus} + onFocus={(n) => this.setState({ + focus: { ...this.state.focus, [n]: !this.state.focus[n] }, + })} + transactions={this.state.transactions} + /> + <hr /> + <div> + <ul> + {Object.keys(this.state.saved).map(k => ( + <li key={k}> + {usd.format(this.state.saved[k])} {k} + </li> + ))} + </ul> + <p>{usd.format(savedSum)}</p> + <button className="btn btn-default" onClick={() => this.setState({ saved: {} })}>clear</button> + </div> + <hr /> + <Table + transactions={sortTransactions(this.state.transactions)} + onClick={x => this.setState({ + saved: { ...this.state.saved, [transactionKey(x)]: x.Outflow } + })} + /> + </div> + ); + } +} + +/** + * Table rendering information about transactions bucketed by its order of + * magnitude. + */ +const Magnitable = ({ label, transactions }) => { + const categories = transactions.reduce((acc, x) => { + if (x.Category === '') { + return acc; + } + if (!(x.Category in acc)) { + acc[x.Category] = 0; + } + acc[x.Category] += x.Outflow; + return acc; + }, {}); + + // Sort category keys by sum decreasing. + const keys = [...Object.keys(categories)].sort((x, y) => { + if (categories[x] < categories[y]) { + return 1; + } else if (categories[x] > categories[y]) { + return -1; + } else { + return 0; + } + }); + + return ( + <React.Fragment> + {keys.map(k => ( + <tr style={{backgroundColor: '#F0F8FF'}}> + <td>{k}</td><td>{usd.format(categories[k])}</td> + </tr> + ))} + </React.Fragment> + ); +}; + +/** + * Calculates and renders various aggregates over an input list of transactions. + */ +const AggregateTable = ({ focus, onFocus, transactions }) => { + const sum = transactions.reduce((acc, x) => acc + x.Outflow, 0); + const buckets = transactions.reduce((acc, x) => { + const order = Math.floor(Math.log(x.Outflow) / Math.LN10 + 0.000000001); + const bucket = Math.pow(10, order); + acc[bucket].push(x); + return acc; + }, {0.1: [], 0: [], 1: [], 10: [], 100: [], 1000: []}); + + return ( + <div> + <table> + <caption>Aggregations</caption> + <thead> + <tr> + <th>function</th> + <th>value</th> + </tr> + </thead> + <tbody> + <tr><td>sum</td><td>{usd.format(sum)}</td></tr> + <tr><td>per day</td><td>{usd.format(sum / 365)}</td></tr> + <tr><td>per week</td><td>{usd.format(sum / 52)}</td></tr> + <tr><td>per month</td><td>{usd.format(sum / 12)}</td></tr> + <tr onClick={() => onFocus(1000)}><td>Σ Θ($1,000)</td><td>{usd.format(buckets[1000].reduce((acc, x) => acc + x.Outflow, 0))}</td></tr> + {(focus[1000]) && <Magnitable label="$1,000" transactions={buckets[1000]} />} + <tr onClick={() => onFocus(100)}><td>Σ Θ($100)</td><td>{usd.format(buckets[100].reduce((acc, x) => acc + x.Outflow, 0))}</td></tr> + {(focus[100]) && <Magnitable label="$100" transactions={buckets[100]} />} + <tr onClick={() => onFocus(10)}><td>Σ Θ($10)</td><td>{usd.format(buckets[10].reduce((acc, x) => acc + x.Outflow, 0))}</td></tr> + {(focus[10]) && <Magnitable label="$10" transactions={buckets[10]} />} + <tr onClick={() => onFocus(1)}><td>Σ Θ($1)</td><td>{usd.format(buckets[1].reduce((acc, x) => acc + x.Outflow, 0))}</td></tr> + {(focus[1]) && <Magnitable label="$1.00" transactions={buckets[1]} />} + <tr onClick={() => onFocus(0.1)}><td>Σ Θ($0.10)</td><td>{usd.format(buckets[0.1].reduce((acc, x) => acc + x.Outflow, 0))}</td></tr> + {(focus[0.1]) && <Magnitable label="$0.10" transactions={buckets[0.1]} />} + <tr><td>average</td><td>{usd.format(sum / transactions.length)}</td></tr> + <tr><td>count</td><td>{transactions.length}</td></tr> + </tbody> + </table> + </div> + ); +}; + +const Input = ({ query, onChange, onFilter, onSave }) => ( + <fieldset> + <legend>Query</legend> + <div className="form-group"> + <input name="query" type="text" value={query} onChange={e => onChange(e.target.value)} /> + <div className="btn-group"> + <button className="btn btn-default" onClick={() => onFilter()}>Filter</button> + <button className="btn btn-default" onClick={() => onSave()}>Save</button> + </div> + </div> + </fieldset> +); + +const Table = ({ transactions, onClick }) => ( + <table> + <caption>Transactions</caption> + <thead> + <tr> + <th>Account</th> + <th>Category</th> + <th>Date</th> + <th>Outflow</th> + <th>Payee</th> + <th>Memo</th> + </tr> + </thead> + <tbody> + {transactions.map(x => ( + <tr onClick={() => onClick(x)}> + <td>{x.Account}</td> + <td>{x.Category}</td> + <td>{x.Date.toLocaleDateString()}</td> + <td>{usd.format(x.Outflow)}</td> + <td>{x.Payee}</td> + <td>{x.Memo}</td> + </tr> + ))} + </tbody> + </table> +); + +const domContainer = document.querySelector('#react-mount'); +const root = ReactDOM.createRoot(domContainer); + +root.render(<App />); \ No newline at end of file diff --git a/users/wpcarro/ynabsql/dataviz/index.css b/users/wpcarro/ynabsql/dataviz/index.css deleted file mode 100644 index 82130daf4867..000000000000 --- a/users/wpcarro/ynabsql/dataviz/index.css +++ /dev/null @@ -1 +0,0 @@ -/* testing */ diff --git a/users/wpcarro/ynabsql/dataviz/index.html b/users/wpcarro/ynabsql/dataviz/index.html index 00f35a7807dd..823ffdc58b08 100644 --- a/users/wpcarro/ynabsql/dataviz/index.html +++ b/users/wpcarro/ynabsql/dataviz/index.html @@ -2,11 +2,24 @@ <html lang="en"> <head> <meta charset="UTF-8" /> - <link rel="stylesheet" href="./index.css" /> + <link rel="stylesheet" href="https://unpkg.com/terminal.css@0.7.2/dist/terminal.min.css" /> + <link rel="stylesheet" href="https://unpkg.com/terminal.css@0.7.1/dist/terminal.min.css" /> + <link rel="stylesheet" href="https://unpkg.com/terminal.css@0.7.1/dist/terminal.min.css" /> </head> <body> - <canvas id="mount"></canvas> + <div id="react-mount"></div> + <!-- <canvas id="mount"></canvas> --> + + <!-- chart.js --> <script src="https://cdn.jsdelivr.net/npm/chart.js"></script> + <!-- react.js --> + <script src="https://unpkg.com/react@18/umd/react.development.js" crossorigin></script> + <script src="https://unpkg.com/react-dom@18/umd/react-dom.development.js" crossorigin></script> + <script src="https://unpkg.com/babel-standalone@6/babel.min.js"></script> + <!-- depot JS --> + <script src="http://localhost:8002/index.js"></script> + <script src="./data.js"></script> <script src="./index.js"></script> + <script src="./components.js" type="text/babel"></script> </body> </html> |