package com.iailab.module.data.point.service.impl; import cn.hutool.core.collection.CollUtil; import com.alibaba.fastjson.JSONArray; import com.baomidou.dynamic.datasource.annotation.DSTransactional; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.iailab.framework.common.pojo.PageResult; import com.iailab.framework.common.util.object.BeanUtils; import com.iailab.framework.common.util.object.ConvertUtils; import com.iailab.module.data.channel.common.service.ChannelSourceService; import com.iailab.module.data.common.enums.CommonConstant; import com.iailab.module.data.common.enums.IsEnableEnum; import com.iailab.module.data.common.enums.IncreaseCodeEnum; import com.iailab.module.data.point.common.PointTypeEnum; import com.iailab.module.data.point.dao.DaPointDao; import com.iailab.module.data.point.dto.DaCumulatePointDTO; import com.iailab.module.data.point.dto.DaMathPointDTO; import com.iailab.module.data.point.dto.DaMeasurePointDTO; import com.iailab.module.data.point.dto.DaPointDTO; import com.iailab.module.data.point.entity.DaMeasurePointEntity; import com.iailab.module.data.point.entity.DaPointEntity; import com.iailab.module.data.point.service.*; import com.iailab.module.data.point.vo.DaPointPageReqVO; import com.iailab.module.data.point.vo.PointImportExcelVO; import com.iailab.module.data.point.vo.PointImportRespVO; import org.apache.commons.lang3.ObjectUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import javax.annotation.Resource; import java.util.*; import java.util.concurrent.ConcurrentHashMap; import static com.iailab.framework.common.exception.util.ServiceExceptionUtil.exception; import static com.iailab.module.data.enums.ErrorCodeConstants.POINT_EXISTS; import static com.iailab.module.data.enums.ErrorCodeConstants.POINT_IMPORT_LIST_IS_EMPTY; /** * @author lirm * @Description * @createTime 2024年09月2日 */ @Service public class DaPointServiceImpl extends ServiceImpl implements DaPointService { @Autowired private DaMeasurePointService daMeasurePointService; @Autowired private DaMathPointService daMathPointService; @Autowired private DaCumulatePointService daCumulatePointService; @Autowired private DaSequenceNumService daSequenceNumService; @Resource private DaPointDao daPointDao; @Resource private ChannelSourceService channelSourceService; private static Map pointIdMap = new ConcurrentHashMap<>(); private static Map pointNoMap = new ConcurrentHashMap<>(); @Override public PageResult queryPage(DaPointPageReqVO reqVO) { IPage page = daPointDao.selectPageList(reqVO); return new PageResult<>(page.getRecords(), page.getTotal()); } private void clearCache() { pointIdMap.clear(); pointNoMap.clear(); } @Override public DaPointDTO info(String id) { DaPointEntity entity = daPointDao.selectById(id); DaPointDTO result = ConvertUtils.sourceToTarget(entity, DaPointDTO.class); result.setMeasurePoint(new DaMeasurePointDTO()); result.setMathPoint(new DaMathPointDTO()); result.setCumulatePoint(new DaCumulatePointDTO()); switch (PointTypeEnum.getEumByCode(result.getPointType())) { case MEASURE_POINT: DaMeasurePointDTO measurePoint = daMeasurePointService.getByPoint(id); result.setMeasurePoint(measurePoint); List sourceOption = new ArrayList<>(); sourceOption.add(measurePoint.getSourceType()); sourceOption.add(measurePoint.getSourceId()); sourceOption.add(measurePoint.getTagNo()); result.setSourceOption(sourceOption); break; case CALCULATE_POINT: result.setMathPoint(daMathPointService.getByPoint(id)); break; case CUMULATE: result.setCumulatePoint(daCumulatePointService.getByPoint(id)); break; default: break; } return result; } @Override public DaPointDTO getSimpleInfoById(String id) { if (pointIdMap.containsKey(id)) { return pointIdMap.get(id); } DaPointDTO dto = ConvertUtils.sourceToTarget(daPointDao.selectById(id), DaPointDTO.class); if (dto == null) { return null; } pointIdMap.put(id, dto); return pointIdMap.get(id); } @Override public DaPointDTO getSimpleInfoByNo(String no) { QueryWrapper queryWrapper = new QueryWrapper(); queryWrapper.eq("pointNo", no); return ConvertUtils.sourceToTarget(daPointDao.selectOne(queryWrapper), DaPointDTO.class); } @Override public List list(Map params) { Object pointType = params.get("pointType"); List pointNos = new ArrayList<>(); if (params.get("pointNos") != null) { pointNos = JSONArray.parseArray(JSONArray.toJSONString(params.get("pointNos")), String.class); } List pointTypes = new ArrayList<>(); if (params.get("pointTypes") != null) { pointTypes = Arrays.asList(params.get("pointTypes").toString().split(",")); } Object pointNoLike = params.get("pointNoLike"); QueryWrapper queryWrapper = new QueryWrapper(); queryWrapper.eq(!ObjectUtils.isEmpty(pointType), "point_type", pointType); queryWrapper.in(pointNos.size() != 0,"point_no", pointNos); queryWrapper.like(!ObjectUtils.isEmpty(pointNoLike), "point_no", pointNoLike); queryWrapper.in(pointTypes.size() != 0,"point_type", pointTypes); List list = daPointDao.selectList(queryWrapper); return ConvertUtils.sourceToTarget(list, DaPointDTO.class); } @Override @DSTransactional(rollbackFor = Exception.class) public void add(DaPointDTO dataPoint) { DaPointEntity daPointEntity = ConvertUtils.sourceToTarget(dataPoint, DaPointEntity.class); daPointEntity.setId(UUID.randomUUID().toString()); switch (PointTypeEnum.getEumByCode(dataPoint.getPointType())) { case MEASURE_POINT: DaMeasurePointDTO measurePoint = new DaMeasurePointDTO(); measurePoint.setSourceType(dataPoint.getSourceOption().get(0)); measurePoint.setSourceId(dataPoint.getSourceOption().get(1)); measurePoint.setTagNo(dataPoint.getSourceOption().get(2)); daMeasurePointService.add(measurePoint, daPointEntity.getId()); daPointEntity.setPointNo(daSequenceNumService.getAndIncreaseByCode(IncreaseCodeEnum.POINT_M.name())); break; case CALCULATE_POINT: daMathPointService.add(dataPoint.getMathPoint(), daPointEntity.getId()); daPointEntity.setPointNo(daSequenceNumService.getAndIncreaseByCode(IncreaseCodeEnum.POINT_C.name())); break; case CONSTANT: daPointEntity.setPointNo(daSequenceNumService.getAndIncreaseByCode(IncreaseCodeEnum.POINT_F.name())); break; case CUMULATE: daCumulatePointService.add(dataPoint.getCumulatePoint(), daPointEntity.getId()); daPointEntity.setPointNo(daSequenceNumService.getAndIncreaseByCode(IncreaseCodeEnum.POINT_L.name())); break; default: break; } daPointEntity.setIsEnable(CommonConstant.IS_ENABLE); daPointEntity.setCreateTime(new Date()); daPointDao.insert(daPointEntity); // 清空缓存 clearCache(); } @Override @DSTransactional(rollbackFor = Exception.class) public void update(DaPointDTO dataPoint) { DaPointEntity daPointEntity = ConvertUtils.sourceToTarget(dataPoint, DaPointEntity.class); daPointEntity.setUpdateTime(new Date()); daPointDao.updateById(daPointEntity); switch (PointTypeEnum.getEumByCode(dataPoint.getPointType())) { case MEASURE_POINT: DaMeasurePointDTO measurePoint = dataPoint.getMeasurePoint(); measurePoint.setSourceType(dataPoint.getSourceOption().get(0)); measurePoint.setSourceId(dataPoint.getSourceOption().get(1)); measurePoint.setTagNo(dataPoint.getSourceOption().get(2)); daMeasurePointService.update(measurePoint); break; case CALCULATE_POINT: daMathPointService.update(dataPoint.getMathPoint()); break; case CUMULATE: daCumulatePointService.update(dataPoint.getCumulatePoint()); break; default: break; } // 清空缓存 clearCache(); } @Override @DSTransactional(rollbackFor = Exception.class) public void delete(String[] ids) { daPointDao.deleteBatchIds(Arrays.asList(ids)); daMeasurePointService.deleteByPoint(ids); daMathPointService.deleteByPoint(ids); daCumulatePointService.deleteByPoint(ids); // 清空缓存 clearCache(); } @Override public List getConstantPoint(DaPointPageReqVO reqVO) { Map params = new HashMap<>(); params.put("pointType", PointTypeEnum.CONSTANT.getCode()); params.put("pointNo", reqVO.getPointNo()); params.put("pointName", reqVO.getPointName()); return daPointDao.getConstantPoint(params); } @Override public List getConstantPoint(String freq) { Map params = new HashMap<>(); params.put("pointType", PointTypeEnum.CONSTANT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("minfreqid", freq); return daPointDao.getConstantPoint(params); } @Override public List getConstantPoint(List pointNos) { Map params = new HashMap<>(); params.put("pointType", PointTypeEnum.CONSTANT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("pointNos", pointNos); return daPointDao.getConstantPoint(params); } @Override public List getMeasurePoint(DaPointPageReqVO reqVO) { Map params = new HashMap<>(); params.put("pointType", PointTypeEnum.MEASURE_POINT.getCode()); params.put("pointNo", reqVO.getPointNo()); params.put("pointName", reqVO.getPointName()); params.put("sourceName", reqVO.getSourceName()); return daPointDao.getMeasurePoint(params); } @Override public List getMeasurePoint(String freq) { Map params = new HashMap<>(); params.put("pointType", PointTypeEnum.MEASURE_POINT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("minfreqid", freq); return daPointDao.getMeasurePoint(params); } @Override public List getMeasurePoint(List pointNos) { Map params = new HashMap<>(); params.put("pointType", PointTypeEnum.MEASURE_POINT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("pointNos", pointNos); return daPointDao.getMeasurePoint(params); } @Override public DaPointDTO getMeasurePointByNo(String pointNo) { Map params = new HashMap<>(); params.put("pointType", PointTypeEnum.MEASURE_POINT.getCode()); params.put("pointNo", pointNo); List list = daPointDao.getMeasurePoint(params); if (CollectionUtils.isEmpty(list)) { return null; } return list.get(0); } @Override public List getMathPoint(DaPointPageReqVO reqVO) { Map params = new HashMap<>(); params.put("pointType", PointTypeEnum.CALCULATE_POINT.getCode()); params.put("pointNo", reqVO.getPointNo()); params.put("pointName", reqVO.getPointName()); return daPointDao.getMathPoint(params); } @Override public List getMathPoint(String freq) { Map params = new HashMap<>(); params.put("pointType", PointTypeEnum.CALCULATE_POINT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("minfreqid", freq); return daPointDao.getMathPoint(params); } @Override public List getMathPoint(List pointNos) { Map params = new HashMap<>(); params.put("pointType", PointTypeEnum.CALCULATE_POINT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("pointNos", pointNos); return daPointDao.getMathPoint(params); } @Override public List getCumulatePoint(String freq) { Map params = new HashMap<>(3); params.put("pointType", PointTypeEnum.CUMULATE.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("minfreqid", freq); return daPointDao.getCumulatePoint(params); } @Override public List getCumulatePoint(DaPointPageReqVO reqVO) { Map params = new HashMap<>(3); params.put("pointType", PointTypeEnum.CUMULATE.getCode()); params.put("pointNo", reqVO.getPointNo()); params.put("pointName", reqVO.getPointName()); return daPointDao.getCumulatePoint(params); } @Override public DaPointDTO getByNo(String pointNo) { if (pointNoMap.containsKey(pointNo)) { return pointNoMap.get(pointNo); } QueryWrapper wrapper = new QueryWrapper<>(); wrapper.eq("point_no", pointNo); DaPointEntity entity = daPointDao.selectOne(wrapper); DaPointDTO dto = ConvertUtils.sourceToTarget(entity, DaPointDTO.class); pointNoMap.put(pointNo, dto); return dto; } @Override public List getByNos(List pointNos) { QueryWrapper wrapper = new QueryWrapper<>(); wrapper.in("point_no", pointNos); List list = daPointDao.selectList(wrapper); return ConvertUtils.sourceToTarget(list, DaPointDTO.class); } @Override public void updateDefaultValue(DaPointDTO dto) { QueryWrapper wrapper = new QueryWrapper<>(); wrapper.eq("point_no", dto.getPointNo()); DaPointEntity entity = new DaPointEntity(); entity.setDefaultValue(dto.getDefaultValue()); daPointDao.update(entity, wrapper); } @Override @DSTransactional(rollbackFor = Exception.class) // 添加事务,异常则回滚所有导入 public PointImportRespVO importPointList(List importPoints, boolean isUpdateSupport) { // 1.1 参数校验 if (CollUtil.isEmpty(importPoints)) { throw exception(POINT_IMPORT_LIST_IS_EMPTY); } Map> sourcesIdMap = channelSourceService.getSourcesId(); // 2. 遍历,逐个创建 or 更新 PointImportRespVO respVO = PointImportRespVO.builder().createPointnames(new ArrayList<>()) .updatePointnames(new ArrayList<>()).failurePointnames(new LinkedHashMap<>()).build(); importPoints.forEach(importPoint -> { // 判断如果不存在,再进行插入 DaPointEntity existPoint = baseMapper.selectByPointName(importPoint.getPointName()); if (existPoint == null) { DaPointEntity daPointEntity = ConvertUtils.sourceToTarget(importPoint, DaPointEntity.class); daPointEntity.setId(UUID.randomUUID().toString()); daPointEntity.setIsEnable(CommonConstant.IS_ENABLE); daPointEntity.setCreateTime(new Date()); switch (PointTypeEnum.getEumByCode(daPointEntity.getPointType())) { case MEASURE_POINT: DaMeasurePointDTO measurePoint = new DaMeasurePointDTO(); measurePoint.setSourceType(importPoint.getSourceType()); measurePoint.setSourceId(sourcesIdMap.get(importPoint.getSourceType()).get(importPoint.getSourceName())); measurePoint.setTagNo(importPoint.getTagNo()); measurePoint.setValueType(importPoint.getValueType()); measurePoint.setDimension(importPoint.getDimension()); daMeasurePointService.add(measurePoint, daPointEntity.getId()); daPointEntity.setPointNo(daSequenceNumService.getAndIncreaseByCode(IncreaseCodeEnum.POINT_M.name())); break; case CALCULATE_POINT: daMathPointService.add(importPoint.getExpression(), daPointEntity.getId()); daPointEntity.setPointNo(daSequenceNumService.getAndIncreaseByCode(IncreaseCodeEnum.POINT_C.name())); break; case CONSTANT: daPointEntity.setPointNo(daSequenceNumService.getAndIncreaseByCode(IncreaseCodeEnum.POINT_F.name())); break; case CUMULATE: DaCumulatePointDTO cumulatePoint = new DaCumulatePointDTO(); cumulatePoint.setMomentPoint(importPoint.getMomentPoint()); cumulatePoint.setLength(importPoint.getLength()); cumulatePoint.setDivisor(importPoint.getDivisor()); daCumulatePointService.add(cumulatePoint, daPointEntity.getId()); daPointEntity.setPointNo(daSequenceNumService.getAndIncreaseByCode(IncreaseCodeEnum.POINT_L.name())); default: break; } daPointDao.insert(daPointEntity); respVO.getCreatePointnames().add(importPoint.getPointName()); return; } // 如果存在,判断是否允许更新 if (!isUpdateSupport) { respVO.getFailurePointnames().put(importPoint.getPointName(), POINT_EXISTS.getMsg()); return; } DaPointEntity updatePoint = BeanUtils.toBean(importPoint, DaPointEntity.class); updatePoint.setId(existPoint.getId()); baseMapper.updateById(updatePoint); DaMeasurePointEntity measurePoint = new DaMeasurePointEntity(); measurePoint.setSourceType(importPoint.getSourceType()); measurePoint.setSourceId(sourcesIdMap.get(importPoint.getSourceType()).get(importPoint.getSourceName())); measurePoint.setTagNo(importPoint.getTagNo()); daMeasurePointService.update(measurePoint, new QueryWrapper().eq("point_id",updatePoint.getId())); respVO.getUpdatePointnames().add(importPoint.getPointName()); }); return respVO; } @Override public List getList(DaPointPageReqVO exportReqVO) { return daPointDao.getList(exportReqVO); } @Override @DSTransactional(rollbackFor = Exception.class) public void enableByIds(String[] ids) { if (CollectionUtils.isEmpty(Arrays.asList(ids))) { return; } Arrays.asList(ids).forEach(item -> { DaPointEntity entity = new DaPointEntity(); entity.setId(item); entity.setIsEnable(IsEnableEnum.ENABLE.getCode()); entity.setUpdateTime(new Date()); daPointDao.updateById(entity); }); } @Override @DSTransactional(rollbackFor = Exception.class) public void disableByIds(String[] ids) { if (CollectionUtils.isEmpty(Arrays.asList(ids))) { return; } Arrays.asList(ids).forEach(item -> { DaPointEntity entity = new DaPointEntity(); entity.setId(item); entity.setIsEnable(IsEnableEnum.DISABLE.getCode()); entity.setUpdateTime(new Date()); daPointDao.updateById(entity); }); } }