/**
* 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;
}
/**
* change the permission of a ticket_user.
* @param $user_id the TUserId of the entry.
* @param $perm the new permission value.
*/
public static function change_permission($user_id, $perm)
{
$user = new Ticket_User();
$user->load_With_TUserId($user_id);
$user->setPermission($perm);
$user->update();
}
