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 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> totals = recordMapper.selectTotals(todayReqVO); Map 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()); } }