package com.moral.api.service.impl;
|
|
import com.alibaba.fastjson.JSON;
|
import com.alibaba.fastjson.JSONObject;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.moral.api.config.mybatis.wrapper.NullFilterWrapper;
|
import com.moral.api.entity.MonitorPoint;
|
import com.moral.api.entity.Organization;
|
import com.moral.api.entity.User;
|
import com.moral.api.mapper.MonitorPointMapper;
|
import com.moral.api.mapper.OrganizationMapper;
|
import com.moral.api.mapper.UserMapper;
|
import com.moral.api.pojo.dto.organization.OrganizationDTO;
|
import com.moral.api.pojo.dto.organization.OrganizationQueryDTO;
|
import com.moral.api.pojo.dto.organization.OrganizationQueryNamesDTO;
|
import com.moral.api.pojo.form.organization.*;
|
import com.moral.api.service.MonitorPointService;
|
import com.moral.api.service.OrganizationService;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.moral.api.service.UserService;
|
import com.moral.api.util.LogUtils;
|
import com.moral.constant.Constants;
|
import com.moral.constant.ResponseCodeEnum;
|
import com.moral.util.ConvertUtils;
|
import com.moral.util.DateUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.boot.context.properties.ConfigurationProperties;
|
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.util.*;
|
import java.util.function.Predicate;
|
|
/**
|
* <p>
|
* 组织表 服务实现类
|
* </p>
|
*
|
* @author moral
|
* @since 2021-04-06
|
*/
|
@Service
|
@ConfigurationProperties(prefix = "log-aspect")
|
public class OrganizationServiceImpl extends ServiceImpl<OrganizationMapper, Organization> implements OrganizationService {
|
|
@Autowired
|
OrganizationMapper organizationMapper;
|
|
@Autowired
|
LogUtils logUtils;
|
|
@Autowired
|
UserService userService;
|
|
@Autowired
|
UserMapper userMapper;
|
|
@Autowired
|
MonitorPointService monitorPointService;
|
|
Map<String, String> organizationFormMap;
|
|
public void setOrganizationFormMap(Map<String, String> organizationFormMap) {
|
this.organizationFormMap = organizationFormMap;
|
}
|
|
/**
|
* @Description: 添加客户组织
|
* @Param: [organizationInsertForm]
|
* @return: void
|
* @Author: 陈凯裕
|
* @Date: 2021/3/22
|
*/
|
|
|
@Override
|
@Transactional
|
public OrganizationDTO insertOrganization(OrganizationInsertForm organizationInsertForm) {
|
OrganizationDTO organizationDTO = new OrganizationDTO();
|
QueryWrapper<Organization> queryWrapper = new QueryWrapper<>();
|
//form转换entity
|
Organization organization = organizationInsertForm.formConvertEntity();
|
//查询组织名称是否已经存在
|
Organization existOrganization = new Organization();
|
existOrganization.setName(organization.getName());
|
existOrganization.setIsDelete(Constants.NOT_DELETE);
|
queryWrapper.setEntity(existOrganization);
|
Organization existOrganizationResult = organizationMapper.selectOne(queryWrapper);
|
if (!ObjectUtils.isEmpty(existOrganizationResult)) {
|
organizationDTO.setCode(ResponseCodeEnum.ORGANIZATION_EXIST.getCode());
|
organizationDTO.setMsg(ResponseCodeEnum.ORGANIZATION_EXIST.getMsg());
|
return organizationDTO;
|
}
|
//插入组织
|
organizationMapper.insert(organization);
|
|
//封装DTO信息
|
organizationDTO.setCode(ResponseCodeEnum.SUCCESS.getCode());
|
organizationDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
|
|
//操作插入日志
|
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
|
StringBuilder content = new StringBuilder();
|
content.append("添加了组织：").append(organization.getName() + ";");
|
logUtils.saveOperationForManage(request, content.toString(), Constants.INSERT_OPERATE_TYPE);
|
return organizationDTO;
|
}
|
|
/**
|
* @Description: 更新客户组织
|
* @Param: [organizationUpdateForm]
|
* @return: com.moral.api.pojo.dto.organization.OrganizationDTO
|
* @Author: 陈凯裕
|
* @Date: 2021/3/24
|
*/
|
@Override
|
@Transactional
|
public OrganizationDTO updateOrganization(OrganizationUpdateForm organizationUpdateForm) {
|
OrganizationDTO organizationDTO = new OrganizationDTO();
|
//form转entity
|
Organization organization = organizationUpdateForm.formConvertEntity();
|
|
//查找要更新的组织用于插入日志
|
QueryWrapper<Organization> oldWrapper = new QueryWrapper<>();
|
Organization oldOrganization = new Organization();
|
oldOrganization.setId(organization.getId());
|
oldOrganization.setIsDelete(Constants.NOT_DELETE);
|
oldWrapper.setEntity(oldOrganization);
|
oldOrganization = organizationMapper.selectOne(oldWrapper);
|
if (ObjectUtils.isEmpty(oldOrganization)) {
|
organizationDTO.setCode(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getCode());
|
organizationDTO.setMsg(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getMsg());
|
return organizationDTO;
|
}
|
|
|
//更新组织
|
organizationMapper.updateById(organization);
|
|
//获取更新后的组织
|
organization = organizationMapper.selectById(organization.getId());
|
|
//封装DTO信息
|
organizationDTO.setCode(ResponseCodeEnum.SUCCESS.getCode());
|
organizationDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
|
|
//操作插入日志
|
insertUpdateLog(organizationUpdateForm, organization, oldOrganization);
|
|
return organizationDTO;
|
}
|
|
|
|
/**
|
* @Description: 删除客户组织
|
* @Param: [organizationDeleteForm]
|
* @return: com.moral.api.pojo.dto.organization.OrganizationDTO
|
* @Author: 陈凯裕
|
* @Date: 2021/3/25
|
*/
|
@Override
|
@Transactional
|
public OrganizationDTO deleteOrganization(OrganizationDeleteForm form) {
|
OrganizationDTO dto = new OrganizationDTO();
|
//取参
|
Integer id = form.getOrganizationId();
|
|
//判断组织是否含有站点
|
List<MonitorPoint> monitorPoints = monitorPointService.getMonitorPointsByOrganizationId(id);
|
if(!ObjectUtils.isEmpty(monitorPoints)){
|
dto.setCode(ResponseCodeEnum.ORGANIZATION_EXIST_MONITORPOINT.getCode());
|
dto.setMsg(ResponseCodeEnum.ORGANIZATION_EXIST_MONITORPOINT.getMsg());
|
return dto;
|
}
|
|
//查询要删除的组织用于插入日志
|
Organization existOrganization = new Organization();
|
existOrganization.setIsDelete(Constants.NOT_DELETE);
|
existOrganization.setId(id);
|
QueryWrapper queryExistWrapper = new QueryWrapper();
|
queryExistWrapper.setEntity(existOrganization);
|
existOrganization = organizationMapper.selectOne(queryExistWrapper);
|
if (ObjectUtils.isEmpty(existOrganization)) {
|
dto.setCode(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getCode());
|
dto.setMsg(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getMsg());
|
return dto;
|
}
|
|
//判断是否含有子组织
|
List<Organization> children = getAllChildrenOrganization(existOrganization.getId());
|
if (!ObjectUtils.isEmpty(children)) {
|
//判断是否删除所有子组织，如果不删除子组织则所有子组织全部变为无父组织，孙子组织不变
|
UpdateWrapper updateWrapper = new UpdateWrapper();
|
if (form.getDeleteChildren().equals(Constants.DELETE_CHILDREN_ORG)) {//删除所有子组织
|
//获取所有子组织的id封装为集合
|
List<Integer> childrenId = new ArrayList<>();
|
children.forEach(value -> {
|
childrenId.add(value.getId());
|
});
|
//判断子组织是否含有站点，有一个子组织含有站点则不能删除
|
for (Integer childId : childrenId) {
|
List<MonitorPoint> childMonitorPoints = monitorPointService.getMonitorPointsByOrganizationId(childId);
|
if(!ObjectUtils.isEmpty(childMonitorPoints)){
|
dto.setCode(ResponseCodeEnum.CHILDREN_ORGANIZATION_EXIST_MONITORPOINT.getCode());
|
dto.setMsg(ResponseCodeEnum.CHILDREN_ORGANIZATION_EXIST_MONITORPOINT.getMsg());
|
return dto;
|
}
|
}
|
//进行删除
|
updateWrapper.in("id", childrenId);
|
updateWrapper.set("is_delete", Constants.DELETE);
|
organizationMapper.update(null, updateWrapper);
|
//删除所有子组织账号
|
childrenId.forEach(value->userService.deleteUsersByOrganizationId(value));
|
|
} else {//不删除
|
//提取所有直属子组织id
|
List<Integer> childrenId = new ArrayList<>();
|
children.forEach(value -> {
|
if (value.getParentId().equals(id))
|
childrenId.add(value.getId());
|
});
|
//进行更新
|
updateWrapper.in("id", childrenId);
|
updateWrapper.set("parent_id", 0);
|
organizationMapper.update(null, updateWrapper);
|
}
|
}
|
|
//逻辑删除组织
|
UpdateWrapper deleteWrapper = new UpdateWrapper();
|
deleteWrapper.eq("id", id);
|
deleteWrapper.set("is_delete", Constants.DELETE);
|
organizationMapper.update(null, deleteWrapper);
|
|
//删除组织账号
|
userService.deleteUsersByOrganizationId(id);
|
|
//封装返回结果
|
dto.setCode(ResponseCodeEnum.SUCCESS.getCode());
|
dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
|
//操作插入日志
|
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
|
StringBuilder content = new StringBuilder();
|
content.append("删除了组织：").append(existOrganization.getName());
|
if (form.getDeleteChildren().equals(Constants.DELETE_CHILDREN_ORG))
|
content.append("以及所有子组织;");
|
else
|
content.append(";");
|
logUtils.saveOperationForManage(request, content.toString(), Constants.DELETE_OPERATE_TYPE);
|
|
return dto;
|
}
|
|
/**
|
* @Description: 查询客户组织
|
* @Param: [organizationQueryForm]
|
* @return: com.moral.api.pojo.dto.organization.OrganizationQueryDTO
|
* @Author: 陈凯裕
|
* @Date: 2021/3/25
|
*/
|
@Override
|
public OrganizationQueryDTO queryOrganization(OrganizationQueryForm organizationQueryForm) {
|
OrganizationQueryDTO dto = new OrganizationQueryDTO();
|
//取参
|
Integer pageCount = organizationQueryForm.getPage();
|
Integer size = organizationQueryForm.getSize();
|
Integer parentId = organizationQueryForm.getParentId();
|
String name = organizationQueryForm.getName();
|
Integer provinceCode = organizationQueryForm.getProvinceCode();
|
Integer cityCode = organizationQueryForm.getCityCode();
|
Integer areaCode = organizationQueryForm.getAreaCode();
|
String phone = organizationQueryForm.getPhone();
|
String email = organizationQueryForm.getEmail();
|
String wechat = organizationQueryForm.getWechat();
|
String isDelete = organizationQueryForm.getIsDelete();
|
String order = organizationQueryForm.getOrder();
|
String orderType = organizationQueryForm.getOrderType();
|
Date createStartTime = organizationQueryForm.getCreateStartTime();
|
Date createEndTime = DateUtils.getDateOfDay(organizationQueryForm.getCreateEndTime(), 1);
|
Date expireStartTime = organizationQueryForm.getExpireStartTime();
|
Date expireEndTime = DateUtils.getDateOfDay(organizationQueryForm.getExpireEndTime(), 1);
|
|
//查询条件
|
Page<Organization> page = new Page<>(pageCount, size);
|
NullFilterWrapper<Organization> queryWrapper = new NullFilterWrapper<>();
|
|
queryWrapper.eq("parent_id", parentId);
|
queryWrapper.like("name", name);
|
queryWrapper.eq("province_code", provinceCode);
|
queryWrapper.eq("city_code", cityCode);
|
queryWrapper.eq("area_code", areaCode);
|
queryWrapper.like("phone", phone);
|
queryWrapper.like("email", email);
|
queryWrapper.like("wechat", wechat);
|
queryWrapper.between("create_time", createStartTime, createEndTime);
|
queryWrapper.between("expire_time", expireStartTime, expireEndTime);
|
|
if (!ObjectUtils.isEmpty(isDelete)) {
|
queryWrapper.eq("is_delete", isDelete);
|
} else {
|
queryWrapper.eq("is_delete", Constants.NOT_DELETE);
|
}
|
|
//排序顺序
|
if (!ObjectUtils.isEmpty(order)) {
|
if (!ObjectUtils.isEmpty(orderType)) {
|
if (orderType.equals(Constants.ORDER_ASC))
|
queryWrapper.orderByAsc(ConvertUtils.toLine(order));
|
else
|
queryWrapper.orderByDesc(ConvertUtils.toLine(order));
|
}
|
}
|
|
//查询结果
|
Page<Organization> resultPage = organizationMapper.selectPage(page, queryWrapper);
|
List<Organization> organizations = resultPage.getRecords();
|
List<OrganizationDTO> organizationDTOS = new ArrayList<>();
|
//查找所有组织的父组织和admin账号并且封装organization到DTO中
|
for (Organization organization : organizations) {
|
OrganizationDTO resultDto = new OrganizationDTO();
|
//查找父组织
|
Organization parent = organizationMapper.selectById(organization.getParentId());
|
resultDto.setOrganization(organization);
|
resultDto.setParentOrganization(parent);
|
//查找admin账号
|
QueryWrapper userWrapper = new QueryWrapper();
|
User adminUser = new User();
|
adminUser.setIsAdmin(true);
|
adminUser.setOrganizationId(organization.getId());
|
adminUser.setIsDelete(Constants.NOT_DELETE);
|
userWrapper.setEntity(adminUser);
|
adminUser = userMapper.selectOne(userWrapper);
|
resultDto.setAdminUser(adminUser);
|
organizationDTOS.add(resultDto);
|
}
|
|
dto.setCode(ResponseCodeEnum.SUCCESS.getCode());
|
dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
|
dto.setOrganizationDTOS(organizationDTOS);
|
dto.setCurrent(page.getCurrent());
|
dto.setPages(page.getPages());
|
dto.setSize(page.getSize());
|
dto.setTotal(page.getTotal());
|
return dto;
|
}
|
|
/**
|
* @Description: 如果form中id为空，则查询所有的组织
|
* 如果id不为空，则查询该id和该id所有子组织之外的所有组织
|
* @Param: [from]
|
* @return: com.moral.api.pojo.dto.organization.OrganizationQueryNamesDTO
|
* @Author: 陈凯裕
|
* @Date: 2021/5/7
|
*/
|
@Override
|
public OrganizationQueryNamesDTO queryNames(OrganizationQueryNamesForm form) {
|
OrganizationQueryNamesDTO dto = new OrganizationQueryNamesDTO();
|
//取参
|
Integer id = form.getId();
|
//构造查询条件
|
QueryWrapper<Organization> queryWrapper = new QueryWrapper();
|
queryWrapper.eq("is_delete", Constants.NOT_DELETE);
|
//查询所有组织
|
List<Organization> organizations = organizationMapper.selectList(queryWrapper);
|
//判断form是否含有id,如果有则对其所有子组织进行过滤
|
if(!ObjectUtils.isEmpty(id)){
|
List<Organization> children = getAllChildrenOrganization(id);
|
List<Integer> thisAndchildrenIds = new ArrayList<>();//该id以及其所有子组织的id集合
|
thisAndchildrenIds.add(id);
|
for (Organization child : children) {
|
thisAndchildrenIds.add(child.getId());
|
}
|
organizations.removeIf(new Predicate<Organization>() {//过滤
|
@Override
|
public boolean test(Organization organization) {
|
if(thisAndchildrenIds.contains(organization.getId()))
|
return true;
|
return false;
|
}
|
});
|
}
|
//封装返回对象
|
dto.setCode(ResponseCodeEnum.SUCCESS.getCode());
|
dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
|
dto.setOrganizations(organizations);
|
return dto;
|
}
|
|
|
/**
|
* @Description: 将更新操作插入日志
|
* @Param: [updateForm, newOrganization, oldOrganization]
|
* @return: void
|
* @Author: 陈凯裕
|
* @Date: 2021/4/8
|
*/
|
private void insertUpdateLog(OrganizationUpdateForm updateForm, Organization newOrganization, Organization oldOrganization) {
|
//操作插入日志
|
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
|
StringBuilder content = new StringBuilder();
|
content.append("修改了组织：").append(oldOrganization.getName()).append(";");
|
//对象转为Map,获取对象更新前后的属性
|
Map<String, Object> newParameters = JSONObject.parseObject(JSON.toJSONString(updateForm), Map.class);
|
Map<String, Object> oldParameters = JSONObject.parseObject(JSON.toJSONString(oldOrganization), Map.class);
|
//遍历配置文件中的Map，将属性转化为汉字
|
Set<String> keys = organizationFormMap.keySet();
|
for (String key : keys) {
|
String value = organizationFormMap.get(key);//属性对应的汉字
|
if ("parentName".equals(key)) {//更新父组织特殊处理
|
if (updateForm.getParentId() != null) {//判断父组织是否进行了更新
|
String oldParentName = "空";
|
String newParentName = "空";
|
if (!oldOrganization.getParentId().equals(0)) {
|
oldParentName = organizationMapper.selectById(oldOrganization.getParentId()).getName();
|
}
|
if (!newOrganization.getParentId().equals(0)) {
|
newParentName = organizationMapper.selectById(newOrganization.getParentId()).getName();
|
}
|
content.append(value + ":" + oldParentName + "->" + newParentName + ";");
|
}
|
} else if ("expireTime".equals(key)) {//expireTime时间格式特殊处理
|
if (updateForm.getExpireTime() != null) {
|
Date oldExpireTime = oldOrganization.getExpireTime();
|
Date newExpireTime = newOrganization.getExpireTime();
|
String oldExpireTimeStr = DateUtils.dateToDateString(oldExpireTime, "yyyy-MM-dd");
|
String newExpireTimeStr = DateUtils.dateToDateString(newExpireTime, "yyyy-MM-dd");
|
content.append(value + ":" + oldExpireTimeStr + "->" + newExpireTimeStr + ";");
|
}
|
} else {//处理其他属性
|
if (newParameters.get(key) != null) {
|
String newValue = "空";
|
String oldValue = "空";
|
if (newParameters.get(key) != null && !newParameters.get(key).equals(" ")) {
|
newValue = String.valueOf(newParameters.get(key));
|
}
|
if (oldParameters.get(key) != null && !oldParameters.get(key).equals(" ")) {
|
oldValue = String.valueOf(oldParameters.get(key));
|
}
|
content.append(value + ":" + oldValue + "->" + newValue + ";");
|
}
|
}
|
}
|
logUtils.saveOperationForManage(request, content.toString(), Constants.UPDATE_OPERATE_TYPE);
|
}
|
|
/**
|
* @Description: 根据父组织获取所有子组织
|
* @Param: []
|
* @return: java.util.List<com.moral.api.entity.Organization>
|
* @Author: 陈凯裕
|
* @Date: 2021/4/14
|
*/
|
private List<Organization> getAllChildrenOrganization(Integer parentId) {
|
List<Organization> children = new ArrayList<>();
|
recursionQueryChildren(parentId, children);
|
return children;
|
}
|
|
/**
|
* @Description: 通过父组织查询下面所有的子组织放到children中
|
* @Param: [parent, children]
|
* @return: void
|
* @Author: 陈凯裕
|
* @Date: 2021/4/14
|
*/
|
private void recursionQueryChildren(Integer parentId, List<Organization> children) {
|
QueryWrapper<Organization> queryWrapper = new QueryWrapper();
|
queryWrapper.eq("is_delete", Constants.NOT_DELETE);
|
queryWrapper.eq("parent_id", parentId);
|
List<Organization> organizations = organizationMapper.selectList(queryWrapper);
|
if (!ObjectUtils.isEmpty(organizations)) {
|
children.addAll(organizations);
|
for (Organization organization : organizations) {
|
recursionQueryChildren(organization.getId(), children);
|
}
|
} else {
|
return;
|
}
|
}
|
|
|
}
|
