<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yeejoin.amos.boot.module.jxiop.biz.mapper2.IdxBizFanHealthLevelMapper">

<update id="updateByInfo">
    UPDATE ${tableName}
    <if test="groupLowerLimit != null and groupLowerLimit != ''">
        set GROUP_LOWER_LIMIT = #{groupLowerLimit}
    </if>
    <if test="groupUpperLimit != null and groupUpperLimit != ''">
        , GROUP_UPPER_LIMIT = #{groupUpperLimit}
    </if>
    WHERE
        ANALYSIS_OBJ_TYPE = #{analysisObjType}
      AND HEALTH_LEVEL = #{healthLevel}
    </update>

<update id="updateByInfoIsNull">
    UPDATE ${tableName}
    <if test="groupLowerLimit != null and groupLowerLimit != ''">
        set GROUP_LOWER_LIMIT = #{groupLowerLimit}
    </if>
    <if test="groupUpperLimit != null and groupUpperLimit != ''">
        set GROUP_UPPER_LIMIT = #{groupUpperLimit}
    </if>
    WHERE
    ANALYSIS_OBJ_TYPE = #{analysisObjType}
    AND HEALTH_LEVEL = #{healthLevel}
    </update>
</mapper>
