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

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

@section('modal-header-left')

<h4 class="modal-title">
	<!-- @{{vm.Relatorio.SELECTED.DESCRICAO}} -->
	<span ng-if="!vm.RelatorioSQL.ALTERANDO">{{ Lang::get('admin/_11081.titulo3-exibir') }}</span>
	<span ng-if="vm.RelatorioSQL.INCLUINDO">{{ Lang::get('admin/_11081.titulo3-incluir') }}</span>
	<span ng-if="vm.RelatorioSQL.ALTERANDO == true && vm.RelatorioSQL.INCLUINDO == false">{{ Lang::get('admin/_11081.titulo3-alterar') }}</span>
</h4>

@overwrite

@section('modal-header-right')

	<button ng-if="vm.RelatorioSQL.ALTERANDO && vm.RelatorioSQL.TIPO_ADD < 3" type="submit" class="btn btn-success" data-hotkey="f1">
        <span class="glyphicon glyphicon-ok"></span> Gravar
    </button>
	
	<button ng-if="vm.RelatorioSQL.ALTERANDO && vm.RelatorioSQL.TIPO_ADD == 3" type="submit" class="btn btn-success" data-hotkey="f1">
        <span class="glyphicon glyphicon-ok"></span> Confirmar
    </button>
	
	<button ng-if="vm.RelatorioSQL.ALTERANDO" ng-click="vm.RelatorioSQL.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 || (vm.RelatorioSQL.TIPO_ADD == 2 && vm.Relatorio.ALTERANDO == false)" ng-if="!vm.RelatorioSQL.ALTERANDO && vm.RelatorioSQL.readonly == false" ng-click="vm.RelatorioSQL.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 || (vm.RelatorioSQL.TIPO_ADD == 2 && vm.Relatorio.ALTERANDO == false)" ng-if="!vm.RelatorioSQL.ALTERANDO && vm.RelatorioSQL.readonly == false" ng-click="vm.RelatorioSQL.excluir()" type="button" class="btn btn-danger" data-hotkey="f12">
        <span class="glyphicon glyphicon-trash"></span> Excluir
    </button>
	
	<button ng-if="!vm.RelatorioSQL.ALTERANDO" type="button" class="btn btn-default btn-fechar-modal btn-voltar" ng-click="vm.RelatorioSQL.fecharModal()" data-hotkey="esc">
		<span class="glyphicon glyphicon-chevron-left"></span> Voltar
    </button>	

@overwrite

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

    <div class="row">
	
        <div class="form-group" ng-if="!vm.RelatorioSQL.INCLUINDO && vm.RelatorioSQL.readonly == false">
            <label>ID:</label>
            <input 
                type="text"
                ng-model="vm.RelatorioSQL.SELECTED.ID"
                class="form-control input-menor" 
                readonly="readonly">
        </div>
        
        <div class="form-group" ng-if="vm.RelatorioSQL.readonly == false">
            <label>Descrição:</label>
            <input 
                type="text"
                class="form-control input-maior" 
                required
                ng-model="vm.RelatorioSQL.SELECTED.DESCRICAO"
                ng-readonly="!vm.RelatorioSQL.ALTERANDO"
            >
        </div>

        <div class="form-group" ng-if="vm.RelatorioSQL.readonly == false">
            <label>Ordem:</label>
            <input 
                type="number"
                class="form-control input-menor" 
                required
                ng-model="vm.RelatorioSQL.SELECTED.ORDEM"
                ng-readonly="!vm.RelatorioSQL.ALTERANDO"
            >
        </div>

        <div class="form-group">
            <input type="checkbox" id="click1" class="form-control"
                ng-checked="vm.RelatorioSQL.SELECTED.PRINCIPAL == 1"
                ng-true-value="1"	ng-false-value="0"
                check-standard2
                ng-change="( vm.RelatorioSQL.SELECTED.PRINCIPAL == 1 ? vm.RelatorioSQL.SELECTED.CONDICAO_CONSULTA = 0 : '' )"
                ng-model="vm.RelatorioSQL.SELECTED.PRINCIPAL"
                ng-disabled="!vm.RelatorioSQL.ALTERANDO">
            <label for="click1" style="margin-left: 5px; font-weight: bold">
                Principal
            </label>
        </div>

        <div class="form-group" ng-show="vm.RelatorioSQL.SELECTED.PRINCIPAL == 0">
            <input type="checkbox" id="click1233421" class="form-control"
                ng-checked="vm.RelatorioSQL.SELECTED.CONDICAO_CONSULTA == 1"
                ng-true-value="1"	ng-false-value="0"
                check-standard2
                ng-model="vm.RelatorioSQL.SELECTED.CONDICAO_CONSULTA"
                ng-disabled="!vm.RelatorioSQL.ALTERANDO">
            <label for="click1233421" style="margin-left: 5px; font-weight: bold">
                Executar Consulta com Condição
            </label>
        </div>

        <div class="form-group"  ng-if="vm.RelatorioSQL.readonly == false">
            <label>Status:</label>
            <label class="switch">
                <input 
                    type="checkbox" 
                    ng-checked="vm.RelatorioSQL.SELECTED.STATUS == '1'"
                    ng-true-value="'1'"
                    ng-false-value="'0'"
                    ng-disabled="!vm.RelatorioSQL.ALTERANDO"
                    ng-click="vm.RelatorioSQL.SELECTED.STATUS = (vm.RelatorioSQL.SELECTED.STATUS == '1') ? '0' : '1'">
                <div class="slider"></div>
            </label>
        </div>

        <div class="form-group">
            <span 
                class="glyphicon glyphicon-info-sign" 
                data-toggle="popover" 
                data-placement="bottom" 
                title="" 
                style="top: 10px; margin-left: 10px; color: #659fe2;" 
                data-element-content="#info-sql-variaveis-@{{ vm.RelatorioSQL.SELECTED.ID }}" 
                on-finish-render="bs-init"
            ></span>

            <div id="info-sql-variaveis-@{{ vm.RelatorioSQL.SELECTED.ID }}" style="display: none">
                <div class="origem-container" style="height: 100% !important; max-height: 400px; overflow: auto !important;">

                    <table class="table table-striped table-bordered">
                        <thead>
                            <tr>
                                <th class="text-center bold" colspan="2" style="font-size: 8pt; font-weight: bold;">Parâmetros de Consulta</th>
                            </tr>
                        </thead>

                        <thead>
                            <tr>
                                <th class="text-center" colspan="2" style="font-size: 8pt; font-weight: bold;">12121 - Visão 360° do Cliente</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">PAINEL_CASO</td>
                                <td class="text-left" style="font-size: 8pt;">ID do Painel de Caso<br>AND ########### = :PAINEL_CASO (Número)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">DATA1</td>
                                <td class="text-left" style="font-size: 8pt;">Data Inicial para filtragem de período<br>AND ########### BETWEEN :DATA1 AND ****** (Data / Inicio)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">DATA2</td>
                                <td class="text-left" style="font-size: 8pt;">Data Final para filtragem de período<br>AND ########### BETWEEN ****** AND :DATA2 (Data / Fim)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">ESTABELECIMENTO</td>
                                <td class="text-left" style="font-size: 8pt;">ID do Estabelecimento<br>AND ########### = :ESTABELECIMENTO (Número)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">REPRESENTANTE</td>
                                <td class="text-left" style="font-size: 8pt;">ID do Representante<br>AND ########### = :REPRESENTANTE (Número)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">GRUPO_CLIENTE</td>
                                <td class="text-left" style="font-size: 8pt;">ID do Grupo de Clientes<br>AND ########### = :GRUPO_CLIENTE (Número)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">CLIENTE</td>
                                <td class="text-left" style="font-size: 8pt;">ID do Cliente<br>AND ########### = :CLIENTE (Número)</td>
                            </tr>
                        </tbody>

                        <thead>
                            <tr>
                                <th class="text-center" colspan="2" style="font-size: 8pt; font-weight: bold;">22611 - Painel de Produção - Ind. Confecção</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">DATA1</td>
                                <td class="text-left" style="font-size: 8pt;">Data Inicial para filtragem de período<br>AND ########### BETWEEN :DATA1 AND ****** (Data / Inicio)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">DATA2</td>
                                <td class="text-left" style="font-size: 8pt;">Data Final para filtragem de período<br>AND ########### BETWEEN ****** AND :DATA2 (Data / Fim)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">ESTABELECIMENTO</td>
                                <td class="text-left" style="font-size: 8pt;">ID do Estabelecimento<br>AND ########### = :ESTABELECIMENTO (Número)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">PERFIL</td>
                                <td class="text-left" style="font-size: 8pt;">ID do Perfil do Grupo de Produção<br>AND ########### = :PERFIL (String)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">GP</td>
                                <td class="text-left" style="font-size: 8pt;">ID do Grupo de Produção<br>AND ########### = :GP (Número)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">FAMILIA_GP</td>
                                <td class="text-left" style="font-size: 8pt;">ID da Família do Grupo de Produção<br>AND ########### = :FAMILIA_GP (Número)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">ETAPA</td>
                                <td class="text-left" style="font-size: 8pt;">ID da Etapa do Grupo de Produção<br>AND ########### = :ETAPA (Número)</td>
                            </tr>
                            <tr>
                                <td class="text-center" style="font-size: 8pt; font-weight: bold;">FAMILIA_ETAPA</td>
                                <td class="text-left" style="font-size: 8pt;">ID da Família da Etapa do Grupo de Produção<br>AND ########### = :FAMILIA_ETAPA (Número)</td>
                            </tr>
                        </tbody>
                    </table>

                </div>
            </div>
        </div>


        <div ng-show="vm.RelatorioSQL.SELECTED.CONDICAO_CONSULTA == 1">

            <div class="form-group">
                <label ttitle="Somente parâmetros de tipo LISTA">Parâmetro:</label>
                <select 
                    class="form-control input-medio" 
                    ng-change="vm.RelatorioSQL.alterarParametroCondicao()"
                    ng-model="vm.RelatorioSQL.SELECTED.PARAM_CONDICAO" 
                    ng-readonly="!vm.RelatorioSQL.ALTERANDO" 
                    ng-disabled="!vm.RelatorioSQL.ALTERANDO">
                    <option ng-value="''">- SELECIONE UM PARÂMETRO -</option>
                    <option ng-repeat="item in vm.RelatorioParametro.CAMPOS_DISP_LIST | orderBy:'ORDEM'" ng-value="item.CAMPO">@{{ item.CAMPO }}</option>
                </select>
            </div>

            <div class="form-group">
                <label>Valor da Condição:</label>
                <select 
                    class="form-control input-medio" 
                    ng-model="vm.RelatorioSQL.SELECTED.VALOR_CONDICAO" 
                    ng-readonly="!vm.RelatorioSQL.ALTERANDO" 
                    ng-disabled="!vm.RelatorioSQL.ALTERANDO">
                    <option ng-value="''">- SELECIONE UM VALOR -</option>
                    <option ng-repeat="item in vm.RelatorioSQL.ARRAY_ITENS_DISP | orderBy:'ORDEM'" ng-value="item.VALOR">@{{ item.DESCRICAO }}: @{{ item.VALOR }}</option>
                </select>
            </div>

        </div>

    </div>

    <legend></legend>

    <textarea style="height: calc(100% - 70px);" ng-show="vm.RelatorioSQL.SHOW_SQL == true" id="sql_editor" class="sql_editor normal-case normalcase" ></textarea>
        
</div>
</form>

@overwrite