From c25d93c39975f84ca411da16b82ab556648a50e0 Mon Sep 17 00:00:00 2001
From: 龚焕茏 <2842157468@qq.com>
Date: 星期三, 22 五月 2024 15:21:44 +0800
Subject: [PATCH] feat：用户状况新增审核
---
src/main/java/com/mindskip/xzs/service/impl/UserServiceImpl.java | 2
src/main/java/com/mindskip/xzs/controller/admin/UserConditionExamineController.java | 54 +++++++
src/main/java/com/mindskip/xzs/service/DepartmentExamineService.java | 2
src/main/java/com/mindskip/xzs/domain/enums/DepartmentExamineEnum.java | 2
src/main/java/com/mindskip/xzs/controller/admin/UserController.java | 6
src/main/java/com/mindskip/xzs/repository/UserMapper.java | 3
src/main/resources/mapper/UserMapper.xml | 9
src/main/java/com/mindskip/xzs/domain/enums/UserConditionExamineEnum.java | 32 ++++
src/main/java/com/mindskip/xzs/domain/vo/UserConditionExamineVO.java | 84 ++++++++++++
src/main/java/com/mindskip/xzs/service/impl/DepartmentExamineServiceImpl.java | 4
src/main/java/com/mindskip/xzs/service/UserConditionExamineService.java | 21 +++
src/main/java/com/mindskip/xzs/domain/UserConditionExamine.java | 77 +++++++++++
src/main/java/com/mindskip/xzs/controller/admin/DepartmentExamineController.java | 4
src/main/resources/mapper/UserConditionExamineMapper.xml | 29 ++++
src/main/java/com/mindskip/xzs/domain/vo/DepartmentExamineVO.java | 3
src/main/java/com/mindskip/xzs/service/impl/UserConditionExamineServiceImpl.java | 54 +++++++
src/main/java/com/mindskip/xzs/repository/UserConditionExamineMapper.java | 22 +++
src/main/java/com/mindskip/xzs/service/UserService.java | 3
18 files changed, 389 insertions(+), 22 deletions(-)
diff --git a/src/main/java/com/mindskip/xzs/controller/admin/DepartmentExamineController.java b/src/main/java/com/mindskip/xzs/controller/admin/DepartmentExamineController.java
index 8205e50..e4cbe61 100644
--- a/src/main/java/com/mindskip/xzs/controller/admin/DepartmentExamineController.java
+++ b/src/main/java/com/mindskip/xzs/controller/admin/DepartmentExamineController.java
@@ -6,7 +6,7 @@
import com.mindskip.xzs.base.RestResponse;
import com.mindskip.xzs.domain.DepartmentExamine;
import com.mindskip.xzs.domain.vo.DepartmentExamineVO;
-import com.mindskip.xzs.service.IDepartmentExamineService;
+import com.mindskip.xzs.service.DepartmentExamineService;
import lombok.RequiredArgsConstructor;
import org.apache.commons.lang3.ObjectUtils;
import org.springframework.web.bind.annotation.*;
@@ -26,7 +26,7 @@
@RequiredArgsConstructor
public class DepartmentExamineController extends BaseApiController {
- private final IDepartmentExamineService departmentExamineService;
+ private final DepartmentExamineService departmentExamineService;
@RequestMapping(value = "list", method = RequestMethod.POST)
public RestResponse<PageInfo<DepartmentExamineVO>> list(@RequestBody DepartmentExamineVO departmentExamineVO) {
diff --git a/src/main/java/com/mindskip/xzs/controller/admin/UserConditionExamineController.java b/src/main/java/com/mindskip/xzs/controller/admin/UserConditionExamineController.java
new file mode 100644
index 0000000..0a782c3
--- /dev/null
+++ b/src/main/java/com/mindskip/xzs/controller/admin/UserConditionExamineController.java
@@ -0,0 +1,54 @@
+package com.mindskip.xzs.controller.admin;
+
+
+import com.github.pagehelper.PageInfo;
+import com.mindskip.xzs.base.BaseApiController;
+import com.mindskip.xzs.base.RestResponse;
+import com.mindskip.xzs.domain.UserConditionExamine;
+import com.mindskip.xzs.domain.vo.UserConditionExamineVO;
+import com.mindskip.xzs.service.UserConditionExamineService;
+import lombok.RequiredArgsConstructor;
+import org.apache.commons.lang3.ObjectUtils;
+import org.springframework.web.bind.annotation.*;
+
+import java.time.LocalDateTime;
+
+/**
+ * <p>
+ * 鐢ㄦ埛鐘跺喌琛� 鍓嶇鎺у埗鍣�
+ * </p>
+ *
+ * @author gonghl
+ * @since 2024-05-22
+ */
+@RestController
+@RequestMapping("/api/admin/userCondition/examine")
+@RequiredArgsConstructor
+public class UserConditionExamineController extends BaseApiController {
+
+ private final UserConditionExamineService userConditionExamineService;
+
+ @RequestMapping(value = "list", method = RequestMethod.POST)
+ public RestResponse<PageInfo<UserConditionExamineVO>> list(@RequestBody UserConditionExamineVO userConditionExamineVO) {
+ userConditionExamineVO.setDeptIds(ObjectUtils.isNotEmpty(userConditionExamineVO.getDeptIds()) ? userConditionExamineVO.getDeptIds() : getAdminDeptIds());
+ return RestResponse.ok(userConditionExamineService.pageInfo(userConditionExamineVO));
+ }
+
+ @RequestMapping(value = "save", method = RequestMethod.POST)
+ public RestResponse<Boolean> save(@RequestBody UserConditionExamine userConditionExamine) {
+ userConditionExamine.setCreateTime(LocalDateTime.now());
+ userConditionExamine.setCreateUser(getCurrentUser().getId());
+ return RestResponse.ok(userConditionExamineService.save(userConditionExamine));
+ }
+
+ @RequestMapping(value = "delete/{id}", method = RequestMethod.POST)
+ public RestResponse<Boolean> delete(@PathVariable Integer id) {
+ return RestResponse.ok(userConditionExamineService.removeById(id));
+ }
+
+ @RequestMapping(value = "audit", method = RequestMethod.POST)
+ public RestResponse<Boolean> audit(@RequestBody UserConditionExamineVO userConditionExamine) {
+ return RestResponse.ok(userConditionExamineService.audit(userConditionExamine));
+ }
+
+}
diff --git a/src/main/java/com/mindskip/xzs/controller/admin/UserController.java b/src/main/java/com/mindskip/xzs/controller/admin/UserController.java
index 278505d..8b9b82d 100644
--- a/src/main/java/com/mindskip/xzs/controller/admin/UserController.java
+++ b/src/main/java/com/mindskip/xzs/controller/admin/UserController.java
@@ -230,10 +230,4 @@
return RestResponse.ok();
}
- @RequestMapping(value = "/setStatus", method = RequestMethod.POST)
- public RestResponse<String> setStatus(@RequestBody UserVO user) {
- userService.setStatus(user);
- return RestResponse.ok("鎿嶄綔鎴愬姛");
- }
-
}
diff --git a/src/main/java/com/mindskip/xzs/domain/UserConditionExamine.java b/src/main/java/com/mindskip/xzs/domain/UserConditionExamine.java
new file mode 100644
index 0000000..4c7dc1d
--- /dev/null
+++ b/src/main/java/com/mindskip/xzs/domain/UserConditionExamine.java
@@ -0,0 +1,77 @@
+package com.mindskip.xzs.domain;
+
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableLogic;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.mindskip.xzs.domain.enums.UserConditionEnum;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.experimental.Accessors;
+
+import java.io.Serializable;
+import java.time.LocalDateTime;
+
+/**
+ * <p>
+ * 鐢ㄦ埛鐘跺喌瀹℃牳琛�
+ * </p>
+ *
+ * @author gonghl
+ * @since 2024-05-22
+ */
+@Data
+@EqualsAndHashCode(callSuper = false)
+@Accessors(chain = true)
+@TableName("t_user_condition_examine")
+public class UserConditionExamine implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ @TableId(value = "id", type = IdType.AUTO)
+ private Integer id;
+
+ /**
+ * 鐢ㄦ埛id
+ */
+ private Integer userId;
+
+ /**
+ * 鐩爣鐘跺喌
+ */
+ private UserConditionEnum targetCondition;
+
+ /**
+ * 鍘熷鐘跺喌
+ */
+ private UserConditionEnum sourceCondition;
+
+ /**
+ * 闄勪欢
+ */
+ private String attachment;
+
+ /**
+ * 璋冨姩鍘熷洜
+ */
+ private String reason;
+
+ /**
+ * 瀹℃牳缁撴灉
+ */
+ private UserConditionEnum result;
+
+ /**
+ * 瀹℃牳澶囨敞
+ */
+ private String remark;
+
+ private Integer createUser;
+
+ private LocalDateTime createTime;
+
+ @TableLogic
+ private Boolean deleted;
+
+
+}
diff --git a/src/main/java/com/mindskip/xzs/domain/enums/DepartmentExamineEnum.java b/src/main/java/com/mindskip/xzs/domain/enums/DepartmentExamineEnum.java
index 1a72054..cbe6c3a 100644
--- a/src/main/java/com/mindskip/xzs/domain/enums/DepartmentExamineEnum.java
+++ b/src/main/java/com/mindskip/xzs/domain/enums/DepartmentExamineEnum.java
@@ -5,7 +5,7 @@
import lombok.Getter;
/**
- * 鐢ㄦ埛鐘舵��
+ * 閮ㄩ棬瀹℃牳鐘舵��
*
* @author gonghl
*/
diff --git a/src/main/java/com/mindskip/xzs/domain/enums/UserConditionExamineEnum.java b/src/main/java/com/mindskip/xzs/domain/enums/UserConditionExamineEnum.java
new file mode 100644
index 0000000..1b3f341
--- /dev/null
+++ b/src/main/java/com/mindskip/xzs/domain/enums/UserConditionExamineEnum.java
@@ -0,0 +1,32 @@
+package com.mindskip.xzs.domain.enums;
+
+import com.baomidou.mybatisplus.annotation.EnumValue;
+import com.fasterxml.jackson.annotation.JsonValue;
+import lombok.Getter;
+
+/**
+ * 鐢ㄦ埛瀹℃牳鐘舵��
+ *
+ * @author gonghl
+ */
+@Getter
+public enum UserConditionExamineEnum {
+
+ WAIT("0", "寰呭鏍�"),
+ PASS("1", "瀹℃牳閫氳繃"),
+ OVERRULE("2", "瀹℃牳椹冲洖"),
+ ;
+
+
+ @EnumValue // 鏍囨槑璇ュ瓧娈靛瓨鍏ユ暟鎹簱
+ private final String code;
+
+ @JsonValue // 鏍囨槑鍦ㄨ浆JSON鏃朵娇鐢ㄨ瀛楁锛屽嵆鍝嶅簲鏃�
+ private final String desc;
+
+ UserConditionExamineEnum(String code, String desc) {
+ this.code = code;
+ this.desc = desc;
+ }
+
+}
diff --git a/src/main/java/com/mindskip/xzs/domain/vo/DepartmentExamineVO.java b/src/main/java/com/mindskip/xzs/domain/vo/DepartmentExamineVO.java
index 55cbfd8..81d0ab6 100644
--- a/src/main/java/com/mindskip/xzs/domain/vo/DepartmentExamineVO.java
+++ b/src/main/java/com/mindskip/xzs/domain/vo/DepartmentExamineVO.java
@@ -67,6 +67,9 @@
private Integer pageSize;
+ /**
+ * 閮ㄩ棬绠＄悊鍛樺彧鐪嬭嚜宸辩殑璁板綍
+ */
private List<Integer> deptIds;
/**
diff --git a/src/main/java/com/mindskip/xzs/domain/vo/UserConditionExamineVO.java b/src/main/java/com/mindskip/xzs/domain/vo/UserConditionExamineVO.java
new file mode 100644
index 0000000..57ea712
--- /dev/null
+++ b/src/main/java/com/mindskip/xzs/domain/vo/UserConditionExamineVO.java
@@ -0,0 +1,84 @@
+package com.mindskip.xzs.domain.vo;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import com.mindskip.xzs.domain.enums.DepartmentExamineEnum;
+import com.mindskip.xzs.domain.enums.UserConditionEnum;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.experimental.Accessors;
+
+import java.io.Serializable;
+import java.time.LocalDateTime;
+import java.util.List;
+
+/**
+ * <p>
+ * 鐢ㄦ埛鐘跺喌瀹℃牳琛�
+ * </p>
+ *
+ * @author gonghl
+ * @since 2024-05-22
+ */
+@Data
+@EqualsAndHashCode(callSuper = false)
+@Accessors(chain = true)
+public class UserConditionExamineVO implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ private Integer id;
+
+ /**
+ * 鐢ㄦ埛id
+ */
+ private Integer userId;
+ private String userName;
+
+ /**
+ * 鐩爣鐘跺喌
+ */
+ private UserConditionEnum targetCondition;
+
+ /**
+ * 鍘熷鐘跺喌
+ */
+ private UserConditionEnum sourceCondition;
+
+ /**
+ * 闄勪欢
+ */
+ private String attachment;
+
+ /**
+ * 璋冨姩鍘熷洜
+ */
+ private String reason;
+
+ private Integer createUser;
+ private String createUserName;
+
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private LocalDateTime createTime;
+
+ /**
+ * 瀹℃牳缁撴灉
+ */
+ private DepartmentExamineEnum result;
+
+ /**
+ * 瀹℃牳澶囨敞
+ */
+ private String remark;
+
+ private Boolean deleted;
+
+ private Integer pageIndex;
+
+ private Integer pageSize;
+
+ /**
+ * 閮ㄩ棬绠＄悊鍛樺彧鐪嬭嚜宸辩殑璁板綍
+ */
+ private List<Integer> deptIds;
+
+}
diff --git a/src/main/java/com/mindskip/xzs/repository/UserConditionExamineMapper.java b/src/main/java/com/mindskip/xzs/repository/UserConditionExamineMapper.java
new file mode 100644
index 0000000..8cebd8d
--- /dev/null
+++ b/src/main/java/com/mindskip/xzs/repository/UserConditionExamineMapper.java
@@ -0,0 +1,22 @@
+package com.mindskip.xzs.repository;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.mindskip.xzs.domain.UserConditionExamine;
+import com.mindskip.xzs.domain.vo.UserConditionExamineVO;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.util.List;
+
+/**
+ * <p>
+ * 鐢ㄦ埛鐘跺喌瀹℃牳琛� Mapper 鎺ュ彛
+ * </p>
+ *
+ * @author gonghl
+ * @since 2024-05-22
+ */
+@Mapper
+public interface UserConditionExamineMapper extends BaseMapper<UserConditionExamine> {
+
+ List<UserConditionExamineVO> pageInfo(UserConditionExamineVO userConditionExamineVO);
+}
diff --git a/src/main/java/com/mindskip/xzs/repository/UserMapper.java b/src/main/java/com/mindskip/xzs/repository/UserMapper.java
index 6ba4984..3a00eba 100644
--- a/src/main/java/com/mindskip/xzs/repository/UserMapper.java
+++ b/src/main/java/com/mindskip/xzs/repository/UserMapper.java
@@ -6,7 +6,6 @@
import com.mindskip.xzs.domain.User;
import com.mindskip.xzs.domain.other.KeyValue;
import com.mindskip.xzs.domain.vo.UpdateDeptAdminVO;
-import com.mindskip.xzs.domain.vo.UserVO;
import com.mindskip.xzs.viewmodel.admin.paper.ExamPaperGradeQuery;
import com.mindskip.xzs.viewmodel.admin.user.UserPageRequestVM;
import org.apache.ibatis.annotations.Mapper;
@@ -151,7 +150,7 @@
List<ExamPaperAnswer> getUserByDept(@Param("query") ExamPaperGradeQuery query);
- void setStatus(UserVO user);
+ void setStatus(User user);
/**
* 娓呴櫎鏌愰儴闂ㄧ殑鐢ㄦ埛绠＄悊鍛樻爣璇�
diff --git a/src/main/java/com/mindskip/xzs/service/IDepartmentExamineService.java b/src/main/java/com/mindskip/xzs/service/DepartmentExamineService.java
similarity index 85%
rename from src/main/java/com/mindskip/xzs/service/IDepartmentExamineService.java
rename to src/main/java/com/mindskip/xzs/service/DepartmentExamineService.java
index a07ddc2..6dad78b 100644
--- a/src/main/java/com/mindskip/xzs/service/IDepartmentExamineService.java
+++ b/src/main/java/com/mindskip/xzs/service/DepartmentExamineService.java
@@ -13,7 +13,7 @@
* @author gonghl
* @since 2024-05-13
*/
-public interface IDepartmentExamineService extends IService<DepartmentExamine> {
+public interface DepartmentExamineService extends IService<DepartmentExamine> {
PageInfo<DepartmentExamineVO> pageInfo(DepartmentExamineVO departmentExamineVO);
diff --git a/src/main/java/com/mindskip/xzs/service/UserConditionExamineService.java b/src/main/java/com/mindskip/xzs/service/UserConditionExamineService.java
new file mode 100644
index 0000000..d55162c
--- /dev/null
+++ b/src/main/java/com/mindskip/xzs/service/UserConditionExamineService.java
@@ -0,0 +1,21 @@
+package com.mindskip.xzs.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.github.pagehelper.PageInfo;
+import com.mindskip.xzs.domain.UserConditionExamine;
+import com.mindskip.xzs.domain.vo.UserConditionExamineVO;
+
+/**
+ * <p>
+ * 鐢ㄦ埛鐘跺喌琛� 鏈嶅姟绫�
+ * </p>
+ *
+ * @author gonghl
+ * @since 2024-05-22
+ */
+public interface UserConditionExamineService extends IService<UserConditionExamine> {
+
+ PageInfo<UserConditionExamineVO> pageInfo(UserConditionExamineVO userConditionExamineVO);
+
+ Boolean audit(UserConditionExamineVO userConditionExamine);
+}
diff --git a/src/main/java/com/mindskip/xzs/service/UserService.java b/src/main/java/com/mindskip/xzs/service/UserService.java
index 833fb39..c5dd26d 100644
--- a/src/main/java/com/mindskip/xzs/service/UserService.java
+++ b/src/main/java/com/mindskip/xzs/service/UserService.java
@@ -5,7 +5,6 @@
import com.mindskip.xzs.domain.ExamPaper;
import com.mindskip.xzs.domain.User;
import com.mindskip.xzs.domain.other.KeyValue;
-import com.mindskip.xzs.domain.vo.UserVO;
import com.mindskip.xzs.viewmodel.admin.user.UserPageRequestVM;
import java.util.List;
@@ -135,7 +134,7 @@
User getUserByRealName(String realName);
- void setStatus(UserVO user);
+ void setStatus(User user);
User getUserByExam(ExamPaper examPaper);
diff --git a/src/main/java/com/mindskip/xzs/service/impl/DepartmentExamineServiceImpl.java b/src/main/java/com/mindskip/xzs/service/impl/DepartmentExamineServiceImpl.java
index c4dc2da..392ebc4 100644
--- a/src/main/java/com/mindskip/xzs/service/impl/DepartmentExamineServiceImpl.java
+++ b/src/main/java/com/mindskip/xzs/service/impl/DepartmentExamineServiceImpl.java
@@ -7,7 +7,7 @@
import com.mindskip.xzs.domain.DepartmentExamine;
import com.mindskip.xzs.domain.vo.DepartmentExamineVO;
import com.mindskip.xzs.repository.DepartmentExamineMapper;
-import com.mindskip.xzs.service.IDepartmentExamineService;
+import com.mindskip.xzs.service.DepartmentExamineService;
import com.mindskip.xzs.service.UserDepartMentService;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Service;
@@ -23,7 +23,7 @@
*/
@Service
@RequiredArgsConstructor
-public class DepartmentExamineServiceImpl extends ServiceImpl<DepartmentExamineMapper, DepartmentExamine> implements IDepartmentExamineService {
+public class DepartmentExamineServiceImpl extends ServiceImpl<DepartmentExamineMapper, DepartmentExamine> implements DepartmentExamineService {
private final UserDepartMentService userDepartMentService;
diff --git a/src/main/java/com/mindskip/xzs/service/impl/UserConditionExamineServiceImpl.java b/src/main/java/com/mindskip/xzs/service/impl/UserConditionExamineServiceImpl.java
new file mode 100644
index 0000000..b046976
--- /dev/null
+++ b/src/main/java/com/mindskip/xzs/service/impl/UserConditionExamineServiceImpl.java
@@ -0,0 +1,54 @@
+package com.mindskip.xzs.service.impl;
+
+import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.github.pagehelper.PageHelper;
+import com.github.pagehelper.PageInfo;
+import com.mindskip.xzs.domain.User;
+import com.mindskip.xzs.domain.UserConditionExamine;
+import com.mindskip.xzs.domain.vo.UserConditionExamineVO;
+import com.mindskip.xzs.repository.UserConditionExamineMapper;
+import com.mindskip.xzs.service.UserConditionExamineService;
+import com.mindskip.xzs.service.UserService;
+import lombok.RequiredArgsConstructor;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+/**
+ * <p>
+ * 鐢ㄦ埛鐘跺喌琛� 鏈嶅姟瀹炵幇绫�
+ * </p>
+ *
+ * @author gonghl
+ * @since 2024-05-22
+ */
+@Service
+@RequiredArgsConstructor
+public class UserConditionExamineServiceImpl extends ServiceImpl<UserConditionExamineMapper, UserConditionExamine> implements UserConditionExamineService {
+
+ private final UserService userService;
+
+ @Override
+ public PageInfo<UserConditionExamineVO> pageInfo(UserConditionExamineVO userConditionExamineVO) {
+ return PageHelper.startPage(userConditionExamineVO.getPageIndex(), userConditionExamineVO.getPageSize(), "id desc").doSelectPageInfo(() ->
+ baseMapper.pageInfo(userConditionExamineVO)
+ );
+ }
+
+ @Override
+ @Transactional
+ public Boolean audit(UserConditionExamineVO userConditionExamine) {
+ // 瀹℃牳閫氳繃淇敼鐘跺喌
+ if ("1".equals(userConditionExamine.getResult().getCode())) {
+ User user = new User();
+ user.setId(userConditionExamine.getUserId());
+ user.setCondition(userConditionExamine.getTargetCondition());
+ userService.setStatus(user);
+ }
+ return new LambdaUpdateChainWrapper<>(baseMapper)
+ .eq(UserConditionExamine::getId, userConditionExamine.getId())
+ .set(UserConditionExamine::getResult, userConditionExamine.getResult())
+ .set(UserConditionExamine::getRemark, userConditionExamine.getRemark())
+ .update();
+ }
+}
diff --git a/src/main/java/com/mindskip/xzs/service/impl/UserServiceImpl.java b/src/main/java/com/mindskip/xzs/service/impl/UserServiceImpl.java
index 156f7f9..3435fbf 100644
--- a/src/main/java/com/mindskip/xzs/service/impl/UserServiceImpl.java
+++ b/src/main/java/com/mindskip/xzs/service/impl/UserServiceImpl.java
@@ -176,7 +176,7 @@
}
@Override
- public void setStatus(UserVO user) {
+ public void setStatus(User user) {
userMapper.setStatus(user);
}
diff --git a/src/main/resources/mapper/UserConditionExamineMapper.xml b/src/main/resources/mapper/UserConditionExamineMapper.xml
new file mode 100644
index 0000000..6dc2d42
--- /dev/null
+++ b/src/main/resources/mapper/UserConditionExamineMapper.xml
@@ -0,0 +1,29 @@
+<?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.mindskip.xzs.repository.UserConditionExamineMapper">
+
+ <select id="pageInfo" resultType="com.mindskip.xzs.domain.vo.UserConditionExamineVO">
+ SELECT
+ a.* ,
+ b1.real_name as userName,
+ b2.real_name as createUserName
+ FROM
+ t_user_condition_examine a
+ LEFT JOIN t_user b1 ON a.user_id = b1.id
+ LEFT JOIN t_user b2 ON a.create_user = b2.id
+ iNNER JOIN t_user_department c ON a.user_id = c.user_id
+ <if test="deptIds != null and deptIds.size() > 0">
+ AND c.department_id IN
+ <foreach collection="deptIds" item="deptId" open="(" separator="," close=")">
+ #{deptId}
+ </foreach>
+ </if>
+ WHERE
+ a.deleted = 0
+ <if test="userName != null">
+ AND b1.real_name LIKE concat('%', #{userName}, '%')
+ </if>
+ GROUP BY a.id, a.create_time
+ ORDER BY a.create_time
+ </select>
+</mapper>
diff --git a/src/main/resources/mapper/UserMapper.xml b/src/main/resources/mapper/UserMapper.xml
index 5d3b1b3..68d3dfc 100644
--- a/src/main/resources/mapper/UserMapper.xml
+++ b/src/main/resources/mapper/UserMapper.xml
@@ -469,11 +469,10 @@
</update>
<update id="setStatus">
- UPDATE t_user
- SET `condition` = #{condition},
- `condition_detail` = #{conditionDetail}
- WHERE id = #{id}
- AND deleted = 0
+ UPDATE t_user
+ SET `condition` = #{condition}
+ WHERE id = #{id}
+ AND deleted = 0
</update>
<update id="clearDeptAdmin">
--
Gitblit v1.8.0