| | |
|---|
| | | Map<String, Object> map = new HashMap<>(); |
|---|
| | | map1 = getLook.selectPowerByMethodAndUserId("selectInsOrderParameter"); |
|---|
| | | Long totalNumberOfMessages = baseMapper.selectCount(Wrappers.<InformationNotification>lambdaQuery() |
|---|
| | | .eq(InformationNotification::getConsigneeId, map1.get("userId"))); |
|---|
| | | .eq(InformationNotification::getConsigneeId, map1.get("userId")) |
|---|
| | | .apply("DATE(create_time) BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE()") |
|---|
| | | .eq(InformationNotification::getViewStatus, false)); |
|---|
| | | Long totalNumberOfReadMessages = baseMapper.selectCount(Wrappers.<InformationNotification>lambdaQuery() |
|---|
| | | .eq(InformationNotification::getConsigneeId, map1.get("userId")) |
|---|
| | | .apply("DATE(create_time) BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE()") |
|---|
| | | .eq(InformationNotification::getViewStatus, true)); |
|---|
| | | LocalDate today = LocalDate.now(); |
|---|
| | | LocalDate sevenDaysAgo = today.minusDays(7); |
|---|
| | | Long totalNumberOfMessagesInThePastSevenDays = baseMapper.selectCount(Wrappers.<InformationNotification>lambdaQuery() |
|---|
| | | .eq(InformationNotification::getConsigneeId, map1.get("userId")) |
|---|
| | | .between(InformationNotification::getCreateTime, today, sevenDaysAgo)); |
|---|
| | | .between(InformationNotification::getCreateTime, today.atStartOfDay(), sevenDaysAgo.atStartOfDay())); |
|---|
| | | long remainingToDo = totalNumberOfMessages - totalNumberOfReadMessages; |
|---|
| | | remainingToDo=remainingToDo<0?0:remainingToDo; |
|---|
| | | map.put("totalNumberOfMessages", totalNumberOfMessages); |
|---|
| | | map.put("remainingToDo", remainingToDo); |
|---|
| | | map.put("totalNumberOfReadMessages", totalNumberOfReadMessages); |
|---|
