1、查询数据库订单数据
/*
*按今天,本周,本月,本季度,本年,全部查询预约单数据
* $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==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;
}
}
2、单纯输出
<?php
//今天
$today = date("Y-m-d");
//昨天
$yesterday = date("Y-m-d", strtotime(date("Y-m-d"))-86400);
//上周
$lastweek_start = date("Y-m-d H:i:s",mktime(0, 0 , 0,date("m"),date("d")-date("w")+1-7,date("Y")));
$lastweek_end = date("Y-m-d H:i:s",mktime(23,59,59,date("m"),date("d")-date("w")+7-7,date("Y")));
//本周
$thisweek_start = date("Y-m-d H:i:s",mktime(0, 0 , 0,date("m"),date("d")-date("w")+1,date("Y")));
$thisweek_end = date("Y-m-d H:i:s",mktime(23,59,59,date("m"),date("d")-date("w")+7,date("Y")));
//上月
$lastmonth_start = date("Y-m-d H:i:s",mktime(0, 0 , 0,date("m")-1,1,date("Y")));
$lastmonth_end = date("Y-m-d H:i:s",mktime(23,59,59,date("m") ,0,date("Y")));
//本月
$thismonth_start = date("Y-m-d H:i:s",mktime(0, 0 , 0,date("m"),1,date("Y")));
$thismonth_end = date("Y-m-d H:i:s",mktime(23,59,59,date("m"),date("t"),date("Y")));
//本季度未最后一月天数
$getMonthDays = date("t",mktime(0, 0 , 0,date('n')+(date('n')-1)%3,1,date("Y")));
//本季度/
$thisquarter_start = date('Y-m-d H:i:s', mktime(0, 0, 0,date('n')-(date('n')-1)%3,1,date('Y')));
$thisquarter_end = date('Y-m-d H:i:s', mktime(23,59,59,date('n')+(date('n')-1)%3,$getMonthDays,date('Y')));
//2016-08-10这天 2个月后的日期
echo date("Y-m-d",strtotime("+2 month",strtotime("2016-08-10")));
//当前 3个月后的日期
3、组合方法使用
/**
* 方法名 :time_slot
* 作 用 :时间段(本日,昨日,本周,上周,本月,上月)
* @param :
* @return: 返回时间段
* @author:
* @date :2016/7/14
*/
function time_slot(){
$time['today']['begin'] = mktime(0,0,0,date('m'),date('d'),date('Y'));
$time['today']['end'] = mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1;
$time['tomorrow']['begin'] = mktime(0,0,0,date('m'),date('d')-1,date('Y'));
$time['tomorrow']['end'] = mktime(0,0,0,date('m'),date('d'),date('Y'))-1;
$time['week']['begin'] = mktime(0, 0 , 0,date("m"),date("d")-date("w")+1,date("Y"));
$time['week']['end'] = mktime(23,59,59,date("m"),date("d")-date("w")+7,date("Y"));
$time['lastweek']['begin'] = mktime(0,0,0,date('m'),date('d')-date('w')+1-7,date('Y'));
$time['lastweek']['end'] = mktime(23,59,59,date('m'),date('d')-date('w')+7-7,date('Y'));
$time['month']['begin'] = mktime(0,0,0,date('m'),1,date('Y'));
$time['month']['end'] = mktime(23,59,59,date('m'),date('t'),date('Y'));
$time['lastmonth']['begin'] = mktime(0, 0 , 0,date("m")-1,1,date("Y"));
$time['lastmonth']['end'] = mktime(23,59,59,date("m") ,0,date("Y"));
//返回时间段
return $time;
}
最新评论