统计状态过滤

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();

}