1. 数据查询 ,
CancelTimeDate是通过获取器获取的Y-m-d格式的cancel_time
{
$order_data = Orders::where("order_status",7)
->append(["CancelTimeDate"])
->field("count(id) num ,cancel_time")
->whereTime("cancel_time",[$start ,$end])
->group("FROM_UNIXTIME(cancel_time,'%Y-%m-%d')")->select()->toArray();
$order_maintenance_data = \app\common\model\OrdersMaintenance::where("order_status",7)
->field("count(id) num ,cancel_time")
->append(["CancelTimeDate"])
->whereTime("cancel_time",[$start ,$end])
->group("FROM_UNIXTIME(cancel_time,'%Y-%m-%d')")->select()->toArray();
$order_scooter_data = \app\common\model\OrdersScooter::where("order_status",7)
->