吉安感知网项目-后端
parent: ef66d1e8 | patch | commit | ignore whitespace
linwei
8 hours ago 8585b431e9257333413358eb37c30ae58f74db76 
refactor(database): 优化数据库查询中的字段映射

- 移除了 thumbnailUrl 字段的别名映射，直接使用 thumbnail_url
- 简化了查询结果集的字段映射结构
- 提高了代码可读性和维护性
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


@@ -119,7 +119,7 @@


            COALESCE(tr.attachment_type, ce.attachment_type) as attachment_type,


            ce.create_time as create_time,


            tr.shoot_time as shoot_time,


            tr.thumbnail_url as thumbnailUrl,


            tr.thumbnail_url,


            COALESCE(bu.real_name, bu.name) as dispose_user_name,


            bd.dept_name as dispose_dept_name,


            ce.result_id,