From 5864e92e24a5fee0a5fed15b505933ac10df5cf4 Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期三, 19 三月 2025 17:53:21 +0800 Subject: [PATCH] 1.零件绑定 2.给对象绑定车间 3.检验对象导入模板讨论及联调导入功能 4.检验对象查询优化 --- basic-server/src/main/java/com/ruoyi/basic/service/impl/ProductPartServiceImpl.java | 78 ++++++++++++++++++++++++++++++++++++--- 1 files changed, 72 insertions(+), 6 deletions(-) diff --git a/basic-server/src/main/java/com/ruoyi/basic/service/impl/ProductPartServiceImpl.java b/basic-server/src/main/java/com/ruoyi/basic/service/impl/ProductPartServiceImpl.java index 5ecfb88..64f659a 100644 --- a/basic-server/src/main/java/com/ruoyi/basic/service/impl/ProductPartServiceImpl.java +++ b/basic-server/src/main/java/com/ruoyi/basic/service/impl/ProductPartServiceImpl.java @@ -1,10 +1,15 @@ package com.ruoyi.basic.service.impl; +import cn.hutool.core.date.DateUtil; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.StringUtils; import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.ruoyi.basic.dto.ProductPartDto; +import com.ruoyi.basic.mapper.ProductPartLogMapper; +import com.ruoyi.basic.pojo.ProductPartLog; import com.ruoyi.common.exception.base.BaseException; import com.ruoyi.common.utils.QueryWrappers; import com.ruoyi.basic.mapper.ProductPartMapper; @@ -12,22 +17,29 @@ import com.ruoyi.basic.pojo.ProductPart; import com.ruoyi.basic.pojo.StructureTestObjectPart; import com.ruoyi.basic.service.ProductPartService; +import com.ruoyi.common.utils.SecurityUtils; import lombok.AllArgsConstructor; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; + +import java.time.LocalDateTime; +import java.util.List; +import java.util.Map; @Transactional @Service @AllArgsConstructor public class ProductPartServiceImpl extends ServiceImpl<ProductPartMapper, ProductPart> implements ProductPartService { - private ProductPartMapper productPartMapper; + private ProductPartMapper productPartMapper; private StructureTestObjectPartMapper structureTestObjectPartMapper; + + private ProductPartLogMapper productPartLogMapper; @Override - public IPage<ProductPart> selectByProductId(IPage<ProductPart> page,ProductPart productPart) { - return productPartMapper.selectListByProductId(page, QueryWrappers.queryWrappers(productPart),productPart.getProductId()); + public IPage<ProductPart> selectByProductId(IPage<ProductPart> page, ProductPart productPart) { + return productPartMapper.selectListByProductId(page, QueryWrappers.queryWrappers(productPart), productPart.getProductId()); } @Override @@ -36,20 +48,74 @@ throw new BaseException("缂哄皯浜у搧瀵硅薄id"); } this.isPartNoExist(productPart.getPartNo(), productPart.getProductId(), null); + productPart.setReview("寰呭鏍�"); productPartMapper.insert(productPart); } @Override - public void updateProductPartById(ProductPart productPart) { + public int updateProductPartById(ProductPart productPart) { + if (productPart.getProductId() == null) { + throw new BaseException("缂哄皯浜у搧瀵硅薄id"); + } +// this.isPartNoExist(productPart.getPartNo(), productPart.getProductId(), null); + if (!"宸插鏍�".equals(productPart.getReview())) { + productPart.setReview("寰呭鏍�"); + } + return productPartMapper.updateById(productPart); + } + + @Override + public List<Map<String, Object>> inspectionItems(String sample, String productName) { + // 浼樺厛澶勭悊涓や釜鍙傛暟鍧囬潪绌虹殑鍦烘櫙 + if (StringUtils.isNotEmpty(productName) && StringUtils.isNotEmpty(sample)) { + //鍏堝樊浜у搧锛屾湁杩囨湁鍊肩洿鎺ヨ繑鍥烇紝娌″�煎啀鏌ュぇ绫� + List<Map<String, Object>> result = productPartMapper.inspectionItems(productName); + return result.isEmpty() ? productPartMapper.inspectionItems(sample) : result; + } + + // 鍏朵粬鎯呭喌鐩存帴閫夊彇鏈夋晥鍙傛暟锛堜紭鍏坧roductName锛夋垨绌哄瓧绗︿覆 + String param = StringUtils.isNotEmpty(productName) ? productName : + StringUtils.isNotEmpty(sample) ? sample : ""; + return productPartMapper.inspectionItems(param); + + } + + @Override + public int productPartReviewById(ProductPartDto productPartDto) { + + int userId = SecurityUtils.getUserId().intValue(); + String username = SecurityUtils.getUsername(); + ProductPart productPart = productPartMapper.selectById(productPartDto.getId()); this.isPartNoExist(productPart.getPartNo(), productPart.getProductId(), productPart.getId()); if (productPart.getProductId() == null) { throw new BaseException("缂哄皯浜у搧瀵硅薄id"); } - productPartMapper.updateById(productPart); + productPart.setReview("宸插鏍�"); + int num = productPartMapper.updateById(productPart); + if (num > 0) { + ProductPartLog productPartLog = new ProductPartLog(); + productPartLog.setProductPartId(productPart.getId()); + productPartLog.setOperName(username); + productPartLog.setOperId(userId); + productPartLog.setOperTime(LocalDateTime.now()); + productPartLog.setColor(productPart.getColor()); + productPartLog.setColorCode(productPart.getColorCode()); + productPartLog.setPartNo(productPart.getPartNo()); + productPartLog.setInspectionItem(productPart.getInspectionItem()); + productPartLog.setReview(productPart.getReview()); + productPartLogMapper.insert(productPartLog); + } + return num; + } + + @Override + public IPage<ProductPartLog> productPartLogList(Page page, Integer id) { + return productPartLogMapper.selectPage(page, Wrappers.<ProductPartLog>lambdaQuery() + .eq(ProductPartLog::getProductPartId, id)); } // 鍒ゆ柇闆朵欢鍙锋槸鍚﹀瓨鍦� - public void isPartNoExist(String partNo,Integer productId, Integer id) { + public void isPartNoExist(String partNo, Integer productId, Integer id) { // 闆朵欢鍙峰敮涓� 浣嗕笉蹇呭~ if (StringUtils.isNotBlank(partNo)) { Long count = productPartMapper.selectCount(new LambdaQueryWrapper<ProductPart>() -- Gitblit v1.9.3