<?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.casking.ccss.modules.qs.dao.QuestionnaireSurveyDao">
<select id="getVidBySid" resultType="string">
SELECT C_V_ID
FROM C_QUESTION_VERSIONS
WHERE C_V_ID = (
SELECT MAX(C_V_ID) FROM C_NOTE_CONTENT
WHERE C_V_C_RANK = '2'
AND C_N_S_ID = #{sId}
)
</select>
<select id="getDescriptionByVid" resultType="string">
SELECT C_V_DESCRIPTION
FROM C_QUESTION_VERSIONS
WHERE C_V_ID = #{vId}
</select>
<select id="getQuestionInfo" resultType="hashmap">
SELECT T1.C_Q_ID AS "qId",
T1.C_Q_NAME AS "qType",
T2.C_Q_QUESTION_NAME AS "qName",
T2.C_Q_QUESTION_TYPE AS "qQType"
FROM C_VERSIONS_WAREHOUSE T1
LEFT JOIN C_QUESTION_WAREHOUSE T2
ON T1.C_Q_ID = T2.C_Q_ID
WHERE T1.C_V_ID = #{vId}
ORDER BY T1.C_Q_ORDER
</select>
<select id="getQuestionDetailInfo" resultType="hashmap">
SELECT T1.C_Q_ID AS "qId",
T3.C_Q_D_ID AS "dId",
T3.C_Q_D_NAME AS "dName"
FROM C_VERSIONS_WAREHOUSE T1
LEFT JOIN C_QUESTION_WAREHOUSE T2
ON T1.C_Q_ID = T2.C_Q_ID
LEFT JOIN C_QUESTION_DETAILS T3
ON T2.C_Q_ID = T3.C_Q_ID
WHERE T1.C_V_ID = #{vId}
ORDER BY T2.C_Q_ORDER,T3.C_Q_D_ORDER
</select>
<insert id="addQuestionResult">
BEGIN
<foreach collection="list" item="item" index="index" separator=";" >
INSERT INTO C_QUESTION_RESULT (
C_Q_R_ID,C_I_P_ID,C_N_S_ID,C_V_ID,C_Q_ID,C_Q_RESULT
) VALUES (
SYS_GUID(),#{item.pId},#{item.sId},#{item.vId},#{item.qId},#{item.qResult}
)
</foreach>
;END ;
</insert>
<select id="getQuestionResultList" resultType="hashmap">
SELECT C_Q_ID AS "qId",
C_Q_RESULT AS "result"
FROM C_QUESTION_RESULT
WHERE C_V_ID = #{vId}
AND C_I_P_ID = #{pId}
</select>
</mapper>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.casking.ccss.modules.qs.dao.QuestionnaireSurveyDao">
<select id="getVidBySid" resultType="string">
SELECT C_V_ID
FROM C_QUESTION_VERSIONS
WHERE C_V_ID = (
SELECT MAX(C_V_ID) FROM C_NOTE_CONTENT
WHERE C_V_C_RANK = '2'
AND C_N_S_ID = #{sId}
)
</select>
<select id="getDescriptionByVid" resultType="string">
SELECT C_V_DESCRIPTION
FROM C_QUESTION_VERSIONS
WHERE C_V_ID = #{vId}
</select>
<select id="getQuestionInfo" resultType="hashmap">
SELECT T1.C_Q_ID AS "qId",
T1.C_Q_NAME AS "qType",
T2.C_Q_QUESTION_NAME AS "qName",
T2.C_Q_QUESTION_TYPE AS "qQType"
FROM C_VERSIONS_WAREHOUSE T1
LEFT JOIN C_QUESTION_WAREHOUSE T2
ON T1.C_Q_ID = T2.C_Q_ID
WHERE T1.C_V_ID = #{vId}
ORDER BY T1.C_Q_ORDER
</select>
<select id="getQuestionDetailInfo" resultType="hashmap">
SELECT T1.C_Q_ID AS "qId",
T3.C_Q_D_ID AS "dId",
T3.C_Q_D_NAME AS "dName"
FROM C_VERSIONS_WAREHOUSE T1
LEFT JOIN C_QUESTION_WAREHOUSE T2
ON T1.C_Q_ID = T2.C_Q_ID
LEFT JOIN C_QUESTION_DETAILS T3
ON T2.C_Q_ID = T3.C_Q_ID
WHERE T1.C_V_ID = #{vId}
ORDER BY T2.C_Q_ORDER,T3.C_Q_D_ORDER
</select>
<insert id="addQuestionResult">
BEGIN
<foreach collection="list" item="item" index="index" separator=";" >
INSERT INTO C_QUESTION_RESULT (
C_Q_R_ID,C_I_P_ID,C_N_S_ID,C_V_ID,C_Q_ID,C_Q_RESULT
) VALUES (
SYS_GUID(),#{item.pId},#{item.sId},#{item.vId},#{item.qId},#{item.qResult}
)
</foreach>
;END ;
</insert>
<select id="getQuestionResultList" resultType="hashmap">
SELECT C_Q_ID AS "qId",
C_Q_RESULT AS "result"
FROM C_QUESTION_RESULT
WHERE C_V_ID = #{vId}
AND C_I_P_ID = #{pId}
</select>
</mapper>