@extends('layouts.superadmin')

@section('content')
<div class="section-header">
    <h1>Database Differences Dashboard</h1>
</div>

<div class="section-body">
    @foreach($differences as $dbName => $diff)
    <div class="card">
        <div class="card-header">
            <h4>{{ $dbName }}</h4>
        </div>
        <div class="card-body">
            <div class="mb-3">
                <a href="{{ route('portal.database.diff.history') }}" class="btn btn-outline-info">
                    View History
                </a>
                <form action="{{ route('portal.database.diff.refresh') }}" method="POST" class="d-inline">
                    @csrf
                    <button class="btn btn-outline-primary" onclick="return confirm('Force refresh differences and log?')">
                        🔄 Force Refresh + Log
                    </button>
                </form>
            </div>

            @if(empty($diff['missingTables']) && empty($diff['extraTables']) && empty($diff['schemaDifferences']))
                <div class="alert alert-success">✅ No differences found.</div>
            @else
                @if(!empty($diff['missingTables']))
                    <div class="mb-3">
                        <h5 class="text-danger">Missing Tables</h5>
                        <ul>
                            @foreach($diff['missingTables'] as $table)
                                <li>{{ $table }}</li>
                            @endforeach
                        </ul>
                    </div>
                @endif

                @if(!empty($diff['extraTables']))
                    <div class="mb-3">
                        <h5 class="text-warning">Extra Tables</h5>
                        <ul>
                            @foreach($diff['extraTables'] as $table)
                                <li>{{ $table }}</li>
                            @endforeach
                        </ul>
                    </div>
                @endif

                @if(!empty($diff['schemaDifferences']))
                    <div class="mb-3">
                        <h5 class="text-info">Table Column Differences</h5>
                        @foreach($diff['schemaDifferences'] as $table => $changes)
                            <div class="mb-2">
                                <strong>{{ $table }}</strong>
                                <ul>
                                    @if(!empty($changes['missingColumns']))
                                        <li class="text-danger">Missing Columns:
                                            <ul>
                                                @foreach($changes['missingColumns'] as $col => $type)
                                                    <li>{{ $col }} ({{ $type }})</li>
                                                @endforeach
                                            </ul>
                                        </li>
                                    @endif
                                    @if(!empty($changes['extraColumns']))
                                        <li class="text-warning">Extra Columns:
                                            <ul>
                                                @foreach($changes['extraColumns'] as $col => $type)
                                                    <li>{{ $col }} ({{ $type }})</li>
                                                @endforeach
                                            </ul>
                                        </li>
                                    @endif
                                    @if(!empty($changes['modifiedColumns']))
                                        <li class="text-info">Modified Columns:
                                            <ul>
                                                @foreach($changes['modifiedColumns'] as $col => $val)
                                                    <li>{{ $col }}: {{ $val['original'] }} &rarr; {{ $val['clone'] }}</li>
                                                @endforeach
                                            </ul>
                                        </li>
                                    @endif
                                </ul>
                            </div>
                        @endforeach
                    </div>
                @endif
            @endif
        </div>
    </div>
    @endforeach
</div>
@endsection