File Manager

✏️ Edit File: /home/u625410797/domains/monothailand.com/public_html/ecotect_air/api/v1/inspect_db.php

<?php
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 __DIR__ . '/../../config.php';

$userId = 'a8b7f34371a062ad2a6595bac1bf98b97672'; // From logs

try {
    $db = Database::getConnection();
    echo "Diagnostic for User: $userId\n";
    echo "========================================\n\n";

// 1. Sites
    $sites = $db->prepare("SELECT id, name FROM sites WHERE user_id = ?");
    $sites->execute([$userId]);
    echo "SITES:\n";
    foreach ($sites->fetchAll() as $s) {
        echo " - [{$s['id']}] {$s['name']}\n";
        
        // 2. Rooms
        $rooms = $db->prepare("SELECT id, name, zone_id, level_id FROM rooms WHERE site_id = ?");
        $rooms->execute([$s['id']]);
        foreach ($rooms->fetchAll() as $r) {
            echo "   |-- ROOM: [{$r['id']}] {$r['name']} (Zone: {$r['zone_id']}, Level: {$r['level_id']})\n";
            
            // 3. Slots
            $slots = $db->prepare("SELECT id, name, mac_address FROM device_slots WHERE room_id = ?");
            $slots->execute([$r['id']]);
            foreach ($slots->fetchAll() as $sl) {
                echo "       |-- SLOT: [{$sl['id']}] {$sl['name']} (MAC: {$sl['mac_address']})\n";
            }
        }
    }

$search = '%ออฟฟิศ%';
    echo "\nSearching for '$search'...\n";
    
    $tables = ['sites', 'levels', 'zones', 'rooms'];
    foreach ($tables as $t) {
        echo "Table: $t\n";
        $stmt = $db->prepare("SELECT * FROM `$t` WHERE name LIKE ?");
        $stmt->execute([$search]);
        foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
            echo " - Found: " . json_encode($row) . "\n";
        }
    }

} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}

Batal

⬅ Naik ke api 106 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁admin	dir	—	2026-03-20 09:16	📂 Buka
📁alerts	dir	—	2026-03-20 06:33	📂 Buka
📁auth	dir	—	2026-02-05 17:53	📂 Buka
📁dashboard	dir	—	2026-04-24 01:53	📂 Buka
📁industrial	dir	—	2026-03-16 16:14	📂 Buka
📁ota	dir	—	2026-04-02 09:10	📂 Buka
📁programs	dir	—	2026-02-08 08:58	📂 Buka
🐘active_ping.php	php	995 B	2026-03-28 05:59	✏️ Edit 👁️ View
🐘active_tracker.php	php	1.9 KB	2026-06-30 07:22	✏️ Edit 👁️ View
🐘alert_history.php	php	5 KB	2026-03-27 03:50	✏️ Edit 👁️ View
🐘analytics_engine.php	php	6 KB	2026-02-28 12:46	✏️ Edit 👁️ View
🐘audit_logs.php	php	1.9 KB	2026-02-24 15:21	✏️ Edit 👁️ View
🐘backfill_energy.php	php	1.2 KB	2026-03-27 03:50	✏️ Edit 👁️ View
🐘bind_hardware.php	php	2.7 KB	2026-03-03 09:58	✏️ Edit 👁️ View
🐘bot_slots.php	php	2.5 KB	2026-02-21 07:20	✏️ Edit 👁️ View
🐘check_serial.php	php	4.9 KB	2026-02-23 09:27	✏️ Edit 👁️ View
🐘check_tz.php	php	427 B	2026-03-14 05:28	✏️ Edit 👁️ View
🐘complete_command.php	php	3.1 KB	2026-02-23 10:26	✏️ Edit 👁️ View
🐘control.php	php	14.1 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘control_mass.php	php	1.9 KB	2026-03-14 07:35	✏️ Edit 👁️ View
🐘db_explain.php	php	1.1 KB	2026-03-27 07:12	✏️ Edit 👁️ View
🐘db_optimize.php	php	1.3 KB	2026-03-27 07:13	✏️ Edit 👁️ View
🐘debug_cumulative.php	php	1.5 KB	2026-03-27 03:49	✏️ Edit 👁️ View
🐘debug_db.php	php	3.4 KB	2026-02-23 10:27	✏️ Edit 👁️ View
🐘debug_db_check.php	php	757 B	2026-03-17 15:21	✏️ Edit 👁️ View
🐘debug_energy.php	php	901 B	2026-03-27 03:50	✏️ Edit 👁️ View
🐘debug_history_logic.php	php	1.7 KB	2026-03-14 05:28	✏️ Edit 👁️ View
🐘debug_product69.php	php	8.9 KB	2026-07-03 07:31	✏️ Edit 👁️ View
🐘debug_raw_data.php	php	1.7 KB	2026-03-14 05:28	✏️ Edit 👁️ View
🐘debug_slot.php	php	852 B	2026-03-09 09:10	✏️ Edit 👁️ View
🐘debug_wana.php	php	973 B	2026-03-27 07:04	✏️ Edit 👁️ View
🐘delete_node_permanent.php	php	6.3 KB	2026-03-27 03:51	✏️ Edit 👁️ View
🐘delete_program.php	php	2.8 KB	2026-02-21 07:21	✏️ Edit 👁️ View
🐘delete_site.php	php	4.5 KB	2026-02-21 07:22	✏️ Edit 👁️ View
🐘delete_slot.php	php	2.5 KB	2026-02-23 09:27	✏️ Edit 👁️ View
🐘dump_debug.php	php	1.1 KB	2026-02-21 07:22	✏️ Edit 👁️ View
🐘energy_anchor.php	php	2.1 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘energy_integration_engine.php	php	4.6 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘firmware_core.php	php	5.5 KB	2026-02-24 15:20	✏️ Edit 👁️ View
🐘fix_schema.php	php	4.7 KB	2026-06-29 03:03	✏️ Edit 👁️ View
🐘fleet_stats.php	php	4.4 KB	2026-02-24 01:33	✏️ Edit 👁️ View
🐘geo_intelligence.php	php	4.1 KB	2026-03-01 13:44	✏️ Edit 👁️ View
🐘get_commands.php	php	4.2 KB	2026-06-30 07:22	✏️ Edit 👁️ View
🐘get_commands_backup.php	php	1.8 KB	2026-02-21 07:23	✏️ Edit 👁️ View
🐘get_hidden_nodes.php	php	1.2 KB	2026-03-17 15:28	✏️ Edit 👁️ View
🐘get_hierarchy.php	php	15.4 KB	2026-03-18 02:23	✏️ Edit 👁️ View
🐘get_slot_program.php	php	2 KB	2026-02-21 07:24	✏️ Edit 👁️ View
🐘health_analysis.php	php	6.2 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘history.php	php	30.5 KB	2026-07-03 06:29	✏️ Edit 👁️ View
🐘history_backup1.php	php	9.8 KB	2026-04-23 06:40	✏️ Edit 👁️ View
🐘history_day_OK.php	php	18.4 KB	2026-03-23 11:49	✏️ Edit 👁️ View
🐘history_new_bug.php	php	17.8 KB	2026-03-28 02:09	✏️ Edit 👁️ View
🐘history_precision.php	php	11.9 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘history_precision_b1.php	php	4.5 KB	2026-03-27 05:32	✏️ Edit 👁️ View
🐘history_precision_b2.php	php	5.6 KB	2026-04-23 06:39	✏️ Edit 👁️ View
🐘history_precision_day_OK.php	php	10 KB	2026-03-23 11:49	✏️ Edit 👁️ View
🐘hive_core.php	php	6.1 KB	2026-02-21 07:24	✏️ Edit 👁️ View
🐘inspect_db.php	php	1.9 KB	2026-03-18 01:49	✏️ Edit 👁️ View
🐘inspect_schema.php	php	990 B	2026-02-21 07:24	✏️ Edit 👁️ View
🐘latest.php	php	26.2 KB	2026-06-30 07:22	✏️ Edit 👁️ View
🐘list_devices.php	php	527 B	2026-02-21 07:25	✏️ Edit 👁️ View
🐘list_slots.php	php	2 KB	2026-02-21 07:25	✏️ Edit 👁️ View
🐘mass_command.php	php	5.5 KB	2026-02-21 07:25	✏️ Edit 👁️ View
🐘mesh_sync.php	php	3 KB	2026-02-21 07:25	✏️ Edit 👁️ View
🐘migrate_3phase.php	php	2.6 KB	2026-03-27 05:19	✏️ Edit 👁️ View
🐘move_hardware.php	php	5 KB	2026-03-07 07:37	✏️ Edit 👁️ View
🐘ota_manager.php	php	3.8 KB	2026-02-21 07:26	✏️ Edit 👁️ View
🐘peek_data.php	php	708 B	2026-02-21 07:26	✏️ Edit 👁️ View
🐘peek_recent.php	php	663 B	2026-03-09 10:42	✏️ Edit 👁️ View
📊product69_2026-07-02.csv	csv	3.1 MB	2026-07-03 07:32	✏️ Edit 👁️ View
📄purge_lock.timestamp	timestamp	10 B	2026-07-07 14:38	✏️ Edit 👁️ View
🐘push_structure.php	php	12.2 KB	2026-03-01 13:45	✏️ Edit 👁️ View
🐘register_hardware.php	php	3 KB	2026-02-21 07:26	✏️ Edit 👁️ View
🐘reset_energy.php	php	1.6 KB	2026-03-27 04:26	✏️ Edit 👁️ View
🐘room_status.php	php	5.4 KB	2026-02-21 07:49	✏️ Edit 👁️ View
🐘save_program.php	php	7.9 KB	2026-02-21 07:27	✏️ Edit 👁️ View
🐘security_digest.php	php	3.5 KB	2026-02-21 07:27	✏️ Edit 👁️ View
🐘seed_admin.php	php	1.7 KB	2026-02-21 07:27	✏️ Edit 👁️ View
🐘server_health.php	php	1.6 KB	2026-03-27 07:21	✏️ Edit 👁️ View
🐘set_node_visibility.php	php	2.1 KB	2026-03-17 14:45	✏️ Edit 👁️ View
🐘set_room_master.php	php	2.1 KB	2026-02-21 07:27	✏️ Edit 👁️ View
🐘sharing.php	php	5.1 KB	2026-03-18 01:49	✏️ Edit 👁️ View
🐘simulate_history.php	php	6.1 KB	2026-03-18 02:16	✏️ Edit 👁️ View
🐘slot_resolver.php	php	8.4 KB	2026-06-30 07:22	✏️ Edit 👁️ View
🐘status_ping.php	php	11.1 KB	2026-06-30 07:22	✏️ Edit 👁️ View
📋status_ping_error.log	log	0 B	2026-06-25 07:13	✏️ Edit 👁️ View
🐘sync.php	php	9.5 KB	2026-06-26 04:56	✏️ Edit 👁️ View
🐘sync_location_slots.php	php	3.5 KB	2026-03-27 03:51	✏️ Edit 👁️ View
🐘system_config.php	php	2.1 KB	2026-02-21 07:28	✏️ Edit 👁️ View
🐘telemetry.php	php	55.9 KB	2026-06-30 07:22	✏️ Edit 👁️ View
🐘telemetry_back1.php	php	40.6 KB	2026-04-20 09:48	✏️ Edit 👁️ View
🐘telemetry_batch.php	php	15.1 KB	2026-06-30 07:22	✏️ Edit 👁️ View
📋telemetry_batch_error.log	log	628.5 KB	2026-07-07 04:59	✏️ Edit 👁️ View
🐘telemetry_engine.php	php	6.8 KB	2026-06-30 07:04	✏️ Edit 👁️ View
📋telemetry_error.log	log	92.7 MB	2026-07-07 07:46	✏️ Edit 👁️ View
📄telemetry_error.log.20260625_132649.bak	bak	1.3 GB	2026-06-25 06:26	✏️ Edit 👁️ View
📋telemetry_raw.log	log	1.3 MB	2026-06-26 05:11	✏️ Edit 👁️ View
📄telemetry_raw.log.20260625_132649.bak	bak	6.6 GB	2026-06-25 06:26	✏️ Edit 👁️ View
🐘telemetry_raw.php	php	5.9 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘telemetry_v2.php	php	13.9 KB	2026-06-30 07:04	✏️ Edit 👁️ View
🐘test_dual_core.php	php	1.9 KB	2026-03-23 11:58	✏️ Edit 👁️ View
🐘test_write.php	php	541 B	2026-04-23 06:20	✏️ Edit 👁️ View
🐘unlink_device.php	php	2.3 KB	2026-04-02 08:11	✏️ Edit 👁️ View
🐘update_sensor_config.php	php	3.5 KB	2026-03-14 07:36	✏️ Edit 👁️ View
🐘update_user.php	php	4.3 KB	2026-02-21 07:30	✏️ Edit 👁️ View
🐘user_manager.php	php	6.5 KB	2026-02-23 08:15	✏️ Edit 👁️ View