统计状态过滤

ZQN

2024-06-27 55fefdfac9a281cc57a1b3bad1fd061eec4b066d

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

@@ -6,6 +6,7 @@
import com.project.enforce.domain.bo.queryBo.OrderCheckedQueryBo;
import com.project.enforce.domain.vo.EnforceOrderVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@@ -23,4 +24,8 @@


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

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

}