From 5ba99b525e1d351f6a99e40dab27838450dae338 Mon Sep 17 00:00:00 2001
From: huangjiayang <5265313@qq.com>
Date: 星期四, 24 四月 2025 11:00:12 +0800
Subject: [PATCH] 【UPDATE】1.修改工单实体新增“作业（工序名称）”属性 2.修改工序实体新增“工作中心”属性 3.修改对应零件和钣金实体 4.修改mapping.xml字段
---
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-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/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 +++--
13 files changed, 185 insertions(+), 96 deletions(-)
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浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛� */
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;
/**
* 閽ｉ噾璁″垝绠＄悊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 @@
/**
* 鏌ヨ閽ｉ噾璁″垝绠＄悊
- *
+ *
* @param id 閽ｉ噾璁″垝绠＄悊涓婚敭
* @return 閽ｉ噾璁″垝绠＄悊
*/
@@ -51,7 +49,7 @@
/**
* 鏌ヨ閽ｉ噾璁″垝绠＄悊鍒楄〃
- *
+ *
* @param apsPlatePlan 閽ｉ噾璁″垝绠＄悊
* @return 閽ｉ噾璁″垝绠＄悊
*/
@@ -63,7 +61,7 @@
/**
* 鏂板閽ｉ噾璁″垝绠＄悊
- *
+ *
* @param apsPlatePlan 閽ｉ噾璁″垝绠＄悊
* @return 缁撴灉
*/
@@ -77,7 +75,7 @@
/**
* 淇敼閽ｉ噾璁″垝绠＄悊
- *
+ *
* @param apsPlatePlan 閽ｉ噾璁″垝绠＄悊
* @return 缁撴灉
*/
@@ -89,7 +87,7 @@
/**
* 鎵归噺鍒犻櫎閽ｉ噾璁″垝绠＄悊
- *
+ *
* @param ids 闇�瑕佸垹闄ょ殑閽ｉ噾璁″垝绠＄悊涓婚敭
* @return 缁撴灉
*/
@@ -101,7 +99,7 @@
/**
* 鍒犻櫎閽ｉ噾璁″垝绠＄悊淇℃伅
- *
+ *
* @param id 閽ｉ噾璁″垝绠＄悊涓婚敭
* @return 缁撴灉
*/
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=浠ｈ〃瀛樺湪,2=浠ｈ〃鍒犻櫎")
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