NN2020042801/app/index/controller/IndexController.php

<?php
namespace app\index\controller;
use cmf\controller\HomeBaseController;
use think\Db;
class IndexController extends HomeBaseController
{
    public function index()
    {
        //一级分类+二级分类
        $catearr = Db::name('category')->where('parent_id',0)->order('list_order')->limit(0,8)->select();
        foreach($catearr as $k=>$v){
            $erji_cate = Db::name('category')->where('parent_id',$v['id'])->order('list_order')->limit(0,2)->select();
            $v['son'] = $erji_cate;
            $catearr[$k] = $v;
        }
        //推荐品牌 3
        $brand3 = Db::name('jiameng')->field('id,title,logo,guanggaowei')->where('level',3)->order('list_order')->limit(8)->select();
        //广告位 4 
        $brand4 = Db::name('jiameng')->field('id,title,logo,guanggaowei,thumb')->where('level',4)->order('list_order')->limit(6)->select();
        //底部推荐品牌2
        $brand2 = Db::name('jiameng')->field('id,title,touzi_level,logo,guanggaowei')->where('level',2)->order('list_order')->limit(10)->select();
        //底部推荐品牌2
        $brand5 = Db::name('jiameng')->field('id,logo,touzi_level,title,guanggaowei')->where('level',5)->order('list_order')->limit(6)->select();
        $brand7 = Db::name('jiameng')->field('id,title,mendian,area,logo,guanggaowei,product,touzi_level')->where('level',7)->order('list_order')->limit(10)->select();
        //横幅广告位
        $brand8 = Db::name('jiameng')->field('id,title,logo,guanggaowei')->where('level',8)->order('list_order')->limit(3)->select()->toArray();
        
        //资讯
        $news1 = Db::name('news')->where('status',1)->field('id,title,create_time')->where('ncatid',1)->order('list_order,id desc')->limit(8)->select();
        $news2 = Db::name('news')->where('status',1)->field('id,title')->where('ncatid',2)->order('list_order,id desc')->limit(8)->select();
        $news3 = Db::name('news')->where('status',1)->field('id,title')->where('ncatid',3)->order('list_order,id desc')->limit(8)->select();
        
        // print_r($brand_cate);exit;
        //文章分类
        $article_cates = Db::name('news_category')->order('list_order asc')->limit(6)->select();
        $news_list = array();
        foreach($article_cates as $k=>$v){
            $xinwen = Db::name('news')->where('status',1)->field('id,title,create_time')->where('ncatid',$v['id'])->order('id desc')->limit(5)->select();
            $v['xinwen'] = $xinwen;
            $article_cates[$k] = $v;
        }
        // print_r($article_cates);exit;
        //带图片的新闻
        // $news_thumb = Db::name('news')->field('id,title,thumb')->where('thumb','not null')->order('id desc')->limit(5)->select();
        //热点新闻
        $news_hot = Db::name('news')->where('status',1)->field('id,title,keywords')->order('hits desc')->limit('4')->select();
        //最新动态、
        $news_last = Db::name('news')->where('status',1)->field('id,title,keywords')->order('id desc')->limit('6')->select();
        //加盟品牌排行
        $paihang = Db::name('jiameng')->field('id,title,logo,hits,mendian,touzi_level')->order('hits desc')->limit(10)->select();
        $touziarr = array(
            '1万元以下',
            '1～5万元',
            '5～10万元',
            '10～20万元',
            '20～50万元',
            '50～100万元',
            '100万元以上',
            '200万元以上',
            '300万元以上'
        );
        //新闻广告位
        $xinwen3 = Db::name('news')->where('status',1)->field('id,title,guanggaowei')->where('level',3)->limit(5)->select();
        $xinwen4 = Db::name('news')->where('status',1)->field('id,title,guanggaowei')->where('level',4)->limit(5)->select();
        $xinwen5 = Db::name('news')->where('status',1)->field('id,title,guanggaowei')->where('level',5)->limit(2)->select();
        
        $this->assign('xinwen3',$xinwen3);
        $this->assign('xinwen4',$xinwen4);
        $this->assign('xinwen5',$xinwen5);
        $this->assign('news_list',$news_list);
        $this->assign('touziarr',$touziarr);
        $this->assign('paihang',$paihang);
        $this->assign('news_last',$news_last);
        $this->assign('news_hot',$news_hot);
        
        $this->assign('article_cates',$article_cates);
        // $this->assign('brand_cate',$brand_cate);
        $this->assign('news1',$news1);
        $this->assign('news2',$news2);
        $this->assign('news3',$news3);
        $this->assign('brand3',$brand3);
        $this->assign('brand4',$brand4);
        $this->assign('brand2',$brand2);
        $this->assign('brand5',$brand5);
        $this->assign('brand7',$brand7);
        $this->assign('brand8',$brand8);
        $this->assign('catearr',$catearr);
        $this->assign('link_cate_name','index');
        return $this->fetch();
    }

    public function ws()
    {
        return $this->fetch(':ws');
    }
}
?>