| | |
| | | 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_sub qs ON carr.id = qs.reserve_id |
| | | LEFT JOIN com_act_reserve_answer_content ac ON qs.id = ac.reserve_sub_id |
| | | where qn.id =#{detailedAdminDTO.reserveId} |
| | | <if test='detailedAdminDTO.startTime != null and detailedAdminDTO.startTime != ""'> |
| | |
| | | AND ac.answer_content like concat ('%',#{detailedAdminDTO.keyword},'%') |
| | | </if> |
| | | ) |
| | | GROUP BY ac.id |
| | | order by ac.reserve_record_id asc,ac.id asc |
| | | </select> |
| | | |