From 55fefdfac9a281cc57a1b3bad1fd061eec4b066d Mon Sep 17 00:00:00 2001
From: ZQN <364596817@qq.com>
Date: 星期四, 27 六月 2024 09:52:05 +0800
Subject: [PATCH] 统计状态过滤
---
project-enforce/src/main/java/com/project/enforce/mapper/EnforceOrderMapper.java | 2 +-
1 files changed, 1 insertions(+), 1 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 2c34a04..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
@@ -25,7 +25,7 @@
List<EnforceOrderVo> selectScanList(@Param("companyCode") String companyCode,@Param("userId") Long userId);
- @Select("SELECT COUNT(DISTINCT company_id) FROM enforce_order and check_status>=2")
+ @Select("SELECT COUNT(DISTINCT company_id) FROM enforce_order where check_status>=2")
Integer getDistinctCompanyNum();
}
--
Gitblit v1.9.1