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