thinkphp 3.2.3按今天，本周，本月，本季度，本年，全部查询

 /*
*按今天，本周，本月，本季度，本年，全部查询预约单数据
* $day 代表查询条件 $cid 代表 公司id
*返回array $data 查询条件 数组
*/

    public function find_createtime($day,$cid){
//查询当天数据
        if($day==1){
            $today=strtotime(date('Y-m-d 00:00:00'));
            $data['cid']=$cid;
            $data['createtime'] = array('egt',$today);
            return $data;
//查询本周数据
        }else if($day==2){
            $arr=array();
            $arr=getdate();
            $num=$arr['wday'];
            $start=time()-($num-1)*24*60*60;
            $end=time()+(7-$num)*24*60*60;
            $data['cid']=$cid;
            $data['createtime'] = array('between',array($start,$end));
            return $data;
//查询本月数据
        }else if($day==3){
            $start=strtotime(date('Y-m-01 00:00:00'));
            $end = strtotime(date('Y-m-d H:i:s'));
            $data['cid']=$cid;
            $data['createtime'] = array('between',array($start,$end));
            return $data;
        }
//查询上一月数据
        else if($day==6){

            $start =mktime(0,0,0,date('m')-1,1,date('Y'));//上月初第一天
            $end=mktime(0,0,0,date('m'),1,date('Y'))-24*3600;//上月初第二天

            $data['cid']=$cid;
            $data['createtime'] = array('between',array($start,$end));
            return $data;
//查询本季度数据
        }else if($day==4){
            $month=date('m');
            if($month==1 || $month==2 ||$month==3){
                $start=strtotime(date('Y-01-01 00:00:00'));
                $end=strtotime(date("Y-03-31 23:59:59"));
            }elseif($month==4 || $month==5 ||$month==6){
                $start=strtotime(date('Y-04-01 00:00:00'));
                $end=strtotime(date("Y-06-30 23:59:59"));
            }elseif($month==7 || $month==8 ||$month==9){
                $start=strtotime(date('Y-07-01 00:00:00'));
                $end=strtotime(date("Y-09-30 23:59:59"));
            }else{
                $start=strtotime(date('Y-10-01 00:00:00'));
                $end=strtotime(date("Y-12-31 23:59:59"));
            }
            $data['cid']=$cid;
            $data['createtime'] = array('between',array($start,$end));
            return $data;
//查询本年度数据
        }else if($day==5){
            $year=strtotime(date('Y-01-01 00:00:00'));
            $data['cid']=$cid;
            $data['createtime'] = array('egt',$year);
            return $data;
//全部数据
        }else{
            $data['cid']=$cid;
            return $data;
        }
    }

指定月份查询数据

/*
*查询指定月分的sql数据
* $mouth 月份 数字
*返回array $data 查询条件 数组
*/

function find_sql_mouth($mouth){

    $start =mktime(0,0,0,$mouth,1,date('Y'));//上月初第一天
    $end=mktime(0,0,0,$mouth+1,1,date('Y'))-24*3600;//上月初第二天
    $data = array('between',array($start,$end));
    return $data;

}