企业官网建设流程全解析

朝阳专业网站建设,前端为啥不用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