1105测试代码修改

101captain

2021-11-05 2823f21809821747cdb76f957cade9bce921af26

1105测试代码修改

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActReserveAnswerContentMapper.xml

@@ -97,16 +97,16 @@
        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
            carr.id in (
                    SELECT distinct
                    carr.id
                    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 qn.id =#{detailedAdminDTO.reserveId}
        carr.id in (
        SELECT distinct
        carr.id
        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.id = qs.reserve_id
        LEFT JOIN com_act_reserve_answer_content ac ON carr.id = ac.reserve_record_id
        where qn.id =#{detailedAdminDTO.reserveId}
        <if test='detailedAdminDTO.startTime != null and detailedAdminDTO.startTime != &quot;&quot;'>
            AND carr.create_at <![CDATA[ >= ]]> #{detailedAdminDTO.startTime}
        </if>
@@ -122,7 +122,7 @@
        <if test="detailedAdminDTO.keyword!=null and detailedAdminDTO.keyword != &quot;&quot;">
            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},'%'))
        ) 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
        order by ac.reserve_record_id asc,ac.id asc
    </select>