NN2020042801/app/index/controller/JiamengController.php

<?php
namespace app\index\controller;
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 lists(){
        //二级分类
        $param = $this->request->param();
        isset($param['enname'])&&$param['enname']!='' or $param['enname']='项目库';
        $area_id = isset($param['area_id'])?$param['area_id']:0;
        $touzi_level = isset($param['touzi_level'])&&$param['touzi_level']!=''?$param['touzi_level']:-1;
        //所有的
        $catemap = array();
        if($param['enname']!='项目库'){
            $catemap['enname'] = $param['enname'];
        }
        $curarr = array();
        if($param['enname']!='项目库'){
            $curarr = Db::name('category')->where('enname',$param['enname'])->find();
            if(empty($curarr['id'])){
                $this->error('非法id');
            }
            //seo
            $seo_title = str_replace('|',$curarr['catname'],$curarr['seo_title']);
            $seo_keywords = str_replace('|',$curarr['catname'],$curarr['seo_keywords']);
            $seo_desc = str_replace('|',$curarr['catname'],$curarr['seo_desc']);
            $this->assign('seo_title',$seo_title);
            $this->assign('seo_keywords',$seo_keywords);
            $this->assign('seo_desc',$seo_desc);
        }else{
            $curarr['parent_id'] = 0;
            $curarr['id'] = 0;
            $curarr['enname'] = '项目库';
            $curarr['catname'] = '项目库';

        }
        //所有的父分类
        $parlist = Db::name('category')->where('parent_id',0)->order('list_order')->select();
        // $query = array(
        //     'touzi_level' => $touzi_level
        // );
        $query  = array();
        $burl = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
        
        
        
        if($param['enname']!='项目库'){
            if($curarr['parent_id']>0){
                //点击子分类
                $par_id = $curarr['parent_id'];
                $son_id = $curarr['id'];
                $map = array();
                if($param['enname']!='all'){
                    $map['catid'] = $curarr['id'];
                }
                if($area_id>0){
                	$map['area_id'] = $area_id;
                }
                if($touzi_level>=0){
                    $map['touzi_level'] = $touzi_level;
                }
                
                $lists = Db::name('jiameng')->field("id,title,mendian,catid,touzi,touzi_level,company,address,thumb,product,area")->where($map)->order('list_order')->paginate(20,false,['path'=>$burl,'query'=>$query]);   
                $sum =  Db::name('jiameng')->where($map)->count();
                //加盟排行
                $paihang = Db::name('jiameng')->field('id,title,thumb,hits')->where($map)->order('hits desc')->limit(30)->select();
            }else{
                //点击父分类
                $par_id = $curarr['id'];
                $son_id = 0;
                
                $sonarr = Db::name('category')->where('parent_id',$par_id)->select();
                $sonlist = array();
                foreach($sonarr as $k=>$v){
                    $sonlist[] = $v['id'];
                }
                $map = array();
                if($touzi_level>=0){
                    $map['touzi_level'] = $touzi_level;
                }
                if($area_id>0){
                	$map['area_id'] = $area_id;
                }
                $lists = Db::name('jiameng')->field("id,title,mendian,catid,touzi,touzi_level,company,address,thumb,product,area")->where('catid','in',$sonlist)->where($map)->order('list_order')->paginate(20,false,['path'=>$burl,'query'=>$query]);
                $sum = Db::name('jiameng')->where('catid','in',$sonlist)->where($map)->count();
                //加盟排行
                $paihang = Db::name('jiameng')->field('id,title,thumb,hits')->where('catid','in',$sonlist)->where($map)->order('hits desc')->limit(30)->select();
            }
            $sonlist = Db::name('category')->where('parent_id',$par_id)->select();
        }else{
           
            //点击子分类
            $par_id = $curarr['parent_id'];
            $son_id = $curarr['id'];
            $map = array();
        	//是否有关键词搜索
        	$keyword = isset($param['keyword'])?$param['keyword']:'';
        	if($keyword!=''){
        		$map[] = ['title','like','%'.$keyword.'%'];
        	}
            
            if($touzi_level>=0){
                $map['touzi_level'] = $touzi_level;
            }
            if($area_id>0){
                $map['area_id'] = $area_id;
            }
            $lists = Db::name('jiameng')->field("id,title,mendian,catid,touzi,touzi_level,company,address,thumb,product,area")->where($map)->order('list_order')->paginate(20,false,['query'=>$query]);   
            $sum =  Db::name('jiameng')->where($map)->count();
            //加盟排行
            $paihang = Db::name('jiameng')->field('id,title,thumb,hits')->where($map)->order('hits desc')->limit(30)->select();
            
            $sonlist = Db::name('category')->where('parent_id','gt',0)->order('list_order')->limit(20)->select();
            
        }
        
        $touziarr = array(
            '1万元以下',
            '1～5万元',
            '5～10万元',
            '10～20万元',
            '20～50万元',
            '50～100万元',
            '100万元以上',
            '200万元以上',
            '300万元以上'
        );
        $area_list = array('不限','北京','天津','上海','广州','重庆','浙江','江苏','广东','山东','山西','福建','安徽','河北','河南','湖北','湖南','吉林','江西','辽宁','四川','云南','陕西','广西','海南','贵州','黑龙江','内蒙古','宁夏','甘肃','西藏','青海','新疆');
        //9级品牌
        $map9 = array();
        $map9['level'] = 9;
        if($curarr['id']){
        	if($curarr['parent_id']>0){
        		//子分类
        		$map9['catid'] = $curarr['id'];
        	}else{
        		//父分类
        		$map9['pcatid'] = $curarr['id'];
        	}
        	
        }
        $brand9 = Db::name('jiameng')->field('id,guanggaowei,title')->where($map9)->limit(1)->find();
        //最新加盟资讯
        $zxnews = Db::name('news')->field('id,title,create_time')->order('id desc')->limit(10)->select();
        $link_cate_name = $curarr['enname'];
        $this->assign('link_cate_name',$link_cate_name);
        $this->assign('zxnews',$zxnews);
        $this->assign('brand9',$brand9);
        $this->assign('area_list',$area_list);
        $this->assign('touziarr',$touziarr);
        $this->assign('curarr',$curarr);
        $this->assign('parlist',$parlist);
        $this->assign('sonlist',$sonlist);
        $this->assign('par_id',$par_id);
        $this->assign('son_id',$son_id);
        $this->assign('lists',$lists);
        $this->assign('touzi_level',$touzi_level);
        $this->assign('sum',$sum);
        $this->assign('paihang',$paihang);
        $this->assign('area_id',$area_id);
        return $this->fetch();
    }
	//搜索
	public function search(){
		$param = $this->request->param();
		$kw = $param['kw'];
		$lists = Db::name('jiameng')->field("id,title,mendian,catid,touzi,touzi_level,company,address,thumb,product,area")->where('title','like',"%".$kw."%")->order('list_order')->paginate(20);   
		//加盟排行
        $paihang = Db::name('jiameng')->field('id,title,thumb,hits')->where($map)->order('hits desc')->limit(30)->select();
        $sum =  Db::name('jiameng')->where('title','like',"%".$kw."%")->count();
        $this->assign('sum',$sum);
		$this->assign('lists',$lists);
		$this->assign('paihang',$paihang);
		$touziarr = array(
            '1万元以下',
            '1～5万元',
            '5～10万元',
            '10～20万元',
            '20～50万元',
            '50～100万元',
            '100万元以上',
            '200万元以上',
            '300万元以上'
        );
        
        $this->assign('touziarr',$touziarr);
		return $this->fetch();
	}
	
	
    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'];
        $catinfo = Db::name('category')->where('id',$info['catid'])->find();
        
        $parinfo = Db::name('category')->where('id',$catinfo['parent_id'])->find();
        $touziarr = array(
            '1万元以下',
            '1～5万元',
            '5～10万元',
            '10～20万元',
            '20～50万元',
            '50～100万元',
            '100万元以上',
            '200万元以上',
            '300万元以上'
        );
        //热门行业
        $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')->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')->where('catid',$info['catid'])->order('hits desc')->limit(20)->select();
        //最新加盟
        $zx_jm = Db::name('jiameng')->field('id,title')->where('catid',$info['catid'])->order('create_time desc')->limit(20)->select();
        //精选加盟
        $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();
        $todaytime = strtotime(date('Y-m-d'));
        if(strlen($param['content'])>300){
        	$this->error('字符长度不超过300个');
        }
        $param['content'] = $this->strFilter($param['content']);
        $param['name'] = $this->strFilter($param['name']);
        $param['mobile'] = $this->strFilter($param['mobile']);
        $param['tzed'] = $this->strFilter($param['tzed']);
        $param['area'] = $this->strFilter($param['area']);
        // print_r($param);exit;
        //判断是否已超过10次  今天这个ip是否留言过
        $sum = Db::name('message')->where('ip',$param['ip'])->where('create_time','gt',$todaytime)->count();
        if($sum>0){
            $this->error('今日留言已超过1次，明天再来吧！');
        }
        //判断手机号本周内是否留过
        // 当前日期
		$sdefaultDate = date("Y-m-d");
		// $first =1 表示每周星期一为开始日期 0表示每周日为开始日期
		$first=1;
		// 获取当前周的第几天 周日是0 周一到周六是 1 - 6
		$w = date('w', strtotime($sdefaultDate));
		// 获取本周开始日期，如果$w是0，则表示周日，减去 6 天
		$week_start=strtotime("$sdefaultDate -".($w ? $w - $first : 6).' days');
		$sum = Db::name('message')->where('mobile',$param['mobile'])->where('create_time','gt',$week_start)->count();
        if($sum>0){
            $this->error('您的手机号在本周内已预留过，下周再来吧！');
        }
        $res = Db::name('message')->insert($param);
        if($res){
            $this->success('咨询成功');
        }else{
            $this->error('咨询失败');
        }

    }
    public function strFilter($str){
	    $str = str_replace('`', '', $str);
	    $str = str_replace('·', '', $str);
	    $str = str_replace('~', '', $str);
	    $str = str_replace('!', '', $str);
	    $str = str_replace('！', '', $str);
	    $str = str_replace('@', '', $str);
	    $str = str_replace('#', '', $str);
	    $str = str_replace('$', '', $str);
	    $str = str_replace('￥', '', $str);
	    $str = str_replace('%', '', $str);
	    $str = str_replace('^', '', $str);
	    $str = str_replace('……', '', $str);
	    $str = str_replace('&', '', $str);
	    $str = str_replace('*', '', $str);
	    $str = str_replace('(', '', $str);
	    $str = str_replace(')', '', $str);
	    $str = str_replace('（', '', $str);
	    $str = str_replace('）', '', $str);
	    $str = str_replace('-', '', $str);
	    $str = str_replace('_', '', $str);
	    $str = str_replace('——', '', $str);
	    $str = str_replace('+', '', $str);
	    $str = str_replace('=', '', $str);
	    $str = str_replace('|', '', $str);
	    $str = str_replace('\\', '', $str);
	    $str = str_replace('[', '', $str);
	    $str = str_replace(']', '', $str);
	    $str = str_replace('【', '', $str);
	    $str = str_replace('】', '', $str);
	    $str = str_replace('{', '', $str);
	    $str = str_replace('}', '', $str);
	    $str = str_replace(';', '', $str);
	    $str = str_replace('；', '', $str);
	    $str = str_replace(':', '', $str);
	    $str = str_replace('：', '', $str);
	    $str = str_replace('\'', '', $str);
	    $str = str_replace('"', '', $str);
	    $str = str_replace('“', '', $str);
	    $str = str_replace('”', '', $str);
	    $str = str_replace(',', '', $str);
	    $str = str_replace('，', '', $str);
	    $str = str_replace('<', '', $str);
	    $str = str_replace('>', '', $str);
	    $str = str_replace('《', '', $str);
	    $str = str_replace('》', '', $str);
	    $str = str_replace('.', '', $str);
	    $str = str_replace('。', '', $str);
	    $str = str_replace('/', '', $str);
	    $str = str_replace('、', '', $str);
	    $str = str_replace('?', '', $str);
	    $str = str_replace('？', '', $str);
	    return trim($str);
	}
}
?>