package com.iailab.module.data.channel.opcda.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
|
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.iailab.framework.common.util.object.ConvertUtils;
|
import com.iailab.module.data.channel.opcda.dao.ChannelOPCDATagDao;
|
import com.iailab.module.data.channel.opcda.dto.ChannelOPCDATagDTO;
|
import com.iailab.module.data.channel.opcda.entity.ChannelOPCDATagEntity;
|
import com.iailab.module.data.channel.opcda.service.ChannelOPCDATagService;
|
import com.iailab.module.data.common.utils.PageUtils;
|
import com.iailab.module.data.common.utils.Query;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.poi.ss.usermodel.CellType;
|
import org.apache.poi.xssf.usermodel.XSSFRow;
|
import org.apache.poi.xssf.usermodel.XSSFSheet;
|
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.annotation.Resource;
|
import java.io.File;
|
import java.io.FileInputStream;
|
import java.util.ArrayList;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.UUID;
|
|
/**
|
* @author DongYukun
|
* @Description
|
* @createTime 2023年05月08日 15:04:00
|
*/
|
@Slf4j
|
@Service
|
public class ChannelOPCDATagServiceImpl extends ServiceImpl<ChannelOPCDATagDao, ChannelOPCDATagEntity> implements ChannelOPCDATagService {
|
@Resource
|
private ChannelOPCDATagDao channelOPCDATagDao;
|
|
@Value("${iems.upload-dir}")
|
private String uploadDir;
|
|
/**
|
* 分页查询tag
|
*
|
* @param params
|
*/
|
@Override
|
public PageUtils queryPage(Map<String, Object> params) {
|
String tagName = (String) params.get("tagName");
|
String serverId = (String) params.get("serverId");
|
|
IPage<ChannelOPCDATagEntity> page = this.page(
|
new Query<ChannelOPCDATagEntity>().getPage(params),
|
new QueryWrapper<ChannelOPCDATagEntity>()
|
.like(StringUtils.isNotBlank(tagName), "tag_name", tagName)
|
.eq(StringUtils.isNotBlank(serverId), "server_id", serverId)
|
.orderByDesc("create_time")
|
);
|
return new PageUtils(page);
|
}
|
|
/**
|
* 查询tag详情
|
*
|
* @param id
|
*/
|
@Override
|
public ChannelOPCDATagEntity info(String id) {
|
return channelOPCDATagDao.selectById(id);
|
}
|
|
@Override
|
public List<ChannelOPCDATagEntity> getByserverId(String serverId) {
|
QueryWrapper<ChannelOPCDATagEntity> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("server_id", serverId).orderByDesc ("create_time");
|
return channelOPCDATagDao.selectList(queryWrapper);
|
|
}
|
|
/**
|
* 添加tag
|
*
|
* @param channelOPCDATagEntity
|
*/
|
@Override
|
public void add(ChannelOPCDATagEntity channelOPCDATagEntity) {
|
channelOPCDATagDao.insert(channelOPCDATagEntity);
|
}
|
|
/**
|
* 修改tag
|
*
|
* @param channelOPCDATagEntity
|
*/
|
@Override
|
public void update(ChannelOPCDATagEntity channelOPCDATagEntity) {
|
channelOPCDATagDao.updateById(channelOPCDATagEntity);
|
}
|
|
/**
|
* 删除tag
|
*
|
* @param id
|
*/
|
@Override
|
public void delete(String id) {
|
channelOPCDATagDao.deleteById(id);
|
}
|
|
@Override
|
public List<ChannelOPCDATagDTO> selectAll() {
|
|
List<ChannelOPCDATagEntity> entityList = baseMapper.selectList(
|
null
|
);
|
return ConvertUtils.sourceToTarget(entityList, ChannelOPCDATagDTO.class);
|
}
|
|
@Override
|
public List<ChannelOPCDATagEntity> listByIds(List<String> ids) {
|
return baseMapper.selectList(new QueryWrapper<ChannelOPCDATagEntity>().in("id", ids));
|
}
|
|
@Override
|
public void deleteByServerId(String serverId) {
|
baseMapper.delete(new QueryWrapper<ChannelOPCDATagEntity>().eq("server_id",serverId));
|
}
|
|
/**
|
* 导入Tag
|
*
|
* @param serverId
|
* @param file
|
* @throws Exception
|
*/
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void importTag(String serverId, MultipartFile file) throws Exception {
|
try {
|
String suffix = file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf("."));
|
String fileName = UUID.randomUUID().toString() + suffix;
|
String path = uploadDir + fileName;
|
file.transferTo(new File(path));
|
|
XSSFWorkbook hssfWorkbook = new XSSFWorkbook(new FileInputStream(path));
|
XSSFSheet sheet = hssfWorkbook.getSheetAt(0);
|
int lastRowNum = sheet.getLastRowNum();
|
log.info("最后一行：" + lastRowNum);
|
int lastCellNum = 4;
|
List<ChannelOPCDATagEntity> dangerList = new ArrayList<>();
|
for (int i = 2; i <= lastRowNum; i++) {
|
XSSFRow row = sheet.getRow(i);
|
for (int j = row.getFirstCellNum(); j < lastCellNum; j++) {
|
row.getCell(j).setCellType(CellType.STRING);
|
}
|
ChannelOPCDATagEntity tagEntity = new ChannelOPCDATagEntity();
|
tagEntity.setId(UUID.randomUUID().toString());
|
tagEntity.setTagName(row.getCell(1).getStringCellValue());
|
tagEntity.setDataType(row.getCell(2).getStringCellValue());
|
tagEntity.setItemId(row.getCell(3).getStringCellValue());
|
tagEntity.setEnabled(true);
|
tagEntity.setServerId(serverId);
|
dangerList.add(tagEntity);
|
}
|
if (CollectionUtils.isEmpty(dangerList)) {
|
return;
|
}
|
//getBaseMapper().insertList(dangerList);
|
dangerList.forEach(item -> {
|
try {
|
getBaseMapper().insert(item);
|
} catch (Exception ex) {
|
log.warn("插入异常：" + item.getTagName());
|
}
|
});
|
} catch (Exception ex) {
|
ex.printStackTrace();
|
log.warn("导入失败！");
|
throw ex;
|
}
|
}
|
}
|
