0af843be
 Renato De Donato
filters + alasql
|
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
|
<link rel="import" href="../../bower_components/polymer/polymer.html" />
<link rel="import" href="../../bower_components/paper-material/paper-material.html" />
<link rel="import" href="../tree-view-controllet/tree-view-controllet.html" />
<link rel="import" href="../multi-table-controllet/multi-table-controllet.html" />
<link rel="import" href="../filters-controllet/filters-controllet.html" />
<dom-module id="select-data-controllet">
<style is="custom-style">
.div_container {
display: flex;
flex-direction: row;
}
#material_tree_view {
position: relative;
width: 25%;
min-width: 200px;
height: 100vh;
}
#material_multi_table_filters {
position: relative;
width: 75%;
margin-left: 64px;
margin-top: 8px;
}
#div_multi_table {
height: 70%;
width: 100%;
position: relative;
}
#div_filters {
height: 30%;
width: 100%;
position: relative;
}
</style>
<template>
<div class="div_container">
<paper-material id="material_tree_view" elevation="5">
<tree-view-controllet id="tree_view" root-name={{rootName}} opened-path={{openedPath}} preselected-fields={{preselectedFields}}></tree-view-controllet>
</paper-material>
<paper-material id="material_multi_table_filters" elevation="5">
<div id="div_multi_table">
<multi-table-controllet id="multi_table" data-url={{dataUrl}}></multi-table-controllet>
</div>
<div id="div_filters">
<filters-controllet id="filters"></filters-controllet>
</div>
</paper-material>
</div>
</template>
<script>
Polymer({
is : 'select-data-controllet',
properties : {
rootName : {
type : String,
value : "root"
},
preselectedFields : {
type : Array,
value : []
},
openedPath : {
type : String,
value : undefined
},
dataUrl : {
type : String,
value : undefined,
observer : '_init'
|
|
98d9d8a5
Renato De Donato
filters+groupby
|
86
87
88
89
90
91
|
},
filters : {
type : Array,
value : undefined
},
|
|
0af843be
Renato De Donato
filters + alasql
|
92
93
94
95
|
},
listeners: {
|
|
98d9d8a5
Renato De Donato
filters+groupby
|
96
97
|
'tree-view-controllet_selected-fields': '_updateSelectedFields',
'filters-controllet_filters': '_updateFilters'
|
|
0af843be
Renato De Donato
filters + alasql
|
98
99
100
|
},
ready : function() {
|
|
0af843be
Renato De Donato
filters + alasql
|
101
|
$(this.$.material_tree_view).perfectScrollbar();
|
|
98d9d8a5
Renato De Donato
filters+groupby
|
102
103
|
if(this.filters == undefined){
|
|
fa9c1751
Renato De Donato
filter bug
|
104
|
if(this.dataletPreset && this.dataletPreset["filters"] != undefined)
|
|
98d9d8a5
Renato De Donato
filters+groupby
|
105
106
107
108
109
110
111
112
|
this.filters = JSON.parse(this.dataletPreset["filters"]);
else
this.filters = [];
}
this.$.filters.filters = this.filters;
this.$.multi_table.filters = this.filters;
this._refreshTables();
|
|
0af843be
Renato De Donato
filters + alasql
|
113
114
115
116
117
118
119
120
|
},
attached : function(){
this._resize();
var that = this;
window.addEventListener("resize", function() { that._resize(); });
},
|
|
98d9d8a5
Renato De Donato
filters+groupby
|
121
122
123
124
|
getFilters : function() {
return this.$.filters.getFilters();
},
|
|
0af843be
Renato De Donato
filters + alasql
|
125
126
127
128
129
130
131
132
133
|
getFields : function() {
return this.$.tree_view.getFields();
},
getFlatFields : function() {
return this.$.tree_view.getFlatFields();
},
_init : function() {
|
|
0af843be
Renato De Donato
filters + alasql
|
134
135
136
137
138
139
|
var that = this;
$.ajax({
url: this.dataUrl,
dataType: "json",
success: function(data){
|
|
98d9d8a5
Renato De Donato
filters+groupby
|
140
141
142
143
|
that.rootName = "data";
var data = that._filterJson(data);
that.$.tree_view.setAttribute("json-data", JSON.stringify(data));
that.$.tree_view.selectedFields = [];
|
|
0af843be
Renato De Donato
filters + alasql
|
144
|
that._updateSelectedFields();
|
|
98d9d8a5
Renato De Donato
filters+groupby
|
145
146
147
|
that.$.tree_view.ready();
that.$.filters.filters = [];
that.$.multi_table.filters = [];
|
|
0af843be
Renato De Donato
filters + alasql
|
148
149
150
151
152
153
154
|
}
});
this.$.multi_table.ready();
},
_filterJson : function(data){
|
|
0314f487
Renato De Donato
filters opendatasoft
|
155
|
//ckan
|
|
0af843be
Renato De Donato
filters + alasql
|
156
157
158
159
|
if(data.result != undefined && data.result.resource_id != undefined) {
this.rootName = "result,records"
return data.result.records;
}
|
|
0314f487
Renato De Donato
filters opendatasoft
|
160
161
162
163
164
165
166
167
|
//openDataSoft
else if(data.parameters != undefined && data.parameters.dataset != undefined) {
this.rootName = "records,fields";
return data.records[0].fields;
}
else{
return data;
}
|
|
0af843be
Renato De Donato
filters + alasql
|
168
169
170
171
172
173
174
175
176
177
|
},
_updateSelectedFields : function() {
var fields = this.$.tree_view.getFields();
this.$.multi_table.setSelectedFields(fields);
var flatFields = this.$.tree_view.getFlatFields();
this.$.filters.setFields(flatFields);
},
|
|
98d9d8a5
Renato De Donato
filters+groupby
|
178
179
180
181
182
183
184
185
186
187
188
189
190
191
|
_updateFilters : function(e) {
this.filters = e.detail.filters;
this.$.multi_table.filters = e.detail.filters;
this._refreshTables();
},
_refreshTables : function() {
this.$.multi_table.setSelectedFields([]);
this.async(function () {
var fields = this.$.tree_view.getFields();
this.$.multi_table.setSelectedFields(fields);
}, 0);
},
|
|
0af843be
Renato De Donato
filters + alasql
|
192
193
194
195
196
197
198
199
200
201
202
203
|
_resize : function(){
var h = Math.max(document.documentElement.clientHeight, window.innerHeight || 0) - 16;
h = h - 64; //height with page scroller
$("#material_tree_view").height(h);
$("#material_multi_table_filters").height(h-8);
}
});
</script>
</dom-module>
|
