<?php
/**
 * Gerenciador de Tabelas - PipView
 * Configuração: FTP e Banco de Dados
 */

// ============================================================
//  CONFIGURAÇÕES DO BANCO DE DADOS
// ============================================================

define('DB_HOST', 'pipview_db2026.mysql.dbaas.com.br');
define('DB_NAME', 'pipview_db2026');
define('DB_USER', 'pipview_db2026');
define('DB_PASS', 'Locaweb@102030');
define('DB_CHARSET', 'utf8mb4');

// ============================================================
//  CONFIGURAÇÕES DO FTP
// ============================================================

define('FTP_HOST', 'ftp.pipview.com.br');
define('FTP_USER', 'pipview2');
define('FTP_PASS', 'Locaweb@102030');
define('FTP_PORT', 21);
define('FTP_ROOT', '/home/pipview2/');

// ============================================================
//  CONEXÃO COM O BANCO DE DADOS
// ============================================================

function get_db_connection() {
    try {
        $dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=" . DB_CHARSET;
        $pdo = new PDO($dsn, DB_USER, DB_PASS);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
        return $pdo;
    } catch (PDOException $e) {
        error_log('Erro ao conectar ao banco: ' . $e->getMessage());
        throw new Exception('Erro ao conectar ao banco de dados');
    }
}

// ============================================================
//  FUNÇÕES AUXILIARES
// ============================================================

function get_ftp_connection() {
    $conn = ftp_connect(FTP_HOST, FTP_PORT, 30);
    if (!$conn) {
        throw new Exception('Não foi possível conectar ao FTP: ' . FTP_HOST);
    }
    
    if (!ftp_login($conn, FTP_USER, FTP_PASS)) {
        ftp_close($conn);
        throw new Exception('Falha no login FTP para ' . FTP_HOST);
    }
    
    ftp_pasv($conn, true);
    return $conn;
}

function sanitize($value) {
    return htmlspecialchars($value, ENT_QUOTES, 'UTF-8');
}

function get_table_fields($table) {
    $fields = [
        'users' => ['user_id', 'uuid', 'email', 'full_name', 'company_name', 'phone', 'account_status', 'account_tier', 'created_at', 'last_login'],
        'subscription_plans' => ['plan_id', 'plan_code', 'plan_name', 'description', 'max_cameras', 'max_users', 'max_storage_gb', 'price_monthly', 'price_yearly', 'is_active'],
        'user_subscriptions' => ['subscription_id', 'user_id', 'plan', 'expires_at'],
        'user_cameras' => ['camera_id', 'user_id', 'camera_name', 'stream_url', 'is_active', 'updated_at'],
        'detection_logs' => ['log_id', 'user_id', 'camera_id', 'detection_type', 'confidence', 'zone_name', 'detection_timestamp', 'created_at'],
        'alert_configurations' => ['alert_config_id', 'user_id', 'alert_type', 'is_enabled', 'send_email', 'send_push', 'cooldown_minutes', 'created_at'],
        'notifications' => ['notification_id', 'user_id', 'notification_type', 'title', 'message', 'is_read', 'created_at'],
        'payments' => ['payment_id', 'subscription_id', 'user_id', 'amount', 'currency', 'status', 'payment_gateway', 'paid_at', 'created_at'],
        'coupons' => ['coupon_id', 'code', 'description', 'discount_type', 'discount_value', 'valid_from', 'valid_until', 'max_uses', 'uses_count', 'is_active'],
        'api_keys' => ['api_key_id', 'user_id', 'key_name', 'api_key', 'permissions', 'is_active', 'last_used_at', 'created_at'],
        'webhooks' => ['webhook_id', 'user_id', 'name', 'url', 'events', 'is_active', 'created_at'],
        'usage_metrics' => ['metric_id', 'user_id', 'metric_date', 'detection_count', 'api_requests', 'storage_used_mb', 'created_at'],
        'user_configurations' => ['config_id', 'user_id', 'config_name', 'config_data', 'updated_at'],
        'config_history' => ['history_id', 'config_id', 'user_id', 'change_type', 'changed_by', 'created_at'],
        'system_logs' => ['log_id', 'user_id', 'log_level', 'message', 'created_at'],
        'account_recovery' => ['recovery_id', 'user_id', 'recovery_type', 'recovery_value', 'is_verified', 'created_at'],
        'user_sessions' => ['session_id', 'user_id', 'session_token', 'created_at', 'expires_at']
    ];
    return $fields[$table] ?? [];
}

// ============================================================
//  PROCESSAR AÇÕES
// ============================================================

$message = '';
$messageType = '';

$table = $_GET['table'] ?? 'users';
$action = $_POST['action'] ?? $_GET['action'] ?? '';

try {
    $pdo = get_db_connection();
    
    // Processar ações do formulário
    if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
        $action = $_POST['action'];
        
        switch ($action) {
            case 'insert':
                $fields = get_table_fields($table);
                $setParts = [];
                $params = [];
                
                // Montar consulta de inserção
                foreach ($fields as $field) {
                    if (isset($_POST[$field]) && $field !== 'user_id' && $field !== 'created_at' && $field !== 'updated_at') {
                        $setParts[] = $field . ' = :' . $field;
                        $params[':' . $field] = $_POST[$field];
                    }
                }
                
                if (!empty($setParts)) {
                    $sql = "INSERT INTO $table SET " . implode(', ', $setParts);
                    $stmt = $pdo->prepare($sql);
                    $stmt->execute($params);
                    $message = 'Registro adicionado com sucesso!';
                    $messageType = 'success';
                }
                break;
                
            case 'update':
                $id = $_POST['id'] ?? $_GET['id'] ?? 0;
                $fields = get_table_fields($table);
                $setParts = [];
                $params = [];
                $primaryKey = $fields[0] ?? 'id';
                
                foreach ($fields as $field) {
                    if (isset($_POST[$field]) && $field !== $primaryKey && $field !== 'created_at' && $field !== 'updated_at') {
                        $setParts[] = $field . ' = :' . $field;
                        $params[':' . $field] = $_POST[$field];
                    }
                }
                
                if (!empty($setParts) && $id > 0) {
                    $params[':id'] = $id;
                    $sql = "UPDATE $table SET " . implode(', ', $setParts) . " WHERE $primaryKey = :id";
                    $stmt = $pdo->prepare($sql);
                    $stmt->execute($params);
                    $message = 'Registro atualizado com sucesso!';
                    $messageType = 'success';
                }
                break;
                
            case 'delete':
                $id = $_GET['id'] ?? 0;
                if ($id > 0) {
                    $fields = get_table_fields($table);
                    $primaryKey = $fields[0] ?? 'id';
                    $sql = "DELETE FROM $table WHERE $primaryKey = :id";
                    $stmt = $pdo->prepare($sql);
                    $stmt->execute([':id' => $id]);
                    $message = 'Registro excluído com sucesso!';
                    $messageType = 'success';
                }
                break;
        }
    }
    
    // Buscar dados da tabela
    $fields = get_table_fields($table);
    $primaryKey = $fields[0] ?? 'id';
    
    // Construir query com filtros
    $whereConditions = [];
    $params = [];
    
    foreach ($fields as $field) {
        $filterKey = 'filter_' . $field;
        $filterTypeKey = 'filter_type_' . $field;
        
        if (isset($_GET[$filterKey]) && $_GET[$filterKey] !== '') {
            $value = $_GET[$filterKey];
            $type = $_GET[$filterTypeKey] ?? 'contains';
            
            switch ($type) {
                case 'exact':
                    $whereConditions[] = "$field = :" . $field;
                    $params[':' . $field] = $value;
                    break;
                case 'contains':
                    $whereConditions[] = "$field LIKE :" . $field;
                    $params[':' . $field] = '%' . $value . '%';
                    break;
                case 'starts':
                    $whereConditions[] = "$field LIKE :" . $field;
                    $params[':' . $field] = $value . '%';
                    break;
                case 'ends':
                    $whereConditions[] = "$field LIKE :" . $field;
                    $params[':' . $field] = '%' . $value;
                    break;
                case 'empty':
                    $whereConditions[] = "($field IS NULL OR $field = '')";
                    break;
                case 'not_empty':
                    $whereConditions[] = "($field IS NOT NULL AND $field != '')";
                    break;
            }
        }
    }
    
    $whereClause = !empty($whereConditions) ? 'WHERE ' . implode(' AND ', $whereConditions) : '';
    $sql = "SELECT * FROM $table $whereClause ORDER BY $primaryKey DESC LIMIT 100";
    $stmt = $pdo->prepare($sql);
    $stmt->execute($params);
    $rows = $stmt->fetchAll();
    
} catch (Exception $e) {
    $message = 'Erro: ' . $e->getMessage();
    $messageType = 'error';
    $rows = [];
}
?>
<!DOCTYPE html>
<html lang="pt-BR">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Gerenciar Tabelas - PipView</title>
    <style>
        * { margin: 0; padding: 0; box-sizing: border-box; }
        body {
            font-family: 'Segoe UI', Arial, sans-serif;
            background: #f0f4f8;
            padding: 20px;
        }
        .container {
            max-width: 1400px;
            margin: 0 auto;
            background: white;
            border-radius: 16px;
            box-shadow: 0 10px 30px rgba(0,0,0,0.1);
            overflow: hidden;
            padding: 25px;
        }
        .header {
            background: linear-gradient(135deg, #6f42c1, #4a2a7a);
            color: white;
            padding: 20px 30px;
            margin: -25px -25px 20px -25px;
            display: flex;
            justify-content: space-between;
            align-items: center;
            flex-wrap: wrap;
            gap: 15px;
        }
        .header h1 {
            font-size: 1.5em;
            display: flex;
            align-items: center;
            gap: 10px;
        }
        .header .subtitle {
            font-size: 0.85em;
            opacity: 0.8;
        }
        .header-actions {
            display: flex;
            gap: 10px;
            flex-wrap: wrap;
        }
        .header-actions a, .header-actions button {
            padding: 8px 16px;
            border: none;
            border-radius: 8px;
            font-size: 0.85em;
            font-weight: 600;
            cursor: pointer;
            text-decoration: none;
            transition: all 0.3s;
        }
        .btn-back {
            background: rgba(255,255,255,0.2);
            color: white;
        }
        .btn-back:hover {
            background: rgba(255,255,255,0.3);
        }
        .btn-add {
            background: #28a745;
            color: white;
        }
        .btn-add:hover {
            background: #218838;
            transform: translateY(-2px);
        }
        .btn-clear {
            background: #6c757d;
            color: white;
        }
        .btn-clear:hover {
            background: #5a6268;
        }
        .btn-apply {
            background: #6f42c1;
            color: white;
        }
        .btn-apply:hover {
            background: #5a32a3;
        }
        .alert {
            padding: 12px 18px;
            border-radius: 8px;
            margin-bottom: 20px;
            font-weight: 500;
        }
        .alert-success {
            background: #d4edda;
            color: #155724;
            border: 1px solid #c3e6cb;
        }
        .alert-error {
            background: #f8d7da;
            color: #721c24;
            border: 1px solid #f5c6cb;
        }
        .alert-info {
            background: #d1ecf1;
            color: #0c5460;
            border: 1px solid #bee5eb;
        }
        .selector {
            margin-bottom: 20px;
            display: flex;
            align-items: center;
            gap: 12px;
            flex-wrap: wrap;
        }
        .selector label {
            font-weight: 600;
            color: #333;
        }
        .selector select {
            padding: 8px 14px;
            border: 2px solid #e0e0e0;
            border-radius: 8px;
            font-size: 0.9em;
            background: white;
            min-width: 200px;
            cursor: pointer;
            transition: border-color 0.3s;
        }
        .selector select:focus {
            outline: none;
            border-color: #6f42c1;
        }
        .filters-section {
            background: #f8f9fa;
            padding: 20px;
            border-radius: 12px;
            margin-bottom: 20px;
            border: 1px solid #e9ecef;
        }
        .filters-section h3 {
            margin-bottom: 15px;
            color: #6f42c1;
        }
        .filters-grid {
            display: grid;
            grid-template-columns: repeat(auto-fill, minmax(280px, 1fr));
            gap: 12px;
            margin-bottom: 15px;
        }
        .filter-group {
            display: flex;
            flex-direction: column;
        }
        .filter-label {
            font-weight: 600;
            font-size: 0.8em;
            color: #495057;
            margin-bottom: 4px;
        }
        .filter-row {
            display: flex;
            gap: 6px;
        }
        .filter-input {
            flex: 1;
            padding: 6px 10px;
            border: 1px solid #ced4da;
            border-radius: 6px;
            font-size: 0.85em;
            transition: border-color 0.3s;
            min-width: 0;
        }
        .filter-input:focus {
            outline: none;
            border-color: #6f42c1;
        }
        .filter-select {
            padding: 6px 10px;
            border: 1px solid #ced4da;
            border-radius: 6px;
            font-size: 0.8em;
            background: white;
            cursor: pointer;
        }
        .filter-actions {
            display: flex;
            gap: 10px;
            flex-wrap: wrap;
        }
        .table-container {
            overflow-x: auto;
            border-radius: 8px;
            border: 1px solid #e9ecef;
        }
        table {
            width: 100%;
            border-collapse: collapse;
            font-size: 0.85em;
        }
        th, td {
            padding: 10px 12px;
            border-bottom: 1px solid #e9ecef;
            text-align: left;
            white-space: nowrap;
        }
        th {
            background: #f8f9fa;
            color: #495057;
            font-weight: 600;
            position: sticky;
            top: 0;
            z-index: 10;
        }
        tr:hover {
            background: #f8f9fa;
        }
        .badge {
            display: inline-block;
            padding: 2px 10px;
            border-radius: 20px;
            font-size: 0.75em;
            font-weight: 600;
        }
        .badge-success { background: #d4edda; color: #155724; }
        .badge-warning { background: #fff3cd; color: #856404; }
        .badge-danger { background: #f8d7da; color: #721c24; }
        .badge-info { background: #d1ecf1; color: #0c5460; }
        .badge-secondary { background: #e9ecef; color: #495057; }
        .actions {
            display: flex;
            gap: 4px;
        }
        .btn-icon {
            padding: 4px 8px;
            border: none;
            border-radius: 4px;
            cursor: pointer;
            font-size: 0.85em;
            transition: all 0.2s;
        }
        .btn-icon:hover {
            transform: scale(1.1);
        }
        .btn-edit {
            background: #6f42c1;
            color: white;
        }
        .btn-edit:hover {
            background: #5a32a3;
        }
        .btn-delete {
            background: #dc3545;
            color: white;
        }
        .btn-delete:hover {
            background: #c82333;
        }
        .empty-data {
            padding: 40px;
            text-align: center;
            color: #6c757d;
        }
        .modal {
            display: none;
            position: fixed;
            z-index: 1000;
            left: 0;
            top: 0;
            width: 100%;
            height: 100%;
            background: rgba(0,0,0,0.5);
            justify-content: center;
            align-items: center;
        }
        .modal-content {
            background: white;
            padding: 30px;
            border-radius: 16px;
            width: 90%;
            max-width: 600px;
            max-height: 90vh;
            overflow-y: auto;
            position: relative;
        }
        .modal-close {
            position: absolute;
            right: 20px;
            top: 15px;
            font-size: 1.8em;
            cursor: pointer;
            color: #6c757d;
            transition: color 0.3s;
        }
        .modal-close:hover {
            color: #333;
        }
        .modal h2 {
            color: #6f42c1;
            margin-bottom: 20px;
        }
        .form-group {
            margin-bottom: 15px;
        }
        .form-label {
            display: block;
            font-weight: 600;
            margin-bottom: 4px;
            color: #495057;
            font-size: 0.85em;
        }
        .form-input, .form-select {
            width: 100%;
            padding: 8px 12px;
            border: 1px solid #ced4da;
            border-radius: 6px;
            font-size: 0.9em;
            transition: border-color 0.3s;
        }
        .form-input:focus, .form-select:focus {
            outline: none;
            border-color: #6f42c1;
        }
        .form-row {
            display: grid;
            grid-template-columns: 1fr 1fr;
            gap: 15px;
        }
        .btn-submit {
            background: #6f42c1;
            color: white;
            padding: 10px 24px;
            border: none;
            border-radius: 8px;
            font-size: 1em;
            font-weight: 600;
            cursor: pointer;
            transition: background 0.3s;
        }
        .btn-submit:hover {
            background: #5a32a3;
        }
        .form-textarea {
            width: 100%;
            padding: 8px 12px;
            border: 1px solid #ced4da;
            border-radius: 6px;
            font-size: 0.85em;
            min-height: 80px;
            font-family: monospace;
            resize: vertical;
        }
        .text-muted {
            color: #6c757d;
            font-size: 0.75em;
            margin-top: 2px;
        }
        .info-box {
            background: #e7f3ff;
            padding: 10px 15px;
            border-radius: 8px;
            margin-bottom: 15px;
            border-left: 4px solid #6f42c1;
            font-size: 0.85em;
            color: #333;
        }
        @media (max-width: 768px) {
            .filters-grid {
                grid-template-columns: 1fr;
            }
            .form-row {
                grid-template-columns: 1fr;
            }
            .header {
                flex-direction: column;
                align-items: flex-start;
            }
            .header-actions {
                width: 100%;
            }
            .header-actions a, .header-actions button {
                flex: 1;
                text-align: center;
            }
        }
    </style>
</head>
<body>

<div class="container">
    <!-- Header -->
    <div class="header">
        <div>
            <h1>📊 Gerenciar Tabelas</h1>
            <div class="subtitle">PipView - Gerenciamento de Banco de Dados</div>
        </div>
        <div class="header-actions">
            <a href="dashboard.php" class="btn-back">⬅ Voltar</a>
            <button class="btn-add" onclick="openModal('add')">➕ Adicionar</button>
        </div>
    </div>

    <!-- Mensagens -->
    <?php if ($message): ?>
        <div class="alert alert-<?php echo $messageType === 'success' ? 'success' : 'error'; ?>">
            <?php echo sanitize($message); ?>
        </div>
    <?php endif; ?>

    <!-- Info -->
    <div class="info-box">
        <strong>📌 Banco:</strong> <?php echo DB_NAME; ?> | 
        <strong>📋 Tabela:</strong> <?php echo $table; ?> | 
        <strong>📄 Registros:</strong> <?php echo count($rows); ?>
    </div>

    <!-- Seletor de Tabela -->
    <div class="selector">
        <label for="table-select">Selecione uma Tabela:</label>
        <form method="GET" id="tableForm" style="display:inline;">
            <select id="table-select" name="table" onchange="this.form.submit()">
                <?php
                $tables = [
                    'users' => 'Usuários',
                    'subscription_plans' => 'Planos de Assinatura',
                    'user_subscriptions' => 'Assinaturas',
                    'user_cameras' => 'Câmeras',
                    'detection_logs' => 'Logs de Detecção',
                    'alert_configurations' => 'Configurações de Alertas',
                    'notifications' => 'Notificações',
                    'payments' => 'Pagamentos',
                    'coupons' => 'Cupons',
                    'api_keys' => 'Chaves API',
                    'webhooks' => 'Webhooks',
                    'usage_metrics' => 'Métricas de Uso',
                    'user_configurations' => 'Configurações de Usuários',
                    'config_history' => 'Histórico de Configurações',
                    'system_logs' => 'Logs do Sistema',
                    'account_recovery' => 'Recuperação de Conta',
                    'user_sessions' => 'Sessões de Usuários'
                ];
                foreach ($tables as $key => $label):
                    $selected = ($key === $table) ? 'selected' : '';
                ?>
                    <option value="<?php echo $key; ?>" <?php echo $selected; ?>><?php echo $label; ?></option>
                <?php endforeach; ?>
            </select>
        </form>
    </div>

    <!-- Filtros -->
    <div class="filters-section">
        <h3>🔍 Filtros</h3>
        <form method="GET" id="filterForm">
            <input type="hidden" name="table" value="<?php echo $table; ?>">
            <div class="filters-grid">
                <?php foreach ($fields as $field): ?>
                    <?php if (in_array($field, ['created_at', 'updated_at', 'last_login', 'expires_at'])): ?>
                        <div class="filter-group">
                            <label class="filter-label"><?php echo $field; ?></label>
                            <div class="filter-row">
                                <input type="text" class="filter-input" name="filter_<?php echo $field; ?>" 
                                       placeholder="YYYY-MM-DD" value="<?php echo $_GET['filter_' . $field] ?? ''; ?>">
                                <select class="filter-select" name="filter_type_<?php echo $field; ?>">
                                    <option value="contains" <?php echo ($_GET['filter_type_' . $field] ?? '') === 'contains' ? 'selected' : ''; ?>>Contém</option>
                                    <option value="exact" <?php echo ($_GET['filter_type_' . $field] ?? '') === 'exact' ? 'selected' : ''; ?>>Igual</option>
                                    <option value="empty" <?php echo ($_GET['filter_type_' . $field] ?? '') === 'empty' ? 'selected' : ''; ?>>Vazio</option>
                                    <option value="not_empty" <?php echo ($_GET['filter_type_' . $field] ?? '') === 'not_empty' ? 'selected' : ''; ?>>Preenchido</option>
                                </select>
                            </div>
                        </div>
                    <?php else: ?>
                        <div class="filter-group">
                            <label class="filter-label"><?php echo $field; ?></label>
                            <div class="filter-row">
                                <input type="text" class="filter-input" name="filter_<?php echo $field; ?>" 
                                       placeholder="<?php echo $field; ?>" value="<?php echo $_GET['filter_' . $field] ?? ''; ?>">
                                <select class="filter-select" name="filter_type_<?php echo $field; ?>">
                                    <option value="contains" <?php echo ($_GET['filter_type_' . $field] ?? '') === 'contains' ? 'selected' : ''; ?>>Contém</option>
                                    <option value="exact" <?php echo ($_GET['filter_type_' . $field] ?? '') === 'exact' ? 'selected' : ''; ?>>Igual</option>
                                    <option value="starts" <?php echo ($_GET['filter_type_' . $field] ?? '') === 'starts' ? 'selected' : ''; ?>>Começa</option>
                                    <option value="ends" <?php echo ($_GET['filter_type_' . $field] ?? '') === 'ends' ? 'selected' : ''; ?>>Termina</option>
                                    <option value="empty" <?php echo ($_GET['filter_type_' . $field] ?? '') === 'empty' ? 'selected' : ''; ?>>Vazio</option>
                                    <option value="not_empty" <?php echo ($_GET['filter_type_' . $field] ?? '') === 'not_empty' ? 'selected' : ''; ?>>Preenchido</option>
                                </select>
                            </div>
                        </div>
                    <?php endif; ?>
                <?php endforeach; ?>
            </div>
            <div class="filter-actions">
                <button type="submit" class="btn-apply">🔍 Aplicar Filtros</button>
                <a href="?table=<?php echo $table; ?>" class="btn-clear">🗑️ Limpar</a>
            </div>
        </form>
    </div>

    <!-- Tabela -->
    <div class="table-container">
        <table>
            <thead>
                <tr>
                    <th style="min-width:80px;">Ações</th>
                    <?php foreach ($fields as $field): ?>
                        <th><?php echo $field; ?></th>
                    <?php endforeach; ?>
                </tr>
            </thead>
            <tbody>
                <?php if (empty($rows)): ?>
                    <tr>
                        <td colspan="<?php echo count($fields) + 1; ?>" class="empty-data">
                            📭 Nenhum registro encontrado
                        </td>
                    </tr>
                <?php else: ?>
                    <?php foreach ($rows as $row): ?>
                        <tr>
                            <td class="actions">
                                <button class="btn-icon btn-edit" onclick='openModal("edit", <?php echo json_encode($row); ?>)'>✏️</button>
                                <button class="btn-icon btn-delete" onclick="deleteRecord('<?php echo $table; ?>', '<?php echo $row[$primaryKey]; ?>')">🗑️</button>
                            </td>
                            <?php foreach ($fields as $field): ?>
                                <td>
                                    <?php 
                                    $value = $row[$field] ?? '';
                                    if ($value === '') echo '<span class="badge badge-secondary">NULL</span>';
                                    else echo sanitize($value);
                                    ?>
                                </td>
                            <?php endforeach; ?>
                        </tr>
                    <?php endforeach; ?>
                <?php endif; ?>
            </tbody>
        </table>
    </div>

    <div style="margin-top: 15px; text-align: center; color: #6c757d; font-size: 0.8em;">
        PipView &copy; <?php echo date('Y'); ?> - Todos os direitos reservados
    </div>
</div>

<!-- Modal -->
<div id="recordModal" class="modal">
    <div class="modal-content">
        <span class="modal-close" onclick="closeModal()">&times;</span>
        <h2 id="modal-title"></h2>
        <form id="recordForm" method="POST" action="">
            <input type="hidden" name="table" value="<?php echo $table; ?>">
            <input type="hidden" name="action" id="form-action">
            <input type="hidden" name="id" id="form-id" value="">
            
            <div id="form-fields">
                <?php foreach ($fields as $field): ?>
                    <?php if ($field === 'user_id' || $field === 'plan_id' || $field === 'camera_id' || $field === 'subscription_id' || $field === 'config_id' || $field === 'log_id'): ?>
                        <div class="form-group">
                            <label class="form-label"><?php echo $field; ?></label>
                            <input type="number" class="form-input" id="field_<?php echo $field; ?>" name="<?php echo $field; ?>" readonly>
                            <div class="text-muted">Auto-incrementado, não edite</div>
                        </div>
                    <?php elseif ($field === 'created_at' || $field === 'updated_at'): ?>
                        <div class="form-group">
                            <label class="form-label"><?php echo $field; ?></label>
                            <input type="text" class="form-input" id="field_<?php echo $field; ?>" name="<?php echo $field; ?>" readonly>
                            <div class="text-muted">Preenchido automaticamente</div>
                        </div>
                    <?php else: ?>
                        <div class="form-group">
                            <label class="form-label"><?php echo $field; ?></label>
                            <?php if (strpos($field, 'json') !== false || strpos($field, 'config') !== false || strpos($field, 'description') !== false || strpos($field, 'message') !== false): ?>
                                <textarea class="form-textarea" id="field_<?php echo $field; ?>" name="<?php echo $field; ?>"></textarea>
                            <?php elseif (in_array($field, ['account_status', 'account_tier', 'plan', 'status', 'is_active', 'is_verified', 'is_read', 'is_enabled', 'send_email', 'send_push', 'send_sms', 'send_webhook'])): ?>
                                <select class="form-select" id="field_<?php echo $field; ?>" name="<?php echo $field; ?>">
                                    <option value="1">Sim</option>
                                    <option value="0">Não</option>
                                </select>
                            <?php else: ?>
                                <input type="text" class="form-input" id="field_<?php echo $field; ?>" name="<?php echo $field; ?>">
                            <?php endif; ?>
                        </div>
                    <?php endif; ?>
                <?php endforeach; ?>
            </div>
            
            <button type="submit" class="btn-submit">💾 Salvar</button>
        </form>
    </div>
</div>

<script>
function openModal(action, data = null) {
    const modal = document.getElementById('recordModal');
    const modalTitle = document.getElementById('modal-title');
    const formAction = document.getElementById('form-action');
    const formId = document.getElementById('form-id');

    if (action === 'add') {
        modalTitle.textContent = '➕ Adicionar Novo Registro';
        formAction.value = 'insert';
        formId.value = '';
        document.querySelectorAll('.form-input, .form-select, .form-textarea').forEach(input => {
            input.value = '';
        });
    } else if (action === 'edit' && data) {
        modalTitle.textContent = '✏️ Editar Registro';
        formAction.value = 'update';
        formId.value = data.user_id || data.plan_id || data.camera_id || data.alert_config_id || data.payment_id || data.coupon_id || data.api_key_id || data.webhook_id || data.metric_id || data.config_id || data.history_id || data.log_id || data.recovery_id || data.session_id || data.notification_id || data.subscription_id || 0;
        
        Object.keys(data).forEach(key => {
            const field = document.getElementById('field_' + key);
            if (field) {
                field.value = data[key] || '';
            }
        });
    }
    
    modal.style.display = 'flex';
}

function closeModal() {
    document.getElementById('recordModal').style.display = 'none';
}

function deleteRecord(table, id) {
    if (confirm('⚠️ Tem certeza que deseja excluir este registro?\n\nEsta ação não pode ser desfeita!')) {
        window.location.href = '?table=' + table + '&action=delete&id=' + id;
    }
}

// Fechar modal ao clicar fora
window.onclick = function(event) {
    const modal = document.getElementById('recordModal');
    if (event.target === modal) {
        closeModal();
    }
}

// Auto-submit ao mudar filtro de tipo
document.addEventListener('DOMContentLoaded', function() {
    document.querySelectorAll('.filter-select').forEach(select => {
        select.addEventListener('change', function() {
            if (this.value === 'empty' || this.value === 'not_empty') {
                const input = this.parentElement.querySelector('.filter-input');
                if (input) {
                    input.value = '';
                }
            }
        });
    });
});
</script>

</body>
</html>