服务范围增删改查接口

lizijie

2022-01-14 9147ac833536f581c4ce8ff7504d7daf4a20cd9c

服务范围增删改查接口

 screen-common/src/main/java/com/moral/constant/ResponseCodeEnum.java

@@ -62,7 +62,9 @@
    TARGET_IS_NULL(-47, "操作目标不存在"),
    VERSION_USED(-48, "型号被使用，无法删除"),
    CANNOT_DELETE_ONESELF(-49, "不能删除自己的账号"),
    EXPIRE_BEYOND_ADMIN(-50, "不能超过主账号过期时间");
    EXPIRE_BEYOND_ADMIN(-50, "不能超过主账号过期时间"),
    SERVICES_SCOPE_IS_EXIST(-51, "服务范围已存在"),
    SERVICES_SCOPE_IS_NOT_EXIST(-52, "服务范围不存在");

    private final Integer code;
    private final String msg;

 screen-manage/src/main/java/com/moral/api/controller/ServicesScopeController.java

New file
@@ -0,0 +1,112 @@
package com.moral.api.controller;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
import com.moral.api.entity.Organization;
import com.moral.api.entity.ServicesScope;
import com.moral.api.mapper.OrganizationMapper;
import com.moral.api.service.OrganizationService;
import com.moral.api.service.ServicesScopeService;
import com.moral.constant.Constants;
import com.moral.constant.ResponseCodeEnum;
import com.moral.constant.ResultMessage;
import com.moral.util.WebUtils;
import io.swagger.annotations.Api;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.Map;

/**
 * @program: screen
 * @description: 服务范围
 * @author: lizijie
 * @create: 2022-01-12 15:42
 **/
@Slf4j
@Api(tags = {"服务范围"})
@RestController
@RequestMapping("/servicesScope")
public class ServicesScopeController {

    @Resource
    private OrganizationMapper organizationMapper;

    @Resource
    private OrganizationService organizationService;

    @Resource
    private ServicesScopeService servicesScopeService;

    @RequestMapping(value = "getDataByCondition", method = RequestMethod.GET)
    @ResponseBody
    public ResultMessage getDataByCondition(HttpServletRequest request){
        Map<String, Object> parameters = WebUtils.getParametersStartingWith(request,null);
        Object size = parameters.get("size");
        Object current = parameters.get("current");
        if (ObjectUtils.isEmpty(size) || ObjectUtils.isEmpty(current)){
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        Map<String, Object> resultMap = servicesScopeService.getDataByCondition(parameters);
        return ResultMessage.ok(resultMap);
    }

    @RequestMapping(value = "insert",method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage insert(@RequestBody ServicesScope servicesScope){
        if (ObjectUtils.isEmpty(servicesScope.getName()) || ObjectUtils.isEmpty(servicesScope.getOrganizationId())){
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        QueryWrapper<Organization> organizationQueryWrapper = new QueryWrapper<>();
        organizationQueryWrapper.eq("id",servicesScope.getOrganizationId()).eq("is_delete",Constants.NOT_DELETE);
        Organization organization = organizationService.getOne(organizationQueryWrapper);
        if (ObjectUtils.isEmpty(organization)){
            return ResultMessage.fail(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getCode(), ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getMsg());
        }
        servicesScopeService.insert(servicesScope);
        return ResultMessage.ok();
    }

    @RequestMapping(value = "update",method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage update(@RequestBody ServicesScope servicesScope){
        if (ObjectUtils.isEmpty(servicesScope.getId())){
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        QueryWrapper<ServicesScope> servicesScopeQueryWrapper = new QueryWrapper<>();
        servicesScopeQueryWrapper.eq("id",servicesScope.getId()).eq("is_delete",Constants.NOT_DELETE);
        ServicesScope servicesScopeRes = servicesScopeService.getOne(servicesScopeQueryWrapper);
        if (ObjectUtils.isEmpty(servicesScopeRes)){
            return ResultMessage.fail(ResponseCodeEnum.SERVICES_SCOPE_IS_NOT_EXIST.getCode(), ResponseCodeEnum.SERVICES_SCOPE_IS_NOT_EXIST.getMsg());
        }
        if (!ObjectUtils.isEmpty(servicesScope.getOrganizationId())){
            QueryWrapper<Organization> organizationQueryWrapper = new QueryWrapper<>();
            organizationQueryWrapper.eq("id",servicesScope.getOrganizationId()).eq("is_delete",Constants.NOT_DELETE);
            Organization organization = organizationService.getOne(organizationQueryWrapper);
            if (ObjectUtils.isEmpty(organization)){
                return ResultMessage.fail(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getCode(), ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getMsg());
            }
        }
        servicesScopeService.update(servicesScope);
        return ResultMessage.ok();
    }

    @RequestMapping(value = "delete",method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage delete(@RequestBody Map map){
        if (ObjectUtils.isEmpty(map.get("id"))){
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        QueryWrapper<ServicesScope> servicesScopeQueryWrapper = new QueryWrapper<>();
        servicesScopeQueryWrapper.eq("id",Integer.parseInt(map.get("id").toString())).eq("is_delete",Constants.NOT_DELETE);
        ServicesScope servicesScopeRes = servicesScopeService.getOne(servicesScopeQueryWrapper);
        if (ObjectUtils.isEmpty(servicesScopeRes)){
            return ResultMessage.fail(ResponseCodeEnum.SERVICES_SCOPE_IS_NOT_EXIST.getCode(), ResponseCodeEnum.SERVICES_SCOPE_IS_NOT_EXIST.getMsg());
        }
        servicesScopeService.delete(Integer.parseInt(map.get("id").toString()));
        return ResultMessage.ok();
    }

}

 screen-manage/src/main/java/com/moral/api/entity/ServicesScope.java

New file
@@ -0,0 +1,79 @@
package com.moral.api.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.extension.activerecord.Model;
import com.baomidou.mybatisplus.annotation.TableId;
import java.time.LocalDateTime;
import java.io.Serializable;
import java.util.Date;

import lombok.Data;
import lombok.EqualsAndHashCode;

/**
 * <p>
 * 
 * </p>
 *
 * @author moral
 * @since 2022-01-12
 */
@Data
@EqualsAndHashCode(callSuper = false)
public class ServicesScope extends Model<ServicesScope> {

    private static final long serialVersionUID = 1L;

    /**
     * id
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    /**
     * 名称
     */
    private String name;

    /**
     * 组织id
     */
    private Integer organizationId;

    /**
     * 中心经度
     */
    private Double centerLongitude;

    /**
     * 中心纬度
     */
    private Double centerLatitude;

    /**
     * 边界
     */
    private String boundary;

    /**
     * 创建时间
     */
    private Date createTime;

    /**
     * 更新时间
     */
    private Date updateTime;

    /**
     * 是否删除
     */
    private String isDelete;


    @Override
    protected Serializable pkVal() {
        return this.id;
    }

}

 screen-manage/src/main/java/com/moral/api/mapper/ServicesScopeMapper.java

New file
@@ -0,0 +1,16 @@
package com.moral.api.mapper;

import com.moral.api.entity.ServicesScope;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author moral
 * @since 2022-01-12
 */
public interface ServicesScopeMapper extends BaseMapper<ServicesScope> {

}

 screen-manage/src/main/java/com/moral/api/service/ServicesScopeService.java

New file
@@ -0,0 +1,60 @@
package com.moral.api.service;

import com.moral.api.entity.ServicesScope;
import com.baomidou.mybatisplus.extension.service.IService;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  服务类
 * </p>
 *
 * @author moral
 * @since 2022-01-12
 */
@Transactional
public interface ServicesScopeService extends IService<ServicesScope> {

    /**
      *@Description: 按条件查询服务范围列表
      *@Param: [map]
      *@return: java.util.List<java.util.Map<java.lang.String,java.lang.Object>> 
      *@Author: lizijie
      *@Date: 2022/1/12 16:35
     **/
   Map<String, Object> getDataByCondition(Map<String, Object> map);
   
   /**
     *@Description: 新增服务范围
     *@Param: [servicesScope]
     *@return: void 
     *@Author: lizijie
     *@Date: 2022/1/13 9:45
    **/
   @Transactional
   void insert(ServicesScope servicesScope);
   
   /**
     *@Description: 更新
     *@Param: [servicesScope]
     *@return: void 
     *@Author: lizijie
     *@Date: 2022/1/13 14:54
    **/
   @Transactional
   void update(ServicesScope servicesScope);
   
   /**
     *@Description: 根据id删除
     *@Param: [id]
     *@return: void 
     *@Author: lizijie
     *@Date: 2022/1/13 17:30
    **/
   @Transactional
   void delete(int id);

}

 screen-manage/src/main/java/com/moral/api/service/impl/ServicesScopeServiceImpl.java

New file
@@ -0,0 +1,148 @@
package com.moral.api.service.impl;

import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.moral.api.entity.Organization;
import com.moral.api.entity.ServicesScope;
import com.moral.api.mapper.OrganizationMapper;
import com.moral.api.mapper.ServicesScopeMapper;
import com.moral.api.service.ServicesScopeService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.moral.api.util.LogUtils;
import com.moral.constant.Constants;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.ObjectUtils;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;

import javax.servlet.http.HttpServletRequest;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * <p>
 *  服务实现类
 * </p>
 *
 * @author moral
 * @since 2022-01-12
 */
@Service
public class ServicesScopeServiceImpl extends ServiceImpl<ServicesScopeMapper, ServicesScope> implements ServicesScopeService {

    @Autowired
    private ServicesScopeMapper servicesScopeMapper;

    @Autowired
    private OrganizationMapper organizationMapper;

    @Override
    public Map<String, Object> getDataByCondition(Map<String, Object> map) {
        Map<String,Object> resultMap = new HashMap<>();
        int current = Integer.parseInt(map.get("current").toString());
        int size = Integer.parseInt(map.get("size").toString());
        Page<ServicesScope> page = new Page<>(current, size);
        QueryWrapper<ServicesScope> servicesScopeWrapper = new QueryWrapper<>();
        servicesScopeWrapper.eq("is_delete",Constants.NOT_DELETE);
        if (!ObjectUtils.isEmpty(map.get("orgId"))){
            servicesScopeWrapper.eq("organization_id",Integer.parseInt(map.get("orgId").toString()));
        }
        if (!ObjectUtils.isEmpty(map.get("name"))){
            if (map.get("name") != ""){
                servicesScopeWrapper.like("name",map.get("name").toString());
            }
        }
        Page<ServicesScope> resultPage = servicesScopeMapper.selectPage(page, servicesScopeWrapper);
        List<ServicesScope> servicesScopes = resultPage.getRecords();
        SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        List<Map<String,Object>> servicesScopesList = new ArrayList<>();
        for (ServicesScope servicesScope:servicesScopes) {
            Map servicesScopeMap = JSON.parseObject(JSON.toJSONString(servicesScope),Map.class);
            if (ObjectUtils.isEmpty(servicesScopeMap.get("centerLongitude"))){
                servicesScopeMap.put("centerLongitude",null);
            }
            if (ObjectUtils.isEmpty(servicesScopeMap.get("centerLatitude"))){
                servicesScopeMap.put("centerLatitude",null);
            }
            if (ObjectUtils.isEmpty(servicesScopeMap.get("boundary"))){
                servicesScopeMap.put("boundary",null);
            }
            String createTime = SDF.format(servicesScope.getCreateTime());
            String updateTime = SDF.format(servicesScope.getUpdateTime());
            servicesScopeMap.put("createTime",createTime);
            servicesScopeMap.put("updateTime",updateTime);
            int organization_id = servicesScope.getOrganizationId();
            Organization organization = organizationMapper.selectById(organization_id);
            servicesScopeMap.put("organization_name",organization.getName());
            servicesScopesList.add(servicesScopeMap);
        }
        resultMap.put("servicesScopes",servicesScopesList);
        int totalNumber = servicesScopeMapper.selectCount(servicesScopeWrapper);
        resultMap.put("totalNumber",totalNumber);
        resultMap.put("current",current);
        int totalPageNumber = totalNumber/size;
        if(totalNumber%size != 0){
            totalPageNumber += 1;
        }
        resultMap.put("totalPageNumber",totalPageNumber);
        return resultMap;
    }

    @Transactional
    @Override
    public void insert(ServicesScope servicesScope) {
        int count = servicesScopeMapper.insert(servicesScope);
        if (count > 0) {
            //操作日志记录
            HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
            StringBuilder content = new StringBuilder();
            content.append("添加了服务范围：").append("id:").append(servicesScope.getId() + ";").append("name:").append(servicesScope.getName() + ";").append(":").append("organization_id：").append(servicesScope.getOrganizationId() + ";");
            LogUtils.saveOperationForManage(request, content.toString(), Constants.INSERT_OPERATE_TYPE);
        }
    }

    @Override
    @Transactional
    public void update(ServicesScope servicesScope) {
        ServicesScope oldServicesScope = servicesScopeMapper.selectById(servicesScope.getId());
        servicesScopeMapper.updateById(servicesScope);
        ServicesScope newServicesScope = servicesScopeMapper.selectById(servicesScope.getId());
        //操作日志记录
        HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
        StringBuilder content = new StringBuilder();
        content.append("修改了政府站点：").append("id:").append(servicesScope.getId() + ";");
        if (!com.baomidou.mybatisplus.core.toolkit.ObjectUtils.isEmpty(servicesScope.getOrganizationId())) {
            content.append("organization_id:").append(oldServicesScope.getOrganizationId()).append("->").append(newServicesScope.getOrganizationId()).append(";");
        }
        if (!com.baomidou.mybatisplus.core.toolkit.ObjectUtils.isEmpty(servicesScope.getName())) {
            content.append("name:").append(oldServicesScope.getName()).append("->").append(newServicesScope.getName()).append(";");
        }
        if (!com.baomidou.mybatisplus.core.toolkit.ObjectUtils.isEmpty(servicesScope.getCenterLongitude())) {
            content.append("center_longitude:").append(oldServicesScope.getCenterLongitude()).append("->").append(newServicesScope.getCenterLongitude()).append(";");
        }
        if (!com.baomidou.mybatisplus.core.toolkit.ObjectUtils.isEmpty(servicesScope.getCenterLatitude())) {
            content.append("center_latitude:").append(oldServicesScope.getCenterLatitude()).append("->").append(newServicesScope.getCenterLatitude()).append(";");
        }
        if (!com.baomidou.mybatisplus.core.toolkit.ObjectUtils.isEmpty(servicesScope.getBoundary())) {
            content.append("boundary:").append("数据过长").append(";");
        }
        LogUtils.saveOperationForManage(request, content.toString(), Constants.UPDATE_OPERATE_TYPE);
    }

    @Override
    @Transactional
    public void delete(int id) {
        ServicesScope servicesScope = new ServicesScope();
        servicesScope.setId(id);
        servicesScope.setIsDelete(Constants.DELETE);
        servicesScopeMapper.updateById(servicesScope);
        //操作日志记录
        HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
        StringBuilder content = new StringBuilder();
        content.append("删除了服务范围：").append("id:").append(id).append(";");
        LogUtils.saveOperationForManage(request, content.toString(), Constants.DELETE_OPERATE_TYPE);
    }
}

 screen-manage/src/main/resources/mapper/ServicesScopeMapper.xml

New file
@@ -0,0 +1,18 @@
<?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.moral.api.mapper.ServicesScopeMapper">

        <!-- 通用查询映射结果 -->
        <resultMap id="BaseResultMap" type="com.moral.api.entity.ServicesScope">
                    <id column="id" property="id" />
                    <result column="name" property="name" />
                    <result column="organization__id" property="organizationId" />
                    <result column="center_longitude" property="centerLongitude" />
                    <result column="center_latitude" property="centerLatitude" />
                    <result column="boundary" property="boundary" />
                    <result column="create_time" property="createTime" />
                    <result column="update_time" property="updateTime" />
                    <result column="is_delete" property="isDelete" />
        </resultMap>

</mapper>