From e897dfa023634f08d47e4d0ba2bcf19a05b9006e Mon Sep 17 00:00:00 2001 From: ZQN <364596817@qq.com> Date: 星期三, 26 六月 2024 20:17:52 +0800 Subject: [PATCH] 用户列表去除企业 --- project-enforce/src/main/java/com/project/enforce/mapper/EnforceOrderMapper.java | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) diff --git a/project-enforce/src/main/java/com/project/enforce/mapper/EnforceOrderMapper.java b/project-enforce/src/main/java/com/project/enforce/mapper/EnforceOrderMapper.java index 3c2657c..3a08577 100644 --- a/project-enforce/src/main/java/com/project/enforce/mapper/EnforceOrderMapper.java +++ b/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") + Integer getDistinctCompanyNum(); + } -- Gitblit v1.9.1