123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106 |
- <?php
- if (!defined('STATUSNET') && !defined('LACONICA')) {
- exit(1);
- }
- class GroupFavoritedAction extends ShowgroupAction
- {
-
- function title()
- {
- $base = $this->group->getFancyName();
- if ($this->page == 1) {
-
- return sprintf(_m('Popular posts in %s group'), $base);
- } else {
-
- return sprintf(_m('Popular posts in %1$s group, page %2$d'),
- $base,
- $this->page);
- }
- }
-
- function showContent()
- {
- $groupId = intval($this->group->id);
- $weightexpr = common_sql_weight('fave.modified', common_config('popular', 'dropoff'));
- $cutoff = sprintf("fave.modified > '%s'",
- common_sql_date(time() - common_config('popular', 'cutoff')));
- $qry = 'SELECT notice.*, '.
- $weightexpr . ' as weight ' .
- 'FROM notice ' .
- "JOIN group_inbox ON notice.id = group_inbox.notice_id " .
- 'JOIN fave ON notice.id = fave.notice_id ' .
- "WHERE $cutoff AND group_id = $groupId " .
- 'GROUP BY id,profile_id,uri,content,rendered,url,created,notice.modified,reply_to,is_local,source,notice.conversation ' .
- 'ORDER BY weight DESC';
- $offset = ($this->page - 1) * NOTICES_PER_PAGE;
- $limit = NOTICES_PER_PAGE + 1;
- if (common_config('db', 'type') == 'pgsql') {
- $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
- } else {
- $qry .= ' LIMIT ' . $offset . ', ' . $limit;
- }
- $notice = Memcached_DataObject::cachedQuery('Notice',
- $qry,
- 600);
- $nl = new NoticeList($notice, $this);
- $cnt = $nl->show();
- if ($cnt == 0) {
-
- }
- $this->pagination($this->page > 1, $cnt > NOTICES_PER_PAGE,
- $this->page, 'groupfavorited',
- array('nickname' => $this->group->nickname));
- }
- }
|