+
+ /**
+ * Returns a list of the most frequent global hashtags over the given period
+ *
+ * @param int $period Period in hours to consider posts
+ * @param int $limit Number of returned tags
+ * @return array
+ * @throws \Exception
+ */
+ public static function getGlobalTrendingHashtags(int $period, $limit = 10)
+ {
+ $tags = DI::cache()->get('global_trending_tags-' . $period . '-' . $limit);
+ if (!empty($tags)) {
+ return $tags;
+ } else {
+ return self::setGlobalTrendingHashtags($period, $limit);
+ }
+ }
+
+ /**
+ * Creates a list of the most frequent global hashtags over the given period
+ *
+ * @param int $period Period in hours to consider posts
+ * @param int $limit Number of returned tags
+ * @return array
+ * @throws \Exception
+ */
+ public static function setGlobalTrendingHashtags(int $period, $limit = 10)
+ {
+ $tagsStmt = DBA::p("SELECT `name` AS `term`, COUNT(*) AS `score`
+ FROM `tag-search-view`
+ WHERE `private` = ? AND `uid` = ? AND `received` > DATE_SUB(NOW(), INTERVAL ? HOUR)
+ GROUP BY `term` ORDER BY `score` DESC LIMIT ?",
+ Item::PUBLIC, 0, $period, $limit);
+
+ if (DBA::isResult($tagsStmt)) {
+ $tags = DBA::toArray($tagsStmt);
+ DI::cache()->set('global_trending_tags-' . $period . '-' . $limit, $tags, Duration::DAY);
+ return $tags;
+ }
+
+ return [];
+ }
+
+ /**
+ * Returns a list of the most frequent local hashtags over the given period
+ *
+ * @param int $period Period in hours to consider posts
+ * @param int $limit Number of returned tags
+ * @return array
+ * @throws \Exception
+ */
+ public static function getLocalTrendingHashtags(int $period, $limit = 10)
+ {
+ $tags = DI::cache()->get('local_trending_tags-' . $period . '-' . $limit);
+ if (!empty($tags)) {
+ return $tags;
+ } else {
+ return self::setLocalTrendingHashtags($period, $limit);
+ }
+ }
+
+ /**
+ * Returns a list of the most frequent local hashtags over the given period
+ *
+ * @param int $period Period in hours to consider posts
+ * @param int $limit Number of returned tags
+ * @return array
+ * @throws \Exception
+ */
+ public static function setLocalTrendingHashtags(int $period, $limit = 10)
+ {
+ $tagsStmt = DBA::p("SELECT `name` AS `term`, COUNT(*) AS `score`
+ FROM `tag-search-view`
+ WHERE `private` = ? AND `wall` AND `origin` AND `received` > DATE_SUB(NOW(), INTERVAL ? HOUR)
+ GROUP BY `term` ORDER BY `score` DESC LIMIT ?",
+ Item::PUBLIC, $period, $limit);
+
+ if (DBA::isResult($tagsStmt)) {
+ $tags = DBA::toArray($tagsStmt);
+ DI::cache()->set('local_trending_tags-' . $period . '-' . $limit, $tags, Duration::DAY);
+ return $tags;
+ }
+
+ return [];
+ }
+
+ /**
+ * Check if the provided tag is of one of the provided term types.
+ *
+ * @param string $tag
+ * @param int ...$types
+ * @return bool
+ */
+ public static function isType($tag, ...$types)
+ {
+ $tag_chars = [];
+ foreach ($types as $type) {
+ if (array_key_exists($type, self::TAG_CHARACTER)) {
+ $tag_chars[] = self::TAG_CHARACTER[$type];
+ }
+ }
+
+ return Strings::startsWithChars($tag, $tag_chars);
+ }
+
+ /**
+ * Fetch user who subscribed to the given tag
+ *
+ * @param string $tag
+ * @return array User list
+ */
+ private static function getUIDListByTag(string $tag)
+ {
+ $uids = [];
+ $searches = DBA::select('search', ['uid'], ['term' => $tag]);
+ while ($search = DBA::fetch($searches)) {
+ $uids[] = $search['uid'];
+ }
+ DBA::close($searches);
+
+ return $uids;
+ }
+
+ /**
+ * Fetch user who subscribed to the tags of the given item
+ *
+ * @param integer $uri_id
+ * @return array User list
+ */
+ public static function getUIDListByURIId(int $uri_id)
+ {
+ $uids = [];
+ $tags = self::getByURIId($uri_id, [self::HASHTAG]);
+
+ foreach ($tags as $tag) {
+ $uids = array_merge($uids, self::getUIDListByTag(self::TAG_CHARACTER[self::HASHTAG] . $tag['name']));
+ }
+
+ return array_unique($uids);
+ }