// Monthly Active Accounts Example let rawData = fetch( "https://api.flipsidecrypto.com/api/v2/queries/ee247ce2-30ad-4991-bd3a-3648a2bbdae3/data/latest", { subscribe: true, method: "GET", headers: { Accept: "*/*", }, } ); // data.body = data.body.sort((a, b) => new Date(a.MONTH) - new Date(b.MONTH)); State.init({ setSortConfig: { key: null, direction: "asc" } }); let Style = styled.div` .table-header { background-color: #000000; /* Set this to the desired dark color for the header */ color: #ffffff; text-align: center; font-weight: 600; } `; let nodes = rawData.body || []; function formatPercentNew(text) { let number = parseFloat(text); return <span className="text-white">{number}%</span>; } function formatNumber(num) { return ( <span className="text-white text-sm p-2"> {num.toString().replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1,")} </span> ); } function formatNumberDecimal(text) { let number = parseInt(text); return ( <span className="text-white"> {number.toString().replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1,")} </span> ); } function formatCell(text) { return ( <a href={ "https://beta.nearatlas.com/#/y3k.near/widget/near_atlas.components.detail_chart?project_name=" + text } className="text-red-50 text-wrap " > {text} </a> ); } function formatText(text) { let number = parseFloat(text); if (number < 0) { return <span className="text-red-600">{number}%</span>; // Red color for negative numbers } else if (number > 0) { return <span className="text-green-600">{number}%</span>; // Green color for positive numbers } else { return <span className="text-yellow-600">{number}%</span>; // Yellow color for zero } } const data = { nodes: nodes, }; const COLUMNS = [ { label: ( <p className="text-center text-white text-sm font-semibold p-2 text-wrap"> Project </p> ), renderCell: (item) => formatCell(item["Contract Address"]), sort: { sortKey: "ContractAddress" }, }, { label: ( <p className="text-center text-white text-sm font-semibold p-2 text-wrap "> Past 30 Days </p> ), renderCell: (item) => formatNumber(item["Past 30 Days"]), sort: { sortKey: "Past 30 Days" }, }, { label: ( <p className="text-center text-white text-sm font-semibold p-2 text-wrap "> Last Month </p> ), renderCell: (item) => formatNumber(item["30-60 Days Ago"]), sort: { sortKey: "30-60 Days Ago" }, }, { label: ( <p className="text-center text-white text-sm font-semibold p-2 text-wrap "> M/M </p> ), renderCell: (item) => formatText(item["M/M"]), sort: { sortKey: "M/M" }, }, { label: ( <p className="text-center text-white text-sm font-semibold p-2 text-wrap "> New MAAs </p> ), renderCell: (item) => formatNumber(item["New MAAs"]), sort: { sortKey: "New MAAs" }, }, { label: ( <p className="text-center text-white text-sm font-semibold p-2 text-wrap "> M2 Retention </p> ), renderCell: (item) => formatPercentNew(item["M2 Retention"]), sort: { sortKey: "M2 Retention" }, }, { label: ( <p className="text-center text-white text-sm font-semibold p-2 text-wrap "> Average DAU </p> ), renderCell: (item) => formatNumberDecimal(item["Daily Average"]), sort: { sortKey: "Daily Average" }, }, { label: ( <p className="text-center text-white text-sm font-semibold p-2 text-wrap "> Stickiness </p> ), renderCell: (item) => formatPercentNew(item["DAU / MAU"]), sort: { sortKey: "DAU / MAU" }, }, ]; function sort_update(sortKey, direction) { // Update the sort state State.update({ setSortConfig: { key: sortKey, direction }, }); } // Function to get the sorted nodes function getSortedNodes() { // Get the current sort configuration from the state const sortConfig = state.setSortConfig; // Apply sorting if there's a sort key and direction if (sortConfig && sortConfig.key && sortConfig.direction) { const sortedNodes = [...nodes]; sortedNodes.sort((a, b) => { if (a[sortConfig.key] < b[sortConfig.key]) { return sortConfig.direction === "asc" ? -1 : 1; } if (a[sortConfig.key] > b[sortConfig.key]) { return sortConfig.direction === "asc" ? 1 : -1; } return 0; }); return sortedNodes; } return nodes; // Return original nodes if no sorting } return ( <div className="bg-dark rounded-lg mb-12 overflow-hidden w-full"> {data !== null ? ( <div style={{ "min-width": "780px" }} className="bg-dark w-full"> <table className="table-auto w-full "> <thead className="bg-gray-700"> <tr> {COLUMNS.map((column, index) => ( <th key={index} className="text-white text-center font-semibold p-2 border-b border-gray-300 cursor-pointer" onClick={() => { const direction = state.setSortConfig.direction === "asc" ? "desc" : "asc"; sort_update(column.sort.sortKey, direction); }} > {column.label} </th> ))} </tr> </thead> <tbody> {getSortedNodes().map((row, rowIndex) => ( <tr key={rowIndex} className={` ${ rowIndex % 2 === 0 ? "bg-gray-800" : "bg-gray-900" }`} > {COLUMNS.map((column, colIndex) => ( <td key={colIndex} className="text-center p-2 "> {column.renderCell(row)} </td> ))} </tr> ))} </tbody> </table> </div> ) : ( <div className="text-white text-center p-4">Loading ...</div> )} </div> );