File Manager

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

<?php
// =============================================================================
// API: GEO-SPATIAL INTELLIGENCE (ANONYMIZED)
// Method: GET
// Description: Returns aggregated device counts by geographic regions (Hex-Binning)
// =============================================================================

require_once __DIR__ . '/../../../config.php';

// 1. Authenticate & Verify Master API Key (God Mode Required)
Security::guard();

try {
    // 2. Aggregate device locations via coordinate quantization
    // Instead of raw lat/lng, we round to 0.1 degree precision (~11km hex-bin)
    // This provides a high-level "heat" map without exposing exact customer homes.
    
    $stmt = $pdo->query("
        SELECT 
            ROUND(latitude, 1) as bin_lat,
            ROUND(longitude, 1) as bin_lng,
            COUNT(DISTINCT ds.id) as device_count,
            COALESCE(AVG(CASE WHEN ds.is_online = 1 THEN 1 ELSE 0 END) * 100, 0) as health_index
        FROM device_slots ds
        WHERE latitude IS NOT NULL AND longitude IS NOT NULL
        GROUP BY bin_lat, bin_lng
    ");
    
    $bins = $stmt->fetchAll(PDO::FETCH_ASSOC);

Response::success([
        'precision' => '0.1_deg', // ~11.1km
        'unit' => 'hex_bin',
        'generated_at' => date('c'),
        'bins' => $bins
    ], "Geo-spatial intelligence synchronized successfully.");

} catch (Exception $e) {
    error_log("geo_stats.php - Error: " . $e->getMessage());
    Response::error(500, "Geo-Sync Failed", null, $e->getMessage());
}
?>

Batal

⬅ Naik ke v1 8 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘analytics.php	php	14.4 KB	2026-04-27 03:38	✏️ Edit 👁️ View
🐘firmware.php	php	9.1 KB	2026-03-20 09:16	✏️ Edit 👁️ View
🐘fleet_explorer.php	php	3.4 KB	2026-03-20 09:49	✏️ Edit 👁️ View
🐘geo_stats.php	php	1.5 KB	2026-03-20 09:20	✏️ Edit 👁️ View
📄groups.php.bak	bak	7.6 KB	2026-03-20 09:16	✏️ Edit 👁️ View
📄locations.php.bak	bak	9.7 KB	2026-03-20 09:16	✏️ Edit 👁️ View
🐘site_diagnostic.php	php	4.1 KB	2026-03-20 09:49	✏️ Edit 👁️ View
🐘users.php	php	12.1 KB	2026-03-20 09:16	✏️ Edit 👁️ View