<?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.kcim.dao.mapper.ComputeStandShareParamDetailMapper">

	<!-- 可根据自己的需求，是否要使用 -->
    <resultMap type="com.kcim.dao.model.ComputeStandShareParamDetail" id="ComputeStandShareParamDetailMap">
        <result property="id" column="id"/>
        <result property="hospId" column="hosp_id"/>
        <result property="computeDate" column="compute_date"/>
        <result property="shareParamId" column="share_param_id"/>
        <result property="shareParamCode" column="share_param_code"/>
        <result property="computeResult" column="compute_result"/>
        <result property="computeSingleResult" column="compute_single_result"/>
        <result property="createUser" column="create_user"/>
        <result property="createTime" column="create_time"/>
        <result property="updateUser" column="update_user"/>
        <result property="updateTime" column="update_time"/>
        <result property="deleteUser" column="delete_user"/>
        <result property="deleteTime" column="delete_time"/>
        <result property="delFlag" column="del_flag"/>
    </resultMap>
    <select id="getByShareParamId" resultType="com.kcim.vo.ComputeDateShareParamVo">
        SELECT a.responsibility_code,
        a.responsibility_name,
        a.`code`,
        a.`name`,
        a.item_type,
        b.share_param_code,
        sum(b.compute_result) as compute_result
        FROM compute_stand_share_param a
        LEFT JOIN compute_stand_share_param_detail b ON a.id = b.share_param_id
        AND b.del_flag = 0
        WHERE a.hosp_id = #{hospId,jdbcType=BIGINT}
        AND b.hosp_id = #{hospId,jdbcType=BIGINT}
        AND a.del_flag = 0
        and a.compute_date = #{computeDate,jdbcType=VARCHAR}
        and b.compute_date = #{computeDate,jdbcType=VARCHAR}
        and b.share_param_id in
        <foreach collection="items" item="shareParamId" index="index" open="(" close=")" separator=",">
            #{shareParamId}
        </foreach>
        GROUP BY a.responsibility_code, a.`code`,b.share_param_code
    </select>


</mapper>