File size: 8,907 Bytes
2e10c7a | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 | // Dashtreme's DataTables, in React: "Show N entries", search, Copy / CSV / Print, sortable striped rows, "Showing x to y
// of z entries" and pagination. Columns render cells and give raw values for sorting, searching and export.
import { useEffect, useMemo, useState, type ReactNode } from 'react'
import { download, toCsv } from '../lib/csv'
import { useStored } from '../lib/hooks'
import { useFeedback } from './feedback'
import { Help } from './ui'
export type Col<R> = {
key: string
label: string
/** Render the cell (default: the value as text). */
render?: (row: R) => ReactNode
/** The raw value for sorting, filtering and export (default: row[key]). */
value?: (row: R) => unknown
num?: boolean
wrap?: boolean
help?: string
width?: number
}
const SIZES = [10, 25, 50, 100, 0] as const // 0 = all
function pages(cur: number, total: number): (number | '…')[] {
if (total <= 7) return Array.from({ length: total }, (_, i) => i)
const out: (number | '…')[] = [0]
const lo = Math.max(1, cur - 1), hi = Math.min(total - 2, cur + 1)
if (lo > 1) out.push('…')
for (let i = lo; i <= hi; i++) out.push(i)
if (hi < total - 2) out.push('…')
out.push(total - 1)
return out
}
/** ``compact`` fits a narrow card: header labels wrap onto two lines and the cells pad less. */
export function DataTable<R extends Record<string, unknown>>({ rows, cols, height = 560, filename = 'table', onRowClick, empty = 'No rows.', search = true, initialSort, pageSize, compact = false }: {
rows: R[]; cols: Col<R>[]; height?: number; filename?: string; onRowClick?: (r: R) => void; empty?: ReactNode; search?: boolean
initialSort?: { key: string; desc?: boolean }; pageSize?: number; compact?: boolean
}) {
const fb = useFeedback()
const [sort, setSort] = useState<{ key: string; desc: boolean } | null>(initialSort ? { key: initialSort.key, desc: !!initialSort.desc } : null)
const [filter, setFilter] = useState('')
const [size, setSize] = useStored<number>(`dt:${filename}:size`, pageSize ?? 10)
const [page, setPage] = useState(0)
const val = (c: Col<R>, r: R) => (c.value ? c.value(r) : r[c.key])
const shown = useMemo(() => {
let out = rows
const f = filter.trim().toLowerCase()
if (f) out = out.filter((r) => cols.some((c) => { const v = val(c, r); return v !== null && v !== undefined && String(v).toLowerCase().includes(f) }))
if (sort) {
const c = cols.find((x) => x.key === sort.key)
if (c) {
out = [...out].sort((a, b) => {
const x = val(c, a), y = val(c, b)
if (x === y) return 0
if (x === null || x === undefined) return 1
if (y === null || y === undefined) return -1
const r = typeof x === 'number' && typeof y === 'number' ? x - y : String(x).localeCompare(String(y), undefined, { numeric: true })
return sort.desc ? -r : r
})
}
}
return out
// eslint-disable-next-line react-hooks/exhaustive-deps
}, [rows, cols, sort, filter])
const per = size > 0 ? size : Math.max(1, shown.length)
const npages = Math.max(1, Math.ceil(shown.length / per))
useEffect(() => { if (page > npages - 1) setPage(npages - 1) }, [npages, page])
if (!rows.length) return <div className="empty">{empty}</div>
const start = Math.min(page, npages - 1) * per
const view = shown.slice(start, start + per)
const click = (k: string) => setSort((s) => (!s || s.key !== k ? { key: k, desc: false } : !s.desc ? { key: k, desc: true } : null))
const exportRows = () => shown.map((r) => cols.map((c) => val(c, r)))
const copy = async () => {
const text = [cols.map((c) => c.label).join('\t'), ...exportRows().map((r) => r.map((v) => (v === null || v === undefined ? '' : typeof v === 'object' ? JSON.stringify(v) : String(v))).join('\t'))].join('\n')
try { await navigator.clipboard.writeText(text); fb.toast(`Copied ${shown.length} rows`, 'success', 2500) } catch { fb.toast('The browser refused the clipboard', 'error') }
}
const print = () => {
const w = window.open('', '_blank'); if (!w) return
const esc = (v: unknown) => String(v ?? '').replace(/[&<>]/g, (m) => ({ '&': '&', '<': '<', '>': '>' })[m]!)
w.document.write(`<title>${esc(filename)}</title><style>body{font:12px system-ui;margin:16px}table{border-collapse:collapse;width:100%}th,td{border:1px solid #ccc;padding:4px 6px;text-align:left}th{background:#eee}</style>`
+ `<h3>${esc(filename)}</h3><table><thead><tr>${cols.map((c) => `<th>${esc(c.label)}</th>`).join('')}</tr></thead><tbody>`
+ exportRows().map((r) => `<tr>${r.map((v) => `<td>${esc(typeof v === 'object' && v !== null ? JSON.stringify(v) : v)}</td>`).join('')}</tr>`).join('') + '</tbody></table>')
w.document.close(); w.focus(); w.print()
}
return (
<div className="dt">
<div className="dt-top">
<label className="dt-len">Show
<select className="form-select form-select-sm" value={size} onChange={(e) => { setSize(Number(e.target.value)); setPage(0) }}>
{SIZES.map((s) => <option key={s} value={s}>{s || 'All'}</option>)}
</select>entries</label>
<div className="btn-group dt-buttons" role="group">
<button type="button" className="btn btn-sm btn-light" onClick={copy}>Copy</button>
<button type="button" className="btn btn-sm btn-light" onClick={() => download(`${filename}.csv`, toCsv(cols.map((c) => c.label), exportRows()))}>CSV</button>
<button type="button" className="btn btn-sm btn-light" onClick={print}>Print</button>
</div>
{search && <label className="dt-search">Search:<input className="form-control form-control-sm" value={filter} onChange={(e) => { setFilter(e.target.value); setPage(0) }} /></label>}
</div>
<div className="ftable-wrap" style={{ maxHeight: height }}>
<table className={`ftable ${compact ? 'compact' : ''}`}>
<thead>
<tr>
{cols.map((c) => (
<th key={c.key} className={`${c.num ? 'num' : ''} ${sort?.key === c.key ? 'sorted' : ''}`} style={c.width ? { width: c.width } : undefined} onClick={() => click(c.key)}>
{c.label}<Help text={c.help} />
<i className={`bx sort ${sort?.key === c.key ? (sort.desc ? 'bx-sort-down' : 'bx-sort-up') : 'bx-sort-alt-2'}`} />
</th>
))}
</tr>
</thead>
<tbody>
{view.map((r, i) => (
<tr key={start + i} className={onRowClick ? 'clickable' : ''} onClick={onRowClick ? () => onRowClick(r) : undefined}>
{cols.map((c) => {
const v = c.render ? c.render(r) : (val(c, r) as ReactNode)
return <td key={c.key} className={`${c.num ? 'num' : ''} ${c.wrap ? 'wrap' : ''}`}>{v === null || v === undefined || v === '' ? '—' : v}</td>
})}
</tr>
))}
{!view.length && <tr><td colSpan={cols.length} className="text-center text-muted2">No matching rows</td></tr>}
</tbody>
</table>
</div>
<div className="dt-bottom">
<span>Showing {shown.length ? start + 1 : 0} to {start + view.length} of {shown.length} entries{shown.length !== rows.length ? ` (filtered from ${rows.length})` : ''}</span>
{npages > 1 && (
<ul className="pagination pagination-sm">
<li className={`page-item ${page === 0 ? 'disabled' : ''}`}><a className="page-link" onClick={() => setPage(Math.max(0, page - 1))}>Prev</a></li>
{pages(page, npages).map((p, i) => p === '…'
? <li key={`e${i}`} className="page-item disabled"><span className="page-link">…</span></li>
: <li key={p} className={`page-item ${p === page ? 'active' : ''}`}><a className="page-link" onClick={() => setPage(p)}>{p + 1}</a></li>)}
<li className={`page-item ${page >= npages - 1 ? 'disabled' : ''}`}><a className="page-link" onClick={() => setPage(Math.min(npages - 1, page + 1))}>Next</a></li>
</ul>
)}
</div>
</div>
)
}
/** A 0..1 score as a bar with its number (Streamlit's ProgressColumn). */
export function BarCell({ value, max = 1, digits = 3 }: { value: number | null | undefined; max?: number; digits?: number }) {
if (value === null || value === undefined) return <>—</>
return (
<span className="bar-cell">
<span className="track"><span className="fill" style={{ width: `${Math.max(0, Math.min(1, value / max)) * 100}%` }} /></span>
<span className="num">{value.toFixed(digits)}</span>
</span>
)
}
/** Dashtreme's status pill in a table cell. */
export function Pill({ children, color = 'gray' }: { children: ReactNode; color?: string }) {
return <span className={`fbadge ${color}`} style={{ minWidth: 86, justifyContent: 'center' }}>{children}</span>
}
|