xml에 쿼리문 수정

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="kr.co.saehimit.WithGMP.Admin.main.comm.dao.CodeCommDao">
	
	<select id="getCodeCommCombo" parameterType="java.util.Map" resultType="kr.co.saehimit.WithGMP.Admin.main.admin.model.Combo" >
		SELECT 
			CONVERT(NVARCHAR(10),'') AS CODE
			<if test="locale.equals('ko')">
			, CONVERT(NVARCHAR(10),'전체') AS CODENAME
			</if>
			<if test="locale.equals('en')">
			, CONVERT(NVARCHAR(10),'ALL') AS CODENAME
			</if>
			<if test="locale.equals('ch')">
			, CONVERT(NVARCHAR(10),'全部') AS CODENAME
			</if>			
			, 0 AS CODEID
			, '' AS S_CODE_NAME_FST
            , '' AS S_CODE_NAME_SND
		WHERE 
			'ALL' = ISNULL(#{all},'')
		UNION ALL
		SELECT 
			  CONVERT(NVARCHAR(10),S_CODE) AS CODE
			, CONVERT(NVARCHAR(20),S_CODE_NAME) AS CODENAME
			, SORDER AS CODEID
			, CONVERT(NVARCHAR(20),'') AS S_CODE_NAME_FST
            , CONVERT(NVARCHAR(20),'') AS S_CODE_NAME_SND
		FROM T_CODE_COMM
		WHERE M_CODE = #{m_code} 
		<if test="use_yn != null and use_yn != ''">
		AND USE_YN = #{use_yn}
		</if>
		ORDER BY CODEID, CODE
	</select>	
</mapper>

#all# -> #{all}
#m_code# -> #{m_code}
#use_yn# -> #{user_yn}