package cn.iocoder.yudao.module.mes.service.dc.record;
|
|
import cn.hutool.core.util.ObjUtil;
|
import cn.hutool.core.util.StrUtil;
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.module.mes.controller.admin.dc.open.vo.MesDcIngestReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.dc.open.vo.MesDcIngestRespVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.dc.record.vo.MesDcRecordCancelReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.dc.record.vo.MesDcRecordCorrectReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.dc.record.vo.MesDcRecordPageReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.dc.statistics.vo.MesDcStatisticsReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.dc.device.MesDcDeviceDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.dc.record.MesDcRecordDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdItemDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.pro.workorder.MesProWorkOrderDO;
|
import cn.iocoder.yudao.module.mes.dal.mysql.dc.device.MesDcDeviceMapper;
|
import cn.iocoder.yudao.module.mes.dal.mysql.dc.record.MesDcRecordMapper;
|
import cn.iocoder.yudao.module.mes.enums.dc.MesDcDeviceStatusEnum;
|
import cn.iocoder.yudao.module.mes.enums.dc.MesDcRecordStatusEnum;
|
import cn.iocoder.yudao.module.mes.service.dc.device.MesDcDeviceService;
|
import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService;
|
import cn.iocoder.yudao.module.mes.service.pro.workorder.MesProWorkOrderService;
|
import jakarta.annotation.Resource;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.validation.annotation.Validated;
|
|
import java.math.BigDecimal;
|
import java.time.LocalDate;
|
import java.time.LocalDateTime;
|
import java.util.List;
|
import java.util.Map;
|
|
import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
|
import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*;
|
|
/**
|
* MES 数据采集记录 Service 实现类
|
*
|
* @author 超级管理员
|
*/
|
@Service
|
@Validated
|
public class MesDcRecordServiceImpl implements MesDcRecordService {
|
|
@Resource
|
private MesDcRecordMapper recordMapper;
|
@Resource
|
private MesDcDeviceMapper deviceMapper;
|
@Resource
|
private MesDcDeviceService deviceService;
|
@Resource
|
private MesProWorkOrderService workOrderService;
|
@Resource
|
private MesMdItemService itemService;
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public MesDcIngestRespVO ingest(MesDcIngestReqVO reqVO, String token, String rawData) {
|
// 1. 校验设备编号与令牌
|
MesDcDeviceDO device = deviceService.validateDeviceToken(reqVO.getDeviceCode(), token);
|
// 2. 幂等:同一设备 + bizId 重复上报直接返回已有记录
|
if (StrUtil.isNotBlank(reqVO.getBizId())) {
|
MesDcRecordDO existing = recordMapper.selectByDeviceIdAndBizId(device.getId(), reqVO.getBizId());
|
if (existing != null) {
|
return buildIngestResp(existing, device, true);
|
}
|
}
|
// 3. 校验上报数量与重量
|
validateIngestPayload(device, reqVO);
|
|
// 4. 计算本次数量:优先 count;只有累计值时按上一次累计值求差
|
int quantity = resolveQuantity(device, reqVO);
|
// 累计值重复上报(设备重试但未带 bizId):不新增记录,按重复上报返回
|
if (reqVO.getCount() == null && reqVO.getTotalCount() != null && quantity == 0) {
|
MesDcRecordDO last = recordMapper.selectLastByDeviceId(device.getId());
|
if (last != null) {
|
return buildIngestResp(last, device, true);
|
}
|
}
|
|
// 5. 组装记录(截断到秒,避免数据库按秒四舍五入后落到下一时刻)
|
LocalDateTime now = LocalDateTime.now().withNano(0);
|
MesDcRecordDO record = new MesDcRecordDO();
|
record.setDeviceId(device.getId());
|
record.setDeviceCode(device.getCode());
|
record.setDeviceName(device.getName());
|
record.setRecordNo(reqVO.getRecordNo());
|
record.setBizId(StrUtil.emptyToNull(reqVO.getBizId()));
|
record.setQuantity(quantity);
|
record.setTotalQuantity(reqVO.getTotalCount());
|
record.setWeight(reqVO.getWeight());
|
record.setTotalWeight(reqVO.getTotalWeight());
|
record.setRecordTime(reqVO.getRecordTime() != null ? reqVO.getRecordTime() : now);
|
record.setReceiveTime(now);
|
record.setOnline(reqVO.getOnline() == null || reqVO.getOnline());
|
record.setRawData(rawData);
|
record.setStatus(MesDcRecordStatusEnum.NORMAL.getStatus());
|
fillWorkOrderInfo(record, device);
|
recordMapper.insert(record);
|
|
// 6. 更新设备最后上报时间与固件版本
|
MesDcDeviceDO updateObj = new MesDcDeviceDO();
|
updateObj.setId(device.getId());
|
updateObj.setLastIngestTime(now);
|
if (StrUtil.isNotBlank(reqVO.getFirmwareVersion())) {
|
updateObj.setFirmwareVersion(reqVO.getFirmwareVersion());
|
}
|
deviceMapper.updateById(updateObj);
|
|
return buildIngestResp(record, device, false);
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void correctRecord(MesDcRecordCorrectReqVO reqVO) {
|
MesDcRecordDO record = validateRecordExists(reqVO.getId());
|
if (!ObjUtil.equal(record.getStatus(), MesDcRecordStatusEnum.NORMAL.getStatus())) {
|
throw exception(DC_RECORD_OPERATE_STATUS_INVALID, record.getId(),
|
resolveRecordStatusName(record.getStatus()), "更正");
|
}
|
MesDcRecordDO updateObj = new MesDcRecordDO();
|
updateObj.setId(record.getId());
|
updateObj.setQuantity(reqVO.getQuantity());
|
updateObj.setStatus(MesDcRecordStatusEnum.CORRECTED.getStatus());
|
updateObj.setCorrectReason(reqVO.getReason());
|
if (record.getOriginalQuantity() == null) {
|
updateObj.setOriginalQuantity(record.getQuantity());
|
}
|
recordMapper.updateById(updateObj);
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void cancelRecord(MesDcRecordCancelReqVO reqVO) {
|
MesDcRecordDO record = validateRecordExists(reqVO.getId());
|
if (ObjUtil.equal(record.getStatus(), MesDcRecordStatusEnum.CANCELED.getStatus())) {
|
throw exception(DC_RECORD_OPERATE_STATUS_INVALID, record.getId(),
|
resolveRecordStatusName(record.getStatus()), "作废");
|
}
|
MesDcRecordDO updateObj = new MesDcRecordDO();
|
updateObj.setId(record.getId());
|
updateObj.setStatus(MesDcRecordStatusEnum.CANCELED.getStatus());
|
updateObj.setCorrectReason(reqVO.getReason());
|
if (record.getOriginalQuantity() == null) {
|
updateObj.setOriginalQuantity(record.getQuantity());
|
}
|
recordMapper.updateById(updateObj);
|
}
|
|
@Override
|
public MesDcRecordDO getRecord(Long id) {
|
return recordMapper.selectById(id);
|
}
|
|
@Override
|
public PageResult<MesDcRecordDO> getRecordPage(MesDcRecordPageReqVO pageReqVO) {
|
return recordMapper.selectPage(pageReqVO);
|
}
|
|
// ==================== 私有方法 ====================
|
|
private MesDcRecordDO validateRecordExists(Long id) {
|
MesDcRecordDO record = recordMapper.selectById(id);
|
if (record == null) {
|
throw exception(DC_RECORD_NOT_EXISTS);
|
}
|
return record;
|
}
|
|
private void validateIngestPayload(MesDcDeviceDO device, MesDcIngestReqVO reqVO) {
|
if (ObjUtil.equal(device.getStatus(), MesDcDeviceStatusEnum.DISABLE.getStatus())) {
|
throw exception(DC_DEVICE_DISABLED, device.getName() + "(" + device.getCode() + ")");
|
}
|
if (reqVO.getCount() == null && reqVO.getTotalCount() == null) {
|
throw exception(DC_RECORD_COUNT_REQUIRED);
|
}
|
if ((reqVO.getCount() != null && reqVO.getCount() < 0)
|
|| (reqVO.getTotalCount() != null && reqVO.getTotalCount() < 0)) {
|
throw exception(DC_RECORD_COUNT_INVALID,
|
reqVO.getCount() == null ? "未填写" : String.valueOf(reqVO.getCount()),
|
reqVO.getTotalCount() == null ? "未填写" : String.valueOf(reqVO.getTotalCount()));
|
}
|
if ((reqVO.getWeight() != null && reqVO.getWeight().signum() < 0)
|
|| (reqVO.getTotalWeight() != null && reqVO.getTotalWeight().signum() < 0)) {
|
throw exception(DC_RECORD_WEIGHT_INVALID,
|
reqVO.getWeight() == null ? "未填写" : reqVO.getWeight().toPlainString(),
|
reqVO.getTotalWeight() == null ? "未填写" : reqVO.getTotalWeight().toPlainString());
|
}
|
}
|
|
/**
|
* 计算本次数量:
|
* 1. 上报 count 时直接使用;
|
* 2. 只有 totalCount 时,与上一次记录的累计值求差;首次上报或设备计数器清零时直接使用累计值。
|
*/
|
private int resolveQuantity(MesDcDeviceDO device, MesDcIngestReqVO reqVO) {
|
if (reqVO.getCount() != null) {
|
return reqVO.getCount();
|
}
|
MesDcRecordDO last = recordMapper.selectLastByDeviceId(device.getId());
|
Integer lastTotal = last != null ? last.getTotalQuantity() : null;
|
if (lastTotal == null || reqVO.getTotalCount() < lastTotal) {
|
return reqVO.getTotalCount();
|
}
|
return reqVO.getTotalCount() - lastTotal;
|
}
|
|
private void fillWorkOrderInfo(MesDcRecordDO record, MesDcDeviceDO device) {
|
if (device.getWorkOrderId() == null) {
|
return;
|
}
|
MesProWorkOrderDO workOrder = workOrderService.getWorkOrder(device.getWorkOrderId());
|
if (workOrder == null) {
|
return;
|
}
|
record.setWorkOrderId(workOrder.getId());
|
record.setWorkOrderCode(workOrder.getCode());
|
record.setProductId(workOrder.getProductId());
|
record.setBatchCode(workOrder.getBatchCode());
|
if (workOrder.getProductId() != null) {
|
MesMdItemDO item = itemService.getItem(workOrder.getProductId());
|
if (item != null) {
|
record.setProductCode(item.getCode());
|
record.setProductName(item.getName());
|
}
|
}
|
}
|
|
private MesDcIngestRespVO buildIngestResp(MesDcRecordDO record, MesDcDeviceDO device,
|
boolean duplicate) {
|
MesDcIngestRespVO respVO = new MesDcIngestRespVO();
|
respVO.setRecordId(record.getId());
|
respVO.setDuplicate(duplicate);
|
respVO.setQuantity(record.getQuantity());
|
respVO.setServerTime(LocalDateTime.now());
|
// 今日累计(不含已作废记录)
|
MesDcStatisticsReqVO todayReqVO = new MesDcStatisticsReqVO();
|
todayReqVO.setBeginTime(LocalDate.now().atStartOfDay());
|
todayReqVO.setEndTime(LocalDate.now().plusDays(1).atStartOfDay());
|
todayReqVO.setDeviceId(device.getId());
|
List<Map<String, Object>> totals = recordMapper.selectTotals(todayReqVO);
|
Map<String, Object> totalRow = totals.isEmpty() ? Map.of() : totals.get(0);
|
respVO.setTodayQuantity(toLong(totalRow.get("totalQuantity")));
|
respVO.setTodayWeight(toDecimal(totalRow.get("totalWeight")));
|
return respVO;
|
}
|
|
private static String resolveRecordStatusName(Integer status) {
|
MesDcRecordStatusEnum statusEnum = MesDcRecordStatusEnum.valueOf(status);
|
return statusEnum != null ? statusEnum.getName() : "未知状态(" + status + ")";
|
}
|
|
private static long toLong(Object value) {
|
if (value == null) {
|
return 0L;
|
}
|
if (value instanceof Number number) {
|
return number.longValue();
|
}
|
return Long.parseLong(value.toString());
|
}
|
|
private static BigDecimal toDecimal(Object value) {
|
if (value == null) {
|
return BigDecimal.ZERO;
|
}
|
if (value instanceof BigDecimal decimal) {
|
return decimal;
|
}
|
if (value instanceof Number number) {
|
return new BigDecimal(number.toString());
|
}
|
return new BigDecimal(value.toString());
|
}
|
|
}
|