PhpcmsV9调用全站最新文章的方法小编亲测完美好用

来源：齐鲁建站栏目：开发教程阅读：日期：2020-07-26

今天有客户想实现PhpcmsV9调用全站最新文章，不过PHPCMS默认是没有这个功能的，只能调用某个频道或栏目的最新文章，只要是跨模型就不行了，齐鲁建站小编经过研究发现Phpcms调用全站文章的方法，亲测完美好用。

下面就来说说Phpcms调用全站文章的方法。

第一步：需要修改文件：\phpcms\modules\content\classes\content_tag.class.php，找到以下函数

/**

* 列表页标签

* @param $data

*/

public function lists($data) {

$catid = intval($data['catid']);

if(!$this->set_modelid($catid)) return false;

if(isset($data['where'])) {

$sql = $data['where'];

} else {

$thumb = intval($data['thumb']) ? " AND thumb != ''" : '';

if($this->category[$catid]['child']) {

$catids_str = $this->category[$catid]['arrchildid'];

$pos = strpos($catids_str,',')+1;

$catids_str = substr($catids_str, $pos);

$sql = "status=99 AND catid IN ($catids_str)".$thumb;

} else {

$sql = "status=99 AND catid='$catid'".$thumb;

}

}

$order = $data['order'];

$return = $this->db->select($sql, '*', $data['limit'], $order, '', 'id');

//调用副表的数据

if (isset($data['moreinfo']) && intval($data['moreinfo']) == 1) {

$ids = array();

foreach ($return as $v) {

if (isset($v['id']) && !empty($v['id'])) {

$ids[] = $v['id'];

} else {

continue;

}

}

if (!empty($ids)) {

$this->db->table_name = $this->db->table_name.'_data';

$ids = implode('\',\'', $ids);

$r = $this->db->select("`id` IN ('$ids')", '*', '', '', '', 'id');

if (!empty($r)) {

foreach ($r as $k=>$v) {

if (isset($return[$k])) $return[$k] = array_merge($v, $return[$k]);

}

}

}

}

return $return;

}

修改为：

/**

* 列表页标签

* @param $data

*/

public function lists($data) {

$catid = intval($data['catid']);

if(isset($data['where'])) {

$sql = $data['where'];

} else {

$thumb = intval($data['thumb']) ? " AND thumb != ''" : '';

if(!empty($catid)) {

if(!$this->set_modelid($catid)) return false;

if($this->category[$catid]['child']) {

$catids_str = $this->category[$catid]['arrchildid'];

$pos = strpos($catids_str,',')+1;

$catids_str = substr($catids_str, $pos);

$sql = "status=99 AND catid IN ($catids_str)".$thumb;

} else {

$sql = "status=99 AND catid='$catid'".$thumb;

}

}

else {

$sql = "status=99".$thumb;

}

}

$order = $data['order'];

$return = $this->db->select($sql, '*', $data['limit'], $order, '', 'id');

//调用副表的数据

if (isset($data['moreinfo']) && intval($data['moreinfo']) == 1) {

$ids = array();

foreach ($return as $v) {

if (isset($v['id']) && !empty($v['id'])) {

$ids[] = $v['id'];

} else {

continue;

}

}

if (!empty($ids)) {

$this->db->table_name = $this->db->table_name.'_data';

$ids = implode('\',\'', $ids);

$r = $this->db->select("`id` IN ('$ids')", '*', '', '', '', 'id');

if (!empty($r)) {

foreach ($r as $k=>$v) {

if (isset($return[$k])) $return[$k] = array_merge($v, $return[$k]);

}

}

}

}

return $return;

}