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.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.DaMathPointService;
|
import com.iailab.module.data.point.service.DaMeasurePointService;
|
import com.iailab.module.data.point.service.DaPointService;
|
import com.iailab.module.data.point.service.DaSequenceNumService;
|
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.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<DaPointDao, DaPointEntity> implements DaPointService {
|
|
@Resource
|
private DaMeasurePointService daMeasurePointService;
|
|
@Resource
|
private DaMathPointService daMathPointService;
|
|
@Resource
|
private DaSequenceNumService daSequenceNumService;
|
|
@Resource
|
private DaPointDao daPointDao;
|
|
@Resource
|
private ChannelSourceService channelSourceService;
|
|
private static Map<String, DaPointDTO> pointNoMap = new ConcurrentHashMap<>();
|
|
@Override
|
public PageResult<DaPointDTO> queryPage(DaPointPageReqVO reqVO) {
|
IPage<DaPointDTO> page = daPointDao.selectPageList(reqVO);
|
return new PageResult<DaPointDTO>(page.getRecords(), page.getTotal());
|
}
|
|
@Override
|
public DaPointDTO info(String id) {
|
DaPointEntity entity = daPointDao.selectById(id);
|
DaPointDTO result = ConvertUtils.sourceToTarget(entity, DaPointDTO.class);
|
if (PointTypeEnum.MEASURE_POINT.getCode().equals(result.getPointType())) {
|
DaMeasurePointDTO measurePoint = daMeasurePointService.getByPoint(id);
|
result.setMeasurePoint(measurePoint);
|
List<String> sourceOption = new ArrayList<>();
|
sourceOption.add(measurePoint.getSourceType());
|
sourceOption.add(measurePoint.getSourceId());
|
sourceOption.add(measurePoint.getTagNo());
|
result.setSourceOption(sourceOption);
|
} else if (PointTypeEnum.CALCULATE_POINT.getCode().equals(result.getPointType())) {
|
result.setMathPoint(daMathPointService.getByPoint(id));
|
}
|
return result;
|
}
|
|
@Override
|
public DaPointDTO getSimpleInfoById(String id) {
|
return ConvertUtils.sourceToTarget(daPointDao.selectById(id), DaPointDTO.class);
|
}
|
|
@Override
|
public DaPointDTO getSimpleInfoByNo(String no) {
|
QueryWrapper<DaPointEntity> queryWrapper = new QueryWrapper();
|
queryWrapper.eq("pointNo", no);
|
return ConvertUtils.sourceToTarget(daPointDao.selectOne(queryWrapper), DaPointDTO.class);
|
}
|
|
@Override
|
public List<DaPointDTO> list(Map<String, Object> params) {
|
Object pointType = params.get("pointType");
|
List<String> pointNos = new ArrayList<>();
|
if (params.get("pointNos") != null) {
|
pointNos = JSONArray.parseArray(JSONArray.toJSONString(params.get("pointNos")), String.class);
|
}
|
List<String> pointTypes = new ArrayList<>();
|
if (params.get("pointTypes") != null) {
|
pointTypes = Arrays.asList(params.get("pointTypes").toString().split(","));
|
}
|
|
Object pointNoLike = params.get("pointNoLike");
|
QueryWrapper<DaPointEntity> 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<DaPointEntity> 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;
|
default:
|
break;
|
}
|
daPointEntity.setIsEnable(CommonConstant.IS_ENABLE);
|
daPointEntity.setCreateTime(new Date());
|
daPointDao.insert(daPointEntity);
|
|
// 清空缓存
|
pointNoMap.clear();
|
}
|
|
@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;
|
default:
|
break;
|
}
|
// 清空缓存
|
pointNoMap.clear();
|
}
|
|
@Override
|
@DSTransactional(rollbackFor = Exception.class)
|
public void delete(String[] id) {
|
daPointDao.deleteBatchIds(Arrays.asList(id));
|
daMeasurePointService.deleteByPoint(id);
|
daMathPointService.deleteByPoint(id);
|
// 清空缓存
|
pointNoMap.clear();
|
}
|
|
@Override
|
public List<DaPointDTO> getConstantPoint(DaPointPageReqVO reqVO) {
|
Map<String, Object> 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<DaPointDTO> getConstantPoint(String freq) {
|
Map<String, Object> 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<DaPointDTO> getConstantPoint(List<String> pointNos) {
|
Map<String, Object> 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<DaPointDTO> getMeasurePoint(DaPointPageReqVO reqVO) {
|
Map<String, Object> 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<DaPointDTO> getMeasurePoint(String freq) {
|
Map<String, Object> 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<DaPointDTO> getMeasurePoint(List<String> pointNos) {
|
Map<String, Object> 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<String, Object> params = new HashMap<>();
|
params.put("pointType", PointTypeEnum.MEASURE_POINT.getCode());
|
params.put("pointNo", pointNo);
|
List<DaPointDTO> list = daPointDao.getMeasurePoint(params);
|
if (CollectionUtils.isEmpty(list)) {
|
return null;
|
}
|
return list.get(0);
|
}
|
|
@Override
|
public List<DaPointDTO> getMathPoint(DaPointPageReqVO reqVO) {
|
Map<String, Object> 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<DaPointDTO> getMathPoint(String freq) {
|
Map<String, Object> 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<DaPointDTO> getMathPoint(List<String> pointNos) {
|
Map<String, Object> 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 DaPointDTO getByNo(String pointNo) {
|
if (pointNoMap.containsKey(pointNo)) {
|
return pointNoMap.get(pointNo);
|
}
|
QueryWrapper<DaPointEntity> 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<DaPointDTO> getByNos(List<String> pointNos) {
|
QueryWrapper<DaPointEntity> wrapper = new QueryWrapper<>();
|
wrapper.in("point_no", pointNos);
|
List<DaPointEntity> list = daPointDao.selectList(wrapper);
|
return ConvertUtils.sourceToTarget(list, DaPointDTO.class);
|
}
|
|
@Override
|
public void updateDefaultValue(DaPointDTO dto) {
|
QueryWrapper<DaPointEntity> 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<PointImportExcelVO> importPoints, boolean isUpdateSupport) {
|
// 1.1 参数校验
|
if (CollUtil.isEmpty(importPoints)) {
|
throw exception(POINT_IMPORT_LIST_IS_EMPTY);
|
}
|
|
Map<String, Map<String, String>> 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;
|
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<DaMeasurePointEntity>().eq("point_id",updatePoint.getId()));
|
|
|
|
respVO.getUpdatePointnames().add(importPoint.getPointName());
|
});
|
return respVO;
|
}
|
|
@Override
|
public List<DaPointDTO> getList(DaPointPageReqVO exportReqVO) {
|
return daPointDao.getList(exportReqVO);
|
}
|
|
@Override
|
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());
|
daPointDao.updateById(entity);
|
});
|
}
|
|
@Override
|
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());
|
daPointDao.updateById(entity);
|
});
|
}
|
}
|
