X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FContent%2FForumManager.php;h=5decaac141454fac2f69c1e653913f79e271e860;hb=f61fd93db02bc2d66e1473ca34dc1154e77217a3;hp=1b292731647956d463d04c834b594455987cd6fa;hpb=36ba7fa79c7c2d4304f3423d84215771e3bb6a9f;p=friendica.git diff --git a/src/Content/ForumManager.php b/src/Content/ForumManager.php index 1b29273164..5decaac141 100644 --- a/src/Content/ForumManager.php +++ b/src/Content/ForumManager.php @@ -1,30 +1,44 @@ . + * */ + namespace Friendica\Content; -use Friendica\Core\Protocol; use Friendica\Content\Text\HTML; -use Friendica\Core\L10n; +use Friendica\Core\Protocol; use Friendica\Core\Renderer; -use Friendica\Core\System; use Friendica\Database\DBA; +use Friendica\DI; use Friendica\Model\Contact; -use Friendica\Util\Proxy as ProxyUtils; /** - * @brief This class handles methods related to the forum functionality + * This class handles methods related to the forum functionality */ class ForumManager { /** - * @brief Function to list all forums a user is connected with + * Function to list all forums a user is connected with * * @param int $uid of the profile owner * @param boolean $lastitem Sort by lastitem - * @param boolean $showhidden Show frorums which are not hidden + * @param boolean $showhidden Show forums which are not hidden * @param boolean $showprivate Show private groups * * @return array @@ -43,23 +57,29 @@ class ForumManager $params = ['order' => ['name']]; } - $condition_str = "`network` IN (?, ?) AND `uid` = ? AND NOT `blocked` AND NOT `pending` AND NOT `archive` AND "; + $condition = [ + 'contact-type' => Contact::TYPE_COMMUNITY, + 'network' => [Protocol::DFRN, Protocol::ACTIVITYPUB], + 'uid' => $uid, + 'blocked' => false, + 'pending' => false, + 'archive' => false, + ]; - if ($showprivate) { - $condition_str .= '(`forum` OR `prv`)'; - } else { - $condition_str .= '`forum`'; + $condition = DBA::mergeConditions($condition, ["`platform` != ?", 'peertube']); + + if (!$showprivate) { + $condition = DBA::mergeConditions($condition, ['manually-approve' => false]); } if (!$showhidden) { - $condition_str .= ' AND NOT `hidden`'; + $condition = DBA::mergeConditions($condition, ['hidden' => false]); } $forumlist = []; - $fields = ['id', 'url', 'name', 'micro', 'thumb']; - $condition = [$condition_str, Protocol::DFRN, Protocol::ACTIVITYPUB, $uid]; - $contacts = DBA::select('contact', $fields, $condition, $params); + $fields = ['id', 'url', 'name', 'micro', 'thumb', 'avatar', 'network', 'uid']; + $contacts = DBA::select('account-user-view', $fields, $condition, $params); if (!$contacts) { return($forumlist); } @@ -80,18 +100,19 @@ class ForumManager /** - * @brief Forumlist widget + * Forumlist widget * - * Sidebar widget to show subcribed friendica forums. If activated + * Sidebar widget to show subscribed friendica forums. If activated * in the settings, it appears at the notwork page sidebar * - * @param int $uid The ID of the User - * @param int $cid The contact id which is used to mark a forum as "selected" + * @param string $baseurl Base module path + * @param int $uid The ID of the User + * @param int $cid The contact id which is used to mark a forum as "selected" * @return string * @throws \Friendica\Network\HTTPException\InternalServerErrorException * @throws \ImagickException */ - public static function widget($uid, $cid = 0) + public static function widget(string $baseurl, int $uid, int $cid = 0) { $o = ''; @@ -111,12 +132,12 @@ class ForumManager $selected = (($cid == $contact['id']) ? ' forum-selected' : ''); $entry = [ - 'url' => 'network?cid=' . $contact['id'], - 'external_url' => Contact::magicLink($contact['url']), + 'url' => $baseurl . '/' . $contact['id'], + 'external_url' => Contact::magicLinkByContact($contact), 'name' => $contact['name'], 'cid' => $contact['id'], 'selected' => $selected, - 'micro' => System::removedBaseUrl(ProxyUtils::proxifyUrl($contact['micro'], false, ProxyUtils::SIZE_MICRO)), + 'micro' => DI::baseUrl()->remove(Contact::getMicro($contact)), 'id' => ++$id, ]; $entries[] = $entry; @@ -127,12 +148,13 @@ class ForumManager $o .= Renderer::replaceMacros( $tpl, [ - '$title' => L10n::t('Forums'), + '$title' => DI::l10n()->t('Forums'), '$forums' => $entries, - '$link_desc' => L10n::t('External link to forum'), + '$link_desc' => DI::l10n()->t('External link to forum'), '$total' => $total, '$visible_forums' => $visible_forums, - '$showmore' => L10n::t('show more')] + '$showless' => DI::l10n()->t('show less'), + '$showmore' => DI::l10n()->t('show more')] ); } @@ -140,7 +162,7 @@ class ForumManager } /** - * @brief Format forumlist as contact block + * Format forumlist as contact block * * This function is used to show the forumlist in * the advanced profile. @@ -153,8 +175,8 @@ class ForumManager public static function profileAdvanced($uid) { $profile = intval(Feature::isEnabled($uid, 'forumlist_profile')); - if (! $profile) { - return; + if (!$profile) { + return ''; } $o = ''; @@ -168,23 +190,19 @@ class ForumManager $contacts = self::getList($uid, $lastitem, false, false); $total_shown = 0; - $forumlist = ''; foreach ($contacts as $contact) { - $forumlist .= HTML::micropro($contact, true, 'forumlist-profile-advanced'); - $total_shown ++; + $o .= HTML::micropro($contact, true, 'forumlist-profile-advanced'); + $total_shown++; if ($total_shown == $show_total) { break; } } - if (count($contacts) > 0) { - $o .= $forumlist; - return $o; - } + return $o; } /** - * @brief count unread forum items + * count unread forum items * * Count unread items of connected forums and private groups * @@ -197,14 +215,15 @@ class ForumManager public static function countUnseenItems() { $stmtContacts = DBA::p( - "SELECT `contact`.`id`, `contact`.`name`, COUNT(*) AS `count` FROM `item` - INNER JOIN `contact` ON `item`.`contact-id` = `contact`.`id` - WHERE `item`.`uid` = ? AND `item`.`visible` AND NOT `item`.`deleted` AND `item`.`unseen` - AND `contact`.`network`= 'dfrn' AND (`contact`.`forum` OR `contact`.`prv`) + "SELECT `contact`.`id`, `contact`.`name`, COUNT(*) AS `count` FROM `post-user-view` + INNER JOIN `contact` ON `post-user-view`.`contact-id` = `contact`.`id` + WHERE `post-user-view`.`uid` = ? AND `post-user-view`.`visible` AND NOT `post-user-view`.`deleted` AND `post-user-view`.`unseen` + AND `contact`.`network` IN (?, ?) AND `contact`.`contact-type` = ? AND NOT `contact`.`blocked` AND NOT `contact`.`hidden` AND NOT `contact`.`pending` AND NOT `contact`.`archive` - GROUP BY `contact`.`id` ", - local_user() + AND `contact`.`uid` = ? + GROUP BY `contact`.`id`", + DI::userSession()->getLocalUserId(), Protocol::DFRN, Protocol::ACTIVITYPUB, Contact::TYPE_COMMUNITY, DI::userSession()->getLocalUserId() ); return DBA::toArray($stmtContacts);