<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
if (session_status() == PHP_SESSION_NONE) {
    session_start();
}

// ============================================================================
// [BARU] KELAS DATABASE ABSTRACTION LAYER
// ============================================================================
class Database
{
    private $connection;
    private $driver; // 'mysqli' atau 'pdo'

    public function __construct($host, $user, $pass, $port)
    {
        if (extension_loaded('mysqli')) {
            $this->driver = 'mysqli';
            try {
                mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
                $this->connection = mysqli_connect($host, $user, $pass, null, (int)$port);
                mysqli_report(MYSQLI_REPORT_OFF);
            } catch (Exception $e) {
                throw new Exception("MySQLi Connect Error: " . $e->getMessage());
            }
        } elseif (extension_loaded('pdo_mysql')) {
            $this->driver = 'pdo';
            try {
                $dsn = "mysql:host={$host};port={$port}";
                $this->connection = new PDO($dsn, $user, $pass, [
                    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
                ]);
            } catch (PDOException $e) {
                throw new Exception("PDO Connect Error: " . $e->getMessage());
            }
        } else {
            throw new Exception("Tidak ada driver database yang tersedia (MySQLi atau PDO_MySQL tidak ditemukan).");
        }
    }
    
    public function selectDb($dbName) {
        if ($this->driver === 'mysqli') {
            return mysqli_select_db($this->connection, $dbName);
        } else { // PDO
            $this->connection->exec("USE `$dbName`");
            return true;
        }
    }

    public function query($sql)
    {
        if ($this->driver === 'mysqli') {
            return mysqli_query($this->connection, $sql);
        } else { // PDO
            return $this->connection->query($sql);
        }
    }

    public function prepare($sql)
    {
        if ($this->driver === 'mysqli') {
            return mysqli_prepare($this->connection, $sql);
        } else { // PDO
            return $this->connection->prepare($sql);
        }
    }
    
    public function execute($stmt, $params = [])
    {
        if ($this->driver === 'mysqli') {
            if (!empty($params)) {
                $types = str_repeat('s', count($params)); // Asumsi semua string untuk kesederhanaan
                mysqli_stmt_bind_param($stmt, $types, ...$params);
            }
            return mysqli_stmt_execute($stmt);
        } else { // PDO
            return $stmt->execute($params);
        }
    }
    
    public function getResult($stmt) {
         if ($this->driver === 'mysqli') {
            return mysqli_stmt_get_result($stmt);
        } else { // PDO
            return $stmt; // PDO statement object is iterable
        }
    }

    public function fetchAllAssoc($result)
    {
        if ($this->driver === 'mysqli') {
            return mysqli_fetch_all($result, MYSQLI_ASSOC);
        } else { // PDO
            return $result->fetchAll(PDO::FETCH_ASSOC);
        }
    }

    public function fetchAssoc($result)
    {
        if ($this->driver === 'mysqli') {
            return mysqli_fetch_assoc($result);
        } else { // PDO
            return $result->fetch(PDO::FETCH_ASSOC);
        }
    }
    
    public function fetchRow($result)
    {
        if ($this->driver === 'mysqli') {
            return mysqli_fetch_row($result);
        } else { // PDO
            return $result->fetch(PDO::FETCH_NUM);
        }
    }
    
    public function fetchFields($result)
    {
        if ($this->driver === 'mysqli') {
             return mysqli_fetch_fields($result);
        } else { // PDO
            $fields = [];
            for ($i = 0; $i < $result->columnCount(); $i++) {
                $meta = $result->getColumnMeta($i);
                $field = new stdClass();
                $field->name = $meta['name'];
                $fields[] = $field;
            }
            return $fields;
        }
    }
    
    public function dataSeek($result, $offset) {
        if ($this->driver === 'mysqli') {
            return mysqli_data_seek($result, $offset);
        }
        // PDO is forward-only, this is a limitation we accept for now.
        return true;
    }

    public function getAffectedRows($stmt = null)
    {
        if ($this->driver === 'mysqli') {
            return !is_null($stmt) ? mysqli_stmt_affected_rows($stmt) : mysqli_affected_rows($this->connection);
        } else { // PDO
             return !is_null($stmt) ? $stmt->rowCount() : 0;
        }
    }
    
    public function getLastError($stmt = null) {
        if ($this->driver === 'mysqli') {
            return !is_null($stmt) ? mysqli_stmt_error($stmt) : mysqli_error($this->connection);
        } else { // PDO
            $errorInfo = !is_null($stmt) ? $stmt->errorInfo() : $this->connection->errorInfo();
            return $errorInfo[2] ?? 'Unknown PDO Error';
        }
    }
    
    public function escape($string) {
        if ($this->driver === 'mysqli') {
            return mysqli_real_escape_string($this->connection, $string);
        } else { // PDO
            // PDO's quote() adds quotes, so we need to substr. 
            // This is for simple cases. Prepared statements are always better.
            return substr($this->connection->quote($string), 1, -1);
        }
    }

    public function getServerInfo()
    {
        if ($this->driver === 'mysqli') {
            return mysqli_get_server_info($this->connection);
        } else { // PDO
            return $this->connection->getAttribute(PDO::ATTR_SERVER_VERSION);
        }
    }

    public function getDriver()
    {
        return $this->driver;
    }
    
    public function multiQuery($sql) {
        if ($this->driver === 'mysqli') {
             if (mysqli_multi_query($this->connection, $sql)) {
                do {
                    if ($res = mysqli_store_result($this->connection)) {
                        mysqli_free_result($res);
                    }
                } while (mysqli_more_results($this->connection) && mysqli_next_result($this->connection));
                return true;
            } else {
                return false;
            }
        } else { // PDO
            try {
                 $this->connection->exec($sql);
                 return true;
            } catch(PDOException $e) {
                return false;
            }
        }
    }
}
// ============================================================================


// === FUNGSI BANTU ===
function execute_sql_from_file($db, $filepath, $is_gzipped = false) {
    $sql_content = '';
    if (!file_exists($filepath) || !is_readable($filepath)) {
        return "File tidak ditemukan atau tidak dapat dibaca di server: " . htmlspecialchars($filepath);
    }
    if ($is_gzipped) {
        $zp = gzopen($filepath, "r");
        if (!$zp) return "Gagal membuka file .gz.";
        while (!gzeof($zp)) {
            $sql_content .= gzgets($zp, 8192);
        }
        gzclose($zp);
    } else {
        $sql_content = file_get_contents($filepath);
    }

    if (trim($sql_content) === '') return "File SQL kosong.";

    if ($db->multiQuery($sql_content)) {
        return true;
    } else {
        return "Error impor: " . $db->getLastError();
    }
}


// === MANAJEMEN KONEKSI & SESI ===
$db = null;
$dbConnected = false;
$connectionError = '';
$dbVersion = '';
$activeConnection = null;

if (!isset($_SESSION['connections'])) {
    $_SESSION['connections'] = [];
}

if (isset($_GET['logout'])) {
    session_destroy();
    header("Location: " . strtok($_SERVER["REQUEST_URI"], '?'));
    exit;
}
if (isset($_GET['disconnect'])) {
    unset($_SESSION['active_connection_id']);
    header("Location: " . strtok($_SERVER["REQUEST_URI"], '?'));
    exit;
}

if ($_SERVER['REQUEST_METHOD'] === 'POST' && !isset($_POST['ajax_action'])) {
    if (isset($_POST['add_connection'])) {
        $id = uniqid();
        $_SESSION['connections'][$id] = [
            'id' => $id,
            'host' => $_POST['dbHost'],
            'user' => $_POST['dbUser'],
            'pass' => $_POST['dbPass'],
            'port' => $_POST['dbPort']
        ];
        // Redirect to connect immediately after adding
        header("Location: " . strtok($_SERVER["REQUEST_URI"], '?') . "?connect=" . $id);
        exit;
    }
    if (isset($_POST['delete_connection'])) {
        unset($_SESSION['connections'][$_POST['conn_id']]);
        header("Location: " . strtok($_SERVER["REQUEST_URI"], '?'));
        exit;
    }
}

if (isset($_GET['connect'])) {
    $conn_id = $_GET['connect'];
    if (isset($_SESSION['connections'][$conn_id])) {
        $_SESSION['active_connection_id'] = $conn_id;
    }
    header("Location: " . strtok($_SERVER["REQUEST_URI"], '?')); // Redirect to clean URL
    exit;
}

// Try to establish a connection if an active one is set
if (isset($_SESSION['active_connection_id']) && isset($_SESSION['connections'][$_SESSION['active_connection_id']])) {
    $activeConnection = $_SESSION['connections'][$_SESSION['active_connection_id']];
    try {
        $db = new Database($activeConnection['host'], $activeConnection['user'], $activeConnection['pass'], $activeConnection['port']);
        $dbConnected = true;
        $dbVersion = $db->getServerInfo();
    } catch (Exception $e) {
        $connectionError = $e->getMessage();
        unset($_SESSION['active_connection_id']);
        $dbConnected = false;
    }
}

// Inisialisasi variabel setelah koneksi
$dbName = $_GET['db'] ?? null;
$tableName = $_GET['table'] ?? null;
$action = $_GET['action'] ?? ($tableName ? 'browse' : ($dbName ? 'tables' : 'databases'));
$message = $_SESSION['message'] ?? '';
unset($_SESSION['message']);

if ($dbConnected && $dbName) {
    $db->selectDb($dbName);
}


// === PENANGANAN PERMINTAAN AJAX (MENGGUNAKAN $db) ===
if ($dbConnected && isset($_POST['ajax_action'])) {
    header('Content-Type: application/json');
    $response = ['status' => 'error', 'message' => 'Aksi tidak valid.'];
    $db->selectDb($_POST['db']);

    switch ($_POST['ajax_action']) {
        case 'update_row':
            $update_table = $_POST['table'];
            $pk_col = $_POST['pk_col'];
            $pk_val = $_POST['pk_val'];
            $data = $_POST['data'];
            
            $set_parts = []; $params = [];
            foreach ($data as $col => $val) { $set_parts[] = "`$col` = ?"; $params[] = $val; }
            $params[] = $pk_val;

            $sql = "UPDATE `$update_table` SET " . implode(', ', $set_parts) . " WHERE `$pk_col` = ?";
            
            try {
                $stmt = $db->prepare($sql);
                $db->execute($stmt, $params);
                if ($db->getAffectedRows($stmt) >= 0) {
                    $response = ['status' => 'success', 'message' => 'Baris berhasil diperbarui.'];
                }
            } catch (Exception $e) {
                $response['message'] = 'Gagal memperbarui: ' . $e->getMessage();
            }
            break;

        case 'delete_row':
            $delete_table = $_POST['table'];
            $pk_col = $_POST['pk_col'];
            $pk_val = $_POST['pk_val'];
            $sql = "DELETE FROM `$delete_table` WHERE `$pk_col` = ?";

            try {
                $stmt = $db->prepare($sql);
                $db->execute($stmt, [$pk_val]);
                if ($db->getAffectedRows($stmt) > 0) {
                    $response = ['status' => 'success', 'message' => 'Baris berhasil dihapus.'];
                } else {
                    $response = ['status' => 'error', 'message' => 'Baris tidak ditemukan atau gagal dihapus.'];
                }
            } catch (Exception $e) {
                $response['message'] = 'Gagal menghapus: ' . $e->getMessage();
            }
            break;
    }
    echo json_encode($response);
    exit;
}

// === PENANGANAN AKSI POST (MENGGUNAKAN $db) ===
if ($dbConnected && $_SERVER['REQUEST_METHOD'] === 'POST') {
    $redirectUrl = "?db=" . urlencode($dbName) . ($tableName ? "&table=" . urlencode($tableName) : '');

    // Action on table
    if ($tableName) {
        if (isset($_POST['rename_table'])) {
            $newTableName = $_POST['new_table_name'];
            if ($newTableName && $db->query("RENAME TABLE `$tableName` TO `$newTableName`")) {
                $_SESSION['message'] = "✅ Tabel '$tableName' berhasil diubah namanya menjadi '$newTableName'.";
                header("Location: ?db=".urlencode($dbName)."&table=".urlencode($newTableName)."&action=structure"); exit;
            } else { $_SESSION['message'] = "❌ Error: " . $db->getLastError(); }
        } elseif (isset($_POST['drop_table_confirm'])) {
            if($db->query("DROP TABLE `$tableName`")) {
                $_SESSION['message'] = "✅ Tabel '$tableName' berhasil dihapus.";
                header("Location: ?db=".urlencode($dbName)); exit;
            } else { $_SESSION['message'] = "❌ Error: " . $db->getLastError(); }
        } elseif (isset($_POST['truncate_table_confirm'])) {
            if($db->query("TRUNCATE TABLE `$tableName`")) {
                $_SESSION['message'] = "✅ Tabel '$tableName' berhasil dikosongkan.";
                header("Location: " . $redirectUrl . "&action=browse"); exit;
            } else { $_SESSION['message'] = "❌ Error: " . $db->getLastError(); }
        } elseif (isset($_POST['add_column'])) {
            $col = $_POST['col'];
            $sql = "ALTER TABLE `$tableName` ADD COLUMN `{$col['name']}` {$col['type']}";
            if (!empty($col['length'])) $sql .= "({$col['length']})";
            if (!empty($col['attributes'])) $sql .= " {$col['attributes']}";
            if (!empty($col['collation'])) $sql .= " COLLATE {$col['collation']}";
            $sql .= isset($col['nullable']) ? " NULL" : " NOT NULL";
            
            if (isset($col['default_type'])) {
                switch ($col['default_type']) {
                    case 'defined': $sql .= " DEFAULT '" . $db->escape($col['default_value']) . "'"; break;
                    case 'NULL': $sql .= " DEFAULT NULL"; break;
                    case 'CURRENT_TIMESTAMP': $sql .= " DEFAULT CURRENT_TIMESTAMP"; break;
                }
            }
            
            if (isset($col['auto_increment'])) $sql .= " AUTO_INCREMENT";
            if (!empty($col['after'])) $sql .= $col['after'] == '--FIRST--' ? ' FIRST' : " AFTER `{$col['after']}`";
            
            if($db->query($sql)) {
                $_SESSION['message'] = "✅ Kolom '{$col['name']}' berhasil ditambahkan.";
                if (!empty($col['index']) && $col['index'] != '---') {
                    $indexType = $col['index'];
                    $indexSql = "ALTER TABLE `$tableName` ADD " . ($indexType == 'PRIMARY' ? "PRIMARY KEY" : $indexType) . " (`{$col['name']}`)";
                    if(!$db->query($indexSql)) { $_SESSION['message'] .= " ⚠️ Gagal menambahkan index: " . $db->getLastError(); }
                }
            } else { $_SESSION['message'] = "❌ Gagal menambah kolom: " . $db->getLastError(); }
            header("Location: ?db=".urlencode($dbName)."&table=".urlencode($tableName)."&action=structure"); exit;

        } elseif (isset($_POST['update_column'])) {
            $col = $_POST['col'];
            $original_name = $_POST['original_col_name'];
            $sql = "ALTER TABLE `$tableName` CHANGE COLUMN `{$original_name}` `{$col['name']}` {$col['type']}";
            if (!empty($col['length'])) $sql .= "({$col['length']})";
            if (!empty($col['attributes'])) $sql .= " {$col['attributes']}";
            $sql .= isset($col['nullable']) ? " NULL" : " NOT NULL";
            if ($col['default_type'] == 'defined') $sql .= " DEFAULT '" . $db->escape($col['default_value']) . "'";
            elseif ($col['default_type'] == 'NULL') $sql .= " DEFAULT NULL";
            elseif ($col['default_type'] == 'CURRENT_TIMESTAMP') $sql .= " DEFAULT CURRENT_TIMESTAMP";

            if($db->query($sql)) {
                $_SESSION['message'] = "✅ Kolom '{$original_name}' berhasil diubah.";
            } else { $_SESSION['message'] = "❌ Gagal mengubah kolom: " . $db->getLastError(); }
            header("Location: ?db=".urlencode($dbName)."&table=".urlencode($tableName)."&action=structure"); exit;
        } elseif (isset($_POST['drop_column_confirm'])) {
            $col_to_drop = $_POST['col_to_drop'];
            if($db->query("ALTER TABLE `$tableName` DROP COLUMN `$col_to_drop`")) {
                $_SESSION['message'] = "✅ Kolom '$col_to_drop' berhasil dihapus.";
            } else { $_SESSION['message'] = "❌ Gagal menghapus kolom: " . $db->getLastError(); }
            header("Location: ?db=".urlencode($dbName)."&table=".urlencode($tableName)."&action=structure"); exit;
        }
    }

    if(isset($_POST['insert_data']) && $tableName) {
        $columns = array_keys($_POST['data']);
        $values = array_values($_POST['data']);
        $placeholders = implode(',', array_fill(0, count($columns), '?'));
        $sql = "INSERT INTO `$tableName` (`" . implode('`,`', $columns) . "`) VALUES ($placeholders)";
        
        $stmt = $db->prepare($sql);
        if($db->execute($stmt, $values)){
            $_SESSION['message'] = '✅ 1 baris baru berhasil ditambahkan.';
        } else {
            $_SESSION['message'] = '❌ Gagal menambahkan data: ' . $db->getLastError($stmt);
        }
        header("Location: " . $redirectUrl . "&action=browse"); exit;
    }

    if((isset($_POST['import_sql_upload']) && isset($_FILES['import_file']) && $_FILES['import_file']['error'] == UPLOAD_ERR_OK) || isset($_POST['import_sql_server'])) {
        $is_server_file = isset($_POST['import_sql_server']);
        $filepath = $is_server_file ? $_POST['server_file'] : $_FILES['import_file']['tmp_name'];
        $filename = $is_server_file ? $filepath : $_FILES['import_file']['name'];
        $is_gz = pathinfo($filename, PATHINFO_EXTENSION) == 'gz';
        $result = execute_sql_from_file($db, $filepath, $is_gz);
        $_SESSION['message'] = ($result === true) ? "✅ File '{$filename}' berhasil diimpor." : '❌ ' . $result;
        header("Location: " . $redirectUrl); exit;
    }
}


// === FIND PRIMARY KEY & LOAD DATA (MENGGUNAKAN $db) ===
$primaryKey = null;
if ($dbConnected && $dbName && $tableName) {
    try {
        $keys_res = $db->query("SHOW KEYS FROM `$tableName` WHERE Key_name = 'PRIMARY'");
        if ($pk = $db->fetchAssoc($keys_res)) $primaryKey = $pk['Column_name'];
    } catch (Exception $e) { /* table might not exist yet */ }
}
$databases = []; $tables = [];
if ($dbConnected) {
    $r = $db->query("SHOW DATABASES");
    while ($row = $db->fetchAssoc($r)) $databases[] = $row['Database'];
    if ($dbName) {
        $db->selectDb($dbName);
        $r = $db->query("SHOW TABLES");
        if ($r) while ($row = $db->fetchRow($r)) $tables[] = $row[0];
    }
}

// === EKSPORT (MENGGUNAKAN $db) ===
if ($dbConnected && $action == 'export' && isset($_POST['export_data']) ) {
    $db->selectDb($dbName);
    
    $format = $_POST['format'];
    $type = $_POST['type'];
    
    $filename = $type == 'db' ? $dbName : $tableName;
    header('Content-Type: text/plain; charset=utf-8');
    header('Content-Disposition: attachment; filename="' . htmlspecialchars($filename) . '.' . $format . '"');

    if ($type == 'db') {
        $tables_to_export = [];
        $res = $db->query("SHOW TABLES");
        while($row = $db->fetchRow($res)) $tables_to_export[] = $row[0];

        foreach($tables_to_export as $table_to_export) {
            $create_table_res = $db->query("SHOW CREATE TABLE `$table_to_export`");
            $create_table_row = $db->fetchRow($create_table_res);
            echo $create_table_row[1] . ";\n\n";
            
            $r_data = $db->query("SELECT * FROM `$table_to_export`");
            while($row_data = $db->fetchAssoc($r_data)) {
                $cols = array_keys($row_data);
                $vals = array_map(function($val) use ($db) { return is_null($val) ? 'NULL' : "'" . $db->escape($val) . "'"; }, array_values($row_data));
                echo "INSERT INTO `$table_to_export` (`".implode('`,`', $cols)."`) VALUES (".implode(',', $vals).");\n";
            }
            echo "\n-- --------------------------------------------------------\n\n";
        }
    } else { // Table Export
        if ($format == 'csv') {
            $output = fopen('php://output', 'w');
            $r = $db->query("SELECT * FROM `$tableName`");
            $fields = $db->fetchFields($r);
         if (is_array($fields)) {
    $header = [];
    foreach ($fields as $f) {
			if (is_object($f) && isset($f->name)) {
				$header[] = $f->name;
			} else {
				$header[] = '';
			}
		}
			fputcsv($output, $header);
		} else {
			fputcsv($output, ['No Fields']);
		}
            while ($row = $db->fetchAssoc($r)) fputcsv($output, $row);
            fclose($output);
        } else { // SQL Format
            if ($type == 'structure' || $type == 'all') {
                $create_table_res = $db->query("SHOW CREATE TABLE `$tableName`");
                $create_table_row = $db->fetchRow($create_table_res);
                echo $create_table_row[1] . ";\n\n";
            }
            if ($type == 'data' || $type == 'all') {
                $r = $db->query("SELECT * FROM `$tableName`");
                while($row = $db->fetchAssoc($r)) {
                    $cols = array_keys($row);
                    $vals = array_map(function($val) use ($db) { return is_null($val) ? 'NULL' : "'" . $db->escape($val) . "'"; }, array_values($row));
                    echo "INSERT INTO `$tableName` (`".implode('`,`', $cols)."`) VALUES (".implode(',', $vals).");\n";
                }
            }
        }
    }
    exit;
}
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>DB Tool Pro v4.0 - <?= $activeConnection ? htmlspecialchars($activeConnection['host']) : 'Manajer Koneksi' ?></title>
    <style>
        :root {
            --light-bg: #ffffff; --light-surface: #f7f7f7; --light-primary: #007bff; --light-text: #212529;
            --light-subtle: #6c757d; --light-border: #dee2e6; --light-success: #28a745; --light-error: #dc3545;
            --light-warn: #ffc107; --light-header-bg: #e9ecef;

            --dark-bg: #1e1e2e; --dark-surface: #27293d; --dark-primary: #89b4fa; --dark-text: #cad3f5;
            --dark-subtle: #a6adc8; --dark-border: #414559; --dark-success: #a6e3a1; --dark-error: #f38ba8;
            --dark-warn: #fab387; --dark-header-bg: #363a4f;

            --font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;
        }
        body.light-theme {
            --bg-color: var(--light-bg); --surface-color: var(--light-surface); --primary-color: var(--light-primary);
            --text-color: var(--light-text); --subtle-text-color: var(--light-subtle); --border-color: var(--light-border);
            --success-color: var(--light-success); --error-color: var(--light-error); --warning-color: var(--light-warn);
            --header-bg-color: var(--light-header-bg);
        }
        body.dark-theme {
            --bg-color: var(--dark-bg); --surface-color: var(--dark-surface); --primary-color: var(--dark-primary);
            --text-color: var(--dark-text); --subtle-text-color: var(--dark-subtle); --border-color: var(--dark-border);
            --success-color: var(--dark-success); --error-color: var(--dark-error); --warning-color: var(--dark-warn);
            --header-bg-color: var(--dark-header-bg);
        }
        body { background-color: var(--bg-color); color: var(--text-color); font-family: var(--font-family); padding: 20px; margin: 0; font-size: 14px; transition: background-color 0.3s, color 0.3s; }
        .container { max-width: 95%; margin: 0 auto; }
        .card { background-color: var(--surface-color); border: 1px solid var(--border-color); border-radius: 8px; padding: 25px; margin-top: 20px; box-shadow: 0 4px 12px rgba(0,0,0,0.05); }
        input, select, textarea, button, .btn { background-color: var(--bg-color); color: var(--text-color); border: 1px solid var(--border-color); padding: 10px 12px; margin: 5px; border-radius: 6px; font-family: inherit; font-size: 14px; transition: all 0.2s; }
        input:focus, select:focus, textarea:focus { outline: none; border-color: var(--primary-color); box-shadow: 0 0 0 3px color-mix(in srgb, var(--primary-color) 20%, transparent); }
        button, .btn { cursor: pointer; background-color: var(--primary-color); color: var(--light-bg); border: none; font-weight: 600; text-decoration: none; display: inline-block; }
        button:hover, .btn:hover { opacity: 0.85; }
        body.dark-theme button, body.dark-theme .btn { color: var(--dark-bg); }
        button:disabled { background-color: var(--subtle-text-color); cursor: not-allowed; }
        .btn-danger { background-color: var(--error-color); }
        .btn-secondary { background-color: var(--subtle-text-color); }
        .btn-success { background-color: var(--success-color); }
        h1, h2, h3, h4 { color: var(--primary-color); margin-top: 10px; margin-bottom: 20px; padding-bottom: 10px; border-bottom: 1px solid var(--border-color); }
        table { width: 100%; border-collapse: collapse; margin-top: 20px; }
        th, td { border: 1px solid var(--border-color); padding: 10px 12px; text-align: left; vertical-align: top; word-break: break-word; }
        th { background-color: var(--header-bg-color); color: var(--primary-color); font-weight: 600; }
        tr:nth-child(even) { background-color: color-mix(in srgb, var(--surface-color) 50%, var(--bg-color)); }
        tbody tr:hover { background-color: color-mix(in srgb, var(--primary-color) 10%, transparent); }
        a { color: var(--primary-color); text-decoration: none; } a:hover { text-decoration: underline; }
        .error, .message { padding: 15px; margin: 20px 0; border: 1px solid; border-radius: 6px; }
        .error { background-color: color-mix(in srgb, var(--error-color) 10%, transparent); color: var(--error-color); border-color: var(--error-color); }
        .message { background-color: color-mix(in srgb, var(--success-color) 10%, transparent); color: var(--success-color); border-color: var(--success-color); }
        .header-info { display: flex; justify-content: space-between; align-items: center; flex-wrap: wrap; gap: 15px; }
        .server-details { color: var(--subtle-text-color); font-size: 0.9em; } .server-details b { color: var(--text-color); }
        .form-row { display: flex; align-items: center; gap: 10px; flex-wrap: wrap; margin-bottom: 15px; }
        .action-toolbar { display: flex; gap: 5px; background-color: color-mix(in srgb, var(--bg-color) 50%, var(--surface-color)); padding: 10px; border-radius: 6px; flex-wrap: wrap; }
        .action-toolbar a.btn { background-color: var(--subtle-text-color); color: var(--light-bg); }
        body.dark-theme .action-toolbar a.btn { color: var(--dark-bg); }
        .action-toolbar a.btn:hover { opacity: 0.8; }
        .action-toolbar a.btn.active { background-color: var(--primary-color); }
        .modal { display: none; position: fixed; z-index: 1000; left: 0; top: 0; width: 100%; height: 100%; overflow: auto; background-color: rgba(0,0,0,0.5); }
        .modal-content { background-color: var(--surface-color); margin: 10% auto; padding: 20px; border: 1px solid var(--border-color); width: 80%; max-width: 700px; border-radius: 8px; }
        .close-modal { color: var(--subtle-text-color); float: right; font-size: 28px; font-weight: bold; cursor: pointer; }
        .add-column-form .form-row { align-items: flex-end; }
        .add-column-form label { display: block; font-size: 0.85em; margin-bottom: 3px; color: var(--subtle-text-color); }
        .insert-form .form-row { flex-direction: column; align-items: stretch; }
        pre { background-color: var(--surface-color); padding: 15px; border-radius: 6px; border: 1px solid var(--border-color); white-space: pre-wrap; word-break: break-all; }
        .connection-list-item { display:flex; justify-content:space-between; align-items:center; padding:10px; border-bottom:1px solid var(--border-color); }
    </style>
</head>
<body class="light-theme">
<div class="container">

<h1>DB Tool v4.0</h1>

<?php if (!$dbConnected): ?>
    <div class="card">
        <h2>Manajer Koneksi</h2>
        <?php if ($connectionError): ?><p class="error">❌ <?= htmlspecialchars($connectionError) ?></p><?php endif; ?>
        
        <h4>Koneksi Tersimpan</h4>
        <div class="connection-list">
            <?php if (empty($_SESSION['connections'])): ?>
                <p>Belum ada koneksi yang tersimpan.</p>
            <?php else: ?>
                <?php foreach ($_SESSION['connections'] as $conn): ?>
                <div class="connection-list-item">
                    <div>
                        <b><?= htmlspecialchars($conn['user']) ?>@<?= htmlspecialchars($conn['host']) ?>:<?= htmlspecialchars($conn['port']) ?></b>
                    </div>
                    <div>
                        <a href="?connect=<?= $conn['id'] ?>" class="btn btn-success">Connect</a>
                        <form method="post" style="display:inline-block;" onsubmit="return confirm('Yakin ingin menghapus profil koneksi ini?')">
                            <input type="hidden" name="conn_id" value="<?= $conn['id'] ?>">
                            <button type="submit" name="delete_connection" class="btn btn-danger">Hapus</button>
                        </form>
                    </div>
                </div>
                <?php endforeach; ?>
            <?php endif; ?>
        </div>

        <hr style="margin: 30px 0;">
        <h4>Tambah Koneksi Baru</h4>
        <form method="post">
             <div class="form-row"><label for="dbHost" style="width:50px;">Host:</label><input id="dbHost" name="dbHost" value="localhost" required></div>
             <div class="form-row"><label for="dbPort" style="width:50px;">Port:</label><input id="dbPort" name="dbPort" type="number" value="3306" required></div>
             <div class="form-row"><label for="dbUser" style="width:50px;">User:</label><input id="dbUser" name="dbUser" value="root" required></div>
             <div class="form-row"><label for="dbPass" style="width:50px;">Pass:</label><input id="dbPass" type="password" name="dbPass"></div>
            <button type="submit" name="add_connection">Simpan & Hubungkan</button>
        </form>
    </div>
    <div style="text-align:center; margin-top:20px;">
        <a href="?logout=1" class="btn btn-secondary" onclick="return confirm('Yakin ingin logout? Semua profil koneksi yang tersimpan akan dihapus.')">Logout (Hapus Semua Sesi)</a>
    </div>
<?php else: ?>
    <div class="card">
        <div class="header-info">
            <div class="server-details">
                <b>Host:</b> <?= htmlspecialchars($activeConnection['host']) ?>:<?= htmlspecialchars($activeConnection['port']) ?><br>
                <b>User:</b> <?= htmlspecialchars($activeConnection['user']) ?><br>
                <b>Versi Server:</b> <?= htmlspecialchars($dbVersion) ?><br>
                <b>Driver:</b> <span style="color:var(--success-color); font-weight:bold;"><?= strtoupper($db->getDriver()) ?></span> | <b>PHP:</b> <?= phpversion() ?>
            </div>
            <div>
                <button id="theme-switcher" class="btn btn-secondary">🌙 Mode Gelap</button>
                <a href="?disconnect=1" class="btn btn-danger">Disconnect</a>
            </div>
        </div>
        <form method="get" class="form-row" style="margin-top: 20px;">
            <label for="db_select">Database:</label>
            <select name="db" id="db_select" onchange="const tableSelect = document.getElementById('table_select'); if (tableSelect) { tableSelect.value = ''; } this.form.submit();">
                <option value="">-- Pilih Database --</option>
                <?php foreach ($databases as $db_item): ?>
                    <option value="<?= htmlspecialchars($db_item) ?>" <?= ($db_item == $dbName ? 'selected' : '') ?>><?= htmlspecialchars($db_item) ?></option>
                <?php endforeach; ?>
            </select>
            <?php if ($dbName && !empty($tables)): ?>
                <label for="table_select">Tabel:</label>
                <select name="table" id="table_select" onchange="this.form.submit()">
                    <option value="">-- Pilih Tabel --</option>
                    <?php foreach ($tables as $table): ?>
                        <option value="<?= htmlspecialchars($table) ?>" <?= ($table == $tableName ? 'selected' : '') ?>><?= htmlspecialchars($table) ?></option>
                    <?php endforeach; ?>
                </select>
            <?php endif; ?>
        </form>
    </div>

    <?php if ($message): ?><p class="<?= strpos($message, '❌') !== false || strpos($message, '⚠️') !== false ? 'error' : 'message' ?>"><?= $message ?></p><?php endif; ?>
    
    <?php if ($dbName && !$tableName): // Database level toolbar ?>
        <div class="card" style="padding: 15px;">
             <div class="action-toolbar">
                <a href="?db=<?=urlencode($dbName)?>" class="btn <?= $action == 'tables' ? 'active' : '' ?>">Tabel</a>
                <a href="?db=<?=urlencode($dbName)?>&action=sql" class="btn <?= $action == 'sql' ? 'active' : '' ?>">SQL</a>
                <a href="?db=<?=urlencode($dbName)?>&action=users" class="btn <?= ($action == 'users' || $action == 'edit_privileges') ? 'active' : '' ?>">Pengguna</a>
                <a href="?db=<?=urlencode($dbName)?>&action=import" class="btn <?= $action == 'import' ? 'active' : '' ?>">Impor</a>
                <a href="?db=<?=urlencode($dbName)?>&action=export" class="btn <?= $action == 'export' ? 'active' : '' ?>">Ekspor</a>
             </div>
        </div>
    <?php endif; ?>


    <?php if ($dbName && $tableName): // Table level toolbar ?>
        <div class="card" style="padding: 15px;">
             <h2>Tabel: `<?= htmlspecialchars($tableName) ?>`</h2>
             <div class="action-toolbar">
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=browse" class="btn <?= $action == 'browse' ? 'active' : '' ?>">Data</a>
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=structure" class="btn <?= ($action == 'structure' || $action == 'edit_column' || $action == 'drop_column') ? 'active' : '' ?>">Struktur</a>
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=sql" class="btn <?= $action == 'sql' ? 'active' : '' ?>">SQL</a>
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=insert" class="btn <?= $action == 'insert' ? 'active' : '' ?>">Entri Baru</a>
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=export" class="btn <?= $action == 'export' ? 'active' : '' ?>">Ekspor</a>
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=import" class="btn <?= $action == 'import' ? 'active' : '' ?>">Impor</a>
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=operations" class="btn <?= $action == 'operations' ? 'active' : '' ?>">Operasi</a>
             </div>
        </div>
    <?php endif; ?>

    <div class="card">
    <?php 
    // Main content switch based on action
    switch($action):
    
    case 'tables':
    case 'databases':
        ?>
        <h2>Database: `<?= htmlspecialchars($dbName) ?>`</h2>
        <table><thead><tr><th>Nama Tabel (<?= count($tables) ?>)</th><th>Aksi</th></tr></thead><tbody>
        <?php foreach ($tables as $table): ?>
        <tr>
            <td><a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($table)?>"><?= htmlspecialchars($table) ?></a></td>
            <td>
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($table)?>&action=browse">Data</a> |
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($table)?>&action=structure">Struktur</a> |
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($table)?>&action=operations" style="color:var(--error-color);">Operasi</a>
            </td>
        </tr>
        <?php endforeach; ?>
        </tbody></table>
        <?php
    break;
        
    case 'structure':
        $columns_res = $db->query("SHOW FULL COLUMNS FROM `$tableName`");
        ?>
        <h3>Struktur Kolom - `<?= htmlspecialchars($tableName) ?>`</h3>
        <table><thead><tr><th>Nama</th><th>Tipe</th><th>Collation</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th><th>Aksi</th></tr></thead><tbody>
        <?php while($row = $db->fetchAssoc($columns_res)): ?>
        <tr>
            <td><?=htmlspecialchars($row['Field'])?></td>
            <td><?=htmlspecialchars($row['Type'])?></td>
            <td><?=htmlspecialchars($row['Collation'])?></td>
            <td><?=htmlspecialchars($row['Null'])?></td>
            <td><?=htmlspecialchars($row['Key'])?></td>
            <td><?=htmlspecialchars($row['Default'])?></td>
            <td><?=htmlspecialchars($row['Extra'])?></td>
            <td>
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=edit_column&col=<?=urlencode($row['Field'])?>" class="btn btn-secondary" style="padding: 5px 8px;">Ubah</a>
                <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=drop_column&col=<?=urlencode($row['Field'])?>" class="btn btn-danger" style="padding: 5px 8px;" onclick="return confirm('Yakin ingin menghapus kolom <?= htmlspecialchars($row['Field']) ?>?')">Hapus</a>
            </td>
        </tr>
        <?php endwhile; ?>
        </tbody></table>
        
        <hr style="margin: 30px 0;">
        <h4>Tambah Kolom Baru</h4>
        <form method="post" class="add-column-form">
            <input type="hidden" name="add_column" value="1">
            <div class="form-row">
                <div><label>Nama</label><input type="text" name="col[name]" required></div>
                <div><label>Tipe</label><input type="text" name="col[type]" value="VARCHAR" required></div>
                <div><label>Panjang/Nilai</label><input type="text" name="col[length]" value="255"></div>
                <div><label>Default</label><select name="col[default_type]"><option value="none">None</option><option value="defined">Sesuai Definisi</option><option value="NULL">NULL</option><option value="CURRENT_TIMESTAMP">CURRENT_TIMESTAMP</option></select></div>
                <div><label>Value Default</label><input type="text" name="col[default_value]"></div>
                <div><label>Collation</label><input type="text" name="col[collation]"></div>
                <div><label>Atribut</label><select name="col[attributes]"><option value=""></option><option>BINARY</option><option>UNSIGNED</option><option>UNSIGNED ZEROFILL</option></select></div>
                <div><label>Null</label><input type="checkbox" name="col[nullable]" style="height: 30px;"></div>
                <div><label>Index</label><select name="col[index]"><option>---</option><option>PRIMARY</option><option>UNIQUE</option><option>INDEX</option></select></div>
                <div><label>A_I</label><input type="checkbox" name="col[auto_increment]" style="height: 30px;"></div>
                <div><label>Posisi</label><select name="col[after]"><option value="--FIRST--">Di Awal Tabel</option><?php $db->dataSeek($columns_res, 0); while($c = $db->fetchAssoc($columns_res)) echo "<option value='".htmlspecialchars($c['Field'])."'>Setelah ".htmlspecialchars($c['Field'])."</option>"; ?></select></div>
                <button type="submit" class="btn-success">Tambah</button>
            </div>
        </form>
        <?php
    break;
    
    case 'edit_column':
        $col_name = $_GET['col'];
        $col_res = $db->query("SHOW FULL COLUMNS FROM `$tableName` WHERE Field = '".$db->escape($col_name)."'");
        $column = $db->fetchAssoc($col_res);
        preg_match('/([a-z]+)(?:\(([0-9,]+)\))?/', $column['Type'], $type_parts);
        $col_type = $type_parts[1] ?? '';
        $col_length = $type_parts[2] ?? '';
        ?>
        <h3>Ubah Kolom `<?= htmlspecialchars($col_name) ?>`</h3>
        <form method="post">
            <input type="hidden" name="update_column" value="1">
            <input type="hidden" name="original_col_name" value="<?= htmlspecialchars($column['Field']) ?>">
            <div class="form-row"><label style="width:120px;">Nama Kolom:</label><input type="text" name="col[name]" value="<?= htmlspecialchars($column['Field']) ?>" required></div>
            <div class="form-row"><label style="width:120px;">Tipe:</label><input type="text" name="col[type]" value="<?= htmlspecialchars(strtoupper($col_type)) ?>" required></div>
            <div class="form-row"><label style="width:120px;">Panjang/Nilai:</label><input type="text" name="col[length]" value="<?= htmlspecialchars($col_length) ?>"></div>
            <div class="form-row"><label style="width:120px;">Default:</label>
                <select name="col[default_type]">
                    <option value="none" <?= is_null($column['Default']) && $column['Null'] == 'NO' ? 'selected' : '' ?>>None</option>
                    <option value="defined" <?= !is_null($column['Default']) && $column['Default'] != 'CURRENT_TIMESTAMP' ? 'selected' : '' ?>>Sesuai Definisi</option>
                    <option value="NULL" <?= is_null($column['Default']) && $column['Null'] == 'YES' ? 'selected' : '' ?>>NULL</option>
                    <option value="CURRENT_TIMESTAMP" <?= $column['Default'] == 'CURRENT_TIMESTAMP' ? 'selected' : '' ?>>CURRENT_TIMESTAMP</option>
                </select>
            </div>
            <div class="form-row"><label style="width:120px;">Value Default:</label><input type="text" name="col[default_value]" value="<?= htmlspecialchars($column['Default']) ?>"></div>
            <div class="form-row"><label style="width:120px;">Nullable:</label><input type="checkbox" name="col[nullable]" <?= $column['Null'] == 'YES' ? 'checked' : '' ?>></div>
            <button type="submit" class="btn-success">Simpan</button>
        </form>
        <?php
    break;

    case 'drop_column':
        ?>
        <h3>Hapus Kolom</h3>
        <p>Apakah Anda yakin ingin menghapus kolom `<?= htmlspecialchars($_GET['col']) ?>` dari tabel `<?= htmlspecialchars($tableName) ?>`?</p>
        <form method="post">
            <input type="hidden" name="drop_column_confirm" value="1">
            <input type="hidden" name="col_to_drop" value="<?= htmlspecialchars($_GET['col']) ?>">
            <a href="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=structure" class="btn btn-secondary">Batal</a>
            <button type="submit" class="btn-danger">Ya, Hapus Kolom</button>
        </form>
        <?php
    break;

    case 'users':
        $users = [];
        try {
            $res = $db->query("SELECT User, Host FROM mysql.user ORDER BY User, Host");
            if ($res) {
                while($row = $db->fetchAssoc($res)) {
                    $users[] = $row;
                }
            } else {
                echo "<p class='error'>❌ Tidak dapat mengambil daftar pengguna. Pengguna saat ini mungkin tidak memiliki hak akses ke database `mysql`.</p>";
            }
        } catch (Exception $e) {
            echo "<p class='error'>❌ Error: " . $e->getMessage() . "</p>";
        }
        ?>
        <h3>Daftar Pengguna Server</h3>
        <table>
            <thead><tr><th>Username</th><th>Host</th><th>Aksi</th></tr></thead>
            <tbody>
            <?php foreach($users as $user): ?>
                <tr>
                    <td><?= htmlspecialchars($user['User']) ?></td>
                    <td><?= htmlspecialchars($user['Host']) ?></td>
                    <td><a href="?db=<?=urlencode($dbName)?>&action=edit_privileges&user=<?=urlencode($user['User'])?>&host=<?=urlencode($user['Host'])?>">Lihat Hak Akses</a></td>
                </tr>
            <?php endforeach; ?>
            </tbody>
        </table>
        
        <hr style="margin: 30px 0;">
        <h4>Kerangka: Tambah Pengguna Baru (Contoh)</h4>
        <p><strong>Peringatan:</strong> Fungsionalitas di bawah ini adalah contoh kerangka. Mengelola pengguna dan hak akses secara programatik memiliki risiko keamanan. Pastikan Anda mengerti perintah SQL yang dijalankan.</p>
        <form method="post" onsubmit="alert('Fungsionalitas ini belum diaktifkan.'); return false;">
             <div class="form-row">
                <label>Username:</label><input type="text" name="new_user[name]" required>
                <label>Host:</label><input type="text" name="new_user[host]" value="localhost" required>
                <label>Password:</label><input type="password" name="new_user[pass]" required>
                <button type="submit" disabled>Tambah Pengguna (Non-aktif)</button>
             </div>
             <pre style="font-size:0.9em;">Contoh query:
CREATE USER 'user'@'host' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON `nama_database`.* TO 'user'@'host';
FLUSH PRIVILEGES;</pre>
        </form>
        <?php
    break;
    
    case 'edit_privileges':
        $grant_user = $_GET['user'];
        $grant_host = $_GET['host'];
        $grants = [];
        try {
            // Escaping is crucial here, even though it's from the trusted user list
            $escaped_user = $db->escape($grant_user);
            $escaped_host = $db->escape($grant_host);
            $res = $db->query("SHOW GRANTS FOR '{$escaped_user}'@'{$escaped_host}'");
            if ($res) {
                while($row = $db->fetchRow($res)) {
                    $grants[] = $row[0];
                }
            } else {
                 echo "<p class='error'>❌ Gagal mengambil hak akses.</p>";
            }
        } catch (Exception $e) {
            echo "<p class='error'>❌ Error: " . $e->getMessage() . "</p>";
        }
        ?>
        <h3>Hak Akses untuk <code><?= htmlspecialchars($grant_user) ?>@<?= htmlspecialchars($grant_host) ?></code></h3>
        <p>Daftar di bawah ini adalah perintah `GRANT` yang mendefinisikan hak akses untuk pengguna ini.</p>
        <pre><?php
            foreach($grants as $grant) {
                echo htmlspecialchars($grant) . "\n";
            }
        ?></pre>
        <a href="?db=<?=urlencode($dbName)?>&action=users" class="btn btn-secondary">Kembali ke Daftar Pengguna</a>
        <?php
    break;

    case 'export':
        ?>
        <h3>Ekspor</h3>
        <form method="post" action="?db=<?=urlencode($dbName)?>&table=<?=urlencode($tableName)?>&action=export">
             <div class="form-row"><label>Jenis Ekspor:</label>
                <select name="type">
                    <?php if ($tableName): ?>
                    <option value="all">Struktur dan Data Tabel</option>
                    <option value="structure">Hanya Struktur Tabel</option>
                    <option value="data">Hanya Data Tabel</option>
                    <?php endif; ?>
                    <option value="db">Seluruh Database</option>
                </select>
            </div>
            <div class="form-row"><label>Format:</label><select name="format"><option value="sql">SQL</option><option value="csv" <?= !$tableName ? 'disabled' : ''?>>CSV (Hanya data tabel)</option></select></div>
            <button type="submit" name="export_data">Ekspor</button>
        </form>
        <?php
    break;

    case 'import': ?>
        <h3>Impor ke `<?= $tableName ? 'Tabel ' . htmlspecialchars($tableName) : 'Database ' . htmlspecialchars($dbName) ?>`</h3>
        <p>Pilih file <code>.sql</code> atau <code>.sql.gz</code> untuk diimpor.</p>
        
        <h4>Unggah File dari Komputer</h4>
        <form method="post" enctype="multipart/form-data">
            <input type="hidden" name="import_sql_upload" value="1">
            <input type="file" name="import_file" accept=".sql,.gz,.sql.gz">
            <button type="submit">Impor</button>
        </form>

        <hr style="margin: 30px 0;">

        <h4>Impor dari File di Server</h4>
        <p>Letakkan file di direktori yang sama dengan skrip ini. Contoh: <code>backup.sql.gz</code></p>
        <form method="post">
            <input type="hidden" name="import_sql_server" value="1">
            <input type="text" name="server_file" placeholder="namafile.sql.gz">
            <button type="submit">Impor dari Server</button>
        </form>
    <?php
    break;
    
    case 'operations':
        ?>
        <h3>Operasi untuk Tabel `<?= htmlspecialchars($tableName) ?>`</h3>
        <div class="card" style="margin-top:10px;">
            <h4>Ubah Nama Tabel</h4>
            <form method="post" class="form-row">
                <input type="hidden" name="rename_table" value="1">
                <label>Ubah nama menjadi:</label>
                <input type="text" name="new_table_name" value="<?= htmlspecialchars($tableName) ?>" required>
                <button type="submit">Kirim</button>
            </form>
        </div>
        <div class="card" style="margin-top:10px;">
            <h4>Kosongkan Tabel (TRUNCATE)</h4>
            <p>Aksi ini akan menghapus semua data di dalam tabel, tetapi struktur tabel tetap ada. <b>Aksi ini tidak dapat dibatalkan.</b></p>
            <form method="post" onsubmit="return confirm('ANDA YAKIN ingin mengosongkan tabel ini?')">
                <input type="hidden" name="truncate_table_confirm" value="1">
                <button type="submit" class="btn-danger">Kosongkan Tabel</button>
            </form>
        </div>
        <div class="card" style="margin-top:10px;">
            <h4>Hapus Tabel (DROP)</h4>
            <p>Aksi ini akan menghapus tabel beserta seluruh datanya. <b>Aksi ini tidak dapat dibatalkan.</b></p>
            <form method="post" onsubmit="return confirm('ANDA YAKIN ingin menghapus tabel ini selamanya?')">
                <input type="hidden" name="drop_table_confirm" value="1">
                <button type="submit" class="btn-danger">Hapus Tabel</button>
            </form>
        </div>
        <?php
    break;
    
    case 'sql':
        $sql_query = $_POST['sql_query'] ?? ($tableName ? "SELECT * FROM `$tableName` LIMIT 100;" : "SHOW DATABASES;");
        $query_result = null;
        $query_error = '';
        $affected_rows = null;
        $result_headers = [];
        $result_data = [];

        if (isset($_POST['run_sql'])) {
            try {
                // Use a generic query method that can return boolean or result set
                $res = $db->query($sql_query);
                if (is_object($res)) { // It's a result set from SELECT, SHOW, etc.
                    $fields = $db->fetchFields($res);
                    foreach($fields as $field) {
                        $result_headers[] = $field->name;
                    }
                    while($row = $db->fetchAssoc($res)) {
                        $result_data[] = $row;
                    }
                } else { // It was an action query (INSERT, UPDATE, DELETE)
                     $affected_rows = $db->getAffectedRows();
                }
            } catch (Exception $e) {
                $query_error = $e->getMessage();
            }
        }
        ?>
        <h3>Jalankan Perintah SQL</h3>
        <form method="post">
            <input type="hidden" name="run_sql" value="1">
            <textarea name="sql_query" style="width: 98%; height: 150px; font-family: monospace;"><?= htmlspecialchars($sql_query) ?></textarea>
            <button type="submit" class="btn-success" style="margin-top: 10px;">Jalankan</button>
        </form>
        <?php if ($query_error): ?>
            <p class="error">❌ <?= htmlspecialchars($query_error) ?></p>
        <?php elseif(isset($_POST['run_sql'])): ?>
            <?php if (!is_null($affected_rows)): ?>
                <p class="message">✅ Query berhasil. <?= $affected_rows ?> baris terpengaruh.</p>
            <?php else: ?>
                <p class="message">✅ Query berhasil. Menampilkan <?= count($result_data) ?> hasil.</p>
                <div style="overflow-x:auto;"><table>
                    <thead><tr><?php foreach($result_headers as $h) echo "<th>".htmlspecialchars($h)."</th>"; ?></tr></thead>
                    <tbody><?php foreach($result_data as $r): ?>
                        <tr><?php foreach($r as $cell) echo "<td>".htmlspecialchars($cell)."</td>"; ?></tr>
                    <?php endforeach; ?></tbody>
                </table></div>
            <?php endif; ?>
        <?php endif; ?>
        <?php
    break;

    case 'insert':
        $columns_res = $db->query("SHOW FULL COLUMNS FROM `$tableName`");
        ?>
        <h3>Entri Baru ke Tabel `<?= htmlspecialchars($tableName) ?>`</h3>
        <form method="post" class="insert-form">
            <input type="hidden" name="insert_data" value="1">
            <?php while($col = $db->fetchAssoc($columns_res)): ?>
            <div class="form-row">
                <label for="insert-<?= htmlspecialchars($col['Field']) ?>">
                    <b><?= htmlspecialchars($col['Field']) ?></b><br>
                    <small style="color:var(--subtle-text-color);"><?= htmlspecialchars($col['Type']) ?></small>
                </label>
                <?php if(strpos(strtolower($col['Type']), 'text') !== false): ?>
                    <textarea id="insert-<?= htmlspecialchars($col['Field']) ?>" name="data[<?= htmlspecialchars($col['Field']) ?>]" rows="3"></textarea>
                <?php else: ?>
                    <input id="insert-<?= htmlspecialchars($col['Field']) ?>" type="text" name="data[<?= htmlspecialchars($col['Field']) ?>]">
                <?php endif; ?>
            </div>
            <?php endwhile; ?>
            <button type="submit" class="btn-success">Kirim</button>
        </form>
        <?php
    break;

    case 'browse':
    default:
        $search_col = $_GET['search_col'] ?? '';
        $search_op = $_GET['search_op'] ?? 'LIKE %%';
        $search_val = $_GET['search_val'] ?? '';
        $sort_col = $_GET['sort_col'] ?? $primaryKey ?? '';
        $sort_dir = $_GET['sort_dir'] ?? 'ASC';
        $limit = isset($_GET['limit']) ? (int)$_GET['limit'] : 50;
        $page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
        $offset = ($page - 1) * $limit;

        $whereClause = ""; $params = [];
        if ($search_col && $search_val !== '') {
             $op = $search_op;
             if ($op == 'LIKE %%') { $op = 'LIKE'; $bind_val = "%$search_val%"; }
             else { $bind_val = $search_val; }
             $whereClause = "WHERE `$search_col` $op ?";
             $params[] = $bind_val;
        }
        
        $totalRows_query = "SELECT COUNT(*) FROM `$tableName`" . ($whereClause ? " ".str_replace('?', "'".$db->escape(end($params))."'", $whereClause) : "");
        $totalRows_res = $db->query($totalRows_query);
        $totalRows = $db->fetchRow($totalRows_res)[0];
        $totalPages = $limit > 0 ? ceil($totalRows / $limit) : 1;

        $query = "SELECT * FROM `$tableName` $whereClause " . ($sort_col ? "ORDER BY `$sort_col` $sort_dir" : "") . " LIMIT $limit OFFSET $offset";
        
        $data = [];
        try {
            $stmt = $db->prepare($query);
            $db->execute($stmt, $params);
            $result = $db->getResult($stmt);
            $data = $db->fetchAllAssoc($result);
        } catch (Exception $e) {
            echo "<p class='error'>❌ Query Gagal: ".htmlspecialchars($e->getMessage())."</p>";
        }
        ?>
        <form method="get">
            <input type="hidden" name="db" value="<?= htmlspecialchars($dbName) ?>">
            <input type="hidden" name="table" value="<?= htmlspecialchars($tableName) ?>">
            <input type="hidden" name="action" value="browse">
            <div class="form-row">
                <label>Cari:</label>
                <select name="search_col">
                    <?php $columns_res = $db->query("SHOW COLUMNS FROM `$tableName`"); while($c = $db->fetchAssoc($columns_res)) echo "<option ".($c['Field']==$search_col?'selected':'').">".htmlspecialchars($c['Field'])."</option>"; ?>
                </select>
                <select name="search_op">
                    <?php $ops = ['LIKE %%', '=', '!=', '>', '<', '>=', '<=']; foreach($ops as $o) echo "<option ".($o==$search_op?'selected':'').">".htmlspecialchars($o)."</option>"; ?>
                </select>
                <input type="text" name="search_val" value="<?= htmlspecialchars($search_val) ?>">
                <label>Urutkan:</label>
                <select name="sort_col">
                     <?php $db->dataSeek($columns_res, 0); while($c = $db->fetchAssoc($columns_res)) echo "<option ".($c['Field']==$sort_col?'selected':'').">".htmlspecialchars($c['Field'])."</option>"; ?>
                </select>
                <select name="sort_dir"><option <?= $sort_dir=='ASC'?'selected':''?>>ASC</option><option <?= $sort_dir=='DESC'?'selected':''?>>DESC</option></select>
                <label>Limit:</label>
                <input type="number" name="limit" value="<?= $limit ?>" style="width: 70px;">
                <button type="submit">Filter</button>
            </div>
        </form>
        <p>Menampilkan <b><?= count($data) ?></b> baris (Total: <?= $totalRows ?>, Halaman: <?= $page ?> dari <?= $totalPages ?>)</p>
        
        <div style="overflow-x:auto;">
        <table><thead><tr><th>No.</th><th>Aksi</th>
        <?php if(!empty($data)) foreach(array_keys($data[0]) as $header) echo "<th>".htmlspecialchars($header)."</th>"; ?>
        </tr></thead><tbody id="data-tbody">
        <?php $i = 0; foreach($data as $row): ?>
            <tr id="row-<?= htmlspecialchars($primaryKey ? $row[$primaryKey] : $i) ?>">
                <td><?= $offset + $i + 1 ?></td>
                <td>
                    <?php if($primaryKey): ?>
                    <button type="button" class="btn-secondary" style="padding: 5px 8px;" onclick="editRow(this, '<?= htmlspecialchars($row[$primaryKey]) ?>')">Edit</button>
                    <button type="button" class="btn-danger" style="padding: 5px 8px;" onclick="deleteRow(this, '<?= htmlspecialchars($row[$primaryKey]) ?>')">Hapus</button>
                    <?php else: echo "No PK"; endif; ?>
                </td>
                <?php foreach($row as $col => $cell): ?>
                    <td data-colname="<?= htmlspecialchars($col) ?>" data-pk-val="<?= htmlspecialchars($primaryKey ? $row[$primaryKey] : '') ?>">
                        <div class="cell-content" style="max-height:100px; overflow-y:auto;"><?= nl2br(htmlspecialchars($cell ?? 'NULL')) ?></div>
                    </td>
                <?php endforeach; ?>
            </tr>
        <?php $i++; endforeach; ?>
        </tbody></table>
        </div>
        <?php
    break;
    endswitch;
    ?>
    </div>
<?php endif; ?>
</div>

<div id="editModal" class="modal">
  <div class="modal-content">
    <span class="close-modal" onclick="closeModal()">&times;</span>
    <h3>Edit Baris</h3>
    <form id="editForm">
      <input type="hidden" id="edit-pk-val" name="pk_val">
      <div id="edit-fields"></div>
      <button type="submit" class="btn-success">Simpan Perubahan</button>
    </form>
  </div>
</div>

<script>
document.addEventListener('DOMContentLoaded', () => {
    const themeSwitcher = document.getElementById('theme-switcher');
    if (themeSwitcher) {
        const body = document.body;
        themeSwitcher.addEventListener('click', () => {
            body.classList.toggle('dark-theme');
            body.classList.toggle('light-theme');
            const isDark = body.classList.contains('dark-theme');
            themeSwitcher.textContent = isDark ? '☀️ Mode Terang' : '🌙 Mode Gelap';
            localStorage.setItem('theme', isDark ? 'dark' : 'light');
        });
        const savedTheme = localStorage.getItem('theme') || 'light';
        if (savedTheme === 'dark') {
            body.classList.replace('light-theme', 'dark-theme');
            themeSwitcher.textContent = '☀️ Mode Terang';
        }
    }
});

const pk_col = '<?= $primaryKey ?? '' ?>';
const modal = document.getElementById('editModal');
const editForm = document.getElementById('editForm');
const editFields = document.getElementById('edit-fields');
const currentDb = '<?= urlencode($dbName) ?>';
const currentTable = '<?= urlencode($tableName) ?>';

function closeModal() { if(modal) modal.style.display = "none"; }
window.onclick = function(event) { if (event.target == modal) closeModal(); }

function editRow(btn, pk_val) {
    const row = btn.closest('tr');
    editFields.innerHTML = '';
    document.getElementById('edit-pk-val').value = pk_val;
    row.querySelectorAll('td[data-colname]').forEach(cell => {
        const colName = cell.dataset.colname;
        const contentDiv = cell.querySelector('.cell-content');
        const value = contentDiv.innerText.trim() === 'NULL' ? '' : contentDiv.innerText;
        const isPK = colName === pk_col;
        
        let fieldHtml = `<div class="form-row" style="margin-bottom:10px; flex-direction:column; align-items:flex-start;"><label style="font-weight:bold;">${colName}</label>`;
        
        if (isPK) {
            fieldHtml += `<input type="text" value="${value}" disabled class="form-control" style="width: 98%;">`;
        } else {
            const isTextarea = value.length > 80 || value.includes('\n');
            if (isTextarea) {
                 const rowCount = Math.max(3, Math.min(10, (value.match(/\n/g) || []).length + 2));
                 fieldHtml += `<textarea name="data[${colName}]" rows="${rowCount}" style="width: 98%;">${value}</textarea>`;
            } else {
                 fieldHtml += `<input type="text" name="data[${colName}]" value="${value}" style="width: 98%;">`;
            }
        }
        fieldHtml += `</div>`;
        editFields.innerHTML += fieldHtml;
    });
    modal.style.display = "block";
}

if(editForm) {
    editForm.addEventListener('submit', function(e) {
        e.preventDefault();
        const pk_val = document.getElementById('edit-pk-val').value;
        const formData = new FormData(this);
        formData.append('ajax_action', 'update_row');
        formData.append('db', currentDb);
        formData.append('table', currentTable);
        formData.append('pk_col', pk_col);
        formData.append('pk_val', pk_val);

        fetch('<?= basename($_SERVER["SCRIPT_NAME"]) ?>', { method: 'POST', body: formData })
        .then(response => response.json())
        .then(data => {
            if (data.status === 'success') {
                alert('Sukses: ' + data.message);
                window.location.reload(); 
            } else {
                alert('Error: ' + data.message);
            }
        })
        .catch(error => {
            console.error('Fetch Error:', error);
            alert('Request failed. Check console for details.');
        });
    });
}

function deleteRow(btn, pk_val) {
    if (!confirm(`Apakah Anda yakin ingin menghapus baris dengan PK = ${pk_val}?`)) return;

    const formData = new FormData();
    formData.append('ajax_action', 'delete_row');
    formData.append('db', currentDb);
    formData.append('table', currentTable);
    formData.append('pk_col', pk_col);
    formData.append('pk_val', pk_val);
    
    fetch('<?= basename($_SERVER["SCRIPT_NAME"]) ?>', { method: 'POST', body: formData })
    .then(response => response.json())
    .then(data => {
        if (data.status === 'success') {
            const row = document.getElementById(`row-${pk_val}`);
            if (row) {
                row.style.transition = 'opacity 0.5s';
                row.style.opacity = '0';
                setTimeout(() => row.remove(), 500);
            }
            // alert('Sukses: ' + data.message); // Optional: can be annoying
        } else {
            alert('Error: ' .concat(data.message));
        }
    })
    .catch(error => {
        console.error('Fetch Error:', error);
        alert('Request failed. Check console for details.');
    });
}
</script>

</body>
</html>