Box: Beste Beiträge bzw. Beiträge in definierten Zeitraum

<?php
/**
 * WoltLab Community Framework
 * Template: portalBoxBestPosts
 * Compiled at: Sat, 01 Jul 2017 05:50:27 +0000
 * 
 * DO NOT EDIT THIS FILE
 */
$this->v['tpl']['template'] = 'portalBoxBestPosts';
?>
<?php
if (!isset($this->pluginObjects['wcf\system\template\plugin\LinkBlockTemplatePlugin'])) {
$this->pluginObjects['wcf\system\template\plugin\LinkBlockTemplatePlugin'] = new wcf\system\template\plugin\LinkBlockTemplatePlugin;
}
if (!isset($this->pluginObjects['wcf\system\template\plugin\TruncateModifierTemplatePlugin'])) {
$this->pluginObjects['wcf\system\template\plugin\TruncateModifierTemplatePlugin'] = new wcf\system\template\plugin\TruncateModifierTemplatePlugin;
}
?><ul>
    <?php
if (count($this->v['bestPosts']) > 0) {
foreach ($this->v['bestPosts'] as $this->v['postID'] => $this->v['post']) {
?>
        <li>
            <div style="float:left">
                <span class="icon icon16 icon-file"></span>
            </div>
            <div style="float:right">
                <span class="likesBadge badge green">+<?php echo wcf\util\StringUtil::formatNumeric($this->v['post']['cumulativeLikes']); ?></span>
            </div>
            <div style="float:none;margin-left:16px;">
                <a href="<?php $this->tagStack[] = array('link', array('application' => 'wbb', 'controller' => 'Thread', 'id' => $this->v['post']['threadID'], 'postID' => $this->v['post']['postID']));
$this->pluginObjects['wcf\system\template\plugin\LinkBlockTemplatePlugin']->init($this->tagStack[count($this->tagStack) - 1][1], $this);
while ($this->pluginObjects['wcf\system\template\plugin\LinkBlockTemplatePlugin']->next($this)) { ob_start(); ?>#post<?php echo wcf\util\StringUtil::formatNumeric($this->v['postID']); ?><?php echo $this->pluginObjects['wcf\system\template\plugin\LinkBlockTemplatePlugin']->execute($this->tagStack[count($this->tagStack) - 1][1], ob_get_clean(), $this); }
array_pop($this->tagStack);?>"><?php if ($this->v['maxStrLen']) { ?><?php echo wcf\util\StringUtil::encodeHTML($this->pluginObjects['wcf\system\template\plugin\TruncateModifierTemplatePlugin']->execute(array($this->v['post']['topic'],$this->v['maxStrLen']), $this)); ?><?php } else { ?><?php echo wcf\util\StringUtil::encodeHTML($this->v['post']['topic']); ?><?php } ?></a>
            </div>
            <div style="clear:both"></div>
        </li>
    <?php } } ?>
</ul>

portalBoxBestPosts.tpl

<ul>
    {foreach from=$bestPosts key=postID item=post}
        <li>
            <div style="float:left">
                <span class="icon icon16 icon-file"></span>
            </div>
            <div style="float:right">
                <span class="likesBadge badge green">+{#$post.cumulativeLikes}</span>
            </div>
            <div style="float:none;margin-left:16px;">
                <a href="{link application='wbb' controller='Thread' id=$post.threadID postID=$post.postID}#post{#$postID}{/link}">{if $maxStrLen}{$post.topic|truncate:$maxStrLen}{else}{$post.topic}{/if}</a>
            </div>
            <div style="clear:both"></div>
        </li>
    {/foreach}
</ul>

BestPosts.class.php

<?php
namespace wcf\data\portal\box;

use wbb\data\board\Board;
use wbb\data\board\BoardCache;
use wcf\system\cache\builder\PortalBestPostsCacheBuilder;
use wcf\system\WCF;


class BestPosts extends AbstractPortalBox {

    
    public function render() {

        $bestPosts = array();
        // get boards ids
        $boardIDs = Board::getAccessibleBoardIDs(array('canViewBoard', 'canEnterBoard'));
        foreach ($boardIDs as $key => $boardID) {
            $board = BoardCache::getInstance()->getBoard($boardID);
            if ($board->isIgnored() || !$board->searchable) {
                unset($boardIDs[$key]);
            }
        }
        $postList = PortalBestPostsCacheBuilder::getInstance()->getData();
        foreach ($postList as $postID => $post) { 
            if ((count($bestPosts)<PORTAL_BESTPOSTS_ITEMS_COUNT) && in_array($post['boardID'], $boardIDs)) {
                $bestPosts[$postID] = $post;
            }
        }
        unset($boardIDs);
        unset($postList);
        
        if (count($bestPosts)) {
            WCF::getTPL()->assign(array(
                'bestPosts' => $bestPosts,
                'maxStrLen' => $this->maxStrLen
            ));
            return WCF::getTPL()->fetch('portalBoxBestPosts');
        }
        return('');
    }
}

<?php
namespace wcf\system\cache\builder;
use wcf\data\user\UserList;
use wcf\data\object\type\ObjectTypeCache;
use wcf\system\WCF;
/**
 * CacheBuilder for PortalBox "MostActiveThreads"
 * 
 * @package    com.mobahner.wcf2.portal
 * @copyright    2012 WBB-Basteleien <http://www.mobahner.com>
 * @author    nmichel
 * @license    GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 * @category    WCF
 */
class PortalBestPostsCacheBuilder extends AbstractCacheBuilder {
    /**
     * @see    wcf\system\cache\builder\AbstractCacheBuilder::$maxLifetime
     */
    protected $maxLifetime = 300;
    
    public $data = array();
    /**
     * @see    wcf\system\cache\builder\AbstractCacheBuilder::rebuild()
     */
    protected function rebuild(array $parameters) {
        
        $objectType = ObjectTypeCache::getInstance()->getObjectTypeByName('com.woltlab.wcf.like.likeableObject', 'com.woltlab.wbb.likeablePost');
        
        if ($objectType !== null) {
            $postAge = 0;
            if (PORTAL_BESTPOSTS_POST_AGE) 
                $postAge = TIME_NOW - (PORTAL_BESTPOSTS_POST_AGE * 24 * 3600);
            
            $sql = "SELECT    thread.boardID, thread.topic, post.threadID, post.postID, likes.cumulativeLikes 
                FROM     wbb".WCF_N."_post post, wbb".WCF_N."_thread thread, wcf".WCF_N."_like_object likes
                WHERE    likes.objectID=post.postID 
                AND     likes.objectTypeID = ".$objectType->objectTypeID."
                AND    thread.threadID = post.threadID
                AND    likes.cumulativeLikes > 0".
                ($postAge ? " AND post.time > ".$postAge : "" ).
                (PORTAL_BESTPOSTS_BOARD_IDS ? " AND thread.boardID IN (".implode(',', explode("\n", PORTAL_BESTPOSTS_BOARD_IDS)).")" : "" )."
                ORDER    BY likes.cumulativeLikes DESC";
            $statement = WCF::getDB()->prepareStatement($sql, 3 * PORTAL_BESTPOSTS_ITEMS_COUNT);
            $statement->execute(array());
            while ($row = $statement->fetchArray()) {
                $this->data[$row['postID']] = $row;
            }
        }
        return $this->data;
    }
}