topic.php

来自「php 开发的内容管理系统」· PHP 代码 · 共 370 行

<?php
/**
 * Article management
 *
 * @copyright	The XOOPS project http://www.xoops.org/
 * @license		http://www.fsf.org/copyleft/gpl.html GNU public license
 * @author		Taiwen Jiang (phppp or D.J.) <[e-mail]>
 * @since		1.00
 * @version		$Id$
 * @package		module::article
 */

/**
 * Xtopic 
 * 
 * @author D.J. (phppp)
 * @copyright copyright &copy; 2005 XoopsForge.com
 * @package module::article
 *
 * {@link XoopsObject} 
 **/
 
if (!defined("XOOPS_ROOT_PATH")) {
	exit();
}
include_once dirname(dirname(__FILE__))."/include/vars.php";
mod_loadFunctions("parse", $GLOBALS["artdirname"]);


if(!class_exists("Xtopic")){
class Xtopic extends ArtObject
{
    /**
     * holds reference to xoopsDB
     * @var object
     */
    //var $db;
    /**
     * @var string
     */
    //var $table;

    /**
     * Constructor
     */
    function Xtopic()
    {
	    $this->ArtObject();
        //$this->db =& Database::getInstance();
        $this->table = art_DB_prefix("topic");
        $this->initVar("top_id", XOBJ_DTYPE_INT, null, false);
        $this->initVar("cat_id", XOBJ_DTYPE_INT, 0, false);
        $this->initVar("top_title", XOBJ_DTYPE_TXTBOX, "", true);
        $this->initVar("top_description", XOBJ_DTYPE_TXTAREA);
        $this->initVar("top_template", XOBJ_DTYPE_TXTBOX);
        $this->initVar("top_time", XOBJ_DTYPE_INT);
        $this->initVar("top_expire", XOBJ_DTYPE_INT);
        $this->initVar("top_order", XOBJ_DTYPE_INT, 1);
        $this->initVar("top_sponsor", XOBJ_DTYPE_TXTAREA);
    }

    /**
     * get a list of parsed sponsors of the topic
     * 
     * @return 	array
     */
    function &getSponsor()
    {
	    $ret = art_parseLinks($this->getVar("top_sponsor", "e"));
	    return $ret;
    }

    /**
     * get formatted creation time of the topic
     * 
     * @param string $format format of time
     * @return 	string
     */
    function getTime($format ="")
    {
		mod_loadFunctions("time", $GLOBALS["artdirname"]);
	    $time = art_formatTimestamp($this->getVar("top_time"), $format);
		return $time;
    }

    /**
     * get formatted expiring time of the topic
     * 
     * @param string $format format of time
     * @return 	string
     */
    function getExpire($format ="")
    {
		mod_loadFunctions("time", $GLOBALS["artdirname"]);
	    $time = art_formatTimestamp($this->getVar("top_expire"), $format);
		return $time;
    }
}
}

/**
* Topic object handler class.  
* @package module::article
*
* @author  D.J. (phppp)
* @copyright copyright &copy; 2005 The XOOPS Project
*
* {@link XoopsPersistableObjectHandler} 
*
* @param CLASS_PREFIX variable prefix for the class name
*/

art_parse_class('
class [CLASS_PREFIX]TopicHandler extends ArtObjectHandler
{
	/**
	 * Constructor
	 *
	 * @param object $db reference to the {@link XoopsDatabase} object	 
	 **/
    function [CLASS_PREFIX]TopicHandler(&$db) {
        $this->ArtObjectHandler($db, art_DB_prefix("topic", true), "Xtopic", "top_id", "top_title");
    }

    /**
     * get a list of topics including a specified article and matching a condition
     * 
     * {@link Permission}
     *
     * @param	int		$art_id 	article ID
     * @param 	object	$criteria 	{@link CriteriaElement} to match
     * @return 	array of topics {@link Xtopoic}
     */
    function &getByArticle($art_id, $criteria = null)
    {
	    $_cachedTop=array();
		$ret = null;
	    if(empty($art_id)) {
		    return $ret;
	    }

        $sql = "SELECT t.top_id, t.top_title FROM " . art_DB_prefix("topic"). " AS t";
        $sql .= " LEFT JOIN ".art_DB_prefix("arttop")." AS at ON at.top_id=t.top_id";
        $sql .= " WHERE at.art_id =". intval($art_id);
		mod_loadFunctions("user", $GLOBALS["artdirname"]);
        if(!art_isAdministrator()){
			$permission_handler =& xoops_getmodulehandler("permission", $GLOBALS["artdirname"]);
			$allowed_cats =& $permission_handler->getCategories();
			if(count($allowed_cats)==0) return null;
        	$sql .= " AND t.cat_id IN (".implode(",",$allowed_cats).")";
    	}
	    $limit = $start = null;
        if (isset($criteria) && is_subclass_of($criteria, "criteriaelement")) {
            $sql .= " AND ".$criteria->render();
            if ($criteria->getSort() != "") {
                $sql .= " ORDER BY ".$criteria->getSort()." ".$criteria->getOrder();
                $orderSet = true;
            }
            $limit = $criteria->getLimit();
            $start = $criteria->getStart();
        }
        if(empty($orderSet))  $sql .= " ORDER BY t.cat_id, t.top_order, t.top_time DESC";
        if (!$result = $this->db->query($sql, $limit, $start)) {
		    return $ret;
        }
        while ($row = $this->db->fetchArray($result)) {
            $topic =& $this->create(false);
            $topic->assignVars($row);
            $_cachedTop[$topic->getVar("top_id")] = $topic;
            unset($topic);
        }
        return $_cachedTop;
    }

    /**
     * get a list of topics matching a condition of a category
     * 
     * @param	mixed	$cat_id 	category ID(s)
	 * @param 	int   	$limit      Max number of objects to fetch
	 * @param 	int   	$start      Which record to start at
     * @param 	object	$criteria 	{@link CriteriaElement} to match
     * @param 	array	$tags 		variables to fetch
     * @param 	bool	$asObject 	flag indicating as object, otherwise as array
     * @return 	array of topics {@link Xtopoic}
     */
   	function &getByCategory($cat_id=0, $limit=0, $start = 0, $criteria = null, $tags = null, $asObject=true)
    {
        if (isset($criteria) && is_subclass_of($criteria, "criteriaelement")) {
        }else{
			$criteria = new CriteriaCompo();
        }
        $criteria->setLimit($limit);
        $criteria->setStart($start);

        if(is_array($cat_id) && count($cat_id)>0){
		    $cat_id = array_map("intval",$cat_id);
        	$criteria->add(new criteria("cat_id", "(".implode(",", $cat_id).")", "IN"));
        }elseif(intval($cat_id)){
        	$criteria->add(new criteria("cat_id", intval($cat_id)));
        }
        $ret = $this->getAll($criteria, $tags, $asObject);
        return $ret;
    }

    /**
     * count topics matching a condition of a category (categories)
     * 
     * @param 	mixed 	$category array or {@link Xcategory}
     * @param object $criteria {@link CriteriaElement} to match
     * @return int count of topics
     */
   	function getCountByCategory($cat_id=0, $criteria = null)
    {
        $sql = "SELECT COUNT(*) AS count FROM " . art_DB_prefix("topic");
        if(is_array($cat_id) && count($cat_id)>0){
		    $cat_id = array_map("intval",$cat_id);
        	$sql .= " WHERE cat_id IN (".implode(",", $cat_id).")";
        }elseif(intval($cat_id)){
        	$sql .= " WHERE cat_id = ".intval($cat_id);
        }else{
        	$sql .= " WHERE 1=1";
        }
        if (isset($criteria) && is_subclass_of($criteria, "criteriaelement")) {
            $sql .= " AND ".$criteria->render();
        }
        if (!$result = $this->db->query($sql)) {
            return false;
        }
        $myrow = $this->db->fetchArray($result);
        return intval($myrow["count"]);
    }

    /**
     * count topics matching a condition grouped by category
     * 
     * @param 	object 	$criteria {@link CriteriaElement} to match
     * @return array	associative array of count of topics and category ID
     */
   	function getCountsByCategory($criteria = null)
   	{
        $sql = "SELECT cat_id, COUNT(*) as count FROM ".art_DB_prefix("topic")." GROUP BY cat_id";
        if (isset($criteria) && is_subclass_of($criteria, "criteriaelement")) {
            $sql .= " ".$criteria->renderWhere();
        }
        $result = $this->db->query($sql);
        $ret = array();
        while ($myrow = $this->db->fetchArray($result)) {
            $ret[$myrow["cat_id"]] = $myrow["count"];
        }
        return $ret;
   	}

    /**
     * get articles matching a condition of a topic
     * 
	 * {@link Article} 
	 *
     * @param mixed		$topic 		topic ID or {@link Xtopic}
	 * @param int   	$limit      Max number of objects to fetch
	 * @param int   	$start      Which record to start at
     * @param object	$criteria 	{@link CriteriaElement} to match
     * @param array		$tags 		variables to fetch
     * @return array of articles {@link Article}
     */
    function &getArticles(&$topic, $limit=0, $start=0, $criteria = null, $tags=null)
    {
        $top_id = (is_object($topic))? $topic->getVar("top_id"):intval($topic);
		$article_handler =& xoops_getmodulehandler("article", $GLOBALS["artdirname"]);
		$ret =& $article_handler->getByTopic($top_id, $limit, $start, $criteria, $tags);
		return $ret;
	}

    /**
     * count articles matching a condition of a cateogy (categories)
     * 
     * @param 	mixed	$top_id	array or {@link Xtopic}
     * @param 	object 	$criteria {@link CriteriaElement} to match
     * @return 	int 	count of articles
     */
    function getArticleCount($top_id, $criteria = null)
    {
        $sql = "SELECT COUNT(*) as count FROM ".art_DB_prefix("arttop");
        if(is_array($top_id) && count($top_id)>0){
        	$sql .= " WHERE top_id IN (".implode(",", $top_id).")";
        }elseif(intval($top_id)){
        	$sql .= " WHERE top_id = ".intval($top_id);
        }else{
        	$sql .= " WHERE 1=1";
        }
        if (isset($criteria) && is_subclass_of($criteria, "criteriaelement")) {
            $sql .= " AND ".$criteria->render();
        }
        $result = $this->db->query($sql);
        $myrow = $this->db->fetchArray($result);
        return intval($myrow["count"]);
    }

    /**
     * count articles matching a condition of a list of topics, respectively
     * 
     * @param 	mixed	$top_id array or {@link Xtopic}
     * @param 	object 	$criteria {@link CriteriaElement} to match
     * @return 	array 	associative array topic ID and article count
     */
    function getArticleCounts($top_id, $criteria = null)
    {
        $sql = "SELECT top_id, COUNT(*) as count FROM ".art_DB_prefix("arttop");
        if(is_array($top_id) && count($top_id)>0){
        	$sql .= " WHERE top_id IN (".implode(",", $top_id).")";
        }elseif(intval($top_id)){
        	$sql .= " WHERE top_id = ".intval($top_id);
        }else{
        	$sql .= " WHERE 1=1";
        }
        if (isset($criteria) && is_subclass_of($criteria, "criteriaelement")) {
            $sql .= " AND ".$criteria->render();
        }
        $sql .= " GROUP BY top_id";
        $result = $this->db->query($sql);
        $ret = array();
        while ($myrow = $this->db->fetchArray($result)) {
            $ret[$myrow["top_id"]] = $myrow["count"];
        }
        return $ret;
    }

    /**
     * check permission of the topic
     * 
	 * {@link Xcategory} 
	 *
     * @param 	object	$topic 	{@link Xtopic}
     * @param 	string 	$type 	permission type
     * @return 	bool 	true on accessible
     */
    function getPermission(&$topic, $type = "access")
    {
	    if(!is_object($topic)) $topic=& $this->get(intval($topic));
		$category_handler =& xoops_getmodulehandler("category", $GLOBALS["artdirname"]);
		$category_obj =& $category_handler->get($topic->getVar("cat_id"));
		return $category_handler->getPermission($category_obj, $type);
    }
    
    /**
     * clean orphan topics from database
     * 
     * @return 	bool	true on success
     */
    function cleanOrphan()
    {
	    //parent::cleanOrphan(art_DB_prefix("article"), "art_id");
	    
    	/* for MySQL 4.1+ */
    	if($this->mysql_major_version() >= 4):
        $sql = "DELETE FROM ".art_DB_prefix("arttop").
        		" WHERE (top_id NOT IN ( SELECT DISTINCT top_id FROM ".art_DB_prefix("topic").") )";
        else: 
        $sql = 	"DELETE ".art_DB_prefix("arttop")." FROM ".art_DB_prefix("arttop").
        		" LEFT JOIN ".art_DB_prefix("topic")." AS aa ON ".art_DB_prefix("arttop").".top_id = aa.top_id ".
        		" WHERE (aa.top_id IS NULL)";
		endif;
        if (!$result = $this->db->queryF($sql)) {
	        //xoops_error("cleanOrphan: ". $sql);
	        return false;
        }
        return true;
    }
}
');
?>