{% extends "base.html" %}
{% block title %}Remote Sync — Admin{% endblock %}

{% block content %}
<div class="space-y-6" x-data="syncDashboard()" x-init="loadStatus()">

    <!-- Header -->
    <div class="flex items-center justify-between">
        <div>
            <h1 class="text-2xl font-bold text-white">Remote Sync</h1>
            <p class="mt-1 text-sm text-gray-400">Sinkronisasi data lokal ↔ production</p>
        </div>
        <a href="/admin/" class="text-xs text-gray-500 hover:text-gray-300 transition">
            &larr; Dashboard
        </a>
    </div>

    <!-- Connection Status -->
    <div class="grid grid-cols-2 md:grid-cols-4 gap-4">
        <div class="bg-gray-900 border border-gray-800 rounded-xl p-4">
            <p class="text-xs text-gray-500 uppercase tracking-wider">Status</p>
            <div class="flex items-center gap-2 mt-1">
                <span class="w-2.5 h-2.5 rounded-full" :class="status.sync_enabled ? 'bg-emerald-400' : 'bg-red-400'"></span>
                <p class="text-sm font-semibold" :class="status.sync_enabled ? 'text-emerald-400' : 'text-red-400'"
                   x-text="status.sync_enabled ? 'Enabled' : 'Disabled'">Loading...</p>
            </div>
        </div>
        <div class="bg-gray-900 border border-gray-800 rounded-xl p-4">
            <p class="text-xs text-gray-500 uppercase tracking-wider">Remote URL</p>
            <p class="text-sm text-white mt-1 truncate" x-text="remoteUrl || '-'">-</p>
        </div>
        <div class="bg-gray-900 border border-gray-800 rounded-xl p-4">
            <p class="text-xs text-gray-500 uppercase tracking-wider">Server Time</p>
            <p class="text-sm text-white mt-1" x-text="formatDate(status.server_time)">-</p>
        </div>
        <div class="bg-gray-900 border border-gray-800 rounded-xl p-4">
            <p class="text-xs text-gray-500 uppercase tracking-wider">Features</p>
            <div class="flex items-center gap-1.5 mt-1">
                <span class="px-1.5 py-0.5 text-[10px] font-medium rounded bg-sky-900/50 text-sky-400">gzip</span>
                <span class="px-1.5 py-0.5 text-[10px] font-medium rounded bg-emerald-900/50 text-emerald-400">SHA256</span>
                <span class="px-1.5 py-0.5 text-[10px] font-medium rounded bg-purple-900/50 text-purple-400">incremental</span>
            </div>
        </div>
    </div>

    <!-- Push Tables -->
    <div>
        <h2 class="text-sm font-semibold text-gray-400 uppercase tracking-wider mb-3 flex items-center gap-2">
            <svg class="w-4 h-4 text-sky-400" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M7 11l5-5m0 0l5 5m-5-5v12"/></svg>
            Push Tables <span class="text-gray-600">(Local → Production)</span>
            <span class="text-xs font-normal text-gray-600" x-text="'(' + pushTables.length + ' tabel)'"></span>
        </h2>
        <div class="grid grid-cols-2 sm:grid-cols-3 md:grid-cols-4 lg:grid-cols-5 gap-3">
            <template x-for="t in pushTables" :key="t">
                <div class="bg-gray-900 rounded-xl p-3 transition cursor-default relative overflow-hidden border"
                     :class="getTableCardClass(t, 'push')">
                    <!-- Sync status indicator overlay -->
                    <div x-show="tableStatuses[t]?.status === 'syncing'"
                         class="absolute inset-0 bg-sky-500/5 animate-pulse"></div>
                    <div class="relative">
                        <div class="flex items-center justify-between">
                            <p class="text-xs font-mono text-sky-400 truncate" x-text="t"></p>
                            <span x-show="tableStatuses[t]?.status === 'ok'" class="text-emerald-400">
                                <svg class="w-3.5 h-3.5" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zm3.707-9.293a1 1 0 00-1.414-1.414L9 10.586 7.707 9.293a1 1 0 00-1.414 1.414l2 2a1 1 0 001.414 0l4-4z" clip-rule="evenodd"/></svg>
                            </span>
                            <span x-show="tableStatuses[t]?.status === 'syncing'" class="text-sky-400">
                                <svg class="w-3.5 h-3.5 animate-spin" fill="none" viewBox="0 0 24 24"><circle class="opacity-25" cx="12" cy="12" r="10" stroke="currentColor" stroke-width="4"></circle><path class="opacity-75" fill="currentColor" d="M4 12a8 8 0 018-8V0C5.373 0 0 5.373 0 12h4z"></path></svg>
                            </span>
                            <span x-show="tableStatuses[t]?.status === 'error'" class="text-red-400">
                                <svg class="w-3.5 h-3.5" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zM8.707 7.293a1 1 0 00-1.414 1.414L8.586 10l-1.293 1.293a1 1 0 101.414 1.414L10 11.414l1.293 1.293a1 1 0 001.414-1.414L11.414 10l1.293-1.293a1 1 0 00-1.414-1.414L10 8.586 8.707 7.293z" clip-rule="evenodd"/></svg>
                            </span>
                        </div>
                        <p class="text-lg font-bold text-white mt-1" x-text="formatCount(status.table_counts?.[t])">-</p>
                        <p class="text-[10px] text-gray-600 mt-0.5" x-text="getLastSync('push', t)">never</p>
                    </div>
                </div>
            </template>
        </div>
    </div>

    <!-- Pull Tables -->
    <div>
        <h2 class="text-sm font-semibold text-gray-400 uppercase tracking-wider mb-3 flex items-center gap-2">
            <svg class="w-4 h-4 text-amber-400" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M17 13l-5 5m0 0l-5-5m5 5V6"/></svg>
            Pull Tables <span class="text-gray-600">(Production → Local)</span>
            <span class="text-xs font-normal text-gray-600" x-text="'(' + pullTables.length + ' tabel)'"></span>
        </h2>
        <div class="grid grid-cols-2 sm:grid-cols-3 md:grid-cols-4 lg:grid-cols-5 gap-3">
            <template x-for="t in pullTables" :key="t">
                <div class="bg-gray-900 rounded-xl p-3 transition cursor-default relative overflow-hidden border"
                     :class="getTableCardClass(t, 'pull')">
                    <div x-show="tableStatuses[t]?.status === 'syncing'"
                         class="absolute inset-0 bg-amber-500/5 animate-pulse"></div>
                    <div class="relative">
                        <div class="flex items-center justify-between">
                            <p class="text-xs font-mono text-amber-400 truncate" x-text="t"></p>
                            <span x-show="tableStatuses[t]?.status === 'ok'" class="text-emerald-400">
                                <svg class="w-3.5 h-3.5" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zm3.707-9.293a1 1 0 00-1.414-1.414L9 10.586 7.707 9.293a1 1 0 00-1.414 1.414l2 2a1 1 0 001.414 0l4-4z" clip-rule="evenodd"/></svg>
                            </span>
                            <span x-show="tableStatuses[t]?.status === 'syncing'" class="text-amber-400">
                                <svg class="w-3.5 h-3.5 animate-spin" fill="none" viewBox="0 0 24 24"><circle class="opacity-25" cx="12" cy="12" r="10" stroke="currentColor" stroke-width="4"></circle><path class="opacity-75" fill="currentColor" d="M4 12a8 8 0 018-8V0C5.373 0 0 5.373 0 12h4z"></path></svg>
                            </span>
                            <span x-show="tableStatuses[t]?.status === 'error'" class="text-red-400">
                                <svg class="w-3.5 h-3.5" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zM8.707 7.293a1 1 0 00-1.414 1.414L8.586 10l-1.293 1.293a1 1 0 101.414 1.414L10 11.414l1.293 1.293a1 1 0 001.414-1.414L11.414 10l1.293-1.293a1 1 0 00-1.414-1.414L10 8.586 8.707 7.293z" clip-rule="evenodd"/></svg>
                            </span>
                        </div>
                        <p class="text-lg font-bold text-white mt-1" x-text="formatCount(status.table_counts?.[t])">-</p>
                        <p class="text-[10px] text-gray-600 mt-0.5" x-text="getLastSync('pull', t)">never</p>
                    </div>
                </div>
            </template>
        </div>
    </div>

    <!-- Control Panel -->
    <div class="bg-gray-900 border border-gray-800 rounded-xl p-5">
        <h2 class="text-sm font-semibold text-white mb-4">Kontrol Sinkronisasi</h2>

        <div class="flex flex-col sm:flex-row items-start sm:items-end gap-4">
            <!-- Table selector -->
            <div class="w-full sm:w-auto">
                <label class="block text-xs text-gray-500 mb-1">Tabel</label>
                <select x-model="selectedTable" :disabled="syncing"
                        class="w-full sm:w-52 bg-gray-800 border border-gray-700 rounded-lg px-3 py-2 text-sm text-white focus:outline-none focus:ring-1 focus:ring-koin-500 disabled:opacity-50">
                    <option value="">Semua tabel</option>
                    <optgroup label="Push (Local → Production)">
                        <template x-for="t in pushTables" :key="'sel-'+t">
                            <option :value="t" x-text="t"></option>
                        </template>
                    </optgroup>
                    <optgroup label="Pull (Production → Local)">
                        <template x-for="t in pullTables" :key="'sel-'+t">
                            <option :value="t" x-text="t"></option>
                        </template>
                    </optgroup>
                </select>
            </div>

            <!-- Full sync checkbox -->
            <label class="flex items-center gap-2 cursor-pointer select-none" :class="syncing ? 'opacity-50 pointer-events-none' : ''">
                <input type="checkbox" x-model="fullSync" :disabled="syncing"
                       class="w-4 h-4 rounded border-gray-600 bg-gray-800 text-koin-500 focus:ring-koin-500">
                <span class="text-sm text-gray-400">Full sync (abaikan timestamp)</span>
            </label>

            <!-- Buttons -->
            <div class="flex gap-2 ml-auto">
                <!-- Abort button (shown during sync) -->
                <button x-show="syncing" @click="abortSync()"
                        class="inline-flex items-center gap-2 px-4 py-2 text-sm font-medium bg-red-600/80 hover:bg-red-500 text-white rounded-lg transition">
                    <svg class="w-4 h-4" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M6 18L18 6M6 6l12 12"/></svg>
                    Batal
                </button>

                <button x-show="!syncing" @click="startSync('push')"
                        class="inline-flex items-center gap-2 px-4 py-2 text-sm font-medium bg-sky-600 hover:bg-sky-500 text-white rounded-lg transition">
                    <svg class="w-4 h-4" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M7 11l5-5m0 0l5 5m-5-5v12"/></svg>
                    Push
                </button>
                <button x-show="!syncing" @click="startSync('pull')"
                        class="inline-flex items-center gap-2 px-4 py-2 text-sm font-medium bg-amber-600 hover:bg-amber-500 text-white rounded-lg transition">
                    <svg class="w-4 h-4" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M17 13l-5 5m0 0l-5-5m5 5V6"/></svg>
                    Pull
                </button>
                <button x-show="!syncing" @click="startSync('both')"
                        class="inline-flex items-center gap-2 px-4 py-2 text-sm font-medium bg-koin-600 hover:bg-koin-500 text-white rounded-lg transition">
                    <svg class="w-4 h-4" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M4 4v5h.582m15.356 2A8.001 8.001 0 004.582 9m0 0H9m11 11v-5h-.581m0 0a8.003 8.003 0 01-15.357-2m15.357 2H15"/></svg>
                    Sync Both
                </button>
            </div>
        </div>

        <!-- ═══ Live Progress Section ═══ -->
        <div x-show="syncing || syncComplete" x-transition class="mt-5">

            <!-- Overall progress bar + stats row -->
            <div class="flex items-center gap-4 mb-3">
                <div class="flex-1">
                    <div class="flex items-center justify-between mb-1">
                        <span class="text-xs font-medium text-gray-400" x-text="syncMessage">Memulai...</span>
                        <div class="flex items-center gap-3">
                            <span class="text-[10px] font-mono text-gray-500" x-show="totalBytesCompressed > 0"
                                  x-text="fmtBytes(totalBytesCompressed) + ' compressed'"></span>
                            <span class="text-xs font-bold tabular-nums"
                                  :class="progressPercent >= 100 ? 'text-emerald-400' : 'text-koin-400'"
                                  x-text="progressPercent + '%'">0%</span>
                        </div>
                    </div>
                    <div class="h-2 bg-gray-800 rounded-full overflow-hidden">
                        <div class="h-full rounded-full transition-all duration-500 ease-out"
                             :class="progressPercent >= 100 ? 'bg-emerald-500' : 'bg-koin-500'"
                             :style="'width: ' + progressPercent + '%'"></div>
                    </div>
                </div>
                <div class="text-right shrink-0">
                    <p class="text-xs text-gray-500">Waktu</p>
                    <p class="text-sm font-mono font-semibold tabular-nums"
                       :class="syncing ? 'text-koin-400' : 'text-gray-300'"
                       x-text="formatElapsed(elapsed)">0s</p>
                </div>
            </div>

            <!-- Per-table live status list -->
            <div class="bg-gray-950/50 border border-gray-800/50 rounded-lg overflow-hidden max-h-96 overflow-y-auto"
                 x-ref="statusList">
                <table class="w-full text-xs">
                    <thead class="sticky top-0 bg-gray-900/95 backdrop-blur">
                        <tr>
                            <th class="text-left font-medium text-gray-500 uppercase tracking-wider px-3 py-2 w-8"></th>
                            <th class="text-left font-medium text-gray-500 uppercase tracking-wider px-3 py-2">Tabel</th>
                            <th class="text-center font-medium text-gray-500 uppercase tracking-wider px-3 py-2 w-16">Arah</th>
                            <th class="text-left font-medium text-gray-500 uppercase tracking-wider px-3 py-2" style="min-width:180px">Progress</th>
                            <th class="text-right font-medium text-gray-500 uppercase tracking-wider px-3 py-2">Ukuran</th>
                            <th class="text-right font-medium text-gray-500 uppercase tracking-wider px-3 py-2 w-16">Durasi</th>
                        </tr>
                    </thead>
                    <tbody class="divide-y divide-gray-800/30">
                        <template x-for="item in syncQueue" :key="item.table + '-' + item.direction">
                            <tr :class="{
                                'bg-sky-900/10': item.status === 'syncing' && item.direction === 'push',
                                'bg-amber-900/10': item.status === 'syncing' && item.direction === 'pull',
                                'opacity-50': item.status === 'pending'
                            }">
                                <!-- Status icon -->
                                <td class="px-3 py-2 text-center">
                                    <span x-show="item.status === 'pending'" class="text-gray-600">
                                        <svg class="w-4 h-4" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 8v4l3 3m6-3a9 9 0 11-18 0 9 9 0 0118 0z"/></svg>
                                    </span>
                                    <span x-show="item.status === 'syncing'" :class="item.direction === 'push' ? 'text-sky-400' : 'text-amber-400'">
                                        <svg class="w-4 h-4 animate-spin" fill="none" viewBox="0 0 24 24"><circle class="opacity-25" cx="12" cy="12" r="10" stroke="currentColor" stroke-width="4"></circle><path class="opacity-75" fill="currentColor" d="M4 12a8 8 0 018-8V0C5.373 0 0 5.373 0 12h4z"></path></svg>
                                    </span>
                                    <span x-show="item.status === 'ok'" class="text-emerald-400">
                                        <svg class="w-4 h-4" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zm3.707-9.293a1 1 0 00-1.414-1.414L9 10.586 7.707 9.293a1 1 0 00-1.414 1.414l2 2a1 1 0 001.414 0l4-4z" clip-rule="evenodd"/></svg>
                                    </span>
                                    <span x-show="item.status === 'partial'" class="text-amber-400">
                                        <svg class="w-4 h-4" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M8.257 3.099c.765-1.36 2.722-1.36 3.486 0l5.58 9.92c.75 1.334-.213 2.98-1.742 2.98H4.42c-1.53 0-2.493-1.646-1.743-2.98l5.58-9.92zM11 13a1 1 0 11-2 0 1 1 0 012 0zm-1-8a1 1 0 00-1 1v3a1 1 0 002 0V6a1 1 0 00-1-1z" clip-rule="evenodd"/></svg>
                                    </span>
                                    <span x-show="item.status === 'error'" class="text-red-400">
                                        <svg class="w-4 h-4" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zM8.707 7.293a1 1 0 00-1.414 1.414L8.586 10l-1.293 1.293a1 1 0 101.414 1.414L10 11.414l1.293 1.293a1 1 0 001.414-1.414L11.414 10l1.293-1.293a1 1 0 00-1.414-1.414L10 8.586 8.707 7.293z" clip-rule="evenodd"/></svg>
                                    </span>
                                    <span x-show="item.status === 'aborted'" class="text-gray-500">
                                        <svg class="w-4 h-4" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M18.364 18.364A9 9 0 005.636 5.636m12.728 12.728A9 9 0 015.636 5.636m12.728 12.728L5.636 5.636"/></svg>
                                    </span>
                                </td>
                                <!-- Table name -->
                                <td class="px-3 py-2 font-mono" :class="item.status === 'pending' ? 'text-gray-600' : 'text-white'" x-text="item.table"></td>
                                <!-- Direction badge -->
                                <td class="px-3 py-2 text-center">
                                    <span class="px-1.5 py-0.5 text-[10px] font-semibold rounded"
                                          :class="item.direction === 'push' ? 'bg-sky-900/50 text-sky-400' : 'bg-amber-900/50 text-amber-400'"
                                          x-text="item.direction === 'push' ? '▲ PUSH' : '▼ PULL'"></span>
                                </td>
                                <!-- Progress bar + text -->
                                <td class="px-3 py-2">
                                    <template x-if="item.status === 'pending'">
                                        <span class="text-gray-600">menunggu...</span>
                                    </template>
                                    <template x-if="item.status === 'syncing'">
                                        <div>
                                            <div class="flex items-center justify-between mb-0.5">
                                                <span class="text-[10px] tabular-nums" :class="item.direction === 'push' ? 'text-sky-400' : 'text-amber-400'"
                                                      x-text="item.message || 'mengirim...'"></span>
                                                <span class="text-[10px] font-bold tabular-nums" :class="item.direction === 'push' ? 'text-sky-300' : 'text-amber-300'"
                                                      x-text="item.batchPercent + '%'">0%</span>
                                            </div>
                                            <div class="h-1.5 bg-gray-800 rounded-full overflow-hidden">
                                                <div class="h-full rounded-full transition-all duration-300"
                                                     :class="item.direction === 'push' ? 'bg-sky-500' : 'bg-amber-500'"
                                                     :style="'width: ' + item.batchPercent + '%'"></div>
                                            </div>
                                        </div>
                                    </template>
                                    <template x-if="item.status === 'ok'">
                                        <span class="text-emerald-400" x-text="item.resultText || 'OK'"></span>
                                    </template>
                                    <template x-if="item.status === 'partial'">
                                        <span class="text-amber-400" x-text="item.resultText || 'Partial'"></span>
                                    </template>
                                    <template x-if="item.status === 'error'">
                                        <span class="text-red-400 truncate max-w-[200px] inline-block" :title="item.error" x-text="item.error || 'Error'"></span>
                                    </template>
                                    <template x-if="item.status === 'aborted'">
                                        <span class="text-gray-500">dibatalkan</span>
                                    </template>
                                </td>
                                <!-- Byte size -->
                                <td class="px-3 py-2 text-right font-mono tabular-nums whitespace-nowrap">
                                    <template x-if="item.bytesCompressed > 0">
                                        <div>
                                            <span class="text-gray-300" x-text="fmtBytes(item.bytesCompressed)"></span>
                                            <span class="text-gray-600 text-[10px]" x-show="item.bytesUncompressed > 0"
                                                  x-text="'(' + fmtBytes(item.bytesUncompressed) + ')'"></span>
                                        </div>
                                    </template>
                                    <template x-if="!item.bytesCompressed && item.bytesReceived > 0">
                                        <span class="text-gray-300" x-text="fmtBytes(item.bytesReceived)"></span>
                                    </template>
                                    <template x-if="!item.bytesCompressed && !item.bytesReceived">
                                        <span class="text-gray-700">-</span>
                                    </template>
                                </td>
                                <!-- Duration -->
                                <td class="px-3 py-2 text-right font-mono text-gray-500 tabular-nums" x-text="item.duration ? formatElapsed(item.duration) : '-'"></td>
                            </tr>
                        </template>
                    </tbody>
                </table>
            </div>

            <!-- Summary stats + total bytes -->
            <div class="flex items-center gap-6 mt-3 text-xs" x-show="syncComplete">
                <div class="flex items-center gap-1.5">
                    <span class="w-2 h-2 rounded-full bg-emerald-400"></span>
                    <span class="text-gray-400">Berhasil: <strong class="text-emerald-400" x-text="countByStatus('ok')">0</strong></span>
                </div>
                <div class="flex items-center gap-1.5" x-show="countByStatus('partial') > 0">
                    <span class="w-2 h-2 rounded-full bg-amber-400"></span>
                    <span class="text-gray-400">Partial: <strong class="text-amber-400" x-text="countByStatus('partial')">0</strong></span>
                </div>
                <div class="flex items-center gap-1.5" x-show="countByStatus('error') > 0">
                    <span class="w-2 h-2 rounded-full bg-red-400"></span>
                    <span class="text-gray-400">Error: <strong class="text-red-400" x-text="countByStatus('error')">0</strong></span>
                </div>
                <div class="flex items-center gap-1.5" x-show="countByStatus('aborted') > 0">
                    <span class="w-2 h-2 rounded-full bg-gray-500"></span>
                    <span class="text-gray-400">Dibatalkan: <strong class="text-gray-400" x-text="countByStatus('aborted')">0</strong></span>
                </div>
                <div class="flex items-center gap-1.5" x-show="totalBytesCompressed > 0">
                    <span class="w-2 h-2 rounded-full bg-sky-400"></span>
                    <span class="text-gray-400">Total: <strong class="text-sky-400" x-text="fmtBytes(totalBytesCompressed)">0</strong></span>
                    <span class="text-gray-600" x-show="totalBytesUncompressed > 0" x-text="'(raw: ' + fmtBytes(totalBytesUncompressed) + ')'"></span>
                </div>
                <div class="ml-auto">
                    <button @click="clearProgress()" class="text-gray-600 hover:text-gray-400 transition text-xs">
                        ✕ Hapus
                    </button>
                </div>
            </div>
        </div>
    </div>

    <!-- ═══ Detailed Results (expanded view after sync) ═══ -->
    <div x-show="syncComplete && hasDetailedResults()" x-transition>
        <div class="bg-gray-900 border border-gray-800 rounded-xl overflow-hidden">
            <div class="px-5 py-3 border-b border-gray-800 flex items-center justify-between">
                <h3 class="text-sm font-semibold text-white">Detail Hasil Sinkronisasi</h3>
                <div class="flex items-center gap-3 text-xs text-gray-500">
                    <span x-text="'Total: ' + formatElapsed(elapsed)"></span>
                    <span x-show="totalErrors > 0" class="text-red-400" x-text="totalErrors + ' error(s)'"></span>
                </div>
            </div>

            <!-- Push detail -->
            <template x-if="pushResults.length > 0">
                <div class="border-b border-gray-800">
                    <div class="px-5 py-2 bg-sky-900/20">
                        <span class="text-xs font-semibold text-sky-400 uppercase tracking-wider">Push Results (Local → Production)</span>
                    </div>
                    <table class="w-full text-sm">
                        <thead>
                            <tr class="border-b border-gray-800">
                                <th class="text-left text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Table</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Records</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Batches</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Compressed</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Raw</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Durasi</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Status</th>
                            </tr>
                        </thead>
                        <tbody class="divide-y divide-gray-800/50">
                            <template x-for="r in pushResults" :key="'pd-'+r.table">
                                <tr class="hover:bg-gray-800/30">
                                    <td class="px-5 py-2 font-mono text-xs text-white" x-text="r.table"></td>
                                    <td class="px-5 py-2 text-right text-xs text-gray-300" x-text="formatCount(r.total_pushed ?? r.count ?? 0)"></td>
                                    <td class="px-5 py-2 text-right text-xs text-gray-500" x-text="r.batches ?? '-'"></td>
                                    <td class="px-5 py-2 text-right text-xs text-sky-400 font-mono" x-text="r.bytes_compressed ? fmtBytes(r.bytes_compressed) : '-'"></td>
                                    <td class="px-5 py-2 text-right text-xs text-gray-500 font-mono" x-text="r.bytes_uncompressed ? fmtBytes(r.bytes_uncompressed) : '-'"></td>
                                    <td class="px-5 py-2 text-right text-xs text-gray-500 font-mono" x-text="r.duration ? formatElapsed(r.duration) : '-'"></td>
                                    <td class="px-5 py-2 text-right">
                                        <span x-show="r.status === 'ok'" class="inline-flex items-center gap-1 text-xs text-emerald-400">
                                            <svg class="w-3.5 h-3.5" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zm3.707-9.293a1 1 0 00-1.414-1.414L9 10.586 7.707 9.293a1 1 0 00-1.414 1.414l2 2a1 1 0 001.414 0l4-4z" clip-rule="evenodd"/></svg> OK
                                        </span>
                                        <span x-show="r.status === 'partial'" class="inline-flex items-center gap-1 text-xs text-amber-400">&#9888; Partial</span>
                                        <span x-show="r.status === 'error'" class="inline-flex items-center gap-1 text-xs text-red-400" :title="r.error">
                                            <svg class="w-3.5 h-3.5" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zM8.707 7.293a1 1 0 00-1.414 1.414L8.586 10l-1.293 1.293a1 1 0 101.414 1.414L10 11.414l1.293 1.293a1 1 0 001.414-1.414L11.414 10l1.293-1.293a1 1 0 00-1.414-1.414L10 8.586 8.707 7.293z" clip-rule="evenodd"/></svg> Error
                                        </span>
                                    </td>
                                </tr>
                            </template>
                        </tbody>
                    </table>
                </div>
            </template>

            <!-- Pull detail -->
            <template x-if="pullResults.length > 0">
                <div>
                    <div class="px-5 py-2 bg-amber-900/20">
                        <span class="text-xs font-semibold text-amber-400 uppercase tracking-wider">Pull Results (Production → Local)</span>
                    </div>
                    <table class="w-full text-sm">
                        <thead>
                            <tr class="border-b border-gray-800">
                                <th class="text-left text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Table</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Received</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Upserted</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Data Size</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Durasi</th>
                                <th class="text-right text-xs font-medium text-gray-500 uppercase tracking-wider px-5 py-2">Status</th>
                            </tr>
                        </thead>
                        <tbody class="divide-y divide-gray-800/50">
                            <template x-for="r in pullResults" :key="'pld-'+r.table">
                                <tr class="hover:bg-gray-800/30">
                                    <td class="px-5 py-2 font-mono text-xs text-white" x-text="r.table"></td>
                                    <td class="px-5 py-2 text-right text-xs text-gray-500" x-text="formatCount(r.total_received ?? 0)"></td>
                                    <td class="px-5 py-2 text-right text-xs text-gray-300" x-text="formatCount(r.total_pulled ?? r.count ?? 0)"></td>
                                    <td class="px-5 py-2 text-right text-xs text-amber-400 font-mono" x-text="r.bytes_received ? fmtBytes(r.bytes_received) : '-'"></td>
                                    <td class="px-5 py-2 text-right text-xs text-gray-500 font-mono" x-text="r.duration ? formatElapsed(r.duration) : '-'"></td>
                                    <td class="px-5 py-2 text-right">
                                        <span x-show="r.status === 'ok'" class="inline-flex items-center gap-1 text-xs text-emerald-400">
                                            <svg class="w-3.5 h-3.5" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zm3.707-9.293a1 1 0 00-1.414-1.414L9 10.586 7.707 9.293a1 1 0 00-1.414 1.414l2 2a1 1 0 001.414 0l4-4z" clip-rule="evenodd"/></svg> OK
                                        </span>
                                        <span x-show="r.status === 'partial'" class="inline-flex items-center gap-1 text-xs text-amber-400">&#9888; Partial</span>
                                        <span x-show="r.status === 'error'" class="inline-flex items-center gap-1 text-xs text-red-400" :title="r.error">
                                            <svg class="w-3.5 h-3.5" fill="currentColor" viewBox="0 0 20 20"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zM8.707 7.293a1 1 0 00-1.414 1.414L8.586 10l-1.293 1.293a1 1 0 101.414 1.414L10 11.414l1.293 1.293a1 1 0 001.414-1.414L11.414 10l1.293-1.293a1 1 0 00-1.414-1.414L10 8.586 8.707 7.293z" clip-rule="evenodd"/></svg> Error
                                        </span>
                                    </td>
                                </tr>
                            </template>
                        </tbody>
                    </table>
                </div>
            </template>

            <!-- Error list -->
            <template x-if="totalErrors > 0">
                <div class="px-5 py-3 bg-red-900/20 border-t border-red-800/30">
                    <p class="text-xs font-semibold text-red-400 mb-2">Error Details:</p>
                    <template x-for="item in syncQueue.filter(i => i.status === 'error')" :key="'err-'+item.table">
                        <p class="text-xs text-red-300/80 font-mono mb-0.5">
                            <span class="text-red-400" x-text="item.direction"></span>
                            <span class="text-gray-500" x-text="item.table + ': '"></span>
                            <span x-text="item.error"></span>
                        </p>
                    </template>
                </div>
            </template>
        </div>
    </div>

    <!-- Toast Notification -->
    <div x-show="toast.show" x-transition
         class="fixed bottom-6 right-6 z-50 px-4 py-3 rounded-xl shadow-lg border text-sm font-medium max-w-sm"
         :class="toast.type === 'success' ? 'bg-emerald-900/90 border-emerald-700 text-emerald-300'
                                            : 'bg-red-900/90 border-red-700 text-red-300'"
         x-text="toast.message"
         @click="toast.show = false">
    </div>
</div>
{% endblock %}

{% block scripts %}
<script>
function syncDashboard() {
    return {
        // ── State ──────────────────────────────────────────
        status: {},
        syncing: false,
        syncComplete: false,
        syncMessage: '',
        selectedTable: '',
        fullSync: false,
        aborted: false,
        remoteUrl: '{{ config.SYNC_REMOTE_URL or "" }}',
        toast: { show: false, message: '', type: 'success' },

        // Progress
        progressPercent: 0,
        startTime: 0,
        elapsed: 0,
        elapsedTimer: null,

        // Byte tracking
        totalBytesCompressed: 0,
        totalBytesUncompressed: 0,

        // Per-table tracking
        tableStatuses: {},       // { table: { status, direction, ... } }
        syncQueue: [],           // ordered list for UI display
        pushResults: [],
        pullResults: [],
        totalErrors: 0,

        // Table classification
        pushTables: [],
        pullTables: [],
        pushTableNames: [
            'coins', 'coin_source_mappings', 'ohlcv_data', 'coin_profiles',
            'trading_signals', 'prediction_queues', 'market_tickers',
            'range_trading_scores', 'bullish_momentum_scores'
        ],
        pullTableNames: [
            'users', 'user_settings', 'watchlist_groups', 'watchlist',
            'portfolio', 'trade_history', 'capital_allocations', 'app_settings'
        ],

        // ── Toast ──────────────────────────────────────────
        showToast(message, type = 'success') {
            this.toast = { show: true, message, type };
            setTimeout(() => this.toast.show = false, 5000);
        },

        // ── Load Status ────────────────────────────────────
        async loadStatus() {
            try {
                const res = await fetch('/api/v1/sync/status');
                this.status = await res.json();
                const allTables = this.status.tables || [];
                this.pushTables = allTables.filter(t => this.pushTableNames.includes(t));
                this.pullTables = allTables.filter(t => this.pullTableNames.includes(t));
            } catch (e) {
                this.showToast('Gagal memuat status sync', 'error');
            }
        },

        // ── Helpers ────────────────────────────────────────
        getLastSync(direction, table) {
            const key = `sync_last_${direction}_${table}`;
            const val = this.status.last_sync?.[key];
            if (!val) return 'belum pernah sync';
            return this.formatDate(val);
        },

        formatCount(n) {
            if (n === undefined || n === null || n === -1) return '-';
            return Number(n).toLocaleString('id-ID');
        },

        formatDate(iso) {
            if (!iso) return '-';
            try {
                const d = new Date(iso);
                return d.toLocaleString('id-ID', {
                    day: '2-digit', month: 'short', year: 'numeric',
                    hour: '2-digit', minute: '2-digit'
                });
            } catch { return iso; }
        },

        formatElapsed(ms) {
            if (!ms || ms < 0) return '0s';
            const totalSec = Math.floor(ms / 1000);
            const m = Math.floor(totalSec / 60);
            const s = totalSec % 60;
            if (m > 0) return `${m}m ${s}s`;
            return `${s}s`;
        },

        fmtBytes(n) {
            if (!n || n <= 0) return '0 B';
            const units = ['B', 'KB', 'MB', 'GB'];
            let i = 0;
            let val = n;
            while (val >= 1024 && i < units.length - 1) { val /= 1024; i++; }
            return val.toFixed(i > 0 ? 1 : 0) + ' ' + units[i];
        },

        getTableCardClass(table, direction) {
            const st = this.tableStatuses[table]?.status;
            if (!st) return 'border-gray-800 hover:border-' + (direction === 'push' ? 'sky' : 'amber') + '-800/50';
            if (st === 'syncing') return direction === 'push' ? 'border-sky-500/60 ring-1 ring-sky-500/20' : 'border-amber-500/60 ring-1 ring-amber-500/20';
            if (st === 'ok') return 'border-emerald-600/50';
            if (st === 'partial') return 'border-amber-600/50';
            if (st === 'error') return 'border-red-600/50';
            return 'border-gray-800';
        },

        countByStatus(status) {
            return this.syncQueue.filter(i => i.status === status).length;
        },

        hasDetailedResults() {
            return this.pushResults.length > 0 || this.pullResults.length > 0;
        },

        clearProgress() {
            this.syncComplete = false;
            this.syncQueue = [];
            this.tableStatuses = {};
            this.pushResults = [];
            this.pullResults = [];
            this.progressPercent = 0;
            this.totalErrors = 0;
            this.totalBytesCompressed = 0;
            this.totalBytesUncompressed = 0;
        },

        // ── Abort ──────────────────────────────────────────
        abortSync() {
            this.aborted = true;
            this.syncMessage = 'Membatalkan...';
        },

        // ── Auto-scroll status list ───────────────────────
        scrollToCurrentTable() {
            this.$nextTick(() => {
                const el = this.$refs.statusList;
                if (el) el.scrollTop = el.scrollHeight;
            });
        },

        // ── SSE reader for one table ──────────────────────
        syncTableSSE(table, direction) {
            return new Promise((resolve) => {
                const item = this.tableStatuses[table];
                if (!item) { resolve(); return; }

                const tableStart = Date.now();
                item.status = 'syncing';
                item.message = direction === 'push' ? 'mengirim...' : 'menerima...';
                item.batchPercent = 0;
                item.bytesCompressed = 0;
                item.bytesUncompressed = 0;
                item.bytesReceived = 0;

                fetch('/api/v1/sync/trigger-sse', {
                    method: 'POST',
                    headers: { 'Content-Type': 'application/json' },
                    body: JSON.stringify({ direction, table, full: this.fullSync }),
                }).then(res => {
                    if (res.redirected || !res.ok) {
                        item.status = 'error';
                        item.error = res.redirected ? 'Sesi habis' : `HTTP ${res.status}`;
                        item.duration = Date.now() - tableStart;
                        this.totalErrors++;
                        resolve();
                        return;
                    }

                    const reader = res.body.getReader();
                    const decoder = new TextDecoder();
                    let buffer = '';

                    const processChunk = ({ done, value }) => {
                        if (done) {
                            // Stream ended — finalize if not already
                            if (item.status === 'syncing') {
                                item.status = 'ok';
                                item.duration = Date.now() - tableStart;
                                item.batchPercent = 100;
                            }
                            resolve();
                            return;
                        }

                        buffer += decoder.decode(value, { stream: true });
                        const lines = buffer.split('\n');
                        buffer = lines.pop() || '';

                        for (const line of lines) {
                            if (!line.startsWith('data: ')) continue;
                            let evt;
                            try { evt = JSON.parse(line.slice(6)); } catch { continue; }

                            this._handleSSEEvent(item, evt, tableStart);
                        }

                        reader.read().then(processChunk);
                    };

                    reader.read().then(processChunk);
                }).catch(e => {
                    item.status = 'error';
                    item.error = `Network: ${e.message}`;
                    item.duration = Date.now() - tableStart;
                    this.totalErrors++;
                    resolve();
                });
            });
        },

        // ── Handle SSE event for a table item ─────────────
        _handleSSEEvent(item, evt, tableStart) {
            if (evt.type === 'start') {
                item.totalRecords = evt.total_records || 0;
                item.message = `0/${item.totalRecords > 0 ? this.formatCount(item.totalRecords) : '?'}`;
                item.batchPercent = 0;

            } else if (evt.type === 'batch') {
                const sent = evt.total_sent || evt.total_received || 0;
                const total = evt.total_records || item.totalRecords || 0;
                const pct = total > 0 ? Math.min(Math.round((sent / total) * 100), 99) : 0;
                item.batchPercent = pct;
                item.message = `${this.formatCount(sent)}/${this.formatCount(total)} (batch ${evt.batch || '?'})`;

                // Update byte tracking for push
                if (evt.sum_compressed) {
                    item.bytesCompressed = evt.sum_compressed;
                    item.bytesUncompressed = evt.sum_uncompressed || 0;
                }
                // Update byte tracking for pull
                if (evt.sum_bytes) {
                    item.bytesReceived = evt.sum_bytes;
                }

            } else if (evt.type === 'done') {
                item.duration = evt.duration_ms || (Date.now() - tableStart);
                item.batchPercent = 100;
                const hasErrors = evt.errors && evt.errors.length > 0;
                item.status = evt.status === 'ok' ? 'ok' : (hasErrors ? 'partial' : evt.status || 'ok');

                if (evt.direction === 'push') {
                    const pushed = evt.total_pushed ?? 0;
                    item.resultText = `${this.formatCount(pushed)} pushed`;
                    if (evt.batches) item.resultText += ` (${evt.batches} batch)`;

                    item.bytesCompressed = evt.bytes_compressed || 0;
                    item.bytesUncompressed = evt.bytes_uncompressed || 0;
                    this.totalBytesCompressed += item.bytesCompressed;
                    this.totalBytesUncompressed += item.bytesUncompressed;

                    this.pushResults.push({
                        table: item.table, status: item.status,
                        total_pushed: pushed,
                        total_records: evt.total_records,
                        batches: evt.batches,
                        bytes_compressed: item.bytesCompressed,
                        bytes_uncompressed: item.bytesUncompressed,
                        duration: item.duration,
                        errors: evt.errors,
                    });
                } else {
                    const pulled = evt.total_pulled ?? 0;
                    item.resultText = `${this.formatCount(pulled)} pulled`;

                    item.bytesReceived = evt.bytes_received || 0;
                    this.totalBytesCompressed += item.bytesReceived;

                    this.pullResults.push({
                        table: item.table, status: item.status,
                        total_pulled: pulled,
                        total_received: evt.total_received || 0,
                        bytes_received: item.bytesReceived,
                        duration: item.duration,
                        errors: evt.errors,
                    });
                }

                if (hasErrors) this.totalErrors += evt.errors.length;

            } else if (evt.type === 'error') {
                item.status = 'error';
                item.error = evt.error || 'Unknown error';
                item.duration = evt.duration_ms || (Date.now() - tableStart);
                this.totalErrors++;

                if (evt.direction === 'push') {
                    this.pushResults.push({ table: item.table, status: 'error', error: item.error, duration: item.duration });
                } else {
                    this.pullResults.push({ table: item.table, status: 'error', error: item.error, duration: item.duration });
                }

            } else if (evt.type === 'finished') {
                // End-of-stream marker — no action needed
            }
        },

        // ── MAIN SYNC — Sequential per-table via SSE ──────
        async startSync(direction) {
            if (this.syncing) return;

            if (!this.status.sync_enabled) {
                this.showToast('Sync belum diaktifkan. Set SYNC_ENABLED=true di .env', 'error');
                return;
            }

            // Reset state
            this.syncing = true;
            this.syncComplete = false;
            this.aborted = false;
            this.pushResults = [];
            this.pullResults = [];
            this.totalErrors = 0;
            this.totalBytesCompressed = 0;
            this.totalBytesUncompressed = 0;
            this.progressPercent = 0;
            this.startTime = Date.now();
            this.elapsed = 0;
            this.elapsedTimer = setInterval(() => {
                this.elapsed = Date.now() - this.startTime;
            }, 200);

            // ── Build sync queue ──
            let pushList = [];
            let pullList = [];

            if (this.selectedTable) {
                const isPush = this.pushTableNames.includes(this.selectedTable);
                const isPull = this.pullTableNames.includes(this.selectedTable);

                if (direction === 'push' || (direction === 'both' && isPush)) pushList = [this.selectedTable];
                if (direction === 'pull' || (direction === 'both' && isPull)) pullList = [this.selectedTable];

                if (!pushList.length && !pullList.length) {
                    if (direction === 'push') pushList = [this.selectedTable];
                    else if (direction === 'pull') pullList = [this.selectedTable];
                    else {
                        if (isPush) pushList = [this.selectedTable];
                        if (isPull) pullList = [this.selectedTable];
                        if (!pushList.length && !pullList.length) pushList = [this.selectedTable];
                    }
                }
            } else {
                if (direction === 'push' || direction === 'both') pushList = [...this.pushTables];
                if (direction === 'pull' || direction === 'both') pullList = [...this.pullTables];
            }

            const totalTables = pushList.length + pullList.length;
            if (totalTables === 0) {
                this.syncing = false;
                clearInterval(this.elapsedTimer);
                this.showToast('Tidak ada tabel untuk disinkronkan', 'error');
                return;
            }

            // Initialize sync queue for UI
            this.syncQueue = [];
            this.tableStatuses = {};
            for (const t of pushList) {
                const item = {
                    table: t, direction: 'push', status: 'pending',
                    message: '', resultText: '', error: '', duration: null,
                    batchPercent: 0, totalRecords: 0,
                    bytesCompressed: 0, bytesUncompressed: 0, bytesReceived: 0,
                };
                this.syncQueue.push(item);
                this.tableStatuses[t] = item;
            }
            for (const t of pullList) {
                const item = {
                    table: t, direction: 'pull', status: 'pending',
                    message: '', resultText: '', error: '', duration: null,
                    batchPercent: 0, totalRecords: 0,
                    bytesCompressed: 0, bytesUncompressed: 0, bytesReceived: 0,
                };
                this.syncQueue.push(item);
                this.tableStatuses[t] = item;
            }

            let completed = 0;

            // ── Process push tables via SSE ──
            for (const table of pushList) {
                if (this.aborted) { this._markRemaining('aborted'); break; }

                this.syncMessage = `▲ Push ${table} (${completed + 1}/${totalTables})`;
                this.scrollToCurrentTable();

                await this.syncTableSSE(table, 'push');

                completed++;
                this.progressPercent = Math.round((completed / totalTables) * 100);
            }

            // ── Process pull tables via SSE ──
            for (const table of pullList) {
                if (this.aborted) { this._markRemaining('aborted'); break; }

                this.syncMessage = `▼ Pull ${table} (${completed + 1}/${totalTables})`;
                this.scrollToCurrentTable();

                await this.syncTableSSE(table, 'pull');

                completed++;
                this.progressPercent = Math.round((completed / totalTables) * 100);
            }

            // ── Finalize ──
            clearInterval(this.elapsedTimer);
            this.elapsed = Date.now() - this.startTime;
            this.syncing = false;
            this.syncComplete = true;

            if (this.aborted) {
                this.syncMessage = `Dibatalkan — ${completed}/${totalTables} tabel selesai`;
                this.showToast(`Sync dibatalkan (${completed}/${totalTables} selesai)`, 'error');
            } else {
                this.progressPercent = 100;
                const dur = this.formatElapsed(this.elapsed);
                const bytesInfo = this.totalBytesCompressed > 0 ? ` (${this.fmtBytes(this.totalBytesCompressed)})` : '';
                if (this.totalErrors > 0) {
                    this.syncMessage = `Selesai dengan ${this.totalErrors} error — ${dur}${bytesInfo}`;
                    this.showToast(`Sync selesai dengan ${this.totalErrors} error (${dur})`, 'error');
                } else {
                    this.syncMessage = `Selesai — ${totalTables} tabel berhasil — ${dur}${bytesInfo}`;
                    this.showToast(`Sync berhasil! ${totalTables} tabel (${dur})`, 'success');
                }
            }

            await this.loadStatus();
        },

        _markRemaining(status) {
            for (const item of this.syncQueue) {
                if (item.status === 'pending') item.status = status;
            }
        },
    };
}
</script>
{% endblock %}