ThinkPHP5 获取前一天每小时的消费情况

获取前一天每小时的消费情况

$begin_time = mktime(0,0,0,date('m'),date('d')-1,date('Y')) . '000';//13位的时间戳
		 
$end_time = mktime(0,0,0,date('m'),date('d'),date('Y'))-1 . '000'; 
 //方法一
return  $this->field("FROM_UNIXTIME(start_time/1000,'%H') AS Hour,sum(cost) as total")->where("from_unixtime(start_time/1000, '%Y-%m-%d')",'=',$time)->group("FROM_UNIXTIME(start_time/1000,'%H')")->order("FROM_UNIXTIME(start_time/1000,'%H')")->select();
//方法二
$res = Db::query("SELECT FROM_UNIXTIME(start_time/1000,'%H') AS Hour,sum(cost) as total  FROM 表名  WHERE from_unixtime(start_time/1000, '%Y-%m-%d') = ?   GROUP BY FROM_UNIXTIME(start_time/1000,'%H') ORDER BY FROM_UNIXTIME(start_time/1000,'%H')",[$time]);
return $res;