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)
            ->field('id,catname,enname')
            ->order('list_order')
            ->limit(0,12)
            ->select();
        foreach($catearr as $k=>$v){
            $erji_cate = Db::name('category')
                ->where('parent_id',$v['id'])
                ->field('id,enname,catname')
                ->order('list_order')
                ->limit(0,2)
                ->select();
            $v['son'] = $erji_cate;

            $xmList = Db::name('jiameng')
                ->where(['catid|pcatid'=> $v['id'],'status'=> 1])
                ->field('id,title')
                ->order('list_order')
                ->limit(12)
                ->select();
            $data = $v;
            $data['xmList'] = $xmList;
            $v['sonData'][] = $data;

            // 子类的ID
            foreach ($erji_cate as $val){
                $xmList = Db::name('jiameng')
                    ->where(['catid|pcatid'=> $val['id'],'status'=> 1])
                    ->field('id,title')
                    ->order('list_order')
                    ->limit(12)
                    ->select();
                $data = $val;
                $data['xmList'] = $xmList;
                $v['sonData'][] = $data;
            }


            $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();
        //横幅广告位
        $banner = Db::name('slide_item')->where(['slide_id'=>1,'status'=> 1])
            ->field('id,title,image,url,target')
            ->order('list_order')
            ->limit(6)
            ->select()
            ->toArray();

        $banner1 = Db::name('slide_item')->where(['slide_id'=>3,'status'=> 1])
            ->field('id,title,image,url,target')
            ->order('list_order')
            ->limit(1)
            ->select()
            ->toArray();

        $bannerMin = Db::name('slide_item')->where(['slide_id'=>2,'status'=> 1])
            ->field('id,title,image,url,target')
            ->order('list_order')
            ->limit(5)
            ->select()
            ->toArray();

        $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('banner',$banner);
        $this->assign('banner1',$banner1);
        $this->assign('bannerMin',$bannerMin);
        // end


        $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');
    }
}
?>