phpcms调用全站最新文章列表的方法

phpcms教程 强烈建议 2024-03-02 10:45 167 0

  /**

  * 列表页标签

  * @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(!emptyempty($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']) && !emptyempty($v['id'])) {

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

  } else {

  continue;

  }

  }

  if (!emptyempty($ids)) {

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

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

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

  if (!emptyempty($r)) {

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

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

  }

  }

  }

  }

  return $return;

  }

本站资源均来自互联网或会员发布,如果不小心侵犯了您的权益请与我们联系。我们将立即删除!谢谢!