Blame view

controllets/select-data-controllet/select-data-controllet.html 6.44 KB
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
                          that.$.tree_view.ready();
ef51505a   Renato De Donato   reset filters
146
                          that.filters = [];
98d9d8a5   Renato De Donato   filters+groupby
147
148
                          that.$.filters.filters = [];
                          that.$.multi_table.filters = [];
0af843be   Renato De Donato   filters + alasql
149
150
151
152
153
154
155
                      }
                  });
  
                  this.$.multi_table.ready();
              },
  
              _filterJson : function(data){
0314f487   Renato De Donato   filters opendatasoft
156
                  //ckan
0af843be   Renato De Donato   filters + alasql
157
158
159
160
                  if(data.result != undefined && data.result.resource_id != undefined) {
                      this.rootName = "result,records"
                      return data.result.records;
                  }
0314f487   Renato De Donato   filters opendatasoft
161
162
163
164
165
166
167
168
                  //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
169
170
171
172
173
174
175
176
177
178
              },
  
              _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
179
180
181
182
183
184
185
186
187
188
189
190
191
192
              _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
193
194
195
196
197
198
199
200
201
202
203
204
              _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>