<?php
/*
* StatusNet - the distributed open-source microblogging tool
- * Copyright (C) 2008, 2009, StatusNet, Inc.
+ * Copyright (C) 2008-2011, StatusNet, Inc.
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
*/
require_once INSTALLDIR.'/classes/Memcached_DataObject.php';
-class Profile extends Memcached_DataObject
+class Profile extends Managed_DataObject
{
###START_AUTOCODE
/* the code below is auto generated do not remove the above tag */
return Memcached_DataObject::staticGet('Profile',$k,$v);
}
+ public static function schemaDef()
+ {
+ return array(
+ 'description' => 'local and remote users have profiles',
+ 'fields' => array(
+ 'id' => array('type' => 'serial', 'not null' => true, 'description' => 'unique identifier'),
+ 'nickname' => array('type' => 'varchar', 'length' => 64, 'not null' => true, 'description' => 'nickname or username'),
+ 'fullname' => array('type' => 'varchar', 'length' => 255, 'description' => 'display name'),
+ 'profileurl' => array('type' => 'varchar', 'length' => 255, 'description' => 'URL, cached so we dont regenerate'),
+ 'homepage' => array('type' => 'varchar', 'length' => 255, 'description' => 'identifying URL'),
+ 'bio' => array('type' => 'text', 'description' => 'descriptive biography'),
+ 'location' => array('type' => 'varchar', 'length' => 255, 'description' => 'physical location'),
+ 'lat' => array('type' => 'numeric', 'precision' => 10, 'scale' => 7, 'description' => 'latitude'),
+ 'lon' => array('type' => 'numeric', 'precision' => 10, 'scale' => 7, 'description' => 'longitude'),
+ 'location_id' => array('type' => 'int', 'description' => 'location id if possible'),
+ 'location_ns' => array('type' => 'int', 'description' => 'namespace for location'),
+
+ 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date this record was created'),
+ 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
+ ),
+ 'primary key' => array('id'),
+ 'indexes' => array(
+ 'profile_nickname_idx' => array('nickname'),
+ ),
+ 'fulltext indexes' => array(
+ 'nickname' => array('nickname', 'fullname', 'location', 'bio', 'homepage')
+ ),
+ );
+ }
+
+ function multiGet($keyCol, $keyVals, $skipNulls=true)
+ {
+ return parent::multiGet('Profile', $keyCol, $keyVals, $skipNulls);
+ }
+
/* the code above is auto generated do not remove the tag below */
###END_AUTOCODE
+ protected $_user = -1; // Uninitialized value distinct from null
+
function getUser()
{
- return User::staticGet('id', $this->id);
+ if (is_int($this->_user) && $this->_user == -1) {
+ $this->_user = User::staticGet('id', $this->id);
+ }
+
+ return $this->_user;
}
+ protected $_avatars;
+
function getAvatar($width, $height=null)
{
if (is_null($height)) {
$height = $width;
}
- return Avatar::pkeyGet(array('profile_id' => $this->id,
- 'width' => $width,
- 'height' => $height));
+
+ if (!isset($this->_avatars)) {
+ $this->_avatars = array();
+ }
+
+ if (array_key_exists($width, $this->_avatars)) {
+ return $this->_avatars[$width];
+ }
+
+ $avatar = null;
+
+ if (Event::handle('StartProfileGetAvatar', array($this, $width, &$avatar))) {
+ $avatar = Avatar::pkeyGet(array('profile_id' => $this->id,
+ 'width' => $width,
+ 'height' => $height));
+ Event::handle('EndProfileGetAvatar', array($this, $width, &$avatar));
+ }
+
+ $this->_avatars[$width] = $avatar;
+
+ return $avatar;
}
+ function _fillAvatar($width, $avatar)
+ {
+ $this->_avatars[$width] = $avatar;
+ }
+
function getOriginalAvatar()
{
$avatar = DB_DataObject::factory('avatar');
function getFancyName()
{
if ($this->fullname) {
- // TRANS: Full name of a profile or group followed by nickname in parens
+ // TRANS: Full name of a profile or group (%1$s) followed by nickname (%2$s) in parentheses.
return sprintf(_m('FANCYNAME','%1$s (%2$s)'), $this->fullname, $this->nickname);
} else {
return $this->nickname;
*
* @return mixed Notice or null
*/
-
function getCurrentNotice()
{
$notice = $this->getNotices(0, 1);
function getTaggedNotices($tag, $offset=0, $limit=NOTICES_PER_PAGE, $since_id=0, $max_id=0)
{
- $stream = new NoticeStream(array($this, '_streamTaggedDirect'),
- array($tag),
- 'profile:notice_ids_tagged:'.$this->id.':'.$tag);
+ $stream = new TaggedProfileNoticeStream($this, $tag);
return $stream->getNotices($offset, $limit, $since_id, $max_id);
}
function getNotices($offset=0, $limit=NOTICES_PER_PAGE, $since_id=0, $max_id=0)
{
- $stream = new NoticeStream(array($this, '_streamDirect'),
- array(),
- 'profile:notice_ids:' . $this->id);
+ $stream = new ProfileNoticeStream($this);
return $stream->getNotices($offset, $limit, $since_id, $max_id);
}
- function _streamTaggedDirect($tag, $offset, $limit, $since_id, $max_id)
+ function isMember($group)
{
- // XXX It would be nice to do this without a join
- // (necessary to do it efficiently on accounts with long history)
+ $groups = $this->getGroups(0, null);
+ $gs = $groups->fetchAll();
+ foreach ($gs as $g) {
+ if ($group->id == $g->id) {
+ return true;
+ }
+ }
+ return false;
+ }
- $notice = new Notice();
+ function isAdmin($group)
+ {
+ $gm = Group_member::pkeyGet(array('profile_id' => $this->id,
+ 'group_id' => $group->id));
+ return (!empty($gm) && $gm->is_admin);
+ }
+
+ function isPendingMember($group)
+ {
+ $request = Group_join_queue::pkeyGet(array('profile_id' => $this->id,
+ 'group_id' => $group->id));
+ return !empty($request);
+ }
- $query =
- "select id from notice join notice_tag on id=notice_id where tag='".
- $notice->escape($tag) .
- "' and profile_id=" . intval($this->id);
+ function getGroups($offset=0, $limit=PROFILES_PER_PAGE)
+ {
+ $ids = array();
- $since = Notice::whereSinceId($since_id, 'id', 'notice.created');
- if ($since) {
- $query .= " and ($since)";
- }
+ $keypart = sprintf('profile:groups:%d', $this->id);
+
+ $idstring = self::cacheGet($keypart);
- $max = Notice::whereMaxId($max_id, 'id', 'notice.created');
- if ($max) {
- $query .= " and ($max)";
+ if ($idstring !== false) {
+ $ids = explode(',', $idstring);
+ } else {
+ $gm = new Group_member();
+
+ $gm->profile_id = $this->id;
+
+ if ($gm->find()) {
+ while ($gm->fetch()) {
+ $ids[] = $gm->group_id;
+ }
+ }
+
+ self::cacheSet($keypart, implode(',', $ids));
}
- $query .= ' order by notice.created DESC, id DESC';
+ return User_group::multiGet('id', $ids);
+ }
+
+ function isTagged($peopletag)
+ {
+ $tag = Profile_tag::pkeyGet(array('tagger' => $peopletag->tagger,
+ 'tagged' => $this->id,
+ 'tag' => $peopletag->tag));
+ return !empty($tag);
+ }
- if (!is_null($offset)) {
- $query .= " LIMIT " . intval($limit) . " OFFSET " . intval($offset);
+ function canTag($tagged)
+ {
+ if (empty($tagged)) {
+ return false;
}
- $notice->query($query);
+ if ($tagged->id == $this->id) {
+ return true;
+ }
- $ids = array();
+ $all = common_config('peopletag', 'allow_tagging', 'all');
+ $local = common_config('peopletag', 'allow_tagging', 'local');
+ $remote = common_config('peopletag', 'allow_tagging', 'remote');
+ $subs = common_config('peopletag', 'allow_tagging', 'subs');
- while ($notice->fetch()) {
- $ids[] = $notice->id;
+ if ($all) {
+ return true;
}
- return $ids;
+ $tagged_user = $tagged->getUser();
+ if (!empty($tagged_user)) {
+ if ($local) {
+ return true;
+ }
+ } else if ($subs) {
+ return (Subscription::exists($this, $tagged) ||
+ Subscription::exists($tagged, $this));
+ } else if ($remote) {
+ return true;
+ }
+ return false;
}
- function _streamDirect($offset, $limit, $since_id, $max_id)
+ function getLists($auth_user, $offset=0, $limit=null, $since_id=0, $max_id=0)
{
- $notice = new Notice();
+ $ids = array();
- $notice->profile_id = $this->id;
+ $keypart = sprintf('profile:lists:%d', $this->id);
- $notice->selectAdd();
- $notice->selectAdd('id');
+ $idstr = self::cacheGet($keypart);
- Notice::addWhereSinceId($notice, $since_id);
- Notice::addWhereMaxId($notice, $max_id);
+ if ($idstr !== false) {
+ $ids = explode(',', $idstr);
+ } else {
+ $list = new Profile_list();
+ $list->selectAdd();
+ $list->selectAdd('id');
+ $list->tagger = $this->id;
+ $list->selectAdd('id as "cursor"');
+
+ if ($since_id>0) {
+ $list->whereAdd('id > '.$since_id);
+ }
- $notice->orderBy('created DESC, id DESC');
+ if ($max_id>0) {
+ $list->whereAdd('id <= '.$max_id);
+ }
- if (!is_null($offset)) {
- $notice->limit($offset, $limit);
+ if($offset>=0 && !is_null($limit)) {
+ $list->limit($offset, $limit);
+ }
+
+ $list->orderBy('id DESC');
+
+ if ($list->find()) {
+ while ($list->fetch()) {
+ $ids[] = $list->id;
+ }
+ }
+
+ self::cacheSet($keypart, implode(',', $ids));
}
- $notice->find();
+ $showPrivate = (($auth_user instanceof User ||
+ $auth_user instanceof Profile) &&
+ $auth_user->id === $this->id);
- $ids = array();
+ $lists = array();
+
+ foreach ($ids as $id) {
+ $list = Profile_list::staticGet('id', $id);
+ if (!empty($list) &&
+ ($showPrivate || !$list->private)) {
- while ($notice->fetch()) {
- $ids[] = $notice->id;
+ if (!isset($list->cursor)) {
+ $list->cursor = $list->id;
+ }
+
+ $lists[] = $list;
+ }
}
- return $ids;
+ return new ArrayWrapper($lists);
}
- function isMember($group)
+ function getOtherTags($auth_user=null, $offset=0, $limit=null, $since_id=0, $max_id=0)
{
- $mem = new Group_member();
+ $lists = new Profile_list();
- $mem->group_id = $group->id;
- $mem->profile_id = $this->id;
+ $tags = new Profile_tag();
+ $tags->tagged = $this->id;
- if ($mem->find()) {
- return true;
+ $lists->joinAdd($tags);
+
+ #@fixme: postgres (round(date_part('epoch', my_date)))
+ $lists->selectAdd('unix_timestamp(profile_tag.modified) as "cursor"');
+
+ if ($auth_user instanceof User || $auth_user instanceof Profile) {
+ $lists->whereAdd('( ( profile_list.private = false ) ' .
+ 'OR ( profile_list.tagger = ' . $auth_user->id . ' AND ' .
+ 'profile_list.private = true ) )');
} else {
- return false;
+ $lists->private = false;
+ }
+
+ if ($since_id>0) {
+ $lists->whereAdd('cursor > '.$since_id);
+ }
+
+ if ($max_id>0) {
+ $lists->whereAdd('cursor <= '.$max_id);
+ }
+
+ if($offset>=0 && !is_null($limit)) {
+ $lists->limit($offset, $limit);
}
+
+ $lists->orderBy('profile_tag.modified DESC');
+ $lists->find();
+
+ return $lists;
}
- function isAdmin($group)
+ function getPrivateTags($offset=0, $limit=null, $since_id=0, $max_id=0)
{
- $mem = new Group_member();
+ $tags = new Profile_list();
+ $tags->private = true;
+ $tags->tagger = $this->id;
- $mem->group_id = $group->id;
- $mem->profile_id = $this->id;
- $mem->is_admin = 1;
+ if ($since_id>0) {
+ $tags->whereAdd('id > '.$since_id);
+ }
- if ($mem->find()) {
- return true;
- } else {
- return false;
+ if ($max_id>0) {
+ $tags->whereAdd('id <= '.$max_id);
+ }
+
+ if($offset>=0 && !is_null($limit)) {
+ $tags->limit($offset, $limit);
}
+
+ $tags->orderBy('id DESC');
+ $tags->find();
+
+ return $tags;
}
- function isPendingMember($group)
+ function hasLocalTags()
{
- $request = Group_join_queue::pkeyGet(array('profile_id' => $this->id,
- 'group_id' => $group->id));
- return !empty($request);
+ $tags = new Profile_tag();
+
+ $tags->joinAdd(array('tagger', 'user:id'));
+ $tags->whereAdd('tagged = '.$this->id);
+ $tags->whereAdd('tagger != '.$this->id);
+
+ $tags->limit(0, 1);
+ $tags->fetch();
+
+ return ($tags->N == 0) ? false : true;
}
- function getGroups($offset=0, $limit=null)
+ function getTagSubscriptions($offset=0, $limit=null, $since_id=0, $max_id=0)
{
- $qry =
- 'SELECT user_group.* ' .
- 'FROM user_group JOIN group_member '.
- 'ON user_group.id = group_member.group_id ' .
- 'WHERE group_member.profile_id = %d ' .
- 'ORDER BY group_member.created DESC ';
-
- if ($offset>0 && !is_null($limit)) {
- if ($offset) {
- if (common_config('db','type') == 'pgsql') {
- $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
- } else {
- $qry .= ' LIMIT ' . $offset . ', ' . $limit;
- }
- }
+ $lists = new Profile_list();
+ $subs = new Profile_tag_subscription();
+
+ $lists->joinAdd('id', 'profile_tag_subscription:profile_tag_id');
+
+ #@fixme: postgres (round(date_part('epoch', my_date)))
+ $lists->selectAdd('unix_timestamp(profile_tag_subscription.created) as "cursor"');
+
+ $lists->whereAdd('profile_tag_subscription.profile_id = '.$this->id);
+
+ if ($since_id>0) {
+ $lists->whereAdd('cursor > '.$since_id);
}
- $groups = new User_group();
+ if ($max_id>0) {
+ $lists->whereAdd('cursor <= '.$max_id);
+ }
- $cnt = $groups->query(sprintf($qry, $this->id));
+ if($offset>=0 && !is_null($limit)) {
+ $lists->limit($offset, $limit);
+ }
- return $groups;
+ $lists->orderBy('"cursor" DESC');
+ $lists->find();
+
+ return $lists;
}
/**
} else {
if (Event::handle('StartJoinGroup', array($group, $this))) {
$join = Group_member::join($group->id, $this->id);
+ self::blow('profile:groups:%d', $this->id);
Event::handle('EndJoinGroup', array($group, $this));
}
}
return $join;
}
- /**
- * Cancel a pending group join...
- *
- * @param User_group $group
- */
- function cancelJoinGroup(User_group $group)
- {
- $request = Group_join_queue::pkeyGet(array('profile_id' => $this->id,
- 'group_id' => $group->id));
- if ($request) {
- if (Event::handle('StartCancelJoinGroup', array($group, $this))) {
- $request->delete();
- Event::handle('EndCancelJoinGroup', array($group, $this));
- }
- }
- }
-
- /**
- * Complete a pending group join on our end...
- *
- * @param User_group $group
- */
- function completeJoinGroup(User_group $group)
- {
- $join = null;
- $request = Group_join_queue::pkeyGet(array('profile_id' => $this->id,
- 'group_id' => $group->id));
- if ($request) {
- if (Event::handle('StartJoinGroup', array($group, $this))) {
- $join = Group_member::join($group->id, $this->id);
- $request->delete();
- Event::handle('EndJoinGroup', array($group, $this));
- }
- } else {
- // TRANS: Exception thrown trying to approve a non-existing group join request.
- throw new Exception(_('Invalid group join approval: not pending.'));
- }
- if ($join) {
- $join->notify();
- }
- return $join;
- }
-
/**
* Leave a group that this profile is a member of.
*
{
if (Event::handle('StartLeaveGroup', array($group, $this))) {
Group_member::leave($group->id, $this->id);
+ self::blow('profile:groups:%d', $this->id);
Event::handle('EndLeaveGroup', array($group, $this));
}
}
return new ArrayWrapper($profiles);
}
+ function getTaggedSubscribers($tag)
+ {
+ $qry =
+ 'SELECT profile.* ' .
+ 'FROM profile JOIN (subscription, profile_tag, profile_list) ' .
+ 'ON profile.id = subscription.subscriber ' .
+ 'AND profile.id = profile_tag.tagged ' .
+ 'AND profile_tag.tagger = profile_list.tagger AND profile_tag.tag = profile_list.tag ' .
+ 'WHERE subscription.subscribed = %d ' .
+ 'AND subscription.subscribed != subscription.subscriber ' .
+ 'AND profile_tag.tagger = %d AND profile_tag.tag = "%s" ' .
+ 'AND profile_list.private = false ' .
+ 'ORDER BY subscription.created DESC';
+
+ $profile = new Profile();
+ $tagged = array();
+
+ $cnt = $profile->query(sprintf($qry, $this->id, $this->id, $tag));
+
+ while ($profile->fetch()) {
+ $tagged[] = clone($profile);
+ }
+ return $tagged;
+ }
+
+ /**
+ * Get pending subscribers, who have not yet been approved.
+ *
+ * @param int $offset
+ * @param int $limit
+ * @return Profile
+ */
+ function getRequests($offset=0, $limit=null)
+ {
+ $qry =
+ 'SELECT profile.* ' .
+ 'FROM profile JOIN subscription_queue '.
+ 'ON profile.id = subscription_queue.subscriber ' .
+ 'WHERE subscription_queue.subscribed = %d ' .
+ 'ORDER BY subscription_queue.created DESC ';
+
+ if ($limit != null) {
+ if (common_config('db','type') == 'pgsql') {
+ $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
+ } else {
+ $qry .= ' LIMIT ' . $offset . ', ' . $limit;
+ }
+ }
+
+ $members = new Profile();
+
+ $members->query(sprintf($qry, $this->id));
+ return $members;
+ }
+
function subscriptionCount()
{
$c = Cache::instance();
return Subscription::exists($this, $other);
}
+ /**
+ * Check if a pending subscription request is outstanding for this...
+ *
+ * @param Profile $other
+ * @return boolean
+ */
+ function hasPendingSubscription($other)
+ {
+ return Subscription_queue::exists($this, $other);
+ }
+
/**
* Are these two profiles subscribed to each other?
*
function hasFave($notice)
{
- $cache = Cache::instance();
-
- // XXX: Kind of a hack.
-
- if (!empty($cache)) {
- // This is the stream of favorite notices, in rev chron
- // order. This forces it into cache.
-
- $ids = Fave::idStream($this->id, 0, NoticeStream::CACHE_WINDOW);
-
- // If it's in the list, then it's a fave
-
- if (in_array($notice->id, $ids)) {
- return true;
- }
-
- // If we're not past the end of the cache window,
- // then the cache has all available faves, so this one
- // is not a fave.
-
- if (count($ids) < NoticeStream::CACHE_WINDOW) {
- return false;
- }
-
- // Otherwise, cache doesn't have all faves;
- // fall through to the default
- }
-
$fave = Fave::pkeyGet(array('user_id' => $this->id,
'notice_id' => $notice->id));
return ((is_null($fave)) ? false : true);
if (!empty($user)) {
$uri = $user->uri;
- } else {
- // return OMB profile if any
- $remote = Remote_profile::staticGet('id', $this->id);
- if (!empty($remote)) {
- $uri = $remote->uri;
- }
}
+
Event::handle('EndGetProfileUri', array($this, &$uri));
}
$user = User::staticGet('uri', $uri);
if (!empty($user)) {
$profile = $user->getProfile();
- } else {
- $remote_profile = Remote_profile::staticGet('uri', $uri);
- if (!empty($remote_profile)) {
- $profile = Profile::staticGet('id', $remote_profile->profile_id);
- }
}
Event::handle('EndGetProfileFromURI', array($uri, $profile));
}
return $profile;
}
+
+ function canRead(Notice $notice)
+ {
+ if ($notice->scope & Notice::SITE_SCOPE) {
+ $user = $this->getUser();
+ if (empty($user)) {
+ return false;
+ }
+ }
+
+ if ($notice->scope & Notice::ADDRESSEE_SCOPE) {
+ $replies = $notice->getReplies();
+
+ if (!in_array($this->id, $replies)) {
+ $groups = $notice->getGroups();
+
+ $foundOne = false;
+
+ foreach ($groups as $group) {
+ if ($this->isMember($group)) {
+ $foundOne = true;
+ break;
+ }
+ }
+
+ if (!$foundOne) {
+ return false;
+ }
+ }
+ }
+
+ if ($notice->scope & Notice::FOLLOWER_SCOPE) {
+ $author = $notice->getProfile();
+ if (!Subscription::exists($this, $author)) {
+ return false;
+ }
+ }
+
+ return true;
+ }
+
+ static function current()
+ {
+ $user = common_current_user();
+ if (empty($user)) {
+ $profile = null;
+ } else {
+ $profile = $user->getProfile();
+ }
+ return $profile;
+ }
+
+ /**
+ * Magic function called at serialize() time.
+ *
+ * We use this to drop a couple process-specific references
+ * from DB_DataObject which can cause trouble in future
+ * processes.
+ *
+ * @return array of variable names to include in serialization.
+ */
+
+ function __sleep()
+ {
+ $vars = parent::__sleep();
+ $skip = array('_user', '_avatars');
+ return array_diff($vars, $skip);
+ }
+
+ static function fillAvatars(&$profiles, $width)
+ {
+ $ids = array();
+ foreach ($profiles as $profile) {
+ $ids[] = $profile->id;
+ }
+
+ $avatars = Avatar::pivotGet('profile_id', $ids, array('width' => $width,
+ 'height' => $width));
+
+ foreach ($profiles as $profile) {
+ $profile->_fillAvatar($width, $avatars[$profile->id]);
+ }
+ }
}