@extends('master')

@section('titulo')
    {{ Lang::get('admin/_11700.titulo') }}
@endsection

@section('estilo')
	<link rel="stylesheet" href="{{ elixir('assets/css/11700.css') }}" />
	<link rel="stylesheet" href="/js/codemirror/codemirror.css" />
	<link rel="stylesheet" href="/js/codemirror/show-hint.css" />
	<link rel="stylesheet" href="/js/codemirror/temas/abcdef.css" />
	<link rel="stylesheet" href="/js/codemirror/temas/darcula.css" />
	<link rel="stylesheet" href="/js/codemirror/temas/mdn-like.css" />
	<link rel="stylesheet" href="/js/codemirror/temas/night.css" />
	<link rel="stylesheet" href="/js/codemirror/temas/xq-dark.css" />
	<link rel="stylesheet" href="/js/codemirror/temas/xq-light.css" />
@endsection

@section('conteudo')
<div ng-controller="Ctrl as vm" ng-cloak>

	<ul class="list-inline acoes">    
		<li>
            <button type="button" class="btn btn-primary" 
				ng-click="vm.Admin.newQuery()"
				ng-disabled ="!(vm.Admin.SELECTED.ID > 0)">
                <span class="glyphicon glyphicon-asterisk"></span> Novo SQL
            </button>
		</li>
		<!--
		<li>
			<button type="button" class="btn btn-default" 
				id="filtrar-toggle" data-toggle="collapse" 
				data-target="#filtro_main" aria-expanded="true" 
				aria-controls="filtro_main"
				ng-click="vm.Menus.tabela_height()">
				Filtro
				<span class="glyphicon glyphicon-cog"></span>
			</button>
		</li>          
		-->                                    
	</ul>  

	<div style="display: inline-flex;">
		<div class="bancos">

			<div class="form-group" style="margin-bottom: 4px;">
				<input type="text" style="width: 100% !important;" placeholder="Filtragem rápida..." id="imput_filtro_db" class="form-control input-maior" required="" autofocus="" ng-model="vm.FILTRO_DADOS">
			</div>

			<div class="folder" ng-repeat="db in vm.Admin.DB track by $index">
				
				<div class="folder_current"  ng-dblclick="vm.Admin.Open(db)" ng-click="vm.Admin.setDB(db)" >
					<span class="glyphicon glyphicon-plus"  ng-if="db.ABERTO == false"></span>
					<span class="glyphicon glyphicon-minus" ng-if="db.ABERTO == true"></span>
					@{{db.DESCRICAO}}

					<div class="status_db_selected" ng-if="vm.Admin.SELECTED.ID == db.ID">*</div>
				</div>

				<div ng-if="db.ABERTO == true" class="db_itens">
					<div ng-dblclick="vm.Admin.OpenTab(db)" style="font-weight: bold;">
						<span class="glyphicon glyphicon-plus"  ng-if="db.ABERTO_TABELA == false"></span>
						<span class="glyphicon glyphicon-minus" ng-if="db.ABERTO_TABELA == true"></span>
						Tabelas (@{{db.TABELA_RENDER.length}})
					</div>

					<div class="lista_tabelas" ng-if="db.ABERTO == true && db.ABERTO_TABELA == true" ng-repeat="tabela in db.TABELA_RENDER = (db.TABELA | find: {model : vm.FILTRO_DADOS ,fields : 'all'})">
						<div class="dropdown">
							<div class="tabela dropdown-toggle" data-toggle="dropdown" ><span style="margin-right: 5px; color: green;" class="glyphicon glyphicon-list-alt"></span>@{{tabela.NOME}}</div>
							<ul class="dropdown-menu">
								<li><button style="width: 100%; background-color: white;" class="btn" ng-click="vm.Admin.OpenFirst(tabela)">SELECT FIRST 100</button></li>
								<li><button style="width: 100%; background-color: white;" class="btn" ng-click="vm.Admin.OpenEditor(tabela)">ABRIR EDITOR</button></li>
							</ul>
						
						</div>
					</div>
				</div>

				<div ng-if="db.ABERTO == true" class="db_itens">
					<div ng-dblclick="vm.Admin.OpenVie(db)" style="font-weight: bold;">
						<span class="glyphicon glyphicon-plus"  ng-if="db.ABERTO_VIEWS == false"></span>
						<span class="glyphicon glyphicon-minus" ng-if="db.ABERTO_VIEWS == true"></span>
						Views (@{{db.VIEWS_RENDER.length}})
					</div>

					<div class="lista_tabelas" ng-if="db.ABERTO == true && db.ABERTO_VIEWS == true" ng-repeat="tabela in db.VIEWS_RENDER = (db.VIEWS | find: {model : vm.FILTRO_DADOS ,fields : 'all'})">
						<div class="tabela"><span style="margin-right: 5px; color: green;" class="glyphicon glyphicon-list-alt"></span>@{{tabela.NOME}}</div>
					</div>
				</div>

				<div ng-if="db.ABERTO == true" class="db_itens">
					<div ng-dblclick="vm.Admin.OpenPro(db)" style="font-weight: bold;">
						<span class="glyphicon glyphicon-plus"  ng-if="db.ABERTO_PROCEDURES == false"></span>
						<span class="glyphicon glyphicon-minus" ng-if="db.ABERTO_PROCEDURES == true"></span>
						Procedures (@{{db.PROCEDURES_RENDER.length}})
					</div>

					<div class="lista_tabelas" ng-if="db.ABERTO == true && db.ABERTO_PROCEDURES == true" ng-repeat="tabela in db.PROCEDURES_RENDER = (db.PROCEDURES | find: {model : vm.FILTRO_DADOS ,fields : 'all'})">
						<div class="tabela"><span style="margin-right: 5px; color: green;" class="glyphicon glyphicon-list-alt"></span>@{{tabela.NOME}}</div>
					</div>
				</div>

				<div ng-if="db.ABERTO == true" class="db_itens">
					<div ng-dblclick="vm.Admin.OpenFun(db)" style="font-weight: bold;">
						<span class="glyphicon glyphicon-plus"  ng-if="db.ABERTO_FUNCTIONS == false"></span>
						<span class="glyphicon glyphicon-minus" ng-if="db.ABERTO_FUNCTIONS == true"></span>
						Functions (@{{db.FUNCTIONS_RENDER.length}})
					</div>

					<div class="lista_tabelas" ng-if="db.ABERTO == true && db.ABERTO_FUNCTIONS == true" ng-repeat="tabela in db.FUNCTIONS_RENDER = (db.FUNCTIONS | find: {model : vm.FILTRO_DADOS ,fields : 'all'})">
						<div class="tabela"><span style="margin-right: 5px; color: green;" class="glyphicon glyphicon-list-alt"></span>@{{tabela.NOME}}</div>
					</div>
				</div>

				<div ng-if="db.ABERTO == true" class="db_itens">
					<div ng-dblclick="vm.Admin.OpenTri(db)" style="font-weight: bold;">
						<span class="glyphicon glyphicon-plus"  ng-if="db.ABERTO_TRIGER == false"></span>
						<span class="glyphicon glyphicon-minus" ng-if="db.ABERTO_TRIGER == true"></span>
						Triger (@{{db.TRIGER_RENDER.length}})
					</div>

					<div class="lista_tabelas" ng-if="db.ABERTO == true && db.ABERTO_TRIGER == true" ng-repeat="tabela in db.TRIGER_RENDER = (db.TRIGER | find: {model : vm.FILTRO_DADOS ,fields : 'all'})">
						<div class="tabela"><span style="margin-right: 5px; color: green;" class="glyphicon glyphicon-list-alt"></span>@{{tabela.NOME}}</div>
					</div>
				</div>

				<div ng-if="db.ABERTO == true" class="db_itens">
					<div ng-dblclick="vm.Admin.OpenGen(db)" style="font-weight: bold;">
						<span class="glyphicon glyphicon-plus"  ng-if="db.ABERTO_GENERATOR == false"></span>
						<span class="glyphicon glyphicon-minus" ng-if="db.ABERTO_GENERATOR == true"></span>
						Genereitor (@{{db.GENERATOR_RENDER.length}})
					</div>

					<div class="lista_tabelas" ng-if="db.ABERTO == true && db.ABERTO_GENERATOR == true" ng-repeat="tabela in db.GENERATOR_RENDER = (db.GENERATOR | find: {model : vm.FILTRO_DADOS ,fields : 'all'})">
						<div class="tabela"><span style="margin-right: 5px; color: green;" class="glyphicon glyphicon-list-alt"></span>@{{tabela.NOME}}</div>
					</div>
				</div>

			</div>

		</div>

		<div style="width: calc(100vw - 320px); padding: 10px;"  ng-show="vm.Admin.TABS.length > 0">

			<ul style="height: 42px;" id="tab" class="nav nav-tabs" role="tablist"> 
				<li ng-if="tab.STATUS == 1" role="presentation" class="tab-detalhamento" ng-repeat="tab in vm.Admin.TABS">
					<a href="#tab@{{tab.ID}}-container" id="tab@{{tab.ID}}-tab" role="tab" data-toggle="tab" aria-controls="tab@{{tab.ID}}-container" aria-expanded="true">
						@{{tab.NOME}}
					</a>
				</li>
			</ul>

			<div id="tab-content" class="tab-content" style="height: calc(100% - 45px);">
				
				<div role="tabpanel" ng-show="tab.STATUS == 1" ng-repeat="tab in vm.Admin.TABS" class="tab-pane" id="tab@{{tab.ID}}-container" name="" aria-labelledby="tab@{{tab.ID}}-tab" style="height: 100%; overflow:auto;">
					<div>

						<ul class="list-inline">    
							<li>
								<button type="button" class="btn btn-primary" ng-click="vm.Admin.rumQuery(tab, 1)">
									<span class="glyphicon glyphicon-play"></span> Exec.
								</button>
							</li> 
							
							<li>
								<button type="button" class="btn btn-primary" ng-click="vm.Admin.rumQuery(tab, 2)">
									<span class="glyphicon glyphicon-forward"></span> Exec. Commit
								</button>
							</li>

							<li ng-show="tab.TIPO == 'SQL' || false">
								<select 
									style="width: 150px;"
									name="repeatSelect1"
									id="repeatSelect1"
									ng-model="vm.Admin.TEMA"
									ng-change="vm.Admin.setTeme(vm.Admin.TEMA, tab)"
									required>
									<option ng-repeat="tema in vm.Admin.listTemas" ng-value="tema">@{{tema}}</option>
								</select>
							</li>

							<li>
								<select 
									style="width: 150px;"
									name="repeatSelect3"
									id="repeatSelect3"
									ng-model="vm.Admin.TESTE_TYPE"
									required>
									<option ng-value="1">Com Tipos</option>
									<option ng-value="0">Sem Tipos</option>
								</select>
							</li>

							<li>
								<button type="button" class="btn btn-danger" ng-click="vm.Admin.CloseTab(tab);">
									<span class="glyphicon glyphicon-remove"></span> Fechar
								</button>
							</li>

						</ul> 

						<textarea ng-show="tab.TIPO == 'SQL'" class="normal-case" id="sql_editor_@{{tab.ID}}" ></textarea>

						<div style="margin-top: 20px;" class="tabela_reg@{{tab.ID}}" id="tabela_reg@{{tab.ID}}"></div>
						
					</div>
				</div>

			</div>
		</div>

	</div>
	
    @include($menu.'.modal.Admin')
	@include($menu.'.modal.AdminItens')
</div>
@endsection

@section('script')
	<script src="/js/codemirror/codemirror.js"></script>
	<script src="/js/codemirror/matchbrackets.js"></script>
	<script src="/js/codemirror/show-hint.js"></script>
	<script src="/js/codemirror/sql-hint.js"></script>
	<script src="/js/codemirror/sql.js"></script>
    <script src="{{ elixir('assets/js/_11700.js') }}"></script>
@append