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();
}
