From be649a182a10a25a834f137576b28c3f7de03c64 Mon Sep 17 00:00:00 2001
From: ZQN <364596817@qq.com>
Date: 星期二, 03 九月 2024 11:08:52 +0800
Subject: [PATCH] 审批企业状态
---
project-enforce/src/main/java/com/project/enforce/mapper/EnforceOrderMapper.java | 7 +++++++
1 files changed, 7 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..361934d 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
@@ -4,8 +4,10 @@
import com.project.enforce.domain.EnforceOrder;
import com.project.enforce.domain.bo.queryBo.EnforceOrderQueryBo;
import com.project.enforce.domain.bo.queryBo.OrderCheckedQueryBo;
+import com.project.enforce.domain.vo.EnforceDistinctVo;
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 +25,9 @@
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();
+
+ List<EnforceDistinctVo> selectDistinctCheckDeptIdAndCompanyId();
}
--
Gitblit v1.9.1