phpcms v9 调用方法全站点击排行

最新推荐文章于 2021-04-03 07:56:44 发布

gstormspire

最新推荐文章于 2021-04-03 07:56:44 发布

阅读量1.2k

点赞数

分类专栏： phpcms 文章标签： sql merge action function

本文链接：https://blog.csdn.net/gstormspire/article/details/7885404

版权

phpcms 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

/**
	 * 排行榜标签
	 * @param $data
	 */
	public function hits($data) {
		$catid = intval($data['catid']);
		if($catid != 0){
			if(!$this->set_modelid($catid)) return false;
		}

		$this->hits_db = pc_base::load_model('hits_model');
		$sql = $desc = $ids = '';
		$array = $ids_array = array();
		$order = $data['order'];
		$hitsid = 'c-'.$this->modelid.'-%';
		$sql = "hitsid LIKE '$hitsid'";
		if(isset($data['day'])) {
			$updatetime = SYS_TIME-intval($data['day'])*86400;
			$sql .= " AND updatetime>'$updatetime'";
		}
		if($catid != 0){
			if($this->category[$catid]['child']) {
				$catids_str = $this->category[$catid]['arrchildid'];
				$pos = strpos($catids_str,',')+1;
				$catids_str = substr($catids_str, $pos);
				$sql .= " AND catid IN ($catids_str)";
			} else {
				$sql .= " AND catid='$catid'";
			}
		}
		$hits = array();
		$result = $this->hits_db->select($sql, '*', $data['limit'], $order);
		foreach ($result as $r) {
			$pos = strpos($r['hitsid'],'-',2) + 1;
			$ids_array[] = $id = substr($r['hitsid'],$pos);
			$hits[$id] = $r;
		}
		$ids = implode(',', $ids_array);
		if($ids) {
			$sql = "status=99 AND id IN ($ids)";
		} else {
			$sql = '';
		}
		$this->db->table_name = $this->tablename;
		$result = $this->db->select($sql, '*', $data['limit'],'','','id');
		foreach ($ids_array as $id) {
			if($result[$id]['title']!='') {
				$array[$id] = $result[$id];
				$array[$id] = array_merge($array[$id], $hits[$id]);
			}
		}
		return $array;
	}

PHPCMS V9 只提供了调用单个频道点击排行的方法，只要对其方法做相应的改变就能做到全站排行。找到phpcms/modules/content/classes/content_tag.class.php，可以修改hits方法。

在相应位置增加$catid!=0的判断，前台调用：

{pc:content action="hits" catid="0" num="10" order="views DESC"}