From c3946c3fb35d6537f90d6789df9a8a1e2a9bfd22 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期二, 09 十一月 2021 12:26:04 +0800
Subject: [PATCH] 1109预约修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActReserveAnswerContentMapper.xml | 7 +++----
1 files changed, 3 insertions(+), 4 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActReserveAnswerContentMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActReserveAnswerContentMapper.xml
index 48aceba..d9d4667 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActReserveAnswerContentMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActReserveAnswerContentMapper.xml
@@ -88,12 +88,11 @@
</select>
<select id="export" resultType="com.panzhihua.common.model.vos.community.ComActQuestnaireAnswerContentVO">
- SELECT
- qs.type as optionType,ac.*,su.nick_name,carr.create_at as `time`
+ select ac.*,t.nick_name from ( SELECT
+ qs.type as optionType,ac.*,ac.create_at as `time`
FROM
com_act_reserve_record carr
LEFT JOIN com_act_reserve qn ON carr.reserve_id = qn.id
- LEFT JOIN sys_user su ON carr.user_id = su.user_id
LEFT JOIN com_act_reserve_sub qs ON carr.reserve_id = qs.reserve_id
LEFT JOIN com_act_reserve_answer_content ac ON qs.id = ac.reserve_sub_id
WHERE
@@ -123,7 +122,7 @@
AND ac.answer_content like concat ('%',#{detailedAdminDTO.keyword},'%')
</if>
) and ac.reserve_record_id in (select distinct reserve_record_id from com_act_reserve_answer_content where answer_content like concat('%',#{detailedAdminDTO.keyword},'%'))
- GROUP BY ac.id
+ GROUP BY ac.id ) ac left join sys_user t on ac.user_id = t.user_id
order by ac.reserve_record_id asc,ac.id asc
</select>
</mapper>
\ No newline at end of file
--
Gitblit v1.7.1