业务数据聚合分析 xxl-job定时任务

统计每天的用户注册数。与其每次都去扫描用户表，不如每天凌晨跑个定时任务，把结果算好存起来

数据库
user表

用户统计数据聚合表

定时任务

@XxlJob("dailyUserStatic")publicvoiddailyUserStatic(){log.info("xxl-job dailyUserStatic");IntegernewUserCount=userService.newUserCount();IntegeractiveUserCount=userService.activeUserCount();UserDailyStaticuserDailyStatic=newUserDailyStatic();userDailyStatic.setStatDate(LocalDate.now().minusDays(1));userDailyStatic.setActiveUserCount(activeUserCount);userDailyStatic.setNewUserCount(newUserCount);userDailyStaticService.save(userDailyStatic);}

sql
newUserCount

<select id="newUserCount">SELECTcount(1)AS new_user_count FROM `user`WHEREDATE(create_time)=DATE(DATE_SUB(CURDATE(),INTERVAL1DAY))GROUPBYDATE(create_time)</select>

activeUserCount

<select id="activeUserCount"resultType="java.lang.Integer">SELECTcount(1)AS active_user_count FROM `user`WHEREDATE(login_time)=DATE(DATE_SUB(CURDATE(),INTERVAL1DAY))GROUPBYDATE(login_time)</select>