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); } }