企业官网建设流程全解析

博客社区类网站模板,免费手游代理平台,wordpress 摄影 主题,房地产网站建设联系方式统计每天的用户注册数。与其每次都去扫描用户表#xff0c;不如每天凌晨跑个定时任务#xff0c;把结果算好存起来 数据库 user表用户统计数据聚合表定时任务 XxlJob(dailyUserStatic)public void dailyUserStatic() {log.info(xxl-job dailyUserStatic不如每天凌晨跑个定时任务把结果算好存起来数据库user表用户统计数据聚合表定时任务XxlJob(dailyUserStatic)publicvoiddailyUserStatic(){log.info(xxl-job dailyUserStatic);IntegernewUserCountuserService.newUserCount();IntegeractiveUserCountuserService.activeUserCount();UserDailyStaticuserDailyStaticnewUserDailyStatic();userDailyStatic.setStatDate(LocalDate.now().minusDays(1));userDailyStatic.setActiveUserCount(activeUserCount);userDailyStatic.setNewUserCount(newUserCount);userDailyStaticService.save(userDailyStatic);}sqlnewUserCountselect idnewUserCountSELECTcount(1)AS new_user_count FROM userWHEREDATE(create_time)DATE(DATE_SUB(CURDATE(),INTERVAL1DAY))GROUPBYDATE(create_time)/selectactiveUserCountselect idactiveUserCountresultTypejava.lang.IntegerSELECTcount(1)AS active_user_count FROM userWHEREDATE(login_time)DATE(DATE_SUB(CURDATE(),INTERVAL1DAY))GROUPBYDATE(login_time)/select