@extends ('backend.layouts.app')

@section('title', 'All DB Tables')

@section('page-header')
<h1>All DB Tables</h1>
@endsection

@section('content')

<div class="box box-info">
        <div class="box-header with-border">
        </div>
        <!--box-header with-border-->

        <div class="box-body">
            <div class="table-responsive data-table-wrapper">
                <table id="dbtable-table" class="table table-condensed table-hover table-bordered">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Table</th>
                            <th>Schema</th>
                            <th>Size</th>
                            <th>Collation</th>
                            <th>Engine</th>
                            <th>Comment</th>
                            <th>{{  trans('labels.general.actions') }}</th>
                        </tr>
                    </thead>
                    <tbody>
                    @if( !empty($tables) )
                        @foreach  ($tables as $table)
                            <tr>
                                <td>{{ $loop->iteration }}</td>
                                <td>{{ $table['name'] }}</td>
                                <td>{{ ( $table['schema'] == 'null' ) ? $table['schema'] : 'NULL' }}</td>
                                <td>{{ $table['size'] }}</td>
                                <td>{{ $table['collation'] }}</td>
                                <td>{{ $table['engine'] }}</td>
                                <td>{{ (  $table['comment'] == 'null' ) ? $table['comment'] : 'NULL' }}</td>
                                <td>
                                    <a href="{{ route('admin.dbmanager.viewtableschema', $table['name']) }}" class="btn btn-primary btn-sm gotoSCM">
                                        View Stucture
                                    </a>
                                    <a href="{{ route('admin.dbmanager.viewtabledata', $table['name']) }}" class="btn btn-primary btn-sm gotoTBL">
                                        View Data
                                    </a>
                                </td>
                            </tr>
                        @endforeach
                    @endif
                    </tbody>
                </table>
            </div>
            <!--table-responsive-->
        </div><!-- /.box-body -->
    </div>
    <!--box-->
@endsection

@section('after-scripts')

<script src="{{ mix('js/dataTable.js') }}"></script>

<script>
    $(function() {
        var dataTable = $('#dbtable-table').dataTable();
    });
</script>

@endsection