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
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
<link rel="import" href="../../bower_components/polymer/polymer.html" />
<link rel="import" href="../../bower_components/paper-dropdown-menu/paper-dropdown-menu.html">
<link rel="import" href="../../bower_components/paper-menu/paper-menu.html">
<link rel="import" href="../../bower_components/paper-item/paper-item.html">
<link rel="import" href="../../bower_components/paper-icon-button/paper-icon-button.html">
<link rel="import" href="../../bower_components/iron-icons/iron-icons.html">
<link rel="import" href="../../bower_components/iron-icon/iron-icon.html">
<dom-module id="filters-controllet">
<template>
<style is="custom-style">
:host {
--paper-dropdown-menu-icon: {
color: #2196F3;
};
}
#filters_container {
height: 100%;
width: 100%;
font-family: 'Roboto', 'Helvetica Neue', Helvetica, Arial, sans-serif;
font-size: 16px;
}
#filters_panel {
display: none;
position: relative;
height: calc(100% - 48px);
}
.filters_header {
height: 32px;
padding-top: 16px;
text-align: center;
font-weight: 700;
color: #00BCD4;
cursor: pointer;
}
paper-dropdown-menu {
height: 48px;
width: 248px;;
--paper-input-container-focus-color: #2196F3;
}
paper-item.iron-selected {
background-color: #2196F3;
color: #FFFFFF;
}
paper-icon-button {
color: #2196F3;
--paper-icon-button-ink-color: #2196F3;
margin: 0px;
}
paper-icon-button.cancel {
color: #F44336;
--paper-icon-button-ink-color: #F44336;
margin-bottom: -6px;
margin-left: -8px;
}
paper-icon-button.add {
margin-bottom: -6px;
margin-left: -8px;
}
paper-input {
display: inline-block;
height: 48px;
width: 248px;
--paper-input-container-focus-color: #2196F3;
}
td {
height: 48px;
padding: 0px;
padding-bottom: 4px;
margin: 0px;
width: 248px;
border-bottom: 1px solid #2196F3;
vertical-align: bottom;
}
th {
height: 48px;
padding: 0px;
margin: 0px;
vertical-align: bottom;
text-align: left ;
}
.filters_cell_button {
width: 24px;
border-bottom: none;
}
</style>
<div id="filters_container">
|
e94f9513
Renato De Donato
filter ln
|
109
|
<div id="filters_header" class="filters_header" on-click="_showFiltersPanel"><span id="filters"><span id="addFilters"></span></span></div>
|
0af843be
Renato De Donato
filters + alasql
|
110
111
112
113
114
115
116
|
<div id="filters_panel">
<table cellspacing="12px">
<tr>
<th>
<paper-dropdown-menu id="filter_field" label="Field">
|
39d5ab70
Renato De Donato
update filters
|
117
|
<paper-menu id="filter_field_menu" class="dropdown-content">
|
0af843be
Renato De Donato
filters + alasql
|
118
|
<template is="dom-repeat" items={{fields}}>
|
e94f9513
Renato De Donato
filter ln
|
119
120
|
<paper-item id={{index}}>{{_fieldName(item)}}</paper-item>
<!--on-tap=""-->
|
0af843be
Renato De Donato
filters + alasql
|
121
122
123
124
125
126
|
</template>
</paper-menu>
</paper-dropdown-menu>
</th>
<th>
<paper-dropdown-menu id="filter_operation" label="Operation">
|
39d5ab70
Renato De Donato
update filters
|
127
|
<paper-menu id="filter_operation_menu" class="dropdown-content">
|
0af843be
Renato De Donato
filters + alasql
|
128
|
<template is="dom-repeat" items={{operations}}>
|
e94f9513
Renato De Donato
filter ln
|
129
|
<paper-item id={{index}}>{{_getOperationlName(item)}}</paper-item>
|
0af843be
Renato De Donato
filters + alasql
|
130
131
132
133
134
|
</template>
</paper-menu>
</paper-dropdown-menu>
</th>
<th>
|
7464051f
Renato De Donato
not contains
|
135
136
|
<paper-input id="filter_value" label="Value" class="base_input" maxlength="32" auto-validate pattern="^[.:,;+-_ a-zA-Z0-9]*" error-message="Invalid value!"></paper-input>
<!--"^[_a-zA-Z0-9]*"-->
|
0af843be
Renato De Donato
filters + alasql
|
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
|
</th>
<th class="filters_cell_button">
<paper-icon-button on-click="_addFilter" icon="add-circle" class="add"></paper-icon-button>
</th>
</tr>
<template is="dom-repeat" items={{filters}}>
<tr>
<td>{{item.field}}</td>
<td>{{item.operation}}</td>
<td class="filters_cell_value">{{item.value}}</td>
<td class="filters_cell_button"><paper-icon-button on-click="_deleteFilter" icon="cancel" class="cancel"></paper-icon-button></td>
</tr>
</template>
</table>
</div>
</div>
</template>
<script>
Polymer({
is : 'filters-controllet',
properties : {
fields : {
type : Array,
value : []
},
operations : {
type : Array,
|
7464051f
Renato De Donato
not contains
|
173
|
value : ["=", "!=", ">", ">=", "<", "<=", "contains", "not contains", "start", "ends"]
|
0af843be
Renato De Donato
filters + alasql
|
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
|
},
filters : {
type : Array,
value : []
},
show : {
type : Boolean,
value : false
}
},
ready : function() {
$(this.$.filters_panel).perfectScrollbar();
},
|
e94f9513
Renato De Donato
filter ln
|
192
193
194
195
|
attached : function() {
this._translate();
},
|
0af843be
Renato De Donato
filters + alasql
|
196
197
198
199
200
201
202
203
|
setFields : function(fields) {
this.fields = this._copy(fields);
},
getFilters : function() {
return this.filters;
},
|
e94f9513
Renato De Donato
filter ln
|
204
|
_translate : function() {
|
79627d7e
Renato De Donato
controllet ln
|
205
|
this.$.addFilters.innerHTML = ln["expertAddFilters_" + ln["localization"]];
|
e94f9513
Renato De Donato
filter ln
|
206
207
208
209
210
|
this.$.filter_field.setAttribute("label", ln["filterField_" + ln["localization"]]);
this.$.filter_operation.setAttribute("label", ln["filterOperation_" + ln["localization"]]);
this.$.filter_value.setAttribute("label", ln["filterValue_" + ln["localization"]]);
},
|
0af843be
Renato De Donato
filters + alasql
|
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
|
_fieldName : function(field) {
return field.substring(field.lastIndexOf(",")+1, field.length);
},
_showFiltersPanel : function() {
if(!this.show) {
this.$.filters_header.style.color = "#000000";
this.$.filters_header.style.background = "#B6B6B6";
this.$.filters_panel.style.display = "block";
}
else {
this.$.filters_header.style.color = "#00BCD4";
this.$.filters_header.style.background = "#FFFFFF";
this.$.filters_panel.style.display = "none";
}
this.show = !this.show;
},
_addFilter : function() {
|
e94f9513
Renato De Donato
filter ln
|
231
232
|
if (this.$.filter_field.selectedItem && this.$.filter_operation_menu.selectedItem && this.$.filter_value.value != "" && !this.$.filter_value.invalid) {
var field = this.$.filter_field.value;
|
93ba7167
Renato De Donato
filters bug fix + ln
|
233
234
235
|
var id = this.$.filter_operation.selectedItem.id;
var operation = this.operations[id];
// var operation = this.$.filter_operation.value;
|
e94f9513
Renato De Donato
filter ln
|
236
|
var value = this.$.filter_value.value;
|
0af843be
Renato De Donato
filters + alasql
|
237
|
|
e94f9513
Renato De Donato
filter ln
|
238
239
240
|
var filters = this.filters;
filters.push({"field": field, "operation": operation, "value": value});
this.filters = this._copy(filters);
|
98d9d8a5
Renato De Donato
filters+groupby
|
241
|
|
e94f9513
Renato De Donato
filter ln
|
242
243
244
|
this.$.filter_field_menu.select(-1);
this.$.filter_operation_menu.select(-1);
this.$.filter_value.value = "";
|
39d5ab70
Renato De Donato
update filters
|
245
|
|
e94f9513
Renato De Donato
filter ln
|
246
247
|
this.fire('filters-controllet_filters', {filters: this.filters});
}
|
0af843be
Renato De Donato
filters + alasql
|
248
249
250
251
252
253
254
255
|
},
_deleteFilter : function(e) {
var index = e.model.index;
var filters = this.filters;
filters.splice(index, 1);
this.filters = this._copy(filters);
|
98d9d8a5
Renato De Donato
filters+groupby
|
256
257
|
this.fire('filters-controllet_filters', {filters: this.filters});
|
0af843be
Renato De Donato
filters + alasql
|
258
259
|
},
|
e94f9513
Renato De Donato
filter ln
|
260
|
_getOperationlName: function(operation) {
|
7464051f
Renato De Donato
not contains
|
261
262
|
if(operation.indexOf("not") > -1)
return ln["notContains_" + ln["localization"]];
|
e94f9513
Renato De Donato
filter ln
|
263
264
265
266
267
268
269
270
271
|
if(operation.indexOf("contains") > -1)
return ln["contains_" + ln["localization"]];
if(operation.indexOf("start") > -1)
return ln["start_" + ln["localization"]];
if(operation.indexOf("ends") > -1)
return ln["ends_" + ln["localization"]];
return operation;
},
|
0af843be
Renato De Donato
filters + alasql
|
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
|
_copy : function(o) {
var out, v, key;
out = Array.isArray(o) ? [] : {};
for (key in o) {
v = o[key];
out[key] = (typeof v === "object") ? this._copy(v) : v;
}
return out;
}
});
</script>
</dom-module>
|