3 * Data class for event RSVPs
9 * @author Evan Prodromou <evan@status.net>
10 * @license http://www.fsf.org/licensing/licenses/agpl.html AGPLv3
11 * @link http://status.net/
13 * StatusNet - the distributed open-source microblogging tool
14 * Copyright (C) 2011, StatusNet, Inc.
16 * This program is free software: you can redistribute it and/or modify
17 * it under the terms of the GNU Affero General Public License as published by
18 * the Free Software Foundation, either version 3 of the License, or
19 * (at your option) any later version.
21 * This program is distributed in the hope that it will be useful,
22 * but WITHOUT ANY WARRANTY; without even the implied warranty of
23 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 * GNU Affero General Public License for more details.
26 * You should have received a copy of the GNU Affero General Public License
27 * along with this program. If not, see <http://www.gnu.org/licenses/>.
30 if (!defined('GNUSOCIAL')) { exit(1); }
33 * Data class for event RSVPs
37 * @author Evan Prodromou <evan@status.net>
38 * @license http://www.fsf.org/licensing/licenses/agpl.html AGPLv3
39 * @link http://status.net/
41 * @see Managed_DataObject
43 class RSVP extends Managed_DataObject
45 const POSITIVE = 'http://activitystrea.ms/schema/1.0/rsvp-yes';
46 const POSSIBLE = 'http://activitystrea.ms/schema/1.0/rsvp-maybe';
47 const NEGATIVE = 'http://activitystrea.ms/schema/1.0/rsvp-no';
49 public $__table = 'rsvp'; // table name
50 public $id; // varchar(36) UUID
51 public $uri; // varchar(191) not 255 because utf8mb4 takes more space
52 public $profile_id; // int
53 public $event_uri; // varchar(191) not 255 because utf8mb4 takes more space
54 public $response; // tinyint
55 public $created; // datetime
58 * The One True Thingy that must be defined and declared.
60 public static function schemaDef()
63 'description' => 'Plan to attend event',
65 'id' => array('type' => 'char',
68 'description' => 'UUID'),
69 'uri' => array('type' => 'varchar',
72 'profile_id' => array('type' => 'int'),
73 'event_uri' => array('type' => 'varchar',
76 'description' => 'Event URI'),
77 'response' => array('type' => 'char',
79 'description' => 'Y, N, or ? for three-state yes, no, maybe'),
80 'created' => array('type' => 'datetime',
83 'primary key' => array('id'),
84 'unique keys' => array(
85 'rsvp_uri_key' => array('uri'),
86 'rsvp_profile_event_key' => array('profile_id', 'event_uri'),
88 'foreign keys' => array('rsvp_event_uri_key' => array('happening', array('event_uri' => 'uri')),
89 'rsvp_profile_id__key' => array('profile', array('profile_id' => 'id'))),
90 'indexes' => array('rsvp_created_idx' => array('created')),
94 static public function beforeSchemaUpdate()
96 $table = strtolower(get_called_class());
97 $schema = Schema::get();
98 $schemadef = $schema->getTableDef($table);
100 // 2015-12-31 RSVPs refer to Happening by event_uri now, not event_id. Let's migrate!
101 if (isset($schemadef['fields']['event_uri'])) {
102 // We seem to have already migrated, good!
106 // this is a "normal" upgrade from StatusNet for example
107 echo "\nFound old $table table, upgrading it to add 'event_uri' field...";
109 $schemadef['fields']['event_uri'] = array('type' => 'varchar', 'length' => 191, 'not null' => true, 'description' => 'Event URI');
110 $schema->ensureTable($table, $schemadef);
114 while ($rsvp->fetch()) {
115 $event = Happening::getKV('id', $rsvp->event_id);
116 if (!$event instanceof Happening) {
119 $orig = clone($rsvp);
120 $rsvp->event_uri = $event->uri;
121 $rsvp->updateWithKeys($orig);
124 print "Resuming core schema upgrade...";
127 function saveNew(Profile $profile, $event, $verb, array $options = array())
129 if (array_key_exists('uri', $options)) {
130 $other = RSVP::getKV('uri', $options['uri']);
131 if (!empty($other)) {
132 // TRANS: Client exception thrown when trying to save an already existing RSVP ("please respond").
133 throw new ClientException(_m('RSVP already exists.'));
138 $other = RSVP::getByKeys( [ 'profile_id' => $profile->getID(),
139 'event_uri' => $event->getUri(),
141 // TRANS: Client exception thrown when trying to save an already existing RSVP ("please respond").
142 throw new AlreadyFulfilledException(_m('RSVP already exists.'));
143 } catch (NoResultException $e) {
144 // No previous RSVP, so go ahead and add.
149 $rsvp->id = UUID::gen();
150 $rsvp->profile_id = $profile->getID();
151 $rsvp->event_uri = $event->getUri();
152 $rsvp->response = self::codeFor($verb);
154 if (array_key_exists('created', $options)) {
155 $rsvp->created = $options['created'];
157 $rsvp->created = common_sql_now();
160 if (array_key_exists('uri', $options)) {
161 $rsvp->uri = $options['uri'];
163 $rsvp->uri = common_local_url('showrsvp',
164 array('id' => $rsvp->id));
169 self::blow('rsvp:for-event:%s', $event->getUri());
171 // XXX: come up with something sexier
173 $content = $rsvp->asString();
175 $rendered = $rsvp->asHTML();
177 $options = array_merge(array('object_type' => $verb),
180 if (!array_key_exists('uri', $options)) {
181 $options['uri'] = $rsvp->uri;
184 $eventNotice = $event->getNotice();
186 if (!empty($eventNotice)) {
187 $options['reply_to'] = $eventNotice->getID();
190 $saved = Notice::saveNew($profile->getID(),
192 array_key_exists('source', $options) ?
193 $options['source'] : 'web',
199 function codeFor($verb)
212 // TRANS: Exception thrown when requesting an undefined verb for RSVP.
213 throw new Exception(sprintf(_m('Unknown verb "%s".'),$verb));
217 static function verbFor($code)
221 return RSVP::POSITIVE;
224 return RSVP::NEGATIVE;
227 return RSVP::POSSIBLE;
230 // TRANS: Exception thrown when requesting an undefined code for RSVP.
231 throw new Exception(sprintf(_m('Unknown code "%s".'),$code));
237 $notice = Notice::getKV('uri', $this->uri);
238 if (empty($notice)) {
239 // TRANS: Server exception thrown when requesting a non-exsting notice for an RSVP ("please respond").
240 // TRANS: %s is the RSVP with the missing notice.
241 throw new ServerException(sprintf(_m('RSVP %s does not correspond to a notice in the database.'),$this->id));
246 static function fromNotice(Notice $notice)
249 $rsvp->uri = $notice->uri;
250 if (!$rsvp->find(true)) {
251 throw new NoResultException($rsvp);
256 static function forEvent(Happening $event)
258 $keypart = sprintf('rsvp:for-event:%s', $event->getUri());
260 $idstr = self::cacheGet($keypart);
262 if ($idstr !== false) {
263 $ids = explode(',', $idstr);
270 $rsvp->selectAdd('id');
272 $rsvp->event_uri = $event->getUri();
275 while ($rsvp->fetch()) {
279 self::cacheSet($keypart, implode(',', $ids));
282 $rsvps = array(RSVP::POSITIVE => array(),
283 RSVP::NEGATIVE => array(),
284 RSVP::POSSIBLE => array());
286 foreach ($ids as $id) {
287 $rsvp = RSVP::getKV('id', $id);
289 $verb = self::verbFor($rsvp->response);
290 $rsvps[$verb][] = $rsvp;
297 function getProfile()
299 $profile = Profile::getKV('id', $this->profile_id);
300 if (empty($profile)) {
301 // TRANS: Exception thrown when requesting a non-existing profile.
302 // TRANS: %s is the ID of the non-existing profile.
303 throw new Exception(sprintf(_m('No profile with ID %s.'),$this->profile_id));
310 $event = Happening::getKV('uri', $this->event_uri);
312 // TRANS: Exception thrown when requesting a non-existing event.
313 // TRANS: %s is the ID of the non-existing event.
314 throw new Exception(sprintf(_m('No event with URI %s.'),$this->event_uri));
321 return self::toHTML($this->getProfile(),
328 return self::toString($this->getProfile(),
333 static function toHTML(Profile $profile, Event $event, $response)
339 // TRANS: HTML version of an RSVP ("please respond") status for a user.
340 // TRANS: %1$s is a profile URL, %2$s a profile name,
341 // TRANS: %3$s is an event URL, %4$s an event title.
342 $fmt = _m("<span class='automatic event-rsvp'><a href='%1\$s'>%2\$s</a> is attending <a href='%3\$s'>%4\$s</a>.</span>");
345 // TRANS: HTML version of an RSVP ("please respond") status for a user.
346 // TRANS: %1$s is a profile URL, %2$s a profile name,
347 // TRANS: %3$s is an event URL, %4$s an event title.
348 $fmt = _m("<span class='automatic event-rsvp'><a href='%1\$s'>%2\$s</a> is not attending <a href='%3\$s'>%4\$s</a>.</span>");
351 // TRANS: HTML version of an RSVP ("please respond") status for a user.
352 // TRANS: %1$s is a profile URL, %2$s a profile name,
353 // TRANS: %3$s is an event URL, %4$s an event title.
354 $fmt = _m("<span class='automatic event-rsvp'><a href='%1\$s'>%2\$s</a> might attend <a href='%3\$s'>%4\$s</a>.</span>");
357 // TRANS: Exception thrown when requesting a user's RSVP status for a non-existing response code.
358 // TRANS: %s is the non-existing response code.
359 throw new Exception(sprintf(_m('Unknown response code %s.'),$response));
364 // TRANS: Used as event title when not event title is available.
365 // TRANS: Used as: Username [is [not ] attending|might attend] an unknown event.
366 $eventTitle = _m('an unknown event');
368 $notice = $event->getNotice();
369 $eventUrl = $notice->getUrl();
370 $eventTitle = $event->title;
374 htmlspecialchars($profile->profileurl),
375 htmlspecialchars($profile->getBestName()),
376 htmlspecialchars($eventUrl),
377 htmlspecialchars($eventTitle));
380 static function toString($profile, $event, $response)
386 // TRANS: Plain text version of an RSVP ("please respond") status for a user.
387 // TRANS: %1$s is a profile name, %2$s is an event title.
388 $fmt = _m('%1$s is attending %2$s.');
391 // TRANS: Plain text version of an RSVP ("please respond") status for a user.
392 // TRANS: %1$s is a profile name, %2$s is an event title.
393 $fmt = _m('%1$s is not attending %2$s.');
396 // TRANS: Plain text version of an RSVP ("please respond") status for a user.
397 // TRANS: %1$s is a profile name, %2$s is an event title.
398 $fmt = _m('%1$s might attend %2$s.');
401 // TRANS: Exception thrown when requesting a user's RSVP status for a non-existing response code.
402 // TRANS: %s is the non-existing response code.
403 throw new Exception(sprintf(_m('Unknown response code %s.'),$response));
408 // TRANS: Used as event title when not event title is available.
409 // TRANS: Used as: Username [is [not ] attending|might attend] an unknown event.
410 $eventTitle = _m('an unknown event');
412 $notice = $event->getNotice();
413 $eventTitle = $event->title;
417 $profile->getBestName(),
421 function delete($useWhere=false)
423 self::blow('rsvp:for-event:%s', $this->id);
424 return parent::delete($useWhere);