<?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.artfess.bpm.persistence.dao.BpmTaskCommuDao">
	<resultMap id="BpmTaskCommu" type="com.artfess.bpm.persistence.model.BpmTaskCommu">
		<id property="id" column="id_" jdbcType="VARCHAR"/>
		<result property="instanceId" column="instance_id_" jdbcType="VARCHAR"/>
		<result property="nodeName" column="node_name_" jdbcType="VARCHAR"/>
		<result property="nodeId" column="node_id_" jdbcType="VARCHAR"/>
		<result property="taskId" column="task_id_" jdbcType="VARCHAR"/>
		<result property="senderId" column="sender_id_" jdbcType="VARCHAR"/>
		<result property="sender" column="sender" jdbcType="VARCHAR"/>
		<result property="createtime" column="createtime_" jdbcType="TIMESTAMP"/>
		<result property="opinion" column="opinion_" jdbcType="VARCHAR"/>
	</resultMap>

	<select id="getByTaskId"   parameterType="java.lang.String" resultMap="BpmTaskCommu">
		SELECT * FROM bpm_task_commu 
		WHERE 
		task_id_=#{taskId}
	</select>

    <select id="getByInstId"   parameterType="java.lang.String" resultMap="BpmTaskCommu">
		SELECT * FROM bpm_task_commu
		WHERE
		INSTANCE_ID_=#{instId}
	</select>
	
	
</mapper>