<?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', 'collate' => 'utf8_general_ci'),
+ 'fullname' => array('type' => 'varchar', 'length' => 255, 'description' => 'display name', 'collate' => 'utf8_general_ci'),
+ 'profileurl' => array('type' => 'varchar', 'length' => 255, 'description' => 'URL, cached so we dont regenerate'),
+ 'homepage' => array('type' => 'varchar', 'length' => 255, 'description' => 'identifying URL', 'collate' => 'utf8_general_ci'),
+ 'bio' => array('type' => 'text', 'description' => 'descriptive biography', 'collate' => 'utf8_general_ci'),
+ 'location' => array('type' => 'varchar', 'length' => 255, 'description' => 'physical location', 'collate' => 'utf8_general_ci'),
+ '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
return $this->_user;
}
+ protected $_avatars;
+
function getAvatar($width, $height=null)
{
if (is_null($height)) {
$height = $width;
}
+ 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))) {
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 isMember($group)
{
- $gm = Group_member::pkeyGet(array('profile_id' => $this->id,
- 'group_id' => $group->id));
- return (!empty($gm));
+ $groups = $this->getGroups(0, null);
+ $gs = $groups->fetchAll();
+ foreach ($gs as $g) {
+ if ($group->id == $g->id) {
+ return true;
+ }
+ }
+ return false;
}
function isAdmin($group)
self::cacheSet($keypart, implode(',', $ids));
}
- $groups = array();
-
- foreach ($ids as $id) {
- $group = User_group::staticGet('id', $id);
- if (!empty($group)) {
- $groups[] = $group;
- }
- }
-
- return new ArrayWrapper($groups);
+ return User_group::multiGet('id', $ids);
}
function isTagged($peopletag)
return false;
}
- function getOwnedTags($auth_user, $offset=0, $limit=null, $since_id=0, $max_id=0)
+ function getLists($auth_user, $offset=0, $limit=null, $since_id=0, $max_id=0)
{
- $tags = new Profile_list();
- $tags->tagger = $this->id;
+ $ids = array();
- if (($auth_user instanceof User || $auth_user instanceof Profile) &&
- $auth_user->id === $this->id) {
- // no condition, get both private and public tags
+ $keypart = sprintf('profile:lists:%d', $this->id);
+
+ $idstr = self::cacheGet($keypart);
+
+ if ($idstr !== false) {
+ $ids = explode(',', $idstr);
} else {
- $tags->private = false;
- }
+ $list = new Profile_list();
+ $list->selectAdd();
+ $list->selectAdd('id');
+ $list->tagger = $this->id;
+ $list->selectAdd('id as "cursor"');
- $tags->selectAdd('id as "cursor"');
+ if ($since_id>0) {
+ $list->whereAdd('id > '.$since_id);
+ }
- if ($since_id>0) {
- $tags->whereAdd('id > '.$since_id);
- }
+ if ($max_id>0) {
+ $list->whereAdd('id <= '.$max_id);
+ }
- if ($max_id>0) {
- $tags->whereAdd('id <= '.$max_id);
- }
+ if($offset>=0 && !is_null($limit)) {
+ $list->limit($offset, $limit);
+ }
- if($offset>=0 && !is_null($limit)) {
- $tags->limit($offset, $limit);
+ $list->orderBy('id DESC');
+
+ if ($list->find()) {
+ while ($list->fetch()) {
+ $ids[] = $list->id;
+ }
+ }
+
+ self::cacheSet($keypart, implode(',', $ids));
}
- $tags->orderBy('id DESC');
- $tags->find();
+ $showPrivate = (($auth_user instanceof User ||
+ $auth_user instanceof Profile) &&
+ $auth_user->id === $this->id);
- return $tags;
+ $lists = array();
+
+ foreach ($ids as $id) {
+ $list = Profile_list::staticGet('id', $id);
+ if (!empty($list) &&
+ ($showPrivate || !$list->private)) {
+
+ if (!isset($list->cursor)) {
+ $list->cursor = $list->id;
+ }
+
+ $lists[] = $list;
+ }
+ }
+
+ return new ArrayWrapper($lists);
}
function getOtherTags($auth_user=null, $offset=0, $limit=null, $since_id=0, $max_id=0)
$tags->tagged = $this->id;
$lists->joinAdd($tags);
+
#@fixme: postgres (round(date_part('epoch', my_date)))
$lists->selectAdd('unix_timestamp(profile_tag.modified) as "cursor"');
$lists = new Profile_list();
$subs = new Profile_tag_subscription();
- $lists->joinAdd($subs);
+ $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"');
$faves = new Fave();
$faves->user_id = $this->id;
- $cnt = (int) $faves->count('distinct notice_id');
+ $cnt = (int) $faves->count('notice_id');
if (!empty($c)) {
$c->set(Cache::key('profile:fave_count:'.$this->id), $cnt);
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 getLists()
- {
- $ids = array();
-
- $keypart = sprintf('profile:lists:%d', $this->id);
-
- $idstr = self::cacheGet($keypart);
-
- if ($idstr !== false) {
- $ids = explode(',', $idstr);
- } else {
- $list = new Profile_list();
- $list->selectAdd();
- $list->selectAdd('id');
- $list->tagger = $this->id;
-
- if ($list->find()) {
- while ($list->fetch()) {
- $ids[] = $list->id;
- }
- }
-
- self::cacheSet($keypart, implode(',', $ids));
- }
-
- $lists = array();
-
- foreach ($ids as $id) {
- $lists[] = Profile_list::staticGet('id', $id);
- }
+ /**
+ * 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.
+ */
- return new ArrayWrapper($lists);
+ 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]);
+ }
}
}
projects / quix0rs-gnu-social.git / blobdiff