123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451 |
- <?php
- // This file is part of GNU social - https://www.gnu.org/software/social
- //
- // GNU social is free software: you can redistribute it and/or modify
- // it under the terms of the GNU Affero General Public License as published by
- // the Free Software Foundation, either version 3 of the License, or
- // (at your option) any later version.
- //
- // GNU social is distributed in the hope that it will be useful,
- // but WITHOUT ANY WARRANTY; without even the implied warranty of
- // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- // GNU Affero General Public License for more details.
- //
- // You should have received a copy of the GNU Affero General Public License
- // along with GNU social. If not, see <http://www.gnu.org/licenses/>.
- /**
- * @copyright 2008, 2009, StatusNet, Inc.
- * @license https://www.gnu.org/licenses/agpl.html GNU AGPL v3 or later
- */
- defined('GNUSOCIAL') || die();
- /**
- * Table Definition for subscription
- */
- class Subscription extends Managed_DataObject
- {
- const CACHE_WINDOW = 201;
- const FORCE = true;
- public $__table = 'subscription'; // table name
- public $subscriber; // int(4) primary_key not_null
- public $subscribed; // int(4) primary_key not_null
- public $jabber; // bool default_true
- public $sms; // bool default_true
- public $token; // varchar(191) not 255 because utf8mb4 takes more space
- public $secret; // varchar(191) not 255 because utf8mb4 takes more space
- public $uri; // varchar(191) not 255 because utf8mb4 takes more space
- public $created; // datetime() not_null default_0000-00-00%2000%3A00%3A00
- public $modified; // datetime() not_null default_CURRENT_TIMESTAMP
- public static function schemaDef()
- {
- return array(
- 'fields' => array(
- 'subscriber' => array('type' => 'int', 'not null' => true, 'description' => 'profile listening'),
- 'subscribed' => array('type' => 'int', 'not null' => true, 'description' => 'profile being listened to'),
- 'jabber' => array('type' => 'bool', 'default' => true, 'description' => 'deliver jabber messages'),
- 'sms' => array('type' => 'bool', 'default' => true, 'description' => 'deliver sms messages'),
- 'token' => array('type' => 'varchar', 'length' => 191, 'description' => 'authorization token'),
- 'secret' => array('type' => 'varchar', 'length' => 191, 'description' => 'token secret'),
- 'uri' => array('type' => 'varchar', 'length' => 191, 'description' => 'universally unique identifier'),
- 'created' => array('type' => 'datetime', 'not null' => true, 'default' => '0000-00-00 00:00:00', 'description' => 'date this record was created'),
- 'modified' => array('type' => 'datetime', 'not null' => true, 'default' => 'CURRENT_TIMESTAMP', 'description' => 'date this record was modified'),
- ),
- 'primary key' => array('subscriber', 'subscribed'),
- 'unique keys' => array(
- 'subscription_uri_key' => array('uri'),
- ),
- 'indexes' => array(
- 'subscription_subscriber_idx' => array('subscriber', 'created'),
- 'subscription_subscribed_idx' => array('subscribed', 'created'),
- 'subscription_token_idx' => array('token'),
- ),
- );
- }
- /**
- * Make a new subscription
- *
- * @param Profile $subscriber party to receive new notices
- * @param Profile $other party sending notices; publisher
- * @param bool $force pass Subscription::FORCE to override local subscription approval
- *
- * @return mixed Subscription or Subscription_queue: new subscription info
- */
- public static function start(Profile $subscriber, Profile $other, $force = false)
- {
- if (!$subscriber->hasRight(Right::SUBSCRIBE)) {
- // TRANS: Exception thrown when trying to subscribe while being banned from subscribing.
- throw new Exception(_('You have been banned from subscribing.'));
- }
- if (self::exists($subscriber, $other)) {
- // TRANS: Exception thrown when trying to subscribe while already subscribed.
- throw new AlreadyFulfilledException(_('Already subscribed!'));
- }
- if ($other->hasBlocked($subscriber)) {
- // TRANS: Exception thrown when trying to subscribe to a user who has blocked the subscribing user.
- throw new Exception(_('User has blocked you.'));
- }
- if (Event::handle('StartSubscribe', array($subscriber, $other))) {
- // unless subscription is forced, the user policy for subscription approvals is tested
- if (!$force && $other->requiresSubscriptionApproval($subscriber)) {
- try {
- $sub = Subscription_queue::saveNew($subscriber, $other);
- $sub->notify();
- } catch (AlreadyFulfilledException $e) {
- $sub = Subscription_queue::getSubQueue($subscriber, $other);
- }
- } else {
- $otherUser = User::getKV('id', $other->id);
- $sub = self::saveNew($subscriber, $other);
- $sub->notify();
- self::blow('user:notices_with_friends:%d', $subscriber->id);
- self::blow('subscription:by-subscriber:'.$subscriber->id);
- self::blow('subscription:by-subscribed:'.$other->id);
- $subscriber->blowSubscriptionCount();
- $other->blowSubscriberCount();
- if ($otherUser instanceof User &&
- $otherUser->autosubscribe &&
- !self::exists($other, $subscriber) &&
- !$subscriber->hasBlocked($other)) {
- try {
- self::start($other, $subscriber);
- } catch (AlreadyFulfilledException $e) {
- // This shouldn't happen due to !self::exists above
- common_debug('Tried to autosubscribe a user to its new subscriber.');
- } catch (Exception $e) {
- common_log(LOG_ERR, "Exception during autosubscribe of {$other->nickname} to profile {$subscriber->id}: {$e->getMessage()}");
- }
- }
- }
- if ($sub instanceof Subscription) { // i.e. not Subscription_queue
- Event::handle('EndSubscribe', array($subscriber, $other));
- }
- }
- return $sub;
- }
- public static function ensureStart(Profile $subscriber, Profile $other, $force = false)
- {
- try {
- $sub = self::start($subscriber, $other, $force);
- } catch (AlreadyFulfilledException $e) {
- return self::getSubscription($subscriber, $other);
- }
- return $sub;
- }
- /**
- * Low-level subscription save.
- * Outside callers should use Subscription::start()
- */
- protected static function saveNew(Profile $subscriber, Profile $other)
- {
- $sub = new Subscription();
- $sub->subscriber = $subscriber->getID();
- $sub->subscribed = $other->getID();
- $sub->jabber = true;
- $sub->sms = true;
- $sub->created = common_sql_now();
- $sub->uri = self::newUri(
- $subscriber,
- $other,
- $sub->created
- );
- $result = $sub->insert();
- if ($result===false) {
- common_log_db_error($sub, 'INSERT', __FILE__);
- // TRANS: Exception thrown when a subscription could not be stored on the server.
- throw new Exception(_('Could not save subscription.'));
- }
- return $sub;
- }
- public function notify()
- {
- // XXX: add other notifications (Jabber, SMS) here
- // XXX: queue this and handle it offline
- // XXX: Whatever happens, do it in Twitter-like API, too
- $this->notifyEmail();
- }
- public function notifyEmail()
- {
- $subscribedUser = User::getKV('id', $this->subscribed);
- if ($subscribedUser instanceof User) {
- $subscriber = Profile::getKV('id', $this->subscriber);
- mail_subscribe_notify_profile($subscribedUser, $subscriber);
- }
- }
- /**
- * Cancel a subscription
- *
- */
- public static function cancel(Profile $subscriber, Profile $other)
- {
- if (!self::exists($subscriber, $other)) {
- // TRANS: Exception thrown when trying to unsibscribe without a subscription.
- throw new AlreadyFulfilledException(_('Not subscribed!'));
- }
- // Don't allow deleting self subs
- if ($subscriber->id == $other->id) {
- // TRANS: Exception thrown when trying to unsubscribe a user from themselves.
- throw new Exception(_('Could not delete self-subscription.'));
- }
- if (Event::handle('StartUnsubscribe', array($subscriber, $other))) {
- $sub = Subscription::pkeyGet(array('subscriber' => $subscriber->id,
- 'subscribed' => $other->id));
- // note we checked for existence above
- assert(!empty($sub));
- $result = $sub->delete();
- if (!$result) {
- common_log_db_error($sub, 'DELETE', __FILE__);
- // TRANS: Exception thrown when a subscription could not be deleted on the server.
- throw new Exception(_('Could not delete subscription.'));
- }
- self::blow('user:notices_with_friends:%d', $subscriber->id);
- self::blow('subscription:by-subscriber:'.$subscriber->id);
- self::blow('subscription:by-subscribed:'.$other->id);
- $subscriber->blowSubscriptionCount();
- $other->blowSubscriberCount();
- Event::handle('EndUnsubscribe', array($subscriber, $other));
- }
- return;
- }
- public static function exists(Profile $subscriber, Profile $other)
- {
- try {
- $sub = self::getSubscription($subscriber, $other);
- } catch (NoResultException $e) {
- return false;
- }
- return true;
- }
- public static function getSubscription(Profile $subscriber, Profile $other)
- {
- // This is essentially a pkeyGet but we have an object to return in NoResultException
- $sub = new Subscription();
- $sub->subscriber = $subscriber->id;
- $sub->subscribed = $other->id;
- if (!$sub->find(true)) {
- throw new NoResultException($sub);
- }
- return $sub;
- }
- public function getSubscriber()
- {
- return Profile::getByID($this->subscriber);
- }
- public function getSubscribed()
- {
- return Profile::getByID($this->subscribed);
- }
- public function asActivity()
- {
- $subscriber = $this->getSubscriber();
- $subscribed = $this->getSubscribed();
- $act = new Activity();
- $act->verb = ActivityVerb::FOLLOW;
- // XXX: rationalize this with the URL
- $act->id = $this->getUri();
- $act->time = strtotime($this->created);
- // TRANS: Activity title when subscribing to another person.
- $act->title = _m('TITLE', 'Follow');
- // TRANS: Notification given when one person starts following another.
- // TRANS: %1$s is the subscriber, %2$s is the subscribed.
- $act->content = sprintf(
- _('%1$s is now following %2$s.'),
- $subscriber->getBestName(),
- $subscribed->getBestName()
- );
- $act->actor = $subscriber->asActivityObject();
- $act->objects[] = $subscribed->asActivityObject();
- $url = common_local_url(
- 'AtomPubShowSubscription',
- [
- 'subscriber' => $subscriber->id,
- 'subscribed' => $subscribed->id,
- ]
- );
- $act->selfLink = $url;
- $act->editLink = $url;
- return $act;
- }
- /**
- * Stream of subscriptions with the same subscriber
- *
- * Useful for showing pages that list subscriptions in reverse
- * chronological order. Has offset & limit to make paging
- * easy.
- *
- * @param integer $profile_id ID of the subscriber profile
- * @param integer $offset Offset from latest
- * @param integer $limit Maximum number to fetch
- *
- * @return Subscription stream of subscriptions; use fetch() to iterate
- */
- public static function bySubscriber($profile_id, $offset = 0, $limit = PROFILES_PER_PAGE)
- {
- // "by subscriber" means it is the list of subscribed users we want
- $ids = self::getSubscribedIDs($profile_id, $offset, $limit);
- return Subscription::listFind('subscribed', $ids);
- }
- /**
- * Stream of subscriptions with the same subscriber
- *
- * Useful for showing pages that list subscriptions in reverse
- * chronological order. Has offset & limit to make paging
- * easy.
- *
- * @param integer $profile_id ID of the subscribed profile
- * @param integer $offset Offset from latest
- * @param integer $limit Maximum number to fetch
- *
- * @return Subscription stream of subscriptions; use fetch() to iterate
- */
- public static function bySubscribed($profile_id, $offset = 0, $limit = PROFILES_PER_PAGE)
- {
- // "by subscribed" means it is the list of subscribers we want
- $ids = self::getSubscriberIDs($profile_id, $offset, $limit);
- return Subscription::listFind('subscriber', $ids);
- }
- // The following are helper functions to the subscription lists,
- // notably the public ones get used in places such as Profile
- public static function getSubscribedIDs($profile_id, $offset, $limit)
- {
- return self::getSubscriptionIDs('subscribed', $profile_id, $offset, $limit);
- }
- public static function getSubscriberIDs($profile_id, $offset, $limit)
- {
- return self::getSubscriptionIDs('subscriber', $profile_id, $offset, $limit);
- }
- private static function getSubscriptionIDs($get_type, $profile_id, $offset, $limit)
- {
- switch ($get_type) {
- case 'subscribed':
- $by_type = 'subscriber';
- break;
- case 'subscriber':
- $by_type = 'subscribed';
- break;
- default:
- throw new Exception('Bad type argument to getSubscriptionIDs');
- }
- $cacheKey = 'subscription:by-'.$by_type.':'.$profile_id;
- $queryoffset = $offset;
- $querylimit = $limit;
- if ($offset + $limit <= self::CACHE_WINDOW) {
- // Oh, it seems it should be cached
- $ids = self::cacheGet($cacheKey);
- if (is_array($ids)) {
- return array_slice($ids, $offset, $limit);
- }
- // Being here indicates we didn't find anything cached
- // so we'll have to fill it up simultaneously
- $queryoffset = 0;
- $querylimit = self::CACHE_WINDOW;
- }
- $sub = new Subscription();
- $sub->$by_type = $profile_id;
- $sub->selectAdd($get_type);
- $sub->whereAdd($get_type . ' <> ' . $profile_id);
- $sub->orderBy('created DESC');
- $sub->limit($queryoffset, $querylimit);
- if (!$sub->find()) {
- return array();
- }
- $ids = $sub->fetchAll($get_type);
- // If we're simultaneously filling up cache, remember to slice
- if ($queryoffset === 0 && $querylimit === self::CACHE_WINDOW) {
- self::cacheSet($cacheKey, $ids);
- return array_slice($ids, $offset, $limit);
- }
- return $ids;
- }
- /**
- * Flush cached subscriptions when subscription is updated
- *
- * Because we cache subscriptions, it's useful to flush them
- * here.
- *
- * @param mixed $dataObject Original version of object
- *
- * @return boolean success flag.
- */
- public function update($dataObject = false)
- {
- self::blow('subscription:by-subscriber:'.$this->subscriber);
- self::blow('subscription:by-subscribed:'.$this->subscribed);
- return parent::update($dataObject);
- }
- public function getUri()
- {
- return $this->uri ?: self::newUri($this->getSubscriber(), $this->getSubscribed(), $this->created);
- }
- }
|