$count = count($childs);
return $count;
}
/**
* 获取指定id的所有后代，不含指定id
* @param type $id 指定id, 有可能是array
* @return type 所有后代id的一维数组
*/
public function Index()
{
//读数据库,改刀数组,循环输出
if (!($list = S('index_list'))) {
//如果缓存'index_lis'不存在,则走数据库
//1st. hd_cate 中cid=0的所有数据
$db = M('cate');
$where = array('pid' => 0);
$list = $db->where($where)->order('sort')->select();
$cate = $db->select();
import('Class.Category', APP_PATH);
foreach ($list as $k => $v) {
$cids = Category::getChildsId($cate, $v['id']);
$cids[] = $v['id'];
$field = array('id', 'title', 'time');
$where = array('cid' => array('IN', $cids));
//事实证明, $list[$k]['blog'] !=$v['blog']
$list[$k]['blog'] = M('blog')->order('time DESC')->field($field)->where($where)->limit('5')->select();
}
S('index_list', $list, 10);
//将$list(数组)缓存到'index_list'中,缓存时间一天
}
$this->list = $list;
$this->display();
}
public function index()
{
import('Class.Category', APP_PATH);
import('ORG.Util.Page');
$id = (int) $_GET['id'];
$cate = M('cate')->order('sort')->select();
$cids = Category::getChildsId($cate, $id);
$cids = $id;
$where = array('cid' => array('IN', $cids));
$count = M('blog')->where($where)->count();
$page = new Page($count, 15);
$limit = $page->firstRow . ',' . $page->listRows;
$this->blog = D('BlogView')->getAll($where, $limit);
$this->page = $page->show();
$this->display();
}
public function index()
{
if (!($list = S('index_list'))) {
$list = M('cate')->where(array('pid' => 0))->order('sort')->select();
import('Class.Category', APP_PATH);
$cate = M('cate')->order('sort')->select();
$db = M('blog');
foreach ($list as $k => $v) {
$cids = Category::getChildsId($cate, $v['id']);
$cids[] = $v['id'];
$where = array('cid' => array('IN', $cids));
$list[$k]['blog'] = $db->field(array('id', 'title', 'time'))->where($where)->order('time DESC')->select();
}
//缓存名称 缓存数据 缓存时间10s
S('index_list', $list, 10);
}
$this->cate = $list;
$this->display();
}
public function detailsList()
{
import('Class.Category', './');
//引入无限极分类
import('ORG.Util.Page');
//导入分页类
$sort_id = intval($_GET['id']);
//获取传过来的分类id
$objDiscussSort = M('discuss_sort');
$objDiscuss = M('discuss');
$sortList = $objDiscussSort->select();
$sortList = deep_htmlspecialchars_decode($sortList);
//查询输出了数据库数据之后记得反转义
$idList = Category::getChildsId($sortList, $sort_id);
//传一个父ID获取所有的子ID 返回的是数组
$idList = implode(',', $idList);
//把数组拆成字符串 方便下面用in查询出父ID及其子id下面的文章
$idList = $sort_id . ',' . $idList;
//把当前的分类id 连接起子分类id
$idList = rtrim($idList, ',');
//去除右边的 逗号
$count = $objDiscuss->count();
//统计总数
$Page = new Page($count, 15);
//实例化分页类 传入总记录数和每页显示的记录数
$list = $objDiscuss->alias('AS a')->join('yrq_discuss_sort AS s ON a.sort_id = s.id')->field('s.sort_name,a.*')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$list = deep_htmlspecialchars_decode($list);
$this->assign('list', $list);
$show = $Page->show();
//分页显示输出
$this->assign('page', $show);
$this->display();
}
public function detailsList()
{
import('Class.Category', './');
//引入无限极分类
import('ORG.Util.Page');
//导入分页类
$sort_id = intval($_GET['id']);
//获取传过来的分类id
$objAdSort = M('ad_sort');
$objAd = M('ad');
$sortList = $objAdSort->select();
$sortList = deep_htmlspecialchars_decode($sortList);
//查询输出了数据库数据之后记得反转义
$idList = Category::getChildsId($sortList, $sort_id);
//传一个父ID获取所有的子ID 返回的是数组
$idList = implode(',', $idList);
//把数组拆成字符串 方便下面用in查询出父ID及其子id下面的文章
$idList = $sort_id . ',' . $idList;
//把当前的分类id 连接起子分类id
$idList = rtrim($idList, ',');
//去除右边的 逗号
$count = $objAd->count();
//统计总数
$Page = new Page($count, 15);
//实例化分页类 传入总记录数和每页显示的记录数
$list = $objAd->alias('AS a')->join('yrq_ad_sort AS s ON a.sort_id = s.id')->field('s.sort_name,a.*')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$list = deep_htmlspecialchars_decode($list);
//广告是否有效标记
foreach ($list as &$value) {
if ($value['status'] == 0 || $value['start_time'] > mktime() || $value['end_time'] < mktime()) {
$value['use_tag'] = 0;
} else {
$value['use_tag'] = 1;
}
}
$this->assign('list', $list);
$show = $Page->show();
//分页显示输出
$this->assign('page', $show);
$this->display();
}
