From 33aa0f005c1952dda7dc1f713b424a6700a6befd Mon Sep 17 00:00:00 2001
From: zxl <763096477@qq.com>
Date: 星期三, 04 六月 2025 11:42:44 +0800
Subject: [PATCH] 用户权限管理(商家)
---
buyer-api/src/main/java/cn/lili/controller/lmk/StoreMemberController.java | 75 +++++++
framework/src/main/java/cn/lili/modules/lmk/domain/query/StoreMemberQuery.java | 22 ++
framework/src/main/java/cn/lili/modules/lmk/service/StoreMemberService.java | 67 ++++++
framework/src/main/java/cn/lili/modules/lmk/domain/form/StoreMemberForm.java | 51 +++++
framework/src/main/java/cn/lili/modules/lmk/domain/vo/StoreMemberVO.java | 58 +++++
framework/src/main/java/cn/lili/modules/lmk/service/impl/StoreMemberServiceImpl.java | 169 ++++++++++++++++
framework/src/main/java/cn/lili/modules/lmk/domain/entity/StoreMember.java | 35 +++
framework/src/main/java/cn/lili/modules/lmk/mapper/StoreMemberMapper.java | 33 +++
framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java | 15 +
framework/src/main/java/cn/lili/modules/member/service/MemberService.java | 9
framework/src/main/resources/mapper/lmk/StoreMemberMapper.xml | 61 ++++++
11 files changed, 595 insertions(+), 0 deletions(-)
diff --git a/buyer-api/src/main/java/cn/lili/controller/lmk/StoreMemberController.java b/buyer-api/src/main/java/cn/lili/controller/lmk/StoreMemberController.java
new file mode 100644
index 0000000..1336c10
--- /dev/null
+++ b/buyer-api/src/main/java/cn/lili/controller/lmk/StoreMemberController.java
@@ -0,0 +1,75 @@
+package cn.lili.controller.lmk;
+
+
+import cn.lili.base.Result;
+import cn.lili.group.Add;
+import cn.lili.group.Update;
+import cn.lili.modules.lmk.domain.form.StoreMemberForm;
+import cn.lili.modules.lmk.domain.query.StoreMemberQuery;
+import cn.lili.modules.lmk.service.StoreMemberService;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.security.access.prepost.PreAuthorize;
+import lombok.RequiredArgsConstructor;
+import java.util.List;
+import javax.validation.constraints.NotEmpty;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.web.bind.annotation.*;
+
+/**
+ * 鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗) 鍓嶇鎺у埗鍣�
+ *
+ * @author zxl
+ * @since 2025-05-30
+ */
+@Validated
+@RequiredArgsConstructor
+@Api(value = "鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)", tags = "鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)绠＄悊")
+@RestController
+@RequestMapping("/buyer/lmk/lmk-user-permissions")
+public class StoreMemberController {
+ // store_member
+ private final StoreMemberService storeMemberService;
+
+ @PostMapping
+ @ApiOperation(value = "娣诲姞", notes = "娣诲姞")
+ public Result add(@RequestBody @Validated(Add.class) StoreMemberForm form) {
+ return storeMemberService.add(form);
+ }
+
+ @PutMapping
+ @ApiOperation(value = "淇敼", notes = "淇敼")
+ public Result update(@RequestBody @Validated(Update.class) StoreMemberForm form) {
+ return storeMemberService.update(form);
+ }
+
+ @DeleteMapping("/{id}")
+ @ApiOperation(value = "ID鍒犻櫎", notes = "ID鍒犻櫎")
+ public Result removeById(@PathVariable("id") String id) {
+ return storeMemberService.removeById(id);
+ }
+
+ @DeleteMapping("/batch")
+ @ApiOperation(value = "鎵归噺鍒犻櫎", notes = "鎵归噺鍒犻櫎")
+ public Result remove(@RequestBody @NotEmpty(message = "璇烽�夋嫨鏁版嵁") List<String> ids) {
+ return storeMemberService.remove(ids);
+ }
+
+ @GetMapping("/page")
+ @ApiOperation(value = "鍒嗛〉", notes = "鍒嗛〉")
+ public Result page(StoreMemberQuery query) {
+ return storeMemberService.page(query);
+ }
+
+ @GetMapping("/{id}")
+ @ApiOperation(value = "璇︽儏", notes = "璇︽儏")
+ public Result detail(@PathVariable("id") String id) {
+ return storeMemberService.detail(id);
+ }
+
+ @GetMapping("/list")
+ @ApiOperation(value = "鍒楄〃", notes = "鍒楄〃")
+ public Result list() {
+ return storeMemberService.all();
+ }
+}
diff --git a/framework/src/main/java/cn/lili/modules/lmk/domain/entity/StoreMember.java b/framework/src/main/java/cn/lili/modules/lmk/domain/entity/StoreMember.java
new file mode 100644
index 0000000..c024434
--- /dev/null
+++ b/framework/src/main/java/cn/lili/modules/lmk/domain/entity/StoreMember.java
@@ -0,0 +1,35 @@
+package cn.lili.modules.lmk.domain.entity;
+
+import cn.lili.mybatis.BaseEntity;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+import java.io.Serializable;
+import lombok.Data;
+
+/**
+ * 鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)
+ *
+ * @author zxl
+ * @since 2025-05-30
+ */
+@Data
+@TableName("lmk_store_member")
+public class StoreMember extends BaseEntity {
+
+ private static final long serialVersionUID = 1L;
+
+ @TableField("real_name")
+ /** 鐪熷疄濮撳悕 */
+ private String realName;
+
+ @TableField("role")
+ /** 瑙掕壊 */
+ private String role;
+
+ @TableField("member_id")
+ /** 浼氬憳鐢ㄦ埛id */
+ private String memberId;
+ /** 鍟嗘埛id */
+ @TableField("store_id")
+ private String storeId;
+}
diff --git a/framework/src/main/java/cn/lili/modules/lmk/domain/form/StoreMemberForm.java b/framework/src/main/java/cn/lili/modules/lmk/domain/form/StoreMemberForm.java
new file mode 100644
index 0000000..183348b
--- /dev/null
+++ b/framework/src/main/java/cn/lili/modules/lmk/domain/form/StoreMemberForm.java
@@ -0,0 +1,51 @@
+package cn.lili.modules.lmk.domain.form;
+
+import cn.lili.base.AbsForm;
+import cn.lili.group.Add;
+import cn.lili.group.Update;
+import cn.lili.modules.lmk.domain.entity.StoreMember;
+import org.springframework.beans.BeanUtils;
+import javax.validation.constraints.NotBlank;
+
+import org.springframework.lang.NonNull;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+/**
+ * 鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)琛ㄥ崟
+ *
+ * @author zxl
+ * @since 2025-05-30
+ */
+@Data
+@ApiModel(value = "LmkUserPermissions琛ㄥ崟", description = "鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)琛ㄥ崟")
+public class StoreMemberForm extends AbsForm {
+
+ @NotBlank(message = "鐪熷疄濮撳悕涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("鐪熷疄濮撳悕")
+ private String realName;
+
+ @NotBlank(message = "鐢佃瘽鍙风爜涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("鐢佃瘽鍙风爜")
+ private String mobile;
+
+ @NotBlank(message = "瀵嗙爜涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("瀵嗙爜")
+ private String password;
+
+
+ @NotBlank(message = "瑙掕壊涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("瑙掕壊Json瀛楃涓�")
+ private String role;
+
+
+ public static StoreMember getEntityByForm(@NonNull StoreMemberForm form, StoreMember entity) {
+ if(entity == null) {
+ entity = new StoreMember();
+ }
+ BeanUtils.copyProperties(form, entity);
+ return entity;
+ }
+
+}
diff --git a/framework/src/main/java/cn/lili/modules/lmk/domain/query/StoreMemberQuery.java b/framework/src/main/java/cn/lili/modules/lmk/domain/query/StoreMemberQuery.java
new file mode 100644
index 0000000..b5f9686
--- /dev/null
+++ b/framework/src/main/java/cn/lili/modules/lmk/domain/query/StoreMemberQuery.java
@@ -0,0 +1,22 @@
+package cn.lili.modules.lmk.domain.query;
+
+import cn.lili.base.AbsQuery;
+import io.swagger.annotations.ApiModel;
+import lombok.Data;
+
+/**
+ * 鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)鏌ヨ
+ *
+ * @author zxl
+ * @since 2025-05-30
+ */
+@Data
+@ApiModel(value = "LmkUserPermissions鏌ヨ鍙傛暟", description = "鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)鏌ヨ鍙傛暟")
+public class StoreMemberQuery extends AbsQuery {
+
+ /** 鐪熷疄濮撳悕*/
+ private String realName;
+ /** 搴楅摵id */
+ private String storeId;
+}
+
diff --git a/framework/src/main/java/cn/lili/modules/lmk/domain/vo/StoreMemberVO.java b/framework/src/main/java/cn/lili/modules/lmk/domain/vo/StoreMemberVO.java
new file mode 100644
index 0000000..6c462bd
--- /dev/null
+++ b/framework/src/main/java/cn/lili/modules/lmk/domain/vo/StoreMemberVO.java
@@ -0,0 +1,58 @@
+package cn.lili.modules.lmk.domain.vo;
+
+
+import cn.lili.base.AbsVo;
+import cn.lili.modules.lmk.domain.entity.StoreMember;
+import org.springframework.lang.NonNull;
+import org.springframework.beans.BeanUtils;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+/**
+ * 鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)灞曠ず
+ *
+ * @author zxl
+ * @since 2025-05-30
+ */
+@Data
+@ApiModel(value = "鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)鍝嶅簲鏁版嵁", description = "鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)鍝嶅簲鏁版嵁")
+public class StoreMemberVO extends AbsVo {
+
+ /** 鐢佃瘽 */
+ @ApiModelProperty("鐢佃瘽")
+ private String mobile;
+
+ /** 鐢ㄦ埛鍚� */
+ @ApiModelProperty("鐢ㄦ埛鍚�")
+ private String userName;
+
+ /** 鐪熷疄濮撳悕 */
+ @ApiModelProperty("鐪熷疄濮撳悕")
+ private String realName;
+
+ /** 瀵嗙爜 */
+ @ApiModelProperty("瀵嗙爜")
+ private String password;
+
+ /** 瑙掕壊 */
+ @ApiModelProperty("瑙掕壊")
+ private String role;
+
+ /** 鐢ㄦ埛id */
+ @ApiModelProperty("鐢ㄦ埛id")
+ private String memberId;
+
+ /** 搴楅摵id */
+ @ApiModelProperty("搴楅摵id")
+ private String storeId;
+
+ public static StoreMemberVO getVoByEntity(@NonNull StoreMember entity, StoreMemberVO vo) {
+ if(vo == null) {
+ vo = new StoreMemberVO();
+ }
+ BeanUtils.copyProperties(entity, vo);
+ return vo;
+ }
+
+}
diff --git a/framework/src/main/java/cn/lili/modules/lmk/mapper/StoreMemberMapper.java b/framework/src/main/java/cn/lili/modules/lmk/mapper/StoreMemberMapper.java
new file mode 100644
index 0000000..23e19c2
--- /dev/null
+++ b/framework/src/main/java/cn/lili/modules/lmk/mapper/StoreMemberMapper.java
@@ -0,0 +1,33 @@
+package cn.lili.modules.lmk.mapper;
+
+import cn.lili.modules.lmk.domain.entity.StoreMember;
+import cn.lili.modules.lmk.domain.query.StoreMemberQuery;
+import cn.lili.modules.lmk.domain.vo.StoreMemberVO;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+/**
+ * 鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗) Mapper 鎺ュ彛
+ *
+ * @author zxl
+ * @since 2025-05-30
+ */
+@Mapper
+public interface StoreMemberMapper extends BaseMapper<StoreMember> {
+
+ /**
+ * id鏌ユ壘鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗)
+ * @param id
+ * @return
+ */
+ StoreMemberVO getById(String id);
+
+ /**
+ * 鍒嗛〉
+ */
+ IPage getPage(IPage page, @Param("query") StoreMemberQuery query);
+
+}
diff --git a/framework/src/main/java/cn/lili/modules/lmk/service/StoreMemberService.java b/framework/src/main/java/cn/lili/modules/lmk/service/StoreMemberService.java
new file mode 100644
index 0000000..7eb7339
--- /dev/null
+++ b/framework/src/main/java/cn/lili/modules/lmk/service/StoreMemberService.java
@@ -0,0 +1,67 @@
+package cn.lili.modules.lmk.service;
+
+
+import cn.lili.base.Result;
+import cn.lili.modules.lmk.domain.entity.StoreMember;
+import cn.lili.modules.lmk.domain.form.StoreMemberForm;
+import cn.lili.modules.lmk.domain.query.StoreMemberQuery;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+import java.util.List;
+
+/**
+ * 鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗) 鏈嶅姟绫�
+ *
+ * @author zxl
+ * @since 2025-05-30
+ */
+public interface StoreMemberService extends IService<StoreMember> {
+
+ /**
+ * 娣诲姞
+ * @param form
+ * @return
+ */
+ Result add(StoreMemberForm form);
+
+ /**
+ * 淇敼
+ * @param form
+ * @return
+ */
+ Result update(StoreMemberForm form);
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ Result remove(List<String> ids);
+
+ /**
+ * id鍒犻櫎
+ * @param id
+ * @return
+ */
+ Result removeById(String id);
+
+ /**
+ * 鍒嗛〉鏌ヨ
+ * @param query
+ * @return
+ */
+ Result page(StoreMemberQuery query);
+
+ /**
+ * 鏍规嵁id鏌ユ壘
+ * @param id
+ * @return
+ */
+ Result detail(String id);
+
+ /**
+ * 鍒楄〃
+ * @return
+ */
+ Result all();
+}
diff --git a/framework/src/main/java/cn/lili/modules/lmk/service/impl/StoreMemberServiceImpl.java b/framework/src/main/java/cn/lili/modules/lmk/service/impl/StoreMemberServiceImpl.java
new file mode 100644
index 0000000..bc19a15
--- /dev/null
+++ b/framework/src/main/java/cn/lili/modules/lmk/service/impl/StoreMemberServiceImpl.java
@@ -0,0 +1,169 @@
+package cn.lili.modules.lmk.service.impl;
+
+import cn.lili.base.Result;
+
+import cn.lili.common.security.AuthUser;
+import cn.lili.common.security.context.UserContext;
+import cn.lili.modules.lmk.domain.entity.StoreMember;
+import cn.lili.modules.lmk.domain.form.StoreMemberForm;
+import cn.lili.modules.lmk.domain.query.StoreMemberQuery;
+import cn.lili.modules.lmk.domain.vo.StoreMemberVO;
+import cn.lili.modules.lmk.mapper.StoreMemberMapper;
+import cn.lili.modules.lmk.service.StoreMemberService;
+import cn.lili.modules.member.entity.dos.Member;
+import cn.lili.modules.member.entity.dto.ManagerMemberEditDTO;
+import cn.lili.modules.member.entity.dto.MemberAddDTO;
+import cn.lili.modules.member.service.MemberService;
+import cn.lili.utils.PageUtil;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+
+import org.springframework.stereotype.Service;
+import lombok.RequiredArgsConstructor;
+
+import org.springframework.beans.BeanUtils;
+import org.springframework.util.Assert;
+
+import java.util.List;
+import java.util.stream.Collectors;
+
+/**
+ * 鐢ㄦ埛鏉冮檺绠＄悊(鍟嗗) 鏈嶅姟瀹炵幇绫�
+ *
+ * @author zxl
+ * @since 2025-05-30
+ */
+@Service
+@RequiredArgsConstructor
+public class StoreMemberServiceImpl extends ServiceImpl<StoreMemberMapper, StoreMember> implements StoreMemberService {
+
+ private final StoreMemberMapper storeMemberMapper;
+
+ private final MemberService memberService;
+ /**
+ * 娣诲姞
+ * @param form
+ * @return
+ */
+ @Override
+ public Result add(StoreMemberForm form) {
+ //鎻掑叆鍒扮敤鎴疯〃涓�
+ AuthUser currentUser = UserContext.getCurrentUser();
+ String id = currentUser.getId();
+// String storeId = currentUser.getStoreId();
+ String storeId = "12312323123";
+ if (id == null || storeId == null) {
+ return Result.error("褰撳墠鐧诲綍璐︽埛鏈粦瀹氬晢鎴锋垨鐢ㄦ埛id鑾峰彇寮傚父");
+ }
+
+ //鎻掑叆浼氬憳琛�
+ MemberAddDTO addDTO = new MemberAddDTO();
+ addDTO.setMobile(form.getMobile());
+ addDTO.setPassword(form.getPassword());
+ addDTO.setUsername(form.getMobile());
+
+ Member member = memberService.addMember(addDTO);
+
+ //鎻掑叆鐢ㄦ埛鏉冮檺琛�
+ //id鎻掑叆闂
+ StoreMember entity = StoreMemberForm.getEntityByForm(form, null);
+ entity.setMemberId(member.getId());
+ entity.setStoreId(storeId);
+
+ baseMapper.insert(entity);
+ return Result.ok("娣诲姞鎴愬姛");
+ }
+
+ /**
+ * 淇敼
+ * @param form
+ * @return
+ */
+ @Override
+ public Result update(StoreMemberForm form) {
+ StoreMember entity = baseMapper.selectById(form.getId());
+
+ //TODO 鏄惁闇�瑕佸垽鏂瘑鐮佹柊瀵嗙爜
+ //浼氬憳淇敼瀵嗙爜锛岀數璇�
+ memberService.updateMemberPartProperties(entity.getMemberId(),form.getPassword(),form.getMobile());
+
+ //淇敼鐪熷疄濮撳悕
+ entity.setRealName(form.getRealName());
+ entity.setRole(form.getRole());
+ baseMapper.updateById(entity);
+ return Result.ok("淇敼鎴愬姛");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ @Override
+ public Result remove(List<String> ids) {
+ baseMapper.deleteBatchIds(ids);
+ return Result.ok("鍒犻櫎鎴愬姛");
+ }
+
+ /**
+ * id鍒犻櫎
+ * @param id
+ * @return
+ */
+ @Override
+ public Result removeById(String id) {
+ StoreMember entity = baseMapper.selectById(id);
+ memberService.removeById(entity.getMemberId());
+ baseMapper.deleteById(id);
+ //鍚屾椂鍒犻櫎鐢ㄦ埛
+
+
+ return Result.ok("鍒犻櫎鎴愬姛");
+ }
+
+ /**
+ * 鍒嗛〉鏌ヨ
+ * @param query
+ * @return
+ */
+ @Override
+ public Result page(StoreMemberQuery query) {
+ AuthUser currentUser = UserContext.getCurrentUser();
+// String storeId = currentUser.getStoreId();
+ String storeId = "12312323123";
+ if (storeId == null) {
+ return Result.error("褰撳墠鐧诲綍璐︽埛鏈粦瀹氬晢鎴锋垨鐢ㄦ埛id鑾峰彇寮傚父");
+ }
+ IPage<StoreMemberVO> page = PageUtil.getPage(query, StoreMemberVO.class);
+ query.setStoreId(storeId);
+ baseMapper.getPage(page, query);
+ return Result.ok().data(page.getRecords()).total(page.getTotal());
+ }
+
+ /**
+ * 鏍规嵁id鏌ユ壘
+ * @param id
+ * @return
+ */
+ @Override
+ public Result detail(String id) {
+ StoreMemberVO vo = baseMapper.getById(id);
+ //瀵嗙爜鏄惁闇�瑕佽В瀵�
+
+ Assert.notNull(vo, "璁板綍涓嶅瓨鍦�");
+ return Result.ok().data(vo);
+ }
+
+ /**
+ * 鍒楄〃
+ * @return
+ */
+ @Override
+ public Result all() {
+ List<StoreMember> entities = baseMapper.selectList(null);
+ List<StoreMemberVO> vos = entities.stream()
+ .map(entity -> StoreMemberVO.getVoByEntity(entity, null))
+ .collect(Collectors.toList());
+ return Result.ok().data(vos);
+ }
+}
diff --git a/framework/src/main/java/cn/lili/modules/member/service/MemberService.java b/framework/src/main/java/cn/lili/modules/member/service/MemberService.java
index 79c9d4e..614446c 100644
--- a/framework/src/main/java/cn/lili/modules/member/service/MemberService.java
+++ b/framework/src/main/java/cn/lili/modules/member/service/MemberService.java
@@ -27,6 +27,15 @@
*/
public interface MemberService extends IService<Member> {
/**
+ * 鐢ㄦ埛鏉冮檺绠＄悊淇敼鐢ㄦ埛
+ * @param id 浼氬憳id
+ * @param password 瀵嗙爜
+ * @param mobile 鐢佃瘽锛堣处鍙凤級
+ * @return
+ */
+ Member updateMemberPartProperties(String id,String password,String mobile);
+
+ /**
* 榛樿瀵嗙爜
*/
static String DEFAULT_PASSWORD = "111111";
diff --git a/framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java b/framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java
index ddcd129..3cfd13a 100644
--- a/framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java
+++ b/framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java
@@ -502,6 +502,21 @@
return member;
}
+
+ @Override
+ public Member updateMemberPartProperties(String id,String password,String mobile) {
+ //鏌ヨ浼氬憳淇℃伅
+ Member member = this.getById(id);
+ //濡傛灉瀵嗙爜涓嶄负绌哄垯鍔犲瘑瀵嗙爜
+ if (CharSequenceUtil.isNotBlank(password)) {
+ member.setPassword(new BCryptPasswordEncoder().encode(password));
+ }
+ member.setMobile(mobile);
+ member.setUsername(mobile);
+ this.updateById(member);
+ return member;
+ }
+
@Override
public IPage<MemberVO> getMemberPage(MemberSearchVO memberSearchVO, PageVO page) {
QueryWrapper<Member> queryWrapper = Wrappers.query();
diff --git a/framework/src/main/resources/mapper/lmk/StoreMemberMapper.xml b/framework/src/main/resources/mapper/lmk/StoreMemberMapper.xml
new file mode 100644
index 0000000..e40eeb7
--- /dev/null
+++ b/framework/src/main/resources/mapper/lmk/StoreMemberMapper.xml
@@ -0,0 +1,61 @@
+<?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="cn.lili.modules.lmk.mapper.StoreMemberMapper">
+
+ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+ <resultMap id="BaseResultMap" type="cn.lili.modules.lmk.domain.vo.StoreMemberVO">
+ <result column="real_name" property="realName" />
+ <result column="mobile" property="mobile" />
+ <result column="password" property="password" />
+ <result column="role" property="role" />
+ <result column="create_by" property="createBy" />
+ <result column="create_time" property="createTime" />
+ <result column="update_by" property="updateBy" />
+ <result column="update_time" property="updateTime" />
+ <result column="delete_flag" property="deleteFlag" />
+
+ <result column="store_id" property="storeId" />
+ <result column="member_id" property="memberId" />
+ <result column="username" property="userName" />
+ </resultMap>
+
+
+ <select id="getById" resultMap="BaseResultMap">
+ SELECT
+ LSM.id,
+ LSM.real_name,
+ LSM.role,
+ LSM.store_id,
+ LSM.member_id,
+ LM.mobile,
+ LM.username
+ FROM lmk_store_member LSM
+ LEFT JOIN li_member LM
+ ON LM.id = LSM.member_id
+ where LSM.delete_flag = 0
+ AND LM.delete_flag = 0
+ AND LSM.id = #{id}
+ </select>
+
+
+ <select id="getPage" resultMap="BaseResultMap">
+ SELECT
+ LSM.id,
+ LSM.real_name,
+ LSM.role,
+ LSM.store_id,
+ LSM.member_id,
+ LM.mobile,
+ LM.username
+ FROM lmk_store_member LSM
+ LEFT JOIN li_member LM
+ ON LM.id = LSM.member_id
+ where LSM.delete_flag = 0
+ AND LM.delete_flag = 0
+ <if test="query.realName != null and query.realName != ''">
+ AND LSM.real_name LIKE CONCAT('%', #{query.realName}, '%')
+ </if>
+ AND LSM.store_id = #{query.storeId}
+ </select>
+
+</mapper>
--
Gitblit v1.8.0