@php
    use App\Models\NewClasses;
@endphp
@include('system-layouts.layout-head')
@include('systructure-architect-database-version-test.title')
@include('systructure-architect-database-version-test.style')
@php
    switch ($x_order){
          case 1:
              $x_order_name='idArchitect';
              break;
          case 2:
              $x_order_name='xOrder';
              break;
          case 3:
              $x_order_name='idStatusRegExec';
              break;

          default;
              $x_order_name='xOrder';
              $x_order=2;
      }
    //CONDIÇÕES DAS OPÇOES
    $data_sql = new NewClasses();//create a new
    $data_sql->optionInporporate=2;
    $data_sql->optionStatus=1;//AMBIENTE DE TESTE
@endphp
<div class="container-fluid p-b-0">
    <form action="{{ asset('architect-database/test-environment/sql/') }}/{{$select_url}}/{{$id_workspace}}"
          method="get"
          class="needs-validation error" novalidate
          id="actionOption">
        <div class="card">
            <div class="card-body">
                <!--/ CONTENT END -->

                <div class="m-t-20">

                    <h4 class="card-title">EDITAR SCRIPT SQL</h4>
                    {{--            <h6 class="card-subtitle">Lista todos os registro 2</h6>--}}
                    <div class="form-row">
                        <div class="col-sm-4  text-left">
                            {{--                            <a href="{{url('architect-database/test-environment/dbconf/')}}/{{$id_workspace}}"--}}
                            {{--                               class="btn waves-effect waves-light btn-secondary "--}}
                            {{--                               style="width: 150px;"--}}
                            {{--                            >--}}
                            {{--                                <i class="fa fa-cogs font-18"></i>--}}
                            {{--                                DB Conf--}}
                            {{--                            </a>--}}
                            <button type="button"
                                    class="right-side-open btn btn-sm waves-effect waves-light btn-outline-themecolor  "
                                    data-target="sidebar-right-medium"
                                    id="sideBarDBConf">
                                    <span class="btn-label">
                                        <i class="fa fa-cogs font font-18" style="color: coral;"></i>
                                    </span>
                                DB Configurações
                            </button>
                        </div>
                        <div class="col-sm-4  text-center">
                            <div class="btn-group btn-group-toggle" role="group" aria-label="First group">

                                @php $select_process = isset($select_process)?$select_process:3 @endphp

                                @foreach($record_process as $row_process)
                                    <a href="{{url('architect-database/test-environment')}}/sql/{{ mb_strtolower($row_process->xName) }}/{{$id_workspace}}"
                                       class="btn btn-secondary project_process
                                     @if($select_process == $row_process->idArchitectProcess) focus  active @endif"
                                       data-toggle="tooltip" title="{{ mb_strtolower($row_process->xName) }}"
                                       value="{{$row_process->idArchitectProcess }}">
                                        <i class="{!! $row_process->icon !!}"></i>
                                    </a>
                                @endforeach
                            </div>
                        </div>
                        <div class="col-sm-4  text-center">
                            <div class="input-group">
                                <input type="hidden" id="idArchitectProcess" name="idArchitectProcess"
                                       value="{{$select_process}}">
                                <input type="hidden"
                                       value="{{$description_sql_all}}">
                                <select id="xOrder" name="xOrder" class="form-control">
                                    <option value="">
                                        ---
                                    </option>
                                    <option value="1" @if($x_order==1) selected @endif>
                                        Cards
                                    </option>
                                    <option value="2" @if($x_order==2) selected @endif >
                                        SQL
                                    </option>
                                    <option value="3" @if($x_order==3) selected @endif >
                                        Executar
                                    </option>
                                </select>
                                <select id="descriptionSQLAll" name="descriptionSQLAll" class="form-control">
                                    <option value="1" @if($description_sql_all==1) selected @endif>
                                        Mostrar editores vazios
                                    </option>
                                    <option value="2" @if($description_sql_all==2) selected @endif >
                                        Ocultar editores vazios
                                    </option>
                                </select>
                                <select id="idStatusReg" name="idStatusReg" class="form-control">
                                    <option value="1">
                                        Não Mostrar Backup
                                    </option>
                                    <option value="1,11">
                                        Mostrar Backup
                                    </option>
                                </select>
                                <div class="input-group-prepend">
                                    <button type="submit" class="btn waves-effect waves-light btn-rounded btn-info">GO>
                                    </button>
                                </div>
                            </div>
                        </div>

                    </div>

                </div>

                <!--/ CONTENT END -->
            </div>
        </div>
        <input type="hidden" name="idWorkSpace" id="idWorkSpace" value="{{$id_workspace}}">

    </form>
</div>
<div class="container-fluid p-t-0">
    <form action="{{ asset('architect-database/test-environment/dbconf') }}" method="post"
          class="needs-validation error" novalidate
          id="actionForm">

        <div class="card" id="acrionDatabase">


            @include('systructure-architect-database-version-test.index-sql-load')
        </div>
        <input type="hidden" name="_token" id="_token" value="{{ csrf_token() }}">

        <div class="card" id="acrionDatabaseUpdate">
            <div class="row">
                <div class="col-sm-12">
                    <div class="btn-group float-right">
                        <button type="button"
                                id="save"
                                class="btn waves-effect waves-light btn-secondary">
                            <i class="ti-save"></i>
                            Salvar
                        </button>
                        <button type="button"
                                id="saveNext"
                                class="btn waves-effect waves-light btn-secondary ">
                            <i class="ti-save"></i>
                            Salvar/Avançar >>
                        </button>
                    </div>
                </div>
            </div>
        </div>
    </form>
    <div id="destinyAction"></div>
    <div id="msnForm"></div>
</div>


@include('system-layouts.layout-footer')
<script>
    $(function () {
        $('#save').click(function () {

            oziLoadData(data = {
                consoleError: 'on',
                ldId: 'save',
                ldDestinyId: 'destinyAction',
                ldCatchGroupId: ['actionForm'],
                ldCatchItenName: ['_token', 'idWorkSpace'],
                ldUrl: '{{ asset("architect-database/test-environment/save")}}',
                ldProgress: [{
                    ldType: 'bar',
                    ldStyle: 'text-primary',
                    ldDestinyId: 'relacitionshiProg',

                }, {
                    ldType: 'spinner-bt',
                    ldStyle: 'text-light',
                }]
            });


        });
        $('#saveNext').click(function () {

            oziLoadData(data = {
                consoleError: 'on',
                ldId: 'save',
                ldDestinyId: 'destinyAction',
                ldCatchGroupId: [
                    'actionForm',
                ],
                ldCatchItenName: [
                    '_token',
                    'idWorkSpace',
                    'saveNext:dbconf'

                ],
                ldUrl: '{{ asset("architect-database/test-environment/save")}}',
                ldProgress: [{
                    ldType: 'bar',
                    ldStyle: 'text-primary',
                    ldDestinyId: 'relacitionshiProg',

                }, {
                    ldType: 'spinner-bt',
                    ldStyle: 'text-light',
                }]
            });


        });
        $("#sideBarDBConf").click(function () {
            loadsDataForm('#sidebarRight  .content',
                '{{ url('architect-database/test-environment/dbconfSideBar/')}}/{{$id_workspace}}',
                '#actionIndexNot', ['#_token', '#selectProcess', '#user', '#dateRange']);
        });

        $('.add-sql').click(function () {
            var var_number = $(this).val();
            var var_order = $('#xOrder' + var_number).val();
            var_order = var_order * 1.05;
            var analiz = $('#destinationSql' + var_number).html();
            if (analiz == '') {
                var var_version_action =
                    '<div class="col-sm-6">' +
                    '<select id="idVersionAction" name="idVersionAction" class="form-control script-base-black " aria-invalid="false">' +
                    '<option value=""> ---    </option>' +
                        @foreach($record_version_action as $row_version_action)
                            '<option value="{{$row_version_action->idVersionAction}}">{{$row_version_action->xName}}  </option>' +
                        @endforeach
                        '</select>' +
                    '</div>';

                var block_name =
                    '<div class="row m-b-10">' +
                    '    <div class="col-sm-6">' +
                    '       <input  class="form-control script-base-black font-13" name="blockName"' +
                    '                id="blockName" placeholder="Título: tabelas" value="">' +
                    '   </div>' + var_version_action +
                    '</div>';
                var var_order_inp =
                    '<input type="hidden" name="xOrder" id="xOrder" value="' + var_order + '">';
                var var_save =
                    '<button type="button"  class="btn btn-sm waves-effect waves-light btn-outline-success w-100"' +
                    'id="salveDescription' + var_number + '" ' +
                    'onclick="saveCardSQL(' + var_number + ')">' +
                    '<i class="ti-save font-16 "> Salvar</i>' +
                    '</button>';
                var var_del =
                    '<button type="button"  class="btn btn-sm waves-effect waves-light btn-secondary  w-100"' +
                    'onclick="delCardSQL(' + var_number + ')">' +
                    '<i class="fa fa-times font-16"></i> Cancelar</i>' +
                    '</button>';
                var var_div =
                    '<div class="row m-t-5" > ' +
                    '<div class="col-sm-9">' + var_save + '</div>' +
                    '<div class="col-sm-3 ">' + var_del + '</div>' +
                    '</div>'
                var description =
                    '<div id="cardSQL' + var_number + '" ><hr  class="m-t-20">' + block_name +
                    '<textarea class="form-control m-t-15 editor_simple script-base-black"' +
                    ' id="descriptionSQL' + var_number + '" ' +
                    ' name="descriptionSQL" ' +
                    ' placeholder="Banco de dados" autoc ' +
                    ' maxlength="50000" data-maxlength="50000"' +
                    ' spellcheck="false"' +
                    ' style="height: 500px;"' +
                    '></textarea>' + var_div + var_order_inp
                '</div>';

                $('#destinationSql' + var_number).html(description);

                $('#destinationSql' + var_number).slideDown('1000');

            } else {
                alert('Já exite conteudo, salve o conteudo para add');
            }
        });
        $('.save-sql').click(function () {
            var var_number = $(this).val();
            oziLoadData(data = {
                consoleError: 'on',
                ldUrl: '{{asset("architect-database/test-environment/sql/save")}}',
                ldDestinyId: 'actionSQLOption' + var_number + 'Destination',
                ldCatchGroupId: ['actionSQL' + var_number],
                ldCatchItenName: ['_token'],
            });

        });
        $('.del-sql').click(function () {
            var var_number = $(this).val();
            oziLoadData(data = {
                consoleError: 'on',
                ldUrl: '{{asset("architect-database/test-environment/sql/del")}}',
                ldDestinyId: 'actionSQLOption' + var_number + 'Destination',
                ldCatchGroupId: ['actionSQL' + var_number],
                ldCatchItenName: ['_token'],
            });

        });
        $('.bk-sql').click(function () {
            var var_number = $(this).val();
            oziLoadData(data = {
                consoleError: 'on',
                ldUrl: '{{asset("architect-database/test-environment/sql/bk")}}',
                ldDestinyId: 'actionSQLOption' + var_number + 'Destination',
                ldCatchGroupId: ['actionSQL' + var_number],
                ldCatchItenName: ['_token'],
            });

        });
        $('.res-sql').click(function () {
            var var_number = $(this).val();
            oziLoadData(data = {
                consoleError: 'on',
                ldUrl: '{{asset("architect-database/test-environment/sql/res")}}',
                ldDestinyId: 'actionSQLOption' + var_number + 'Destination',
                ldCatchGroupId: ['actionSQL' + var_number],
                ldCatchItenName: ['_token'],
            });

        });

    });

    function delCardSQL(id) {
        $('#cardSQL' + id).slideUp('600', function () {
            $('#cardSQL' + id).remove();
            $('#destinationSql' + id).css('hide');
            $('#destinationSql' + id).removeAttr('style');

        });

    }

    function saveCardSQL(id) {
        oziLoadData(data = {
            consoleError: 'on',
            ldId: 'save',
            ldDestinyId: 'destinationSql' + id,
            ldCatchGroupId: ['actionSQLOption' + id, 'cardSQL' + id],
            ldCatchItenName: ['_token'],
            ldUrl: '{{ asset("architect-database/test-environment/sql/add")}}',
            ldProgress: [{
                ldType: 'bar',
                ldStyle: 'text-primary',
                ldDestinyId: 'relacitionshiProg',

            }, {
                ldType: 'spinner-bt',
                ldStyle: 'text-light',
            }]
        });
    }
</script>