代码提交

liusheng

2024-07-20 04a3469886f03afb3eab782d99c51fc10b137f6f

代码提交

 smartor/src/main/resources/mapper/smartor/IvrLibaTemplateMapper.xml

@@ -44,7 +44,7 @@
    </resultMap>

    <sql id="selectIvrLibaTemplateVo">
        select ID,
        select id,
               revisit_before,
               revisit_after,
               templateName,
@@ -70,7 +70,7 @@
            <if test="templateName != null  and templateName != ''">and templateName like concat('%', #{templateName},
                '%')
            </if>
            <if test="ID != null ">and id = #{ID}</if>
            <if test="id != null ">and id = #{id}</if>
            <if test="revisitAfter != null ">and revisit_after = #{revisitAfter}</if>
            <if test="revisitBefore != null ">and revisit_before = #{revisitBefore}</if>
            <if test="mateNum != null and mateNum > 0">and mate_num = #{mateNum}</if>
@@ -112,7 +112,7 @@
    </select>

    <insert id="insertIvrLibaTemplate" parameterType="com.smartor.domain.IvrLibaTemplate" useGeneratedKeys="true"
            keyProperty="ID">
            keyProperty="id">
        insert into ivr_liba_template
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="templateName != null and templateName != ''">templateName,</if>
@@ -231,7 +231,7 @@
            <if test="noVoiceNum != null and noVoiceNum > 0 ">no_voice_num = #{noVoiceNum},</if>
            <if test="silencetime != null">silencetime = #{silencetime}</if>
        </trim>
        where ID = #{ID}
        where id = #{id}
    </update>

    <update id="deleteIvrLibaTemplateByID" parameterType="Long">
@@ -239,13 +239,13 @@
        <trim prefix="SET" suffixOverrides=",">
            del_flag = 1
        </trim>
        where ID = #{ID}
        where id = #{id}
    </update>

    <delete id="deleteIvrLibaTemplateByIDs" parameterType="String">
        delete from ivr_liba_template where ID in
        <foreach item="ID" collection="array" open="(" separator="," close=")">
            #{ID}
        delete from ivr_liba_template where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>