From 366ea52e19897a287355e2e5241f0593befd7d3c Mon Sep 17 00:00:00 2001
From: ZQN <364596817@qq.com>
Date: 星期四, 27 六月 2024 09:56:00 +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..459a525 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 where check_status>=2")
+    Integer getDistinctCompanyNum();
+
 }

--
Gitblit v1.9.1