@php
    use App\Http\Controllers\CompanyManagerAuthController as CompanyManager;
    use App\Http\Controllers\ClientInterDataBase;
    use App\Http\Controllers\SyStructureArchitectProcess;
    $record_process = SyStructureArchitectProcess::information([
        'idArchitectProcess'=>$select_process,
        'orderByName'=>'xOrder',
    ]);
//    dump($record_process);
@endphp
@include('system-layouts.layout-head')
@include('systructure-architect-database.title')

<div class="container-fluid">
    <div class="card">
        <div class="card-body">
            <!-- CONTENT END -->


            <h4 class="card-title">Confirgurações Banco de dados</h4>
            <div class="row">
                <div class="col-sm-6 text-left">
                    <a href="{{url('architect-database/test-environment/sql/in progress/')}}/{{$id_workspace}}"
                       class="btn waves-effect waves-light btn-secondary  "
                       style="width: 150px;">
                        <i class="fa fa-database font-18"></i>
                        Editar SQL
                    </a>
                </div>
                <div class="col-sm-6 text-right">
                    <a href="{{url('architect-database/test-environment/formadd-database/')}}/{{$id_workspace}}"  class="btn waves-effect waves-light btn-secondary w-50">
                        <i class="mdi mdi-database-plus font-18"></i> Criar novas configurações
                    </a>
                </div>
            </div>

{{--            <form action="{{ asset('architect-database/test-environment') }}/contratante/{{$id_workspace}}" method="get"--}}
{{--                  class="needs-validation error m-t-20" novalidate--}}
{{--                  id="actionOption">--}}
{{--                <div class="input-group">--}}
{{--                    <div class="input-group-prepend">--}}
{{--                    <span class="input-group-text font-10"--}}
{{--                          title="Códido do contratante"> PROCESSO A SER TESTADO  </span>--}}

{{--                    </div>--}}
{{--                    <input type="text" class="form-control form-control-sm " disabled="disabled"--}}
{{--                           id="xName" name="xName"--}}
{{--                           value="{{  $record_process->xName }}">--}}
{{--                    <select name="dd" id="dd">--}}
{{--                        <option value="on">ON</option>--}}
{{--                        <option value="off">OFF</option>--}}
{{--                    </select>--}}
{{--                </div>--}}

{{--            </form>--}}

            <div class="table-responsive m-t-40" id="actionIndex">
                <table class="data_table_search table table-bordered table-striped">
                    <thead>
                    <tr>
                        <th>Decrição</th>

                    </tr>
                    </thead>
                    <tbody>
                    @foreach($record as $row )
                        <tr>
                            <td>
                                <div class="row bg-secondary" style="padding: 5px; ">
                                    <div class="col-sm-10">
                                        <div class=" text-white radio-5 p-t-10 ">
                                            <b>ID:</b> {{ $row->idManager }}
                                            | <b>Nome:</b> {{ $row->xName }}
                                            | <b>Codigo ADM:</b> &nbsp <span
                                                    class="label label-themecolor">  {{ $row->idManager }} </span>


                                        </div>
                                    </div>
                                    <div class="col-sm-2 text-right">
                                        <a class="btn btn-secondary btn-sm font-18" target="_blank"
                                           href="{{ url('managerinter-client-conf')}}/{{ $row->idManager }}">
                                            <i class="fa fa-pencil"></i>
                                        </a>
                                    </div>
                                </div>


                                @php $company= CompanyManager::listCompName('',$row->idManager) @endphp
                                @foreach($company as $row_comp )
                                    <hr>
                                    <div class="row m-t-15">
                                        <div class="col-sm-10">
                                            @php
                                                $record_batabase = ClientInterDataBase::information([
                                                    'idManager'=>$row_comp->idManager,
                                                    'idComp'=>$row_comp->idComp,
                                                ]);
                                            @endphp
                                            <b>ID:</b> {{ $row_comp->idComp }}
                                            | <a href="{{ asset('managerinter-client-conf') }}/{{ $row_comp->idComp }}"
                                                 class="card-subtitle text-themecolor">  {{ $row_comp->xName }}</a>
                                            | <b>CNPJ:</b> {{ $row_comp->cnpj }}<br>
                                            <div class="m-l-10">
                                                <small>
                                                    <b>DRIVER:</b> {{isset($record_batabase->dbDriver)?$record_batabase->dbDriver:null}}
                                                    |
                                                    <b>PORT:</b> {{isset($record_batabase->dbPort)?$record_batabase->dbPort:null}}
                                                    |
                                                    <b>URL</b>:{{isset($record_batabase->idCompDataBase)?$record_batabase->dbUrl:null}}
                                                    <br>
                                                    <b>HOST:</b> {{isset($record_batabase->dbHost)?$record_batabase->dbHost:null}}
                                                    | <b>BANCO DE
                                                        DADOS:</b> {{isset($record_batabase->dbDataBase)?$record_batabase->dbDataBase:null}}
                                                    |
                                                    <b>USUARIO:</b> {{isset($record_batabase->dbUserName)?$record_batabase->dbUserName:null}}
                                                    |
                                                    <b>SENHA:</b> {{isset($record_batabase->dbPassWord)?$record_batabase->dbPassWord:null}}
                                                </small>
                                            </div>
                                        </div>
                                        <div class="col-sm-2 text-left">


                                            <button type="button" class="btn btn-secondary font-10"
                                                    title="ATUALIZAÇÃO RÁPIDA"
                                                    onClick="oziOpenWindow('{{url('architect-database/test-environment/execute')}}/?idCompDataBase={{isset($record_batabase->idCompDataBase)?$record_batabase->idCompDataBase:null}}&selectProcess={{$select_process}}&dd={{$dd}}')">
                                                <i class="mdi mdi-refresh"></i> Executar SQL
                                            </button>


                                        </div>
                                    </div>

                                @endforeach
                            </td>


                        </tr>
                    @endforeach
                    </tbody>
                </table>

                <input type="hidden" name="idWorkSpace" id="idWorkSpace" value="{{$id_workspace}}">
                <input type="hidden" name="_token" id="_token" value="{{csrf_token()}}">
            </div>


            <!--/ CONTENT END -->
        </div>
    </div>
    <div class="card" id="acrionDatabaseUpdate">
        <div class="row">
            <div class="col-sm-12">
                <a href="{{url('architect-database-contratante')}}"
                   class="btn waves-effect waves-light btn-secondary float-right"><i class="ti-save"></i>
                    ATUALIZAR AGORA
                </a>
            </div>
        </div>
    </div>

</div>


@include('system-layouts.layout-footer')