| | |
| | | import com.aps.common.core.utils.file.FileUtils; |
| | | import com.aps.common.core.web.domain.AjaxResult; |
| | | import com.aps.core.service.*; |
| | | import com.aps.core.service.ApsPlate.IApsPlatePlanService; |
| | | import com.aps.system.api.domain.SysFile; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/controller/mainPlan/ApsPlateOrderPlanManagerController.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.controller.mainPlan; |
| | | package com.aps.core.controller.mainPlan.ApsPlate; |
| | | |
| | | import com.aps.common.core.web.controller.BaseController; |
| | | import com.aps.common.core.web.domain.AjaxResult; |
| | | import com.aps.common.core.web.page.TableDataInfo; |
| | | import com.aps.common.security.annotation.RequiresPermissions; |
| | | import com.aps.core.domain.ApsPlateOrderPlanDate; |
| | | import com.aps.core.domain.ApsPlateOrderPlanManager; |
| | | import com.aps.core.domain.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.service.IApsPlateOrderPlanManagerService; |
| | | import com.aps.core.service.IApsPlateStandardRequireBomOrderDetailService; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateOrderPlanDate; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateOrderPlanManager; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | import com.aps.core.service.ApsPlate.IApsPlateOrderPlanManagerService; |
| | | import com.aps.core.service.ApsPlate.IApsPlateStandardRequireBomOrderDetailService; |
| | | import jakarta.annotation.Resource; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPlatePlanController.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.controller; |
| | | package com.aps.core.controller.mainPlan.ApsPlate; |
| | | |
| | | import com.aps.common.core.utils.poi.ExcelUtil; |
| | | import com.aps.common.core.web.controller.BaseController; |
| | |
| | | import com.aps.common.log.enums.BusinessType; |
| | | import com.aps.common.security.annotation.RequiresPermissions; |
| | | import com.aps.common.security.utils.DictUtils; |
| | | import com.aps.core.domain.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlatePlanTemp; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlanTemp; |
| | | import com.aps.core.domain.export.ApsPlatePlanExport; |
| | | import com.aps.core.service.IApsPlatePlanService; |
| | | import com.aps.core.service.IApsPlatePlanTempService; |
| | | import com.aps.core.service.ApsPlate.IApsPlatePlanService; |
| | | import com.aps.core.service.ApsPlate.IApsPlatePlanTempService; |
| | | import com.aps.system.api.domain.SysDictData; |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import org.springframework.beans.BeanUtils; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPlatePlanTempController.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.controller; |
| | | package com.aps.core.controller.mainPlan.ApsPlate; |
| | | |
| | | import java.util.List; |
| | | import java.io.IOException; |
| | | |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | |
| | | import com.aps.common.log.annotation.Log; |
| | | import com.aps.common.log.enums.BusinessType; |
| | | import com.aps.common.security.annotation.RequiresPermissions; |
| | | import com.aps.core.domain.ApsPlatePlanTemp; |
| | | import com.aps.core.service.IApsPlatePlanTempService; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlanTemp; |
| | | import com.aps.core.service.ApsPlate.IApsPlatePlanTempService; |
| | | import com.aps.common.core.web.controller.BaseController; |
| | | import com.aps.common.core.web.domain.AjaxResult; |
| | | import com.aps.common.core.utils.poi.ExcelUtil; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/controller/mainPlan/ApsPlateProcessShopStatController.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.controller.mainPlan; |
| | | package com.aps.core.controller.mainPlan.ApsPlate; |
| | | |
| | | import com.aps.common.core.utils.poi.ExcelUtil; |
| | | import com.aps.common.core.web.controller.BaseController; |
| | | import com.aps.common.core.web.domain.AjaxResult; |
| | | import com.aps.common.core.web.page.TableDataInfo; |
| | | import com.aps.common.log.annotation.Log; |
| | | import com.aps.common.log.enums.BusinessType; |
| | | import com.aps.common.security.annotation.RequiresPermissions; |
| | | import com.aps.core.domain.ApsPlateProcessShopStat; |
| | | import com.aps.core.service.IApsPlateProcessShopStatService; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateProcessShopStat; |
| | | import com.aps.core.service.ApsPlate.IApsPlateProcessShopStatService; |
| | | import io.swagger.v3.oas.annotations.Operation; |
| | | import io.swagger.v3.oas.annotations.tags.Tag; |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * é£é车é´ç»è®¡Controller |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/controller/mainPlan/ApsPlateProcessStatController.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.controller.mainPlan; |
| | | package com.aps.core.controller.mainPlan.ApsPlate; |
| | | |
| | | import java.util.List; |
| | | import java.io.IOException; |
| | | |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.PutMapping; |
| | | import org.springframework.web.bind.annotation.DeleteMapping; |
| | | import org.springframework.web.bind.annotation.PathVariable; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | |
| | | import com.aps.common.log.annotation.Log; |
| | | import com.aps.common.log.enums.BusinessType; |
| | | import com.aps.common.security.annotation.RequiresPermissions; |
| | | import com.aps.core.domain.ApsPlateProcessStat; |
| | | import com.aps.core.service.IApsPlateProcessStatService; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateProcessStat; |
| | | import com.aps.core.service.ApsPlate.IApsPlateProcessStatService; |
| | | import com.aps.common.core.web.controller.BaseController; |
| | | import com.aps.common.core.web.domain.AjaxResult; |
| | | import com.aps.common.core.utils.poi.ExcelUtil; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/controller/mainPlan/ApsPlateStandardRequireController.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.controller.mainPlan; |
| | | package com.aps.core.controller.mainPlan.ApsPlate; |
| | | |
| | | import com.aps.common.core.utils.poi.ExcelUtil; |
| | | import com.aps.common.core.web.controller.BaseController; |
| | |
| | | import com.aps.common.log.annotation.Log; |
| | | import com.aps.common.log.enums.BusinessType; |
| | | import com.aps.common.security.annotation.RequiresPermissions; |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | import com.aps.core.enums.PLAN_TASK_STATUS; |
| | | import com.aps.core.service.ApsPlanTaskService; |
| | | import com.aps.core.service.IApsPlateStandardRequireBatchService; |
| | | import com.aps.core.service.IApsPlateStandardRequireService; |
| | | import com.aps.core.service.ApsPlate.IApsPlateStandardRequireBatchService; |
| | | import com.aps.core.service.ApsPlate.IApsPlateStandardRequireService; |
| | | import jakarta.annotation.Resource; |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/controller/mainPlan/ApsPlateStandardRequireErrorController.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.controller.mainPlan; |
| | | package com.aps.core.controller.mainPlan.ApsPlate; |
| | | |
| | | import com.aps.common.core.utils.poi.ExcelUtil; |
| | | import com.aps.common.core.web.controller.BaseController; |
| | |
| | | import com.aps.common.log.annotation.Log; |
| | | import com.aps.common.log.enums.BusinessType; |
| | | import com.aps.common.security.annotation.RequiresPermissions; |
| | | import com.aps.core.domain.ApsPlateStandardRequireError; |
| | | import com.aps.core.service.IApsPlateStandardRequireErrorService; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireError; |
| | | import com.aps.core.service.ApsPlate.IApsPlateStandardRequireErrorService; |
| | | import io.swagger.v3.oas.annotations.Operation; |
| | | import io.swagger.v3.oas.annotations.tags.Tag; |
| | | import jakarta.servlet.http.HttpServletResponse; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateOrderPlanDate.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.web.domain.BaseEntity; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateOrderPlanManager.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.annotation.Excel; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateOrderPlanRequireDate.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.web.domain.BaseEntity; |
| | | import lombok.Data; |
| | | |
| | | import java.io.Serial; |
| | | import java.sql.Timestamp; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * é£éå·¥å计åéæ±æ¥æ |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlatePlan.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.annotation.Excel; |
| | | import com.aps.common.core.web.domain.BaseEntity; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlatePlanTemp.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.annotation.Excel; |
| | | import com.aps.common.core.web.domain.BaseEntity; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateProcessShopPlanStat.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.annotation.Excel; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateProcessShopStat.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import io.swagger.v3.oas.annotations.media.Schema; |
| | | import org.apache.commons.lang3.builder.ToStringBuilder; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateProcessStat.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.Date; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import lombok.Data; |
| | | 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; |
| | | |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateStandardRequire.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.annotation.Excel; |
| | | import com.aps.common.core.web.domain.BaseEntity; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateStandardRequireBatch.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.web.domain.BaseEntity; |
| | | import lombok.Builder; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateStandardRequireBomOrderDetail.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.annotation.Excel; |
| | | import com.aps.common.core.web.domain.BaseEntity; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateStandardRequireBomStockDetail.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.annotation.Excel; |
| | | import com.aps.common.core.web.domain.BaseEntity; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateStandardRequireError.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.annotation.Excel; |
| | | import com.aps.common.core.web.domain.BaseEntity; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateStandardRequireOrderEndDay.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.domain; |
| | | package com.aps.core.domain.ApsPlate; |
| | | |
| | | import com.aps.common.core.web.domain.BaseEntity; |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import com.aps.core.domain.ApsPlateOrderPlanDate; |
| | | import com.aps.core.domain.ApsPlateOrderPlanManager; |
| | | import com.aps.core.domain.ApsPlateOrderPlanRequireDate; |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateOrderPlanDate; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateOrderPlanManager; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateOrderPlanRequireDate; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.List; |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import com.alibaba.fastjson2.JSONObject; |
| | | import com.aps.core.domain.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.List; |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsPlatePlanTemp; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlanTemp; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsPlateProcessShopStat; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateProcessShopStat; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsPlateProcessStat; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateProcessStat; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsPlateStandardRequireBatch; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBatch; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import com.aps.core.domain.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomOrderDetail; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.List; |
| | |
| | | |
| | | import java.util.List; |
| | | |
| | | import com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail; |
| | | import com.aps.core.domain.ApsPlateStandardRequireBomStockDetail; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomStockDetail; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsPlateStandardRequireError; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireError; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.List; |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import com.aps.core.domain.ApsPlateStandardRequireOrderEndDay; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireOrderEndDay; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @author zhl |
| | | * @description é对表ãaps_plate_standard_require_order_end_day(éæ±è®¡åå®ææ¥æè¡¨)ãçæ°æ®åºæä½Mapper |
| | | * @createDate 2025-05-19 10:20:50 |
| | | * @Entity com.aps.core.domain.ApsPlateStandardRequireOrderEndDay |
| | | * @Entity com.aps.core.domain.ApsPlate.ApsPlateStandardRequireOrderEndDay |
| | | */ |
| | | public interface ApsPlateStandardRequireOrderEndDayMapper extends BaseMapper<ApsPlateStandardRequireOrderEndDay> { |
| | | |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateOrderPlanManagerService.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service; |
| | | package com.aps.core.service.ApsPlate; |
| | | |
| | | import com.aps.core.domain.ApsPlateOrderPlanDate; |
| | | import com.aps.core.domain.ApsPlateOrderPlanManager; |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateOrderPlanDate; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateOrderPlanManager; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | |
| | | import java.util.List; |
| | | |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlatePlanService.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service; |
| | | package com.aps.core.service.ApsPlate; |
| | | |
| | | import com.aps.core.domain.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlatePlanTemp; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlanTemp; |
| | | |
| | | import java.util.Hashtable; |
| | | import java.util.List; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlatePlanTempService.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service; |
| | | package com.aps.core.service.ApsPlate; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsPlatePlanTemp; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlanTemp; |
| | | |
| | | /** |
| | | * é£é计å临æ¶è¡¨Serviceæ¥å£ |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateProcessShopStatService.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service; |
| | | package com.aps.core.service.ApsPlate; |
| | | |
| | | import java.util.List; |
| | | |
| | | import com.aps.common.core.web.domain.AjaxResult; |
| | | import com.aps.core.domain.ApsPlateProcessShopStat; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateProcessShopStat; |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | |
| | | /** |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateProcessStatService.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service; |
| | | package com.aps.core.service.ApsPlate; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsPlateProcessStat; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateProcessStat; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | /** |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateStandardRequireBatchService.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service; |
| | | package com.aps.core.service.ApsPlate; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsPlateStandardRequireBatch; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBatch; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | /** |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateStandardRequireBomOrderDetailService.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service; |
| | | package com.aps.core.service.ApsPlate; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | | |
| | | import com.aps.core.domain.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomOrderDetail; |
| | | |
| | | /** |
| | | * ApsPlateStandardRequireBomOrderDetailServiceæ¥å£ |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateStandardRequireBomStockDetailService.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service; |
| | | package com.aps.core.service.ApsPlate; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | | |
| | | import com.aps.core.domain.ApsBom; |
| | | import com.aps.core.domain.ApsMaterialStorageManagement; |
| | | import com.aps.core.domain.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlateStandardRequireBomStockDetail; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomStockDetail; |
| | | |
| | | /** |
| | | * ApsPlateStandardRequireBomStockDetailServiceæ¥å£ |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateStandardRequireErrorService.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service; |
| | | package com.aps.core.service.ApsPlate; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsPlateStandardRequireError; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireError; |
| | | |
| | | /** |
| | | * é£éæ åéæ±å¼å¸¸ä¿¡æ¯Serviceæ¥å£ |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateStandardRequireService.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service; |
| | | package com.aps.core.service.ApsPlate; |
| | | |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | |
| | | import java.util.List; |
| | | |
| | |
| | | package com.aps.core.service; |
| | | |
| | | import com.aps.core.domain.ApsPlateStandardRequireOrderEndDay; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireOrderEndDay; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | |
| | | package com.aps.core.service; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | | |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsStandardProcessRouteLine; |
| | | |
| | | /** |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateOrderPlanManagerServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import com.aps.common.security.utils.SecurityUtils; |
| | | import com.aps.core.domain.ApsPlateOrderPlanDate; |
| | | import com.aps.core.domain.ApsPlateOrderPlanManager; |
| | | import com.aps.core.domain.ApsPlateOrderPlanRequireDate; |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateOrderPlanDate; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateOrderPlanManager; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateOrderPlanRequireDate; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | import com.aps.core.enums.PLAN_TASK_STATUS; |
| | | import com.aps.core.mapper.ApsPlateOrderPlanManagerMapper; |
| | | import com.aps.core.service.ApsPlanTaskService; |
| | | import com.aps.core.service.IApsPlateOrderPlanManagerService; |
| | | import com.aps.core.service.IApsPlateStandardRequireBatchService; |
| | | import com.aps.core.service.IApsPlateStandardRequireService; |
| | | import com.aps.core.service.ApsPlate.IApsPlateOrderPlanManagerService; |
| | | import com.aps.core.service.ApsPlate.IApsPlateStandardRequireBatchService; |
| | | import com.aps.core.service.ApsPlate.IApsPlateStandardRequireService; |
| | | import jakarta.annotation.Resource; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlatePlanServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import cn.hutool.core.util.IdUtil; |
| | | import com.alibaba.fastjson2.JSONArray; |
| | |
| | | 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.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.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.core.service.ApsPlate.IApsPlatePlanService; |
| | | import com.aps.system.api.domain.SysDictData; |
| | | import org.apache.logging.log4j.util.Strings; |
| | | import org.springframework.beans.BeanUtils; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlatePlanTempServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import java.util.List; |
| | | |
| | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.aps.core.mapper.ApsPlatePlanTempMapper; |
| | | import com.aps.core.domain.ApsPlatePlanTemp; |
| | | import com.aps.core.service.IApsPlatePlanTempService; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlanTemp; |
| | | import com.aps.core.service.ApsPlate.IApsPlatePlanTempService; |
| | | |
| | | /** |
| | | * é£é计å临æ¶è¡¨Serviceä¸å¡å±å¤ç |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateProcessShopStatServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.*; |
| | |
| | | import com.aps.common.security.utils.DictUtils; |
| | | import com.aps.common.security.utils.SecurityUtils; |
| | | import com.aps.core.domain.*; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateProcessShopPlanStat; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateProcessShopStat; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateProcessStat; |
| | | import com.aps.core.mapper.*; |
| | | import com.aps.system.api.domain.SysDictData; |
| | | import jakarta.annotation.Resource; |
| | |
| | | import org.apache.poi.xssf.streaming.SXSSFWorkbook; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.aps.core.service.IApsPlateProcessShopStatService; |
| | | import com.aps.core.service.ApsPlate.IApsPlateProcessShopStatService; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | /** |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateProcessStatServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.time.*; |
| | |
| | | |
| | | import com.aps.common.core.utils.uuid.IdUtils; |
| | | import com.aps.common.security.utils.SecurityUtils; |
| | | import org.apache.commons.lang3.SystemUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.aps.core.mapper.ApsPlateProcessStatMapper; |
| | | import com.aps.core.domain.ApsPlateProcessStat; |
| | | import com.aps.core.service.IApsPlateProcessStatService; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateProcessStat; |
| | | import com.aps.core.service.ApsPlate.IApsPlateProcessStatService; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import static java.util.stream.Collectors.groupingBy; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateStandardRequireBatchServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import java.util.List; |
| | | |
| | |
| | | import jakarta.annotation.Resource; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.aps.core.domain.ApsPlateStandardRequireBatch; |
| | | import com.aps.core.service.IApsPlateStandardRequireBatchService; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBatch; |
| | | import com.aps.core.service.ApsPlate.IApsPlateStandardRequireBatchService; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | /** |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateStandardRequireBomOrderDetailServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | |
| | | import cn.hutool.core.util.IdUtil; |
| | | import com.aps.common.core.utils.DateUtils; |
| | | import com.aps.common.security.utils.SecurityUtils; |
| | | import com.aps.core.domain.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | import com.aps.core.mapper.ApsPlatePlanMapper; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.aps.core.mapper.ApsPlateStandardRequireBomOrderDetailMapper; |
| | | import com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail; |
| | | import com.aps.core.service.IApsPlateStandardRequireBomOrderDetailService; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomOrderDetail; |
| | | import com.aps.core.service.ApsPlate.IApsPlateStandardRequireBomOrderDetailService; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | /** |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateStandardRequireBomStockDetailServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | |
| | | import com.aps.common.core.utils.DateUtils; |
| | | import com.aps.common.security.utils.SecurityUtils; |
| | | import com.aps.core.domain.*; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomStockDetail; |
| | | import com.aps.core.mapper.ApsMaterialStorageManagementMapper; |
| | | import jakarta.annotation.Resource; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.aps.core.mapper.ApsPlateStandardRequireBomStockDetailMapper; |
| | | import com.aps.core.service.IApsPlateStandardRequireBomStockDetailService; |
| | | import com.aps.core.service.ApsPlate.IApsPlateStandardRequireBomStockDetailService; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | /** |
| | |
| | | @Override |
| | | public void saveStorageAndDetail(ApsMaterialStorageManagement itemStorage, ApsPlatePlan plan, String bomLineId, |
| | | String itemCode, String batchNum, BigDecimal deductionAmount, |
| | | BigDecimal afterStockAmount,Long requireId |
| | | ,List<ApsPlateStandardRequireBomStockDetail> stockDetailsList){ |
| | | BigDecimal afterStockAmount, Long requireId |
| | | , List<ApsPlateStandardRequireBomStockDetail> stockDetailsList){ |
| | | |
| | | |
| | | //itemStorageMapper.updateMaterialStorageByVersion(itemStorage.getId(), afterStockAmount,itemStorage.getVersion()); |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateStandardRequireErrorServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import java.util.List; |
| | | import com.aps.common.core.utils.DateUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.aps.core.mapper.ApsPlateStandardRequireErrorMapper; |
| | | import com.aps.core.domain.ApsPlateStandardRequireError; |
| | | import com.aps.core.service.IApsPlateStandardRequireErrorService; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireError; |
| | | import com.aps.core.service.ApsPlate.IApsPlateStandardRequireErrorService; |
| | | |
| | | /** |
| | | * é£éæ åéæ±å¼å¸¸ä¿¡æ¯Serviceä¸å¡å±å¤ç |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateStandardRequireOrderEndDayServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.aps.core.domain.ApsPlateStandardRequireOrderEndDay; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireOrderEndDay; |
| | | import com.aps.core.service.ApsPlateStandardRequireOrderEndDayService; |
| | | import com.aps.core.mapper.ApsPlateStandardRequireOrderEndDayMapper; |
| | | import org.springframework.stereotype.Service; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateStandardRequireServiceImpl.java ÐÞ¸Ä |
| | |
| | | package com.aps.core.service.impl; |
| | | package com.aps.core.service.impl.ApsPlate; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.*; |
| | |
| | | import com.aps.common.security.utils.DictUtils; |
| | | import com.aps.common.security.utils.SecurityUtils; |
| | | import com.aps.core.domain.*; |
| | | import com.aps.core.domain.ApsPlate.ApsPlatePlan; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomOrderDetail; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomStockDetail; |
| | | import com.aps.core.mapper.*; |
| | | import com.aps.core.service.*; |
| | | import com.aps.core.service.ApsPlate.*; |
| | | import com.aps.system.api.domain.SysDictData; |
| | | import jakarta.annotation.Resource; |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | import com.aps.core.mapper.ApsPlateStandardRequireMapper; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.aps.core.service.IApsPlateStandardRequireService; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.List; |
| | |
| | | * 使ç¨åä»¶å·¥åå¹é
éæ±ä¸çåéæ± |
| | | * */ |
| | | |
| | | private void matchRequireAndSubPlan(ApsPlateStandardRequire require, List<ApsPlateStandardRequireBomOrderDetail> orderDetailsList,Hashtable<String, List<ApsPlatePlan>> subPlans) { |
| | | private void matchRequireAndSubPlan(ApsPlateStandardRequire require, List<ApsPlateStandardRequireBomOrderDetail> orderDetailsList, Hashtable<String, List<ApsPlatePlan>> subPlans) { |
| | | BigDecimal netRequirement = require.getNetRequirement(); |
| | | require.setMatchMode("å·¥åå¹é
"); |
| | | require.setMatchState("å·²å¹é
"); |
| | |
| | | import cn.hutool.core.util.IdUtil; |
| | | import com.aps.common.core.utils.DateUtils; |
| | | import com.aps.common.security.utils.SecurityUtils; |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlateStandardRequireError; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequire; |
| | | import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireError; |
| | | import com.aps.core.domain.ApsStandardProcessRouteHeader; |
| | | import com.aps.core.mapper.ApsPlateStandardRequireErrorMapper; |
| | | import com.aps.core.mapper.ApsStandardProcessRouteHeaderMapper; |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlatePlanMapper"> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlatePlan" id="ApsPlatePlanResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlatePlan" id="ApsPlatePlanResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="masterPlanner" column="master_planner" /> |
| | | <result property="weekDay" column="week_day" /> |
| | |
| | | from aps_plate_plan |
| | | </sql> |
| | | |
| | | <select id="selectApsPlatePlanList" parameterType="com.aps.core.domain.ApsPlatePlan" resultMap="ApsPlatePlanResult"> |
| | | <select id="selectApsPlatePlanList" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlan" resultMap="ApsPlatePlanResult"> |
| | | <include refid="selectApsPlatePlanVo"/> |
| | | <where> |
| | | <if test="masterPlanner != null and masterPlanner != ''"> and master_planner like '%'|| #{masterPlanner}|| '%'</if> |
| | |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsPlatePlan" parameterType="com.aps.core.domain.ApsPlatePlan"> |
| | | <insert id="insertApsPlatePlan" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlan"> |
| | | insert into aps_plate_plan |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null and id != ''">id,</if> |
| | |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsPlatePlan" parameterType="com.aps.core.domain.ApsPlatePlan"> |
| | | <update id="updateApsPlatePlan" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlan"> |
| | | update aps_plate_plan |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="masterPlanner != null">master_planner = #{masterPlanner},</if> |
| | |
| | | update aps_plate_plan set del_flag='1' where del_flag ='0' |
| | | </update> |
| | | |
| | | <select id="selectPlatePlanByPlantMajor" parameterType="com.aps.core.domain.ApsPlatePlan" resultMap="ApsPlatePlanResult"> |
| | | <select id="selectPlatePlanByPlantMajor" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlan" resultMap="ApsPlatePlanResult"> |
| | | select id,document_number,main_part_number,item_number,plant,professional_affiliation,production_quantity,require_id, |
| | | unmatched_quantity,version, production_base,plan_end_day,order_create_time,low_order_code |
| | | from aps_plate_plan |
| | |
| | | order by document_number asc,id asc |
| | | </select> |
| | | |
| | | <select id="selectUnMatchPlateSubPlan" parameterType="com.aps.core.domain.ApsPlatePlan" resultMap="ApsPlatePlanResult"> |
| | | <select id="selectUnMatchPlateSubPlan" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlan" resultMap="ApsPlatePlanResult"> |
| | | select id,document_number,main_part_number,item_number,plant,professional_affiliation,production_quantity, |
| | | unmatched_quantity,version |
| | | from aps_plate_plan |
| | |
| | | order by document_number asc,id asc |
| | | limit 1 |
| | | </select> |
| | | <select id="selectUnMatchPlateSubPlanList" parameterType="com.aps.core.domain.ApsPlatePlan" resultMap="ApsPlatePlanResult"> |
| | | <select id="selectUnMatchPlateSubPlanList" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlan" resultMap="ApsPlatePlanResult"> |
| | | select id,document_number,main_part_number,item_number,plant,professional_affiliation,production_quantity, |
| | | unmatched_quantity,version |
| | | from aps_plate_plan |
| | |
| | | order by document_number asc,id asc |
| | | </select> |
| | | |
| | | <update id="updatePlanUnMatchQtyByVersion" parameterType="com.aps.core.domain.ApsPlatePlan"> |
| | | <update id="updatePlanUnMatchQtyByVersion" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlan"> |
| | | update aps_plate_plan |
| | | set unmatched_quantity=#{unmatchedQuantity},version=version+1 |
| | | where id=#{id} and version=#{version} |
| | | </update> |
| | | <select id="selectPlateRedundantOrderList" parameterType="com.aps.core.domain.ApsPlatePlan" resultMap="ApsPlatePlanResult"> |
| | | <select id="selectPlateRedundantOrderList" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlan" resultMap="ApsPlatePlanResult"> |
| | | select document_number, item_number, production_quantity, unmatched_quantity, plant, production_base, plan_start_day, plan_end_day, order_create_time |
| | | from aps_plate_plan where unmatched_quantity>0 and professional_affiliation='sub' and del_flag='0' |
| | | <if test="documentNumber != null and documentNumber != ''"> |
| | |
| | | set unmatched_quantity=production_quantity, version=0,require_id=id |
| | | where del_flag='0' and professional_affiliation !='0' |
| | | </update> |
| | | <update id="updatePlanUnMatchQtyAndVersion" parameterType="com.aps.core.domain.ApsPlatePlan"> |
| | | <update id="updatePlanUnMatchQtyAndVersion" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlan"> |
| | | update aps_plate_plan |
| | | set unmatched_quantity=#{unmatchedQuantity},version=#{version},update_time=now() |
| | | where id=#{id} |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanOrderManagerMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlateOrderPlanManagerMapper"> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlateOrderPlanManager" id="ApsPlateOrderPlanManagerResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlateOrderPlanManager" id="ApsPlateOrderPlanManagerResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="requireId" column="require_id" /> |
| | | <result property="requireTrackId" column="require_track_id" /> |
| | |
| | | <result property="orderCreateTime" column="order_create_time" /> |
| | | </resultMap> |
| | | |
| | | <select id="selectApsPlanOrderManager" parameterType="com.aps.core.domain.ApsPlateOrderPlanManager" resultMap="ApsPlateOrderPlanManagerResult"> |
| | | <select id="selectApsPlanOrderManager" parameterType="com.aps.core.domain.ApsPlate.ApsPlateOrderPlanManager" resultMap="ApsPlateOrderPlanManagerResult"> |
| | | select |
| | | detail.require_id, |
| | | detail.require_track_id, |
| | |
| | | </select> |
| | | |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlateStandardRequire" id="ApsPlateStandardRequireResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlateStandardRequire" id="ApsPlateStandardRequireResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="requireTrackId" column="require_track_id" /> |
| | | <result property="bomLineId" column="bom_line_id" /> |
| | |
| | | <if test="workOrderNo != null and workOrderNo != ''"> and detail.doc_no = #{workOrderNo}</if> |
| | | </select> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlateOrderPlanRequireDate" id="selectPlanRequireIdsResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlateOrderPlanRequireDate" id="selectPlanRequireIdsResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="start" column="start_date" /> |
| | | <result property="end" column="end_date" /> |
| | |
| | | group by plan.id |
| | | </select> |
| | | |
| | | <update id="updatePlanDateByBatch" parameterType="com.aps.core.domain.ApsPlateOrderPlanRequireDate"> |
| | | <update id="updatePlanDateByBatch" parameterType="com.aps.core.domain.ApsPlate.ApsPlateOrderPlanRequireDate"> |
| | | update aps_plate_plan set |
| | | plan_start_day = #{start}, |
| | | plan_end_day = #{end}, |
| | |
| | | where id = #{id} |
| | | </update> |
| | | |
| | | <update id="updatePlanDateByCustom" parameterType="com.aps.core.domain.ApsPlateOrderPlanDate"> |
| | | <update id="updatePlanDateByCustom" parameterType="com.aps.core.domain.ApsPlate.ApsPlateOrderPlanDate"> |
| | | update aps_plate_plan set |
| | | plan_end_day = #{customDate}, |
| | | update_by = #{updateBy}, |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanTempMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlatePlanTempMapper"> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlatePlanTemp" id="ApsPlatePlanTempResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlatePlanTemp" id="ApsPlatePlanTempResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="masterPlanner" column="master_planner" /> |
| | | <result property="weekDay" column="week_day" /> |
| | |
| | | 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, batch_number from aps_plate_plan_temp |
| | | </sql> |
| | | |
| | | <select id="selectApsPlatePlanTempList" parameterType="com.aps.core.domain.ApsPlatePlanTemp" resultMap="ApsPlatePlanTempResult"> |
| | | <select id="selectApsPlatePlanTempList" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlanTemp" resultMap="ApsPlatePlanTempResult"> |
| | | <include refid="selectApsPlatePlanTempVo"/> |
| | | <where> |
| | | <if test="nextProcessDeparment != null and nextProcessDeparment != ''"> and next_process_deparment = #{nextProcessDeparment}</if> |
| | |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsPlatePlanTemp" parameterType="com.aps.core.domain.ApsPlatePlanTemp"> |
| | | <insert id="insertApsPlatePlanTemp" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlanTemp"> |
| | | insert into aps_plate_plan_temp |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null and id != ''">id,</if> |
| | |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsPlatePlanTemp" parameterType="com.aps.core.domain.ApsPlatePlanTemp"> |
| | | <update id="updateApsPlatePlanTemp" parameterType="com.aps.core.domain.ApsPlate.ApsPlatePlanTemp"> |
| | | update aps_plate_plan_temp |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="masterPlanner != null">master_planner = #{masterPlanner},</if> |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateProcessShopStatMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlateProcessShopStatMapper"> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlateProcessShopStat" id="ApsPlateProcessShopStatResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlateProcessShopStat" id="ApsPlateProcessShopStatResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="docNo" column="doc_no" /> |
| | | <result property="shopCode" column="shop_code" /> |
| | |
| | | from aps_plate_process_shop_stat |
| | | </sql> |
| | | |
| | | <select id="selectApsPlateProcessShopStatList" parameterType="com.aps.core.domain.ApsPlateProcessShopStat" resultMap="ApsPlateProcessShopStatResult"> |
| | | <select id="selectApsPlateProcessShopStatList" parameterType="com.aps.core.domain.ApsPlate.ApsPlateProcessShopStat" resultMap="ApsPlateProcessShopStatResult"> |
| | | <include refid="selectApsPlateProcessShopStatVo"/> |
| | | <where> |
| | | <if test="docNo != null and docNo != ''"> and doc_no = #{docNo}</if> |
| | |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsPlateProcessShopStat" parameterType="com.aps.core.domain.ApsPlateProcessShopStat" useGeneratedKeys="true" keyProperty="id"> |
| | | <insert id="insertApsPlateProcessShopStat" parameterType="com.aps.core.domain.ApsPlate.ApsPlateProcessShopStat" useGeneratedKeys="true" keyProperty="id"> |
| | | insert into aps_plate_process_shop_stat |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="docNo != null">doc_no,</if> |
| | |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsPlateProcessShopStat" parameterType="com.aps.core.domain.ApsPlateProcessShopStat"> |
| | | <update id="updateApsPlateProcessShopStat" parameterType="com.aps.core.domain.ApsPlate.ApsPlateProcessShopStat"> |
| | | update aps_plate_process_shop_stat |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="docNo != null">doc_no = #{docNo},</if> |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateProcessStatMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlateProcessStatMapper"> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlateProcessStat" id="ApsPlateProcessStatResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlateProcessStat" id="ApsPlateProcessStatResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="workOrderNo" column="work_order_no" /> |
| | | <result property="processName" column="process_name" /> |
| | |
| | | from aps_plate_process_stat |
| | | </sql> |
| | | |
| | | <select id="selectApsPlateProcessStatList" parameterType="com.aps.core.domain.ApsPlateProcessStat" resultMap="ApsPlateProcessStatResult"> |
| | | <select id="selectApsPlateProcessStatList" parameterType="com.aps.core.domain.ApsPlate.ApsPlateProcessStat" resultMap="ApsPlateProcessStatResult"> |
| | | <include refid="selectApsPlateProcessStatVo"/> |
| | | <where> |
| | | <if test="workOrderNo != null and workOrderNo != ''"> and work_order_no = #{workOrderNo}</if> |
| | |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsPlateProcessStat" parameterType="com.aps.core.domain.ApsPlateProcessStat"> |
| | | <insert id="insertApsPlateProcessStat" parameterType="com.aps.core.domain.ApsPlate.ApsPlateProcessStat"> |
| | | insert into aps_plate_process_stat |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsPlateProcessStat" parameterType="com.aps.core.domain.ApsPlateProcessStat"> |
| | | <update id="updateApsPlateProcessStat" parameterType="com.aps.core.domain.ApsPlate.ApsPlateProcessStat"> |
| | | update aps_plate_process_stat |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="workOrderNo != null">work_order_no = #{workOrderNo},</if> |
| | |
| | | delete from aps_plate_process_stat where batch_number != #{batchNumber} |
| | | </update> |
| | | |
| | | <insert id="batchInsertPlateStat" parameterType="com.aps.core.domain.ApsPlateProcessStat"> |
| | | <insert id="batchInsertPlateStat" parameterType="com.aps.core.domain.ApsPlate.ApsPlateProcessStat"> |
| | | insert into aps_plate_process_stat |
| | | ( |
| | | id, |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireBatchMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlateStandardRequireBatchMapper"> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlateStandardRequireBatch" id="ApsPlateStandardRequireBatchResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBatch" id="ApsPlateStandardRequireBatchResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="batchNumber" column="batch_number" /> |
| | | <result property="delFlag" column="del_flag" /> |
| | |
| | | select id, batch_number, del_flag, create_time, create_by, update_by, update_time from aps_plate_standard_require_batch |
| | | </sql> |
| | | |
| | | <select id="selectApsPlateStandardRequireBatchList" parameterType="com.aps.core.domain.ApsPlateStandardRequireBatch" resultMap="ApsPlateStandardRequireBatchResult"> |
| | | <select id="selectApsPlateStandardRequireBatchList" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBatch" resultMap="ApsPlateStandardRequireBatchResult"> |
| | | <include refid="selectApsPlateStandardRequireBatchVo"/> |
| | | <where> |
| | | <if test="batchNumber != null and batchNumber != ''"> and batch_number = #{batchNumber}</if> |
| | |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsPlateStandardRequireBatch" parameterType="com.aps.core.domain.ApsPlateStandardRequireBatch"> |
| | | <insert id="insertApsPlateStandardRequireBatch" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBatch"> |
| | | insert into aps_plate_standard_require_batch |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsPlateStandardRequireBatch" parameterType="com.aps.core.domain.ApsPlateStandardRequireBatch"> |
| | | <update id="updateApsPlateStandardRequireBatch" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBatch"> |
| | | update aps_plate_standard_require_batch |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="batchNumber != null">batch_number = #{batchNumber},</if> |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireBomOrderDetailMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlateStandardRequireBomOrderDetailMapper"> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail" id="ApsPlateStandardRequireBomOrderDetailResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomOrderDetail" id="ApsPlateStandardRequireBomOrderDetailResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="requireId" column="require_id" /> |
| | | <result property="requireTrackId" column="require_track_id" /> |
| | |
| | | from aps_plate_standard_require_bom_order_detail |
| | | </sql> |
| | | |
| | | <select id="selectApsPlateStandardRequireBomOrderDetailList" parameterType="com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail" resultMap="ApsPlateStandardRequireBomOrderDetailResult"> |
| | | <select id="selectApsPlateStandardRequireBomOrderDetailList" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomOrderDetail" resultMap="ApsPlateStandardRequireBomOrderDetailResult"> |
| | | <include refid="selectApsPlateStandardRequireBomOrderDetailVo"/> |
| | | <where> |
| | | <if test="requireId != null and requireId != ''"> and require_id = #{requireId}</if> |
| | |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsPlateStandardRequireBomOrderDetail" parameterType="com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail"> |
| | | <insert id="insertApsPlateStandardRequireBomOrderDetail" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomOrderDetail"> |
| | | insert into aps_plate_standard_require_bom_order_detail |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsPlateStandardRequireBomOrderDetail" parameterType="com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail"> |
| | | <update id="updateApsPlateStandardRequireBomOrderDetail" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomOrderDetail"> |
| | | update aps_plate_standard_require_bom_order_detail |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="requireId != null">require_id = #{requireId},</if> |
| | |
| | | update aps_plate_standard_require_bom_order_detail set del_flag = '1' where batch_number = #{batchNumber} |
| | | </update> |
| | | |
| | | <insert id="batchInsert" parameterType="com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail"> |
| | | <insert id="batchInsert" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomOrderDetail"> |
| | | insert into aps_plate_standard_require_bom_order_detail |
| | | (id, require_id,require_track_id, bom_line_id, bom_line_code, doc_no, |
| | | before_prod_amount, deduction_amount, after_prod_amount, |
| | |
| | | </insert> |
| | | |
| | | |
| | | <select id="selectRequireUpAndDownLevel" parameterType="Long" resultType="com.aps.core.domain.ApsPlatePlan"> |
| | | <select id="selectRequireUpAndDownLevel" parameterType="Long" resultType="com.aps.core.domain.ApsPlate.ApsPlatePlan"> |
| | | with bs as ( |
| | | select id, bom_header_code,bom_line_code, require_track_id |
| | | from aps_plate_standard_require |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireBomStockDetailMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlateStandardRequireBomStockDetailMapper"> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlateStandardRequireBomStockDetail" id="ApsPlateStandardRequireBomStockDetailResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomStockDetail" id="ApsPlateStandardRequireBomStockDetailResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="requireId" column="require_id" /> |
| | | <result property="requireTrackId" column="require_track_id" /> |
| | |
| | | from aps_plate_standard_require_bom_stock_detail |
| | | </sql> |
| | | |
| | | <select id="selectApsPlateStandardRequireBomStockDetailList" parameterType="com.aps.core.domain.ApsPlateStandardRequireBomStockDetail" resultMap="ApsPlateStandardRequireBomStockDetailResult"> |
| | | <select id="selectApsPlateStandardRequireBomStockDetailList" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomStockDetail" resultMap="ApsPlateStandardRequireBomStockDetailResult"> |
| | | <include refid="selectApsPlateStandardRequireBomStockDetailVo"/> |
| | | <where> |
| | | <if test="requireId != null and requireId != ''"> and require_id = #{requireId}</if> |
| | |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsPlateStandardRequireBomStockDetail" parameterType="com.aps.core.domain.ApsPlateStandardRequireBomStockDetail"> |
| | | <insert id="insertApsPlateStandardRequireBomStockDetail" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomStockDetail"> |
| | | insert into aps_plate_standard_require_bom_stock_detail |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsPlateStandardRequireBomStockDetail" parameterType="com.aps.core.domain.ApsPlateStandardRequireBomStockDetail"> |
| | | <update id="updateApsPlateStandardRequireBomStockDetail" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomStockDetail"> |
| | | update aps_plate_standard_require_bom_stock_detail |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="requireId != null">require_id = #{requireId},</if> |
| | |
| | | update aps_plate_standard_require_bom_stock_detail set del_flag = '1' where batch_number = #{batchNumber} |
| | | </update> |
| | | |
| | | <insert id="batchInsert" parameterType="com.aps.core.domain.ApsPlateStandardRequireBomStockDetail"> |
| | | <insert id="batchInsert" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomStockDetail"> |
| | | insert into aps_plate_standard_require_bom_stock_detail |
| | | (id,require_id, require_track_id, bom_line_id, bom_line_code, before_stock_amount, deduction_amount |
| | | , after_stock_amount, org_code, batch_number, del_flag, create_time, create_by) |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireErrorMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlateStandardRequireErrorMapper"> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlateStandardRequireError" id="ApsPlateStandardRequireErrorResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireError" id="ApsPlateStandardRequireErrorResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="batchNumber" column="batch_number" /> |
| | | <result property="requireId" column="require_id" /> |
| | |
| | | select id, batch_number, require_id, doc_num, item_num, org_code, message, del_flag, create_by, create_time, update_by, update_time from aps_plate_standard_require_error |
| | | </sql> |
| | | |
| | | <select id="selectApsPlateStandardRequireErrorList" parameterType="com.aps.core.domain.ApsPlateStandardRequireError" resultMap="ApsPlateStandardRequireErrorResult"> |
| | | <select id="selectApsPlateStandardRequireErrorList" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireError" resultMap="ApsPlateStandardRequireErrorResult"> |
| | | <include refid="selectApsPlateStandardRequireErrorVo"/> |
| | | <where> |
| | | <if test="batchNumber != null and batchNumber != ''"> and batch_number = #{batchNumber}</if> |
| | |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsPlateStandardRequireError" parameterType="com.aps.core.domain.ApsPlateStandardRequireError"> |
| | | <insert id="insertApsPlateStandardRequireError" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireError"> |
| | | insert into aps_plate_standard_require_error |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsPlateStandardRequireError" parameterType="com.aps.core.domain.ApsPlateStandardRequireError"> |
| | | <update id="updateApsPlateStandardRequireError" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireError"> |
| | | update aps_plate_standard_require_error |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="batchNumber != null">batch_number = #{batchNumber},</if> |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlateStandardRequireMapper"> |
| | | |
| | | <resultMap type="com.aps.core.domain.ApsPlateStandardRequire" id="ApsPlateStandardRequireResult"> |
| | | <resultMap type="com.aps.core.domain.ApsPlate.ApsPlateStandardRequire" id="ApsPlateStandardRequireResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="requireTrackId" column="require_track_id" /> |
| | | <result property="bomLineId" column="bom_line_id" /> |
| | |
| | | from aps_plate_standard_require |
| | | </sql> |
| | | |
| | | <select id="selectApsPlateStandardRequireList" parameterType="com.aps.core.domain.ApsPlateStandardRequire" resultMap="ApsPlateStandardRequireResult"> |
| | | <select id="selectApsPlateStandardRequireList" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequire" resultMap="ApsPlateStandardRequireResult"> |
| | | <include refid="selectApsPlateStandardRequireVo"/> |
| | | <where> |
| | | <if test="requireTrackId != null and requireTrackId != ''"> and require_track_id = #{requireTrackId}</if> |
| | |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsPlateStandardRequire" parameterType="com.aps.core.domain.ApsPlateStandardRequire"> |
| | | <insert id="insertApsPlateStandardRequire" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequire"> |
| | | insert into aps_plate_standard_require |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsPlateStandardRequire" parameterType="com.aps.core.domain.ApsPlateStandardRequire"> |
| | | <update id="updateApsPlateStandardRequire" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequire"> |
| | | update aps_plate_standard_require |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="requireTrackId != null">require_track_id = #{requireTrackId},</if> |
| | |
| | | </foreach> |
| | | </delete> |
| | | |
| | | <select id="selectPlateSupplyGapList" parameterType="com.aps.core.domain.ApsPlateStandardRequire" resultMap="ApsPlateStandardRequireResult"> |
| | | <select id="selectPlateSupplyGapList" parameterType="com.aps.core.domain.ApsPlate.ApsPlateStandardRequire" resultMap="ApsPlateStandardRequireResult"> |
| | | select id, require_track_id, bom_line_code, bom_line_level, |
| | | match_state, match_mode, unmatched_demand_amount, start_date, |
| | | complete_date, demand_date, org_code, production_base |
ÎļþÃû´Ó aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireOrderEndDayMapper.xml ÐÞ¸Ä |
| | |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.aps.core.mapper.ApsPlateStandardRequireOrderEndDayMapper"> |
| | | |
| | | <resultMap id="BaseResultMap" type="com.aps.core.domain.ApsPlateStandardRequireOrderEndDay"> |
| | | <resultMap id="BaseResultMap" type="com.aps.core.domain.ApsPlate.ApsPlateStandardRequireOrderEndDay"> |
| | | <id property="id" column="id" /> |
| | | <result property="bomOrderId" column="bom_order_id" /> |
| | | <result property="requireId" column="require_id" /> |