From 2e4a8950290ea2eef167315a4254f89ded9acc49 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Thu, 16 Dec 2021 11:12:19 +0800 Subject: [PATCH] 20211216 --- src/main/resources/mapper/modules/VideoMemberMapper.xml | 28 ++++++++++++++++++++++++++++ 1 files changed, 28 insertions(+), 0 deletions(-) diff --git a/src/main/resources/mapper/modules/VideoMemberMapper.xml b/src/main/resources/mapper/modules/VideoMemberMapper.xml index 25fcbb8..9c1b101 100644 --- a/src/main/resources/mapper/modules/VideoMemberMapper.xml +++ b/src/main/resources/mapper/modules/VideoMemberMapper.xml @@ -14,4 +14,32 @@ select * from video_member where account=#{account} and password=#{password} </select> + <select id="selectVideoMemberListInPage" resultType="cc.mrbird.febs.video.entity.VideoMemberEntity"> + SELECT m.*,a.name referrerName,IFNULL(c.balance,0) balance FROM mall_member m + left join mall_member a on m.referrer_id = a.invite_id + LEFT JOIN mall_member_wallet c on c.member_id = m.id + <where> + <if test="record != null" > + <if test="record.name!=null and record.name!=''"> + and m.name like concat('%', #{record.name},'%') + </if> + <if test="record.account!=null and record.account!=''"> + and ( + m.phone like concat('%', #{record.account},'%') + or m.email like concat('%', #{record.account},'%') + or m.bind_phone like concat('%', #{record.account},'%') + or m.invite_id like concat('%', #{record.account},'%') + ) + </if> + <if test="record.accountStatus!=null"> + and m.account_status = #{record.accountStatus} + </if> + <if test="record.accountType != null" > + and m.account_type = #{record.accountType} + </if> + </if> + </where> + order by m.CREATED_TIME desc + </select> + </mapper> \ No newline at end of file -- Gitblit v1.9.1