From 8f9f72a3f92de3a1a5f2faf1eaff583fbe6e70fb Mon Sep 17 00:00:00 2001 From: kaiyu <404897439@qq.com> Date: Wed, 12 May 2021 11:06:50 +0800 Subject: [PATCH] screen-manage 增加单位转换模块,增加功能,查询功能 --- screen-manage/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java | 433 ++++++++++++++++++++++++++++++++++++++++++----------- 1 files changed, 343 insertions(+), 90 deletions(-) diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java index dc16393..2de9059 100644 --- a/screen-manage/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java +++ b/screen-manage/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java @@ -1,26 +1,38 @@ 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.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.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 java.util.List; +import javax.servlet.http.HttpServletRequest; +import java.util.*; +import java.util.function.Predicate; /** * <p> @@ -28,13 +40,29 @@ * </p> * * @author moral - * @since 2021-03-09 + * @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; + + Map<String, String> organizationFormMap; + + public void setOrganizationFormMap(Map<String, String> organizationFormMap) { + this.organizationFormMap = organizationFormMap; + } /** * @Description: ������������������ @@ -43,6 +71,8 @@ * @Author: ��������� * @Date: 2021/3/22 */ + + @Override @Transactional public OrganizationDTO insertOrganization(OrganizationInsertForm organizationInsertForm) { @@ -55,159 +85,382 @@ existOrganization.setName(organization.getName()); existOrganization.setIsDelete(Constants.NOT_DELETE); queryWrapper.setEntity(existOrganization); - List<Organization> existOrganizations = organizationMapper.selectList(queryWrapper); - if (!ObjectUtils.isEmpty(existOrganizations)) { + Organization existOrganizationResult = organizationMapper.selectOne(queryWrapper); + if (!ObjectUtils.isEmpty(existOrganizationResult)) { organizationDTO.setCode(ResponseCodeEnum.ORGANIZATION_EXIST.getCode()); 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()); + + //������������������ + 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 - */ + * @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> 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()); + + //������������������ + insertUpdateLog(organizationUpdateForm, organization, oldOrganization); + return organizationDTO; } + + /** - * @Description: ������������������ - * @Param: [organizationDeleteForm] - * @return: com.moral.api.pojo.dto.organization.OrganizationDTO - * @Author: ��������� - * @Date: 2021/3/25 - */ + * @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(); - //������������������������ + + //������������������������������������������ 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)){ + if (ObjectUtils.isEmpty(existOrganization)) { dto.setCode(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getCode()); dto.setMsg(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getMsg()); return dto; } + //������������������ 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); + deleteWrapper.eq("id", id); + deleteWrapper.set("is_delete", Constants.DELETE); + organizationMapper.update(null, deleteWrapper); + + //������������������ + userService.deleteUserByOrganizationId(id); + + //��������������������������� + 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()); + }); + //������������ + updateWrapper.in("id", childrenId); + updateWrapper.set("is_delete", Constants.DELETE); + organizationMapper.update(null, updateWrapper); + //��������������������������� + childrenId.forEach(value->userService.deleteUserByOrganizationId(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); + } } - dto.setOrganization(existOrganization); + //������������������ 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 - */ + * @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(); //������ - Organization organization = organizationQueryForm.formConvertEntity(); 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); - QueryWrapper<Organization> queryWrapper = new QueryWrapper<>(); - return null; + //������������ + 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; + } } -- Gitblit v1.8.0