NN2020042801/app/index/controller/NewsController.php

<?php
namespace app\index\controller;
use app\index\service\CategoryService;
use app\index\service\JiamengService;
use app\index\service\NewsCategoryService;
use app\index\service\NewsService;
use cmf\controller\HomeBaseController;
use think\Db;
class NewsController extends HomeBaseController
{
    public function index()
    {
        $map['status'] = 1;
        $cate_list = NewsCategoryService::getCates(20);
        $cate_list = $cate_list? $cate_list->toArray() : [];

        $catinfo = array('id'=>0);
        //排行
        $paihang = JiamengService::getHotList(18);

        // 最新入驻
        $brand_jx = JiamengService::getNewList(12);
        
        $news1 = NewsService::getList(['level'=> 1], 18);

        $newsHot = NewsService::getHotList();

        $this->assign('news1',$news1);
        $this->assign('data',$news1? $news1->toArray(): ['total'=>0]);
        $this->assign('page',$news1->render());
        $this->assign('brand_jx',$brand_jx);
        $this->assign('hots', $newsHot);
        $this->assign('cate_list',$cate_list? array_chunk($cate_list, 6) : []);
        $this->assign('paihang',$paihang);
        $this->assign('catinfo',$catinfo);
        $this->assign('link_cate_name','news');
    
        return $this->fetch();
    }

    /**
     * 详情
     * @return mixed
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    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();
        $bcate = Db::name('category')->where('id',$info['catid'])->find();
        $info['catname'] = $bcate['catname'];

        //更新点击次数
        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;
        // 上一篇
        $lastInfo = Db::name('news')->field('id,title')->where($map)->where('id','lt',$param['id'])->order('id desc')->limit(1)->find();
        //下一篇
        $nextInfo = Db::name('news')->field('id,title')->where($map)->where('id','gt',$param['id'])->order('id')->limit(1)->find();
        $last = $lastInfo? 1 : 0;
        $next = $nextInfo? 1 : 0;

        // 最新入驻
        $brand_jx = JiamengService::getNewList(12);

        // 推荐品牌
        $touziarr = config('params.touziLevels');
        $jx_jm = Db::name('jiameng')
            ->field('id,title,logo,touzi_level,hits')
            ->whereNotIn('id',$info['id'])
            ->orderRaw('rand()')
            ->limit(10)
            ->select()
            ->each(function($item, $k) use ($touziarr){
                $touziLevel = isset($item['touzi_level']) ? $item['touzi_level'] : '-1';
                $item['touzi_level_name'] = isset($touziarr[$touziLevel]) ? $touziarr[$touziLevel] : '';
                return $item;
            });

        // 加盟资讯
        $jm_news = NewsService::getListByCate(1, 6);

        // 相关资讯
        $other_news = NewsService::getListByCate($info['catid'], 10);

        $keywords = [];
        if(isset($info['keywords']) && !empty($info['keywords'])){
            $keywords = explode(',', $info['keywords']);
        }

        $this->assign('lastInfo',$lastInfo);
        $this->assign('nextInfo',$nextInfo);
        $this->assign('last',$last);
        $this->assign('next',$next);
        $this->assign('catinfo',$catinfo);
        $this->assign('info',$info);
        $this->assign('brand_jx',$brand_jx);
        $this->assign('jx_jm',$jx_jm);
        $this->assign('jm_news',$jm_news);
        $this->assign('other_news',$other_news);
        $this->assign('keywords',$keywords);

        //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(){
        $catinfo = [];
        $param = $this->request->param();
        $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;
        }

        $kw = isset($param['kw'])? trim($param['kw']) : '';
        if($kw){
            $map['kw'] = $kw;
        }

        // 分类
        $cate_list = NewsCategoryService::getCates(20);
        $cate_list = $cate_list? $cate_list->toArray() : [];

        $lists = NewsService::getList($map, 10);

        //排行
        $paihang = JiamengService::getHotList(18);

        // 最新入驻
        $brand_jx = JiamengService::getNewList(12);

        $newsHot = NewsService::getHotList();

        $this->assign('news1',$lists);
        $this->assign('data',$lists? $lists->toArray(): ['total'=>0]);
        $this->assign('page',$lists->render());
        $this->assign('brand_jx',$brand_jx);
        $this->assign('hots', $newsHot);
        $this->assign('cate_list',$cate_list? array_chunk($cate_list, 6) : []);
        $this->assign('paihang',$paihang);
        $this->assign('catinfo',$catinfo);
        $this->assign('link_cate_name','news');

        //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();
    }

    public function complaint(){
        return $this->fetch();
    }
}
?>