@extends('layouts.app')
@section('style')
<style>
    .not-data{
        background: rgb(209, 119, 119);
        color:rgb(146, 15, 15);
        padding: 3px 7px;
        text-shadow: 0 0 5px #fff;
    }
    .not-same{
        background: rgb(209, 173, 119);
        color:rgb(146, 85, 15);
        padding: 3px 7px;
        text-shadow: 0 0 5px #fff;
    }
    .table-bordered tr td:nth-child(1),.table-bordered tr th:nth-child(1){width: 25%;}
    .table-bordered tr td:nth-child(2),.table-bordered tr th:nth-child(2){width: 10%;}
    .table-bordered tr td:nth-child(3),.table-bordered tr th:nth-child(3){width: 10%;}
    .table-bordered tr td:nth-child(4),.table-bordered tr th:nth-child(4){width: 10%;}
    .table-bordered tr td:nth-child(5),.table-bordered tr th:nth-child(5){width: 25%;}
    .table-bordered tr td:nth-child(6),.table-bordered tr th:nth-child(6){width: 10%;}
    .table-bordered tr td:nth-child(7),.table-bordered tr th:nth-child(7){width: 10%;}
    .table-bordered{
        border: none;
    }

    .scroll-table{
        height: 50vh;
        overflow-y: scroll;
    }
    ::-webkit-scrollbar {
        width: 10px;
    }

    ::-webkit-scrollbar-track {
        background: #fff;
    }

    ::-webkit-scrollbar-thumb {
        background: #888;
    }

    ::-webkit-scrollbar-thumb:hover {
        background: #555;
    }
    .menu-list{
        height: 25vh;
        overflow-y: scroll;
    }
    .menu-list .row{
        padding-top: 7px;
        height: 8em;
        overflow-y: scroll;
        background: seashell;
    }
    #transfer{
        position:fixed;
        right: 0;
        top: 45%;
        border-radius: 15px 0 0 15px;
    }
</style>
@endsection
@section('content')
@php
    function check_array_data($data,$k){
        if(isset($data)){
            echo $k;
        }else{
            echo "<font class='not-data'>ไม่มี Table นี้</font>";
        }
    }
    function check_type($type_a,$type_b){
        if(isset($type_a) && isset($type_b)){
            if(count($type_a)>=count($type_b)){
                $data_loop_a = $type_a;
                $data_loop_b = $type_b;
                $ck = 'my';
            }else{
                $data_loop_a = $type_b;
                $data_loop_b = $type_a;
                $ck = 'your';
            }
            foreach ($data_loop_a as $key => $value) {
                if($value != @$data_loop_b[$key]){
                    $color = 'not-same';

                    if($ck=='my'){
                        echo "<font class='not-same'>".$key.'['.$value.']'."</font>";
                    }else{
                        if(isset($data_loop_b[$key])){
                            echo "<font class='not-same'>".$key.'['.@$data_loop_b[$key].']'."</font>&emsp;";
                        }else{
                            echo "<font class='not-data'>".$key."</font>";

                        }
                    }
                }
            }
        }
    }

    function count_type($count_a,$count_b){
        if(isset($count_a) && !isset($count_b)){
            echo count($count_a);
        }else if(isset($count_a) && isset($count_b)){
            $data_a = count($count_a);
            $data_b = count($count_b);
            if($data_a == $data_b){
                echo $data_a;
            }else{
                echo "<font class='not-same'>$data_a</font>";
            }
        }
    }
@endphp
<div class="col-12">
    <div class="card">
        <div class="card-body">
            <form action="{{url('check_db/transfer')}}" method="post">
                @method('PUT')
                @csrf
                @if(count($new)>0)
                    <input type="hidden" name="table" value="{{json_encode($new)}}">
                @endif
                @php
                $c_dh =0;
                // dd($sum);
                    for($i=0;$i<count($sum['new']);$i++){
                        if(isset($sum['new'][$i]['not_have'])){
                            $ar[] = $sum['new'][$i]['not_have'];
                            $c_dh =1;
                        }
                    }
                    if($c_dh ==1){
                        $dh = json_encode($ar);
                    }
                @endphp
                @if($c_dh==1)
                    <input type="hidden" name="colum" value="{{$dh}}">
                @endif
                <button type="submit" class="btn btn-danger" id="transfer"><i class="fab fa-cloudversify p-0"></i></button>
            </form>
            <div class="row m-0 scroll-table">
                <table class="table table-bordered ">
                    <tr>
                        <th colspan="3" class="text-center bg-success">Database เก่า</th>
                        <th class="border-0"></th>
                        <th colspan="3" class="text-center bg-primary">Database ใหม่</th>
                    </tr>
                    <tr>
                        <th class="text-center bg-secondary">Table</th>
                        <th class="text-center bg-secondary">Type</th>
                        <th class="text-center bg-secondary">Count</th>
                        <th class="border-0"></th>
                        <th class="text-center bg-secondary">Table</th>
                        <th class="text-center bg-secondary">Type</th>
                        <th class="text-center bg-secondary">Count</th>
                    </tr>
                    @foreach ($data as $key => $item)
                        <tr>
                            <td class="pl-5">{{check_array_data(@$data[$key]['first'],$key)}}</td>
                            <td class="text-center">{{check_type(@$data[$key]['first'],@$data[$key]['connection'])}}</td>
                            <td class="text-center">{{count_type(@$data[$key]['first'],@$data[$key]['connection'])}}</td>
                            <td class="border-0"></td>
                            <td class="pl-5">{{check_array_data(@$data[$key]['connection'],$key)}}</td>
                            <td class="text-center">{{check_type(@$data[$key]['connection'],@$data[$key]['first'])}}</td>
                            <td class="text-center">{{count_type(@$data[$key]['connection'],@$data[$key]['first'])}}</td>
                        </tr>
                    @endforeach
                </table>
            </div>
        </div>
    </div>
    <div class="card mt-3">
        <div class="card-body">
            <div class="row m-0 menu-list">
                <div class="col">
                    <div class="col-12">
                        <h4>Database เก่า</h4>
                    </div>
                    <div class="row m-0">
                        <div class="col-12">
                            @if(count($new)==0)
                                Table : <b class="text-success">ครบ</b>
                            @else
                                Table ขาด :
                                @foreach ($new as $n)
                                    [ {{$n}} ] &emsp;
                                @endforeach
                            @endif
                        </div>
                    </div>
                    <div class="row m-0 mt-2">
                        @if(!isset($sum['new']))
                            <div class="col-12">Type : <b class="text-success">เหมือนกันครบ</b></div>
                        @else
                            <div class="col-12">Type :
                                @foreach ($sum['new'] as $s)
                                <b class="text-warning">{{@$s['not_same']}}</b>  &nbsp;
                                @endforeach
                            </div>
                        @endif
                    </div>
                    <div class="row m-0 mt-2">
                        @if(!isset($sum['new']))
                            <div class="col-12">Fill : <b class="text-success">เหมือนกันครบ</b></div>
                        @else
                            <div class="col-12">Fill :
                                @foreach ($sum['new'] as $s)
                                <b class="text-warning">{{@$s['not_have']}}</b>   &nbsp;
                                @endforeach
                            </div>
                        @endif
                    </div>
                </div>
                <div class="col-1"></div>
                <div class="col">
                    <div class="col-12">
                        <h4>Database ใหม่</h4>
                    </div>
                    <div class="row m-0">
                        <div class="col-12">
                            @if(count($old)==0)
                                Table : <b class="text-success">ครบ</b>
                            @else
                                Table ขาด :
                                @foreach ($old as $o)
                                   <b class="text-warning">[ {{$o}} ]</b>  &emsp;
                                @endforeach
                            @endif
                        </div>
                    </div>
                    <div class="row m-0 mt-2">
                        @if(!isset($sum['old']))
                            <div class="col-12">Type : <b class="text-success">เหมือนกันครบ</b></div>
                        @else
                            <div class="col-12">Type :
                                @foreach ($sum['old'] as $s)
                                <b class="text-warning">{{@$s['not_same']}}</b>   &nbsp;
                                @endforeach
                            </div>
                        @endif
                    </div>
                    <div class="row m-0 mt-2">
                        @if(!isset($sum['old']))
                            <div class="col-12">Fill : <b class="text-success">เหมือนกันครบ</b></div>
                        @else
                            <div class="col-12">Fill :
                                @foreach ($sum['old'] as $s)
                                   <b class="text-warning">{{@$s['not_have']}}</b>  &nbsp;
                                @endforeach
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection