Project

General

Profile

« Previous | Next » 

Revision 34749

Added by Michele Artini over 9 years ago

sql query

View differences:

isQuery.html
1 1 
<form role="form">
2 2 
	<div class="form-group">
3 
		<label for="xqueryInput" class="control-label">XQuery</label>
4 
		<textarea class="form-control" id="xqueryInput" ng-model="query" rows="10"></textarea>
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 5 
	</div>
6 
	<button class="btn btn-default" ng-click="searchXQuery()">Search</button>
7 
	<button class="btn btn-primary pull-right" data-toggle="modal" data-target="#xqueryHistoryModal">History</button>
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 8 
</form>
9 9 
<br />
10 10 

  		




  ......




  27
  27
  
    
		<a class="accordion-toggle" data-toggle="collapse" data-target="#collapse_{{$index}}"><b> Result: </b><i>{{$index + 1}}</i></a>


  		




  28
  28
  
    
	</div>


  		




  29
  29
  
    
	<div id="collapse_{{$index}}" class="panel-collapse collapse in">


  		




  30
  
  
    
		<div class="panel-body">


  		




  31
  
  
    
			<pre>{{r}}</pre>


  		




  32
  
  
    
		</div>


  		




  
  30
  
    
		<div ui-codemirror ui-codemirror-opts="resultOptions" ng-model="r"></div>


  		




  33
  31
  
    
	</div>


  		




  34
  32
  
    
</div>


  		




  35
  33
  
    

  		




  36
  34
  
    

  		




  37
  
  
    
<div id="xqueryHistoryModal" class="modal fade" tabindex="-1" role="dialog">


  		




  
  35
  
    
<div id="sqlQueryHistoryModal" class="modal fade" tabindex="-1" role="dialog">


  		




  38
  36
  
    
	<div class="modal-dialog modal-lg">


  		




  39
  37
  
    
		<div class="modal-content">


  		




  40
  38
  
    
			<div class="modal-header">


  		




  ......




  46
  44
  
    
					<b>History is empty</b>


  		




  47
  45
  
    
				</p>


  		




  48
  46
  
    
				<div ng-repeat="e in history | reverse">


  		




  49
  
  
    
					<span><a href="javascript:void(0)" data-dismiss="modal" ng-click="updateXQuery(e.query)">{{e.date | date:"yyyy-MM-dd HH:mm:ss"}}</a></span>


  		




  
  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>


  		




  50
  48
  
    
					<pre>{{e.query}}</pre>


  		




  51
  49
  
    
				</div>


  		




  52
  50
  
    
			</div>


  		












Also available in:  Unified diff