<?php

/*

*按今天，本周，本月，本季度，本年，全部查询预约单数据

* $day 代表查询条件 $cid 代表 公司id

*返回array $data 查询条件 数组

*/

class ReserveModel extends BaseModel {

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;

}

}

}

?>