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 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){
            $this->error('不是一级分类');
        }
        $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();
        $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();
            $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();
        }

        $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('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');
        $info = Db::name('jiameng')
            ->where('id',$param['id'])
            ->find();
        //内容
        $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();
        $touziarr = config('params.touziLevels');

        //热门行业
        $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'])->order('hits desc')->limit(5)->select();
        //动态
        $about_news = Db::name('news')->field('id,title,thumb,create_time')->where('ncatid',1)->order('id desc')->limit(6)->select();
        $brand_news = Db::name('news')->field('id,title,create_time')->where('catid',$info['catid'])->order('id desc')->limit(6)->select();
        //热门加盟
        $hot_jm = Db::name('jiameng')->field('id,title,hits')->where('catid',$info['catid'])->order('hits desc')->limit(20)->select();
        //最新加盟
        $zx_jm = $brand8 = JiamengService::getNewList(20);
        //精选加盟
        $jx_jm = Db::name('jiameng')->field('id,title')->where('catid',$info['catid'])->orderRaw('rand()')->limit(20)->select();
        //seo
        $seo_title = str_replace('|',$info['title'],$catinfo['seo_title']);
        $seo_keywords = str_replace('|',$info['title'],$catinfo['seo_keywords']);
        $seo_desc = mb_substr($info['content'],0,200,'utf8');
        $seo_desc = strip_tags($seo_desc);
        $link_cate_name = $parinfo['enname'];
	    // $this->assign('link_cate_name',$link_cate_name);
        $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();
        // 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个');
        }

        if(isset($param['tzed']) && $param['tzed']<=0){
            $this->error('请选择投资额度');
        }
        $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;

        // 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('咨询失败');
        }

    }
}
?>