吉安感知网项目-后端
linwei
yesterday 08ddfad4530a014094c06fe68b8c2d9a0753403a
fix(gd): 修复线索事件查询中的SQL语法错误

- 修正了GdClueEventMapper.xml中的重复like关键字问题
- 确保事件名称搜索功能正常工作
1 files modified
2 ■■■ changed files
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdClueEventMapper.xml 2 ●●● patch | view | raw | blame | history
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdClueEventMapper.xml
@@ -146,7 +146,7 @@
        </if>
        <if test="keyword != null and keyword != ''">
            and (ce.event_num::VARCHAR like concat('%', #{keyword}, '%')
                 or ce.event_name::VARCHAR like like concat('%', #{keyword}, '%'))
                 or ce.event_name::VARCHAR like concat('%', #{keyword}, '%'))
        </if>
        <if test="onlyMine != null and onlyMine == 1">
            and ce.dispose_user = #{userId}