From 0411eeb918e0e09aa15cbefd0f9179932375757b Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期一, 13 五月 2024 17:18:57 +0800 Subject: [PATCH] 最新版本 --- server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/MemberMapper.java | 13 ------------- 1 files changed, 0 insertions(+), 13 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/MemberMapper.java b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/MemberMapper.java index 8ef6f07..58e60bb 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/MemberMapper.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/MemberMapper.java @@ -4,8 +4,6 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.Constants; -import com.doumee.dao.admin.response.MemberInfoDTO; -import com.doumee.dao.business.model.CarEvent; import com.doumee.dao.business.model.Member; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; @@ -17,17 +15,6 @@ * @date 2023/11/30 15:33 */ public interface MemberMapper extends BaseMapper<Member> { - - - @Select(" select m.* , c.name as companyName , " + - " (select count(0) from member_card mc where mc.MEMBER_ID=m.id and mc.ISDELETED=0) as memberCardCount, " + - " (select GROUP_CONCAT(dr.name) from member_role mr left join device_role dr on dr.id=mr.ROLE_ID " + - " where mr.MEMBER_ID=m.id and mr.ISDELETED=0 GROUP BY mr.MEMBER_ID) as roleName "+ - " from member m " + - " left join company c on m.COMPANY_ID=c.id "+ - " ${ew.customSqlSegment} ") - IPage<MemberInfoDTO> getPage(IPage<MemberInfoDTO> page, @Param(Constants.WRAPPER) Wrapper wrapper); - void insertBatchSomeColumn(List<Member> list); } -- Gitblit v1.9.3