首页添加未过期的公告数量

huminmin

11 小时以前 186e25fed2ba68e445a4cd8dffb0bde6b02af93a

首页添加未过期的公告数量

 src/main/java/com/ruoyi/home/controller/HomeController.java

@@ -85,5 +85,10 @@
        return AjaxResult.success(map);
    }


    @GetMapping("/noticesCount")
    @ApiOperation("未过期的公告数量")
    public AjaxResult noticesCount(){
       Long count = homeService.noticesCount();
        return AjaxResult.success(count);
    }
}

 src/main/java/com/ruoyi/home/service/HomeService.java

@@ -29,4 +29,6 @@
    StatisticsReceivablePayableDto statisticsReceivablePayable(Integer type);

    Map<String, Object> approveAndDeviceTodos();

    Long noticesCount();
}

 src/main/java/com/ruoyi/home/service/impl/HomeServiceImpl.java

@@ -3,6 +3,8 @@
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.ruoyi.approve.mapper.ApproveProcessMapper;
import com.ruoyi.approve.pojo.ApproveProcess;
import com.ruoyi.collaborativeApproval.mapper.NoticeMapper;
import com.ruoyi.collaborativeApproval.pojo.Notice;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.device.mapper.DeviceMaintenanceMapper;
import com.ruoyi.device.mapper.DeviceRepairMapper;
@@ -93,6 +95,9 @@

    @Autowired
    private SysDeptMapper sysDeptMapper;

    @Autowired
    private NoticeMapper noticeMapper;

    @Override
    public HomeBusinessDto business() {
@@ -467,4 +472,12 @@
            put("deviceRepairTodo", aLong1);
        }};
    }

    @Override
    public Long noticesCount() {
        // 查询未过期的通知数量：状态为发布且过期时间大于等于当前日期
        return noticeMapper.selectCount(new LambdaQueryWrapper<Notice>()
                .eq(Notice::getStatus, 1) // 1表示发布状态
                .ge(Notice::getExpirationDate, new Date())); // 过期时间大于等于当前日期
    }
}