From b5837609dcd4417904eaaa5924de46010443affd Mon Sep 17 00:00:00 2001
From: lin <sbla5888@163.com>
Date: Thu, 21 Mar 2024 19:37:45 +0800
Subject: [PATCH] 居住证审核+从业人员优化

---
 src/main/java/org/springblade/modules/place/service/impl/PlacePractitionerServiceImpl.java       |   22 ++++++++++-
 src/main/java/org/springblade/modules/task/controller/TaskResidencePermitApplyController.java    |    7 ++-
 src/main/java/org/springblade/modules/task/service/impl/TaskResidencePermitApplyServiceImpl.java |    5 ++
 src/main/java/org/springblade/modules/place/service/IPlacePractitionerService.java               |    7 +++
 src/main/java/org/springblade/modules/place/controller/PlacePractitionerController.java          |   10 +++++
 src/main/java/org/springblade/modules/place/entity/PlacePractitionerEntity.java                  |   21 ++++++++++
 src/main/java/org/springblade/modules/place/mapper/PlacePractitionerMapper.xml                   |    9 ++++
 7 files changed, 76 insertions(+), 5 deletions(-)

diff --git a/src/main/java/org/springblade/modules/place/controller/PlacePractitionerController.java b/src/main/java/org/springblade/modules/place/controller/PlacePractitionerController.java
index 69ad213..cc9fc78 100644
--- a/src/main/java/org/springblade/modules/place/controller/PlacePractitionerController.java
+++ b/src/main/java/org/springblade/modules/place/controller/PlacePractitionerController.java
@@ -109,6 +109,16 @@
 	}
 
 	/**
+	 * 场所从业人员 修改
+	 */
+	@PostMapping("/auditing")
+	@ApiOperationSupport(order = 5)
+	@ApiOperation(value = "修改", notes = "传入placePractitioner")
+	public R auditing(@Valid @RequestBody PlacePractitionerEntity placePractitioner) {
+		return R.status(placePractitionerService.auditing(placePractitioner));
+	}
+
+	/**
 	 * 场所从业人员 新增或修改
 	 */
 	@PostMapping("/submit")
diff --git a/src/main/java/org/springblade/modules/place/entity/PlacePractitionerEntity.java b/src/main/java/org/springblade/modules/place/entity/PlacePractitionerEntity.java
index 77010de..036c093 100644
--- a/src/main/java/org/springblade/modules/place/entity/PlacePractitionerEntity.java
+++ b/src/main/java/org/springblade/modules/place/entity/PlacePractitionerEntity.java
@@ -118,4 +118,25 @@
 	@TableField("resignation_flag")
 	private Integer resignationFlag;
 
+	/** 审核确认人用户id */
+	@ApiModelProperty(value = "审核确认人用户id", example = "")
+	@TableField("confirm_user_id")
+	private Long confirmUserId;
+
+	/** 确认标记 1:待审核  2:审核通过  3:审核不通过 4:待完善 */
+	@ApiModelProperty(value = "确认标记 1:待审核  2:审核通过  3:审核不通过 4:待完善", example = "")
+	@TableField("confirm_flag")
+	private Integer confirmFlag;
+
+	/** 审核确认时间 */
+	@ApiModelProperty(value = "审核确认时间", example = "")
+	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
+	@TableField("confirm_time")
+	private Date confirmTime;
+
+	/** 审核意见 */
+	@ApiModelProperty(value = "审核意见", example = "")
+	@TableField("confirm_notion")
+	private String confirmNotion;
+
 }
diff --git a/src/main/java/org/springblade/modules/place/mapper/PlacePractitionerMapper.xml b/src/main/java/org/springblade/modules/place/mapper/PlacePractitionerMapper.xml
index afb67cc..847de74 100644
--- a/src/main/java/org/springblade/modules/place/mapper/PlacePractitionerMapper.xml
+++ b/src/main/java/org/springblade/modules/place/mapper/PlacePractitionerMapper.xml
@@ -23,6 +23,10 @@
         jpp.employment_time,
         jpp.resignation_time,
         jpp.resignation_flag,
+        jpp.confirm_user_id,
+        jpp.confirm_flag,
+        jpp.confirm_time,
+        jpp.confirm_notion,
         jc.category_name
         FROM
         jczz_place_practitioner jpp
@@ -61,6 +65,11 @@
             <if test="placePractitioner.createTime != null ">and jpp.create_time = #{placePractitioner.createTime}</if>
             <if test="placePractitioner.ethnicity != null ">and jpp.ethnicity = #{placePractitioner.ethnicity}</if>
 
+            <if test="placePractitioner.confirmUserId != null "> and confirm_user_id = #{placePractitioner.confirmUserId}</if>
+            <if test="placePractitioner.confirmFlag != null "> and confirm_flag = #{placePractitioner.confirmFlag}</if>
+            <if test="placePractitioner.confirmTime != null "> and confirm_time = #{placePractitioner.confirmTime}</if>
+            <if test="placePractitioner.confirmNotion != null  and placePractitioner.confirmNotion != ''"> and confirm_notion = #{placePractitioner.confirmNotion}</if>
+
             <if test="placePractitioner.type == 1">
                 and TIMESTAMPDIFF(year, substring(jpp.id_card, 7, 8), now()) &lt; 18
                 and jc.category_no in (180202,180201)
diff --git a/src/main/java/org/springblade/modules/place/service/IPlacePractitionerService.java b/src/main/java/org/springblade/modules/place/service/IPlacePractitionerService.java
index d5759e5..3944100 100644
--- a/src/main/java/org/springblade/modules/place/service/IPlacePractitionerService.java
+++ b/src/main/java/org/springblade/modules/place/service/IPlacePractitionerService.java
@@ -41,4 +41,11 @@
 
 
     Object countByType(PlacePractitionerVO placePractitioner);
+
+	/**
+	 * 审核
+	 * @param placePractitioner
+	 * @return
+	 */
+	Boolean auditing(PlacePractitionerEntity placePractitioner);
 }
diff --git a/src/main/java/org/springblade/modules/place/service/impl/PlacePractitionerServiceImpl.java b/src/main/java/org/springblade/modules/place/service/impl/PlacePractitionerServiceImpl.java
index 312ccd5..520d013 100644
--- a/src/main/java/org/springblade/modules/place/service/impl/PlacePractitionerServiceImpl.java
+++ b/src/main/java/org/springblade/modules/place/service/impl/PlacePractitionerServiceImpl.java
@@ -16,8 +16,10 @@
  */
 package org.springblade.modules.place.service.impl;
 
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import org.springblade.common.constant.CommonConstant;
+import org.springblade.core.secure.utils.AuthUtil;
 import org.springblade.modules.place.entity.PlacePractitionerEntity;
 import org.springblade.modules.place.vo.PlacePractitionerVO;
 import org.springblade.modules.place.mapper.PlacePractitionerMapper;
@@ -26,6 +28,7 @@
 import org.springframework.stereotype.Service;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 
+import java.util.Date;
 import java.util.HashMap;
 import java.util.Map;
 
@@ -46,6 +49,7 @@
 
 	/**
 	 * 统计少数民族和未成年数量
+	 *
 	 * @return
 	 */
 	@Override
@@ -57,8 +61,22 @@
 		placePractitioner.setType(CommonConstant.NUMBER_TWO);
 		Integer nationalMinority = baseMapper.selectPlaceCountByType(placePractitioner);
 		Map<String, Integer> resultMap = new HashMap<>();
-		resultMap.put("minors",minors);
-		resultMap.put("nationalMinority",nationalMinority);
+		resultMap.put("minors", minors);
+		resultMap.put("nationalMinority", nationalMinority);
 		return resultMap;
 	}
+
+	@Override
+	public Boolean auditing(PlacePractitionerEntity placePractitioner) {
+		placePractitioner.setConfirmUserId(AuthUtil.getUserId());
+		placePractitioner.setConfirmTime(new Date());
+		boolean update = update(Wrappers.<PlacePractitionerEntity>lambdaUpdate()
+			.set(PlacePractitionerEntity::getConfirmFlag, placePractitioner.getConfirmFlag())
+			.set(PlacePractitionerEntity::getConfirmNotion, placePractitioner.getConfirmNotion())
+			.set(PlacePractitionerEntity::getConfirmUserId, placePractitioner.getConfirmUserId())
+			.eq(PlacePractitionerEntity::getPlaceId, placePractitioner.getPlaceId())
+			.eq(PlacePractitionerEntity::getResignationFlag, 1)
+			.eq(PlacePractitionerEntity::getIsDeleted,0));
+		return update;
+	}
 }
diff --git a/src/main/java/org/springblade/modules/task/controller/TaskResidencePermitApplyController.java b/src/main/java/org/springblade/modules/task/controller/TaskResidencePermitApplyController.java
index a3f70a0..4596e5f 100644
--- a/src/main/java/org/springblade/modules/task/controller/TaskResidencePermitApplyController.java
+++ b/src/main/java/org/springblade/modules/task/controller/TaskResidencePermitApplyController.java
@@ -21,6 +21,7 @@
 import io.swagger.annotations.ApiParam;
 import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
 import lombok.AllArgsConstructor;
+
 import javax.validation.Valid;
 
 import org.springblade.core.mp.support.Condition;
@@ -35,6 +36,8 @@
 import org.springblade.modules.task.wrapper.TaskResidencePermitApplyWrapper;
 import org.springblade.modules.task.service.ITaskResidencePermitApplyService;
 import org.springblade.core.boot.ctrl.BladeController;
+
+import java.util.Date;
 
 /**
  * 居住证申请 控制器
@@ -60,6 +63,7 @@
 		TaskResidencePermitApplyEntity detail = taskResidencePermitApplyService.getOne(Condition.getQueryWrapper(taskResidencePermitApply));
 		return R.data(TaskResidencePermitApplyWrapper.build().entityVO(detail));
 	}
+
 	/**
 	 * 居住证申请 分页
 	 */
@@ -69,7 +73,7 @@
 	public R<IPage<TaskResidencePermitApplyVO>> list(TaskResidencePermitApplyEntity taskResidencePermitApply, Query query) {
 		// 查询自己的记录
 		taskResidencePermitApply.setCreateUser(AuthUtil.getUserId());
-		IPage<TaskResidencePermitApplyEntity> pages = taskResidencePermitApplyService.page(Condition.getPage(query), Condition.getQueryWrapper(taskResidencePermitApply));
+		IPage<TaskResidencePermitApplyEntity> pages = taskResidencePermitApplyService.page(Condition.getPage(query), Condition.getQueryWrapper(taskResidencePermitApply).orderByDesc("create_time"));
 		return R.data(TaskResidencePermitApplyWrapper.build().pageVO(pages));
 	}
 
@@ -103,7 +107,6 @@
 	public R update(@Valid @RequestBody TaskResidencePermitApplyEntity taskResidencePermitApply) {
 		return R.status(taskResidencePermitApplyService.updateById(taskResidencePermitApply));
 	}
-
 	/**
 	 * 居住证申请 审核
 	 */
diff --git a/src/main/java/org/springblade/modules/task/service/impl/TaskResidencePermitApplyServiceImpl.java b/src/main/java/org/springblade/modules/task/service/impl/TaskResidencePermitApplyServiceImpl.java
index c366d9d..c754573 100644
--- a/src/main/java/org/springblade/modules/task/service/impl/TaskResidencePermitApplyServiceImpl.java
+++ b/src/main/java/org/springblade/modules/task/service/impl/TaskResidencePermitApplyServiceImpl.java
@@ -48,6 +48,7 @@
 import com.baomidou.mybatisplus.core.metadata.IPage;
 
 import javax.annotation.Resource;
+import java.util.Date;
 import java.util.List;
 import java.util.stream.Collectors;
 
@@ -67,7 +68,7 @@
 	@Override
 	public IPage<TaskResidencePermitApplyVO> selectTaskResidencePermitApplyPage(IPage<TaskResidencePermitApplyVO> page, TaskResidencePermitApplyVO taskResidencePermitApply) {
 		CommonParamSet commonParamSet = new CommonParamSet().invoke(TaskResidencePermitApplyVO.class, taskResidencePermitApply);
-		if(taskResidencePermitApply.getRoleName().equals("inhabitant")){
+		if (taskResidencePermitApply.getRoleName() != null && taskResidencePermitApply.getRoleName().equals("inhabitant")) {
 			taskResidencePermitApply.setCreateUser(AuthUtil.getUserId());
 		}
 		return page.setRecords(baseMapper.selectTaskResidencePermitApplyPage(page, taskResidencePermitApply,
@@ -111,6 +112,8 @@
 
 	@Override
 	public Boolean updateResidencePermitApplyEntity(TaskResidencePermitApplyEntity taskResidencePermitApply) {
+		taskResidencePermitApply.setConfirmTime(new Date());
+		taskResidencePermitApply.setConfirmUserId(AuthUtil.getUserId());
 		boolean b = updateById(taskResidencePermitApply);
 		if (b) {
 			TaskResidencePermitApplyEntity entity = getById(taskResidencePermitApply.getId());

--
Gitblit v1.9.3