X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=src%2FContent%2FForumManager.php;h=0104d388f59f9b557900d0919face9e4dbcb7c7a;hb=8034a48ffe6deef939172c8e659cbd3e0d497464;hp=cfd083f9f8c3821010e1f61d3d77a78d1163f278;hpb=1ab965c9440a32ab241c9f5e06bea1f7ebb202fd;p=friendica.git diff --git a/src/Content/ForumManager.php b/src/Content/ForumManager.php index cfd083f9f8..0104d388f5 100644 --- a/src/Content/ForumManager.php +++ b/src/Content/ForumManager.php @@ -1,26 +1,40 @@ . + * */ -namespace Friendica\Content; -use Friendica\App; -use Friendica\Content\Feature; -use Friendica\Core\L10n; -use Friendica\Core\System; -use Friendica\Database\DBM; -use dba; +namespace Friendica\Content; -require_once 'include/dba.php'; +use Friendica\Content\Text\HTML; +use Friendica\Core\Protocol; +use Friendica\Core\Renderer; +use Friendica\Database\DBA; +use Friendica\DI; +use Friendica\Model\Contact; /** - * @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 @@ -28,38 +42,43 @@ class ForumManager * @param boolean $showprivate Show private groups * * @return array - * 'url' => forum url - * 'name' => forum name - * 'id' => number of the key from the array - * 'micro' => contact photo in format micro - * 'thumb' => contact photo in format thumb + * 'url' => forum url + * 'name' => forum name + * 'id' => number of the key from the array + * 'micro' => contact photo in format micro + * 'thumb' => contact photo in format thumb + * @throws \Exception */ public static function getList($uid, $lastitem, $showhidden = true, $showprivate = false) { - $forumlist = []; + if ($lastitem) { + $params = ['order' => ['last-item' => true]]; + } else { + $params = ['order' => ['name']]; + } + + $condition_str = "`network` IN (?, ?) AND `uid` = ? AND NOT `blocked` AND NOT `pending` AND NOT `archive` AND "; - $order = (($showhidden) ? '' : ' AND NOT `hidden` '); - $order .= (($lastitem) ? ' ORDER BY `last-item` DESC ' : ' ORDER BY `name` ASC '); - $select = '`forum` '; if ($showprivate) { - $select = '(`forum` OR `prv`)'; + $condition_str .= '(`forum` OR `prv`)'; + } else { + $condition_str .= '`forum`'; } - $contacts = dba::p( - "SELECT `contact`.`id`, `contact`.`url`, `contact`.`name`, `contact`.`micro`, `contact`.`thumb` - FROM `contact` - WHERE `network`= 'dfrn' AND $select AND `uid` = ? - AND NOT `blocked` AND NOT `pending` AND NOT `archive` - AND `success_update` > `failure_update` - $order ", - $uid - ); + if (!$showhidden) { + $condition_str .= ' AND NOT `hidden`'; + } + $forumlist = []; + + $fields = ['id', 'url', 'name', 'micro', 'thumb', 'avatar', 'network', 'uid']; + $condition = [$condition_str, Protocol::DFRN, Protocol::ACTIVITYPUB, $uid]; + $contacts = DBA::select('contact', $fields, $condition, $params); if (!$contacts) { return($forumlist); } - while ($contact = dba::fetch($contacts)) { + while ($contact = DBA::fetch($contacts)) { $forumlist[] = [ 'url' => $contact['url'], 'name' => $contact['name'], @@ -68,28 +87,27 @@ class ForumManager 'thumb' => $contact['thumb'], ]; } - dba::close($contacts); + DBA::close($contacts); return($forumlist); } /** - * @brief Forumlist widget + * Forumlist widget * * Sidebar widget to show subcribed 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) { - if (! intval(Feature::isEnabled(local_user(), 'forumlist_widget'))) { - return; - } - $o = ''; //sort by last updated item @@ -99,35 +117,38 @@ class ForumManager $total = count($contacts); $visible_forums = 10; - if (DBM::is_result($contacts)) { + if (DBA::isResult($contacts)) { $id = 0; + $entries = []; + foreach ($contacts as $contact) { $selected = (($cid == $contact['id']) ? ' forum-selected' : ''); $entry = [ - 'url' => 'network?f=&cid=' . $contact['id'], - 'external_url' => 'redir/' . $contact['id'], + 'url' => $baseurl . '/' . $contact['id'], + 'external_url' => Contact::magicLinkByContact($contact), 'name' => $contact['name'], 'cid' => $contact['id'], 'selected' => $selected, - 'micro' => System::removedBaseUrl(proxy_url($contact['micro'], false, PROXY_SIZE_MICRO)), + 'micro' => DI::baseUrl()->remove(Contact::getMicro($contact)), 'id' => ++$id, ]; $entries[] = $entry; } - $tpl = get_markup_template('widget_forumlist.tpl'); + $tpl = Renderer::getMarkupTemplate('widget_forumlist.tpl'); - $o .= replace_macros( + $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')] ); } @@ -135,19 +156,21 @@ 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. * * @param int $uid The ID of the User * @return string + * @throws \Friendica\Network\HTTPException\InternalServerErrorException + * @throws \ImagickException */ public static function profileAdvanced($uid) { $profile = intval(Feature::isEnabled($uid, 'forumlist_profile')); - if (! $profile) { - return; + if (!$profile) { + return ''; } $o = ''; @@ -161,45 +184,42 @@ class ForumManager $contacts = self::getList($uid, $lastitem, false, false); $total_shown = 0; - $forumlist = ''; foreach ($contacts as $contact) { - $forumlist .= micropro($contact, false, '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 * * @return array - * 'id' => contact id - * 'name' => contact/forum name - * 'count' => counted unseen forum items + * 'id' => contact id + * 'name' => contact/forum name + * 'count' => counted unseen forum items + * @throws \Exception */ public static function countUnseenItems() { - $r = q( - "SELECT `contact`.`id`, `contact`.`name`, COUNT(*) AS `count` FROM `item` - INNER JOIN `contact` ON `item`.`contact-id` = `contact`.`id` - WHERE `item`.`uid` = %d AND `item`.`visible` AND NOT `item`.`deleted` AND `item`.`unseen` - AND `contact`.`network`= 'dfrn' AND (`contact`.`forum` OR `contact`.`prv`) + $stmtContacts = DBA::p( + "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` - AND `contact`.`success_update` > `failure_update` - GROUP BY `contact`.`id` ", - intval(local_user()) + AND `contact`.`uid` = ? + GROUP BY `contact`.`id`", + local_user(), Protocol::DFRN, Protocol::ACTIVITYPUB, Contact::TYPE_COMMUNITY, local_user() ); - return $r; + return DBA::toArray($stmtContacts); } }