获取config
select * from sys_job_config where jobId=SUMMARY_JOB and lastUpdateStatus=createDay
来源
select * from t_tenant where delFlag='0' and left(createDate,10)<= createDay(config.LastUpdateTime)
LoginNum
SELECT count(id) FROM log_device_login where createDay=createDay and tenantId=?
PlayNum
select count(*) from (SELECT deviceId,startTime,resourceId FROM log_device_event where eventCode=? and (case when left(startTime,10)=? then left(startTime,10) when (left(startTime,4)>2030 or left(startTime,4)<2018) then createDay else left(startTime,10) end)=? and tenantId=? group by deviceId,startTime,resourceId)b
PlayDeviceNum
select count(distinct deviceId) from log_device_play where createDay=? and tenantId=?
RoomNum
select count(DISTINCT CONCAT(tenantId,roomId)) from t_tenant_device_user where delFlag='0' and tenantId=?
DeviceNum
select count(DISTINCT CONCAT(tenantId,deviceId)) from t_tenant_device_user where delFlag="0" and tenantId=?
orderNum, unpaidNum, paidNum, shippedNum, sumPrice
select * from log_device_orders where createDay=? and tenantId=?
更新
insert log_device_summary_day
