package com.moral.api.service.impl;
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.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.CompareFieldUtils;
import com.moral.api.util.LogUtils;
import com.moral.constant.Constants;
import com.moral.constant.ResponseCodeEnum;
import com.moral.pojo.CompareFieldResult;
import com.moral.util.ConvertUtils;
import com.moral.util.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.ObjectUtils;
import java.util.*;
import java.util.function.Predicate;
/**
*
* 组织表 服务实现类
*
*
* @author moral
* @since 2021-04-06
*/
@Service
public class OrganizationServiceImpl extends ServiceImpl implements OrganizationService {
@Autowired
OrganizationMapper organizationMapper;
@Autowired
UserService userService;
@Autowired
UserMapper userMapper;
@Autowired
MonitorPointService monitorPointService;
/**
* @Description: 添加客户组织
* @Param: [organizationInsertForm]
* @return: void
* @Author: 陈凯裕
* @Date: 2021/3/22
*/
@Override
@Transactional
public OrganizationDTO insertOrganization(OrganizationInsertForm organizationInsertForm) {
OrganizationDTO organizationDTO = new OrganizationDTO();
QueryWrapper 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());
//操作插入日志
insertLog(organization);
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 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());
//操作插入日志
updateLog(oldOrganization, organization);
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 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 children = getAllChildrenOrganization(existOrganization.getId());
if (!ObjectUtils.isEmpty(children)) {
//判断是否删除所有子组织,如果不删除子组织则所有子组织全部变为无父组织,孙子组织不变
UpdateWrapper updateWrapper = new UpdateWrapper();
if (form.getDeleteChildren().equals(Constants.DELETE_CHILDREN_ORG)) {//删除所有子组织
//获取所有子组织的id封装为集合
List childrenId = new ArrayList<>();
children.forEach(value -> {
childrenId.add(value.getId());
});
//判断子组织是否含有站点,有一个子组织含有站点则不能删除
for (Integer childId : childrenId) {
List 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 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());
//操作插入日志
StringBuilder content = new StringBuilder();
content.append("删除了组织:").append(existOrganization.getName());
if (form.getDeleteChildren().equals(Constants.DELETE_CHILDREN_ORG))
content.append("以及所有子组织;");
else
content.append(";");
LogUtils.saveOperationForManage(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 page = new Page<>(pageCount, size);
NullFilterWrapper 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 resultPage = organizationMapper.selectPage(page, queryWrapper);
List organizations = resultPage.getRecords();
List 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 queryWrapper = new QueryWrapper();
queryWrapper.eq("is_delete", Constants.NOT_DELETE);
//查询所有组织
List organizations = organizationMapper.selectList(queryWrapper);
//判断form是否含有id,如果有则对其所有子组织进行过滤
if (!ObjectUtils.isEmpty(id)) {
List children = getAllChildrenOrganization(id);
List thisAndchildrenIds = new ArrayList<>();//该id以及其所有子组织的id集合
thisAndchildrenIds.add(id);
for (Organization child : children) {
thisAndchildrenIds.add(child.getId());
}
organizations.removeIf(new Predicate() {//过滤
@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: []
* @return: java.util.List
* @Author: 陈凯裕
* @Date: 2021/4/14
*/
@Override
public List getAllChildrenOrganization(Integer parentId) {
List 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 children) {
QueryWrapper queryWrapper = new QueryWrapper();
queryWrapper.eq("is_delete", Constants.NOT_DELETE);
queryWrapper.eq("parent_id", parentId);
List organizations = organizationMapper.selectList(queryWrapper);
if (!ObjectUtils.isEmpty(organizations)) {
children.addAll(organizations);
for (Organization organization : organizations) {
recursionQueryChildren(organization.getId(), children);
}
} else {
return;
}
}
/**
* @Description: 插入操作插入日志
* @Param: [organization]
* @return: void
* @Author: 陈凯裕
* @Date: 2021/8/25
*/
private void insertLog(Organization organization) {
StringBuilder content = new StringBuilder();
content.append("添加了组织:").append(organization.getName() + ";");
LogUtils.saveOperationForManage(content.toString(), Constants.INSERT_OPERATE_TYPE);
}
public void updateLog(Organization oldOrganization, Organization newOrganization) {
List results = CompareFieldUtils.compare(Organization.class, oldOrganization, newOrganization);
for (CompareFieldResult result : results) {
//改变父组织特殊处理
if (result.getFieldName().equals("parentId")) {
//父组织id转换为名称
String oldData = result.getOldData();
String newData = result.getNewData();
if (!oldData.equals("0"))
oldData = organizationMapper.selectById(Integer.parseInt(oldData)).getName();
else
oldData = "null";
if (!newData.equals("0"))
newData = organizationMapper.selectById(Integer.parseInt(newData)).getName();
else
newData = "null";
result.setNewData(newData);
result.setOldData(oldData);
result.setFieldAnnoName("父组织");
}
//过期时间格式转换
if (result.getFieldName().equals("expireTime")) {
//DateToString的时间格式改为yyyy-MM-dd
String oldData = result.getOldData();
String newData = result.getNewData();
if (oldData != null) {
Date oldDate = DateUtils.dateStringToDate(oldData);
oldData = DateUtils.dateToDateString(oldDate, "yyyy-MM-dd");
}
if (newData != null) {
Date newDate = DateUtils.dateStringToDate(newData);
newData = DateUtils.dateToDateString(newDate, "yyyy-MM-dd");
}
result.setNewData(newData);
result.setOldData(oldData);
result.setFieldAnnoName("过期时间");
}
}
String content = CompareFieldUtils.resultsConvertContent(results, "修改了组织;组织名称:" + oldOrganization.getName());
LogUtils.saveOperationForManage(content, Constants.UPDATE_OPERATE_TYPE);
}
}