@extends('layouts.admin')

@section('title', 'Live dump import — '.config('app.name'))
@section('page_title', 'Live dump & product files')

@section('content')
    <div class="alert alert-info">
        Copies the <strong>live SQL dump</strong> and optional <strong>product file folder</strong> into this platform.
        Rows are <strong>upserted</strong> by the same IDs the live site uses — nothing is wiped, migrations are not reset, and the dump file is never modified.
        Prefer a <strong>dry run</strong> first.
    </div>

    @if ($errors->any())
        <div class="alert alert-danger">
            <ul class="mb-0">
                @foreach ($errors->all() as $error)
                    <li>{{ $error }}</li>
                @endforeach
            </ul>
        </div>
    @endif

    <div class="row g-4">
        <div class="col-lg-7">
            <div class="card mb-4">
                <div class="card-header"><h5 class="mb-0">1. SQL dump (partners, prices, AC requests, CMS, …)</h5></div>
                <div class="card-body">
                    <form method="post" action="{{ route('admin.legacy-import.run') }}" enctype="multipart/form-data">
                        @csrf

                        <div class="mb-3">
                            <label class="form-label">Dump path on server</label>
                            <input type="text" name="dump_path" class="form-control font-monospace"
                                   value="{{ old('dump_path', $suggestedDumps[0]['path'] ?? '') }}"
                                   placeholder="C:\path\to\systronicsYYYYMMDD.sql">
                            <div class="form-text">Best option for large dumps (avoids PHP upload limits). Current PHP upload cap: {{ $uploadMaxMb }}&nbsp;MB.</div>
                        </div>

                        @if (count($suggestedDumps))
                            <div class="mb-3">
                                <div class="text-muted small mb-1">Detected dumps — click to fill path:</div>
                                <div class="d-flex flex-wrap gap-2">
                                    @foreach ($suggestedDumps as $dump)
                                        <button type="button" class="btn btn-sm btn-outline-secondary"
                                                onclick="this.form.dump_path.value={{ json_encode($dump['path']) }}">
                                            {{ $dump['label'] }} ({{ $dump['size_mb'] }} MB · {{ $dump['mtime'] }})
                                        </button>
                                    @endforeach
                                </div>
                            </div>
                        @endif

                        <div class="mb-3">
                            <label class="form-label">Or upload .sql</label>
                            <input type="file" name="dump_file" class="form-control" accept=".sql,text/plain">
                            <div class="form-text">Only works if upload limit ≥ dump size. Uploads go to <code>storage/app/migration/uploads/</code>.</div>
                        </div>

                        <hr>

                        <h6 class="mb-2">2. Product / download files (optional, same run)</h6>
                        <p class="text-muted small">Copy the live <code>downloads/</code> tree onto this machine, then point here. Extra files not listed in the dump <code>files</code> table are registered so partners can download them.</p>

                        <div class="mb-3">
                            <label class="form-label">Files folder on server</label>
                            <input type="text" name="files_path" class="form-control font-monospace"
                                   value="{{ old('files_path', $suggestedFileFolders[0]['path'] ?? '') }}"
                                   placeholder="C:\path\to\downloads">
                            <div class="form-text">Leave blank to import SQL only. Default disk is <code>DOWNLOADS_PATH</code> (sibling <code>downloads/</code> folder).</div>
                        </div>

                        @if (count($suggestedFileFolders))
                            <div class="mb-3">
                                <div class="text-muted small mb-1">Detected folders — click to fill path:</div>
                                <div class="d-flex flex-wrap gap-2">
                                    @foreach ($suggestedFileFolders as $folder)
                                        <button type="button" class="btn btn-sm btn-outline-secondary"
                                                onclick="this.form.files_path.value={{ json_encode($folder['path']) }}">
                                            {{ $folder['label'] }}
                                        </button>
                                    @endforeach
                                </div>
                            </div>
                        @endif

                        <div class="form-check mb-3">
                            <input type="hidden" name="register_files" value="0">
                            <input class="form-check-input" type="checkbox" name="register_files" value="1" id="register_files"
                                @checked((string) old('register_files', '1') === '1')>
                            <label class="form-check-label" for="register_files">Register extra product files found on disk (does not delete dump rows if a file is missing)</label>
                        </div>

                        <fieldset class="mb-3">
                            <legend class="form-label mb-2">Domains</legend>
                            <div class="form-check mb-2">
                                <input class="form-check-input" type="checkbox" name="domains[]" value="all" id="domain_all"
                                    @checked(collect(old('domains', ['all']))->contains('all'))>
                                <label class="form-check-label" for="domain_all"><strong>All domains</strong></label>
                            </div>
                            <div class="row">
                                @foreach ($domains as $domain)
                                    <div class="col-md-6">
                                        <div class="form-check">
                                            <input class="form-check-input" type="checkbox" name="domains[]" value="{{ $domain }}" id="domain_{{ $domain }}"
                                                @checked(collect(old('domains', []))->contains($domain))>
                                            <label class="form-check-label" for="domain_{{ $domain }}">{{ $domain }}</label>
                                        </div>
                                    </div>
                                @endforeach
                            </div>
                        </fieldset>

                        <div class="form-check mb-2">
                            <input type="hidden" name="dry_run" value="0">
                            <input class="form-check-input" type="checkbox" name="dry_run" value="1" id="dry_run"
                                @checked((string) old('dry_run', '1') === '1')>
                            <label class="form-check-label" for="dry_run">Dry run (count / transform only — no writes)</label>
                        </div>
                        <div class="form-check mb-3">
                            <input class="form-check-input" type="checkbox" name="confirm_write" value="1" id="confirm_write"
                                @checked(old('confirm_write'))>
                            <label class="form-check-label" for="confirm_write">I confirm write mode (upsert into portal; dump stays read-only)</label>
                        </div>

                        <button type="submit" class="btn btn-primary">Run import</button>
                    </form>
                </div>
            </div>

            <div class="card">
                <div class="card-header"><h5 class="mb-0">Marketing HTML helpers (not in the SQL dump)</h5></div>
                <div class="card-body">
                    <p class="text-muted small">Company/product marketing HTML lives in PHP files on disk, not in MySQL. Run these after you copy the old site tree.</p>
                    <form method="post" action="{{ route('admin.legacy-import.filesystem') }}" class="d-flex flex-wrap gap-2 align-items-center">
                        @csrf
                        <div class="form-check me-2">
                            <input type="hidden" name="dry_run" value="0">
                            <input class="form-check-input" type="checkbox" name="dry_run" value="1" id="fs_dry_run" checked>
                            <label class="form-check-label" for="fs_dry_run">Dry run</label>
                        </div>
                        <button class="btn btn-outline-secondary btn-sm" name="action" value="static_pages" type="submit">Import static pages</button>
                        <button class="btn btn-outline-secondary btn-sm" name="action" value="product_pages" type="submit">Import product pages</button>
                        <button class="btn btn-outline-secondary btn-sm" name="action" value="sync_files" type="submit">Re-scan downloads folder</button>
                    </form>
                </div>
            </div>
        </div>

        <div class="col-lg-5">
            <div class="card mb-4">
                <div class="card-header"><h5 class="mb-0">What this does / does not</h5></div>
                <div class="card-body small">
                    <p class="mb-2"><strong>Updates safely:</strong> partners, catalog/prices, activations, downloads metadata + files on disk, support, territories, CMS DB pages, webinars, blacklist.</p>
                    <p class="mb-2"><strong>Skipped from the dump:</strong> rollups, office holidays, phpBB, sessions, visit counters, WordPress, theme/design, mobile API tokens.</p>
                    <p class="mb-0"><strong>Does not break:</strong> no <code>migrate:fresh</code>, no delete of portal schema, no overwrite of app code. Re-runs refresh rows by live IDs (login, product id, reqid, …).</p>
                </div>
            </div>

            @if ($lastRun)
                <div class="card mb-4">
                    <div class="card-header d-flex justify-content-between align-items-center">
                        <h5 class="mb-0">Last run</h5>
                        @if (!empty($lastRun['ok']))
                            <span class="badge text-bg-success">OK</span>
                        @else
                            <span class="badge text-bg-danger">Failed</span>
                        @endif
                    </div>
                    <div class="card-body small">
                        <dl class="row mb-2">
                            <dt class="col-4">When</dt><dd class="col-8">{{ $lastRun['finished_at'] ?? $lastRun['at'] ?? '—' }}</dd>
                            <dt class="col-4">Mode</dt><dd class="col-8">{{ !empty($lastRun['dry_run']) ? 'Dry run' : 'Write' }}</dd>
                            <dt class="col-4">Domains</dt><dd class="col-8"><code>{{ implode(', ', $lastRun['domains'] ?? []) }}</code></dd>
                            <dt class="col-4">Dump</dt><dd class="col-8 text-break"><code>{{ $lastRun['dump'] ?? '—' }}</code></dd>
                            <dt class="col-4">Files</dt><dd class="col-8 text-break"><code>{{ $lastRun['files_root'] ?? '—' }}</code></dd>
                        </dl>
                        @if (!empty($lastRun['error']))
                            <div class="alert alert-danger py-2">{{ $lastRun['error'] }}</div>
                        @endif
                        @if (!empty($lastRun['summary']))
                            <table class="table table-sm mb-2">
                                <thead><tr><th>Domain</th><th>In</th><th>Upd</th><th>Skip</th><th>Err</th></tr></thead>
                                <tbody>
                                @foreach ($lastRun['summary'] as $domain => $row)
                                    <tr>
                                        <td>{{ $domain }}</td>
                                        <td>{{ $row['imported'] }}</td>
                                        <td>{{ $row['updated'] }}</td>
                                        <td>{{ $row['skipped'] }}</td>
                                        <td>{{ $row['errors'] }}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        @endif
                        @if (!empty($lastRun['disk_register']))
                            <p class="mb-1">Disk register: scanned={{ $lastRun['disk_register']['scanned'] ?? 0 }}
                                new={{ $lastRun['disk_register']['registered'] ?? 0 }}
                                existing={{ $lastRun['disk_register']['skipped_existing'] ?? 0 }}</p>
                        @endif
                        @if (!empty($lastRun['files']))
                            <p class="mb-2">File inventory: present={{ $lastRun['files']['present'] ?? 0 }}
                                missing={{ $lastRun['files']['missing'] ?? 0 }}</p>
                        @endif
                        @if (!empty($lastRun['diffs']))
                            <div class="text-muted mb-1">Reconcile DIFF (often expected: seed users, extra disk files, static CMS pages):</div>
                            <ul class="mb-0">
                                @foreach ($lastRun['diffs'] as $table => $row)
                                    <li><code>{{ $table }}</code> source={{ $row['legacy'] ?? 'n/a' }} portal={{ $row['portal'] }}</li>
                                @endforeach
                            </ul>
                        @endif
                    </div>
                </div>
            @endif

            @if (count($recentReports))
                <div class="card">
                    <div class="card-header"><h5 class="mb-0">Recent reports</h5></div>
                    <ul class="list-group list-group-flush small">
                        @foreach ($recentReports as $report)
                            <li class="list-group-item d-flex justify-content-between">
                                <span class="text-break">{{ $report['name'] }}</span>
                                <span class="text-muted">{{ $report['mtime'] }}</span>
                            </li>
                        @endforeach
                    </ul>
                    <div class="card-body py-2 text-muted small">Stored under <code>storage/app/migration/</code></div>
                </div>
            @endif
        </div>
    </div>
@endsection