54 lines
1.4 KiB
XML
54 lines
1.4 KiB
XML
<?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="kr.co.i4way.sample.dao.SampleDao">
|
|
<select id="getDual" resultType="java.lang.String">
|
|
SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24MISS') FROM DUAL
|
|
</select>
|
|
|
|
<select id="getTestList" parameterType="kr.co.i4way.sample.model.TestListVo" resultType="hashmap">
|
|
<![CDATA[
|
|
SELECT scr_id as Key
|
|
,scr_id
|
|
,scr_name
|
|
,scr_name as Title
|
|
,scr_link
|
|
,grade
|
|
,use_yn
|
|
,depth
|
|
,p_id
|
|
,order_no || '' AS order_no
|
|
,folder
|
|
FROM TBL_MENU
|
|
WHERE use_yn = 'Y'
|
|
]]>
|
|
</select>
|
|
|
|
<select id="getWallInfo" parameterType="kr.co.i4way.sample.model.WallInfoVo" resultType="hashmap">
|
|
SELECT a.ID,
|
|
a.CENTER_ID,
|
|
b.CENTER_NAME,
|
|
a.WALL_NAME,
|
|
a.BG_INFO,
|
|
a.VIEW_YN,
|
|
b.CENTER_ORDER,
|
|
a.WALL_ORDER,
|
|
a.WALL_DURATION,
|
|
a.FONT_COLOR,
|
|
a.CI_INFO,
|
|
a.WALL_URL,
|
|
a.CHANGE_EFFECT
|
|
FROM TBL_WALL_INFO a, TBL_WALL_CENTER b
|
|
WHERE a.CENTER_ID = b.CENTER_ID
|
|
AND a.VIEW_YN = 'Y'
|
|
<if test='center_id != "" '>
|
|
<if test="query_arry != null and query_arry.length > 0">
|
|
AND a.CENTER_ID IN
|
|
<foreach collection="query_arry" item="item" open="(" close=")" separator=",">
|
|
#{item}
|
|
</foreach>
|
|
</if>
|
|
</if>
|
|
ORDER BY b.CENTER_ORDER, a.WALL_ORDER ASC
|
|
</select>
|
|
</mapper> |