librenms-librenms/includes/html/forms/show-transport-group.inc.php

<?php

/*
 * LibreNMS
 *
 * This program is free software: you can redistribute it and/or modify it
 * under the terms of the GNU General Public License as published by the
 * Free Software Foundation, either version 3 of the License, or (at your
 * option) any later version.  Please see LICENSE.txt at the top level of
 * the source code distribution for details.
 */

header('Content-type: application/json');

if (!Auth::user()->hasGlobalAdmin()) {
    die(json_encode([
        'status' => 'error',
        'message' => 'You need to be admin'
    ]));
}

$group_id = $vars['group_id'];
// Retrieve alert transport
if (is_numeric($group_id) && $group_id > 0) {
    $name = dbFetchCell('SELECT `transport_group_name` FROM `alert_transport_groups` WHERE `transport_group_id`=? LIMIT 1', [$group_id]);
    
    $query = "SELECT `a`.`transport_id`, `transport_type`, `transport_name` FROM `transport_group_transport` AS `a` LEFT JOIN `alert_transports` AS `b` ON `a`.`transport_id`=`b`.`transport_id` WHERE `transport_group_id`=?";
    
    $members = [];
    foreach (dbFetchRows($query, [$group_id]) as $member) {
        $members[] =  [
            'id' => $member['transport_id'],
            'text' => ucfirst($member['transport_type']).": ".$member['transport_name']
        ];
    }
}

if (is_array($members)) {
    die(json_encode([
        'name' => $name,
        'members' => $members
    ]));
} else {
    die(json_encode([
        'status' => 'error',
        'message' => 'No transport group found'
    ]));
}