时间范围、1、今天 2、明天 3、本周末 4、本周 5、下周 6、本月 7、下个月
function get_time_range($type)
{
$where = [];
//今天
if($type == 1){
$start_time=mktime(0,0,0,date('m'),date('d'),date('Y'));
$end_time=mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1;
$where['dateTime'] = [date("Y-m-d H:i:s",$start_time),date("Y-m-d H:i:s",$end_time)];
}
//明天
if($type == 2){
$start_time=mktime(0,0,0,date('m'),date('d')+1,date('Y'));
$end_time=mktime(0,0,0,date('m'),date('d')+2,date('Y'))-1;
$where['dateTime'] = [date("Y-m-d H:i:s",$start_time),date("Y-m-d H:i:s",$end_time)];
}
//昨天
if($type == 3){
$start_time=mktime(0,0,0,date('m'),date('d')-1,date('Y'));
$end_time=mktime(0,0,0,date('m'),date('d'),date('Y'))-1;
$where['dateTime'] = [date("Y-m-d H:i:s",$start_time),date("Y-m-d H:i:s",$end_time)];
}
//过去7天
if($type == 4){
$start_time = mktime(0,0,0,date('m'),date('d')-7,date('Y'));
$end_time = mktime(0,0,0,date('m'),date('d'),date('Y'))-1;
$where['dateTime'] = [date("Y-m-d H:i:s",$start_time),date("Y-m-d H:i:s",$end_time)];
}
//本周
if($type == 5){
$start_time=mktime(0, 0, 0, date('m'), (date('d') - (date('w')>0 ? date('w') : 7) + 1), date('Y'));
$end_time=mktime(0, 0, 0, date('m'), (date('d') - (date('w')>0 ? date('w') : 7) + 8), date('Y'))-1;
$where['dateTime'] = [date("Y-m-d H:i:s",$start_time),date("Y-m-d H:i:s",$end_time)];
}
//下周
if($type == 6){
$start_time=mktime(0, 0, 0, date('m'), (date('d') - (date('w')>0 ? date('w') : 7) + 8), date('Y'));
$end_time=mktime(0, 0, 0, date('m'), (date('d') - (date('w')>0 ? date('w') : 7) + 15), date('Y'))-1;
$where['dateTime'] = [date("Y-m-d H:i:s",$start_time),date("Y-m-d H:i:s",$end_time)];
}
//本月
if($type == 7){
$start_time=mktime(0,0,0,date('m'),1,date('Y'));
$end_time=mktime(23,59,59,date('m'),date('t'),date('Y'));
$where['dateTime'] = [date("Y-m-d H:i:s",$start_time),date("Y-m-d H:i:s",$end_time)];
}
//过去30天
if($type == 8){
$start_time = mktime(0,0,0,date('m'),date('d')-30,date('Y'));
$end_time = mktime(0,0,0,date('m'),date('d'),date('Y'))-1;
$where['dateTime'] = [date("Y-m-d H:i:s",$start_time),date("Y-m-d H:i:s",$end_time)];
}
//上个月
if($type == 7){
$start_time = mktime(0, 0 , 0,date("m")-1,1,date("Y"));
$end_time = mktime(23,59,59,date("m") ,0,date("Y"));
$where['dateTime'] = [date("Y-m-d H:i:s",$start_time),date("Y-m-d H:i:s",$end_time)];
}
//下个月
if($type == 9){
$start_time=mktime(23,59,59,date('m'),date('t'),date('Y'))+1;
$end_time=mktime(23,59,59,date('m')+1,date('t')-1,date('Y'));
$where['dateTime'] = [date("Y-m-d H:i:s",$start_time),date("Y-m-d H:i:s",$end_time)];
}
return $where;
}
直接调用和方法获取开始时间结束时间即可使用