| | |
| | | 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.form.organization.OrganizationDeleteForm; |
| | | import com.moral.api.pojo.form.organization.OrganizationInsertForm; |
| | | import com.moral.api.pojo.form.organization.OrganizationQueryForm; |
| | | import com.moral.api.pojo.form.organization.OrganizationUpdateForm; |
| | | 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.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.*; |
| | | import java.util.function.Predicate; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | * </p> |
| | | * |
| | | * @author moral |
| | | * @since 2021-03-09 |
| | | * @since 2021-04-06 |
| | | */ |
| | | @Service |
| | | public class OrganizationServiceImpl extends ServiceImpl<OrganizationMapper, Organization> implements OrganizationService { |
| | | |
| | | @Autowired |
| | | OrganizationMapper organizationMapper; |
| | | |
| | | @Autowired |
| | | UserService userService; |
| | | |
| | | @Autowired |
| | | UserMapper userMapper; |
| | | |
| | | @Autowired |
| | | MonitorPointService monitorPointService; |
| | | |
| | | /** |
| | | * @Description: 添加客户组织 |
| | |
| | | organizationDTO.setMsg(ResponseCodeEnum.ORGANIZATION_EXIST.getMsg()); |
| | | return organizationDTO; |
| | | } |
| | | //查询父组织是否存在 |
| | | Integer parentId = organization.getParentId(); |
| | | Organization parentOrganization = new Organization(); |
| | | if (!ObjectUtils.isEmpty(parentId)) { |
| | | parentOrganization.setId(parentId); |
| | | parentOrganization.setIsDelete(Constants.NOT_DELETE); |
| | | queryWrapper.setEntity(parentOrganization); |
| | | parentOrganization = organizationMapper.selectOne(queryWrapper); |
| | | if (ObjectUtils.isEmpty(parentOrganization)) { |
| | | organizationDTO.setCode(ResponseCodeEnum.ORGANIZATION_PARENT_NOT_EXIST.getCode()); |
| | | organizationDTO.setMsg(ResponseCodeEnum.ORGANIZATION_PARENT_NOT_EXIST.getMsg()); |
| | | return organizationDTO; |
| | | } |
| | | } |
| | | //插入组织 |
| | | organizationMapper.insert(organization); |
| | | |
| | | //封装DTO信息 |
| | | organizationDTO.setParentOrganization(parentOrganization); |
| | | organizationDTO.setOrganization(organization); |
| | | organizationDTO.setCode(ResponseCodeEnum.SUCCESS.getCode()); |
| | | organizationDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg()); |
| | | |
| | | //操作插入日志 |
| | | insertLog(organization); |
| | | return organizationDTO; |
| | | } |
| | | |
| | |
| | | //form转entity |
| | | Organization organization = organizationUpdateForm.formConvertEntity(); |
| | | |
| | | //查询组织是否存在 |
| | | QueryWrapper<Organization> existWrapper = new QueryWrapper<>(); |
| | | Organization existOrganization = new Organization(); |
| | | existOrganization.setId(organization.getId()); |
| | | existOrganization.setIsDelete(Constants.NOT_DELETE); |
| | | existWrapper.setEntity(existOrganization); |
| | | existOrganization = organizationMapper.selectOne(existWrapper); |
| | | if (ObjectUtils.isEmpty(existOrganization)) { |
| | | //查找要更新的组织用于插入日志 |
| | | 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; |
| | | } |
| | | |
| | | //如果更改了父组织,查询父组织是否存在 |
| | | Integer parentId = organization.getParentId(); |
| | | Organization parentOrganization = new Organization(); |
| | | if (!ObjectUtils.isEmpty(parentId) && parentId != 0) { |
| | | QueryWrapper<Organization> existParentWrapper = new QueryWrapper<>(); |
| | | parentOrganization.setId(parentId); |
| | | parentOrganization.setIsDelete(Constants.NOT_DELETE); |
| | | existParentWrapper.setEntity(parentOrganization); |
| | | parentOrganization = organizationMapper.selectOne(existParentWrapper); |
| | | if (ObjectUtils.isEmpty(parentOrganization)) { |
| | | organizationDTO.setCode(ResponseCodeEnum.ORGANIZATION_PARENT_NOT_EXIST.getCode()); |
| | | organizationDTO.setMsg(ResponseCodeEnum.ORGANIZATION_PARENT_NOT_EXIST.getMsg()); |
| | | return organizationDTO; |
| | | } |
| | | } |
| | | |
| | | //更新组织 |
| | | organizationMapper.updateById(organization); |
| | | |
| | | //获取更新后的组合 |
| | | //获取更新后的组织 |
| | | organization = organizationMapper.selectById(organization.getId()); |
| | | |
| | | //封装DTO信息 |
| | | organizationDTO.setParentOrganization(parentOrganization); |
| | | organizationDTO.setOrganization(organization); |
| | | organizationDTO.setCode(ResponseCodeEnum.SUCCESS.getCode()); |
| | | organizationDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg()); |
| | | |
| | | //操作插入日志 |
| | | updateLog(oldOrganization, organization); |
| | | |
| | | return organizationDTO; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 删除客户组织 |
| | |
| | | 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); |
| | |
| | | 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); |
| | | //判断是否删除所有子组织,如果不删除则将子组织parentId赋0 |
| | | if (form.getDeleteChildren().equals(Constants.DELETE_CHILDREN_ORG)) { |
| | | UpdateWrapper deleteChildrenWrapper = new UpdateWrapper(); |
| | | deleteChildrenWrapper.eq("parent_id", id); |
| | | deleteChildrenWrapper.set("is_delete", Constants.DELETE); |
| | | organizationMapper.update(null, deleteChildrenWrapper); |
| | | } else { |
| | | UpdateWrapper updateChildrenWrapper = new UpdateWrapper(); |
| | | updateChildrenWrapper.eq("parent_id", id); |
| | | updateChildrenWrapper.set("parent_id", 0); |
| | | organizationMapper.update(null, updateChildrenWrapper); |
| | | } |
| | | |
| | | dto.setOrganization(existOrganization); |
| | | //删除组织账号 |
| | | 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; |
| | | } |
| | | |
| | |
| | | Integer provinceCode = organizationQueryForm.getProvinceCode(); |
| | | Integer cityCode = organizationQueryForm.getCityCode(); |
| | | Integer areaCode = organizationQueryForm.getAreaCode(); |
| | | Long townCode = organizationQueryForm.getTownCode(); |
| | | Long villageCode = organizationQueryForm.getVillageCode(); |
| | | String phone = organizationQueryForm.getPhone(); |
| | | String email = organizationQueryForm.getEmail(); |
| | | String wechat = organizationQueryForm.getWechat(); |
| | |
| | | queryWrapper.eq("province_code", provinceCode); |
| | | queryWrapper.eq("city_code", cityCode); |
| | | queryWrapper.eq("area_code", areaCode); |
| | | queryWrapper.eq("town_code", townCode); |
| | | queryWrapper.eq("village_code", villageCode); |
| | | queryWrapper.like("phone", phone); |
| | | queryWrapper.like("email", email); |
| | | queryWrapper.like("wechat", wechat); |
| | |
| | | Page<Organization> resultPage = organizationMapper.selectPage(page, queryWrapper); |
| | | List<Organization> organizations = resultPage.getRecords(); |
| | | List<OrganizationDTO> organizationDTOS = new ArrayList<>(); |
| | | //查找所有组织的父组织 |
| | | for (Organization child : organizations) { |
| | | //查找所有组织的父组织和admin账号并且封装organization到DTO中 |
| | | for (Organization organization : organizations) { |
| | | OrganizationDTO resultDto = new OrganizationDTO(); |
| | | Organization parent = organizationMapper.selectById(child.getParentId()); |
| | | resultDto.setOrganization(child); |
| | | //查找父组织 |
| | | 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.setMsg(ResponseCodeEnum.SUCCESS.getMsg()); |
| | | dto.setOrganizationDTOS(organizationDTOS); |
| | | dto.setCurrent(page.getCurrent()); |
| | | dto.setPage(page.getPages()); |
| | | 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: [] |
| | | * @return: java.util.List<com.moral.api.entity.Organization> |
| | | * @Author: 陈凯裕 |
| | | * @Date: 2021/4/14 |
| | | */ |
| | | @Override |
| | | public 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; |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * @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<CompareFieldResult> 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); |
| | | } |
| | | |
| | | } |