<?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.ruoyi.member.mapper.MemberRightsMapper">

    <resultMap type="MemberRights" id="MemberRightsResult">
        <result property="id"    column="id"    />
        <result property="userId"    column="user_id"    />
        <result property="userType"    column="user_type"    />
        <result property="cardId"    column="card_id"    />
        <result property="rightsCode"    column="rights_code"    />
        <result property="rightsType"    column="rights_type"    />
        <result property="rightsCycle"    column="rights_cycle"    />
        <result property="rightsValue"    column="rights_value"    />
        <result property="remaining"    column="remaining"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateTime"    column="update_time"    />
    </resultMap>

    <sql id="selectMemberRightsVo">
        select id, user_id, user_type, card_id, rights_code, rights_type, rights_cycle, rights_value, remaining, create_time, update_time from dl_member_rights
    </sql>
    <select id="selectUserRightsByCardIds" resultType="com.ruoyi.member.domain.MemberRights">
        SELECT
            dmr.*
        FROM
            dl_member_rights dmr
        WHERE
            dmr.user_id = #{userId}
          AND dmr.card_id IN
<foreach collection="list" item="item" open="(" separator="," close=")">
    #{item}
</foreach>
    </select>


</mapper>