From ed8c7a5effd0d423ce1118b680ecdca6fe732609 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 02 七月 2025 16:43:13 +0800
Subject: [PATCH] Merge branch 'master' of http://192.168.11.205:9000/r/P2022036_Service
---
src/main/java/com/lf/server/mapper/all/BasicMapper.java | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/lf/server/mapper/all/BasicMapper.java b/src/main/java/com/lf/server/mapper/all/BasicMapper.java
index 93c9dac..478a315 100644
--- a/src/main/java/com/lf/server/mapper/all/BasicMapper.java
+++ b/src/main/java/com/lf/server/mapper/all/BasicMapper.java
@@ -1,6 +1,8 @@
package com.lf.server.mapper.all;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.lf.server.entity.sys.AttachEntity;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@@ -20,7 +22,7 @@
* @param value 鍊�
* @return 缁撴灉鍒楄〃
*/
- @Select("select ${field} from ${tab} where ${field} like #{value} order by ${field} limit 10")
+ @Select("select ${field} from ${tab} where upper(${field}) like #{value} order by ${field} limit 10")
public List<String> selectFieldFuzzy(@Param("tab") String tab, @Param("field") String field, @Param("value") String value);
/**
@@ -40,4 +42,14 @@
* @return
*/
public int updateBatch(@Param("list") List<T> list);
+
+ /**
+ * 鏌ヨ闄勪欢
+ *
+ * @param tab 琛ㄥ悕
+ * @param wrapper 鏌ヨ鍖呰鍣�
+ * @return
+ */
+ @Select("select * from lf.sys_attach where tab = #{tab} and tab_guid in (select eventid from ${tab} ${ew.customSqlSegment})")
+ public List<AttachEntity> selectAnnex(@Param("tab") String tab, @Param("ew") QueryWrapper wrapper);
}
--
Gitblit v1.9.3