NN2020042801/app/index/controller/NewsController.php

<?php
namespace app\index\controller;
use cmf\controller\HomeBaseController;
use think\Db;
class NewsController extends HomeBaseController
{
    public function index()
    {
        // $article_cates = ['加盟快讯','新店开业','店铺选址','加盟指南','品牌新闻','品牌人物'];
        // $article_encate = ['zixun','kaiye','xuanzhi','zhinan','xinwen','renwu'];
        $map['status'] = 1;
        $article_cates = Db::name('news_category')->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 lists(){
        $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('list');
    }
    
    public function message(){
    	return $this->fetch();
    }
    
}
?>