tp5查询两条数据,tp5 财务系统

//当天数据$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));$endToday=mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1;$map['create_time'] = array('between', array($beginToday,$endToday));//昨天数据 $beginYesterday=mktime(0,0,0,date('m'),date('d')-1,date('Y'));$endYesterday=mktime(0,0,0,date('m'),date('d'),date('Y'))-1;$map['create_time'] = array('between', array($beginYesterday,$endYesterday));//按日期和分类分组查询 //create_time 字段在数据库里为时间戳$list = M('user')->where($map) ->field("DATE_FORMAT(FROM_UNIXTIME(create_time),'%Y-%m-%d') as date,count(*) as total,type") ->group("DATE_FORMAT(FROM_UNIXTIME(create_time),'%Y-%m-%d'),type") ->select();$list = array_reverse($list);//ip地落寞的导师滤$distinct_click_ip_list = M('user') ->where(array('type'=>1)) ->field("DATE_FORMAT(FROM_UNIXTIME(create_time),'%Y-%m-%d') as date,count(distinct create_ip) as distinct_total,type") ->group("DATE_FORMAT(FROM_UNIXTIME(create_time),'%Y-%m-%d'),type") ->select();