| | |
| | | |
| | | Long selectRegisterCount(); |
| | | |
| | | Long selectStudyCount(); |
| | | |
| | | List<VideoAndAreaVO> areaCount(); |
| | | |
| | | List<DelayDO> selectDelayVOList(); |
| | |
| | | HashMap<String, Object> map = new HashMap<>(); |
| | | Long review = baseCaseMapper.selectCount(new LambdaQueryWrapper<BaseCase>().eq(BaseCase::getState, 1)); |
| | | Long register = baseCaseMapper.selectRegisterCount(); |
| | | Long study = baseCaseMapper.selectCount(new LambdaQueryWrapper<BaseCase>().eq(BaseCase::getState, 3)); |
| | | Long study = baseCaseMapper.selectStudyCount(); |
| | | map.put("review", review); |
| | | map.put("register", register); |
| | | map.put("study", study); |
| | |
| | | and to_days(create_time) = TO_DAYS(now()); |
| | | </select> |
| | | |
| | | <select id="selectStudyCount" resultType="java.lang.Long"> |
| | | select count(1) |
| | | from ums_base_case |
| | | where state =3 |
| | | and to_days(create_time) = TO_DAYS(now()); |
| | | </select> |
| | | |
| | | <select id="dayCount" resultType="java.lang.Integer"> |
| | | select count(1) |
| | | from ums_base_case |