NN2020042801/app/index/controller/JiamengController.php

<?php
namespace app\index\controller;
use app\index\service\CategoryService;
use app\index\service\IpService;
use app\index\service\JiamengService;
use app\index\service\LinkService;
use app\index\service\MessageService;
use app\index\service\PageService;
use app\index\service\RedisService;
use cmf\controller\HomeBaseController;
use think\Db;
class JiamengController extends HomeBaseController
{
    public function index()
    {
        return $this->fetch();
    }

    public function home(){
        //二级分类
        $param = $this->request->param();
        isset($param['enname']) or $this->error('需要父分类');
        $curarr = Db::name('category')->where('enname',$param['enname'])->find();
        if($curarr['parent_id']>0){
            header("Location:".url('/404'));
            exit;
        }
        $sonarr = Db::name('category')->where('parent_id',$curarr['id'])->order('list_order')->limit(10)->select();
        $this->assign('sonarr',$sonarr);
        return $this->fetch();
    }

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

    /**
     * 列表
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function lists(){
        $param = $this->request->param();  
        //var_dump($param);die();
        $enname = isset($param['enname'])? trim($param['enname']) : '';
        $pcid = isset($param['pcid'])? intval($param['pcid']) : 0;
       
        $param = [
            'kw'=> isset($param['kw'])? trim($param['kw']) : '',
            'enname'=> isset($param['enname'])? trim($param['enname']) : '',
            'catid'=> isset($param['catid'])? intval($param['catid']) : 0,
            'pcid'=> isset($param['pcid'])? intval($param['pcid']) : 0,
            'lv'=> isset($param['lv'])? intval($param['lv']) : '-1',
            'aid'=> isset($param['aid'])? intval($param['aid']) : 0,
        ];
        $sonid = 0; 
        if($enname || $pcid){
            $where = [];
            if($enname){
                $where['enname'] = $enname;
            }
            if($pcid){
                $where['id'] = $pcid;
            }
            $cateData = Db::name('category')->where($where)->find(); 
            $this->assign('hangye',$cateData['catname']);
            $enname = isset($cateData['enname'])? $cateData['enname'] : '';
            $param['sid'] = $cateData['parent_id']? $cateData['id'] : 0;
            $param['pid'] = $cateData['parent_id']? $cateData['parent_id'] : $cateData['id'];
            $seo_title = str_replace('|',$cateData['catname'],$cateData['seo_title']);
            $seo_keywords = str_replace('|',$cateData['catname'],$cateData['seo_keywords']);
            $seo_desc = str_replace('|',$cateData['catname'],$cateData['seo_desc']);
            $this->assign('seo_title',$seo_title);
            $this->assign('seo_keywords',$seo_keywords);
            $this->assign('seo_desc',$seo_desc);
        }else{
            $param['sid'] = 0;
            $param['pid'] = 0;
        }
       //   echo $seo_title;die();

        if($param['pid']){
            $sonlist = Db::name('category')->where('parent_id',$param['pid'])->select();
        }else{
            $sonlist = Db::name('category')->where('parent_id','gt',0)->order('list_order')->limit(20)->select();
        }

        $param['pageType'] = 1;
        $result = JiamengService::getList($param);
        $page = $result->render();


        // 参数
        $touziarr = config('params.touziLevels');
        $areaList = config('params.areaList');
        $cateList = CategoryService::getCates();



        // 获取最新品牌
        $brandNews = JiamengService::getNewList(10);

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

        $result = $result? $result->toArray() : [];
        $lists = isset($result['data'])? $result['data'] : [];
        foreach ($lists as &$item){
            $touziLevel = isset($item['touzi_level']) ? $item['touzi_level'] : '-1';
            $item['touzi_level_name'] = isset($touziarr[$touziLevel]) ? $touziarr[$touziLevel] : '';
            $areaId = isset($item['area_id']) && $item['area_id']>0? intval($item['area_id']) : '-1';

            $item['area_name'] = isset($areaList[$areaId]) ? $areaList[$areaId] : '';
        }

        // 友情链接
        $links = [];
        if($enname){
            $links = LinkService::getList(['catname'=> $enname], 50);
        }

        //通过传入的参数获取中文
        $this->assign('dtite',$page);

       // var_dump($param);die();
        $this->assign('page',$page);
        $this->assign('data',$result);
        $this->assign('lists', $lists);
        $this->assign('paihang',$paihang);
        $this->assign('param',$param);

        $this->assign('brandNews',$brandNews);
        $this->assign('touziarr',$touziarr);
        $this->assign('areaList',$areaList);
        $this->assign('cateList',$cateList);
        $this->assign('sonlist',$sonlist);
        $this->assign('links',$links);
        return $this->fetch('list');
    }

    /**
     * 搜索
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
	public function search(){
		$param = $this->request->param();
		$result = JiamengService::getList($param);
		$page = $result->render();

        // 参数
        $touziarr = config('params.touziLevels');
        $areaList = config('params.areaList');
        $cateList = CategoryService::getCates();


		// 获取最新品牌
		$brandNews = JiamengService::getNewList(10);

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


        $param = [
            'kw'=> isset($param['kw'])? trim($param['kw']) : '',
            'enname'=> isset($param['enname'])? trim($param['enname']) : '',
            'catid'=> isset($param['catid'])? intval($param['catid']) : 0,
            'pcid'=> isset($param['pcid'])? intval($param['pcid']) : 0,
            'lv'=> isset($param['lv'])? intval($param['lv']) : '-1',
            'aid'=> isset($param['aid'])? intval($param['aid']) : 0,
        ];

        $result = $result? $result->toArray() : [];
        $lists = isset($result['data'])? $result['data'] : [];
        foreach ($lists as &$item){
            $touziLevel = isset($item['touzi_level']) ? $item['touzi_level'] : '-1';
            $areaId = isset($item['area_id']) ? $item['area_id'] : '-1';
            $item['touzi_level_name'] = isset($touziarr[$touziLevel]) ? $touziarr[$touziLevel] : '';
            $item['area_name'] = isset($areaList[$areaId]) && $item['area_id']>0? $areaList[$areaId] : '';
        }

        $enname = isset($param['enname'])? trim($param['enname']) : '';
        if($enname){
            $pcatid = Db::name('category')->where('enname', $enname)->value('id');
        }

        $pcid = isset($param['pcid']) ? intval($param['pcid']) : 0;
        $pcid = $pcid>0? $pcid : $pcatid;
        if($pcid){
            $cateData = Db::name('category')->where('id', $pcid)->find();
            $enname = isset($cateData['enname'])? $cateData['enname'] : '';
            $param['sid'] = $cateData['parent_id']? $cateData['id'] : 0;
            $param['pid'] = $cateData['parent_id']? $cateData['parent_id'] : $cateData['id'];
            $seo_title = str_replace('|',$cateData['catname'],$cateData['seo_title']);
            $seo_keywords = str_replace('|',$cateData['catname'],$cateData['seo_keywords']);
            $seo_desc = str_replace('|',$cateData['catname'],$cateData['seo_desc']);
            $this->assign('seo_title',$seo_title);
            $this->assign('seo_keywords',$seo_keywords);
            $this->assign('seo_desc',$seo_desc);
        }else{
            $param['sid'] = 0;
            $param['pid'] = 0;

        }

        if($param['pid']){
            $sonlist = Db::name('category')->where('parent_id',$param['pid'])->select();
        }else{
            $sonlist = Db::name('category')->where('parent_id','gt',0)->order('list_order')->limit(20)->select();
        }

        // 友情链接
        $links = [];
        if($enname){
            $links = LinkService::getList(['catname'=> $enname], 50);
        }

        $this->assign('page',$page);
        $this->assign('data',$result);
		$this->assign('lists', $lists);
		$this->assign('paihang',$paihang);
		$this->assign('param',$param);

        $this->assign('brandNews',$brandNews);
        $this->assign('touziarr',$touziarr);
        $this->assign('areaList',$areaList);
        $this->assign('cateList',$cateList);
        $this->assign('sonlist',$sonlist);
        $this->assign('links',$links);
		return $this->fetch();
	}

    /**
     * 详情
     * @return mixed
     * @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('需要id');
        $cacheKey = "cache:jiameng:show:id_".intval($param['id']);
        $datas = RedisService::get($cacheKey);
        $info = isset($datas['info'])? $datas['info'] : [];
        $touziarr = config('params.touziLevels');
        if(empty($info) || empty($datas)){
            $info = Db::name('jiameng')
                ->where('id',$param['id'])
                ->where('status', 1)
                ->find();
            if(empty($info)){
                header("Location:".url('/404'));
                exit;
            }
            //内容
            $content = Db::name('jiameng_data')->where('id',$param['id'])->find();
            $info['content'] = $content['content'];
            $info['youshi'] = $content['youshi'];
            $info['tiaojian'] = $content['tiaojian'];
            $info['liucheng'] = $content['liucheng'];
            $jmSupport = [];
            $supports = config('params.supports');
            $support = isset($info['jm_support']) && $info['jm_support']? explode(',', $info['jm_support']) : [];
            foreach ($support as $val){
                $name = isset($supports[$val])? $supports[$val] : '';
                if($name){
                    $jmSupport[] = $name;
                }
            }

            unset($supports[0]);
            $info['jm_support'] = $jmSupport? $jmSupport : $supports;
            $areaList = config('params.areaList');
            $areaId = isset($info['area_id']) && $info['area_id']? intval($info['area_id']) : '-1';
            $area = isset($areaList[$areaId])? $areaList[$areaId] : '不限';
            $info['area'] = $info['area']? $info['area'] : $area;

            $catinfo = Db::name('category')->where('id',$info['catid'])->find();

            $parinfo = Db::name('category')->where('id',$catinfo['parent_id'])->find();

            //热门行业
            $hot_cate = Db::name('category')->where('parent_id',$parinfo['id'])->order('list_order')->limit(12)->select();
            //排行
            $paihang = Db::name('jiameng')->field('id,title,logo,touzi_level,mendian,hits')->where('catid',$info['catid'])->where('status', 1)->order('hits desc')->limit(5)->select();
            //动态
            $about_news = Db::name('news')->field('id,title,thumb,create_time')->where(['ncatid'=>1,'status'=> 1])->order('id desc')->limit(6)->select();
            $brand_news = Db::name('news')->field('id,title,thumb,create_time')->where(['catid'=>$info['catid'],'status'=> 1])->order('id desc')->limit(6)->select();
            //热门加盟
            $hot_jm = Db::name('jiameng')->field('id,title,hits')->where('catid',$info['catid'])->where('status', 1)->order('hits desc')->limit(20)->select();
            //最新加盟
            $zx_jm = $brand8 = JiamengService::getNewList(20);
            //精选加盟
            $jx_jm = Db::name('jiameng')
                ->field('id,title')
                ->where('catid',$info['catid'])
                ->where('status', 1)
                ->orderRaw('rand()')->limit(20)->select();


            $datas = [
                'info'=> $info,
                'catinfo'=> $catinfo,
                'hot_jm'=> $hot_jm,
                'zx_jm'=> $zx_jm,
                'jx_jm'=> $jx_jm,
                'about_news'=> $about_news,
                'brand_news'=> $brand_news,
                'paihang'=> $paihang,
                'hot_cate'=> $hot_cate,
                'parinfo'=> $parinfo,
            ];

            // 缓存
            RedisService::set($cacheKey, $datas, 2*3600);
        }else{

            $catinfo = isset($datas['catinfo'])? $datas['catinfo'] : [];
            $hot_jm = isset($datas['hot_jm'])? $datas['hot_jm'] : [];
            $zx_jm = isset($datas['zx_jm'])? $datas['zx_jm'] : [];
            $jx_jm = isset($datas['jx_jm'])? $datas['jx_jm'] : [];
            $about_news = isset($datas['about_news'])? $datas['about_news'] : [];
            $brand_news = isset($datas['brand_news'])? $datas['brand_news'] : [];
            $paihang = isset($datas['paihang'])? $datas['paihang'] : [];
            $hot_cate = isset($datas['hot_cate'])? $datas['hot_cate'] : [];
            $parinfo = isset($datas['parinfo'])? $datas['parinfo'] : [];
        }


        //seo
        $seo_title = str_replace('|',$info['title'],$catinfo['seo_title']);
        $seo_keywords = str_replace('|',$info['title'],$catinfo['seo_keywords']);
        $seo_desc = trim(strip_tags($info['content']));
        $seo_desc = mb_substr($seo_desc,0,200,'utf8');


        $this->assign('seo_title',$seo_title);
        $this->assign('seo_keywords',$seo_keywords);
        $this->assign('seo_desc',$seo_desc);
        $this->assign('hot_jm',$hot_jm);
        $this->assign('zx_jm',$zx_jm);
        $this->assign('jx_jm',$jx_jm);
        $this->assign('about_news',$about_news);
        $this->assign('brand_news',$brand_news);
        $this->assign('paihang',$paihang);
        $this->assign('hot_cate',$hot_cate);
        $this->assign('touziarr',$touziarr);
        $this->assign('catinfo',$catinfo);
        $this->assign('parinfo',$parinfo);
        $this->assign('info',$info);
        return $this->fetch();
    }

    public function message(){
        $param = $this->request->param();
        $orignUrl = $this->request->header('origin');
        // isset($param['name'])&&$param['name']!='' or $this->error('请填写姓名');
        isset($param['mobile'])&&$param['mobile']!='' or $this->error('请填写手机号');
        $param['create_time'] = time();
        $param['ip'] = get_client_ip();
        $param['address'] = IpService::getAddress(get_client_ip());
        $todaytime = strtotime(date('Y-m-d'));
        if(strlen($param['content'])>300){
        	$this->error('字符长度不超过300个');
            exit;
        }

        if(isset($param['tzed']) && $param['tzed']<=0){
            $this->error('请选择投资额度');
            exit;
        }
        $param['content'] = strFilter($param['content']);
        $param['name'] = strFilter($param['name']);
        $param['mobile'] = strFilter($param['mobile']);
        $param['tzed'] = strFilter($param['tzed']);
        $param['area'] = strFilter($param['area']);
        $param['wechat'] = strFilter($param['wechat']);
        $param['type'] = 1;
        $param['source_url'] = $orignUrl;

        // print_r($param);exit;
        //判断是否已超过10次  今天这个ip是否留言过
       /* $sum = MessageService::getTodyCount(['ip'=> $param['ip'],'type'=> 1]);
        if($sum>0){
            $this->error('今日留言已超过1次，明天再来吧！');
        }
        //判断手机号本周内是否留过
		$sum = MessageService::getWeekCount(['mobile'=> $param['mobile'],'type'=> 1]);
        if($sum>0){
            $this->error('您的手机号在本周内已预留过，下周再来吧！');
        }*/
		 $week_time=time()-604800;

        $res_mobile=Db::name('message')->where('mobile',$param['mobile'])->where('create_time','>',$week_time)->find();
        if($res_mobile)
        {
            $this->error('手机号码一个周内只能留一次');
        }
        $ip=get_client_ip();
        $start_time=strtotime(date('Y-m-d') );
        $ip_count=Db::name('message')->where('ip',$ip)->where('create_time','>',$start_time)->count();
        if($ip_count>1)
        {
            $this->error('同一个ip一天只可以留言2次');
        }
        $res = Db::name('message')->insert($param);
        if($res){
            $this->success('咨询成功');
        }else{
            $this->error('咨询失败');
        }

    }
}
?>