File Manager

✏️ Edit File: /home/u625410797/domains/monothailand.com/public_html/smart_panel/master_seed.php

<?php
/**
 * [MASTERPIECE] Infrastructure Seeder V4.2 - God Mode Lattice
 * Purpose: Full Lattice Initialization for God Mode Demonstration
 */

require_once 'config.php';
$pdo = Database::getConnection();

if (!$pdo) {
    die("CRITICAL: Database connection failed. Check config.php and DB availability.\n");
}

echo "--- Smart_PanelINFRASTRUCTURE SEEDER V4.2 [GOD MODE] ---\n";

try {
    // 0. Clean old demo data (Optional: set to false if you want to keep records)
    $clean = true;
    if ($clean) {
        echo "[0/4] Purging stale demo lattice buffers...\n";
        $pdo->exec("DELETE FROM device_slots WHERE id LIKE 'SLOT_DEMO_%'");
        $pdo->exec("DELETE FROM rooms WHERE id LIKE 'ROOM_DEMO_%'");
        $pdo->exec("DELETE FROM sites WHERE id LIKE 'SITE_DEMO_%'");
        $pdo->exec("DELETE FROM devices WHERE id LIKE 'DEV_SIM_%'");
    }

// 1. Core Users (Ensure system identities exist)
    echo "[1/4] Seeding God Mode Identities...\n";
    $pdo->exec("INSERT IGNORE INTO users (id, email, display_name, role) VALUES ('USER_UUID_DEMO_123', 'demo@Smart_Panel.com', 'Admin Root (God Mode)', 'admin')");
    $pdo->exec("INSERT IGNORE INTO users (id, email, display_name, role) VALUES ('SYSTEM_AUTO_STAGING', 'system@Smart_Panel.local', 'System Staging', 'admin')");
    
    // 2. Sites & Rooms
    echo "[2/4] Seeding Infrastructure Lattice...\n";
    $pdo->exec("INSERT IGNORE INTO sites (id, user_id, name, type, address, city) VALUES ('SITE_DEMO_001', 'USER_UUID_DEMO_123', 'Smart_PanelHQ', 'office', '123 Cloud St', 'Bangkok')");
    $pdo->exec("INSERT IGNORE INTO rooms (id, site_id, name, floor_number) VALUES ('ROOM_DEMO_001', 'SITE_DEMO_001', 'Master Control Lab', 1)");
    $pdo->exec("INSERT IGNORE INTO rooms (id, site_id, name, floor_number) VALUES ('ROOM_DEMO_002', 'SITE_DEMO_001', 'Server Sector 7', 2)");

// 3. Devices (Hardware Inventory)
    echo "[3/4] Registering Hardware Nodes...\n";
    $pdo->exec("INSERT IGNORE INTO devices (id, mac_address, serial_number, model, firmware_version, last_seen) VALUES 
        ('DEV_SIM_NODE_01', 'AABBCCDDEE01', 'Smart_Panel_SIM_01', 'ECOAIR-SIM-V4', 'v4.1.0-STABLE', NOW()),
        ('DEV_SIM_NODE_02', 'AABBCCDDEE02', 'Smart_Panel_SIM_02', 'ECOAIR-SIM-V4', 'v4.1.0-STABLE', NOW()),
        ('DEV_SIM_NODE_03', 'AABBCCDDEE03', 'Smart_Panel_SIM_03', 'ECOAIR-SIM-V4', 'v4.0.2', DATE_SUB(NOW(), INTERVAL 10 MINUTE))");

// 4. Device Slots (Spatial Mapping with Pzem/Dht11 flags)
    echo "[4/4] Mapping Spatial Nodes (Lattice Positioning)...\n";
    $pdo->exec("INSERT IGNORE INTO device_slots (id, room_id, name, slot_index, device_type, current_device_id, is_online, power_state, has_pzem, has_dht11) VALUES 
        ('SLOT_DEMO_01', 'ROOM_DEMO_001', 'Main Cooling Cluster', 0, 'ac', 'DEV_SIM_NODE_01', 1, 1, 1, 1),
        ('SLOT_DEMO_02', 'ROOM_DEMO_001', 'Auxiliary Logic Relay', 1, 'ac', 'DEV_SIM_NODE_02', 1, 0, 1, 0),
        ('SLOT_DEMO_03', 'ROOM_DEMO_002', 'Environmental Monitor', 0, 'sensor', 'DEV_SIM_NODE_03', 0, 1, 0, 1)");

echo "\n✅ LATTICE INITIALIZATION SUCCESSFUL.\n";
    echo "Lattice Geometry: 1 Site | 2 Sectors | 3 Spatial Nodes\n";

} catch (Exception $e) {
    echo "❌ SEEDER CRITICAL ERROR: " . $e->getMessage() . "\n";
}

Batal

⬅ Naik ke public_html 42 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁Dimm_app_image	dir	—	2026-05-01 04:34	📂 Buka
📁api	dir	—	2026-04-30 04:28	📂 Buka
📁core	dir	—	2026-04-30 04:28	📂 Buka
📁cron	dir	—	2026-04-30 04:28	📂 Buka
📁node_modules	dir	—	2026-04-30 04:28	📂 Buka
📁vendor	dir	—	2026-04-30 04:28	📂 Buka
📄.env	env	2.4 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘analytics.php	php	1.3 KB	2026-04-30 04:28	✏️ Edit 👁️ View
📜backfill_energy.js	js	1.4 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘check_db.php	php	1.7 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘claim_device.php	php	5.5 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘config.php	php	20.8 KB	2026-05-01 01:51	✏️ Edit 👁️ View
🐘config_b1.php	php	17.1 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘config_b2.php	php	16.9 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘cron_cleanup.php	php	2 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🗃️database.sql	sql	27.4 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘db_cols.php	php	260 B	2026-04-30 04:28	✏️ Edit 👁️ View
🐘db_diag.php	php	189 B	2026-04-30 04:28	✏️ Edit 👁️ View
🐘debug_energy.php	php	633 B	2026-04-30 04:28	✏️ Edit 👁️ View
🐘debug_energy_audit.php	php	485 B	2026-04-30 04:28	✏️ Edit 👁️ View
🐘debug_history.php	php	4.2 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘debug_schema.php	php	659 B	2026-04-30 04:28	✏️ Edit 👁️ View
🐘debug_shard.php	php	2.5 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘debug_system.php	php	990 B	2026-04-30 04:28	✏️ Edit 👁️ View
🐘debug_telemetry.php	php	2.6 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘fix_shards.php	php	1.2 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘get_alerts.php	php	799 B	2026-04-30 04:28	✏️ Edit 👁️ View
🐘ls.php	php	809 B	2026-04-30 04:28	✏️ Edit 👁️ View
🐘master_seed.php	php	3.2 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘migrate_identity.php	php	2.6 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘migrate_tri_path.php	php	1.5 KB	2026-04-30 04:28	✏️ Edit 👁️ View
📋package-lock.json	json	35.5 KB	2026-04-30 04:28	✏️ Edit 👁️ View
📋package.json	json	492 B	2026-04-30 04:28	✏️ Edit 👁️ View
📋prod_users_response.json	json	207 B	2026-04-30 04:28	✏️ Edit 👁️ View
🐘research_shards.php	php	2.6 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘seed_admins.php	php	1.5 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘seed_data.php	php	2 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘seed_telemetry.php	php	979 B	2026-04-30 04:28	✏️ Edit 👁️ View
📜server.js	js	13.5 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘setup_sharding.php	php	1.4 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘test_shard_write.php	php	1.9 KB	2026-04-30 04:28	✏️ Edit 👁️ View
🐘upload.php	php	2.4 KB	2026-04-30 04:28	✏️ Edit 👁️ View