<select id="getStatsByArea" resultMap="BaseResultMap"> SELECT ${areaName} areaCode, t.area_name areaName, COUNT(house_damage_id) totalNum, to_char(disaster_date,'yyyy') theYear ${typeName} FROM house_damage_ledger LEFT JOIN base_area_year t ON t.standard_code=${areaName} GROUP BY theYear,areaCode,areaName HAVING theYear=#{yearStr} <if test="!''.equals(andStr)"> AND areaCode LIKE concat(#{andStr}, '%') </if> ORDER BY totalNum desc </select>
String andStr = areaName; if("0".equals(areaName)){ areaName = "SUBSTRING(area_code,1,2)||'0000'"; andStr = ""; }else if("11".equals(areaName) || "12".eq