MCPcopy Create free account
hub / github.com/explorerhq/sql-explorer / pivotSetup

Function pivotSetup

explorer/src/js/pivot-setup.js:4–31  ·  view source on GitHub ↗
($)

Source from the content-addressed store, hash-verified

2import {csvFromTable} from "./table-to-csv";
3import $ from "jquery";
4export function pivotSetup($) {
5
6 let pivotState = {};
7 if (window.location.hash) {
8 try {
9 pivotState = JSON.parse(atob(window.location.hash.slice(1)));
10 } catch(e) {
11 console.log(e);
12 }
13 }
14 pivotState["onRefresh"] = savePivotState;
15
16 pivotJq($);
17 let pivotInput = $("#preview").clone();
18 pivotInput.find("tr.stats-th").remove();
19 $(".pivot-table").pivotUI(pivotInput, pivotState);
20
21 let csvButton = document.querySelector("#button-excel");
22 if (csvButton) {
23 csvButton.addEventListener("click", e => {
24 e.preventDefault();
25 let table = document.querySelector(".pvtTable");
26 if (typeof (table) != 'undefined' && table != null) {
27 csvFromTable(table);
28 }
29 });
30 }
31}
32
33function savePivotState(state) {
34 const picked = (({ aggregatorName, rows, cols, rendererName, vals }) => ({ aggregatorName, rows, cols, rendererName, vals }))(state);

Callers 1

bindMethod · 0.85

Calls 3

pivotJqFunction · 0.90
csvFromTableFunction · 0.90
logMethod · 0.80

Tested by

no test coverage detected