From 8bcf258496e7c6cdaa3921acec4db1d4f77fe6f2 Mon Sep 17 00:00:00 2001
From: zhanghl <253316343@qq.com>
Date: 星期四, 24 四月 2025 13:34:59 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev' into dev

---
 aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml                    |   20 ++-
 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsProcessRoute.java                    |   58 ++++++---
 aps-modules/aps-core/src/main/resources/mapper/core/ApsBomMapper.xml                           |   30 ++++
 aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderProcess.java                  |   14 ++
 aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderProcessServiceImpl.java |    3 
 aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderProcessMapper.xml                |   22 ++-
 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsBom.java                             |   30 ++++
 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlatePlan.java                       |   15 ++
 aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderJob.java                      |   16 ++
 aps-modules/aps-core/src/main/resources/mapper/core/ApsProcessRouteMapper.xml                  |   11 +
 aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml                     |   11 +
 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlatePlanServiceImpl.java      |   30 ++--
 aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java     |   40 +++---
 aps-modules/aps-core/src/main/resources/mapper/core/ApsPartPlanMapper.xml                      |   12 +
 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPartPlan.java                        |   29 +++-
 15 files changed, 243 insertions(+), 98 deletions(-)

diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsBom.java b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsBom.java
index fe35cdc..6fe7a74 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsBom.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsBom.java
@@ -6,8 +6,8 @@
 import lombok.Data;
 import lombok.EqualsAndHashCode;
 
+import java.math.BigDecimal;
 import java.util.Date;
-import java.util.List;
 
 /**
  * BOM鏁版嵁绠$悊瀵硅薄 aps_bom
@@ -36,6 +36,34 @@
     @Excel(name = "鏂欏彿")
     private String itemCode;
 
+    /** 鍥惧彿 */
+    @Excel(name = "鍥惧彿")
+    private String drawingNo;
+
+    /** 搴忓彿 */
+    @Excel(name = "搴忓彿")
+    private String processNo;
+
+    /** 搴忓彿 */
+    @Excel(name = "鍗曚綅")
+    private String unit;
+
+    /** 鏁伴噺 */
+    @Excel(name = "鏁伴噺")
+    private BigDecimal num;
+
+    /** 鎬绘暟閲� */
+    @Excel(name = "鎬绘暟閲�")
+    private BigDecimal totalNum;
+
+    /** 鍑嗗宸ユ椂 */
+    @Excel(name = "鍑嗗宸ユ椂")
+    private BigDecimal preparationTime;
+
+    /** 鍔犲伐宸ユ椂 */
+    @Excel(name = "鍔犲伐宸ユ椂")
+    private BigDecimal processingTime;
+
     /** 鐗╂枡鎻忚堪 */
     @Excel(name = "鐗╂枡鎻忚堪")
     private String itemName;
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPartPlan.java b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPartPlan.java
index 2b1d185..2e30c2f 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPartPlan.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPartPlan.java
@@ -1,19 +1,13 @@
 package com.aps.core.domain;
 
-import java.math.BigDecimal;
-import java.util.Date;
-
-import com.aps.common.core.utils.uuid.IdUtils;
-import com.aps.common.core.utils.uuid.UUID;
+import com.aps.common.core.annotation.Excel;
+import com.aps.common.core.web.domain.BaseEntity;
 import com.fasterxml.jackson.annotation.JsonFormat;
 import org.apache.commons.lang3.builder.ToStringBuilder;
 import org.apache.commons.lang3.builder.ToStringStyle;
-import com.aps.common.core.annotation.Excel;
-import com.aps.common.core.web.domain.BaseEntity;
-import org.apache.poi.hpsf.Decimal;
-import org.springframework.data.annotation.Id;
 
-import javax.annotation.processing.Generated;
+import java.math.BigDecimal;
+import java.util.Date;
 
 /**
  * 闆朵欢璁″垝绠$悊瀵硅薄 aps_part_plan
@@ -166,6 +160,10 @@
     /** 椋庨櫓鏍囪瘑 */
     @Excel(name = "椋庨櫓鏍囪瘑")
     private Integer hasRisk;
+
+    /** 浣滀笟锛堝伐搴忓悕绉帮級 */
+    @Excel(name = "浣滀笟")
+    private String stdOp;
 
     /** 宸ュ巶 */
 //    @Excel(name = "宸ュ巶")
@@ -521,6 +519,14 @@
         return hasRisk;
     }
 
+    public void setStdOp(String stdOp) {
+        this.stdOp = stdOp;
+    }
+
+    public String getStdOp() {
+        return stdOp;
+    }
+
     @Override
     public String toString() {
         return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
@@ -559,7 +565,8 @@
             .append("isStockComplete", getIsStockComplete())
             .append("hasTurnback", getHasTurnback())
             .append("hasRisk", getHasRisk())
-                .append("plant", getPlant())
+            .append("plant", getPlant())
+            .append("stdOp", getStdOp())
             .toString();
     }
     public String getPlant() {
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlatePlan.java b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlatePlan.java
index 2aa1114..ed0efc9 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlatePlan.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlatePlan.java
@@ -162,6 +162,10 @@
     @Excel(name = "椋庨櫓鏍囪瘑")
     private Integer hasRisk;
 
+    /** 浣滀笟锛堝伐搴忓悕绉帮級 */
+    @Excel(name = "浣滀笟")
+    private String stdOp;
+
     /** 宸ュ巶 */
 //    @Excel(name = "宸ュ巶")
     private String plant;
@@ -516,6 +520,14 @@
         return hasRisk;
     }
 
+    public void setStdOp(String stdOp) {
+        this.stdOp = stdOp;
+    }
+
+    public String getStdOp() {
+        return stdOp;
+    }
+
     @Override
     public String toString() {
         return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
@@ -554,7 +566,8 @@
             .append("isStockComplete", getIsStockComplete())
             .append("hasTurnback", getHasTurnback())
             .append("hasRisk", getHasRisk())
-                .append("plant", getPlant())
+            .append("plant", getPlant())
+            .append("stdOp", getStdOp())
             .toString();
     }
     public String getPlant() {
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsProcessRoute.java b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsProcessRoute.java
index 1603e8b..b11a864 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsProcessRoute.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsProcessRoute.java
@@ -89,6 +89,9 @@
     /** 鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛� */
     private String delFlag;
 
+    /** 宸ヤ綔涓績 */
+    private String workCenter;
+
     public void setId(String id)
     {
         this.id = id;
@@ -209,28 +212,6 @@
         return delFlag;
     }
 
-    @Override
-    public String toString() {
-        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
-                .append("id", getId())
-                .append("itemNo", getItemNo())
-                .append("workOrderNo", getWorkOrderNo())
-                .append("processNumber", getProcessNumber())
-                .append("processName", getProcessName())
-                .append("processPlanStartDay", getProcessPlanStartDay())
-                .append("processPlanEndDay", getProcessPlanEndDay())
-                .append("notStartWorkCount", getNotStartWorkCount())
-                .append("completedCount", getCompletedCount())
-                .append("integrationDay", getIntegrationDay())
-                .append("plant", getPlant())
-                .append("delFlag", getDelFlag())
-                .append("createBy", getCreateBy())
-                .append("createTime", getCreateTime())
-                .append("updateBy", getUpdateBy())
-                .append("updateTime", getUpdateTime())
-                .toString();
-    }
-
     public BigDecimal getDiscardCount() {
         return discardCount;
     }
@@ -286,4 +267,37 @@
     public void setOrgCode(String orgCode) {
         this.orgCode = orgCode;
     }
+
+    public String getWorkCenter() {
+        return workCenter;
+    }
+
+    public void setWorkCenter(String workCenter) {
+        this.workCenter = workCenter;
+    }
+
+    @Override
+    public String toString() {
+        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
+                .append("id", getId())
+                .append("itemNo", getItemNo())
+                .append("workOrderNo", getWorkOrderNo())
+                .append("processNumber", getProcessNumber())
+                .append("processName", getProcessName())
+                .append("processPlanStartDay", getProcessPlanStartDay())
+                .append("processPlanEndDay", getProcessPlanEndDay())
+                .append("notStartWorkCount", getNotStartWorkCount())
+                .append("completedCount", getCompletedCount())
+                .append("integrationDay", getIntegrationDay())
+                .append("plant", getPlant())
+                .append("delFlag", getDelFlag())
+                .append("createBy", getCreateBy())
+                .append("createTime", getCreateTime())
+                .append("updateBy", getUpdateBy())
+                .append("updateTime", getUpdateTime())
+                .append("workCenter", getWorkCenter())
+                .toString();
+    }
+
+
 }
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlatePlanServiceImpl.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlatePlanServiceImpl.java
index eb57e76..73f92fb 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlatePlanServiceImpl.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlatePlanServiceImpl.java
@@ -1,33 +1,31 @@
 package com.aps.core.service.impl;
 
-import java.time.LocalDateTime;
-import java.util.List;
-import java.util.Optional;
-
-
 import com.aps.common.core.utils.DateUtils;
 import com.aps.common.core.utils.uuid.IdUtils;
 import com.aps.common.security.utils.DictUtils;
+import com.aps.core.domain.ApsPlatePlan;
 import com.aps.core.domain.ApsPlatePlanTemp;
 import com.aps.core.mapper.ApsPartPlanTempMapper;
+import com.aps.core.mapper.ApsPlatePlanMapper;
 import com.aps.core.mapper.ApsPlatePlanTempMapper;
+import com.aps.core.service.IApsPlatePlanService;
 import com.aps.system.api.domain.SysDictData;
 import org.apache.logging.log4j.util.Strings;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
-import com.aps.core.mapper.ApsPlatePlanMapper;
-import com.aps.core.domain.ApsPlatePlan;
-import com.aps.core.service.IApsPlatePlanService;
+
+import java.util.List;
+import java.util.Optional;
 
 /**
  * 閽i噾璁″垝绠$悊Service涓氬姟灞傚鐞�
- * 
+ *
  * @author ruoyi
  * @date 2025-04-08
  */
 @Service
-public class ApsPlatePlanServiceImpl implements IApsPlatePlanService 
+public class ApsPlatePlanServiceImpl implements IApsPlatePlanService
 {
     @Autowired
     private ApsPlatePlanMapper apsPlatePlanMapper;
@@ -39,7 +37,7 @@
 
     /**
      * 鏌ヨ閽i噾璁″垝绠$悊
-     * 
+     *
      * @param id 閽i噾璁″垝绠$悊涓婚敭
      * @return 閽i噾璁″垝绠$悊
      */
@@ -51,7 +49,7 @@
 
     /**
      * 鏌ヨ閽i噾璁″垝绠$悊鍒楄〃
-     * 
+     *
      * @param apsPlatePlan 閽i噾璁″垝绠$悊
      * @return 閽i噾璁″垝绠$悊
      */
@@ -63,7 +61,7 @@
 
     /**
      * 鏂板閽i噾璁″垝绠$悊
-     * 
+     *
      * @param apsPlatePlan 閽i噾璁″垝绠$悊
      * @return 缁撴灉
      */
@@ -77,7 +75,7 @@
 
     /**
      * 淇敼閽i噾璁″垝绠$悊
-     * 
+     *
      * @param apsPlatePlan 閽i噾璁″垝绠$悊
      * @return 缁撴灉
      */
@@ -89,7 +87,7 @@
 
     /**
      * 鎵归噺鍒犻櫎閽i噾璁″垝绠$悊
-     * 
+     *
      * @param ids 闇�瑕佸垹闄ょ殑閽i噾璁″垝绠$悊涓婚敭
      * @return 缁撴灉
      */
@@ -101,7 +99,7 @@
 
     /**
      * 鍒犻櫎閽i噾璁″垝绠$悊淇℃伅
-     * 
+     *
      * @param id 閽i噾璁″垝绠$悊涓婚敭
      * @return 缁撴灉
      */
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsBomMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsBomMapper.xml
index e669db1..c17395f 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsBomMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsBomMapper.xml
@@ -18,10 +18,17 @@
         <result property="createTime"    column="create_time"    />
         <result property="updateBy"    column="update_by"    />
         <result property="updateTime"    column="update_time"    />
+        <result property="drawingNo"    column="drawing_no"    />
+        <result property="processNo"    column="process_no"    />
+        <result property="unit"    column="unit"    />
+        <result property="num"    column="num"    />
+        <result property="totalNum"    column="total_num"    />
+        <result property="preparationTime"    column="preparation_time"    />
+        <result property="processingTime"    column="processing_time"    />
     </resultMap>
 
     <sql id="selectApsBomVo">
-        select id, bom_id, parent_bom_id, item_code, item_name, start_date, end_date, org_code, del_flag, create_by, create_time, update_by, update_time from aps_bom
+        select id, bom_id, parent_bom_id, item_code, item_name, start_date, end_date, org_code, del_flag, create_by, create_time, update_by, update_time, drawing_no, process_no, unit, num, total_num, preparation_time, processing_time from aps_bom
     </sql>
 
     <select id="selectApsBomList" parameterType="ApsBom" resultMap="ApsBomResult">
@@ -60,6 +67,13 @@
             <if test="createTime != null">create_time,</if>
             <if test="updateBy != null">update_by,</if>
             <if test="updateTime != null">update_time,</if>
+            <if test="drawingNo != null">drawing_no,</if>
+            <if test="processNo != null">process_no,</if>
+            <if test="unit != null">unit,</if>
+            <if test="num != null">num,</if>
+            <if test="totalNum != null">total_num,</if>
+            <if test="preparationTime != null">preparation_time,</if>
+            <if test="processingTime != null">processing_time,</if>
          </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="bomId != null">#{bomId},</if>
@@ -74,6 +88,13 @@
             <if test="createTime != null">#{createTime},</if>
             <if test="updateBy != null">#{updateBy},</if>
             <if test="updateTime != null">#{updateTime},</if>
+            <if test="drawingNo != null">#{drawingNo},</if>
+            <if test="processNo != null">#{processNo},</if>
+            <if test="unit != null">#{unit},</if>
+            <if test="num != null">#{num},</if>
+            <if test="totalNum != null">#{totalNum},</if>
+            <if test="preparationTime != null">#{preparationTime},</if>
+            <if test="processingTime != null">#{processingTime},</if>
          </trim>
     </insert>
 
@@ -92,6 +113,13 @@
             <if test="createTime != null">create_time = #{createTime},</if>
             <if test="updateBy != null">update_by = #{updateBy},</if>
             <if test="updateTime != null">update_time = #{updateTime},</if>
+            <if test="drawingNo != null">drawing_no = #{drawingNo},</if>
+            <if test="processNo != null">process_no = #{processNo},</if>
+            <if test="unit != null">unit = #{unit},</if>
+            <if test="num != null">num = #{num},</if>
+            <if test="totalNum != null">total_num = #{totalNum}</if>
+            <if test="preparationTime != null">preparation_time = #{preparationTime},</if>
+            <if test="processingTime != null">processing_time = #{processingTime},</if>
         </trim>
         where id = #{id}
     </update>
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPartPlanMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPartPlanMapper.xml
index 90bb069..b6f44c9 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPartPlanMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPartPlanMapper.xml
@@ -40,10 +40,11 @@
         <result property="isStockComplete"    column="is_stock_complete"    />
         <result property="hasTurnback"    column="has_turnback"    />
         <result property="hasRisk"    column="has_risk"    />
+        <result property="stdOp"    column="std_op"    />
     </resultMap>
 
     <sql id="selectApsPartPlanVo">
-        select id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk from aps_part_plan
+        select id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk, std_op from aps_part_plan
     </sql>
 
     <select id="selectApsPartPlanList" parameterType="com.aps.core.domain.ApsPartPlan" resultMap="ApsPartPlanResult">
@@ -82,6 +83,7 @@
             <if test="isStockComplete != null "> and is_stock_complete = #{isStockComplete}</if>
             <if test="hasTurnback != null "> and has_turnback = #{hasTurnback}</if>
             <if test="hasRisk != null "> and has_risk = #{hasRisk}</if>
+            <if test="stdOp != null "> and std_op = #{stdOp}</if>
              and del_flag='0'
         </where>
     </select>
@@ -129,6 +131,7 @@
             <if test="isStockComplete != null">is_stock_complete,</if>
             <if test="hasTurnback != null">has_turnback,</if>
             <if test="hasRisk != null">has_risk,</if>
+            <if test="stdOp != null">std_op,</if>
          </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="id != null and id != ''">#{id},</if>
@@ -166,6 +169,7 @@
             <if test="isStockComplete != null">#{isStockComplete},</if>
             <if test="hasTurnback != null">#{hasTurnback},</if>
             <if test="hasRisk != null">#{hasRisk},</if>
+            <if test="stdOp != null">#{stdOp},</if>
          </trim>
     </insert>
 
@@ -206,6 +210,7 @@
             <if test="isStockComplete != null">is_stock_complete = #{isStockComplete},</if>
             <if test="hasTurnback != null">has_turnback = #{hasTurnback},</if>
             <if test="hasRisk != null">has_risk = #{hasRisk},</if>
+            <if test="stdOp != null">std_op = #{stdOp},</if>
         </trim>
         where id = #{id}
     </update>
@@ -257,7 +262,8 @@
         is_stock_complete,
         has_turnback,
         has_risk,
-        plant
+        plant,
+        std_op
         ) values
         <foreach item="item" index="index" collection="list" separator=",">
             (#{item.id},#{item.masterPlanner},#{item.weekDay},#{item.weekCycle}
@@ -269,7 +275,7 @@
             ,#{item.standbyNumber},#{item.standbyName},#{item.standbyStock},#{item.nextProcessDeparment}
             ,#{item.isSuspended},#{item.isOutsourcing},#{item.account},#{item.advancedMaterials}
             ,#{item.advancedDocumentNumber},#{item.advancedRequirementDay},#{item.isPlanComplete}
-            ,#{item.isStockComplete},#{item.hasTurnback},#{item.hasRisk},#{item.plant})
+            ,#{item.isStockComplete},#{item.hasTurnback},#{item.hasRisk},#{item.plant}),#{item.stdOp})
         </foreach>
     </insert>
 
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml
index 6d758ea..275ea8b 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml
@@ -40,10 +40,11 @@
         <result property="isStockComplete"    column="is_stock_complete"    />
         <result property="hasTurnback"    column="has_turnback"    />
         <result property="hasRisk"    column="has_risk"    />
+        <result property="stdOp"    column="std_op"    />
     </resultMap>
 
     <sql id="selectApsPlatePlanVo">
-        select id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk from aps_plate_plan
+        select id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk, std_op from aps_plate_plan
     </sql>
 
     <select id="selectApsPlatePlanList" parameterType="ApsPlatePlan" resultMap="ApsPlatePlanResult">
@@ -84,6 +85,7 @@
             <if test="hasTurnback != null "> and has_turnback = #{hasTurnback}</if>
             <if test="hasRisk != null "> and has_risk = #{hasRisk}</if>
             <if test="plant != null "> and plant = #{plant}</if>
+            <if test="stdOp != null "> and std_op = #{stdOp}</if>
              and del_flag='0'
         </where>
     </select>
@@ -131,6 +133,7 @@
             <if test="isStockComplete != null">is_stock_complete,</if>
             <if test="hasTurnback != null">has_turnback,</if>
             <if test="hasRisk != null">has_risk,</if>
+            <if test="stdOp != null">std_op,</if>
             create_time,
          </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
@@ -169,6 +172,7 @@
             <if test="isStockComplete != null">#{isStockComplete},</if>
             <if test="hasTurnback != null">#{hasTurnback},</if>
             <if test="hasRisk != null">#{hasRisk},</if>
+            <if test="stdOp != null">#{stdOp},</if>
             #{createTime},
          </trim>
     </insert>
@@ -210,6 +214,7 @@
             <if test="isStockComplete != null">is_stock_complete = #{isStockComplete},</if>
             <if test="hasTurnback != null">has_turnback = #{hasTurnback},</if>
             <if test="hasRisk != null">has_risk = #{hasRisk},</if>
+            <if test="stdOp != null">std_op = #{stdOp},</if>
         </trim>
         where id = #{id}
     </update>
@@ -227,9 +232,9 @@
 
     <insert id="insertPlatePlanFromTempByBatchNumber" parameterType="String">
         insert into aps_plate_plan(
-            id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk)
+            id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk, std_op)
         SELECT
-            id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk
+            id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk, std_op
         from aps_plate_plan_temp
         where batch_number = #{batch_number}
     </insert>
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsProcessRouteMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsProcessRouteMapper.xml
index 0be0f68..b277710 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsProcessRouteMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsProcessRouteMapper.xml
@@ -24,10 +24,15 @@
         <result property="updateTime"    column="update_time"    />
         <result property="standardTime"    column="standard_time"    />
         <result property="processOrder"    column="process_order"    />
+        <result property="workCenter"    column="work_center"    />
+        <result property="processQty"    column="process_qty"    />
+        <result property="opStatus"    column="op_status"    />
+        <result property="opStatus"    column="op_status"    />
+        <result property="orgCode"    column="org_code"    />
     </resultMap>
 
     <sql id="selectApsProcessRouteVo">
-        select id, item_no, work_order_no, process_number, process_name, process_plan_start_day, process_plan_end_day, not_start_work_count, completed_count, discard_count, integration_day, plant, del_flag, create_by, create_time, update_by, update_time,standard_time,process_order from aps_process_route
+        select id, item_no, work_order_no, process_number, process_name, process_plan_start_day, process_plan_end_day, not_start_work_count, completed_count, discard_count, integration_day, plant, del_flag, create_by, create_time, update_by, update_time,standard_time,process_order,work_center from aps_process_route
     </sql>
 
     <select id="selectApsProcessRouteList" parameterType="ApsProcessRoute" resultMap="ApsProcessRouteResult">
@@ -45,6 +50,7 @@
             <if test="params.beginIntegrationDay != null and params.beginIntegrationDay != '' and params.endIntegrationDay != null and params.endIntegrationDay != ''"> and integration_day between #{params.beginIntegrationDay} and #{params.endIntegrationDay}</if>
 <!--            <if test="integrationDay != null "> and integration_day = #{integrationDay}</if>-->
             <if test="plant != null  and plant != ''"> and plant = #{plant}</if>
+            <if test="workCenter != null  and workCenter != ''"> and work_center = #{workCenter}</if>
         </where>
     </select>
 
@@ -73,6 +79,7 @@
             <if test="updateTime != null">update_time,</if>
             <if test="standardTime != null">standard_time,</if>
             <if test="processOrder != null">process_order,</if>
+            <if test="workCenter != null">work_center,</if>
         </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="id != null">#{id},</if>
@@ -94,6 +101,7 @@
             <if test="updateTime != null">#{updateTime},</if>
             <if test="standardTime != null">#{standardTime},</if>
             <if test="processOrder != null">#{processOrder},</if>
+            <if test="workCenter != null">#{workCenter},</if>
         </trim>
     </insert>
 
@@ -118,6 +126,7 @@
             <if test="updateTime != null">update_time = #{updateTime},</if>
             <if test="standardTime != null">standard_time = #{standardTime},</if>
             <if test="processOrder != null">process_order = #{processOrder},</if>
+            <if test="workCenter != null">work_center = #{workCenter},</if>
         </trim>
         where id = #{id}
     </update>
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderJob.java b/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderJob.java
index e4d09d2..17a9c4b 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderJob.java
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderJob.java
@@ -122,10 +122,9 @@
     @Excel(name = "鍒犻櫎鏍囧織", readConverterExp = "0=浠h〃瀛樺湪,2=浠h〃鍒犻櫎")
     private String delFlag;
 
-
-
-
-
+    /** 浣滀笟 */
+    @Excel(name = "浣滀笟")
+    private String stdOp;
 
     private String orgCode;
 
@@ -406,6 +405,14 @@
         this.orgCode = orgCode;
     }
 
+    public void setStdOp(String stdOp) {
+        this.stdOp = stdOp;
+    }
+
+    public String getStdOp() {
+        return stdOp;
+    }
+
     @Override
     public String toString() {
         return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
@@ -440,6 +447,7 @@
             .append("updateBy", getUpdateBy())
             .append("updateTime", getUpdateTime())
             .append("processStatus", getProcessStatus())
+            .append("stdOp", getStdOp())
             .toString();
     }
 }
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderProcess.java b/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderProcess.java
index 330ad8f..bf4573d 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderProcess.java
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderProcess.java
@@ -77,7 +77,10 @@
     @Excel(name = "璐﹀缂栫爜")
     private String orgCode;
 
-    public void setId(Long id) 
+    @Excel(name = "宸ヤ綔涓績")
+    private String workCenter;
+
+    public void setId(Long id)
     {
         this.id = id;
     }
@@ -217,6 +220,14 @@
         return orgCode;
     }
 
+    public String getWorkCenter() {
+        return workCenter;
+    }
+
+    public void setWorkCenter(String workCenter) {
+        this.workCenter = workCenter;
+    }
+
     @Override
     public String toString() {
         return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
@@ -234,6 +245,7 @@
             .append("opStatus", getOpStatus())
             .append("org", getOrg())
             .append("orgCode", getOrgCode())
+            .append("workCenter", getWorkCenter())
             .toString();
     }
 }
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java b/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java
index d94a318..6778319 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java
@@ -1,31 +1,31 @@
 package com.aps.job.service.impl;
 
+import com.alibaba.fastjson.JSONArray;
+import com.alibaba.fastjson.JSONObject;
+import com.aps.common.core.utils.DateUtils;
+import com.aps.job.domain.ApsWorkOrderJob;
+import com.aps.job.domain.ApsWorkOrderJobLog;
+import com.aps.job.mapper.ApsWorkOrderJobLogMapper;
+import com.aps.job.mapper.ApsWorkOrderJobMapper;
+import com.aps.job.param.ApsWorkOrderJobParam;
+import com.aps.job.service.IApsWorkOrderJobService;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.beans.factory.annotation.Value;
+import org.springframework.http.HttpEntity;
+import org.springframework.http.HttpHeaders;
+import org.springframework.http.MediaType;
+import org.springframework.http.ResponseEntity;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.client.RestTemplate;
+
 import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.time.format.DateTimeFormatter;
 import java.util.ArrayList;
 import java.util.Arrays;
 import java.util.List;
-
-import com.alibaba.fastjson.JSONArray;
-import com.alibaba.fastjson.JSONObject;
-import com.aps.common.core.utils.DateUtils;
-import com.aps.job.domain.ApsWorkOrderJobLog;
-import com.aps.job.mapper.ApsWorkOrderJobLogMapper;
-import com.aps.job.param.ApsWorkOrderJobParam;
-import lombok.extern.slf4j.Slf4j;
-import org.springframework.beans.factory.annotation.Value;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.http.HttpEntity;
-import org.springframework.http.HttpHeaders;
-import org.springframework.http.MediaType;
-import org.springframework.http.ResponseEntity;
-import org.springframework.stereotype.Service;
-import com.aps.job.mapper.ApsWorkOrderJobMapper;
-import com.aps.job.domain.ApsWorkOrderJob;
-import com.aps.job.service.IApsWorkOrderJobService;
-import org.springframework.transaction.annotation.Transactional;
-import org.springframework.web.client.RestTemplate;
 
 /**
  * 宸ュ崟鍚屾Service涓氬姟灞傚鐞�
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderProcessServiceImpl.java b/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderProcessServiceImpl.java
index a847e60..1a8a684 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderProcessServiceImpl.java
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderProcessServiceImpl.java
@@ -178,7 +178,7 @@
                             apsWorkOrderProcess.setDocNo(process.getString("DocNo"));
                             apsWorkOrderProcess.setOpNum(process.getString("OpNum"));
                             apsWorkOrderProcess.setOpId(process.getString("OpID"));
-                            apsWorkOrderProcess.setProcessName(process.getString("WorkCenter"));
+                            apsWorkOrderProcess.setProcessName(process.getString("StdOp"));
                             apsWorkOrderProcess.setStandardTime(process.getFloat("StandardTime"));
                             apsWorkOrderProcess.setPalnStartDate(process.getDate("PlanStartDate"));
                             apsWorkOrderProcess.setPlanCompleteDate(process.getDate("PlanCompleteDate"));
@@ -187,6 +187,7 @@
                             apsWorkOrderProcess.setOpStatus(process.getString("OpStatus"));
                             apsWorkOrderProcess.setOrg(process.getString("Org"));
                             apsWorkOrderProcess.setOrgCode(process.getString("OrgCode"));
+                            apsWorkOrderProcess.setWorkCenter(process.getString("WorkCenter"));
                             if (existsId != null) {
                                 apsWorkOrderProcess.setId(existsId);
                                 apsWorkOrderProcess.setUpdateTime(DateUtils.getNowDate());
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml
index a4ceb8c..eb2a7b7 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml
+++ b/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml
@@ -36,6 +36,7 @@
         <result property="updateBy"    column="update_by"    />
         <result property="updateTime"    column="update_time"    />
         <result property="processStatus"    column="process_status"    />
+        <result property="stdOp"    column="std_op"    />
 
     </resultMap>
 
@@ -43,7 +44,7 @@
         select id, order_id, doc_no, mainitem_code, mainitem_figure, customer_name, business_type, demand_type,
                doc_status, item_code, item_figure, item_figure_version, pruduct_qty, work_qty, op_num, work_center,
                dept, start_date, complete_date, next_dept, is_hold_release, is_out_source, org, page_num, page_index,
-               del_flag, create_by, create_time, update_by, update_time , process_status,org_code
+               del_flag, create_by, create_time, update_by, update_time , process_status,org_code, std_op
         from aps_work_order_job
     </sql>
 
@@ -119,6 +120,7 @@
             <if test="updateTime != null">update_time,</if>
             <if test="orgCode != null">org_code,</if>
             <if test="processStatus != null">process_status,</if>
+            <if test="stdOp != null">std_op,</if>
          </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="orderId != null">#{orderId},</if>
@@ -152,6 +154,7 @@
             <if test="updateTime != null">#{updateTime},</if>
             <if test="orgCode != null">#{orgCode},</if>
             <if test="processStatus != null">#{processStatus},</if>
+            <if test="stdOp != null">#{stdOp},</if>
          </trim>
     </insert>
 
@@ -189,6 +192,7 @@
             <if test="updateTime != null">update_time = #{updateTime},</if>
             <if test="orgCode != null"> org_code= #{orgCode},</if>
             <if test="processStatus != null"> process_status= #{processStatus},</if>
+            <if test="stdOp != null"> std_op= #{stdOp},</if>
         </trim>
         where id = #{id}
     </update>
@@ -237,7 +241,8 @@
             update_by,
             update_time,
             org_code,
-            process_status
+            process_status,
+            std_op,
         </trim>
         values
         <foreach collection="list" item="job" separator=",">
@@ -272,7 +277,8 @@
             #{job.updateBy},
             #{job.updateTime},
             #{job.orgCode},
-            #{job.processStatus}
+            #{job.processStatus},
+            #{job.stdOp},
             )
         </foreach>
     </insert>
@@ -305,7 +311,7 @@
             process_number,work_center,department,
             plan_start_day,plan_end_day,next_process_deparment,
             is_suspended,is_outsourcing,account,
-            id,create_time,del_flag,plant,order_status
+            id,create_time,del_flag,plant,order_status,std_op
         )
         select
             doc_no,mainitem_code,mainitem_figure,
@@ -315,7 +321,7 @@
             op_num,work_center,dept,
             start_date,complete_date,next_dept,
             is_hold_release,is_out_source,org_code,
-            order_id,now(),'0',org_code,doc_status
+            order_id,now(),'0',org_code,doc_status,std_op
         from aps_work_order_job
         where ( doc_status in (0,1,2,4) and
             (mainitem_code like 'M01%' or mainitem_code like 'M02%'or mainitem_code like 'M05%' or mainitem_code like 'M10%'
@@ -335,7 +341,7 @@
             process_number,work_center,department,
             plan_start_day,plan_end_day,next_process_deparment,
             is_suspended,is_outsourcing,account,
-            id,create_time,del_flag,plant,order_status
+            id,create_time,del_flag,plant,order_status,,std_op
         )
         select
             doc_no,mainitem_code,mainitem_figure,
@@ -345,7 +351,7 @@
             op_num,work_center,dept,
             start_date,complete_date,next_dept,
             is_hold_release,is_out_source,org_code,
-            order_id,now(),'0',org_code,doc_status
+            order_id,now(),'0',org_code,doc_status,,std_op
         from aps_work_order_job
         where ( doc_status in (0,1,2,4)
                 and (mainitem_code like 'M03%' or mainitem_code like 'M04%'or mainitem_code like 'A75%')
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderProcessMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderProcessMapper.xml
index 6aec5bd..eba3238 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderProcessMapper.xml
+++ b/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderProcessMapper.xml
@@ -19,10 +19,11 @@
         <result property="opStatus"    column="op_status"    />
         <result property="org"    column="org"    />
         <result property="org_code"    column="org_code"    />
+        <result property="work_center"    column="workCenter"    />
     </resultMap>
 
     <sql id="selectApsWorkOrderProcessVo">
-        select id, item_code, doc_no, op_num, op_id, process_name, standard_time, paln_start_date, plan_complete_date, process_qty, scrap_qty, op_status, org, org_code from aps_work_order_process
+        select id, item_code, doc_no, op_num, op_id, process_name, standard_time, paln_start_date, plan_complete_date, process_qty, scrap_qty, op_status, org, org_code, work_center from aps_work_order_process
     </sql>
 
     <select id="selectApsWorkOrderProcessList" parameterType="ApsWorkOrderProcess" resultMap="ApsWorkOrderProcessResult">
@@ -40,7 +41,8 @@
             <if test="scrapQty != null "> and scrap_qty = #{scrapQty}</if>
             <if test="opStatus != null  and opStatus != ''"> and op_status = #{opStatus}</if>
             <if test="org != null  and org != ''"> and org = #{org}</if>
-            <if test="org_code != null  and org_code != ''"> and org_code = #{orgCode}</if>
+            <if test="orgCode != null  and orgCode != ''"> and org_code = #{orgCode}</if>
+            <if test="workCenter != null  and workCenter != ''"> and work_center = #{workCenter}</if>
         </where>
     </select>
     
@@ -66,6 +68,7 @@
             <if test="opStatus != null">op_status,</if>
             <if test="org != null">org,</if>
             <if test="orgCode != null">org_code,</if>
+            <if test="workCenter != null">work_center,</if>
          </trim>
         <trim prefix="values (" suffix=")" suffixOverrides=",">
             <if test="id != null">#{id},</if>
@@ -82,6 +85,7 @@
             <if test="opStatus != null">#{opStatus},</if>
             <if test="org != null">#{org},</if>
             <if test="orgCode != null">#{orgCode},</if>
+            <if test="workCenter != null">#{work_center},</if>
          </trim>
     </insert>
 
@@ -101,6 +105,7 @@
             <if test="opStatus != null">op_status = #{opStatus},</if>
             <if test="org != null">org = #{org},</if>
             <if test="orgCode != null">org_code = #{orgCode},</if>
+            <if test="workCenter != null">work_center = #{workCenter},</if>
         </trim>
         where id = #{id}
     </update>
@@ -138,7 +143,8 @@
             scrap_qty = #{item.scrapQty},
             op_status = #{item.opStatus},
             org = #{item.org},
-            org_code = #{item.orgCode}
+            org_code = #{item.orgCode},
+            work_center = #{item.workCenter}
             WHERE id = #{item.id}
         </foreach>
     </update>
@@ -157,7 +163,8 @@
         scrap_qty,
         op_status,
         org,
-        org_code
+        org_code,
+        work_center
         ) VALUES
         <foreach collection="list" item="item" separator=",">
             (
@@ -174,6 +181,7 @@
             #{item.opStatus},
             #{item.org},
             #{item.orgCode}
+            #{item.workCenter}
             )
         </foreach>
     </insert>
@@ -194,7 +202,8 @@
             discard_count,
             op_status,
             plant,
-            org_code
+            org_code,
+            work_center
         )
         SELECT
             id,
@@ -210,7 +219,8 @@
             scrap_qty,
             op_status,
             org,
-            org_code
+            org_code,
+            work_center
         FROM aps_work_order_process
     </insert>
 

--
Gitblit v1.9.3