From 83923ea389a172c1cf3d9cd7a3628d3692e9feaf Mon Sep 17 00:00:00 2001
From: wujian <14790700720@163.com>
Date: 星期四, 18 一月 2024 18:14:12 +0800
Subject: [PATCH] add 工艺流程

---
 jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/controller/PrepareOnlineController.java   |    1 
 jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/Query/PrepareOnlineQuery.java             |    4 ++
 jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/mapper/BsFormulaChildInfoMapper.java         |   10 ++++-
 jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/service/impl/ProductProcessService.java      |   28 ++++++++++++++
 jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/controller/BsFormulaChildInfoController.java |   39 ++++++++++++-------
 jcdm-main/src/main/resources/mapper/bs/formulaChild/BsFormulaChildInfoMapper.xml                   |   11 +++++
 jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/Query/ProductProcessQuery.java               |   17 ++++++++
 7 files changed, 92 insertions(+), 18 deletions(-)

diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/Query/ProductProcessQuery.java b/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/Query/ProductProcessQuery.java
new file mode 100644
index 0000000..6c4cd46
--- /dev/null
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/Query/ProductProcessQuery.java
@@ -0,0 +1,17 @@
+package com.jcdm.main.bs.formulaChild.Query;
+
+import lombok.Data;
+
+@Data
+public class ProductProcessQuery {
+
+    /**
+     * 浜у搧缂栧彿
+     */
+    private String productCode;
+
+    /**
+     * 宸ュ簭
+     */
+    private String processesCode;
+}
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/controller/BsFormulaChildInfoController.java b/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/controller/BsFormulaChildInfoController.java
index 3c54be3..ba5c4d2 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/controller/BsFormulaChildInfoController.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/controller/BsFormulaChildInfoController.java
@@ -1,25 +1,21 @@
 package com.jcdm.main.bs.formulaChild.controller;
 
-import java.util.List;
-import javax.servlet.http.HttpServletResponse;
-import org.springframework.security.access.prepost.PreAuthorize;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.web.bind.annotation.GetMapping;
-import org.springframework.web.bind.annotation.PostMapping;
-import org.springframework.web.bind.annotation.PutMapping;
-import org.springframework.web.bind.annotation.DeleteMapping;
-import org.springframework.web.bind.annotation.PathVariable;
-import org.springframework.web.bind.annotation.RequestBody;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RestController;
 import com.jcdm.common.annotation.Log;
 import com.jcdm.common.core.controller.BaseController;
 import com.jcdm.common.core.domain.AjaxResult;
+import com.jcdm.common.core.page.TableDataInfo;
 import com.jcdm.common.enums.BusinessType;
+import com.jcdm.common.utils.poi.ExcelUtil;
+import com.jcdm.main.bs.formulaChild.Query.ProductProcessQuery;
 import com.jcdm.main.bs.formulaChild.domain.BsFormulaChildInfo;
 import com.jcdm.main.bs.formulaChild.service.IBsFormulaChildInfoService;
-import com.jcdm.common.utils.poi.ExcelUtil;
-import com.jcdm.common.core.page.TableDataInfo;
+import com.jcdm.main.bs.formulaChild.service.impl.ProductProcessService;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.web.bind.annotation.*;
+
+import javax.servlet.http.HttpServletResponse;
+import java.util.List;
 
 /**
  * 閰嶆柟閰嶇疆瀛愪俊鎭疌ontroller
@@ -33,6 +29,9 @@
 {
     @Autowired
     private IBsFormulaChildInfoService bsFormulaChildInfoService;
+
+    @Autowired
+    private ProductProcessService productProcessService;
 
     /**
      * 鏌ヨ閰嶆柟閰嶇疆瀛愪俊鎭垪琛�
@@ -52,6 +51,18 @@
     }
 
     /**
+     * 鏌ヨ宸ヨ壓娴佺▼
+     * @param productProcessQuery query
+     * @return list
+     */
+    @PostMapping("/getProductProcess")
+    public TableDataInfo getProductProcess(@RequestBody ProductProcessQuery productProcessQuery)
+    {
+        List<BsFormulaChildInfo> list = productProcessService.getProductProcess(productProcessQuery);
+        return getDataTable(list);
+    }
+
+    /**
      * 瀵煎嚭閰嶆柟閰嶇疆瀛愪俊鎭垪琛�
      */
     @PreAuthorize("@ss.hasPermi('bs:formulaChild:export')")
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/mapper/BsFormulaChildInfoMapper.java b/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/mapper/BsFormulaChildInfoMapper.java
index faf4468..04c273b 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/mapper/BsFormulaChildInfoMapper.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/mapper/BsFormulaChildInfoMapper.java
@@ -1,7 +1,9 @@
 package com.jcdm.main.bs.formulaChild.mapper;
 
-import java.util.List;
+import com.jcdm.main.bs.formulaChild.Query.ProductProcessQuery;
 import com.jcdm.main.bs.formulaChild.domain.BsFormulaChildInfo;
+
+import java.util.List;
 
 /**
  * 閰嶆柟閰嶇疆瀛愪俊鎭疢apper鎺ュ彛
@@ -9,7 +11,8 @@
  * @author ruimin
  * @date 2023-12-26
  */
-public interface BsFormulaChildInfoMapper 
+
+public interface BsFormulaChildInfoMapper
 {
     /**
      * 鏌ヨ閰嶆柟閰嶇疆瀛愪俊鎭�
@@ -58,4 +61,7 @@
      * @return 缁撴灉
      */
     public int deleteBsFormulaChildInfoByIds(Long[] ids);
+
+
+    public List<BsFormulaChildInfo> getProductProcess(ProductProcessQuery productProcessQuery);
 }
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/service/impl/ProductProcessService.java b/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/service/impl/ProductProcessService.java
new file mode 100644
index 0000000..35a42a7
--- /dev/null
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/formulaChild/service/impl/ProductProcessService.java
@@ -0,0 +1,28 @@
+package com.jcdm.main.bs.formulaChild.service.impl;
+
+import com.jcdm.main.bs.formulaChild.Query.ProductProcessQuery;
+import com.jcdm.main.bs.formulaChild.domain.BsFormulaChildInfo;
+import com.jcdm.main.bs.formulaChild.mapper.BsFormulaChildInfoMapper;
+import org.springframework.stereotype.Service;
+
+import javax.annotation.Resource;
+import java.util.List;
+
+@Service
+public class ProductProcessService {
+
+    @Resource
+    private BsFormulaChildInfoMapper bsFormulaChildInfoMapper;
+
+    public List<BsFormulaChildInfo> getProductProcess(ProductProcessQuery productProcessQuery){
+
+
+        List<BsFormulaChildInfo> list = bsFormulaChildInfoMapper.getProductProcess(productProcessQuery);
+
+//        if (CollUtil.isNotEmpty(list)){
+//            list = list.stream().sorted(Comparator.comparing(BsFormulaChildInfo::getStepSort)).collect(Collectors.toList());
+//        }
+        return list;
+    }
+
+}
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/Query/PrepareOnlineQuery.java b/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/Query/PrepareOnlineQuery.java
index a81f799..bd93747 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/Query/PrepareOnlineQuery.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/Query/PrepareOnlineQuery.java
@@ -1,8 +1,12 @@
 package com.jcdm.main.bs.orderScheduling.Query;
 
+import lombok.AllArgsConstructor;
 import lombok.Data;
+import lombok.NoArgsConstructor;
 
 @Data
+@AllArgsConstructor
+@NoArgsConstructor
 public class PrepareOnlineQuery {
 
     /**
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/controller/PrepareOnlineController.java b/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/controller/PrepareOnlineController.java
index 05be5aa..17621d1 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/controller/PrepareOnlineController.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/controller/PrepareOnlineController.java
@@ -22,7 +22,6 @@
     private BsOrderSchedulingServiceImpl bsOrderSchedulingService;
 
 
-//    @PreAuthorize("@ss.hasPermi('bs:orderScheduling:list')")
     @PostMapping("/list")
     public TableDataInfo list(@RequestBody PrepareOnlineQuery prepareOnlineQuery)
     {
diff --git a/jcdm-main/src/main/resources/mapper/bs/formulaChild/BsFormulaChildInfoMapper.xml b/jcdm-main/src/main/resources/mapper/bs/formulaChild/BsFormulaChildInfoMapper.xml
index 4810be1..24ab904 100644
--- a/jcdm-main/src/main/resources/mapper/bs/formulaChild/BsFormulaChildInfoMapper.xml
+++ b/jcdm-main/src/main/resources/mapper/bs/formulaChild/BsFormulaChildInfoMapper.xml
@@ -50,7 +50,16 @@
         <include refid="selectBsFormulaChildInfoVo"/>
         where id = #{id}
     </select>
-        
+
+    <select id="getProductProcess" parameterType="com.jcdm.main.bs.formulaChild.Query.ProductProcessQuery" resultMap="BsFormulaChildInfoResult">
+        <include refid="selectBsFormulaChildInfoVo"/>
+        <where>
+            <if test="processesCode != null and processesCode != '' ">and processes_code = #{processesCode}</if>
+            <if test="productCode != null and productCode != '' ">and product_code = #{productCode}</if>
+        </where>
+        order by step_sort
+    </select>
+
     <insert id="insertBsFormulaChildInfo" parameterType="BsFormulaChildInfo" useGeneratedKeys="true" keyProperty="id">
         insert into bs_formula_child_info
         <trim prefix="(" suffix=")" suffixOverrides=",">

--
Gitblit v1.9.3