Example #1
0
    public function getUserData()
    {
        if (Session::getActiveUserid() == 0) {
            return false;
        }
        $sql = 'SELECT 
					UD.firstname, 
					UD.surname, 
					UD.email, 
					UG.groupid,
					U.globaluser
					FROM userdata UD
					LEFT JOIN user U ON UD.userid = U.iduser
					LEFT JOIN usergroup UG ON UG.userid = UD.userid 
					WHERE UD.userid = :userid';
        $stmt = Db::getInstance()->prepare($sql);
        $stmt->bindValue('userid', Session::getActiveUserid());
        $stmt->execute();
        $rs = $stmt->fetch();
        if ($rs) {
            Session::setActiveUserFirstname($rs['firstname']);
            Session::setActiveUserSurname($rs['surname']);
            Session::setActiveUserEmail($rs['email']);
            Session::setActiveUserGroupid($rs['groupid']);
            Session::setActiveStoreData($this->getUserStoresDataByGroupId($rs['groupid']));
            Session::setActiveUserIsGlobal($rs['globaluser']);
        }
        return true;
    }