<?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.BpmSecretaryManageDao">
	<resultMap id="BpmSecretaryManage" type="com.artfess.bpm.persistence.model.BpmSecretaryManage">
		<id property="id" column="ID_" jdbcType="VARCHAR"/>
		<result property="leaderId" column="LEADER_ID_" jdbcType="VARCHAR"/>
		<result property="leaderName" column="LEADER_NAME_" jdbcType="VARCHAR"/>
		<result property="secretaryId" column="SECRETARY_ID_" jdbcType="VARCHAR"/>
		<result property="secretaryName" column="SECRETARY_NAME_" jdbcType="VARCHAR"/>
		<result property="shareType" column="SHARE_TYPE_" jdbcType="VARCHAR"/>
		<result property="shareKey" column="SHARE_KEY_" jdbcType="VARCHAR"/>
		<result property="shareName" column="SHARE_NAME_" jdbcType="VARCHAR"/>
		<result property="enabled" column="ENABLED_" jdbcType="VARCHAR"/>
		<result property="shareRight" column="SHARE_RIGHT_" jdbcType="VARCHAR"/>
	</resultMap>

    <select id="getSecretaryByUserId" parameterType="java.lang.String" resultMap="BpmSecretaryManage">
        SELECT * FROM bpm_secretary_manage where SECRETARY_ID_ LIKE ('%,${userId},%')
    </select>
</mapper>