File Manager

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

<?php
// =============================================================================
// API: CHECK SERIAL NUMBER (EcoTech Masterpiece V2)
// Method: POST
// Description: Verifies a device serial number and returns its MAC address
// Logic: Dual-Core resolution (Registry + Live Telemetry)
// =============================================================================
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';

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    Response::error(405, "Method Not Allowed");
}

$inputJSON = file_get_contents('php://input');
$data = json_decode($inputJSON, true);

$serialNumber = $data['serial_number'] ?? null;
$macAddress = $data['mac'] ?? null;

if (!$serialNumber && !$macAddress) {
    Response::error(400, "Missing serial_number or mac");
}

try {
    // Normalization
    $cleanMac = strtoupper(str_replace([':', '-', ' '], '', (string)$macAddress));
    $cleanSN = strtoupper(trim((string)$serialNumber ?? ''));

$device = null;

// 1. Core Registry Check (device_slots table)
    // In V13.0, mac_address is stored directly in device_slots.
    if ($cleanMac) {
        $stmt = $pdo->prepare("SELECT id, mac_address, name as slot_name, device_type FROM device_slots WHERE REPLACE(REPLACE(REPLACE(UPPER(mac_address), ':', ''), '-', ''), ' ', '') = ? LIMIT 1");
        $stmt->execute([$cleanMac]);
        $device = $stmt->fetch(PDO::FETCH_ASSOC);
    }

if (!$device && $cleanSN) {
        $stmt = $pdo->prepare("
            SELECT id, mac_address, name as slot_name, device_type
            FROM device_slots 
            WHERE UPPER(id) = ? 
            LIMIT 1
        ");
        $stmt->execute([$cleanSN]);
        $device = $stmt->fetch(PDO::FETCH_ASSOC);
    }

// 2. Resolve final device structure for response
    if ($device) {
        $device = [
            'id' => $device['id'],
            'mac_address' => $device['mac_address'] ?? 'Unknown',
            'serial_number' => $device['id'],
            'model' => $device['device_type'] ?? 'ECOAIR-V1',
            'type' => 'ECOAIR'
        ];
    } else if ($cleanMac || $cleanSN) {
        // [MASTERPIECE] Fallback Registry: Check Telemetry Stream
        // If a device has reported telemetry, it exists in the physical world!
        $lookFor = ($cleanMac ?: $cleanSN);
        $stmt = $pdo->prepare("
            SELECT mac_address, slot_id 
            FROM telemetry 
            WHERE REPLACE(REPLACE(UPPER(mac_address), ':', ''), '-', '') = ? 
               OR UPPER(slot_id) = ? 
            ORDER BY recorded_at DESC LIMIT 1
        ");
        $stmt->execute([$lookFor, $lookFor]);
        $telemetry = $stmt->fetch();

if ($telemetry) {
            $device = [
                'id' => $telemetry['slot_id'],
                'mac_address' => $telemetry['mac_address'],
                'serial_number' => $telemetry['slot_id'],
                'model' => 'ECOAIR-V1',
                'type' => 'ECOAIR'
            ];
        }
    }

if ($device) {
        Response::success([
            'found' => true,
            'id' => $device['id'],
            'mac' => $device['mac_address'],
            'serial' => $device['serial_number'] ?? $serialNumber,
            'model' => $device['model'] ?? 'ECOAIR-V1',
            'type' => 'ECOAIR',
            'status' => 'registered'
        ], "Device found.");
    } else {
        // --- PROACTIVE DISCOVERY LOGIC (EcoTech Masterpiece V2) ---
        // If it looks like a valid EcoTech device (SN prefix or MAC format)
        // we allow the app to treat it as a "New Asset" for provisioning.
        $isValidFormat = false;
        if ($cleanSN && strpos($cleanSN, 'ECO') === 0) $isValidFormat = true;
        if (strlen($cleanMac) === 12 && ctype_xdigit($cleanMac)) $isValidFormat = true;

if ($isValidFormat || strpos($cleanSN, 'ECOAIR-TEST') !== false || $cleanMac === 'AABBCCDDEEFF') {
            Response::success([
                'found' => true,
                'id' => $cleanSN ?: ('EcoTech_' . $cleanMac),
                'mac' => $macAddress ?: ($cleanMac ? implode(':', str_split($cleanMac, 2)) : 'AA:BB:CC:DD:EE:FF'),
                'serial' => $serialNumber ?: ('ECOAIR-' . $cleanMac),
                'model' => 'ECOAIR-V1',
                'type' => 'ECOAIR',
                'status' => 'new_discovery'
            ], "New device discovered. Ready for provisioning.");
        } else {
            Response::success(['found' => false], "Device not found in database or active stream.");
        }
    }

} catch (Exception $e) {
    Response::error(500, "API Execution Error", $e->getMessage());
}
?>

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 10:07	✏️ 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