您当前的位置: 首页 >  搜索

暂无认证

  • 1浏览

    0关注

    92582博文

    0收益

  • 0浏览

    0点赞

    0打赏

    0留言

私信
关注
热门博文

layui时间区间搜索功能 如何锁定 开始时间 结束时间 的可选范围

发布时间:2018-09-12 18:46:13 ,浏览量:1

1.示例图:

代码:

活动时间

2.当设置了start_time以后,end_time肯定要大于start_time,否则要设置为不可选,

当设置了end_time以后,start_time肯定要小于start_time,否则要设置为不可选,

3.具体操作如下:复制以下代码即可


		

控制器调用例子:

public function keywords_count(){
        $condition1 =strtotime(input('start_time'));
        $condition2 = strtotime(input('end_time'));
//        var_dump($condition1);
        $condition = input('condition');
        $where='';
        if($condition){
//            $where['keyword']=$condition;
            $where['keyword']=array('like','%'.$condition.'%');
        }
        if($condition1&&$condition2) {
            $where['create_time'] = array(array('egt', $condition1), array('elt', $condition2), 'AND');
        }
        if($where){
            $gust = db('keywords')->where($where)->field('id,keyword,create_time,count(*) as count')->group("keyword")->order("count desc")->select();
            $gustcount = db('keywords')->where($where)->field('id,keyword,create_time,count(*) as count')->count();
        }else{
            $gust = db('keywords')->field('id,keyword,create_time,count(*) as count')->group("keyword")->order("count desc")->select();
            $gustcount = db('keywords')->field('id,keyword,create_time,count(*) as count')->count();
//            $gust = db('keywords')->order('id DESC')->select();
        }
        $this->assign('condition1',$condition1);
        $this->assign('condition2',$condition2);
        $this->assign('condition',$condition);
        $this->assign('gust',$gust);
        $this->assign('gustcount',$gustcount);
        return view();
    }
关注
打赏
1653961664
查看更多评论
立即登录/注册

微信扫码登录

0.3479s