@extends ('backend.layouts.app')

@section('title', 'Table Data')

@section('page-header')
<h1>Table Data of {{ $table }}</h1>
@endsection

@section('content')

<div class="box box-info">
        <div class="box-header with-border">
            <a href="{{ route('admin.dbmanager.index') }}" class="btn btn-primary btn-sm gotoTBL">
                Return
            </a>
        </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>{{  trans('labels.general.actions') }}</th>
                            @foreach($columns as $column)
                                <th scope="col">{{ $column }}</th>
                            @endforeach
                            <!--  -->
                        </tr>
                    </thead>
                    <tbody>
                    @if( !empty($tableData) )
                        @foreach($tableData as $tableValue)
                            <tr>
                            @php 
                                $i=0; 
                            @endphp
                            @foreach($columns as $column)                                
                                @if( $i === 0 )
                                    <td><a href="{{ route('admin.dbmanager.tablerowdata',['tblname' => $table, 'id' => $tableValue->$column, 'col'=> $column]) }}" class="btn btn-primary btn-sm gotoTBL">
                                        View Data
                                    </a></td>
                                    @php $i++; @endphp
                                @endif
                                <td>
                                    {{ $tableValue->$column }}
                                </td>
                            @endforeach
                            </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