class VoteCountJob {

    @Scheduled(cron = "00 00 23 * * ?")
    public void executeVoteCount() {

        System.err.println("begin to start Job");
        List<RunningRecordWithInfo> runningRecordWithInfos = runningRecordMapper.selectRunningRecordWithInfoScoreIn24hours();

        List<MailBean> mailBeanList = new ArrayList();
        for (RunningRecordWithInfo runningRecordWithInfo : runningRecordWithInfos) {
            System.out.println(runningRecordWithInfo);

            MailBean mailBean = new MailBean();
            mailBean.setDistance(runningRecordWithInfo.getDistance());
            mailBean.setUsername(runningRecordWithInfo.getUsername());
            mailBean.setCreationTime(DateUtils.parseForFrontEnd2(runningRecordWithInfo.getCreationTime()));


            RunningRecord runningRecord = runningRecordWithInfo;
            runningRecord.setScore(runningRecordWithInfo.getFinalScore());
            if (runningRecord.getScore() == null) {
                runningRecord.setStatus(1);
                mailBean.setStatus("Expired");
            } else if (runningRecord.getScore() <= 0) {
                runningRecord.setStatus(2);
                mailBean.setStatus("Rejected");
            } else if (runningRecord.getScore() > 0) {
                runningRecord.setStatus(3);
                mailBean.setStatus("Passed");
                mailBean.setEarnedCoins(runningRecordWithInfo.getEarnedCoins());
            }

            mailBeanList.add(mailBean);
            runningRecordMapper.updateByPrimaryKey(runningRecord);
        }


        mostVotedJob.insertDailyVotedCount();


        List<DailyVotedCountVo> dailyVotedCountVos = mostVotedRecordMapper.selectByVotedDate(new Date());

        dailyVotedCountVos.stream().sorted((Comparator.comparing(DailyVotedCountVo::getVotedDate)));

        ThisLocalizedWeek thisLocalizedWeek = new ThisLocalizedWeek(Locale.CHINA);
        List<WeeklyAwardedReportVo> weeklyAwardedReportVos = dailyMostVotedRecordMapper.selectWeeklyAwardedRecord(thisLocalizedWeek.getFirstDay(), thisLocalizedWeek.getLastDay());

        List<UserInfoBatchBean> userInfoBatchBeans = userInfoMapper.selectUserTotalInfo();
        for (UserInfoBatchBean userInfoBatchBean : userInfoBatchBeans) {
            UserInfo userInfo = userInfoMapper.selectByOpenId(userInfoBatchBean.getUserOpenId());
            userInfo.setTotalDistance(userInfoBatchBean.getTotalDistance());
            userInfo.setCoins(userInfoBatchBean.getTotalCoins());
            userInfoMapper.updateByPrimaryKey(userInfo);
        }
        List<UserInfo> userInfos = userInfoMapper.selectAllUser();
        try {
            mailService.sendMessageMail(mailBeanList,userInfos,dailyVotedCountVos,weeklyAwardedReportVos, "RunningClub Report", "message.ftl");
        }catch (Exception e){
            e.printStackTrace();
        }
        System.err.println("send email finished");
    }

}