File Manager

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

<?php
/**
 * [MASTERPIECE] Infrastructure Seeder V4.2 - God Mode Lattice
 * Purpose: Full Lattice Initialization for God Mode Demonstration
 */
header("Content-Type: application/json; charset=UTF-8");
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS');
header('Access-Control-Allow-Headers: Content-Type, Authorization, X-Api-Key');
require_once 'config.php';
$pdo = Database::getConnection();

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

echo "--- ECOTECH INFRASTRUCTURE 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@ecotech.com', 'Admin Root (God Mode)', 'admin')");
    $pdo->exec("INSERT IGNORE INTO users (id, email, display_name, role) VALUES ('SYSTEM_AUTO_STAGING', 'system@ecotech.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', 'EcoTech HQ', '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', 'EcoTech_SIM_01', 'ECOAIR-SIM-V4', 'v4.1.0-STABLE', NOW()),
        ('DEV_SIM_NODE_02', 'AABBCCDDEE02', 'EcoTech_SIM_02', 'ECOAIR-SIM-V4', 'v4.1.0-STABLE', NOW()),
        ('DEV_SIM_NODE_03', 'AABBCCDDEE03', 'EcoTech_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 57 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁api	dir	—	2026-02-14 12:59	📂 Buka
📁core	dir	—	2026-04-20 07:30	📂 Buka
📁middleware	dir	—	2026-02-04 17:48	📂 Buka
📁migrations	dir	—	2026-02-04 17:48	📂 Buka
📁report	dir	—	2026-03-05 05:53	📂 Buka
📁storage	dir	—	2026-02-24 01:40	📂 Buka
📁vendor	dir	—	2026-02-06 01:28	📂 Buka
📄.env	env	2.4 KB	2026-06-26 05:11	✏️ Edit 👁️ View
📄.env_backup	env_backup	2.4 KB	2026-03-14 07:29	✏️ Edit 👁️ View
📋active_db_cache.json	json	67 B	2026-07-07 07:13	✏️ Edit 👁️ View
🐘analytics.php	php	1.6 KB	2026-02-21 07:31	✏️ Edit 👁️ View
📜backfill_energy.js	js	1.3 KB	2026-03-27 06:23	✏️ Edit 👁️ View
🐘check_absolute_latest.php	php	561 B	2026-04-23 03:42	✏️ Edit 👁️ View
🐘check_db.php	php	2 KB	2026-02-27 07:32	✏️ Edit 👁️ View
🐘check_latest.php	php	566 B	2026-04-23 03:21	✏️ Edit 👁️ View
🐘check_mac_formats.php	php	923 B	2026-04-23 03:21	✏️ Edit 👁️ View
🐘check_mac_slots.php	php	898 B	2026-04-23 03:38	✏️ Edit 👁️ View
🐘check_pzem_config.php	php	667 B	2026-04-23 03:21	✏️ Edit 👁️ View
🐘check_server_time.php	php	494 B	2026-04-23 03:58	✏️ Edit 👁️ View
🐘check_shards.php	php	423 B	2026-04-23 04:41	✏️ Edit 👁️ View
🐘check_slot_mac.php	php	496 B	2026-04-23 04:56	✏️ Edit 👁️ View
🐘check_telemetry.php	php	1.1 KB	2026-04-23 03:22	✏️ Edit 👁️ View
🐘claim_device.php	php	4.7 KB	2026-02-21 07:31	✏️ Edit 👁️ View
🐘cleanup_future_data.php	php	802 B	2026-04-23 03:58	✏️ Edit 👁️ View
🐘config.php	php	19.3 KB	2026-06-26 05:11	✏️ Edit 👁️ View
🐘config_add_device.php	php	16 KB	2026-03-18 11:49	✏️ Edit 👁️ View
🐘config_b1.php	php	17.1 KB	2026-03-27 06:23	✏️ Edit 👁️ View
🐘config_b2.php	php	16.4 KB	2026-03-27 09:14	✏️ Edit 👁️ View
🐘config_back1.php	php	18.8 KB	2026-04-23 10:53	✏️ Edit 👁️ View
🐘config_backup.php	php	13.4 KB	2026-02-14 06:34	✏️ Edit 👁️ View
🐘config_backup1.php	php	15.9 KB	2026-03-15 02:06	✏️ Edit 👁️ View
🐘config_backup3.php	php	16.8 KB	2026-03-18 15:42	✏️ Edit 👁️ View
🐘cron_cleanup.php	php	2.1 KB	2026-06-25 06:22	✏️ Edit 👁️ View
🐘db_cols.php	php	516 B	2026-02-23 02:58	✏️ Edit 👁️ View
🐘db_diag.php	php	441 B	2026-04-23 10:53	✏️ Edit 👁️ View
🐘db_process_audit.php	php	1.3 KB	2026-03-27 08:25	✏️ Edit 👁️ View
🐘delete_oldtime.php	php	2.6 KB	2026-05-08 06:41	✏️ Edit 👁️ View
🐘diag_energy.php	php	1.9 KB	2026-04-23 03:38	✏️ Edit 👁️ View
🐘dump_db_custom.php	php	710 B	2026-02-21 07:32	✏️ Edit 👁️ View
🐘find_site.php	php	516 B	2026-04-23 04:57	✏️ Edit 👁️ View
🐘get_alerts.php	php	1 KB	2026-02-21 07:33	✏️ Edit 👁️ View
🐘init_shard_05.php	php	5.3 KB	2026-06-22 15:45	✏️ Edit 👁️ View
🐘list_slots.php	php	687 B	2026-04-23 03:22	✏️ Edit 👁️ View
🐘ls.php	php	1 KB	2026-02-21 07:33	✏️ Edit 👁️ View
🐘master_seed.php	php	3.5 KB	2026-02-21 07:33	✏️ Edit 👁️ View
🐘migrate_identity.php	php	2.9 KB	2026-02-21 07:33	✏️ Edit 👁️ View
🐘probe_rapidsolar.php	php	1.4 KB	2026-04-23 04:51	✏️ Edit 👁️ View
🐘probe_rapidsolar_energy.php	php	1014 B	2026-04-23 04:54	✏️ Edit 👁️ View
🐘probe_rapidsolar_slave.php	php	968 B	2026-04-23 04:58	✏️ Edit 👁️ View
🐘prod_ls.php	php	748 B	2026-03-27 08:23	✏️ Edit 👁️ View
🐘recover_user.php	php	13.3 KB	2026-06-22 16:46	✏️ Edit 👁️ View
🐘relink_user.php	php	7.8 KB	2026-06-22 16:46	✏️ Edit 👁️ View
🐘research_shards.php	php	2.8 KB	2026-04-20 08:33	✏️ Edit 👁️ View
🐘seed_admins.php	php	1.7 KB	2026-02-21 07:33	✏️ Edit 👁️ View
🐘seed_data.php	php	2.2 KB	2026-02-21 07:33	✏️ Edit 👁️ View
🐘seed_telemetry.php	php	1.2 KB	2026-02-21 07:34	✏️ Edit 👁️ View
🐘upload.php	php	2.7 KB	2026-02-21 07:34	✏️ Edit 👁️ View