@extends('admin::layouts.plane')
@section('page_heading') {{$title}} @endsection
@section('content')

<div class="col-lg-12">
    <div class="panel panel-default filterable">
        <div class="panel-heading">
            <div class="panel-title">{{$title}}</div>
        </div>
        <div class="panel-body">
            {{ Form::open([ 'method' => 'post', 'route' => 'DBExplorer','class' => 'form-horizontal']) }}
            {{ csrf_field() }} 
            <div class="form-group required" > 
               <div class="col-sm-1">
                    <label>Table Name:</label>
                </div>
                <div class="col-lg-2">
                    {{Form::select('table_name', $db_tables, $table_name, [ 'id'=>'ui_table_name','class' => 'form-control','required' => ''])}}   
                    {{ Form::hidden('str', $str, ['id' => 'str' ]) }}
                </div> 
               <div class="col-sm-1">
                    <label>WHERE:</label>
                </div>
                
                <div class="col-lg-2">
                    {{ Form::textarea('whereclause', '', ['id' => 'whereclause', 'class' => 'form-                           control' ,'placeholder' => 'Write where condition here', 'rows'=>3,'cols'=>120]) }} 
                </div> 

                <div class="col-sm-6" style="text-align: right; ">
                    {{ Form::submit('Submit', ['class' => 'btn btn-info']) }} 
                </div>
            </div>
            {{ Form::close() }}
        </div>
    </div>
</div>
<div class="col-lg-12">
<div class="panel-body">   
    @if(!isset($noButtonArray[$table_name]))
                                <span  class="btn-group">
                                <a href="{{url('admin/Add')}}/{{$table_name}}" class="xcrud-action btn btn-primary btn-sm" title="Insert"><i class="fa fa-plus-square"></i></a> 
                            </span>
    @endif

    <div class="table-responsive">
        <table id="data-table" class="table table-striped table-bordered table-hover">
            <thead>
                <tr class="filters">
                    <th>Action</th>
                    @foreach($field_names as $key => $value)
                        <th>{{$value}}</th>
                    @endforeach

                </tr>
            </thead>
            <tbody> 
                @foreach ($result as $obj) 
                    @php $school_id = (isset($obj->school_id)?$obj->school_id:-1); @endphp
                    <tr>
                        @if(!isset($noButtonArray[$table_name]))
                        <td>
                            <span>
                                <a href="{{url('admin/Edit')}}/{{$table_name}}/{{$school_id}}/{{$obj->$tableprimaryid}}/{{$str}}" class="xcrud-action btn btn-warning btn-sm" title="Update"><i class="fa fa-pencil-square"></i></a>
                            @if($super_admin)
                            </span>
                                <a href="{{url('admin/Delete')}}/{{$table_name}}/{{$school_id}}/{{$obj->$tableprimaryid}}/{{$str}}" class="xcrud-action btn btn-danger btn-sm" onclick="return deleteClick();" id="delete" title="Delete"><i class="fa fa-trash-o"></i></a>
                            </span>
                            @endif
                        </td>
                        @else
                        <td></td>
                        @endif
                        @foreach ($field_names as $f) 
                            <td>{{$obj->$f}}</td>
                        @endforeach
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div> 
</div>  
<script src="{{ asset ("/bower_components/jquery/dist/jquery.min.js") }}"></script>

<script type="text/javascript">
  $(document).ready(function() {
    $("#ui_table_name").select2();
  });
function deleteClick() {
       return confirm('Are you sure?');
    }
</script>
@stop