/** * get list of all users that are enlisted to a support group. * @param $group_id the id of the group we want to query * @return an array of ticket_user objects that are in the support group. */ public static function getAllUsersOfSupportGroup($group_id) { $dbl = new DBLayer("lib"); $statement = $dbl->execute("SELECT * FROM `in_support_group` INNER JOIN `ticket_user` ON ticket_user.TUserId = in_support_group.User WHERE in_support_group.Group=:id", array('id' => $group_id)); $rows = $statement->fetchAll(); $result = array(); foreach ($rows as $row) { $userInstance = new Ticket_User(); $userInstance->setTUserId($row['TUserId']); $userInstance->setPermission($row['Permission']); $userInstance->setExternId($row['ExternId']); $result[] = $userInstance; } return $result; }