[Java] easyExcel导入组织结构精选
2021/10/19 22:09:40
本文主要是介绍[Java] easyExcel导入组织结构精选，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！
模板
表结构
HSGD_BASE_GROUP_IMPORT_RECORD
HSGD_BASE_GROUP_IMPORT_COMPLETION
HSGD_BASE_GROUP_NOT_IMPORT_RECORD
代码
package com.zhgd.base.controller.api;
import com.zhgd.base.service.IZhgdSrBaseGroupImportService;
import com.zhgd.common.util.JsonUtil;
import com.zhgd.common.web.ResponseResult;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
import javax.annotation.Resource;
import java.util.List;
/**
* 描述 掌柜组织改版：1-导入组织部门
*
* @author wangzhizhong
* @version 1.0.0
* @date 2021/10/11 16:07:20
*/
@RestController
@Api(tags = "Zhgd Sr Base Group Import Controller")
@RequestMapping(value = "/api/srBaseGroupImport")
@Slf4j
public class ApiZhgdSrBaseGroupImportController {
@Resource
private IZhgdSrBaseGroupImportService iZhgdSrBaseGroupImportService;
@ApiOperation(value = "掌柜组织改版导入组织接口-V2版本", response = String.class, notes = "Import Base Group V2")
@PostMapping(value = "/11201/v2/importBaseGroup")
public ResponseResult<List<String>> importBaseGroupV2(@RequestParam("importFile") MultipartFile importFile){
String importFileName1 = importFile != null ? importFile.getOriginalFilename() : "--";
log.info("[掌柜组织改版]导入部门组织，导入文件名：{}",importFileName1);
ResponseResult<List<String>> result = new ResponseResult<>();
result.setData(iZhgdSrBaseGroupImportService.importBaseGroupProcessV2(importFile));
log.info("[掌柜组织改版]导入部门组织，导入文件名：{}", JsonUtil.toJSONString(result));
return result;
}
}
public interface IZhgdSrBaseGroupImportService {
void batchInsertAll(List<HsgdBaseGroupImportRecord> recordList);
List<String> importBaseGroupProcess(MultipartFile importFile);
void insert(HsgdBaseGroupImportRecord record);
HsgdBaseGroupSimpleVO getGroupSimpleByGroupNameAndLevel(String levelGroupName, Integer groupLevel);
HsgdBaseGroupSimpleVO getGroupSimpleByGroupNameAndParentIdAndLevel(String levelGroupName, Long groupId, Integer groupLevel);
List<String> importBaseGroupProcessV2(MultipartFile importFile);
HsgdBaseGroupSimpleVO getGroupSimpleByGroupNameAndLevelAndParentId(String levelGroupName, Integer groupLevel,Long parentId);
}
package com.zhgd.base.service.impl;
import com.alibaba.excel.EasyExcel;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.github.pagehelper.PageHelper;
import com.zhgd.base.domain.model.ZhgdSrGroupImportModel;
import com.zhgd.base.domain.vo.HsgdBaseGroupSimpleVO;
import com.zhgd.base.entity.*;
import com.zhgd.base.enums.HsgdBaseGroupLevelEnum;
import com.zhgd.base.listener.ZhgdSrBaseGroupImportExcelListener;
import com.zhgd.base.mapper.*;
import com.zhgd.base.service.IHsgdBaseGroupNotImportRecordService;
import com.zhgd.base.service.IZhgdSrBaseGroupImportHandleService;
import com.zhgd.base.service.IZhgdSrBaseGroupImportService;
import com.zhgd.common.util.JsonUtil;
import com.zhgd.common.util.UUIDUtils;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.collections.CollectionUtils;
import org.apache.commons.lang.StringUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;
import javax.annotation.Resource;
import java.util.*;
import java.util.stream.Collectors;
@Service
@Slf4j
public class ZhgdSrBaseGroupImportServiceImpl implements IZhgdSrBaseGroupImportService {
private final String SYSTEM_USER_NAME = "system";
@Resource
private IZhgdSrBaseGroupImportHandleService iZhgdSrBaseGroupImportHandleService;
@Resource
private HsgdBaseGroupImportRecordMapper hsgdBaseGroupImportRecordMapper;
@Resource
private HsgdBaseGroupMapper hsgdBaseGroupMapper;
@Resource
private HsgdBaseGroupInfoMapper hsgdBaseGroupInfoMapper;
@Resource
private HsgdBaseGroupLabelDictMapper hsgdBaseGroupLabelDictMapper;
@Resource
private HsgdBaseGroupLabelMapper hsgdBaseGroupLabelMapper;
@Resource
private HsgdBaseGroupRegionMapper hsgdBaseGroupRegionMapper;
@Resource
private CrmRegionMapper crmRegionMapper;
@Resource
private HsgdBaseGroupImportCompletionMapper hsgdBaseGroupImportCompletionMapper;
@Resource
private IHsgdBaseGroupNotImportRecordService iHsgdBaseGroupNotImportRecordService;
/**
* 导入流程 V1
* @param importFile
* @return
*/
@Override
public List<String> importBaseGroupProcess(MultipartFile importFile) {
List<String> importResultList = new ArrayList<>();
try {
String batchNo = UUIDUtils.getUUID();
// 1、导入数据
ZhgdSrBaseGroupImportExcelListener listener = new ZhgdSrBaseGroupImportExcelListener(iZhgdSrBaseGroupImportHandleService, batchNo);
EasyExcel.read(importFile.getInputStream(), ZhgdSrGroupImportModel.class, listener).sheet(0).doRead();
// 2、文件校验(待处理)
// 3、组织数据
int totalRecord = this.organizeAndSaveBaseGroupCompletionData(batchNo);
this.saveBaseGroupData(batchNo,totalRecord);
} catch (Exception e) {
log.info("组织改版组织导入异常", e);
importResultList.add("导入异常！" + e.getMessage());
return importResultList;
}
importResultList.add("导入成功！");
return importResultList;
}
private int organizeAndSaveBaseGroupCompletionData(String batchNo) {
int importDataTotal = hsgdBaseGroupImportRecordMapper.countImportBaseGroupDataTotalByBatchNo(batchNo);
if (importDataTotal > 0) {
// 每页记录数
int pageSize = 500, startPage = 1;
// 总页数
int totalPage = importDataTotal % pageSize == 0 ? (importDataTotal / pageSize) : (importDataTotal / pageSize + 1);
String groupOneLevel = "";
String groupTwoLevel = "";
String groupThreeLevel = "";
String groupFourLevel = "";
String groupFiveLevel = "";
String groupSixLevel = "";
String groupSevenLevel = "";
for (int pageN = 0; pageN < totalPage; pageN++) {
PageHelper.startPage(startPage + pageN, pageSize, false);
List<HsgdBaseGroupImportRecord> list = hsgdBaseGroupImportRecordMapper.selectListByBatchNo(batchNo);
if (CollectionUtils.isNotEmpty(list)) {
List<HsgdBaseGroupImportCompletion> completionList = new ArrayList<>();
HsgdBaseGroupImportCompletion completion;
for (int i = 0, listSize = list.size(); i < listSize; i++) {
HsgdBaseGroupImportRecord record = list.get(i);
completion = new HsgdBaseGroupImportCompletion();
if (StringUtils.isNotBlank(record.getLevelOneGroup())) {
groupOneLevel = record.getLevelOneGroup();
completion.setGroupLevel(HsgdBaseGroupLevelEnum.ONE.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelTwoGroup())) {
groupTwoLevel = record.getLevelTwoGroup();
record.setLevelOneGroup(groupOneLevel);
completion.setGroupLevel(HsgdBaseGroupLevelEnum.TWO.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelThreeGroup())) {
groupThreeLevel = record.getLevelThreeGroup();
record.setLevelOneGroup(groupOneLevel);
record.setLevelTwoGroup(groupTwoLevel);
completion.setGroupLevel(HsgdBaseGroupLevelEnum.THREE.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelFourGroup())) {
groupFourLevel = record.getLevelFourGroup();
record.setLevelOneGroup(groupOneLevel);
record.setLevelTwoGroup(groupTwoLevel);
record.setLevelThreeGroup(groupThreeLevel);
completion.setGroupLevel(HsgdBaseGroupLevelEnum.FOUR.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelFiveGroup())) {
groupFiveLevel = record.getLevelFiveGroup();
record.setLevelOneGroup(groupOneLevel);
record.setLevelTwoGroup(groupTwoLevel);
record.setLevelThreeGroup(groupThreeLevel);
record.setLevelFourGroup(groupFourLevel);
completion.setGroupLevel(HsgdBaseGroupLevelEnum.FIVE.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelSixGroup())) {
groupSixLevel = record.getLevelSixGroup();
record.setLevelOneGroup(groupOneLevel);
record.setLevelTwoGroup(groupTwoLevel);
record.setLevelThreeGroup(groupThreeLevel);
record.setLevelFourGroup(groupFourLevel);
record.setLevelFiveGroup(groupFiveLevel);
completion.setGroupLevel(HsgdBaseGroupLevelEnum.SIX.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelSevenGroup())) {
groupSevenLevel = record.getLevelSevenGroup();
record.setLevelOneGroup(groupOneLevel);
record.setLevelTwoGroup(groupTwoLevel);
record.setLevelThreeGroup(groupThreeLevel);
record.setLevelFourGroup(groupFourLevel);
record.setLevelFiveGroup(groupFiveLevel);
record.setLevelSixGroup(groupSixLevel);
completion.setGroupLevel(HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelEightGroup())) {
record.setLevelOneGroup(groupOneLevel);
record.setLevelTwoGroup(groupTwoLevel);
record.setLevelThreeGroup(groupThreeLevel);
record.setLevelFourGroup(groupFourLevel);
record.setLevelFiveGroup(groupFiveLevel);
record.setLevelSixGroup(groupSixLevel);
record.setLevelSevenGroup(groupSevenLevel);
completion.setGroupLevel(HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel());
}
BeanUtils.copyProperties(record, completion);
completionList.add(completion);
}
iZhgdSrBaseGroupImportHandleService.insertAllImportCompletion(completionList);
}
}
}
return importDataTotal;
}
private void saveBaseGroupData(String batchNo,int totalRecord ) {
if(totalRecord > 0) {
// 每页记录数
int pageSize = 500, startPage = 1;
// 总页数
int totalPage = totalRecord % pageSize == 0 ? (totalRecord / pageSize) : (totalRecord / pageSize + 1);
Date nowDate = new Date();
Long parentId ;
Map<String, HsgdBaseGroupSimpleVO> groupOneLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupTwoLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupThreeLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupFourLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupFiveLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupSixLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupSevenLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupEightLevelMap = new HashMap<>();
Map<String, Long> labelMap = this.getGroupLabelMap();
Map<String,CrmRegion> regionMap = new HashMap<>();
for (int pageN = 0; pageN < totalPage; pageN++) {
PageHelper.startPage(startPage + pageN, pageSize, false);
List<HsgdBaseGroupImportCompletion> importCompletionList = hsgdBaseGroupImportCompletionMapper.selectListByBatchNo(batchNo);
if(CollectionUtils.isNotEmpty(importCompletionList)){
List<HsgdBaseGroupNotImportRecord> errorRecordList = new ArrayList<>();
HsgdBaseGroupNotImportRecord notImportRecord;
this.getPageAllRegionToRegionMap(regionMap,importCompletionList);
for (HsgdBaseGroupImportCompletion completionVO : importCompletionList){
try {
if (HsgdBaseGroupLevelEnum.ONE.getGroupLevel().equals(completionVO.getGroupLevel())) {
if (groupOneLevelMap.get(completionVO.getLevelOneGroup()) == null) {
HsgdBaseGroupSimpleVO simpleOneVO = this.getGroupSimpleByGroupNameAndLevel(completionVO.getLevelOneGroup(), completionVO.getGroupLevel());
if (simpleOneVO != null) {
groupOneLevelMap.put(completionVO.getLevelOneGroup(), simpleOneVO);
} else {
simpleOneVO = this.generatorGroupLevel(completionVO, nowDate, labelMap, regionMap, 0L);
groupOneLevelMap.put(completionVO.getLevelOneGroup(), simpleOneVO);
}
}
} else if (HsgdBaseGroupLevelEnum.TWO.getGroupLevel().equals(completionVO.getGroupLevel())) {
HsgdBaseGroupSimpleVO oneSiVO = groupOneLevelMap.get(completionVO.getLevelOneGroup());
parentId = oneSiVO.getGroupId();
if (groupTwoLevelMap.get(completionVO.getLevelTwoGroup()) == null) {
HsgdBaseGroupSimpleVO simpleTwoVO = this.getGroupSimpleByGroupNameAndLevel(completionVO.getLevelTwoGroup(), completionVO.getGroupLevel());
if (simpleTwoVO != null) {
groupTwoLevelMap.put(completionVO.getLevelTwoGroup(), simpleTwoVO);
} else {
simpleTwoVO = this.generatorGroupLevel(completionVO, nowDate, labelMap, regionMap, parentId);
groupTwoLevelMap.put(completionVO.getLevelTwoGroup(), simpleTwoVO);
}
}
} else if (HsgdBaseGroupLevelEnum.THREE.getGroupLevel().equals(completionVO.getGroupLevel())) {
HsgdBaseGroupSimpleVO twoSiVO = groupTwoLevelMap.get(completionVO.getLevelTwoGroup());
parentId = twoSiVO.getGroupId();
if (groupThreeLevelMap.get(completionVO.getLevelThreeGroup()) == null) {
HsgdBaseGroupSimpleVO simpleThreeVO = this.getGroupSimpleByGroupNameAndLevel(completionVO.getLevelThreeGroup(), completionVO.getGroupLevel());
if (simpleThreeVO != null) {
groupThreeLevelMap.put(completionVO.getLevelThreeGroup(), simpleThreeVO);
} else {
simpleThreeVO = this.generatorGroupLevel(completionVO, nowDate, labelMap, regionMap, parentId);
groupThreeLevelMap.put(completionVO.getLevelThreeGroup(), simpleThreeVO);
}
}
} else if (HsgdBaseGroupLevelEnum.FOUR.getGroupLevel().equals(completionVO.getGroupLevel())) {
HsgdBaseGroupSimpleVO threeSiVO = groupThreeLevelMap.get(completionVO.getLevelThreeGroup());
parentId = threeSiVO.getGroupId();
if (groupFourLevelMap.get(completionVO.getLevelFourGroup()) == null) {
HsgdBaseGroupSimpleVO simplefourVO = this.getGroupSimpleByGroupNameAndLevel(completionVO.getLevelFourGroup(), completionVO.getGroupLevel());
if (simplefourVO != null) {
groupFourLevelMap.put(completionVO.getLevelFourGroup(), simplefourVO);
} else {
simplefourVO = this.generatorGroupLevel(completionVO, nowDate, labelMap, regionMap, parentId);
groupFourLevelMap.put(completionVO.getLevelFourGroup(), simplefourVO);
}
}
} else if (HsgdBaseGroupLevelEnum.FIVE.getGroupLevel().equals(completionVO.getGroupLevel())) {
HsgdBaseGroupSimpleVO fourSiVO = groupFourLevelMap.get(completionVO.getLevelFourGroup());
parentId = fourSiVO.getGroupId();
String fiveKey = completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup();
if (groupFiveLevelMap.get(fiveKey) == null) {
HsgdBaseGroupSimpleVO simplefourVO = this.getGroupSimpleByGroupNameAndParentIdAndLevel(completionVO.getLevelFiveGroup(), parentId, completionVO.getGroupLevel());
if (simplefourVO != null) {
groupFiveLevelMap.put(fiveKey, simplefourVO);
} else {
simplefourVO = this.generatorGroupLevel(completionVO, nowDate, labelMap, regionMap, parentId);
groupFiveLevelMap.put(fiveKey, simplefourVO);
}
}
} else if (HsgdBaseGroupLevelEnum.SIX.getGroupLevel().equals(completionVO.getGroupLevel())) {
HsgdBaseGroupSimpleVO fiveSiVO = groupFiveLevelMap.get(completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup());
parentId = fiveSiVO.getGroupId();
String sixKey = completionVO.getLevelFiveGroup() + "-" + completionVO.getLevelSixGroup();
if (groupSixLevelMap.get(sixKey) == null) {
HsgdBaseGroupSimpleVO simplefourVO = this.getGroupSimpleByGroupNameAndParentIdAndLevel(completionVO.getLevelSixGroup(), parentId, completionVO.getGroupLevel());
if (simplefourVO != null) {
groupSixLevelMap.put(sixKey, simplefourVO);
} else {
simplefourVO = this.generatorGroupLevel(completionVO, nowDate, labelMap, regionMap, parentId);
groupSixLevelMap.put(sixKey, simplefourVO);
}
}
} else if (HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel().equals(completionVO.getGroupLevel())) {
HsgdBaseGroupSimpleVO sixSiVO = groupSixLevelMap.get(completionVO.getLevelFiveGroup() + "-" + completionVO.getLevelSixGroup());
parentId = sixSiVO.getGroupId();
String sevenKey = completionVO.getLevelSixGroup() + "-" + completionVO.getLevelSevenGroup();
if (groupSevenLevelMap.get(sevenKey) == null) {
HsgdBaseGroupSimpleVO simplefourVO = this.getGroupSimpleByGroupNameAndParentIdAndLevel(completionVO.getLevelSixGroup(), parentId, completionVO.getGroupLevel());
if (simplefourVO != null) {
groupSevenLevelMap.put(sevenKey, simplefourVO);
} else {
simplefourVO = this.generatorGroupLevel(completionVO, nowDate, labelMap, regionMap, parentId);
groupSevenLevelMap.put(sevenKey, simplefourVO);
}
}
} else if (HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel().equals(completionVO.getGroupLevel())) {
HsgdBaseGroupSimpleVO sevenSiVO = groupSevenLevelMap.get(completionVO.getLevelSixGroup() + "-" + completionVO.getLevelSevenGroup());
parentId = sevenSiVO.getGroupId();
String eightKey = completionVO.getLevelSevenGroup() + "-" + completionVO.getLevelEightGroup();
if (groupEightLevelMap.get(eightKey) == null) {
HsgdBaseGroupSimpleVO simplefourVO = this.getGroupSimpleByGroupNameAndParentIdAndLevel(completionVO.getLevelEightGroup(), sevenSiVO.getGroupId(), completionVO.getGroupLevel());
if (simplefourVO != null) {
groupEightLevelMap.put(eightKey, simplefourVO);
} else {
simplefourVO = this.generatorGroupLevel(completionVO, nowDate, labelMap, regionMap, parentId);
groupEightLevelMap.put(eightKey, simplefourVO);
}
}
}
} catch (Exception e) {
log.info("组织{}导入失败", JsonUtil.toJSONString(completionVO));
log.info("组织"+JsonUtil.toJSONString(completionVO)+"导入失败",e);
notImportRecord = new HsgdBaseGroupNotImportRecord();
BeanUtils.copyProperties(completionVO,notImportRecord);
errorRecordList.add(notImportRecord);
}
}
if(CollectionUtils.isNotEmpty(errorRecordList)){
iHsgdBaseGroupNotImportRecordService.saveBatch(errorRecordList);
}
}
}
}
}
@Override
public List<String> importBaseGroupProcessV2(MultipartFile importFile) {
List<String> importResultList = new ArrayList<>();
try {
// 批次号
String batchNo = UUIDUtils.getUUID();
// 1、导入数据
ZhgdSrBaseGroupImportExcelListener listener = new ZhgdSrBaseGroupImportExcelListener(iZhgdSrBaseGroupImportHandleService, batchNo);
EasyExcel.read(importFile.getInputStream(), ZhgdSrGroupImportModel.class, listener).sheet(0).doRead();
// 2、组织整理数据
int totalRecord = this.organizeAndSaveBaseGroupCompletionDataV2(batchNo);
// 3、保存组织数据
this.saveBaseGroupDataV2(batchNo,totalRecord);
} catch (Exception e) {
log.info("组织改版组织导入异常", e);
importResultList.add("导入异常 ：" + e.getMessage());
return importResultList;
}
importResultList.add("执行完成,请检查是否全部导入成功！");
return importResultList;
}
private int organizeAndSaveBaseGroupCompletionDataV2(String batchNo) {
int importDataTotal = hsgdBaseGroupImportRecordMapper.countImportBaseGroupDataTotalByBatchNo(batchNo);
if (importDataTotal > 0) {
// 每页记录数，起始页
int pageSize = 120, startPage = 1;
// 总页数
int totalPage = importDataTotal % pageSize == 0 ? (importDataTotal / pageSize) : (importDataTotal / pageSize + 1);
String groupOneLevel = "";
String groupTwoLevel = "";
String groupThreeLevel = "";
String groupFourLevel = "";
String groupFiveLevel = "";
String groupSixLevel = "";
String groupSevenLevel = "";
String groupEightLevel = "";
String groupRecordRe = "";
int groupOneSort = 0;
int groupTwoSort = 0;
int groupThreeSort = 0;
int groupFourSort = 0;
int groupFiveSort = 0;
int groupSixSort = 0;
int groupSevenSort = 0;
int groupEightSort = 0;
for (int pageN = 0; pageN < totalPage; pageN++) {
PageHelper.startPage(startPage + pageN, pageSize, false);
List<HsgdBaseGroupImportRecord> list = hsgdBaseGroupImportRecordMapper.selectListByBatchNo(batchNo);
if (CollectionUtils.isNotEmpty(list)) {
List<HsgdBaseGroupImportCompletion> completionList = new ArrayList<>();
HsgdBaseGroupImportCompletion completion;
for (int i = 0, listSize = list.size(); i < listSize; i++) {
HsgdBaseGroupImportRecord record = list.get(i);
completion = new HsgdBaseGroupImportCompletion();
BeanUtils.copyProperties(record, completion);
if (StringUtils.isNotBlank(record.getLevelOneGroup())) {
completion.setGroupLevel(HsgdBaseGroupLevelEnum.ONE.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelTwoGroup())) {
completion.setGroupLevel(HsgdBaseGroupLevelEnum.TWO.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelThreeGroup())) {
completion.setGroupLevel(HsgdBaseGroupLevelEnum.THREE.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelFourGroup())) {
completion.setGroupLevel(HsgdBaseGroupLevelEnum.FOUR.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelFiveGroup())) {
completion.setGroupLevel(HsgdBaseGroupLevelEnum.FIVE.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelSixGroup())) {
completion.setGroupLevel(HsgdBaseGroupLevelEnum.SIX.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelSevenGroup())) {
completion.setGroupLevel(HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel());
}
if (StringUtils.isNotBlank(record.getLevelEightGroup())) {
completion.setGroupLevel(HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel());
}
if (HsgdBaseGroupLevelEnum.ONE.getGroupLevel().equals(completion.getGroupLevel())) {
groupRecordRe = completion.getLevelOneGroup();
if (! groupOneLevel.equals(groupRecordRe)) {
groupOneSort = groupOneSort + 1;
groupOneLevel = groupRecordRe;
groupTwoSort = 0;
groupThreeSort = 0;
groupFourSort = 0;
groupFiveSort = 0;
groupSixSort = 0;
groupSevenSort = 0;
groupEightSort = 0;
completion.setGroupSort(groupOneSort);
}else{
completion.setGroupSort(groupOneSort);
}
}
else if (HsgdBaseGroupLevelEnum.TWO.getGroupLevel().equals(completion.getGroupLevel())) {
groupRecordRe = completion.getLevelTwoGroup();
if (! groupTwoLevel.equals(groupRecordRe)) {
groupTwoSort = groupTwoSort + 1;
groupTwoLevel = groupRecordRe;
groupThreeSort = 0;
groupFourSort = 0;
groupFiveSort = 0;
groupSixSort = 0;
groupSevenSort = 0;
groupEightSort = 0;
completion.setGroupSort(groupTwoSort);
}else{
completion.setGroupSort(groupTwoSort);
}
}
else if (HsgdBaseGroupLevelEnum.THREE.getGroupLevel().equals(completion.getGroupLevel())) {
groupRecordRe = completion.getLevelThreeGroup();
if (! groupThreeLevel.equals(groupRecordRe)) {
groupThreeSort = groupThreeSort + 1;
groupThreeLevel = groupRecordRe;
groupFourSort = 0;
groupFiveSort = 0;
groupSixSort = 0;
groupSevenSort = 0;
groupEightSort = 0;
completion.setGroupSort(groupThreeSort);
}else{
completion.setGroupSort(groupThreeSort);
}
}
else if (HsgdBaseGroupLevelEnum.FOUR.getGroupLevel().equals(completion.getGroupLevel())) {
groupRecordRe = completion.getLevelFourGroup();
if (! groupFourLevel.equals(groupRecordRe)) {
groupFourSort = groupFourSort + 1;
groupFourLevel = groupRecordRe;
groupFiveSort = 0;
groupSixSort = 0;
groupSevenSort = 0;
groupEightSort = 0;
completion.setGroupSort(groupFourSort);
}else{
completion.setGroupSort(groupFourSort);
}
}
else if (HsgdBaseGroupLevelEnum.FIVE.getGroupLevel().equals(completion.getGroupLevel())) {
groupRecordRe = completion.getLevelFiveGroup();
if (! groupFiveLevel.equals(groupRecordRe)) {
groupFiveSort = groupFiveSort + 1;
groupFiveLevel = groupRecordRe;
groupSixSort = 0;
groupSevenSort = 0;
groupEightSort = 0;
completion.setGroupSort(groupFiveSort);
}else{
completion.setGroupSort(groupFiveSort);
}
}
else if (HsgdBaseGroupLevelEnum.SIX.getGroupLevel().equals(completion.getGroupLevel())) {
groupRecordRe = completion.getLevelSixGroup();
if (! groupSixLevel.equals(groupRecordRe)) {
groupSixSort = groupSixSort + 1;
groupSixLevel = groupRecordRe;
groupSevenSort = 0;
groupEightSort = 0;
completion.setGroupSort(groupSixSort);
}else{
completion.setGroupSort(groupSixSort);
}
}
else if (HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel().equals(completion.getGroupLevel())) {
groupRecordRe = completion.getLevelSevenGroup();
if (! groupSevenLevel.equals(groupRecordRe)) {
groupSevenSort = groupSevenSort + 1;
groupSevenLevel = groupRecordRe;
groupEightSort = 0;
completion.setGroupSort(groupSevenSort);
}else{
completion.setGroupSort(groupSevenSort);
}
}
else if (HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel().equals(completion.getGroupLevel())) {
groupRecordRe = completion.getLevelEightGroup();
if (! groupEightLevel.equals(groupRecordRe)) {
groupEightSort = groupEightSort + 1;
groupEightLevel = groupRecordRe;
completion.setGroupSort(groupEightSort);
}else{
completion.setGroupSort(groupEightSort);
}
}
completionList.add(completion);
}
iZhgdSrBaseGroupImportHandleService.insertAllImportCompletion(completionList);
}
}
}
return importDataTotal;
}
private void saveBaseGroupDataV2(String batchNo, int totalRecord) {
if(totalRecord > 0) {
int pageSize = 120, startPage = 1;
int totalPage = totalRecord % pageSize == 0 ? (totalRecord / pageSize) : (totalRecord / pageSize + 1);
Date nowDate = new Date();
Long parentId;
String oneMapKey, twoMapKey, threeMapKey, fourMapKey, fiveMapKey, sixMapKey, sevenMapKey, eightMapKey;
Map<String, CrmRegion> regionMap = new HashMap<>();
Map<String, Long> labelMap = this.getGroupLabelMap();
Map<String, HsgdBaseGroupSimpleVO> groupOneLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupTwoLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupThreeLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupFourLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupFiveLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupSixLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupSevenLevelMap = new HashMap<>();
Map<String, HsgdBaseGroupSimpleVO> groupEightLevelMap = new HashMap<>();
for (int pageN = 0; pageN < totalPage; pageN++) {
PageHelper.startPage(startPage + pageN, pageSize, false);
List<HsgdBaseGroupImportCompletion> importCompletionList = hsgdBaseGroupImportCompletionMapper.selectListByBatchNoV2(batchNo);
if(CollectionUtils.isNotEmpty(importCompletionList)){
List<HsgdBaseGroupNotImportRecord> errorRecordList = new ArrayList<>();
HsgdBaseGroupNotImportRecord notImportRecord;
this.getPageAllRegionToRegionMap(regionMap,importCompletionList);
for (HsgdBaseGroupImportCompletion completionVO : importCompletionList) {
try {
// 一级部门
if (HsgdBaseGroupLevelEnum.ONE.getGroupLevel().equals(completionVO.getGroupLevel())) {
oneMapKey = completionVO.getLevelOneGroup();
if (groupOneLevelMap.get(oneMapKey) == null) {
this.handleOneLevelGroup(nowDate, regionMap, groupOneLevelMap, labelMap, oneMapKey, completionVO);
}
}
else if (HsgdBaseGroupLevelEnum.TWO.getGroupLevel().equals(completionVO.getGroupLevel())) {
oneMapKey = completionVO.getLevelOneGroup();
twoMapKey = completionVO.getLevelTwoGroup();
if (groupOneLevelMap.get(oneMapKey) == null) {
this.handleOneLevelGroup(nowDate, regionMap, groupOneLevelMap, labelMap, oneMapKey, completionVO);
}
if (groupTwoLevelMap.get(twoMapKey) == null) {
parentId = groupOneLevelMap.get(oneMapKey).getGroupId();
this.handleTwoLevelGroup(parentId, nowDate, regionMap, groupTwoLevelMap, labelMap, twoMapKey, completionVO);
}
}
else if (HsgdBaseGroupLevelEnum.THREE.getGroupLevel().equals(completionVO.getGroupLevel())) {
oneMapKey = completionVO.getLevelOneGroup();
twoMapKey = completionVO.getLevelTwoGroup();
threeMapKey = completionVO.getLevelThreeGroup();
if (groupOneLevelMap.get(oneMapKey) == null) {
this.handleOneLevelGroup(nowDate, regionMap, groupOneLevelMap, labelMap, oneMapKey, completionVO);
}
if(groupTwoLevelMap.get(twoMapKey) == null){
parentId = groupOneLevelMap.get(oneMapKey).getGroupId();
this.handleTwoLevelGroup(parentId, nowDate, regionMap, groupTwoLevelMap, labelMap, twoMapKey, completionVO);
}
if (groupThreeLevelMap.get(threeMapKey) == null) {
parentId = groupTwoLevelMap.get(twoMapKey).getGroupId();
this.handleThreeLevelGroup(parentId, nowDate, regionMap, groupThreeLevelMap, labelMap, threeMapKey, completionVO);
}
}
else if (HsgdBaseGroupLevelEnum.FOUR.getGroupLevel().equals(completionVO.getGroupLevel())) {
oneMapKey = completionVO.getLevelOneGroup();
twoMapKey = completionVO.getLevelTwoGroup();
threeMapKey = completionVO.getLevelThreeGroup();
fourMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup();
if (groupOneLevelMap.get(oneMapKey) == null) {
this.handleOneLevelGroup(nowDate, regionMap, groupOneLevelMap, labelMap, oneMapKey, completionVO);
}
if(groupTwoLevelMap.get(twoMapKey) == null){
parentId = groupOneLevelMap.get(oneMapKey).getGroupId();
this.handleTwoLevelGroup(parentId, nowDate, regionMap, groupTwoLevelMap, labelMap, twoMapKey, completionVO);
}
if (groupThreeLevelMap.get(threeMapKey) == null) {
parentId = groupTwoLevelMap.get(twoMapKey).getGroupId();
this.handleThreeLevelGroup(parentId, nowDate, regionMap, groupThreeLevelMap, labelMap, threeMapKey, completionVO);
}
if(groupFourLevelMap.get(fourMapKey) == null){
parentId = groupThreeLevelMap.get(threeMapKey).getGroupId();
this.handleFourLevelGroup(parentId, nowDate, regionMap, groupFourLevelMap, labelMap, fourMapKey, completionVO);
}
}
else if (HsgdBaseGroupLevelEnum.FIVE.getGroupLevel().equals(completionVO.getGroupLevel())) {
oneMapKey = completionVO.getLevelOneGroup();
twoMapKey = completionVO.getLevelTwoGroup();
threeMapKey = completionVO.getLevelThreeGroup();
fourMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup();
fiveMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup();
if (groupOneLevelMap.get(oneMapKey) == null) {
this.handleOneLevelGroup(nowDate, regionMap, groupOneLevelMap, labelMap, oneMapKey, completionVO);
}
if(groupTwoLevelMap.get(twoMapKey) == null){
parentId = groupOneLevelMap.get(oneMapKey).getGroupId();
this.handleTwoLevelGroup(parentId, nowDate, regionMap, groupTwoLevelMap, labelMap, twoMapKey, completionVO);
}
if (groupThreeLevelMap.get(threeMapKey) == null) {
parentId = groupTwoLevelMap.get(twoMapKey).getGroupId();
this.handleThreeLevelGroup(parentId, nowDate, regionMap, groupThreeLevelMap, labelMap, threeMapKey, completionVO);
}
if(groupFourLevelMap.get(fourMapKey) == null){
parentId = groupThreeLevelMap.get(threeMapKey).getGroupId();
this.handleFourLevelGroup(parentId, nowDate, regionMap, groupFourLevelMap, labelMap, fourMapKey, completionVO);
}
if(groupFiveLevelMap.get(fiveMapKey) == null){
parentId = groupFourLevelMap.get(fourMapKey).getGroupId();
this.handleFiveLevelGroup(parentId, nowDate, regionMap, groupFiveLevelMap, labelMap, fiveMapKey, completionVO);
}
}
else if (HsgdBaseGroupLevelEnum.SIX.getGroupLevel().equals(completionVO.getGroupLevel())) {
oneMapKey = completionVO.getLevelOneGroup();
twoMapKey = completionVO.getLevelTwoGroup();
threeMapKey = completionVO.getLevelThreeGroup();
fourMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup();
fiveMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup();
sixMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
+ "-" + completionVO.getLevelSixGroup();
if (groupOneLevelMap.get(oneMapKey) == null) {
this.handleOneLevelGroup(nowDate, regionMap, groupOneLevelMap, labelMap, oneMapKey, completionVO);
}
if(groupTwoLevelMap.get(twoMapKey) == null){
parentId = groupOneLevelMap.get(oneMapKey).getGroupId();
this.handleTwoLevelGroup(parentId, nowDate, regionMap, groupTwoLevelMap, labelMap, twoMapKey, completionVO);
}
if (groupThreeLevelMap.get(threeMapKey) == null) {
parentId = groupTwoLevelMap.get(twoMapKey).getGroupId();
this.handleThreeLevelGroup(parentId, nowDate, regionMap, groupThreeLevelMap, labelMap, threeMapKey, completionVO);
}
if(groupFourLevelMap.get(fourMapKey) == null){
parentId = groupThreeLevelMap.get(threeMapKey).getGroupId();
this.handleFourLevelGroup(parentId, nowDate, regionMap, groupFourLevelMap, labelMap, fourMapKey, completionVO);
}
if(groupFiveLevelMap.get(fiveMapKey) == null){
parentId = groupFourLevelMap.get(fourMapKey).getGroupId();
this.handleFiveLevelGroup(parentId, nowDate, regionMap, groupFiveLevelMap, labelMap, fiveMapKey, completionVO);
}
if(groupSixLevelMap.get(sixMapKey) == null){
parentId = groupFiveLevelMap.get(fiveMapKey).getGroupId();
this.handleSixLevelGroup(parentId, nowDate, regionMap, groupSixLevelMap, labelMap, sixMapKey, completionVO);
}
}
else if (HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel().equals(completionVO.getGroupLevel())) {
oneMapKey = completionVO.getLevelOneGroup();
twoMapKey = completionVO.getLevelTwoGroup();
threeMapKey = completionVO.getLevelThreeGroup();
fourMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup();
fiveMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup();
sixMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
+ "-" + completionVO.getLevelSixGroup();
sevenMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
+ "-" + completionVO.getLevelSixGroup() + "-" + completionVO.getLevelSevenGroup();
if (groupOneLevelMap.get(oneMapKey) == null) {
this.handleOneLevelGroup(nowDate, regionMap, groupOneLevelMap, labelMap, oneMapKey, completionVO);
}
if(groupTwoLevelMap.get(twoMapKey) == null){
parentId = groupOneLevelMap.get(oneMapKey).getGroupId();
this.handleTwoLevelGroup(parentId, nowDate, regionMap, groupTwoLevelMap, labelMap, twoMapKey, completionVO);
}
if (groupThreeLevelMap.get(threeMapKey) == null) {
parentId = groupTwoLevelMap.get(twoMapKey).getGroupId();
this.handleThreeLevelGroup(parentId, nowDate, regionMap, groupThreeLevelMap, labelMap, threeMapKey, completionVO);
}
if(groupFourLevelMap.get(fourMapKey) == null){
parentId = groupThreeLevelMap.get(threeMapKey).getGroupId();
this.handleFourLevelGroup(parentId, nowDate, regionMap, groupFourLevelMap, labelMap, fourMapKey, completionVO);
}
if(groupFiveLevelMap.get(fiveMapKey) == null){
parentId = groupFourLevelMap.get(fourMapKey).getGroupId();
this.handleFiveLevelGroup(parentId, nowDate, regionMap, groupFiveLevelMap, labelMap, fiveMapKey, completionVO);
}
if(groupSixLevelMap.get(sixMapKey) == null){
parentId = groupFiveLevelMap.get(fiveMapKey).getGroupId();
this.handleSixLevelGroup(parentId, nowDate, regionMap, groupSixLevelMap, labelMap, sixMapKey, completionVO);
}
if(groupSevenLevelMap.get(sevenMapKey) == null){
parentId = groupSixLevelMap.get(sixMapKey).getGroupId();
this.handleSevenLevelGroup(parentId, nowDate, regionMap, groupSevenLevelMap, labelMap, sevenMapKey, completionVO);
}
}
else if (HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel().equals(completionVO.getGroupLevel())) {
oneMapKey = completionVO.getLevelOneGroup();
twoMapKey = completionVO.getLevelTwoGroup();
threeMapKey = completionVO.getLevelThreeGroup();
fourMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup();
fiveMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup();
sixMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
+ "-" + completionVO.getLevelSixGroup();
sevenMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
+ "-" + completionVO.getLevelSixGroup() + "-" + completionVO.getLevelSevenGroup();
eightMapKey = completionVO.getLevelThreeGroup() + "-" + completionVO.getLevelFourGroup() + "-" + completionVO.getLevelFiveGroup()
+ "-" + completionVO.getLevelSixGroup() + "-" + completionVO.getLevelSevenGroup() + "-" + completionVO.getLevelEightGroup();
if (groupOneLevelMap.get(oneMapKey) == null) {
this.handleOneLevelGroup(nowDate, regionMap, groupOneLevelMap, labelMap, oneMapKey, completionVO);
}
if(groupTwoLevelMap.get(twoMapKey) == null){
parentId = groupOneLevelMap.get(oneMapKey).getGroupId();
this.handleTwoLevelGroup(parentId, nowDate, regionMap, groupTwoLevelMap, labelMap, twoMapKey, completionVO);
}
if (groupThreeLevelMap.get(threeMapKey) == null) {
parentId = groupTwoLevelMap.get(twoMapKey).getGroupId();
this.handleThreeLevelGroup(parentId, nowDate, regionMap, groupThreeLevelMap, labelMap, threeMapKey, completionVO);
}
if(groupFourLevelMap.get(fourMapKey) == null){
parentId = groupThreeLevelMap.get(threeMapKey).getGroupId();
this.handleFourLevelGroup(parentId, nowDate, regionMap, groupFourLevelMap, labelMap, fourMapKey, completionVO);
}
if(groupFiveLevelMap.get(fiveMapKey) == null){
parentId = groupFourLevelMap.get(fourMapKey).getGroupId();
this.handleFiveLevelGroup(parentId, nowDate, regionMap, groupFiveLevelMap, labelMap, fiveMapKey, completionVO);
}
if(groupSixLevelMap.get(sixMapKey) == null){
parentId = groupFiveLevelMap.get(fiveMapKey).getGroupId();
this.handleSixLevelGroup(parentId, nowDate, regionMap, groupSixLevelMap, labelMap, sixMapKey, completionVO);
}
if(groupSevenLevelMap.get(sevenMapKey) == null){
parentId = groupSixLevelMap.get(sixMapKey).getGroupId();
this.handleSevenLevelGroup(parentId, nowDate, regionMap, groupSevenLevelMap, labelMap, sevenMapKey, completionVO);
}
if(groupEightLevelMap.get(eightMapKey) == null){
parentId = groupSevenLevelMap.get(sevenMapKey).getGroupId();
this.handleEightLevelGroup(parentId, nowDate, regionMap, groupEightLevelMap, labelMap, eightMapKey, completionVO);
}
}
} catch (Exception e) {
log.info("组织"+JsonUtil.toJSONString(completionVO)+"导入失败",e);
log.info("组织{}导入失败", JsonUtil.toJSONString(completionVO));
notImportRecord = new HsgdBaseGroupNotImportRecord();
BeanUtils.copyProperties(completionVO,notImportRecord);
errorRecordList.add(notImportRecord);
}
}
if(CollectionUtils.isNotEmpty(errorRecordList)){
iHsgdBaseGroupNotImportRecordService.saveBatch(errorRecordList);
}
}
}
}
}
@Override
public void insert(HsgdBaseGroupImportRecord record) {
hsgdBaseGroupImportRecordMapper.insert(record);
}
@Override
@Transactional(rollbackFor = Exception.class)
public void batchInsertAll(List<HsgdBaseGroupImportRecord> recordList) {
hsgdBaseGroupImportRecordMapper.insertAll(recordList);
}
private void getPageAllRegionToRegionMap(Map<String, CrmRegion> regionMap, List<HsgdBaseGroupImportCompletion> importCompletionList) {
if (CollectionUtils.isNotEmpty(importCompletionList)) {
List<String> regionInfoList = new ArrayList<>();
for (HsgdBaseGroupImportCompletion completionData : importCompletionList) {
if(StringUtils.isNotBlank(completionData.getGroupRegion())){
List<String> regionList = Arrays.asList(completionData.getGroupRegion().split(","));
for ( String regionCode : regionList){
if(regionMap.get(regionCode) == null){
regionInfoList.add(regionCode);
}
}
}
}
if(CollectionUtils.isNotEmpty(regionInfoList)){
List<CrmRegion> regions = crmRegionMapper.selectCrmRegionsByCodes(regionInfoList);
for ( CrmRegion crmRegion : regions){
regionMap.put(crmRegion.getRegionCode(),crmRegion);
}
}
}
}
@Override
public HsgdBaseGroupSimpleVO getGroupSimpleByGroupNameAndParentIdAndLevel(String levelGroupName, Long groupId, Integer groupLevel) {
return hsgdBaseGroupMapper.getGroupSimpleByGroupNameAndParentIdAndLevel(levelGroupName,groupId, groupLevel);
}
private HsgdBaseGroupSimpleVO generatorGroupLevel(HsgdBaseGroupImportCompletion completionVO, Date nowDate,
Map<String, Long> labelMap, Map<String, CrmRegion> regionMap, Long parentId) {
HsgdBaseGroupSimpleVO resultVo = new HsgdBaseGroupSimpleVO();
Long parentIdTop = 0L;
Integer recordStatus = 1;
Integer level = completionVO.getGroupLevel();
// 表HSGD_BASE_GROUP
HsgdBaseGroup hsgdBaseGroup = new HsgdBaseGroup();
hsgdBaseGroup.setGroupName(this.getGroupNameByLevel(completionVO));
if(HsgdBaseGroupLevelEnum.ONE.getGroupLevel().equals(level)){
hsgdBaseGroup.setParentId(parentIdTop);
}else {
hsgdBaseGroup.setParentId(parentId);
}
hsgdBaseGroup.setStatus(recordStatus);
hsgdBaseGroup.setCreated(nowDate);
hsgdBaseGroup.setCreatedBy(SYSTEM_USER_NAME);
hsgdBaseGroup.setUpdated(nowDate);
hsgdBaseGroup.setUpdatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupMapper.insert(hsgdBaseGroup);
long groupId = hsgdBaseGroup.getId();
resultVo.setGroupId(groupId);
resultVo.setGroupName(hsgdBaseGroup.getGroupName());
resultVo.setParentId(hsgdBaseGroup.getParentId());
resultVo.setGroupLevel(level);
// 表HSGD_BASE_GROUP_INFO
HsgdBaseGroupInfo hsgdBaseGroupInfo = new HsgdBaseGroupInfo();
hsgdBaseGroupInfo.setGroupId(groupId);
hsgdBaseGroupInfo.setStatus(recordStatus);
hsgdBaseGroupInfo.setGroupLevel(completionVO.getGroupLevel());
hsgdBaseGroupInfo.setGroupLevelInfo(getGroupLevelInfoByLevel(completionVO));
hsgdBaseGroupInfo.setRegionFlag(0);
if(StringUtils.isNotBlank(completionVO.getGroupRegion())){
hsgdBaseGroupInfo.setRegionFlag(1);
}
hsgdBaseGroupInfo.setCustomerNumber(0);
hsgdBaseGroupInfo.setEmployeeNumber(0);
hsgdBaseGroupInfo.setCreated(nowDate);
hsgdBaseGroupInfo.setCreatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupInfo.setUpdated(nowDate);
hsgdBaseGroupInfo.setUpdatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupInfoMapper.insert(hsgdBaseGroupInfo);
// 表 HSGD_BASE_GROUP_LABEL
if(StringUtils.isNotBlank(completionVO.getGroupLabel())){
HsgdBaseGroupLabel hsgdBaseGroupLabel = new HsgdBaseGroupLabel();
hsgdBaseGroupLabel.setGroupId(groupId);
hsgdBaseGroupLabel.setLabelId(labelMap.get(completionVO.getGroupLabel()));
hsgdBaseGroupLabel.setCreated(nowDate);
hsgdBaseGroupLabel.setCreatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupLabel.setUpdated(nowDate);
hsgdBaseGroupLabel.setUpdatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupLabelMapper.insert(hsgdBaseGroupLabel);
}
if(StringUtils.isNotBlank(completionVO.getGroupRegion())){
List<String> regionCodeList = Arrays.asList(completionVO.getGroupRegion().split(","));
List<HsgdBaseGroupRegion> regionList = new ArrayList<>();
HsgdBaseGroupRegion region = null;
for (String regionCode : regionCodeList ){
region = new HsgdBaseGroupRegion();
region.setGroupId(groupId);
region.setGroupName(hsgdBaseGroup.getGroupName());
region.setStatus(recordStatus);
CrmRegion crmRegion = regionMap.get(regionCode);
if(crmRegion !=null){
region.setProvinceCode(crmRegion.getProvinceCode());
region.setCityCode(crmRegion.getCityCode());
region.setCountyCode(crmRegion.getCountyCode());
}
region.setRegionCode(regionCode);
region.setStatus(recordStatus);
region.setCreated(nowDate);
region.setCreatedBy(SYSTEM_USER_NAME);
region.setUpdated(nowDate);
region.setUpdatedBy(SYSTEM_USER_NAME);
regionList.add(region);
}
hsgdBaseGroupRegionMapper.batchInsert(regionList);
}
return resultVo;
}
@Override
public HsgdBaseGroupSimpleVO getGroupSimpleByGroupNameAndLevel(String levelGroupName, Integer groupLevel) {
return hsgdBaseGroupMapper.selectByGroupNameAndLevel(levelGroupName, groupLevel);
}
@Override
public HsgdBaseGroupSimpleVO getGroupSimpleByGroupNameAndLevelAndParentId(String levelGroupName, Integer groupLevel,Long parentId) {
return hsgdBaseGroupMapper.selectByGroupNameAndLevelAndParentId(levelGroupName, groupLevel,parentId);
}
public Map<String,Long> getGroupLabelMap(){
QueryWrapper<HsgdBaseGroupLabelDict> queryWrapper = new QueryWrapper<>();
queryWrapper.orderByAsc("ID");
List<HsgdBaseGroupLabelDict> labelList = hsgdBaseGroupLabelDictMapper.selectList(queryWrapper);
Map<String,Long> labelMap = labelList.stream().collect(Collectors.toMap(HsgdBaseGroupLabelDict::getLabelName,HsgdBaseGroupLabelDict::getId,(key1,key2)-> key2));
return labelMap;
}
private HsgdBaseGroupSimpleVO generatorGroupLevelNew(HsgdBaseGroupImportCompletion completionVO, Date nowDate,
Map<String, Long> labelMap, Map<String, CrmRegion> regionMap, Long parentId,Integer groupLevel) {
HsgdBaseGroupSimpleVO resultVo = new HsgdBaseGroupSimpleVO();
Integer recordStatus = 1;
Integer createSource = 1;
Long userId = -1L;
// 表HSGD_BASE_GROUP
HsgdBaseGroup hsgdBaseGroup = new HsgdBaseGroup();
hsgdBaseGroup.setGroupName(this.getGroupNameByLevelNew(completionVO, groupLevel));
hsgdBaseGroup.setParentId(parentId);
hsgdBaseGroup.setStatus(recordStatus);
hsgdBaseGroup.setCreated(nowDate);
hsgdBaseGroup.setCreatedBy(SYSTEM_USER_NAME);
hsgdBaseGroup.setCreatedById(userId);
hsgdBaseGroup.setCreatedSource(createSource);
hsgdBaseGroup.setUpdated(nowDate);
hsgdBaseGroup.setUpdatedBy(SYSTEM_USER_NAME);
hsgdBaseGroup.setUpdatedById(userId);
hsgdBaseGroup.setUpdatedSource(createSource);
hsgdBaseGroupMapper.insert(hsgdBaseGroup);
long groupId = hsgdBaseGroup.getId();
resultVo.setGroupId(groupId);
resultVo.setGroupName(hsgdBaseGroup.getGroupName());
resultVo.setParentId(hsgdBaseGroup.getParentId());
resultVo.setGroupLevel(groupLevel);
// 表HSGD_BASE_GROUP_INFO
HsgdBaseGroupInfo hsgdBaseGroupInfo = new HsgdBaseGroupInfo();
hsgdBaseGroupInfo.setGroupId(groupId);
hsgdBaseGroupInfo.setGroupLevelInfo(getGroupLevelInfoByLevelNew(completionVO,groupLevel));
hsgdBaseGroupInfo.setRegionFlag(0);
if(completionVO.getGroupLevel().equals(groupLevel)) {
if (StringUtils.isNotBlank(completionVO.getGroupRegion())) {
hsgdBaseGroupInfo.setRegionFlag(1);
}
}
hsgdBaseGroupInfo.setStatus(recordStatus);
hsgdBaseGroupInfo.setCustomerNumber(0);
hsgdBaseGroupInfo.setEmployeeNumber(0);
hsgdBaseGroupInfo.setCreated(nowDate);
hsgdBaseGroupInfo.setCreatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupInfo.setCreatedById(userId);
hsgdBaseGroupInfo.setUpdated(nowDate);
hsgdBaseGroupInfo.setUpdatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupInfo.setUpdatedById(userId);
hsgdBaseGroupInfo.setGroupLevel(groupLevel);
hsgdBaseGroupInfoMapper.insert(hsgdBaseGroupInfo);
if(completionVO.getGroupLevel().equals(groupLevel)){
// 表 HSGD_BASE_GROUP_LABEL
if(StringUtils.isNotBlank(completionVO.getGroupLabel())){
HsgdBaseGroupLabel hsgdBaseGroupLabel = new HsgdBaseGroupLabel();
hsgdBaseGroupLabel.setGroupId(groupId);
hsgdBaseGroupLabel.setLabelId(labelMap.get(completionVO.getGroupLabel()));
hsgdBaseGroupLabel.setCreated(nowDate);
hsgdBaseGroupLabel.setCreatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupLabel.setCreatedById(userId);
hsgdBaseGroupLabel.setUpdated(nowDate);
hsgdBaseGroupLabel.setUpdatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupLabel.setUpdatedById(userId);
hsgdBaseGroupLabelMapper.insert(hsgdBaseGroupLabel);
}
if (StringUtils.isNotBlank(completionVO.getGroupRegion())) {
List<String> regionCodeList = Arrays.asList(completionVO.getGroupRegion().split(","));
List<HsgdBaseGroupRegion> regionList = new ArrayList<>();
HsgdBaseGroupRegion region;
for (String regionCode : regionCodeList) {
region = new HsgdBaseGroupRegion();
region.setGroupName(hsgdBaseGroup.getGroupName());
region.setGroupId(groupId);
region.setRegionCode(regionCode);
CrmRegion crmRegion = regionMap.get(regionCode);
if (crmRegion != null) {
region.setProvinceCode(crmRegion.getProvinceCode());
region.setCityCode(crmRegion.getCityCode());
region.setCountyCode(crmRegion.getCountyCode());
}
region.setStatus(recordStatus);
region.setCreated(nowDate);
region.setCreatedBy(SYSTEM_USER_NAME);
region.setCreatedById(userId);
region.setUpdated(nowDate);
region.setUpdatedBy(SYSTEM_USER_NAME);
region.setUpdatedById(userId);
regionList.add(region);
}
hsgdBaseGroupRegionMapper.batchInsert(regionList);
}
}
return resultVo;
}
public String getGroupNameByLevel(HsgdBaseGroupImportCompletion completionVO) {
Integer level = completionVO.getGroupLevel();
String groupName = "";
if (HsgdBaseGroupLevelEnum.ONE.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelOneGroup();
} else if (HsgdBaseGroupLevelEnum.TWO.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelTwoGroup();
} else if (HsgdBaseGroupLevelEnum.THREE.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelThreeGroup();
} else if (HsgdBaseGroupLevelEnum.FOUR.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelFourGroup();
} else if (HsgdBaseGroupLevelEnum.FIVE.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelFiveGroup();
} else if (HsgdBaseGroupLevelEnum.SIX.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelSixGroup();
} else if (HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelSevenGroup();
} else if (HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelEightGroup();
}
return groupName;
}
public String getGroupNameByLevelNew(HsgdBaseGroupImportCompletion completionVO,Integer groupLevel) {
Integer level = groupLevel;
String groupName = "";
if (HsgdBaseGroupLevelEnum.ONE.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelOneGroup();
} else if (HsgdBaseGroupLevelEnum.TWO.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelTwoGroup();
} else if (HsgdBaseGroupLevelEnum.THREE.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelThreeGroup();
} else if (HsgdBaseGroupLevelEnum.FOUR.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelFourGroup();
} else if (HsgdBaseGroupLevelEnum.FIVE.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelFiveGroup();
} else if (HsgdBaseGroupLevelEnum.SIX.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelSixGroup();
} else if (HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelSevenGroup();
} else if (HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel().equals(level)) {
groupName = completionVO.getLevelEightGroup();
}
return groupName;
}
public String getGroupLevelInfoByLevel(HsgdBaseGroupImportCompletion completionVO) {
Integer level = completionVO.getGroupLevel();
String groupLevelInfoName = "";
if (HsgdBaseGroupLevelEnum.ONE.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup();
} else if (HsgdBaseGroupLevelEnum.TWO.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup();
} else if (HsgdBaseGroupLevelEnum.THREE.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup();
} else if (HsgdBaseGroupLevelEnum.FOUR.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup() + "->" + completionVO.getLevelFourGroup();
} else if (HsgdBaseGroupLevelEnum.FIVE.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup() + "->" + completionVO.getLevelFourGroup()
+ "->" + completionVO.getLevelFiveGroup();
} else if (HsgdBaseGroupLevelEnum.SIX.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup() + "->" + completionVO.getLevelFourGroup()
+ "->" + completionVO.getLevelFiveGroup() + "->" + completionVO.getLevelSixGroup();
} else if (HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup() + "->" + completionVO.getLevelFourGroup()
+ "->" + completionVO.getLevelFiveGroup() + "->" + completionVO.getLevelSixGroup() + "->" + completionVO.getLevelSevenGroup();
} else if (HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup() + "->" + completionVO.getLevelFourGroup()
+ "->" + completionVO.getLevelFiveGroup() + "->" + completionVO.getLevelSixGroup() + "->" + completionVO.getLevelSevenGroup() + "->" + completionVO.getLevelEightGroup();
}
return groupLevelInfoName;
}
public String getGroupLevelInfoByLevelNew(HsgdBaseGroupImportCompletion completionVO,Integer groupLevel) {
Integer level = groupLevel;
String groupLevelInfoName = "";
if (HsgdBaseGroupLevelEnum.ONE.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup();
} else if (HsgdBaseGroupLevelEnum.TWO.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup();
} else if (HsgdBaseGroupLevelEnum.THREE.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup();
} else if (HsgdBaseGroupLevelEnum.FOUR.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup() + "->" + completionVO.getLevelFourGroup();
} else if (HsgdBaseGroupLevelEnum.FIVE.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup() + "->" + completionVO.getLevelFourGroup()
+ "->" + completionVO.getLevelFiveGroup();
} else if (HsgdBaseGroupLevelEnum.SIX.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup() + "->" + completionVO.getLevelFourGroup()
+ "->" + completionVO.getLevelFiveGroup() + "->" + completionVO.getLevelSixGroup();
} else if (HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup() + "->" + completionVO.getLevelFourGroup()
+ "->" + completionVO.getLevelFiveGroup() + "->" + completionVO.getLevelSixGroup() + "->" + completionVO.getLevelSevenGroup();
} else if (HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel().equals(level)) {
groupLevelInfoName = completionVO.getLevelOneGroup() + "->" + completionVO.getLevelTwoGroup() + "->" + completionVO.getLevelThreeGroup() + "->" + completionVO.getLevelFourGroup()
+ "->" + completionVO.getLevelFiveGroup() + "->" + completionVO.getLevelSixGroup() + "->" + completionVO.getLevelSevenGroup() + "->" + completionVO.getLevelEightGroup();
}
return groupLevelInfoName;
}
/**
* 生成一级组织
*/
private void handleOneLevelGroup(Date nowDate, Map<String, CrmRegion> regionMap, Map<String, HsgdBaseGroupSimpleVO> groupOneLevelMap, Map<String, Long> labelMap,
String oneMapKey, HsgdBaseGroupImportCompletion completionVO) {
HsgdBaseGroupSimpleVO simpleOneVO = this.getGroupSimpleByGroupNameAndLevel(completionVO.getLevelOneGroup(), HsgdBaseGroupLevelEnum.ONE.getGroupLevel());
if (simpleOneVO != null) {
this.updateGroupLabelAndRegion(simpleOneVO,completionVO,labelMap,regionMap,nowDate,HsgdBaseGroupLevelEnum.ONE.getGroupLevel());
groupOneLevelMap.put(oneMapKey, simpleOneVO);
} else {
simpleOneVO = this.generatorGroupLevelNew(completionVO, nowDate, labelMap, regionMap, null, HsgdBaseGroupLevelEnum.ONE.getGroupLevel());
groupOneLevelMap.put(oneMapKey, simpleOneVO);
}
}
// 生成二级组织
private void handleTwoLevelGroup(Long parentId, Date nowDate, Map<String, CrmRegion> regionMap, Map<String, HsgdBaseGroupSimpleVO> groupTwoLevelMap, Map<String, Long> labelMap,
String twoMapKey, HsgdBaseGroupImportCompletion completionVO) {
HsgdBaseGroupSimpleVO simpleTwoVO = this.getGroupSimpleByGroupNameAndLevel(completionVO.getLevelTwoGroup(), HsgdBaseGroupLevelEnum.TWO.getGroupLevel());
if (simpleTwoVO != null) {
this.updateGroupLabelAndRegion(simpleTwoVO,completionVO,labelMap,regionMap,nowDate,HsgdBaseGroupLevelEnum.TWO.getGroupLevel());
groupTwoLevelMap.put(twoMapKey, simpleTwoVO);
} else {
simpleTwoVO = this.generatorGroupLevelNew(completionVO, nowDate, labelMap, regionMap, parentId, HsgdBaseGroupLevelEnum.TWO.getGroupLevel());
groupTwoLevelMap.put(twoMapKey, simpleTwoVO);
}
}
// 生成三级组织
private void handleThreeLevelGroup(Long parentId, Date nowDate, Map<String, CrmRegion> regionMap, Map<String, HsgdBaseGroupSimpleVO> groupThreeLevelMap, Map<String, Long> labelMap,
String threeMapKey, HsgdBaseGroupImportCompletion completionVO) {
HsgdBaseGroupSimpleVO simpleThreeVO = this.getGroupSimpleByGroupNameAndLevel(completionVO.getLevelThreeGroup(), HsgdBaseGroupLevelEnum.THREE.getGroupLevel());
if (simpleThreeVO != null) {
this.updateGroupLabelAndRegion(simpleThreeVO,completionVO,labelMap,regionMap,nowDate,HsgdBaseGroupLevelEnum.THREE.getGroupLevel());
groupThreeLevelMap.put(threeMapKey, simpleThreeVO);
} else {
simpleThreeVO = this.generatorGroupLevelNew(completionVO, nowDate, labelMap, regionMap, parentId, HsgdBaseGroupLevelEnum.THREE.getGroupLevel());
groupThreeLevelMap.put(threeMapKey, simpleThreeVO);
}
}
// 生成四级组织
private void handleFourLevelGroup(Long parentId, Date nowDate, Map<String, CrmRegion> regionMap, Map<String, HsgdBaseGroupSimpleVO> groupFourLevelMap, Map<String, Long> labelMap,
String fourMapKey, HsgdBaseGroupImportCompletion completionVO) {
HsgdBaseGroupSimpleVO simpleFourVO = this.getGroupSimpleByGroupNameAndLevelAndParentId(completionVO.getLevelFourGroup(), HsgdBaseGroupLevelEnum.FOUR.getGroupLevel(),parentId);
if (simpleFourVO != null) {
this.updateGroupLabelAndRegion(simpleFourVO,completionVO,labelMap,regionMap,nowDate,HsgdBaseGroupLevelEnum.FOUR.getGroupLevel());
groupFourLevelMap.put(fourMapKey, simpleFourVO);
} else {
simpleFourVO = this.generatorGroupLevelNew(completionVO, nowDate, labelMap, regionMap, parentId, HsgdBaseGroupLevelEnum.FOUR.getGroupLevel());
groupFourLevelMap.put(fourMapKey, simpleFourVO);
}
}
// 生成五级组织
private void handleFiveLevelGroup(Long parentId, Date nowDate, Map<String, CrmRegion> regionMap, Map<String, HsgdBaseGroupSimpleVO> groupFiveLevelMap, Map<String, Long> labelMap,
String fiveMapKey, HsgdBaseGroupImportCompletion completionVO) {
HsgdBaseGroupSimpleVO simpleFiveVO = this.getGroupSimpleByGroupNameAndLevelAndParentId(completionVO.getLevelFiveGroup(), HsgdBaseGroupLevelEnum.FIVE.getGroupLevel(),parentId);
if (simpleFiveVO != null) {
this.updateGroupLabelAndRegion(simpleFiveVO,completionVO,labelMap,regionMap,nowDate,HsgdBaseGroupLevelEnum.FIVE.getGroupLevel());
groupFiveLevelMap.put(fiveMapKey, simpleFiveVO);
} else {
simpleFiveVO = this.generatorGroupLevelNew(completionVO, nowDate, labelMap, regionMap, parentId, HsgdBaseGroupLevelEnum.FIVE.getGroupLevel());
groupFiveLevelMap.put(fiveMapKey, simpleFiveVO);
}
}
// 生成六级组织
private void handleSixLevelGroup(Long parentId, Date nowDate, Map<String, CrmRegion> regionMap, Map<String, HsgdBaseGroupSimpleVO> groupSixLevelMap, Map<String, Long> labelMap,
String sixMapKey, HsgdBaseGroupImportCompletion completionVO) {
HsgdBaseGroupSimpleVO simpleSixVO = this.getGroupSimpleByGroupNameAndLevelAndParentId(completionVO.getLevelSixGroup(), HsgdBaseGroupLevelEnum.SIX.getGroupLevel(), parentId);
if (simpleSixVO != null) {
this.updateGroupLabelAndRegion(simpleSixVO,completionVO,labelMap,regionMap,nowDate,HsgdBaseGroupLevelEnum.SIX.getGroupLevel());
groupSixLevelMap.put(sixMapKey, simpleSixVO);
} else {
simpleSixVO = this.generatorGroupLevelNew(completionVO, nowDate, labelMap, regionMap, parentId, HsgdBaseGroupLevelEnum.SIX.getGroupLevel());
groupSixLevelMap.put(sixMapKey, simpleSixVO);
}
}
// 生成七级组织
private void handleSevenLevelGroup(Long parentId, Date nowDate, Map<String, CrmRegion> regionMap, Map<String, HsgdBaseGroupSimpleVO> groupSevenLevelMap, Map<String, Long> labelMap,
String sevenMapKey, HsgdBaseGroupImportCompletion completionVO) {
HsgdBaseGroupSimpleVO simpleSevenVO = this.getGroupSimpleByGroupNameAndLevelAndParentId(completionVO.getLevelSevenGroup(), HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel(), parentId);
if (simpleSevenVO != null) {
this.updateGroupLabelAndRegion(simpleSevenVO,completionVO,labelMap,regionMap,nowDate,HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel());
groupSevenLevelMap.put(sevenMapKey, simpleSevenVO);
} else {
simpleSevenVO = this.generatorGroupLevelNew(completionVO, nowDate, labelMap, regionMap, parentId, HsgdBaseGroupLevelEnum.SEVEN.getGroupLevel());
groupSevenLevelMap.put(sevenMapKey, simpleSevenVO);
}
}
// 生成八级组织
private void handleEightLevelGroup(Long parentId, Date nowDate, Map<String, CrmRegion> regionMap, Map<String, HsgdBaseGroupSimpleVO> groupEightLevelMap, Map<String, Long> labelMap,
String eightMapKey, HsgdBaseGroupImportCompletion completionVO) {
HsgdBaseGroupSimpleVO simpleEightVO = this.getGroupSimpleByGroupNameAndLevelAndParentId(completionVO.getLevelEightGroup(), HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel(), parentId);
if (simpleEightVO != null) {
this.updateGroupLabelAndRegion(simpleEightVO,completionVO,labelMap,regionMap,nowDate,HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel());
groupEightLevelMap.put(eightMapKey, simpleEightVO);
} else {
simpleEightVO = this.generatorGroupLevelNew(completionVO, nowDate, labelMap, regionMap, parentId, HsgdBaseGroupLevelEnum.EIGHT.getGroupLevel());
groupEightLevelMap.put(eightMapKey, simpleEightVO);
}
}
private void updateGroupLabelAndRegion(HsgdBaseGroupSimpleVO simpleOneVO, HsgdBaseGroupImportCompletion completionVO,
Map<String, Long> labelMap, Map<String, CrmRegion> regionMap,Date nowDate,Integer groupLvel) {
// 表 HSGD_BASE_GROUP_LABEL
Long userId = -1L;
Integer recordStatus = 1;
Long groupId = simpleOneVO.getGroupId();
if(completionVO.getGroupLevel().equals(groupLvel)){
if(StringUtils.isNotBlank(completionVO.getGroupLabel())){
QueryWrapper<HsgdBaseGroupLabel> queryWrapper = new QueryWrapper();
queryWrapper.eq("GROUP_ID",groupId);
Long labelCount = hsgdBaseGroupLabelMapper.selectCount(queryWrapper);
if (labelCount > 0) {
UpdateWrapper<HsgdBaseGroupLabel> updateWrapper = new UpdateWrapper();
updateWrapper.eq("GROUP_ID",groupId);
HsgdBaseGroupLabel updateLabel = new HsgdBaseGroupLabel();
updateLabel.setLabelId(labelMap.get(completionVO.getGroupLabel()));
updateLabel.setUpdated(nowDate);
updateLabel.setUpdatedBy(SYSTEM_USER_NAME);
updateLabel.setUpdatedById(userId);
hsgdBaseGroupLabelMapper.update(updateLabel,updateWrapper);
} else {
HsgdBaseGroupLabel hsgdBaseGroupLabel = new HsgdBaseGroupLabel();
hsgdBaseGroupLabel.setGroupId(groupId);
hsgdBaseGroupLabel.setLabelId(labelMap.get(completionVO.getGroupLabel()));
hsgdBaseGroupLabel.setCreated(nowDate);
hsgdBaseGroupLabel.setCreatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupLabel.setCreatedById(userId);
hsgdBaseGroupLabel.setUpdated(nowDate);
hsgdBaseGroupLabel.setUpdatedBy(SYSTEM_USER_NAME);
hsgdBaseGroupLabel.setUpdatedById(userId);
hsgdBaseGroupLabelMapper.insert(hsgdBaseGroupLabel);
}
}
if (StringUtils.isNotBlank(completionVO.getGroupRegion())) {
List<String> regionCodeList = Arrays.asList(completionVO.getGroupRegion().split(","));
List<HsgdBaseGroupRegion> regionList = new ArrayList<>();
HsgdBaseGroupRegion region;
for (String regionCode : regionCodeList) {
region = new HsgdBaseGroupRegion();
region.setGroupName(simpleOneVO.getGroupName());
region.setGroupId(groupId);
region.setRegionCode(regionCode);
CrmRegion crmRegion = regionMap.get(regionCode);
if (crmRegion != null) {
region.setProvinceCode(crmRegion.getProvinceCode());
region.setCityCode(crmRegion.getCityCode());
region.setCountyCode(crmRegion.getCountyCode());
}
region.setStatus(recordStatus);
region.setCreated(nowDate);
region.setCreatedBy(SYSTEM_USER_NAME);
region.setCreatedById(userId);
region.setUpdated(nowDate);
region.setUpdatedBy(SYSTEM_USER_NAME);
region.setUpdatedById(userId);
regionList.add(region);
}
QueryWrapper<HsgdBaseGroupRegion> queryWrapper = new QueryWrapper();
queryWrapper.eq("GROUP_ID",groupId);
queryWrapper.eq("STATUS",1);
Long existsRegionNum = hsgdBaseGroupRegionMapper.selectCount(queryWrapper);
if(existsRegionNum > 0){
UpdateWrapper<HsgdBaseGroupRegion> updateWrapper = new UpdateWrapper();
updateWrapper.eq("GROUP_ID",groupId);
HsgdBaseGroupRegion updateRegion = new HsgdBaseGroupRegion();
updateRegion.setStatus(0);
updateRegion.setUpdated(nowDate);
updateRegion.setUpdatedBy(SYSTEM_USER_NAME);
updateRegion.setUpdatedById(userId);
hsgdBaseGroupRegionMapper.update(updateRegion,updateWrapper);
}
hsgdBaseGroupRegionMapper.batchInsert(regionList);
}
}
}
}
package com.zhgd.base.listener;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import com.zhgd.base.domain.model.ZhgdSrGroupImportModel;
import com.zhgd.base.service.IZhgdSrBaseGroupImportHandleService;
import com.zhgd.common.util.JsonUtil;
import lombok.extern.slf4j.Slf4j;
import java.util.ArrayList;
import java.util.List;
@Slf4j
public class ZhgdSrBaseGroupImportExcelListener extends AnalysisEventListener<ZhgdSrGroupImportModel> {
private List<ZhgdSrGroupImportModel> dataList = new ArrayList<>();
private static final int BATCH_COUNT = 120;
private IZhgdSrBaseGroupImportHandleService iZhgdSrBaseGroupImportHandleService;
private String batchNo;
public ZhgdSrBaseGroupImportExcelListener(IZhgdSrBaseGroupImportHandleService iZhgdSrBaseGroupImportHandleService,String batchNo) {
this.iZhgdSrBaseGroupImportHandleService = iZhgdSrBaseGroupImportHandleService;
this.batchNo = batchNo;
}
@Override
public void invoke(ZhgdSrGroupImportModel model, AnalysisContext analysisContext) {
log.debug("读取数据:{}", JsonUtil.toJSONString(model));
model.setBatchNo(batchNo);
dataList.add(model);
if(dataList.size() >= BATCH_COUNT){
iZhgdSrBaseGroupImportHandleService.saveSrBaseGroupImportDataList(dataList);
dataList.clear();
}
}
@Override
public void doAfterAllAnalysed(AnalysisContext analysisContext) {
iZhgdSrBaseGroupImportHandleService.saveSrBaseGroupImportDataList(dataList);
dataList.clear();
}
}
package com.zhgd.base.service;
import com.zhgd.base.domain.model.ZhgdSrGroupImportModel;
import com.zhgd.base.entity.HsgdBaseGroupImportCompletion;
import java.util.List;
public interface IZhgdSrBaseGroupImportHandleService {
void saveSrBaseGroupImportDataList(List<ZhgdSrGroupImportModel> dataList);
void saveSrBaseGroupImportData(ZhgdSrGroupImportModel dataList);
void insertAllImportCompletion(List<HsgdBaseGroupImportCompletion> completionList);
}
package com.zhgd.base.service.impl;
import com.zhgd.base.domain.model.ZhgdSrGroupImportModel;
import com.zhgd.base.entity.HsgdBaseGroupImportCompletion;
import com.zhgd.base.entity.HsgdBaseGroupImportRecord;
import com.zhgd.base.mapper.HsgdBaseGroupImportCompletionMapper;
import com.zhgd.base.service.IZhgdSrBaseGroupImportHandleService;
import com.zhgd.base.service.IZhgdSrBaseGroupImportService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.collections.CollectionUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@Service
@Slf4j
public class ZhgdSrBaseGroupImportHandleServiceImpl implements IZhgdSrBaseGroupImportHandleService {
@Resource
private IZhgdSrBaseGroupImportService iZhgdSrBaseGroupImportService;
@Resource
private HsgdBaseGroupImportCompletionMapper hsgdBaseGroupImportCompletionMapper;
@Override
public void saveSrBaseGroupImportDataList(List<ZhgdSrGroupImportModel> dataList) {
Date nowDate = new Date();
final String userName = "system";
if(CollectionUtils.isNotEmpty(dataList)){
List<HsgdBaseGroupImportRecord> recordList = new ArrayList();
HsgdBaseGroupImportRecord record = null;
for (int i=0,len = dataList.size();i< len;i++){
ZhgdSrGroupImportModel importModel = dataList.get(i);
record = new HsgdBaseGroupImportRecord();
BeanUtils.copyProperties(importModel,record);
record.setCreated(nowDate);
record.setCreatedBy(userName);
record.setUpdated(nowDate);
record.setUpdatedBy(userName);
recordList.add(record);
};
iZhgdSrBaseGroupImportService.batchInsertAll(recordList);
}
}
@Override
public void saveSrBaseGroupImportData(ZhgdSrGroupImportModel data) {
Date nowDate = new Date();
final String userName = "system";
if(data != null){
HsgdBaseGroupImportRecord record = new HsgdBaseGroupImportRecord();
BeanUtils.copyProperties(data,record);
record.setCreated(nowDate);
record.setCreatedBy(userName);
record.setUpdated(nowDate);
record.setUpdatedBy(userName);
iZhgdSrBaseGroupImportService.insert(record);
}
}
@Transactional
@Override
public void insertAllImportCompletion(List<HsgdBaseGroupImportCompletion> completionList) {
hsgdBaseGroupImportCompletionMapper.insertAll(completionList);
}
}
导入之后
HSGD_BASE_GROUP_IMPORT_RECORD
HSGD_BASE_GROUP_IMPORT_COMPLETION
这篇关于[Java] easyExcel导入组织结构精选的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！
- 2024-06-26结对编程到底难不难？答案在这里
- 2024-06-19《2023版Java工程师》课程升级公告
- 2024-06-15matplotlib作图不显示3D图，怎么办？
- 2024-06-1503-Loki 日志监控
- 2024-06-1504-让LLM理解知识 -Prompt
- 2024-06-05做软件测试需要懂代码吗？
- 2024-06-0514-ShardingSphere的分布式主键实现
- 2024-06-03为什么以及如何要进行架构设计权衡？
- 2024-05-31全网首发第二弹！软考2024年5月《软件设计师》真题+解析+答案！（11-20题）
- 2024-05-31全网首发！软考2024年5月《软件设计师》真题+解析+答案！（21-30题）
