3 * Data class to mark notices as bookmarks
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) 2009, 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 * For storing the fact that a notice is a bookmark
37 * @author Evan Prodromou <evan@status.net>
38 * @license http://www.fsf.org/licensing/licenses/agpl.html AGPLv3
39 * @link http://status.net/
43 class Bookmark extends Managed_DataObject
45 public $__table = 'bookmark'; // table name
46 public $id; // char(36) primary_key not_null
47 public $profile_id; // int(4) not_null
48 public $url; // varchar(191) not_null not 255 because utf8mb4 takes more space
49 public $title; // varchar(191) not 255 because utf8mb4 takes more space
50 public $uri; // varchar(191) not 255 because utf8mb4 takes more space
51 public $description; // text
52 public $created; // datetime
54 public static function schemaDef()
58 'id' => array('type' => 'char',
61 'profile_id' => array('type' => 'int', 'not null' => true),
62 'uri' => array('type' => 'varchar',
65 'url' => array('type' => 'varchar',
68 'title' => array('type' => 'varchar', 'length' => 191),
69 'description' => array('type' => 'text'),
70 'created' => array('type' => 'datetime', 'not null' => true),
72 'primary key' => array('uri'),
73 'unique keys' => array(
74 'bookmark_id_key' => array('id'),
76 'foreign keys' => array(
77 'bookmark_profile_id_fkey' => array('profile', array('profile_id' => 'id')),
78 'bookmark_uri_fkey' => array('notice', array('uri' => 'uri')),
80 'indexes' => array('bookmark_created_idx' => array('created'),
81 'bookmark_url_idx' => array('url'),
82 'bookmark_profile_id_idx' => array('profile_id'),
88 * Get a bookmark based on a notice
90 * @param Notice $stored Notice activity which represents the Bookmark
92 * @return Bookmark The found bookmark object.
93 * @throws NoResultException When you don't find it after all.
95 static public function fromStored(Notice $stored)
97 return self::getByPK(array('uri' => $stored->getUri()));
100 public function getDescription()
102 return $this->description;
105 public function getTitle()
110 public function getUrl()
112 if (empty($this->url)) {
113 throw new InvalidUrlException($this->url);
119 * Get the bookmark that a user made for an URL
121 * @param Profile $profile Profile to check for
122 * @param string $url URL to check for
124 * @return Bookmark bookmark found or null
126 static function getByURL(Profile $profile, $url)
128 $nb = new Bookmark();
130 $nb->profile_id = $profile->getID();
133 if (!$nb->find(true)) {
134 throw new NoResultException($nb);
141 * Store a Bookmark object
143 * @param Profile $profile To save the bookmark for
144 * @param string $title Title of the bookmark
145 * @param string $url URL of the bookmark
146 * @param string $description Description of the bookmark
148 * @return Bookmark the Bookmark object
150 static function addNew(Notice $stored, $title, $url, $description)
152 if ($title === '' or is_null($title)) {
153 throw new ClientException(_m('You must provide a non-empty title.'));
155 if (!common_valid_http_url($url)) {
156 throw new ClientException(_m('Only web bookmarks can be posted (HTTP or HTTPS).'));
160 $object = self::getByURL($stored->getProfile(), $url);
161 throw new ClientException(_m('You have already bookmarked this URL.'));
162 } catch (NoResultException $e) {
163 // Alright, so then we have to create it.
166 $nb = new Bookmark();
168 $nb->id = UUID::gen();
169 $nb->uri = $stored->uri;
170 $nb->profile_id = $stored->getProfile()->getID();
173 $nb->description = $description;
174 $nb->created = $stored->created;
176 $result = $nb->insert();
177 if ($result === false) {
178 throw new ServerException('Could not insert Bookmark into database!');
181 /*$hashtags = array();
184 foreach ($tags as $tag) {
185 $hashtags[] = '#'.$tag;
186 $attrs = array('href' => Notice_tag::url($tag),
189 $taglinks[] = XMLStringer::estring('a', $attrs, $tag);
196 * Save a new notice bookmark
198 * @param Profile $profile To save the bookmark for
199 * @param string $title Title of the bookmark
200 * @param string $url URL of the bookmark
201 * @param array $rawtags array of tags
202 * @param string $description Description of the bookmark
203 * @param array $options Options for the Notice::saveNew()
205 * @return Notice saved notice
207 static function saveNew(Profile $profile, $title, $url, $rawtags, $description,
208 array $options=array())
210 if (!common_valid_http_url($url)) {
211 throw new ClientException(_m('Only web bookmarks can be posted (HTTP or HTTPS).'));
215 $object = self::getByURL($profile, $url);
217 } catch (NoResultException $e) {
218 // Alright, so then we have to create it.
221 if (array_key_exists('uri', $options)) {
222 $other = Bookmark::getKV('uri', $options['uri']);
223 if (!empty($other)) {
224 // TRANS: Client exception thrown when trying to save a new bookmark that already exists.
225 throw new ClientException(_m('Bookmark already exists.'));
229 $nb = new Bookmark();
231 $nb->id = UUID::gen();
232 $nb->profile_id = $profile->id;
235 $nb->description = $description;
237 if (array_key_exists('created', $options)) {
238 $nb->created = $options['created'];
240 $nb->created = common_sql_now();
243 if (array_key_exists('uri', $options)) {
244 $nb->uri = $options['uri'];
246 // FIXME: hacks to work around router bugs in
251 $path = $r->build('showbookmark',
252 array('id' => $nb->id));
255 $nb->uri = common_path('bookmark/'.$nb->id, false, false);
257 $nb->uri = common_local_url('showbookmark',
258 array('id' => $nb->id),
270 // filter "for:nickname" tags
272 foreach ($rawtags as $tag) {
273 if (strtolower(mb_substr($tag, 0, 4)) == 'for:') {
274 // skip if done by caller
275 if (!array_key_exists('replies', $options)) {
276 $nickname = mb_substr($tag, 4);
277 $other = common_relative_profile($profile,
279 if (!empty($other)) {
280 $replies[] = $other->getUri();
284 $tags[] = common_canonical_tag($tag);
291 foreach ($tags as $tag) {
292 $hashtags[] = '#'.$tag;
293 $attrs = array('href' => Notice_tag::url($tag),
296 $taglinks[] = XMLStringer::estring('a', $attrs, $tag);
299 // Use user's preferences for short URLs, if possible
302 $user = User::getKV('id', $profile->id);
304 $shortUrl = File_redirection::makeShort($url,
305 empty($user) ? null : $user);
306 } catch (Exception $e) {
307 // Don't let this stop us.
311 // TRANS: Bookmark content.
312 // TRANS: %1$s is a title, %2$s is a short URL, %3$s is the bookmark description,
313 // TRANS: %4$s is space separated list of hash tags.
314 $content = sprintf(_m('"%1$s" %2$s %3$s %4$s'),
318 implode(' ', $hashtags));
320 // TRANS: Rendered bookmark content.
321 // TRANS: %1$s is a URL, %2$s the bookmark title, %3$s is the bookmark description,
322 // TRANS: %4$s is space separated list of hash tags.
323 $rendered = sprintf(_m('<span class="xfolkentry">'.
324 '<a class="taggedlink" href="%1$s">%2$s</a> '.
325 '<span class="description">%3$s</span> '.
326 '<span class="meta">%4$s</span>'.
328 htmlspecialchars($url),
329 htmlspecialchars($title),
330 htmlspecialchars($description),
331 implode(' ', $taglinks));
333 $options = array_merge(array('urls' => array($url),
334 'rendered' => $rendered,
336 'replies' => $replies,
337 'object_type' => ActivityObject::BOOKMARK),
340 $options['uri'] = $nb->uri;
343 $saved = Notice::saveNew($profile->id,
345 array_key_exists('source', $options) ?
346 $options['source'] : 'web',
348 } catch (Exception $e) {