Kimai_Database_Mysql::group_get_data PHP Method

group_get_data() public method

Returns the data of a certain group
Author: th
public group_get_data ( array $groupID ) : array
$groupID array groupID of the group
return array the group's data (name, etc) as array, false on failure
    public function group_get_data($groupID)
    {
        $filter['groupID'] = MySQL::SQLValue($groupID, MySQL::SQLVALUE_NUMBER);
        $table = $this->kga['server_prefix'] . "groups";
        $result = $this->conn->SelectRows($table, $filter);
        if (!$result) {
            $this->logLastError('group_get_data');
            return false;
        } else {
            return $this->conn->RowArray(0, MYSQLI_ASSOC);
        }
    }

Usage Example

Beispiel #1
0
/**
 * @param Kimai_Database_Mysql $database
 * @param array $kgaUser
 * @param bool $viewOtherGroupsAllowed
 * @return array
 */
function getEditUserList(Kimai_Database_Mysql $database, $kgaUser, $viewOtherGroupsAllowed)
{
    $users = array();
    $showDeletedUsers = get_cookie('adminPanel_extension_show_deleted_users', 0);
    if ($database->global_role_allows($kgaUser['globalRoleID'], 'core-user-otherGroup-view')) {
        $dbUsers = $database->get_users($showDeletedUsers);
    } else {
        $dbUsers = $database->get_users($showDeletedUsers, $kgaUser['groups']);
    }
    $roles = $database->global_roles();
    foreach ($dbUsers as $user) {
        $user['globalRoleName'] = 'Unknown (' . $user['globalRoleID'] . ')';
        foreach ($roles as $role) {
            if ($role['globalRoleID'] == $user['globalRoleID']) {
                $user['globalRoleName'] = $role['name'];
                break;
            }
        }
        $user['groups'] = array();
        $groups = $database->getGroupMemberships($user['userID']);
        if (is_array($groups)) {
            foreach ($groups as $group) {
                if (!$viewOtherGroupsAllowed && array_search($group, $kgaUser['groups']) === false) {
                    continue;
                }
                $groupData = $database->group_get_data($group);
                $user['groups'][] = $groupData['name'];
            }
        }
        $users[] = $user;
    }
    return $users;
}
Kimai_Database_Mysql