/**
* Returns the group of the user and put the user's data in the session
* @param $login
* @return string
*/
private function getGroupName($login)
{
if (!isset($this->userNamespace->user)) {
$users = new Users();
$select = $users->select()->setIntegrityCheck(false)->from($users, array('users_id' => 'users.id', 'login' => 'users.login', 'usersgroups_name' => 'usersgroups.name', 'usersgroups_id' => 'usersgroups.id', 'fname' => 'users.fname', 'lname' => 'users.lname', 'email' => 'users.email', 'usersgroups_id' => 'users.usersgroups_id'))->where(' users.login LIKE ?', $login)->join('usersgroups', 'users.usersgroups_id = usersgroups.id');
$rows = $users->fetchAll($select);
$row = $rows->current();
// save the last login time
$usrDB = new Users();
$urow = $usrDB->fetchRow("id = '" . $row->users_id . "'");
$urow->lastlogindate = Sydney_Tools::getMySQLFormatedDate();
$urow->save();
$this->userNamespace->user = $row->toArray();
// define all the groups this user is part of
$groupsDB = new Usersgroups();
$this->userNamespace->user['member_of_groups'] = $groupsDB->getParentsIds($this->userNamespace->user['usersgroups_id']);
$this->userNamespace->lock();
return $row->usersgroups_name;
} else {
return $this->userNamespace->user['usersgroups_name'];
}
}
