|
1
|
<form role="form">
|
|
2
|
<div class="form-group">
|
|
3
|
<label for="sqlInput" class="control-label">SQL Query</label>
|
|
4
|
<div class="dnetFormField" ui-codemirror ui-codemirror-opts="sqlEditorOptions" ng-model="query"></div>
|
|
5
|
</div>
|
|
6
|
<button class="btn btn-default" ng-click="search()">Search</button>
|
|
7
|
<button class="btn btn-primary pull-right" data-toggle="modal" data-target="#sqlQueryHistoryModal">History</button>
|
|
8
|
</form>
|
|
9
|
<br />
|
|
10
|
|
|
11
|
<div class="panel panel-default" ng-show="error">
|
|
12
|
<div class="panel-heading">
|
|
13
|
<a class="accordion-toggle" data-toggle="collapse" data-target="#collapse_error"><b>Error:</b> <i>{{error.message}}</i></a>
|
|
14
|
</div>
|
|
15
|
<div id="collapse_error" class="panel-collapse collapse in">
|
|
16
|
<div class="panel-body">
|
|
17
|
<pre>{{error.stacktrace}}</pre>
|
|
18
|
</div>
|
|
19
|
</div>
|
|
20
|
</div>
|
|
21
|
|
|
22
|
|
|
23
|
<p ng-hide="error"><b>Number of results:</b> {{results.length}}<br /></p>
|
|
24
|
|
|
25
|
<div class="panel panel-default" ng-repeat="r in results track by $index">
|
|
26
|
<div class="panel-heading">
|
|
27
|
<a class="accordion-toggle" data-toggle="collapse" data-target="#collapse_{{$index}}"><b> Result: </b><i>{{$index + 1}}</i></a>
|
|
28
|
</div>
|
|
29
|
<div id="collapse_{{$index}}" class="panel-collapse collapse in">
|
|
30
|
<div ui-codemirror ui-codemirror-opts="sqlResultOptions" ng-model="r"></div>
|
|
31
|
</div>
|
|
32
|
</div>
|
|
33
|
|
|
34
|
|
|
35
|
<div id="sqlQueryHistoryModal" class="modal fade" tabindex="-1" role="dialog">
|
|
36
|
<div class="modal-dialog modal-lg">
|
|
37
|
<div class="modal-content">
|
|
38
|
<div class="modal-header">
|
|
39
|
<button type="button" class="close" data-dismiss="modal">×</button>
|
|
40
|
<h4 class="modal-title">History</h4>
|
|
41
|
</div>
|
|
42
|
<div class="modal-body" style="height: 400px; overflow-y: scroll">
|
|
43
|
<p class="text-center" ng-show="history.length == 0">
|
|
44
|
<b>History is empty</b>
|
|
45
|
</p>
|
|
46
|
<div ng-repeat="e in history | reverse">
|
|
47
|
<span><a href="javascript:void(0)" data-dismiss="modal" ng-click="updateSqlQuery(e.query)">{{e.date | date:"yyyy-MM-dd HH:mm:ss"}}</a></span>
|
|
48
|
<pre>{{e.query}}</pre>
|
|
49
|
</div>
|
|
50
|
</div>
|
|
51
|
<div class="modal-footer">
|
|
52
|
<button class="btn btn-primary" data-dismiss="modal">Clear history</button>
|
|
53
|
<button class="btn btn-default" data-dismiss="modal">Close</button>
|
|
54
|
</div>
|
|
55
|
</div>
|
|
56
|
</div>
|
|
57
|
</div>
|