@extends('admin.layouts.app')
@section('content')
<div class="container-fluid">
    <div class="row bg-title">
        <div class="col-lg-3 col-md-4 col-sm-4 col-xs-12">
            <h4 class="page-title">ADMINISTRATORS</h4>
        </div>
        <div class="col-lg-9 col-sm-8 col-md-8 col-xs-12">
            <ol class="breadcrumb">
                <li><a href="{{ route('dashboard') }}">Dashboard</a></li>
                <li class="active">SQL Query</li>
            </ol>
        </div>
    </div>
    <div class="row"> 
        <div class="col-md-12 col-xs-12">
            <div class="white-box">
                <div class="row">
                    <div class="col-md-6 col-xs-12">
                        <h3 class="box-title m-b-0">SQL Query</h3>
                        <!--<p class="text-muted m-b-30">Add New Admin</p>-->
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-12">
                        @include('admin.includes.status')
                        <form method="post" action="{{ route('run.sql.query') }}" class="form-horizontal form-validator" enctype="multipart/form-data">
                            {{ csrf_field() }}
                            <div class="form-group col-md-4 col-xs-12">
                                <div class="col-md-12">
                                    <label>Database Name</label>
                                    <select name="database" id="database" class="form-control" required>
                                        <option value="">-- Select Database Name --</option>
                                        <option value="1" @if(old('database') == 1) selected="selected" @elseif(empty(old('database'))) selected="selected" @endif>{{ Config::get('database.connections.mysql.database') }}</option>
                                        <option value="2" @if(old('database') == 2) selected="selected" @endif>{{ Config::get('database.connections.mysql2.database') }}</option>
                                    </select>
                                </div>
                            </div>
                            <div class="form-group {{ $errors->has('sql_query') ? 'has-error' : '' }}">
                                <div class="col-md-12">
                                    <textarea type="text" name="sql_query" id="sql_query" placeholder="SQL Query" class="form-control sql_query_box" required value="{{ old('sql_query') }}" ></textarea>
                                    <div class="clearfix"></div>
                                    <div class="help-block with-errors">
                                        @if ($errors->has('sql_query')){{ $errors->first('sql_query') }}@endif
                                    </div>
                                </div>
                            </div>
                           <div class="form-group">
                                <div class="col-sm-12">
                                    <button type="submit" class="btn btn-info" name="run_sql" value="run_sql">Run Query</button>
                                </div>
                            </div>
                        </form>
                    </div>
                    
                </div>
            </div>
        </div>
    </div>
</div>
@endsection