@extends('layouts.home_layout')
@section('title','Generate Seeder')

@section('style')
<link rel="stylesheet" href="{{ asset('app-assets/css/select2.min.css') }}" >
@endsection

@section('content')

    <div class="app-content content">
		<div class="col-12">
            <div class="card">
				<div class="card-header ">
					<h4 class="card-title">
					    <h3>Generate Seeder</h3>
					</h4>
					<a class="heading-elements-toggle"><i class="la la-ellipsis-v font-medium-3"></i></a>
					<div class="heading-elements">
						<ul class="list-inline mb-0">
							<li><a data-action="collapse"><i class="ft-minus"></i></a></li>
							<li><a data-action="reload"><i class="ft-rotate-cw"></i></a></li>
							<li><a data-action="expand"><i class="ft-maximize"></i></a></li>
							<li><a data-action="close"><i class="ft-x"></i></a></li>
						</ul>
					</div>
				</div>
				<div class="card-content collapse show">
                    <div class="col-12">
                        <div class="row">
                            <div class="col-8">
                                <div class="form-group">
                                    <label for="tableName">Table Name</label>
                                    {{-- <input type="text" class="form-control" name="tableName" id="tableName" placeholder="Table Name" value="{{$tableName}}"> --}}
                                    <select class="form-control" name="tableName" id="tableName">
                                        <option value="">--Select a Table--</option>
                                        @if ($tables)
                                            @foreach ($tables as $v)
                                                <option @if ($tableName == $v->$dbName) selected @endif value="{{$v->$dbName}}">{{$v->$dbName}}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="col-4">
                                <div class="form-group">
                                    <label for="" style="width: 100%;">&nbsp;</label>
                                    <button type="submit" onclick="getSeeder();" style="" class="btn btn-primary">Generate</button>
                                    <button type="submit" onclick="newSeeder();" style="" class="btn btn-primary">Reset</button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        
        @if ($tableName != '')
            @if ($tableExist)
                <div class="col-12">
                    <div class="card">
                        <div class="card-header ">
                            <h4 class="card-title">
                                <h3>Generated Seeder Form `{{$tableName}}` Table</h3>
                            </h4>
                            <a class="heading-elements-toggle"><i class="la la-ellipsis-v font-medium-3"></i></a>
                            <div class="heading-elements">
                                <ul class="list-inline mb-0">
                                    <li><a data-action="collapse"><i class="ft-minus"></i></a></li>
                                    <li><a data-action="reload"><i class="ft-rotate-cw"></i></a></li>
                                    <li><a data-action="expand"><i class="ft-maximize"></i></a></li>
                                    <li><a data-action="close"><i class="ft-x"></i></a></li>
                                </ul>
                            </div>
                        </div>
                        <div class="card-content collapse show">
                            <div class="col-12 mb-2">
                                <pre>
                                    @php
                                        $totalColumn = count($columns);
                                        $totalLastKye = ($totalColumn - 1);
                                        // print_r($rows);
                                    @endphp
                                </pre>
                                @foreach ($rows as $key => $item)
                                    [<br>
                                        @foreach ($columns as $i => $col)
                                                @if($i != $totalLastKye) 
                                                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"{{$col}}" => "{{$item->$col}}",<br>
                                                @else
                                                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"{{$col}}" => "{{$item->$col}}"<br>
                                                @endif
                                        @endforeach
                                    ],<br>
                                @endforeach
                            </div>
                        </div>
                    </div>
                </div>
            @else
                <div class="col-12">
                    <div class="alert alert-warning alert-block">
                        <button type="button" class="close" data-dismiss="alert">×</button>    
                        <strong>'{{$tableName}}' </strong>Table Not Found.
                    </div>
                </div>
            @endif
        @endif
    </div>

@endsection


@section('script')
    <script src="{{asset('app-assets/js/select2.min.js')}}"></script>
    <script>
        $("select").select2({ 
            placeholder 	: "Select One",
            allowClear 		: true
        });
        function getSeeder() {
            var tableName = $('#tableName').val();

            location.replace("{{url('makeSeed')}}/"+tableName);
        }
        function newSeeder() {
            location.replace("{{url('makeSeed')}}");
        }
    </script>
@endsection