统计状态过滤

ZQN

2024-06-27 55fefdfac9a281cc57a1b3bad1fd061eec4b066d

统计状态过滤

 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 and check_status>=2")
    @Select("SELECT COUNT(DISTINCT company_id) FROM enforce_order where check_status>=2")
    Integer getDistinctCompanyNum();

}

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

@@ -62,7 +62,7 @@
                .eq(SysUser::getStatus,"0")
        );
        int enforceOrderNum = orderService.count();
        int enforceOrderCheckedNum = orderService.count(orderService.lq().ge(EnforceOrder::getOrderStatus,2));
        int enforceOrderCheckedNum = orderService.count(orderService.lq().ge(EnforceOrder::getCheckStatus,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));

 project-report/src/main/resources/mapper/report/ReportMapper.xml

@@ -13,6 +13,7 @@
            IFNULL(count(order_id),0) as v
        from enforce_order
        where 1=1
        and check_status>=2
        <if test="deptId != null ">
            AND check_dept_id = #{deptId}
        </if>
@@ -34,6 +35,7 @@
        IFNULL(count(order_id),0) as v
        from enforce_order
        where 1=1
        and check_status>=2
        <if test="beginTime!=null and beginTime!=''">
            AND apply_time &gt;= #{beginTime}
        </if>
@@ -54,7 +56,9 @@
        from sys_company sc
        left join enforce_order eo on sc.company_id=eo.company_id
        where 1=1
        and sc.company_status=0
        and sc.check_status=2
        and eo.check_status>=2
        <if test="beginTime!=null and beginTime!=''">
            AND eo.apply_time &gt;= #{beginTime}
        </if>
@@ -73,6 +77,7 @@
        IFNULL(count(order_id),0) as v
        from enforce_order
        where 1=1
          and check_status>=2
        <if test="beginTime!=null and beginTime!=''">
            AND apply_time &gt;= #{beginTime}
        </if>