order('list_order desc')->select(); //加盟头条 $toutiao = Db::name('news')->where($map)->field('id,title')->order('id desc')->limit(12)->select(); //热点聚焦 $redian = Db::name('news')->where($map)->field('id,title,thumb,keywords,create_time')->where('thumb','not null')->limit(4)->select(); //分类资讯 $ncate_list = array(); foreach($article_cates as $k=>$v){ $dqid = $v['id']; $nlist = Db::name('news')->where($map)->where('ncatid',$dqid)->order('list_order')->limit(5)->select(); $ncate_list[$dqid] = $nlist; } //二级分类 // $cates = Db::name('category')->where('parent_id','gt',0)->order('list_order')->limit(12)->select(); // $cate_list = array(); // foreach($cates as $k=>$v){ // $fl_list = Db::name('news')->where($map)->field('id,title,create_time')->where('catid',$v['id'])->limit(10)->select(); // $v['infos'] = $fl_list; // $cate_list[$v['id']] = $v; // } //修改为显示1及分类 $cates = Db::name('category')->where('parent_id',0)->order('list_order')->limit(12)->select(); $cate_list = array(); foreach($cates as $k=>$v){ $son_cate = Db::name('category')->where('parent_id',$v['id'])->order('list_order')->select()->toArray(); $son_array = array(); foreach($son_cate as $kk=>$vv){ $son_array[] = $vv['id']; } $fl_list = Db::name('news')->where($map)->where('catid','in',$son_array)->field('id,title,create_time')->limit(10)->select(); $v['infos'] = $fl_list; $cate_list[$v['id']] = $v; } $catinfo = array('id'=>0); //排行 $paihang = Db::name('jiameng')->field('id,title')->order('hits desc')->limit(15)->select(); //横幅广告 //横幅广告位 $brand8 = Db::name('jiameng')->field('id,title,logo,guanggaowei')->where('level',8)->order('list_order')->limit(2,2)->select()->toArray(); //热门精选 $brand_jx = Db::name('jiameng')->field('id,title,logo')->order('list_order')->limit(5)->select()->toArray(); $news1 = Db::name('news')->where($map)->field('id,title,thumb,guanggaowei')->where('level',1)->order('list_order')->limit(5)->select()->toArray(); $news2 = Db::name('news')->where($map)->field('id,title,guanggaowei')->where('level',2)->order('list_order')->limit(2)->select()->toArray(); $this->assign('news1',$news1); $this->assign('news2',$news2); $this->assign('brand8',$brand8); $this->assign('brand_jx',$brand_jx); $this->assign('cate_list',$cate_list); $this->assign('paihang',$paihang); $this->assign('cates',$cates); $this->assign('ncate_list',$ncate_list); $this->assign('redian',$redian); $this->assign('toutiao',$toutiao); $this->assign('article_cates',$article_cates); $this->assign('catinfo',$catinfo); $this->assign('link_cate_name','news'); // $this->assign('article_encate',$article_encate); return $this->fetch(); } public function show(){ $param = $this->request->param(); isset($param['id']) or $this->error('非法访问'); $info = Db::name('news')->where('id',$param['id'])->where('status',1)->find(); if(empty($info)){ $this->error('未找到新闻'); } $catinfo = Db::name('news_category')->where('id',$info['ncatid'])->find(); // $article_cates = ['加盟快讯','新店开业','店铺选址','加盟指南','品牌新闻','品牌人物']; // $article_dy = ['zixun'=>0,'kaiye'=>1,'xuanzhi'=>2,'zhinan'=>3,'xinwen'=>4,'renwu'=>5]; // $article_encate = ['zixun','kaiye','xuanzhi','zhinan','xinwen','renwu']; $bcate = Db::name('category')->where('id',$info['catid'])->find(); $info['catname'] = $bcate['catname']; $article_cates = Db::name('news_category')->order('list_order desc')->select(); //更新点击次数 Db::name('news')->where('id',$param['id'])->setInc('hits',1); //内容 $content = Db::name('news_data')->where('id',$param['id'])->find(); $info['content'] = $content['content']; //下一篇 $map['status'] = 1; $nextinfo = Db::name('news')->field('id,title')->where($map)->where('id','gt',$param['id'])->order('id')->limit(1)->find(); if(!empty($nextinfo)){ $next = 1; }else{ $next = 0; } $brand_info = array(); if($info['pid']){ $brand_info = Db::name('jiameng')->field('id,catid,title,touzi_level,mendian,yxjm')->find(); //品牌分类 $brand_cate = Db::name('category')->where('id',$brand_info['catid'])->find(); if(!empty($brand_cate)){ $this->assign('brand_cate',$brand_cate); }else{ $this->assign('brand_cate',[]); } } $touziarr = array( '1万元以下', '1~5万元', '5~10万元', '10~20万元', '20~50万元', '50~100万元', '100万元以上', '200万元以上', '300万元以上' ); $this->assign('touziarr',$touziarr); $this->assign('brand_info',$brand_info); $this->assign('nextinfo',$nextinfo); $this->assign('next',$next); $this->assign('article_cates',$article_cates); $this->assign('catinfo',$catinfo); // $this->assign('article_encate',$article_encate); $this->assign('info',$info); //seo $seo_title = $info['seo_title']; $seo_keywords = $info['seo_keywords'];; $seo_desc = mb_substr($info['content'],0,200,'utf8'); $seo_desc = strip_tags($seo_desc); $this->assign('seo_title',$seo_title); $this->assign('seo_keywords',$seo_keywords); $this->assign('seo_desc',$seo_desc); return $this->fetch(); } public function list(){ $param = $this->request->param(); $article_cates = Db::name('news_category')->order('list_order desc')->select(); $map['status'] = 1; if(isset($param['catname'])){ $catinfo = Db::name('news_category')->where('enname',$param['catname'])->find(); if(empty($catinfo)){ $this->error('未找到分类'); } $catid = $catinfo['id']; $map['ncatid'] = $catid; } $lists = Db::name('news')->field('id,title,thumb,keywords,hits,create_time')->where($map)->order('id desc')->paginate(10); $this->assign('lists',$lists); $this->assign('article_cates',$article_cates); // $this->assign('article_encate',$article_encate); $this->assign('catinfo',$catinfo); $this->assign('typeid',$catid); //seo $seo_title = $catinfo['seo_title']; $seo_keywords = $catinfo['seo_keywords']; $seo_desc = $catinfo['seo_desc']; $this->assign('seo_title',$seo_title); $this->assign('seo_keywords',$seo_keywords); $this->assign('seo_desc',$seo_desc); //seo $seo_title = str_replace('|',$catinfo['catname'],$catinfo['seo_title']); $seo_keywords = str_replace('|',$catinfo['catname'],$catinfo['seo_keywords']); $seo_desc = str_replace('|',$catinfo['catname'],$catinfo['seo_desc']); $this->assign('seo_title',$seo_title); $this->assign('seo_keywords',$seo_keywords); $this->assign('seo_desc',$seo_desc); return $this->fetch(); } public function message(){ return $this->fetch(); } } ?>