From 484bc1f21e7d29b480005f9c7077b03c64d8f86e Mon Sep 17 00:00:00 2001 From: ZQN <364596817@qq.com> Date: 星期六, 22 六月 2024 20:14:11 +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