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
|
{#
/*
* Spring Signage Ltd - http://www.springsignage.com
* Copyright (C) 2015 Spring Signage Ltd
* (${FILE_NAME})
*/
#}
{% extends "authed.twig" %}
{% import "inline.twig" as inline %}
{% block actionMenu %}
<ul class="nav nav-pills pull-right">
<li class="btn btn-success btn-xs"><a class="XiboFormButton btns" title="{% trans "Add Column" %}" href="{{ urlFor("dataSet.column.add.form", {id: dataSet.dataSetId}) }}"><i class="fa fa-plus-circle" aria-hidden="true"></i> {% trans "Add Column" %}</a></li>
<li class="btn btn-info btn-xs"><a class="btns" title="{% trans "View Data" %}" href="{{ urlFor("dataSet.view.data", {id: dataSet.dataSetId}) }}"><i class="fa fa-eye" aria-hidden="true"></i> {% trans "View Data" %}</a></li>
</ul>
{% endblock %}
{% block pageContent %}
{% set dataSetName = dataSet.dataSet %}
{% set widgetTitle %}{% trans %}Columns for {{ dataSetName }}{% endtrans %}{% endset %}
<div class="widget">
<div class="widget-title">{{ widgetTitle }}</div>
<div class="widget-body">
<div class="XiboGrid" id="{{ random() }}">
<div class="XiboFilter">
<div class="FilterDiv" id="Filter">
<form class="form-inline">
</form>
</div>
</div>
<div class="XiboData">
<table id="datasets" class="table table-striped">
<thead>
<tr>
<th>{% trans "Heading" %}</th>
<th>{% trans "DataType" %}</th>
<th>{% trans "Column Type" %}</th>
<th>{% trans "List Content" %}</th>
<th>{% trans "Order" %}</th>
<th></th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
{% endblock %}
{% block javaScript %}
<script type="text/javascript">
var table = $("#datasets").DataTable({ "language": dataTablesLanguage,
serverSide: true, stateSave: true,
stateLoadCallback: function (settings, callback) {
var data;
$.ajax({
type: "GET",
async: false,
url: "{{ urlFor("user.pref") }}?preference=dataSetColumnGrid",
dataType: 'json',
success: function (json) {
if (json.success)
data = JSON.parse(json.data.value);
}
});
return data;
},
stateSaveCallback: function (settings, data) {
$.ajax({
type: "POST",
url: "{{ urlFor("user.pref") }}",
data: {
preference: [{
option: "dataSetColumnGrid",
value: JSON.stringify(data)
}]
}
});
},
filter: false,
searchDelay: 3000,
"order": [[ 0, "asc"]],
ajax: {
"url": "{{ urlFor("dataSet.column.search", {id: dataSet.dataSetId}) }}",
"data": function(d) {
$.extend(d, $("#datasets").closest(".XiboGrid").find(".FilterDiv form").serializeObject());
}
},
"columns": [
{ "data": "heading", "render": dataTableSpacingPreformatted },
{ "data": "dataType" },
{ "data": "dataSetColumnType" },
{ "data": "listContent" },
{ "data": "columnOrder" },
{
"orderable": false,
"data": dataTableButtonsColumn
}
]
});
table.on('draw', dataTableDraw);
table.on('processing.dt', dataTableProcessing);
</script>
{% endblock %}
|