统计状态过滤

ZQN

2024-06-27 b88f3ec86a22f0011cef172bff0e4e296ce6cbeb

统计状态过滤

 project-enforce/src/main/java/com/project/enforce/mapper/EnforceOrderMapper.java

@@ -25,7 +25,7 @@

    List<EnforceOrderVo> selectScanList(@Param("companyCode") String companyCode,@Param("userId") Long userId);

    @Select("SELECT COUNT(DISTINCT company_id) FROM enforce_order")
    @Select("SELECT COUNT(DISTINCT company_id) FROM enforce_order and check_status>=2")
    Integer getDistinctCompanyNum();

}

 project-report/src/main/java/com/project/report/service/impl/ReportServiceImpl.java

@@ -50,15 +50,19 @@
    @Override//汇总
    public Map<String, Object> getTotalInfo()
    {
        int companyNum = companyService.count(companyService.lq().eq(SysCompany::getCompanyStatus, 0));
        int companyNum = companyService.count(companyService.lq()
                .eq(SysCompany::getCompanyStatus, 0)
                .eq(SysCompany::getCheckStatus, 2)
        );
        int enforceCompanyNum = orderService.getDistinctCompanyNum();
        int enforceDeptNum = deptService.count(deptService.lq().eq(SysDept::getParentId,100));
        int enforceUserNum = userService.count(userService.lq()
                .ne(SysUser::getUserType,"02")
                .ne(SysUser::getUserName,"admin")
                .eq(SysUser::getStatus,"0")
        );
        int enforceOrderNum = orderService.count();
        int enforceOrderCheckedNum = orderService.count(orderService.lq().eq(EnforceOrder::getOrderStatus,2));
        int enforceOrderCheckedNum = orderService.count(orderService.lq().ge(EnforceOrder::getOrderStatus,2));
        int enforceOrderCompleteNum = orderService.count(orderService.lq().eq(EnforceOrder::getOrderStatus,4));
        int complaintNum = complaintLogService.count();
        int docNum = docService.count(docService.lq().eq(SysDoc::getDocStatus,0));