From 6ad5c2cdc193cf7bb02884961b7434cd7f607a0d Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期四, 16 四月 2026 10:48:09 +0800
Subject: [PATCH] feat(production): 扩展生产工艺路线支持多产品绑定及工单权限控制
---
src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java | 185 +++++++++++++++++++++++++++------------------
1 files changed, 110 insertions(+), 75 deletions(-)
diff --git a/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java b/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java
index f6d6b27..82fcdba 100644
--- a/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java
+++ b/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java
@@ -5,17 +5,19 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
-import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.ruoyi.common.enums.StockQualifiedRecordTypeEnum;
-import com.ruoyi.common.enums.StockUnQualifiedRecordTypeEnum;
-import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.basic.mapper.ProductMapper;
+import com.ruoyi.basic.mapper.ProductModelMapper;
+import com.ruoyi.basic.pojo.Product;
+import com.ruoyi.basic.pojo.ProductModel;
+import com.ruoyi.common.enums.StockOutQualifiedRecordTypeEnum;
+import com.ruoyi.common.enums.StockInUnQualifiedRecordTypeEnum;
import com.ruoyi.framework.web.domain.R;
import com.ruoyi.procurementrecord.utils.StockUtils;
import com.ruoyi.production.dto.ProductStructureDto;
import com.ruoyi.production.mapper.*;
import com.ruoyi.production.pojo.*;
-import com.ruoyi.production.service.impl.SalesLedgerProductionAccountingServiceImpl;
+import com.ruoyi.production.service.impl.ProductOrderServiceImpl;
import com.ruoyi.purchase.mapper.PurchaseLedgerMapper;
import com.ruoyi.purchase.pojo.PurchaseLedger;
import com.ruoyi.quality.mapper.QualityInspectMapper;
@@ -26,7 +28,6 @@
import com.ruoyi.sales.mapper.SalesLedgerMapper;
import com.ruoyi.sales.mapper.SalesLedgerProductMapper;
import com.ruoyi.sales.mapper.ShippingInfoMapper;
-import com.ruoyi.sales.pojo.InvoiceRegistrationProduct;
import com.ruoyi.sales.pojo.SalesLedger;
import com.ruoyi.sales.pojo.SalesLedgerProduct;
import com.ruoyi.sales.pojo.ShippingInfo;
@@ -66,6 +67,10 @@
private PurchaseLedgerMapper purchaseLedgerMapper;
+ private ProductMapper productMapper;
+
+ private ProductModelMapper productModelMapper;
+
private ProductOrderMapper productOrderMapper;
private ProcessRouteItemMapper processRouteItemMapper;
@@ -94,7 +99,7 @@
@Autowired
private StockInventoryMapper stockInventoryMapper;
@Autowired
- private SalesLedgerProductionAccountingServiceImpl salesLedgerProductionAccountingServiceImpl;
+ private ProductOrderServiceImpl productOrderServiceImpl;
@Override
public SalesLedgerProduct selectSalesLedgerProductById(Long id) {
@@ -266,79 +271,103 @@
}
/**
+ * 閫氳繃浜у搧澶х被锛岃鏍煎瀷鍙锋煡璇roductModelId
+ */
+ public Long getProductModelId(String productCategory, String productSpecification) {
+ Product product = productMapper.selectOne(new QueryWrapper<Product>()
+ .lambda()
+ .eq(Product::getProductName, productCategory)
+ .orderByDesc(Product::getId)
+ .last("LIMIT 1"));
+ if(product == null){
+ throw new RuntimeException("璇峰厛娣诲姞浜у搧");
+ }
+ ProductModel productModel = productModelMapper.selectOne(new QueryWrapper<ProductModel>()
+ .lambda()
+ .eq(ProductModel::getProductId, product.getId())
+ .eq(ProductModel::getModel, productSpecification)
+ .orderByDesc(ProductModel::getId)
+ .last("LIMIT 1"));
+ return productModel == null ? null : productModel.getId();
+ }
+
+ /**
* 鏂板鐢熶骇鏁版嵁
*/
public void addProductionData(SalesLedgerProduct salesLedgerProduct) {
ProductOrder productOrder = new ProductOrder();
productOrder.setSalesLedgerId(salesLedgerProduct.getSalesLedgerId());
- productOrder.setProductModelId(salesLedgerProduct.getProductModelId());
+ if(salesLedgerProduct.getProductModelId() == null){
+ Long productModelId = getProductModelId(salesLedgerProduct.getProductCategory(), salesLedgerProduct.getSpecificationModel());
+ productOrder.setProductModelId(productModelId);
+ }else{
+ productOrder.setProductModelId(salesLedgerProduct.getProductModelId());
+ }
productOrder.setSaleLedgerProductId(salesLedgerProduct.getId());
- productOrder.setNpsNo("SC" + String.format("%08d", salesLedgerProduct.getId()));
+ String string = productOrderServiceImpl.generateNextOrderNo(LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd")));
+ productOrder.setNpsNo(string);
productOrder.setQuantity(salesLedgerProduct.getQuantity());//闇�姹傛暟閲�
productOrder.setCompleteQuantity(BigDecimal.ZERO);//瀹屾垚鏁伴噺
productOrderMapper.insert(productOrder);
-
- List<ProcessRoute> processRoutes = processRouteMapper.selectList(new QueryWrapper<ProcessRoute>().lambda()
- .eq(ProcessRoute::getProductModelId, salesLedgerProduct.getProductModelId())
- .orderByDesc(ProcessRoute::getCreateTime));
- if (processRoutes.size()>0){
- ProcessRoute processRoute = processRoutes.get(0);
- //鏂板鐢熶骇璁㈠崟宸ヨ壓璺嚎涓昏〃
- ProductProcessRoute productProcessRoute = new ProductProcessRoute();
- productProcessRoute.setProductModelId(processRoute.getProductModelId());
- productProcessRoute.setProcessRouteCode(processRoute.getProcessRouteCode());
- productProcessRoute.setProductOrderId(productOrder.getId());
- productProcessRoute.setBomId(processRoute.getBomId());
- productProcessRouteMapper.insert(productProcessRoute);
- //鏂板鐢熶骇璁㈠崟宸ヨ壓璺嚎瀛愯〃
- List<ProcessRouteItem> processRouteItems = processRouteItemMapper.selectList(new QueryWrapper<ProcessRouteItem>().lambda().eq(ProcessRouteItem::getRouteId, processRoute.getId()));
- // 鐢熸垚褰撳墠鏃ユ湡鐨勫墠缂�锛氬勾鏈堟棩
- String datePrefix = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd"));
- for (ProcessRouteItem processRouteItem : processRouteItems) {
- ProductProcessRouteItem productProcessRouteItem = new ProductProcessRouteItem();
- productProcessRouteItem.setProductModelId(processRouteItem.getProductModelId());
- productProcessRouteItem.setProcessId(processRouteItem.getProcessId());
- productProcessRouteItem.setProductOrderId(productOrder.getId());
- productProcessRouteItem.setProductRouteId(productProcessRoute.getId());
- productProcessRouteItem.setDragSort(processRouteItem.getDragSort());
- int insert = productProcessRouteItemMapper.insert(productProcessRouteItem);
- if (insert > 0) {
- // 鏌ヨ浠婃棩宸插瓨鍦ㄧ殑鏈�澶у伐鍗曞彿
- QueryWrapper<ProductWorkOrder> queryWrapper = new QueryWrapper<>();
- queryWrapper.likeRight("work_order_no", datePrefix)
- .orderByDesc("work_order_no")
- .last("LIMIT 1");
-
- ProductWorkOrder lastWorkOrder = productWorkOrderMapper.selectOne(queryWrapper);
-
- int sequenceNumber = 1; // 榛樿搴忓彿
- if (lastWorkOrder != null && lastWorkOrder.getWorkOrderNo() != null) {
- String lastNo = lastWorkOrder.getWorkOrderNo().toString();
- if (lastNo.startsWith(datePrefix)) {
- String seqStr = lastNo.substring(datePrefix.length());
- try {
- sequenceNumber = Integer.parseInt(seqStr) + 1;
- } catch (NumberFormatException e) {
- sequenceNumber = 1;
- }
- }
- }
- // 鐢熸垚瀹屾暣鐨勫伐鍗曞彿
- String workOrderNoStr ="GD"+ String.format("%s%03d", datePrefix, sequenceNumber);
- ProductWorkOrder productWorkOrder = new ProductWorkOrder();
- productWorkOrder.setProductProcessRouteItemId(productProcessRouteItem.getId());
- productWorkOrder.setProductOrderId(productOrder.getId());
- productWorkOrder.setPlanQuantity(salesLedgerProduct.getQuantity());
- productWorkOrder.setWorkOrderNo(workOrderNoStr);
- productWorkOrder.setStatus(1);
-
- productWorkOrderMapper.insert(productWorkOrder);
- }
-
- }
- productOrder.setRouteId(processRoute.getId());
- productOrderMapper.updateById(productOrder);
- }
+ // 鍙栨秷榛樿鐨勫伐鑹鸿矾绾�
+// List<ProcessRoute> processRoutes = processRouteMapper.selectList(
+// new QueryWrapper<ProcessRoute>()
+// .and(wrapper -> wrapper.eq("product_model_id", salesLedgerProduct.getProductModelId())
+// .or()
+// .apply("find_in_set({0}, product_model_ids)", salesLedgerProduct.getProductModelId()))
+// .orderByDesc("create_time"));
+// if (processRoutes.size()>0){
+// ProcessRoute processRoute = processRoutes.get(0);
+// //鏂板鐢熶骇璁㈠崟宸ヨ壓璺嚎涓昏〃
+// ProductProcessRoute productProcessRoute = new ProductProcessRoute();
+// productProcessRoute.setProductModelId(salesLedgerProduct.getProductModelId());
+// productProcessRoute.setProcessRouteCode(processRoute.getProcessRouteCode());
+// productProcessRoute.setProductOrderId(productOrder.getId());
+// productProcessRoute.setBomId(processRoute.getBomId());
+// productProcessRouteMapper.insert(productProcessRoute);
+// //鏂板鐢熶骇璁㈠崟宸ヨ壓璺嚎瀛愯〃
+// List<ProcessRouteItem> processRouteItems = processRouteItemMapper.selectList(new QueryWrapper<ProcessRouteItem>().lambda().eq(ProcessRouteItem::getRouteId, processRoute.getId()));
+// // 鐢熸垚褰撳墠鏃ユ湡鐨勫墠缂�锛氬勾鏈堟棩
+// String datePrefix = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd"));
+// for (ProcessRouteItem processRouteItem : processRouteItems) {
+// ProductProcessRouteItem productProcessRouteItem = new ProductProcessRouteItem();
+// productProcessRouteItem.setProductModelId(salesLedgerProduct.getProductModelId());
+// productProcessRouteItem.setProcessId(processRouteItem.getProcessId());
+// productProcessRouteItem.setProductOrderId(productOrder.getId());
+// productProcessRouteItem.setProductRouteId(productProcessRoute.getId());
+// productProcessRouteItem.setDragSort(processRouteItem.getDragSort());
+// int insert = productProcessRouteItemMapper.insert(productProcessRouteItem);
+// if (insert > 0) {
+// // 鏌ヨ浠婃棩宸插瓨鍦ㄧ殑鏈�澶у伐鍗曞彿
+// ProductWorkOrder lastWorkOrder = productWorkOrderMapper.selectMax(datePrefix);
+// int sequenceNumber = 1; // 榛樿搴忓彿
+// if (lastWorkOrder != null && lastWorkOrder.getWorkOrderNo() != null) {
+// String lastNo = lastWorkOrder.getWorkOrderNo().toString();
+// if (lastNo.startsWith(datePrefix)) {
+// String seqStr = lastNo.substring(datePrefix.length());
+// try {
+// sequenceNumber = Integer.parseInt(seqStr) + 1;
+// } catch (NumberFormatException e) {
+// sequenceNumber = 1;
+// }
+// }
+// }
+// // 鐢熸垚瀹屾暣鐨勫伐鍗曞彿
+// String workOrderNoStr ="GD"+ String.format("%s%03d", datePrefix, sequenceNumber);
+// ProductWorkOrder productWorkOrder = new ProductWorkOrder();
+// productWorkOrder.setProductProcessRouteItemId(productProcessRouteItem.getId());
+// productWorkOrder.setProductOrderId(productOrder.getId());
+// productWorkOrder.setPlanQuantity(salesLedgerProduct.getQuantity());
+// productWorkOrder.setWorkOrderNo(workOrderNoStr);
+// productWorkOrder.setStatus(1);
+//
+// productWorkOrderMapper.insert(productWorkOrder);
+// }
+//
+// }
+// productOrder.setRouteId(processRoute.getId());
+// productOrderMapper.updateById(productOrder);
+// }
}
/**
@@ -397,9 +426,9 @@
//鍒犻櫎鍑哄簱璁板綍
for (Long productMainId : productMainIds) {
//鍒犻櫎鐢熶骇鍑哄簱璁板綍
- stockUtils.deleteStockOutRecord(productMainId, StockQualifiedRecordTypeEnum.PRODUCTION_REPORT_STOCK_OUT.getCode());
+ stockUtils.deleteStockOutRecord(productMainId, StockOutQualifiedRecordTypeEnum.PRODUCTION_REPORT_STOCK_OUT.getCode());
//鍒犻櫎鎶ュ簾鐨勫叆搴撹褰�
- stockUtils.deleteStockInRecord(productMainId, StockUnQualifiedRecordTypeEnum.PRODUCTION_SCRAP.getCode());
+ stockUtils.deleteStockInRecord(productMainId, StockInUnQualifiedRecordTypeEnum.PRODUCTION_SCRAP.getCode());
}
qualityInspects.forEach(qualityInspect -> {
//inspectState=1 宸叉彁浜� 涓嶈兘鍒犻櫎
@@ -453,7 +482,7 @@
IPage<SalesLedgerProductDto> salesLedgerProductDtoIPage = salesLedgerProductMapper.listPagePurchaseLedger(page, salesLedgerProduct);
salesLedgerProductDtoIPage.getRecords().forEach(item -> {
// 鍒ゆ柇鐘舵��
- if(item.getTaxInclusiveTotalPrice().compareTo(item.getInvoiceTotal()) == 0){
+ if(item.getTaxInclusiveTotalPrice().compareTo(item.getTicketsTotal()) == 0){
item.setStatusName("宸插畬鎴愪粯娆�");
}else{
item.setStatusName("鏈畬鎴愪粯娆�");
@@ -499,7 +528,13 @@
@Override
public R judgmentInventory(SalesLedgerProduct salesLedgerProduct) {
//鑾峰彇浜у搧鏈�鏂扮殑宸ヨ壓璺嚎
- ProcessRoute processRoute = processRouteMapper.selectOne(new QueryWrapper<ProcessRoute>().lambda().eq(ProcessRoute::getProductModelId, salesLedgerProduct.getProductModelId()).orderByDesc(ProcessRoute::getCreateTime).last("LIMIT 1"));
+ ProcessRoute processRoute = processRouteMapper.selectOne(
+ new QueryWrapper<ProcessRoute>()
+ .and(wrapper -> wrapper.eq("product_model_id", salesLedgerProduct.getProductModelId())
+ .or()
+ .apply("find_in_set({0}, product_model_ids)", salesLedgerProduct.getProductModelId()))
+ .orderByDesc("create_time")
+ .last("LIMIT 1"));
if (processRoute == null) {
return R.fail("璇峰厛璁剧疆宸ヨ壓璺嚎");
}
--
Gitblit v1.9.3