root/taggingreloaded/optionals/de.easy-coding.wbb.taggingreloaded/files/lib/system/event/listener/TaggingReloadedWBBPageListener.class.php @ 178

<?php
// wbb imports
require_once(WBB_DIR.'lib/data/thread/ViewableThreadTagging.class.php');
require_once(WBB_DIR.'lib/data/board/Board.class.php');

// tagging imports
require_once(WCF_DIR.'lib/util/TaggingReloadedUtil.class.php');
require_once(WCF_DIR.'lib/system/event/listener/TaggingReloadedPageListener.class.php');
require_once(WBB_DIR.'lib/data/board/BoardListTaggingReloaded.class.php');

// seo imports
require_once(WCF_DIR.'lib/page/PublicSEORewriterTagging.class.php');

/**
 * Displays the tags for threads/boards
 *
 * @author      Torben Brodt
 * @package     de.easy-coding.wbb.taggingreloaded
 * @license     GNU General Public License <http://opensource.org/licenses/gpl-3.0.html>
 */
class TaggingReloadedWBBPageListener extends TaggingReloadedPageListener {
        protected $postID=0, $threadID=0, $boards=array(), $tag; // params
        
        // data
        protected $threadList = array();

        /**
         * reads similar tags
         */
        protected function queryTagsByTag() {
                // order by weight and cut
                $sql = "SELECT          wcf2.tag,
                                        SUM(wcf2.weight) AS weight
                        FROM            wcf".WCF_N."_taggingreloaded wcf
                        NATURAL JOIN    wbb".WBB_N."_taggingreloaded wbb
                        JOIN            wbb".WBB_N."_post p
                        ON              wbb.postID = p.postID
                        JOIN            wbb".WBB_N."_taggingreloaded wbb2
                        ON              p.postID = wbb2.postID
                        JOIN            wcf".WCF_N."_taggingreloaded wcf2
                        ON              wbb2.taggingID = wcf2.taggingID
                        WHERE           wcf.tag = '".escapeString($this->tag)."'
                        GROUP BY        wcf2.tag
                        ORDER BY        weight DESC
                        LIMIT           50";

                return $sql;
        }
        
        /**
         * reads by board
         */
        protected function queryTagsByBoard() {
                // order by weight and cut
                $sql = "SELECT          tag,
                                        SUM(weight) AS weight
                        FROM            wcf".WCF_N."_taggingreloaded wcf
                        NATURAL JOIN    wbb".WBB_N."_taggingreloaded wbb
                        JOIN            wbb".WBB_N."_post p
                        ON              wbb.postID = p.postID
                        JOIN            wbb".WBB_N."_thread t
                        ON              p.threadID = t.threadID
                        WHERE           t.boardID IN (".implode(',', $this->boards).")
                        GROUP BY        tag
                        ORDER BY        weight DESC
                        LIMIT           50";

                return $sql;
        }
        
        /**
         * reads (threaddata) by post
         */
        protected function queryTagsByPost() {
                // order by weight and cut
                $sql = "SELECT          tag,
                                        SUM(weight) AS weight
                        FROM            wcf".WCF_N."_taggingreloaded wcf
                        NATURAL JOIN    wbb".WBB_N."_taggingreloaded wbb
                        NATURAL JOIN    wbb".WBB_N."_post p
                        JOIN            wbb".WBB_N."_post p2
                        ON              p.threadID = p2.threadID
                        WHERE           p.postID = {$this->postID}
                        GROUP BY        tag
                        ORDER BY        weight DESC
                        LIMIT           50";
                //      SUM( weight ) * IF(COUNT(tag), 1.2, 1 )

                return $sql;
        }
        
        /**
         * reads by thread
         */
        protected function queryTagsByThread() {
                // order by weight and cut
                $sql = "SELECT          tag,
                                        SUM(weight) AS weight
                        FROM            wcf".WCF_N."_taggingreloaded wcf
                        NATURAL JOIN    wbb".WBB_N."_taggingreloaded wbb
                        NATURAL JOIN    wbb".WBB_N."_post p
                        WHERE           p.threadID = {$this->threadID}
                        GROUP BY        tag
                        ORDER BY        weight DESC
                        LIMIT           50";
                //      SUM( weight ) * IF(COUNT(tag), 1.2, 1 )

                return $sql;
        }
        
        /**
         * reads threads by tag
         */
        protected function readThreadsByTag() {
                $sql = "SELECT          t.*,
                                        tag,
                                        SUM(weight) AS weight
                        FROM            wcf".WCF_N."_taggingreloaded wcf
                        NATURAL JOIN    wbb".WBB_N."_taggingreloaded wbb
                        JOIN            wbb".WBB_N."_post p
                        ON              wbb.postID = p.postID
                        JOIN            wbb".WBB_N."_thread t
                        ON              p.threadID = t.threadID
                        WHERE           tag = '".escapeString($this->tag)."'
                        GROUP BY        p.threadID
                        ORDER BY        weight DESC
                        LIMIT           15";

                $result = WCF::getDB()->sendQuery($sql);
                while ($row = WCF::getDB()->fetchArray($result)) {
                        $row['permission'] = Board::getBoard($row['boardID'])->getPermission('canReadThread');
                        $this->threadList[] = new ViewableThreadTagging(null, $row);
                }
        }
        
        /**
         * @see Page::readData()
         */
        protected function readData () {
                switch($this->className) {
                        case 'ThreadPage':
                                $this->threadID = $this->eventObj->threadID;

                                $sql = $this->queryTagsByThread();
                                break;
                        case 'BoardPage':
                                $boardID = $this->eventObj->boardID;
                                $boardList = new BoardListTaggingReloaded($boardID);
                                $boardList->renderBoards();
                                $this->readSubBoards($boardList->getSubBoards());
                                $this->boards[] = $boardID;
                                
                                $sql = $this->queryTagsByBoard();
                                break;
                        case 'TaggingPage':
                                if(isset($_GET['tag'])) {
                                        $this->tag = $_GET['tag'];
                                        $check = true;
                                        $this->readThreadsByTag();
                                        $sql = $this->queryTagsByTag();
                                }
                                break;
                }
                
                // break
                if(!isset($sql)) return;

                // order by tag
                $sql = "SELECT tag,weight FROM ($sql) A ORDER BY tag ASC";
                
                // query
                $result = WCF::getDB()->sendQuery($sql);
                while ($row = WCF::getDB()->fetchArray($result)) {
                        $this->tags[$row['tag']] = array(
                                        'weight'=> $row['weight'],
                                        'color'=> 0,
                                        'size'=> 0,
                                        'url' => $this->rewriter->publicParseTagURLs($row['tag'])
                                        
                                );
                }
                
                $this->tags = TaggingReloadedUtil::beautify($this->tags);
                
                // are there any threads?
                if(isset($check) && count($this->threadList) == 0) {
                        require_once(WCF_DIR.'lib/system/exception/IllegalLinkException.class.php');
                        throw new IllegalLinkException();
                }
        }
        
        /**
         * fetch recursive all child boardIDs
         * @param arr
         */
        protected function readSubBoards($arr) {
                foreach($arr as $boardID => $next) {
                        $this->boards[] = $boardID;
                        $this->readSubBoards($next);
                }
        }
        
        /**
         * @see Page::assignVariables()
         */
        protected function assignVariables () {
                WCF::getTPL()->assign('tags', $this->tags);
                WCF::getTPL()->append('specialStyles', '<link rel="stylesheet" type="text/css" href="'.RELATIVE_WCF_DIR.'style/taggingreloaded.css" />');
                
                if(count($this->tags) > 0 && ($this->threadID || $this->postID || count($this->boards)>0)) {
                        WCF::getTPL()->append('additionalBoxes', WCF::getTPL()->fetch('taggingCloudContainer'));
                } else if($this->tag) {
                        WCF::getTPL()->assign('threads', $this->threadList);
                        WCF::getTPL()->append('additionalTaggingContents', WCF::getTPL()->fetch('taggingCloud'));
                        WCF::getTPL()->append('additionalTaggingContents', WCF::getTPL()->fetch('threadListTagging'));
                }
        }
}
?>