From a7dc3517b3c028eab02cdde35a57389278217ed2 Mon Sep 17 00:00:00 2001
From: Pu Zhibing <393733352@qq.com>
Date: 星期二, 25 二月 2025 19:59:33 +0800
Subject: [PATCH] 新增加后台职位接口

---
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/DepartmentController.java           |    6 
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemUserController.java           |    4 
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/dao/SystemPostMapper.java               |   20 +++++
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/model/entity/SystemPost.java            |   38 +++++++++
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/resources/mapper/SystemPostMapper.xml                                    |   20 +++++
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/ServiceSangeshenbianApplication.java    |    2 
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemPostController.java           |   59 ++++++++++++++
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/SystemPostServiceImpl.java |   25 ++++++
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/ISystemPostService.java         |   15 +++
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/MessageNotificationController.java  |    2 
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/ProblemTypeController.java          |    4 
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemRoleController.java           |    4 
 12 files changed, 187 insertions(+), 12 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/ServiceSangeshenbianApplication.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/ServiceSangeshenbianApplication.java
index c59af8c..45291ce 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/ServiceSangeshenbianApplication.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/ServiceSangeshenbianApplication.java
@@ -1,6 +1,5 @@
 package com.panzhihua.sangeshenbian;
 
-import org.mybatis.spring.annotation.MapperScan;
 import org.springframework.boot.SpringApplication;
 import org.springframework.cloud.client.SpringCloudApplication;
 import org.springframework.cloud.client.circuitbreaker.EnableCircuitBreaker;
@@ -20,7 +19,6 @@
 @EnableEurekaClient
 @EnableCircuitBreaker
 @ComponentScan({"com.panzhihua.sangeshenbian", "com.panzhihua.common"})
-@MapperScan("com.panzhihua.sangeshenbian.dao")
 @EnableScheduling
 public class ServiceSangeshenbianApplication
 {
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/DepartmentController.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/DepartmentController.java
index ae655cf..7f3d84c 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/DepartmentController.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/DepartmentController.java
@@ -63,7 +63,7 @@
 		if(null == department.getPid()){
 			department.setPid(0);
 		}
-		int count = departmentService.count(new LambdaQueryWrapper<Department>().eq(Department::getPid, department.getPid()).eq(Department::getName, department.getName()));
+		long count = departmentService.count(new LambdaQueryWrapper<Department>().eq(Department::getPid, department.getPid()).eq(Department::getName, department.getName()));
 		if(0 < count){
 			return R.fail("单位名称重复。");
 		}
@@ -84,7 +84,7 @@
 		if(null == department.getPid()){
 			department.setPid(0);
 		}
-		int count = departmentService.count(new LambdaQueryWrapper<Department>().eq(Department::getPid, department.getPid())
+		long count = departmentService.count(new LambdaQueryWrapper<Department>().eq(Department::getPid, department.getPid())
 				.eq(Department::getName, department.getName()).ne(Department::getId, department.getId()));
 		if(0 < count){
 			return R.fail("单位名称重复。");
@@ -104,7 +104,7 @@
 	@ApiOperation(value = "删除单位信息", tags = {"三个身边后台-用户管理"})
 	@OperLog(operModul = "三个身边后台",operType = 3, businessType = "删除单位信息")
 	public R delete(@PathVariable("id") Integer id){
-		int count = systemUserService.count(new LambdaQueryWrapper<SystemUser>().eq(SystemUser::getOneDepartmentId, id).or().eq(SystemUser::getTwoDepartmentId, id)
+		long count = systemUserService.count(new LambdaQueryWrapper<SystemUser>().eq(SystemUser::getOneDepartmentId, id).or().eq(SystemUser::getTwoDepartmentId, id)
 				.or().eq(SystemUser::getThreeDepartmentId, id).or().eq(SystemUser::getFourDepartmentId, id).ne(SystemUser::getStatus, 3));
 		if(0 < count){
 			return R.fail("该单位已被使用,删除失败。");
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/MessageNotificationController.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/MessageNotificationController.java
index 0ea8748..591ca78 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/MessageNotificationController.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/MessageNotificationController.java
@@ -100,7 +100,7 @@
 				userId = id.toString();
 				break;
 		}
-		Integer count = messageNotificationService.lambdaQuery()
+		long count = messageNotificationService.lambdaQuery()
 				.eq(MessageNotification::getReadStatus, 0)
 				.eq(MessageNotification::getUndertakerType, systemUser.getAccountLevel())
 				.eq(MessageNotification::getUndertakerUserId, userId)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/ProblemTypeController.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/ProblemTypeController.java
index e0109ac..a816fe3 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/ProblemTypeController.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/ProblemTypeController.java
@@ -59,7 +59,7 @@
 		if(systemUser.getAccountLevel() != 1){
 			return R.fail("添加失败");
 		}
-		int count = problemTypeService.count(new LambdaQueryWrapper<ProblemType>().eq(ProblemType::getName, problemType.getName()).eq(ProblemType::getDel, 0));
+		long count = problemTypeService.count(new LambdaQueryWrapper<ProblemType>().eq(ProblemType::getName, problemType.getName()).eq(ProblemType::getDel, 0));
 		if(0 < count){
 			return R.fail("该问题类型已存在");
 		}
@@ -79,7 +79,7 @@
 		if(systemUser.getAccountLevel() != 1){
 			return R.fail("编辑失败");
 		}
-		int count = problemTypeService.count(new LambdaQueryWrapper<ProblemType>().eq(ProblemType::getName, problemType.getName()).eq(ProblemType::getDel, 0).ne(ProblemType::getId, problemType.getId()));
+		long count = problemTypeService.count(new LambdaQueryWrapper<ProblemType>().eq(ProblemType::getName, problemType.getName()).eq(ProblemType::getDel, 0).ne(ProblemType::getId, problemType.getId()));
 		if(0 < count){
 			return R.fail("该问题类型已存在");
 		}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemPostController.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemPostController.java
new file mode 100644
index 0000000..2ca0c24
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemPostController.java
@@ -0,0 +1,59 @@
+package com.panzhihua.sangeshenbian.api;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.panzhihua.common.interfaces.OperLog;
+import com.panzhihua.common.model.vos.R;
+import com.panzhihua.sangeshenbian.model.entity.SystemPost;
+import com.panzhihua.sangeshenbian.service.ISystemPostService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.web.bind.annotation.*;
+
+import javax.annotation.Resource;
+
+/**
+ * @author zhibing.pu
+ * @Date 2025/2/25 19:44
+ */
+@Api
+@RestController
+@RequestMapping("/systemPost")
+public class SystemPostController {
+	
+	@Resource
+	private ISystemPostService systemPostService;
+	
+	
+	@PostMapping("/add")
+	@ApiOperation(value = "添加职位", tags = {"三个身边后台-职位管理"})
+	@OperLog(operModul = "三个身边后台",operType = 1,businessType = "添加职位")
+	public R add(@RequestBody SystemPost systemPost) {
+		systemPostService.save(systemPost);
+		return R.ok();
+	}
+	
+	
+	@PostMapping("/edit")
+	@ApiOperation(value = "编辑职位", tags = {"三个身边后台-职位管理"})
+	@OperLog(operModul = "三个身边后台",operType = 2,businessType = "编辑职位")
+	public R edit(@RequestBody SystemPost systemPost) {
+		systemPostService.updateById(systemPost);
+		return R.ok();
+	}
+	
+	@DeleteMapping("/delete/{id}")
+	@ApiOperation(value = "删除职位", tags = {"三个身边后台-职位管理"})
+	@OperLog(operModul = "三个身边后台",operType = 3,businessType = "删除职位")
+	public R delete(@PathVariable("id") Integer id) {
+		systemPostService.removeById(id);
+		return R.ok();
+	}
+	
+	
+	@GetMapping("/list")
+	@ApiOperation(value = "获取列表数据", tags = {"三个身边后台-职位管理"})
+	@OperLog(operModul = "三个身边后台",operType = 0,businessType = "获取职位列表数据")
+	public R<IPage<SystemPost>> list(String name, Integer pageNum, Integer pageSize) {
+		return R.ok(systemPostService.list(name, pageNum, pageSize));
+	}
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemRoleController.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemRoleController.java
index 1868240..666bd4a 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemRoleController.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemRoleController.java
@@ -50,7 +50,7 @@
 	@ApiOperation(value = "添加角色", tags = {"三个身边后台-角色管理"})
 	@OperLog(operModul = "三个身边后台",operType = 1,businessType = "添加角色")
 	public R add(@RequestBody AddSystemRole addSystemRole){
-		int count = systemRoleService.count(new LambdaQueryWrapper<SystemRole>().eq(SystemRole::getDel, 0).eq(SystemRole::getName, addSystemRole.getName()));
+		long count = systemRoleService.count(new LambdaQueryWrapper<SystemRole>().eq(SystemRole::getDel, 0).eq(SystemRole::getName, addSystemRole.getName()));
 		if(0 < count){
 			return R.fail("该角色名称已存在");
 		}
@@ -74,7 +74,7 @@
 	@ApiOperation(value = "编辑角色", tags = {"三个身边后台-角色管理"})
 	@OperLog(operModul = "三个身边后台",operType = 2,businessType = "编辑角色")
 	public R edit(@RequestBody EditSystemRole editSystemRole){
-		int count = systemRoleService.count(new LambdaQueryWrapper<SystemRole>().eq(SystemRole::getDel, 0)
+		long count = systemRoleService.count(new LambdaQueryWrapper<SystemRole>().eq(SystemRole::getDel, 0)
 				.eq(SystemRole::getName, editSystemRole.getName()).ne(SystemRole::getId, editSystemRole.getId()));
 		if(0 < count){
 			return R.fail("该角色名称已存在");
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemUserController.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemUserController.java
index 0500362..1d7edde 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemUserController.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/api/SystemUserController.java
@@ -148,7 +148,7 @@
 		if(4 == user.getAccountLevel() && 4 < systemUser.getAccountLevel()){
 			return R.fail("不能添加街道、区县和市级账号");
 		}
-		int count = systemUserService.count(new LambdaQueryWrapper<SystemUser>().eq(SystemUser::getPhone, systemUser.getPhone()).ne(SystemUser::getStatus, 3));
+		long count = systemUserService.count(new LambdaQueryWrapper<SystemUser>().eq(SystemUser::getPhone, systemUser.getPhone()).ne(SystemUser::getStatus, 3));
 		if(0 < count){
 			return R.fail("手机号重复。");
 		}
@@ -163,7 +163,7 @@
 	@ApiOperation(value = "编辑人员", tags = {"三个身边后台-人员管理"})
 	@OperLog(operModul = "三个身边后台",operType = 2,businessType = "编辑人员")
 	public R edit(@RequestBody SystemUser systemUser){
-		int count = systemUserService.count(new LambdaQueryWrapper<SystemUser>().eq(SystemUser::getPhone, systemUser.getPhone())
+		long count = systemUserService.count(new LambdaQueryWrapper<SystemUser>().eq(SystemUser::getPhone, systemUser.getPhone())
 				.ne(SystemUser::getStatus, 3).ne(SystemUser::getId, systemUser.getId()));
 		if(0 < count){
 			return R.fail("手机号重复。");
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/dao/SystemPostMapper.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/dao/SystemPostMapper.java
new file mode 100644
index 0000000..52cf77e
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/dao/SystemPostMapper.java
@@ -0,0 +1,20 @@
+package com.panzhihua.sangeshenbian.dao;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.panzhihua.sangeshenbian.model.entity.SystemPost;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+/**
+ * @author zhibing.pu
+ * @Date 2025/2/25 19:41
+ */
+@Mapper
+public interface SystemPostMapper extends BaseMapper<SystemPost> {
+	
+	
+	
+	IPage<SystemPost> list(Page page, @Param("name") String name);
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/model/entity/SystemPost.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/model/entity/SystemPost.java
new file mode 100644
index 0000000..eb3615d
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/model/entity/SystemPost.java
@@ -0,0 +1,38 @@
+package com.panzhihua.sangeshenbian.model.entity;
+
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.Data;
+
+import java.time.LocalDateTime;
+
+/**
+ * @author zhibing.pu
+ * @Date 2025/2/25 19:39
+ */
+@Data
+@TableName("sgsb_system_post")
+public class SystemPost {
+	/**
+	 * 主键
+	 */
+	@TableId(value = "id", type = IdType.AUTO)
+	private Integer id;
+	/**
+	 * 名称
+	 */
+	@TableField("name")
+	private String name;
+	/**
+	 * 删除标识(0=否,1=是)
+	 */
+	@TableField("del")
+	private Integer del;
+	/**
+	 * 添加时间
+	 */
+	@TableField("create_time")
+	private LocalDateTime createTime;
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/ISystemPostService.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/ISystemPostService.java
new file mode 100644
index 0000000..dcb2552
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/ISystemPostService.java
@@ -0,0 +1,15 @@
+package com.panzhihua.sangeshenbian.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.panzhihua.sangeshenbian.model.entity.SystemPost;
+
+/**
+ * @author zhibing.pu
+ * @Date 2025/2/25 19:42
+ */
+public interface ISystemPostService extends IService<SystemPost> {
+	
+	
+	IPage<SystemPost> list(String name, Integer pageNum, Integer pageSize);
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/SystemPostServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/SystemPostServiceImpl.java
new file mode 100644
index 0000000..78ae394
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/SystemPostServiceImpl.java
@@ -0,0 +1,25 @@
+package com.panzhihua.sangeshenbian.service.impl;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.panzhihua.sangeshenbian.dao.SystemPostMapper;
+import com.panzhihua.sangeshenbian.model.entity.SystemPost;
+import com.panzhihua.sangeshenbian.service.ISystemPostService;
+import org.springframework.stereotype.Service;
+
+/**
+ * @author zhibing.pu
+ * @Date 2025/2/25 19:43
+ */
+@Service
+public class SystemPostServiceImpl extends ServiceImpl<SystemPostMapper, SystemPost> implements ISystemPostService {
+	
+	@Override
+	public IPage<SystemPost> list(String name, Integer pageNum, Integer pageSize) {
+		Page page = new Page<>();
+		page.setCurrent(pageNum);
+		page.setSize(pageSize);
+		return this.baseMapper.list(page, name);
+	}
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/resources/mapper/SystemPostMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/resources/mapper/SystemPostMapper.xml
new file mode 100644
index 0000000..7ce5395
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/resources/mapper/SystemPostMapper.xml
@@ -0,0 +1,20 @@
+<?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.panzhihua.sangeshenbian.dao.SystemPostMapper">
+
+	<select id="list" resultType="com.panzhihua.sangeshenbian.model.entity.SystemPost">
+		select
+		id,
+		name,
+		del,
+		create_time
+		from sgsb_system_post
+		where del = 0
+		<if test="name != null and name != ''">
+			and name like concat('%',#{name},'%')
+		</if>
+		order by create_time desc
+	</select>
+</mapper>
\ No newline at end of file

--
Gitblit v1.7.1