File Manager

✏️ Edit File: /home/u625410797/domains/monothailand.com/public_html/smart_panel/api/v1/admin/groups.php.bak

<?php
/**
 * Device Groups API - Manage 16-device groups
 */

header('Content-Type: application/json');
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');

if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    http_response_code(200);
    exit;
}

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

$auth = Security::requireAuth();
if (!$auth['isAdmin']) {
    Response::error(403, "Forbidden", "Admin access required");
}

$method = $_SERVER['REQUEST_METHOD'];
$path = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH);
$segments = explode('/', trim($path, '/'));

// [GOD MODE] Dynamic Segment Detection
$scriptName = basename(__FILE__);
$scriptIndex = -1;
foreach ($segments as $i => $segment) {
    if ($segment === $scriptName) {
        $scriptIndex = $i;
        break;
    }
}

$identifier = ($scriptIndex !== -1 && isset($segments[$scriptIndex + 1])) ? $segments[$scriptIndex + 1] : null;

try {
    $pdo = Database::getConnection();
    
    switch ($method) {
        case 'GET':
            if ($identifier) {
                // Get specific group
                $groupId = intval($identifier);
                Response::success(getGroup($pdo, $groupId));
            } else {
                // Get all groups
                Response::success(getAllGroups($pdo));
            }
            break;
            
        case 'POST':
            $data = json_decode(file_get_contents('php://input'), true);
            Response::success(createGroup($pdo, $data, $auth['user_id']));
            break;
            
        case 'PUT':
            if ($identifier) {
                $groupId = intval($identifier);
                $data = json_decode(file_get_contents('php://input'), true);
                Response::success(updateGroup($pdo, $groupId, $data));
            }
            break;
            
        case 'DELETE':
            if ($identifier) {
                $groupId = intval($identifier);
                Response::success(deleteGroup($pdo, $groupId));
            }
            break;
            
        default:
            Response::error(405, "Method not allowed");
    }
    
} catch (Exception $e) {
    Response::error(500, "Internal Server Error", "An unexpected error occurred while processing your request.", $e->getMessage());
}

// ======================== Helper Functions ========================

function getAllGroups($pdo) {
    $stmt = $pdo->query("
        SELECT 
            dg.*,
            l.name as location_name,
            l.location_type,
            d.mac_address as master_mac,
            COUNT(DISTINCT dev.id) as device_count
        FROM device_groups dg
        LEFT JOIN locations l ON l.location_id = dg.location_id
        LEFT JOIN devices d ON d.id = dg.master_device_id
        LEFT JOIN devices dev ON dev.group_id = dg.group_id
        GROUP BY dg.group_id
        ORDER BY dg.created_at DESC
    ");
    
    return [
        'success' => true,
        'groups' => $stmt->fetchAll(PDO::FETCH_ASSOC)
    ];
}

function getGroup($pdo, $groupId) {
    $stmt = $pdo->prepare("
        SELECT 
            dg.*,
            l.name as location_name,
            l.location_type,
            d.mac_address as master_mac
        FROM device_groups dg
        LEFT JOIN locations l ON l.location_id = dg.location_id
        LEFT JOIN devices d ON d.id = dg.master_device_id
        WHERE dg.group_id = ?
    ");
    $stmt->execute([$groupId]);
    $group = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if (!$group) {
        http_response_code(404);
        return ['error' => 'Group not found'];
    }
    
    // Get devices in group
    $stmt = $pdo->prepare("
        SELECT 
            d.*,
            d.is_master,
            tl.temp,
            tl.power,
            tl.voltage,
            tl.current
        FROM devices d
        LEFT JOIN (
            SELECT device_id, temp, power, voltage, current
            FROM telemetry_logs
            WHERE (device_id, recorded_at) IN (
                SELECT device_id, MAX(recorded_at)
                FROM telemetry_logs
                GROUP BY device_id
            )
        ) tl ON tl.device_id = d.id
        WHERE d.group_id = ?
        ORDER BY d.is_master DESC, d.mac_address
    ");
    $stmt->execute([$groupId]);
    $group['devices'] = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    return [
        'success' => true,
        'group' => $group
    ];
}

function deleteGroup($pdo, $groupId) {
    // Remove devices from group
    $stmt = $pdo->prepare("UPDATE devices SET group_id = NULL, is_master = FALSE WHERE group_id = ?");
    $stmt->execute([$groupId]);
    
    // Delete group
    $stmt = $pdo->prepare("DELETE FROM device_groups WHERE group_id = ?");
    $stmt->execute([$groupId]);
    
    return [
        'success' => true,
        'message' => 'Group deleted successfully'
    ];
}

Batal

⬅ Naik ke v1 8 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘analytics.php	php	16.7 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘firmware.php	php	9.1 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘fleet_explorer.php	php	3.4 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘geo_stats.php	php	1.5 KB	2026-04-30 09:54	✏️ Edit 👁️ View
📄groups.php.bak	bak	7.6 KB	2026-04-30 09:54	✏️ Edit 👁️ View
📄locations.php.bak	bak	9.7 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘site_diagnostic.php	php	4.1 KB	2026-04-30 09:54	✏️ Edit 👁️ View
🐘users.php	php	12.1 KB	2026-04-30 09:54	✏️ Edit 👁️ View