From e535eeb59b9c56e6a51379a5bfbdfa5762e73a90 Mon Sep 17 00:00:00 2001
From: sinake <sinake1@qq.com>
Date: 星期一, 20 十月 2025 15:25:46 +0800
Subject: [PATCH] orgid过滤优化
---
smartor/src/main/java/com/smartor/service/impl/ServiceTelInfoServiceImpl.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/smartor/src/main/java/com/smartor/service/impl/ServiceTelInfoServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/ServiceTelInfoServiceImpl.java
index cdc27cc..819944a 100644
--- a/smartor/src/main/java/com/smartor/service/impl/ServiceTelInfoServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/ServiceTelInfoServiceImpl.java
@@ -24,7 +24,7 @@
*/
@Override
public List<Map<String,Object>> getList(String orgid) {
- String where=" where state=0 OR DATE_ADD(editTime, INTERVAL 10 MINUTE)< NOW() ";
+ String where=" where (state=0 OR DATE_ADD(editTime, INTERVAL 10 MINUTE)< NOW()) ";
if(ObjectUtils.isNotEmpty(orgid))
where=where+" and orgid='"+orgid+"'";
List<Map<String,Object>> lists= utilsMapper.getList("select * from service_telinfo " +where);
--
Gitblit v1.9.3