NN2020042801/app/index/controller/Top10Controller.php

<?php
namespace app\index\controller;
use cmf\controller\HomeBaseController;
use think\Db;
class Top10Controller extends HomeBaseController
{
    public function index()
    {
        //行业分类
        $brand_cate = Db::name('category')->where('parent_id',0)->order('list_order')->select();
        foreach($brand_cate as $k=>$v){
            $son_cate = Db::name('category')->where('parent_id',$v['id'])->order('list_order')->select()->toArray();
            $v['son'] = $son_cate;
            //推荐的品牌
            $tuijian_brand = Db::name('jiameng')->field('id,title,thumb,touzi_level,mendian')->where('pcatid',$v['id'])->order('list_order')->limit(10)->select();
            $v['tuijian'] = $tuijian_brand;
            $brand_cate[$k] = $v;
        }
        //top10
        $top10 = Db::name('jiameng')->field('id,title,logo,hits,touzi_level,product,thumb')->order('hits desc')->limit(10)->select();
        //飙升榜
        $zengzhang10 = Db::name('jiameng')->field('id,title,logo,hits,touzi_level,product')->order('list_order')->limit(10)->select();
        //推荐
        $tuijian = Db::name('jiameng')->field('id,title,logo,hits,touzi_level,mendian')->orderRaw('rand()')->limit(4)->select();
        $touziarr = array(
            '1万元以下',
            '1～5万元',
            '5～10万元',
            '10～20万元',
            '20～50万元',
            '50～100万元',
            '100万元以上',
            '200万元以上',
            '300万元以上'
        );
        //最新新闻
        $zuixin_news = Db::name('news')->where('ncatid',4)->order('id desc')->limit(10)->select();
        //最热新闻
        $hot_news = Db::name('news')->where('ncatid',4)->order('hits desc')->limit(10)->select();
        $this->assign('zuixin_news',$zuixin_news);
        $this->assign('hot_news',$hot_news);
        $this->assign('tuijian',$tuijian);
        $this->assign('zengzhang10',$zengzhang10);
        $this->assign('touziarr',$touziarr);
        $this->assign('top10',$top10);
        $this->assign('brand_cate',$brand_cate);
        return $this->fetch();
    }
    public function show(){
        return $this->fetch();
    }
    public function cate(){
        $param = $this->request->param();
        $lists = array();
        //字分类
        $soncate = array();

        if(isset($param['catname'])){
            $catinfo = Db::name('category')->where('enname',$param['catname'])->find();
            if(empty($catinfo)){
                $this->error('未找到分类');
            }
            $map = array();
            $new_map['status'] = 3;
            if($catinfo['parent_id']>0){
                $new_map['catid'] = $catinfo['id'];
                //字分类
                $map['catid'] = $catinfo['id'];
                $soncate = Db::name('category')->where('parent_id',$catinfo['parent_id'])->order('list_order')->limit(14)->select();
            }else{
                //父分类
                $map['pcatid'] = $catinfo['id'];
                $soncate = Db::name('category')->where('parent_id',$catinfo['id'])->order('list_order')->limit(14)->select();
                // $new_map['catid'] = $soncate[0]['id'];
                $soncate_arr = array();
                foreach($soncate as $kk=>$vv){
                	$soncate_arr[] = $vv['id'];
                }
                // print_r($soncate_arr);exit;
                $new_map = [['catid','in',$soncate_arr]];
            }
            $lists = Db::name('jiameng')->field('id,title,thumb,area,touzi_level,fromyear,company,product')->where($map)->order('hits desc')->limit(10)->select();
            //排行
            $paihang = Db::name('jiameng')->field('id,title,touzi_level,touzi')->where($map)->order('list_order desc')->limit(10)->select();
            $zuixin = Db::name('jiameng')->field('id,title,touzi_level,touzi')->where($map)->order('id desc')->limit(10)->select();
            //火热招生
            $huore = Db::name('jiameng')->field('id,title,touzi_level,product,mendian,thumb')->where($map)->orderRaw('rand()')->limit(10)->select();
        }else{
            $lists = Db::name('jiameng')->field('id,title,thumb,area,touzi_level,fromyear,company,product')->order('hits desc')->limit(10)->select();
        }
        
        $touziarr = array(
            '1万元以下',
            '1～5万元',
            '5～10万元',
            '10～20万元',
            '20～50万元',
            '50～100万元',
            '100万元以上',
            '200万元以上',
            '300万元以上'
        );
        $parcate = Db::name('category')->where('parent_id',0)->order('list_order')->select();
        $this->assign('soncate',$soncate);
        //最新新闻
        $zuixin_news = Db::name('news')->where($new_map)->order('id desc')->limit(10)->select();
        //最热新闻
        $hot_news = Db::name('news')->where($new_map)->order('hits desc')->limit(10)->select();
        //推荐
        $tuijian = Db::name('jiameng')->field('id,title,logo,hits,touzi_level,mendian')->where($map)->orderRaw('rand()')->limit(4)->select();
        $article_cates = ['加盟快讯','新店开业','店铺选址','加盟指南','品牌新闻','品牌人物'];
        // $article_encate = ['zixun'=>0,'kaiye'=>1,'xuanzhi'=>2,'zhinan'=>3,'xinwen'=>4,'renwu'=>5];
        $article_encate = ['zixun','kaiye','xuanzhi','zhinan','xinwen','renwu'];
        $this->assign('parcate',$parcate);
        $this->assign('article_cates',$article_cates);
        $this->assign('article_encate',$article_encate);
        $this->assign('huore',$huore);
        $this->assign('zuixin',$zuixin);
        $this->assign('paihang',$paihang);
        $this->assign('tuijian',$tuijian);
        $this->assign('zuixin_news',$zuixin_news);
        $this->assign('hot_news',$hot_news);
        $this->assign('touziarr',$touziarr);
        $this->assign('lists',$lists);
        $this->assign('catinfo',$catinfo);
        //seo
        $site_info = cmf_get_site_info();
        $seo_title = str_replace('|',$catinfo['catname'],$site_info['site_seo_title_toplist']);
        $seo_keywords = str_replace('|',$catinfo['catname'],$site_info['site_seo_keywords_toplist']);
        $seo_desc = str_replace('|',$catinfo['catname'],$site_info['site_seo_desc_toplist']);
        $this->assign('seo_title',$seo_title);
        $this->assign('seo_keywords',$seo_keywords);
        $this->assign('seo_desc',$seo_desc);
        return $this->fetch();
    }
}
?>