-
Notifications
You must be signed in to change notification settings - Fork 0
/
PivotTable.js
120 lines (112 loc) · 2.89 KB
/
PivotTable.js
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
import React from 'react';
import { StyleSheet, Text, TouchableOpacity, View } from 'react-native';
import * as FlexmonsterReactNative from 'react-native-flexmonster';
class PivotTable extends React.Component {
report = {
"dataSource": {
"type": "csv",
"filename": "https://cdn.flexmonster.com/data/data.csv"
},
"slice": {
"rows": [
{
"uniqueName": "Category"
}
],
"columns": [
{
"uniqueName": "Color"
},
{
"uniqueName": "[Measures]"
}
],
"measures": [
{
"uniqueName": "Price",
"aggregation": "sum"
}
]
},
"options": {
"chart": {
"showFilter": false,
"showMeasures": false
}
}
}
onclickHandler = (cell) => {
alert("Clicked on cell with label - " + cell.label + ", and row index - " + cell.rowIndex);
this.flexmonster.off("cellclick");
this.flexmonster.on("update", () => {
alert("Report was updated");
});
}
showChart = () => {
this.flexmonster.setFilter("Category", {
"members": [
"category.[cars]"
]
});
this.flexmonster.showCharts("column");
}
showGrid = () => {
this.flexmonster.setFilter("Category", {});
this.flexmonster.showGrid();
}
render() {
return (
<View style={{ flex: 1 }}>
<View style={styles.buttonControllsContainer}>
<View style={styles.buttonContainer}>
<TouchableOpacity activeOpacity={0.8} onPress={this.showChart} style={styles.buttonFirst}>
<Text style={styles.buttonText}>Show Chart</Text>
</TouchableOpacity>
</View>
<View style={styles.buttonContainer}>
<TouchableOpacity activeOpacity={0.8} onPress={this.showGrid} style={styles.button}>
<Text style={styles.buttonText}>Show Grid</Text>
</TouchableOpacity>
</View>
</View>
<FlexmonsterReactNative.Pivot style={{ flexGrow: 2 }}
report={this.report}
cellclick={this.onclickHandler}
ref={flexmonster => this.flexmonster = flexmonster}
/>
</View >
);
}
}
const styles = StyleSheet.create({
buttonControllsContainer: {
flexDirection: 'row',
alignItems: 'center',
},
buttonContainer: {
flex: 1,
},
button: {
backgroundColor: "#df3800",
paddingLeft: 12,
paddingRight: 12,
paddingTop: 10,
paddingBottom: 10
},
buttonFirst: {
backgroundColor: "#df3800",
paddingLeft: 12,
paddingRight: 12,
paddingTop: 10,
paddingBottom: 10,
marginRight: 2
},
buttonText: {
fontSize: 14,
color: '#fff',
textTransform: "uppercase",
textAlign: "center"
},
});
//export { PivotTable as PivotTableComponent }; // React <17
export var PivotTableComponent = React.forwardRef((props, ref) => <PivotTable />); // React >=18