吉安感知网项目-后端
parent: abe28f | patch | commitdiff
linwei
2026-06-09 1fe7ed3c48a35620811b2bde3c88139e467f60be
refs
author linwei <872216696@qq.com>
Tuesday, June 9, 2026 10:19 +0800
committer linwei <872216696@qq.com>
Tuesday, June 9, 2026 10:19 +0800
commit1fe7ed3c48a35620811b2bde3c88139e467f60be
tree 85c6fb1d16b587993c5b7fdbd7ac0e26adfe0794 tree | zip | gz
parent abe28fb2d90bedc4c06ffb389b9f73c2b1249848 view | diff 
fix(workorder): 修复工单和巡检任务类型查询的逗号分隔值处理

- 修改 GdPatrolTaskMapper.xml 中 patrolTaskType 参数的处理逻辑
- 修改 GdWorkOrderMapper.xml 中 workOrderType 参数的处理逻辑
- 使用 PostgreSQL 的 string_agg 和 string_to_array 函数处理逗号分隔的字符串
- 将逗号分隔的字符串转换为带引号的格式进行匹配
- 修复因类型不匹配导致的数据库查询报错问题
2 files modified
16 ■■■■■ changed files
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdPatrolTaskMapper.xml 8 ●●●●● diff | view | raw | blame | history
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdWorkOrderMapper.xml 8 ●●●●● diff | view | raw | blame | history