@extends('helper.include.view.modal', ['id' => 'modal-CAGSql', 'class_size' => 'modal-big'])

@section('modal-start')
    <form class="form-inline" ng-submit="vm.CAGSql.gravar()">
@overwrite

@section('modal-header-left')

<h4 class="modal-title">
	<span ng-if="!vm.CAGSql.ALTERANDO">{{ Lang::get('admin/_11511.titulo-exibir') }}</span>
	<span ng-if="vm.CAGSql.INCLUINDO">{{ Lang::get('admin/_11511.titulo-incluir') }}</span>
	<span ng-if="vm.CAGSql.ALTERANDO == true && vm.CAGSql.INCLUINDO == false">{{ Lang::get('admin/_11511.titulo-alterar') }}</span>
	
</h4>

@overwrite

@section('modal-header-right')

	<button ng-if="vm.CAGSql.ALTERANDO" type="submit" class="btn btn-success" data-hotkey="f1">
        <span class="glyphicon glyphicon-ok"></span> Gravar
    </button>
	
	<button ng-if="vm.CAGSql.ALTERANDO" ng-click="vm.CAGSql.cancelar()" type="button" class="btn btn-danger btn-cancelar" data-hotkey="esc">
        <span class="glyphicon glyphicon-ban-circle"></span> Cancelar
    </button>
	
	<button ng-disabled="{{ userMenu($menu)->ALTERAR }} == 0" ng-if="!vm.CAGSql.ALTERANDO" ng-click="vm.CAGSql.alterar()" type="button" class="btn btn-primary" data-hotkey="f9">
        <span class="glyphicon glyphicon-edit"></span> Alterar
    </button>   
	
	<button ng-disabled="{{ userMenu($menu)->EXCLUIR }} == 0"  ng-if="!vm.CAGSql.ALTERANDO" ng-click="vm.CAGSql.excluir()" type="button" class="btn btn-danger" data-hotkey="f12">
        <span class="glyphicon glyphicon-trash"></span> Excluir
    </button>
	
	<button ng-if="!vm.CAGSql.ALTERANDO" data-consulta-historico data-tabela="TBAGENDAMENTO_REPORT" data-tabela-id="@{{ vm.CAGSql.SELECTED.ID }}" type="button" class="btn gerar-historico" data-hotkey="alt+h">
        <span class="glyphicon glyphicon-time"></span> {{ Lang::get('master.historico') }}
    </button>
	
	<button ng-if="!vm.CAGSql.ALTERANDO" type="button" class="btn btn-default btn-fechar-modal btn-voltar" data-dismiss="modal" data-hotkey="esc">
      	<span class="glyphicon glyphicon-chevron-left"></span> Voltar
    </button>	

@overwrite

@section('modal-body')
<div style="height: calc(100vh - 230px);">

    <div class="row">
	
		<div class="form-group" ng-if="!vm.CAGSql.INCLUINDO">
            <label>ID:</label>
            <input type="text"
                class="form-control input-menor"
				ng-model="vm.CAGSql.SELECTED.DESC_ID"
                readonly="readonly">
        </div>
		
        <div class="form-group">
            <label>Assunto:</label>
			<input type="text" required
				class="form-control input-maior"
                ng-model="vm.CAGSql.SELECTED.DESCRICAO"
                ng-readonly="!vm.CAGSql.ALTERANDO"
                maxlength="300">
		</div>
		
		<div class="form-group">
            <label ttitle="Os emails dos destinatários separados por ','">E-mail:</label>
			<input type="email" required
				style="text-transform: lowercase; width: calc(100vw - 670px) !important; min-width: 300px;"
				class="form-control input-maior normal-case"
                ng-model="vm.CAGSql.SELECTED.EMAIL"
                ng-readonly="!vm.CAGSql.ALTERANDO"
                form-validate="true">
        </div>

		<br>

		<div class="form-group">
            <label>Link: <a tabindex="-1" ng-if="!vm.CAGSql.ALTERANDO" ng-attr-href="http://@{{vm.CAGSql.SELECTED.LINK}}" target="_blank" rel="noopener noreferrer">
					<span class="fa fa-external-link" title="Acessar site"></span></a></label>
			<input type="text" required
				style="text-transform: lowercase; width: 1215px !important;"
				class="form-control input-maior normal-case"
                ng-model="vm.CAGSql.SELECTED.LINK"
                ng-readonly="!vm.CAGSql.ALTERANDO"
                form-validate="true">
        </div>
		
		<br>
		<div class="form-group">
			<label>Tipo:</label>
			<div class="input-group">
				<select required style="width: 248px !important;" ng-disabled="!vm.CAGSql.ALTERANDO" name="repeatSelect" id="repeatSelect" ng-model="vm.CAGSql.SELECTED.TIPO">
					<option value="D">Diário</option>
					<option value="S">Semanal</option>
					<option value="M">Mensal</option>
					<option value="A">Anual</option>
				</select>
			</div>
		</div>

		<div class="form-group">
            <label>Hora Início:</label>
            <input 
                type="time"
                class="form-control input-medio" 
                required
                ng-model="vm.CAGSql.SELECTED.HORAINICIOE"
                ng-readonly="!vm.CAGSql.ALTERANDO"
                form-validate="true">
		</div>
		
		<div class="form-group">
            <label>Hora Fim:</label>
            <input 
                type="time"
                class="form-control input-medio" 
                required
                ng-model="vm.CAGSql.SELECTED.HORAFIME"
                ng-readonly="!vm.CAGSql.ALTERANDO"
                form-validate="true">
        </div>
		
		<div class="form-group">
            <label>Intervalo:</label>
            <input
                type="text"
				money-mask
				ui-number-mask="0"
				ui-hide-group-sep
                class="form-control input-menor text-right" 
                required
                ng-model="vm.CAGSql.SELECTED.INTERVALO"
                ng-readonly="!vm.CAGSql.ALTERANDO"
                maxlength="4">
		</div>

		<div class="form-group">
            <label ttitle="Utilizar apenas se o Tipo de Agendamento for Mensal">Dia do Mês:</label>
            <input 
                type="text"
				money-mask
				ui-number-mask="0"
				ui-hide-group-sep
                class="form-control input-menor text-right" 
                required
                ng-model="vm.CAGSql.SELECTED.DIA"
                ng-readonly="!vm.CAGSql.ALTERANDO"
                maxlength="4">
		</div>

		<div class="form-group">
            <label ttitle="Data e hora da última execução">Data/Hora Última Execução:</label>
			<!--<input type="text" name="maskdatetime" ng-if="vm.CAGSql.INCLUINDO" placeholder="DD/MM/AAAA,HH:MM">-->
			<input type="datetime-local" ng-atalho ng-disabled="!vm.CAGSql.INCLUINDO"
                class="form-control" required form-validate="true"
                ng-model="vm.CAGSql.SELECTED.DATAHORAULTIMOEXEC"
                ng-readonly="!vm.CAGSql.INCLUINDO">
			<!--<input
				name="datetime"
				type="datetime"
				placeholder="DD/MM/AAAA,HH:MM"
				onfocus="this.value=''" 
				ng-disabled="!vm.CAGSql.INCLUINDO"
                class="form-control input-medio" 
				required
                ng-model="vm.CAGSql.SELECTED.DATAHORAULTIMOEXEC"
                ng-readonly="!vm.CAGSql.INCLUINDO"
                form-validate="true">-->
		</div>
		<div class="form-group">
			<label ttitle="Se sim, este Agendamento irá repetir após ser executado">Tarefa Repetível:</label>
			<div class="input-group">
				<select ng-disabled="!vm.CAGSql.ALTERANDO" name="repeatSelect" id="repeatSelect" ng-model="vm.CAGSql.SELECTED.REPETIVEL">
					<option value="1">Sim</option>
					<option value="0">Não</option>
				</select>
			</div>
		</div>

		<div class="form-group">
			<label>Status:</label>
			<label class="switch">
				<input type="checkbox" ng-checked="vm.CAGSql.SELECTED.STATUS == '1'"
					ng-true-value="'1'"	ng-false-value="'0'" ng-disabled="!vm.CAGSql.ALTERANDO"
					ng-click="vm.CAGSql.SELECTED.STATUS = (vm.CAGSql.SELECTED.STATUS == '1') ? '0' : '1'">
				<div 
					class="slider"></div>
			</label>
		</div>
		<br>
		<fieldset style="margin-top: 20px !important;">
			<legend>Agendamento para os dias da semana</legend>
			<div class="form-group">
				<label ttitle="Se sim, este Agendamento será executado à cada Domingo">Domingo:</label>
				<div class="input-group">
					<select ng-disabled="!vm.CAGSql.ALTERANDO" name="repeatSelect" id="repeatSelect" ng-model="vm.CAGSql.SELECTED.DOM">
						<option value="1">Sim</option>
						<option value="0">Não</option>
					</select>
				</div>
			</div>
			<div class="form-group">
				<label ttitle="Se sim, este Agendamento será executado à cada Segunda-Feira">Segunda:</label>
				<div class="input-group">
					<select ng-disabled="!vm.CAGSql.ALTERANDO" name="repeatSelect" id="repeatSelect" ng-model="vm.CAGSql.SELECTED.SEG">
						<option value="1">Sim</option>
						<option value="0">Não</option>
					</select>
				</div>
			</div>

			<div class="form-group">
				<label ttitle="Se sim, este Agendamento será executado à cada Terça-Feira">Terça:</label>
				<div class="input-group">
					<select ng-disabled="!vm.CAGSql.ALTERANDO" name="repeatSelect" id="repeatSelect" ng-model="vm.CAGSql.SELECTED.TER">
						<option value="1">Sim</option>
						<option value="0">Não</option>
					</select>
				</div>
			</div>

			<div class="form-group">
				<label ttitle="Se sim, este Agendamento será executado à cada Quarta-Feira">Quarta:</label>
				<div class="input-group">
					<select ng-disabled="!vm.CAGSql.ALTERANDO" name="repeatSelect" id="repeatSelect" ng-model="vm.CAGSql.SELECTED.QUA">
						<option value="1">Sim</option>
						<option value="0">Não</option>
					</select>
				</div>
			</div>

			<div class="form-group">
				<label ttitle="Se sim, este Agendamento será executado à cada Quinta-Feira">Quinta:</label>
				<div class="input-group">
					<select ng-disabled="!vm.CAGSql.ALTERANDO" name="repeatSelect" id="repeatSelect" ng-model="vm.CAGSql.SELECTED.QUI">
						<option value="1">Sim</option>
						<option value="0">Não</option>
					</select>
				</div>
			</div>
			
			<div class="form-group">
				<label ttitle="Se sim, este Agendamento será executado à cada Sexta-Feira">Sexta:</label>
				<div class="input-group">
					<select ng-disabled="!vm.CAGSql.ALTERANDO" name="repeatSelect" id="repeatSelect" ng-model="vm.CAGSql.SELECTED.SEX">
						<option value="1">Sim</option>
						<option value="0">Não</option>
					</select>
				</div>
			</div>

			<div class="form-group">
				<label ttitle="Se sim, este Agendamento será executado à cada Sábado">Sábado:</label>
				<div class="input-group">
					<select ng-disabled="!vm.CAGSql.ALTERANDO" name="repeatSelect" id="repeatSelect" ng-model="vm.CAGSql.SELECTED.SAB">
						<option value="1">Sim</option>
						<option value="0">Não</option>
					</select>
				</div>
			</div>

			
		</fieldset>

		<div class="form-group" style="width: 100%; height: 100%;">
            <label>SQL:</label>
			<textarea
				required
				rows="15"
                class="form-control input-maior" 
				style=" resize: none; margin: 0px; width: 100% !important;"
                ng-model="vm.CAGSql.SELECTED.SQL"
                ng-readonly="!vm.CAGSql.ALTERANDO"
				ng-class="{'memo-editando' : vm.CAGSql.ALTERANDO, 'memo-show' : !vm.CAGSql.ALTERANDO}"
				form-validate="true">
			</textarea>
        </div>

		<!-- <div style="display: -webkit-inline-box;" class="consulta-usuario"></div> -->
		
    </div>
	
	<!--<div ng-if="!vm.CAGSql.ALTERANDO" style="margin-top: 10px;">   
		<ul class="list-inline">    
			<li>
				<button 
					type="button" 
					class="btn btn-primary btn-incluir" 
					data-hotkey="f6"
					ng-disabled="!{{ userMenu($menu)->INCLUIR }}" 
					ng-click="vm.CAGSqlItens.incluir()">
					<span class="glyphicon glyphicon-plus"></span> Incluir
				</button>
			</li>                                         
		</ul>  
		
		<div class="form-group" style="margin-bottom: 4px; width: 100% !important;">
		<input 
			type="text"
			style="width: 100% !important;"
			placeholder="Filtragem rápida..."
			class="form-control input-maior" 
			required
			ng-model="vm.CAGSqlItens.FILTRO_DADOS">
	</div>
	
		<div class="table-ec table-scroll" style="height: calc(100vh - 400px); min-height: 200px;">
		
			<table class="table table-striped table-bordered table-condensed table-no-break table-middle table-low">
				<thead>
					<tr gc-order-by="vm.CAGSqlItens.ORDER_BY">
						<th field="STATUS" style="width: 23px; min-width: 23px;" ttitle="Status<br/>Verde: Ativo | Vermelho: Inativo"></th>                    
						<th field="ID">ID</th>
						<th field="DESCRICAO">Descrição</th>
					</tr>
				</thead>
				<tbody>
					<tr 
						ng-repeat="item in vm.CAGSqlItens.DADOS_RENDER = ( vm.CAGSqlItens.DADOS | orderBy : vm.CAGSqlItens.ORDER_BY | find: {model : vm.CAGSqlItens.FILTRO_DADOS ,fields : 'all'})"
						ng-Click="vm.CAGSqlItens.visualizar()"
						ng-focus="vm.CAGSqlItens.SELECTED = item"
						ng-class="{ 'selected' : vm.CAGSqlItens.SELECTED == item }"
						tabindex="0"
						>
						<td class="t-status status-@{{ item.STATUS }}">
						</td>
						<td>
							<span>
								@{{ item.ID || 0 | lpad: [4,0] }}
							</span>
						</td>
						<td>
							<span>
								@{{ item.DESCRICAO }}
							</span>
						</td>
					</tr>
				</tbody>
			</table>
		</div>
	</div>-->
	<br><br>
	<!--
	<div class="alert alert-warning" ng-if="vm.CAGSql.INCLUINDO" role="alert">
		No campo "Data/Hora Última Execução" é necessário apenas digitar números,
		a formatação será aplicada automaticamente.
	  </div>
	  -->
</div>
</form>

@overwrite