钣金计划上传临时表

bluejay

2025-04-08 0f1e2f546847cdc5259f167e90bbff5de781d7a0

钣金计划上传临时表

 aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPlatePlanController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,128 @@
package com.aps.core.controller;

import java.util.List;
import java.io.IOException;

import com.aps.common.core.domain.R;
import com.aps.common.core.utils.file.FileUtils;
import com.aps.system.api.domain.SysFile;
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 org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
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.ApsPlatePlan;
import  com.aps.core.service.IApsPlatePlanService;
import com.aps.common.core.web.controller.BaseController;
import com.aps.common.core.web.domain.AjaxResult;
import com.aps.common.core.utils.poi.ExcelUtil;
import com.aps.common.core.web.page.TableDataInfo;
import org.springframework.web.multipart.MultipartFile;

/**
 * é’£é‡‘计划管理Controller
 * 
 * @author ruoyi
 * @date 2025-04-08
 */
@RestController
@RequestMapping("/ApsPlatePlan")
public class ApsPlatePlanController extends BaseController
{
    @Autowired
    private IApsPlatePlanService apsPlatePlanService;

    /**
     * æŸ¥è¯¢é’£é‡‘计划管理列表
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:list")
    @GetMapping("/list")
    public TableDataInfo list(ApsPlatePlan apsPlatePlan)
    {
        startPage();
        List<ApsPlatePlan> list = apsPlatePlanService.selectApsPlatePlanList(apsPlatePlan);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºé’£é‡‘计划管理列表
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:export")
    @Log(title = "钣金计划管理", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ApsPlatePlan apsPlatePlan)
    {
        List<ApsPlatePlan> list = apsPlatePlanService.selectApsPlatePlanList(apsPlatePlan);
        ExcelUtil<ApsPlatePlan> util = new ExcelUtil<ApsPlatePlan>(ApsPlatePlan.class);
        util.exportExcel(response, list, "钣金计划管理数据");
    }

    /**
     * èŽ·å–钣金计划管理详细信息
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:query")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") String id)
    {
        return success(apsPlatePlanService.selectApsPlatePlanById(id));
    }

    /**
     * æ–°å¢žé’£é‡‘计划管理
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:add")
    @Log(title = "钣金计划管理", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ApsPlatePlan apsPlatePlan)
    {
        return toAjax(apsPlatePlanService.insertApsPlatePlan(apsPlatePlan));
    }

    /**
     * ä¿®æ”¹é’£é‡‘计划管理
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:edit")
    @Log(title = "钣金计划管理", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ApsPlatePlan apsPlatePlan)
    {
        return toAjax(apsPlatePlanService.updateApsPlatePlan(apsPlatePlan));
    }

    /**
     * åˆ é™¤é’£é‡‘计划管理
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:remove")
    @Log(title = "钣金计划管理", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable String[] ids)
    {
        return toAjax(apsPlatePlanService.deleteApsPlatePlanByIds(ids));
    }

    @PostMapping("/upload")
    public AjaxResult upload(MultipartFile file)
    {
        try
        {
            // ä¸Šä¼ å¹¶è¿”回访问地址
            ExcelUtil<ApsPlatePlan> util = new ExcelUtil<ApsPlatePlan>(ApsPlatePlan.class);
            List<ApsPlatePlan> userList = util.importExcel(file.getInputStream());
            System.out.println(userList.size());

        }
        catch (Exception e)
        {

        }
        return toAjax(true);
    }
}

 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlatePlan.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,553 @@
package com.aps.core.domain;

import java.util.Date;
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;

/**
 * é’£é‡‘计划管理对象 aps_plate_plan
 * 
 * @author ruoyi
 * @date 2025-04-08
 */
public class ApsPlatePlan extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”®id */
    private String id;

    /** ä¸»è®¡åˆ’员 */
    @Excel(name = "主计划员")
    private String masterPlanner;

    /** å‘¨æ—¥ */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "周日", width = 30, dateFormat = "yyyy-MM-dd")
    private Date weekDay;

    /** å‘¨åº¦ */
    @Excel(name = "周度")
    private String weekCycle;

    /** ä¸»ä»¶æ–™å· */
    @Excel(name = "主件料号")
    private String mainPartNumber;

    /** ä¸»ä»¶å›¾å· */
    @Excel(name = "主件图号")
    private String mainPartDrawingNumber;

    /** å®¢æˆ·åç§° */
    @Excel(name = "客户名称")
    private String customer;

    /** ä¸šåŠ¡ç±»åž‹ */
    @Excel(name = "业务类型")
    private String businessType;

    /** å•æ®å· */
    @Excel(name = "单据号")
    private String documentNumber;

    /** éœ€æ±‚分类 */
    @Excel(name = "需求分类")
    private String requirementType;

    /** å•æ®çŠ¶æ€ */
    @Excel(name = "单据状态")
    private String documentStatus;

    /** æ–™å· */
    @Excel(name = "料号")
    private String itemNumber;

    /** å›¾å· */
    @Excel(name = "图号")
    private String drawingNo;

    /** ç‰ˆæœ¬å· */
    @Excel(name = "版本号")
    private String versionNumber;

    /** ç”Ÿäº§æ•°é‡ */
    @Excel(name = "生产数量")
    private Integer productionQuantity;

    /** è‰¯å“æ•°é‡ */
    @Excel(name = "良品数量")
    private Integer goodProductsQuantity;

    /** å·¥åºå· */
    @Excel(name = "工序号")
    private String processNumber;

    /** å·¥ä½œä¸­å¿ƒ */
    @Excel(name = "工作中心")
    private String workCenter;

    /** æ‰€å±žéƒ¨é—¨ */
    @Excel(name = "所属部门")
    private String department;

    /** è®¡åˆ’开工日 */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "计划开工日", width = 30, dateFormat = "yyyy-MM-dd")
    private Date planStartDay;

    /** è®¡åˆ’完工日 */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "计划完工日", width = 30, dateFormat = "yyyy-MM-dd")
    private Date planEndDay;

    /** å¤‡æ–™æ–™å· */
    @Excel(name = "备料料号")
    private String standbyNumber;

    /** å¤‡æ–™åç§° */
    @Excel(name = "备料名称")
    private String standbyName;

    /** å¤‡æ–™åº“å­˜ */
    @Excel(name = "备料库存")
    private Integer standbyStock;

    /** ä¸‹é“工序所属部门 */
    @Excel(name = "下道工序所属部门")
    private String nextProcessDeparment;

    /** æ˜¯å¦æŒ‚èµ· */
    @Excel(name = "是否挂起")
    private Boolean isSuspended;

    /** å¤–协标识 */
    @Excel(name = "外协标识")
    private String isOutsourcing;

    /** è´¦å¥— */
    @Excel(name = "账套")
    private String account;

    /** ä¸Šé˜¶ç‰©æ–™ */
    @Excel(name = "上阶物料")
    private String advancedMaterials;

    /** ä¸Šé˜¶å•æ®å· */
    @Excel(name = "上阶单据号")
    private String advancedDocumentNumber;

    /** ä¸Šé˜¶éœ€æ±‚日期 */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "上阶需求日期", width = 30, dateFormat = "yyyy-MM-dd")
    private Date advancedRequirementDay;

    /** è®¡åˆ’齐套 */
    @Excel(name = "计划齐套")
    private Boolean isPlanComplete;

    /** åº“存齐套 */
    @Excel(name = "库存齐套")
    private Boolean isStockComplete;

    /** æ˜¯å¦æœ‰æŠ˜è¿”工序 */
    @Excel(name = "是否有折返工序")
    private Boolean hasTurnback;

    /** é£Žé™©æ ‡è¯† */
    @Excel(name = "风险标识")
    private Boolean hasRisk;

    public void setId(String id) 
    {
        this.id = id;
    }

    public String getId() 
    {
        return id;
    }

    public void setMasterPlanner(String masterPlanner) 
    {
        this.masterPlanner = masterPlanner;
    }

    public String getMasterPlanner() 
    {
        return masterPlanner;
    }

    public void setWeekDay(Date weekDay) 
    {
        this.weekDay = weekDay;
    }

    public Date getWeekDay() 
    {
        return weekDay;
    }

    public void setWeekCycle(String weekCycle) 
    {
        this.weekCycle = weekCycle;
    }

    public String getWeekCycle() 
    {
        return weekCycle;
    }

    public void setMainPartNumber(String mainPartNumber) 
    {
        this.mainPartNumber = mainPartNumber;
    }

    public String getMainPartNumber() 
    {
        return mainPartNumber;
    }

    public void setMainPartDrawingNumber(String mainPartDrawingNumber) 
    {
        this.mainPartDrawingNumber = mainPartDrawingNumber;
    }

    public String getMainPartDrawingNumber() 
    {
        return mainPartDrawingNumber;
    }

    public void setCustomer(String customer) 
    {
        this.customer = customer;
    }

    public String getCustomer() 
    {
        return customer;
    }

    public void setBusinessType(String businessType) 
    {
        this.businessType = businessType;
    }

    public String getBusinessType() 
    {
        return businessType;
    }

    public void setDocumentNumber(String documentNumber) 
    {
        this.documentNumber = documentNumber;
    }

    public String getDocumentNumber() 
    {
        return documentNumber;
    }

    public void setRequirementType(String requirementType) 
    {
        this.requirementType = requirementType;
    }

    public String getRequirementType() 
    {
        return requirementType;
    }

    public void setDocumentStatus(String documentStatus) 
    {
        this.documentStatus = documentStatus;
    }

    public String getDocumentStatus() 
    {
        return documentStatus;
    }

    public void setItemNumber(String itemNumber) 
    {
        this.itemNumber = itemNumber;
    }

    public String getItemNumber() 
    {
        return itemNumber;
    }

    public void setDrawingNo(String drawingNo) 
    {
        this.drawingNo = drawingNo;
    }

    public String getDrawingNo() 
    {
        return drawingNo;
    }

    public void setVersionNumber(String versionNumber) 
    {
        this.versionNumber = versionNumber;
    }

    public String getVersionNumber() 
    {
        return versionNumber;
    }

    public void setProductionQuantity(Integer productionQuantity) 
    {
        this.productionQuantity = productionQuantity;
    }

    public Integer getProductionQuantity() 
    {
        return productionQuantity;
    }

    public void setGoodProductsQuantity(Integer goodProductsQuantity) 
    {
        this.goodProductsQuantity = goodProductsQuantity;
    }

    public Integer getGoodProductsQuantity() 
    {
        return goodProductsQuantity;
    }

    public void setProcessNumber(String processNumber) 
    {
        this.processNumber = processNumber;
    }

    public String getProcessNumber() 
    {
        return processNumber;
    }

    public void setWorkCenter(String workCenter) 
    {
        this.workCenter = workCenter;
    }

    public String getWorkCenter() 
    {
        return workCenter;
    }

    public void setDepartment(String department) 
    {
        this.department = department;
    }

    public String getDepartment() 
    {
        return department;
    }

    public void setPlanStartDay(Date planStartDay) 
    {
        this.planStartDay = planStartDay;
    }

    public Date getPlanStartDay() 
    {
        return planStartDay;
    }

    public void setPlanEndDay(Date planEndDay) 
    {
        this.planEndDay = planEndDay;
    }

    public Date getPlanEndDay() 
    {
        return planEndDay;
    }

    public void setStandbyNumber(String standbyNumber) 
    {
        this.standbyNumber = standbyNumber;
    }

    public String getStandbyNumber() 
    {
        return standbyNumber;
    }

    public void setStandbyName(String standbyName) 
    {
        this.standbyName = standbyName;
    }

    public String getStandbyName() 
    {
        return standbyName;
    }

    public void setStandbyStock(Integer standbyStock) 
    {
        this.standbyStock = standbyStock;
    }

    public Integer getStandbyStock() 
    {
        return standbyStock;
    }

    public void setNextProcessDeparment(String nextProcessDeparment) 
    {
        this.nextProcessDeparment = nextProcessDeparment;
    }

    public String getNextProcessDeparment() 
    {
        return nextProcessDeparment;
    }

    public void setIsSuspended(Boolean isSuspended) 
    {
        this.isSuspended = isSuspended;
    }

    public Boolean getIsSuspended() 
    {
        return isSuspended;
    }

    public void setIsOutsourcing(String isOutsourcing) 
    {
        this.isOutsourcing = isOutsourcing;
    }

    public String getIsOutsourcing() 
    {
        return isOutsourcing;
    }

    public void setAccount(String account) 
    {
        this.account = account;
    }

    public String getAccount() 
    {
        return account;
    }

    public void setAdvancedMaterials(String advancedMaterials) 
    {
        this.advancedMaterials = advancedMaterials;
    }

    public String getAdvancedMaterials() 
    {
        return advancedMaterials;
    }

    public void setAdvancedDocumentNumber(String advancedDocumentNumber) 
    {
        this.advancedDocumentNumber = advancedDocumentNumber;
    }

    public String getAdvancedDocumentNumber() 
    {
        return advancedDocumentNumber;
    }

    public void setAdvancedRequirementDay(Date advancedRequirementDay) 
    {
        this.advancedRequirementDay = advancedRequirementDay;
    }

    public Date getAdvancedRequirementDay() 
    {
        return advancedRequirementDay;
    }

    public void setIsPlanComplete(Boolean isPlanComplete) 
    {
        this.isPlanComplete = isPlanComplete;
    }

    public Boolean getIsPlanComplete() 
    {
        return isPlanComplete;
    }

    public void setIsStockComplete(Boolean isStockComplete) 
    {
        this.isStockComplete = isStockComplete;
    }

    public Boolean getIsStockComplete() 
    {
        return isStockComplete;
    }

    public void setHasTurnback(Boolean hasTurnback) 
    {
        this.hasTurnback = hasTurnback;
    }

    public Boolean getHasTurnback() 
    {
        return hasTurnback;
    }

    public void setHasRisk(Boolean hasRisk) 
    {
        this.hasRisk = hasRisk;
    }

    public Boolean getHasRisk() 
    {
        return hasRisk;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("masterPlanner", getMasterPlanner())
            .append("weekDay", getWeekDay())
            .append("weekCycle", getWeekCycle())
            .append("mainPartNumber", getMainPartNumber())
            .append("mainPartDrawingNumber", getMainPartDrawingNumber())
            .append("customer", getCustomer())
            .append("businessType", getBusinessType())
            .append("documentNumber", getDocumentNumber())
            .append("requirementType", getRequirementType())
            .append("documentStatus", getDocumentStatus())
            .append("itemNumber", getItemNumber())
            .append("drawingNo", getDrawingNo())
            .append("versionNumber", getVersionNumber())
            .append("productionQuantity", getProductionQuantity())
            .append("goodProductsQuantity", getGoodProductsQuantity())
            .append("processNumber", getProcessNumber())
            .append("workCenter", getWorkCenter())
            .append("department", getDepartment())
            .append("planStartDay", getPlanStartDay())
            .append("planEndDay", getPlanEndDay())
            .append("standbyNumber", getStandbyNumber())
            .append("standbyName", getStandbyName())
            .append("standbyStock", getStandbyStock())
            .append("nextProcessDeparment", getNextProcessDeparment())
            .append("isSuspended", getIsSuspended())
            .append("isOutsourcing", getIsOutsourcing())
            .append("account", getAccount())
            .append("advancedMaterials", getAdvancedMaterials())
            .append("advancedDocumentNumber", getAdvancedDocumentNumber())
            .append("advancedRequirementDay", getAdvancedRequirementDay())
            .append("isPlanComplete", getIsPlanComplete())
            .append("isStockComplete", getIsStockComplete())
            .append("hasTurnback", getHasTurnback())
            .append("hasRisk", getHasRisk())
            .toString();
    }
}

 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlatePlanTemp.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,568 @@
package com.aps.core.domain;

import java.util.Date;
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;

/**
 * é’£é‡‘计划临时表对象 aps_plate_plan_temp
 * 
 * @author ruoyi
 * @date 2025-04-08
 */
public class ApsPlatePlanTemp extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”®id */
    private String id;

    /** ä¸»è®¡åˆ’员 */
    @Excel(name = "主计划员")
    private String masterPlanner;

    /** å‘¨æ—¥ */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "周日", width = 30, dateFormat = "yyyy-MM-dd")
    private Date weekDay;

    /** å‘¨åº¦ */
    @Excel(name = "周度")
    private String weekCycle;

    /** ä¸»ä»¶æ–™å· */
    @Excel(name = "主件料号")
    private String mainPartNumber;

    /** ä¸»ä»¶å›¾å· */
    @Excel(name = "主件图号")
    private String mainPartDrawingNumber;

    /** å®¢æˆ·åç§° */
    @Excel(name = "客户名称")
    private String customer;

    /** ä¸šåŠ¡ç±»åž‹ */
    @Excel(name = "业务类型")
    private String businessType;

    /** å•æ®å· */
    @Excel(name = "单据号")
    private String documentNumber;

    /** éœ€æ±‚分类 */
    @Excel(name = "需求分类")
    private String requirementType;

    /** å•æ®çŠ¶æ€ */
    @Excel(name = "单据状态")
    private String documentStatus;

    /** æ–™å· */
    @Excel(name = "料号")
    private String itemNumber;

    /** å›¾å· */
    @Excel(name = "图号")
    private String drawingNo;

    /** ç‰ˆæœ¬å· */
    @Excel(name = "版本号")
    private String versionNumber;

    /** ç”Ÿäº§æ•°é‡ */
    @Excel(name = "生产数量")
    private Long productionQuantity;

    /** è‰¯å“æ•°é‡ */
    @Excel(name = "良品数量")
    private Long goodProductsQuantity;

    /** å·¥åºå· */
    @Excel(name = "工序号")
    private String processNumber;

    /** å·¥ä½œä¸­å¿ƒ */
    @Excel(name = "工作中心")
    private String workCenter;

    /** æ‰€å±žéƒ¨é—¨ */
    @Excel(name = "所属部门")
    private String department;

    /** è®¡åˆ’开工日 */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "计划开工日", width = 30, dateFormat = "yyyy-MM-dd")
    private Date planStartDay;

    /** è®¡åˆ’完工日 */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "计划完工日", width = 30, dateFormat = "yyyy-MM-dd")
    private Date planEndDay;

    /** å¤‡æ–™æ–™å· */
    @Excel(name = "备料料号")
    private String standbyNumber;

    /** å¤‡æ–™åç§° */
    @Excel(name = "备料名称")
    private String standbyName;

    /** å¤‡æ–™åº“å­˜ */
    @Excel(name = "备料库存")
    private Long standbyStock;

    /** ä¸‹é“工序所属部门 */
    @Excel(name = "下道工序所属部门")
    private String nextProcessDeparment;

    /** æ˜¯å¦æŒ‚èµ· */
    @Excel(name = "是否挂起")
    private Integer isSuspended;

    /** å¤–协标识 */
    @Excel(name = "外协标识")
    private String isOutsourcing;

    /** è´¦å¥— */
    @Excel(name = "账套")
    private String account;

    /** ä¸Šé˜¶ç‰©æ–™ */
    @Excel(name = "上阶物料")
    private String advancedMaterials;

    /** ä¸Šé˜¶å•æ®å· */
    @Excel(name = "上阶单据号")
    private String advancedDocumentNumber;

    /** ä¸Šé˜¶éœ€æ±‚日期 */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "上阶需求日期", width = 30, dateFormat = "yyyy-MM-dd")
    private Date advancedRequirementDay;

    /** è®¡åˆ’齐套 */
    @Excel(name = "计划齐套")
    private Boolean isPlanComplete;

    /** åº“存齐套 */
    @Excel(name = "库存齐套")
    private Boolean isStockComplete;

    /** æ˜¯å¦æœ‰æŠ˜è¿”工序 */
    @Excel(name = "是否有折返工序")
    private Boolean hasTurnback;

    /** é£Žé™©æ ‡è¯† */
    @Excel(name = "风险标识")
    private Boolean hasRisk;

    /** æ‰¹æ¬¡å· */
    @Excel(name = "批次号")
    private String batchNumber;

    public void setId(String id) 
    {
        this.id = id;
    }

    public String getId() 
    {
        return id;
    }

    public void setMasterPlanner(String masterPlanner) 
    {
        this.masterPlanner = masterPlanner;
    }

    public String getMasterPlanner() 
    {
        return masterPlanner;
    }

    public void setWeekDay(Date weekDay) 
    {
        this.weekDay = weekDay;
    }

    public Date getWeekDay() 
    {
        return weekDay;
    }

    public void setWeekCycle(String weekCycle) 
    {
        this.weekCycle = weekCycle;
    }

    public String getWeekCycle() 
    {
        return weekCycle;
    }

    public void setMainPartNumber(String mainPartNumber) 
    {
        this.mainPartNumber = mainPartNumber;
    }

    public String getMainPartNumber() 
    {
        return mainPartNumber;
    }

    public void setMainPartDrawingNumber(String mainPartDrawingNumber) 
    {
        this.mainPartDrawingNumber = mainPartDrawingNumber;
    }

    public String getMainPartDrawingNumber() 
    {
        return mainPartDrawingNumber;
    }

    public void setCustomer(String customer) 
    {
        this.customer = customer;
    }

    public String getCustomer() 
    {
        return customer;
    }

    public void setBusinessType(String businessType) 
    {
        this.businessType = businessType;
    }

    public String getBusinessType() 
    {
        return businessType;
    }

    public void setDocumentNumber(String documentNumber) 
    {
        this.documentNumber = documentNumber;
    }

    public String getDocumentNumber() 
    {
        return documentNumber;
    }

    public void setRequirementType(String requirementType) 
    {
        this.requirementType = requirementType;
    }

    public String getRequirementType() 
    {
        return requirementType;
    }

    public void setDocumentStatus(String documentStatus) 
    {
        this.documentStatus = documentStatus;
    }

    public String getDocumentStatus() 
    {
        return documentStatus;
    }

    public void setItemNumber(String itemNumber) 
    {
        this.itemNumber = itemNumber;
    }

    public String getItemNumber() 
    {
        return itemNumber;
    }

    public void setDrawingNo(String drawingNo) 
    {
        this.drawingNo = drawingNo;
    }

    public String getDrawingNo() 
    {
        return drawingNo;
    }

    public void setVersionNumber(String versionNumber) 
    {
        this.versionNumber = versionNumber;
    }

    public String getVersionNumber() 
    {
        return versionNumber;
    }

    public void setProductionQuantity(Long productionQuantity) 
    {
        this.productionQuantity = productionQuantity;
    }

    public Long getProductionQuantity() 
    {
        return productionQuantity;
    }

    public void setGoodProductsQuantity(Long goodProductsQuantity) 
    {
        this.goodProductsQuantity = goodProductsQuantity;
    }

    public Long getGoodProductsQuantity() 
    {
        return goodProductsQuantity;
    }

    public void setProcessNumber(String processNumber) 
    {
        this.processNumber = processNumber;
    }

    public String getProcessNumber() 
    {
        return processNumber;
    }

    public void setWorkCenter(String workCenter) 
    {
        this.workCenter = workCenter;
    }

    public String getWorkCenter() 
    {
        return workCenter;
    }

    public void setDepartment(String department) 
    {
        this.department = department;
    }

    public String getDepartment() 
    {
        return department;
    }

    public void setPlanStartDay(Date planStartDay) 
    {
        this.planStartDay = planStartDay;
    }

    public Date getPlanStartDay() 
    {
        return planStartDay;
    }

    public void setPlanEndDay(Date planEndDay) 
    {
        this.planEndDay = planEndDay;
    }

    public Date getPlanEndDay() 
    {
        return planEndDay;
    }

    public void setStandbyNumber(String standbyNumber) 
    {
        this.standbyNumber = standbyNumber;
    }

    public String getStandbyNumber() 
    {
        return standbyNumber;
    }

    public void setStandbyName(String standbyName) 
    {
        this.standbyName = standbyName;
    }

    public String getStandbyName() 
    {
        return standbyName;
    }

    public void setStandbyStock(Long standbyStock) 
    {
        this.standbyStock = standbyStock;
    }

    public Long getStandbyStock() 
    {
        return standbyStock;
    }

    public void setNextProcessDeparment(String nextProcessDeparment) 
    {
        this.nextProcessDeparment = nextProcessDeparment;
    }

    public String getNextProcessDeparment() 
    {
        return nextProcessDeparment;
    }

    public void setIsSuspended(Integer isSuspended) 
    {
        this.isSuspended = isSuspended;
    }

    public Integer getIsSuspended() 
    {
        return isSuspended;
    }

    public void setIsOutsourcing(String isOutsourcing) 
    {
        this.isOutsourcing = isOutsourcing;
    }

    public String getIsOutsourcing() 
    {
        return isOutsourcing;
    }

    public void setAccount(String account) 
    {
        this.account = account;
    }

    public String getAccount() 
    {
        return account;
    }

    public void setAdvancedMaterials(String advancedMaterials) 
    {
        this.advancedMaterials = advancedMaterials;
    }

    public String getAdvancedMaterials() 
    {
        return advancedMaterials;
    }

    public void setAdvancedDocumentNumber(String advancedDocumentNumber) 
    {
        this.advancedDocumentNumber = advancedDocumentNumber;
    }

    public String getAdvancedDocumentNumber() 
    {
        return advancedDocumentNumber;
    }

    public void setAdvancedRequirementDay(Date advancedRequirementDay) 
    {
        this.advancedRequirementDay = advancedRequirementDay;
    }

    public Date getAdvancedRequirementDay() 
    {
        return advancedRequirementDay;
    }

    public void setIsPlanComplete(Boolean isPlanComplete) 
    {
        this.isPlanComplete = isPlanComplete;
    }

    public Boolean getIsPlanComplete() 
    {
        return isPlanComplete;
    }

    public void setIsStockComplete(Boolean isStockComplete) 
    {
        this.isStockComplete = isStockComplete;
    }

    public Boolean getIsStockComplete() 
    {
        return isStockComplete;
    }

    public void setHasTurnback(Boolean hasTurnback) 
    {
        this.hasTurnback = hasTurnback;
    }

    public Boolean getHasTurnback() 
    {
        return hasTurnback;
    }

    public void setHasRisk(Boolean hasRisk) 
    {
        this.hasRisk = hasRisk;
    }

    public Boolean getHasRisk() 
    {
        return hasRisk;
    }

    public void setBatchNumber(String batchNumber) 
    {
        this.batchNumber = batchNumber;
    }

    public String getBatchNumber() 
    {
        return batchNumber;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("masterPlanner", getMasterPlanner())
            .append("weekDay", getWeekDay())
            .append("weekCycle", getWeekCycle())
            .append("mainPartNumber", getMainPartNumber())
            .append("mainPartDrawingNumber", getMainPartDrawingNumber())
            .append("customer", getCustomer())
            .append("businessType", getBusinessType())
            .append("documentNumber", getDocumentNumber())
            .append("requirementType", getRequirementType())
            .append("documentStatus", getDocumentStatus())
            .append("itemNumber", getItemNumber())
            .append("drawingNo", getDrawingNo())
            .append("versionNumber", getVersionNumber())
            .append("productionQuantity", getProductionQuantity())
            .append("goodProductsQuantity", getGoodProductsQuantity())
            .append("processNumber", getProcessNumber())
            .append("workCenter", getWorkCenter())
            .append("department", getDepartment())
            .append("planStartDay", getPlanStartDay())
            .append("planEndDay", getPlanEndDay())
            .append("standbyNumber", getStandbyNumber())
            .append("standbyName", getStandbyName())
            .append("standbyStock", getStandbyStock())
            .append("nextProcessDeparment", getNextProcessDeparment())
            .append("isSuspended", getIsSuspended())
            .append("isOutsourcing", getIsOutsourcing())
            .append("account", getAccount())
            .append("advancedMaterials", getAdvancedMaterials())
            .append("advancedDocumentNumber", getAdvancedDocumentNumber())
            .append("advancedRequirementDay", getAdvancedRequirementDay())
            .append("isPlanComplete", getIsPlanComplete())
            .append("isStockComplete", getIsStockComplete())
            .append("hasTurnback", getHasTurnback())
            .append("hasRisk", getHasRisk())
            .append("batchNumber", getBatchNumber())
            .toString();
    }
}

 aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlatePlanMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.aps.core.mapper;

import java.util.List;
import  com.aps.core.domain.ApsPlatePlan;
import org.apache.ibatis.annotations.Mapper;

/**
 * é’£é‡‘计划管理Mapper接口
 * 
 * @author ruoyi
 * @date 2025-04-08
 */
@Mapper
public interface ApsPlatePlanMapper 
{
    /**
     * æŸ¥è¯¢é’£é‡‘计划管理
     * 
     * @param id é’£é‡‘计划管理主键
     * @return é’£é‡‘计划管理
     */
    public ApsPlatePlan selectApsPlatePlanById(String id);

    /**
     * æŸ¥è¯¢é’£é‡‘计划管理列表
     * 
     * @param apsPlatePlan é’£é‡‘计划管理
     * @return é’£é‡‘计划管理集合
     */
    public List<ApsPlatePlan> selectApsPlatePlanList(ApsPlatePlan apsPlatePlan);

    /**
     * æ–°å¢žé’£é‡‘计划管理
     * 
     * @param apsPlatePlan é’£é‡‘计划管理
     * @return ç»“æžœ
     */
    public int insertApsPlatePlan(ApsPlatePlan apsPlatePlan);

    /**
     * ä¿®æ”¹é’£é‡‘计划管理
     * 
     * @param apsPlatePlan é’£é‡‘计划管理
     * @return ç»“æžœ
     */
    public int updateApsPlatePlan(ApsPlatePlan apsPlatePlan);

    /**
     * åˆ é™¤é’£é‡‘计划管理
     * 
     * @param id é’£é‡‘计划管理主键
     * @return ç»“æžœ
     */
    public int deleteApsPlatePlanById(String id);

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘计划管理
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlatePlanByIds(String[] ids);
}

 aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlatePlanTempMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.aps.core.mapper;

import java.util.List;
import com.aps.core.domain.ApsPlatePlanTemp;
import org.apache.ibatis.annotations.Mapper;

/**
 * é’£é‡‘计划临时表Mapper接口
 * 
 * @author ruoyi
 * @date 2025-04-08
 */
@Mapper
public interface ApsPlatePlanTempMapper 
{
    /**
     * æŸ¥è¯¢é’£é‡‘计划临时表
     * 
     * @param id é’£é‡‘计划临时表主键
     * @return é’£é‡‘计划临时表
     */
    public ApsPlatePlanTemp selectApsPlatePlanTempById(String id);

    /**
     * æŸ¥è¯¢é’£é‡‘计划临时表列表
     * 
     * @param apsPlatePlanTemp é’£é‡‘计划临时表
     * @return é’£é‡‘计划临时表集合
     */
    public List<ApsPlatePlanTemp> selectApsPlatePlanTempList(ApsPlatePlanTemp apsPlatePlanTemp);

    /**
     * æ–°å¢žé’£é‡‘计划临时表
     * 
     * @param apsPlatePlanTemp é’£é‡‘计划临时表
     * @return ç»“æžœ
     */
    public int insertApsPlatePlanTemp(ApsPlatePlanTemp apsPlatePlanTemp);

    /**
     * ä¿®æ”¹é’£é‡‘计划临时表
     * 
     * @param apsPlatePlanTemp é’£é‡‘计划临时表
     * @return ç»“æžœ
     */
    public int updateApsPlatePlanTemp(ApsPlatePlanTemp apsPlatePlanTemp);

    /**
     * åˆ é™¤é’£é‡‘计划临时表
     * 
     * @param id é’£é‡‘计划临时表主键
     * @return ç»“æžœ
     */
    public int deleteApsPlatePlanTempById(String id);

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘计划临时表
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlatePlanTempByIds(String[] ids);
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlatePlanService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.aps.core.service;

import java.util.List;
import  com.aps.core.domain.ApsPlatePlan;

/**
 * é’£é‡‘计划管理Service接口
 * 
 * @author ruoyi
 * @date 2025-04-08
 */
public interface IApsPlatePlanService 
{
    /**
     * æŸ¥è¯¢é’£é‡‘计划管理
     * 
     * @param id é’£é‡‘计划管理主键
     * @return é’£é‡‘计划管理
     */
    public ApsPlatePlan selectApsPlatePlanById(String id);

    /**
     * æŸ¥è¯¢é’£é‡‘计划管理列表
     * 
     * @param apsPlatePlan é’£é‡‘计划管理
     * @return é’£é‡‘计划管理集合
     */
    public List<ApsPlatePlan> selectApsPlatePlanList(ApsPlatePlan apsPlatePlan);

    /**
     * æ–°å¢žé’£é‡‘计划管理
     * 
     * @param apsPlatePlan é’£é‡‘计划管理
     * @return ç»“æžœ
     */
    public int insertApsPlatePlan(ApsPlatePlan apsPlatePlan);

    /**
     * ä¿®æ”¹é’£é‡‘计划管理
     * 
     * @param apsPlatePlan é’£é‡‘计划管理
     * @return ç»“æžœ
     */
    public int updateApsPlatePlan(ApsPlatePlan apsPlatePlan);

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘计划管理
     * 
     * @param ids éœ€è¦åˆ é™¤çš„钣金计划管理主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlatePlanByIds(String[] ids);

    /**
     * åˆ é™¤é’£é‡‘计划管理信息
     * 
     * @param id é’£é‡‘计划管理主键
     * @return ç»“æžœ
     */
    public int deleteApsPlatePlanById(String id);
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlatePlanTempService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.aps.core.service;

import java.util.List;
import com.aps.core.domain.ApsPlatePlanTemp;

/**
 * é’£é‡‘计划临时表Service接口
 * 
 * @author ruoyi
 * @date 2025-04-08
 */
public interface IApsPlatePlanTempService 
{
    /**
     * æŸ¥è¯¢é’£é‡‘计划临时表
     * 
     * @param id é’£é‡‘计划临时表主键
     * @return é’£é‡‘计划临时表
     */
    public ApsPlatePlanTemp selectApsPlatePlanTempById(String id);

    /**
     * æŸ¥è¯¢é’£é‡‘计划临时表列表
     * 
     * @param apsPlatePlanTemp é’£é‡‘计划临时表
     * @return é’£é‡‘计划临时表集合
     */
    public List<ApsPlatePlanTemp> selectApsPlatePlanTempList(ApsPlatePlanTemp apsPlatePlanTemp);

    /**
     * æ–°å¢žé’£é‡‘计划临时表
     * 
     * @param apsPlatePlanTemp é’£é‡‘计划临时表
     * @return ç»“æžœ
     */
    public int insertApsPlatePlanTemp(ApsPlatePlanTemp apsPlatePlanTemp);

    /**
     * ä¿®æ”¹é’£é‡‘计划临时表
     * 
     * @param apsPlatePlanTemp é’£é‡‘计划临时表
     * @return ç»“æžœ
     */
    public int updateApsPlatePlanTemp(ApsPlatePlanTemp apsPlatePlanTemp);

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘计划临时表
     * 
     * @param ids éœ€è¦åˆ é™¤çš„钣金计划临时表主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlatePlanTempByIds(String[] ids);

    /**
     * åˆ é™¤é’£é‡‘计划临时表信息
     * 
     * @param id é’£é‡‘计划临时表主键
     * @return ç»“æžœ
     */
    public int deleteApsPlatePlanTempById(String id);
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlatePlanServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,93 @@
package com.aps.core.service.impl;

import java.util.List;
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;

/**
 * é’£é‡‘计划管理Service业务层处理
 * 
 * @author ruoyi
 * @date 2025-04-08
 */
@Service
public class ApsPlatePlanServiceImpl implements IApsPlatePlanService 
{
    @Autowired
    private ApsPlatePlanMapper apsPlatePlanMapper;

    /**
     * æŸ¥è¯¢é’£é‡‘计划管理
     * 
     * @param id é’£é‡‘计划管理主键
     * @return é’£é‡‘计划管理
     */
    @Override
    public ApsPlatePlan selectApsPlatePlanById(String id)
    {
        return apsPlatePlanMapper.selectApsPlatePlanById(id);
    }

    /**
     * æŸ¥è¯¢é’£é‡‘计划管理列表
     * 
     * @param apsPlatePlan é’£é‡‘计划管理
     * @return é’£é‡‘计划管理
     */
    @Override
    public List<ApsPlatePlan> selectApsPlatePlanList(ApsPlatePlan apsPlatePlan)
    {
        return apsPlatePlanMapper.selectApsPlatePlanList(apsPlatePlan);
    }

    /**
     * æ–°å¢žé’£é‡‘计划管理
     * 
     * @param apsPlatePlan é’£é‡‘计划管理
     * @return ç»“æžœ
     */
    @Override
    public int insertApsPlatePlan(ApsPlatePlan apsPlatePlan)
    {
        return apsPlatePlanMapper.insertApsPlatePlan(apsPlatePlan);
    }

    /**
     * ä¿®æ”¹é’£é‡‘计划管理
     * 
     * @param apsPlatePlan é’£é‡‘计划管理
     * @return ç»“æžœ
     */
    @Override
    public int updateApsPlatePlan(ApsPlatePlan apsPlatePlan)
    {
        return apsPlatePlanMapper.updateApsPlatePlan(apsPlatePlan);
    }

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘计划管理
     * 
     * @param ids éœ€è¦åˆ é™¤çš„钣金计划管理主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlatePlanByIds(String[] ids)
    {
        return apsPlatePlanMapper.deleteApsPlatePlanByIds(ids);
    }

    /**
     * åˆ é™¤é’£é‡‘计划管理信息
     * 
     * @param id é’£é‡‘计划管理主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlatePlanById(String id)
    {
        return apsPlatePlanMapper.deleteApsPlatePlanById(id);
    }
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlatePlanTempServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,93 @@
package com.aps.core.service.impl;

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;

/**
 * é’£é‡‘计划临时表Service业务层处理
 * 
 * @author ruoyi
 * @date 2025-04-08
 */
@Service
public class ApsPlatePlanTempServiceImpl implements IApsPlatePlanTempService 
{
    @Autowired
    private ApsPlatePlanTempMapper apsPlatePlanTempMapper;

    /**
     * æŸ¥è¯¢é’£é‡‘计划临时表
     * 
     * @param id é’£é‡‘计划临时表主键
     * @return é’£é‡‘计划临时表
     */
    @Override
    public ApsPlatePlanTemp selectApsPlatePlanTempById(String id)
    {
        return apsPlatePlanTempMapper.selectApsPlatePlanTempById(id);
    }

    /**
     * æŸ¥è¯¢é’£é‡‘计划临时表列表
     * 
     * @param apsPlatePlanTemp é’£é‡‘计划临时表
     * @return é’£é‡‘计划临时表
     */
    @Override
    public List<ApsPlatePlanTemp> selectApsPlatePlanTempList(ApsPlatePlanTemp apsPlatePlanTemp)
    {
        return apsPlatePlanTempMapper.selectApsPlatePlanTempList(apsPlatePlanTemp);
    }

    /**
     * æ–°å¢žé’£é‡‘计划临时表
     * 
     * @param apsPlatePlanTemp é’£é‡‘计划临时表
     * @return ç»“æžœ
     */
    @Override
    public int insertApsPlatePlanTemp(ApsPlatePlanTemp apsPlatePlanTemp)
    {
        return apsPlatePlanTempMapper.insertApsPlatePlanTemp(apsPlatePlanTemp);
    }

    /**
     * ä¿®æ”¹é’£é‡‘计划临时表
     * 
     * @param apsPlatePlanTemp é’£é‡‘计划临时表
     * @return ç»“æžœ
     */
    @Override
    public int updateApsPlatePlanTemp(ApsPlatePlanTemp apsPlatePlanTemp)
    {
        return apsPlatePlanTempMapper.updateApsPlatePlanTemp(apsPlatePlanTemp);
    }

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘计划临时表
     * 
     * @param ids éœ€è¦åˆ é™¤çš„钣金计划临时表主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlatePlanTempByIds(String[] ids)
    {
        return apsPlatePlanTempMapper.deleteApsPlatePlanTempByIds(ids);
    }

    /**
     * åˆ é™¤é’£é‡‘计划临时表信息
     * 
     * @param id é’£é‡‘计划临时表主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlatePlanTempById(String id)
    {
        return apsPlatePlanTempMapper.deleteApsPlatePlanTempById(id);
    }
}

 aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,223 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.core.mapper.ApsPlatePlanMapper">
    
    <resultMap type="ApsPlatePlan" id="ApsPlatePlanResult">
        <result property="id"    column="id"    />
        <result property="masterPlanner"    column="master_planner"    />
        <result property="weekDay"    column="week_day"    />
        <result property="weekCycle"    column="week_cycle"    />
        <result property="mainPartNumber"    column="main_part_number"    />
        <result property="mainPartDrawingNumber"    column="main_part_drawing_number"    />
        <result property="customer"    column="customer"    />
        <result property="businessType"    column="business_type"    />
        <result property="documentNumber"    column="document_number"    />
        <result property="requirementType"    column="requirement_type"    />
        <result property="documentStatus"    column="document_status"    />
        <result property="itemNumber"    column="item_number"    />
        <result property="drawingNo"    column="drawing_no"    />
        <result property="versionNumber"    column="version_number"    />
        <result property="productionQuantity"    column="production_quantity"    />
        <result property="goodProductsQuantity"    column="good_products_quantity"    />
        <result property="processNumber"    column="process_number"    />
        <result property="workCenter"    column="work_center"    />
        <result property="department"    column="department"    />
        <result property="planStartDay"    column="plan_start_day"    />
        <result property="planEndDay"    column="plan_end_day"    />
        <result property="standbyNumber"    column="standby_number"    />
        <result property="standbyName"    column="standby_name"    />
        <result property="standbyStock"    column="standby_stock"    />
        <result property="nextProcessDeparment"    column="next_process_deparment"    />
        <result property="isSuspended"    column="is_suspended"    />
        <result property="isOutsourcing"    column="is_outsourcing"    />
        <result property="account"    column="account"    />
        <result property="advancedMaterials"    column="advanced_materials"    />
        <result property="advancedDocumentNumber"    column="advanced_document_number"    />
        <result property="advancedRequirementDay"    column="advanced_requirement_day"    />
        <result property="isPlanComplete"    column="is_plan_complete"    />
        <result property="isStockComplete"    column="is_stock_complete"    />
        <result property="hasTurnback"    column="has_turnback"    />
        <result property="hasRisk"    column="has_risk"    />
    </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
    </sql>

    <select id="selectApsPlatePlanList" parameterType="ApsPlatePlan" resultMap="ApsPlatePlanResult">
        <include refid="selectApsPlatePlanVo"/>
        <where>  
            <if test="masterPlanner != null  and masterPlanner != ''"> and master_planner like concat('%', #{masterPlanner}, '%')</if>
            <if test="weekDay != null "> and week_day = #{weekDay}</if>
            <if test="weekCycle != null  and weekCycle != ''"> and week_cycle like concat('%', #{weekCycle}, '%')</if>
            <if test="mainPartNumber != null  and mainPartNumber != ''"> and main_part_number like concat('%', #{mainPartNumber}, '%')</if>
            <if test="mainPartDrawingNumber != null  and mainPartDrawingNumber != ''"> and main_part_drawing_number like concat('%', #{mainPartDrawingNumber}, '%')</if>
            <if test="customer != null  and customer != ''"> and customer like concat('%', #{customer}, '%')</if>
            <if test="businessType != null  and businessType != ''"> and business_type = #{businessType}</if>
            <if test="documentNumber != null  and documentNumber != ''"> and document_number like concat('%', #{documentNumber}, '%')</if>
            <if test="requirementType != null  and requirementType != ''"> and requirement_type like concat('%', #{requirementType}, '%')</if>
            <if test="documentStatus != null  and documentStatus != ''"> and document_status = #{documentStatus}</if>
            <if test="itemNumber != null  and itemNumber != ''"> and item_number like concat('%', #{itemNumber}, '%')</if>
            <if test="drawingNo != null  and drawingNo != ''"> and drawing_no like concat('%', #{drawingNo}, '%')</if>
            <if test="versionNumber != null  and versionNumber != ''"> and version_number like concat('%', #{versionNumber}, '%')</if>
            <if test="productionQuantity != null "> and production_quantity = #{productionQuantity}</if>
            <if test="goodProductsQuantity != null "> and good_products_quantity = #{goodProductsQuantity}</if>
            <if test="processNumber != null  and processNumber != ''"> and process_number like concat('%', #{processNumber}, '%')</if>
            <if test="workCenter != null  and workCenter != ''"> and work_center like concat('%', #{workCenter}, '%')</if>
            <if test="department != null  and department != ''"> and department like concat('%', #{department}, '%')</if>
            <if test="params.beginPlanStartDay != null and params.beginPlanStartDay != '' and params.endPlanStartDay != null and params.endPlanStartDay != ''"> and plan_start_day between #{params.beginPlanStartDay} and #{params.endPlanStartDay}</if>
            <if test="params.beginPlanEndDay != null and params.beginPlanEndDay != '' and params.endPlanEndDay != null and params.endPlanEndDay != ''"> and plan_end_day between #{params.beginPlanEndDay} and #{params.endPlanEndDay}</if>
            <if test="standbyNumber != null  and standbyNumber != ''"> and standby_number like concat('%', #{standbyNumber}, '%')</if>
            <if test="standbyName != null  and standbyName != ''"> and standby_name like concat('%', #{standbyName}, '%')</if>
            <if test="standbyStock != null "> and standby_stock = #{standbyStock}</if>
            <if test="nextProcessDeparment != null  and nextProcessDeparment != ''"> and next_process_deparment like concat('%', #{nextProcessDeparment}, '%')</if>
            <if test="isSuspended != null "> and is_suspended = #{isSuspended}</if>
            <if test="isOutsourcing != null  and isOutsourcing != ''"> and is_outsourcing like concat('%', #{isOutsourcing}, '%')</if>
            <if test="account != null  and account != ''"> and account like concat('%', #{account}, '%')</if>
            <if test="advancedMaterials != null  and advancedMaterials != ''"> and advanced_materials like concat('%', #{advancedMaterials}, '%')</if>
            <if test="advancedDocumentNumber != null  and advancedDocumentNumber != ''"> and advanced_document_number like concat('%', #{advancedDocumentNumber}, '%')</if>
            <if test="params.beginAdvancedRequirementDay != null and params.beginAdvancedRequirementDay != '' and params.endAdvancedRequirementDay != null and params.endAdvancedRequirementDay != ''"> and advanced_requirement_day between #{params.beginAdvancedRequirementDay} and #{params.endAdvancedRequirementDay}</if>
            <if test="isPlanComplete != null "> and is_plan_complete = #{isPlanComplete}</if>
            <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>
        </where>
    </select>
    
    <select id="selectApsPlatePlanById" parameterType="String" resultMap="ApsPlatePlanResult">
        <include refid="selectApsPlatePlanVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsPlatePlan" parameterType="ApsPlatePlan">
        insert into aps_plate_plan
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null and id != ''">id,</if>
            <if test="masterPlanner != null">master_planner,</if>
            <if test="weekDay != null">week_day,</if>
            <if test="weekCycle != null">week_cycle,</if>
            <if test="mainPartNumber != null">main_part_number,</if>
            <if test="mainPartDrawingNumber != null">main_part_drawing_number,</if>
            <if test="customer != null">customer,</if>
            <if test="businessType != null">business_type,</if>
            <if test="documentNumber != null">document_number,</if>
            <if test="requirementType != null">requirement_type,</if>
            <if test="documentStatus != null">document_status,</if>
            <if test="itemNumber != null">item_number,</if>
            <if test="drawingNo != null">drawing_no,</if>
            <if test="versionNumber != null">version_number,</if>
            <if test="productionQuantity != null">production_quantity,</if>
            <if test="goodProductsQuantity != null">good_products_quantity,</if>
            <if test="processNumber != null">process_number,</if>
            <if test="workCenter != null">work_center,</if>
            <if test="department != null">department,</if>
            <if test="planStartDay != null">plan_start_day,</if>
            <if test="planEndDay != null">plan_end_day,</if>
            <if test="standbyNumber != null">standby_number,</if>
            <if test="standbyName != null">standby_name,</if>
            <if test="standbyStock != null">standby_stock,</if>
            <if test="nextProcessDeparment != null">next_process_deparment,</if>
            <if test="isSuspended != null">is_suspended,</if>
            <if test="isOutsourcing != null">is_outsourcing,</if>
            <if test="account != null">account,</if>
            <if test="advancedMaterials != null">advanced_materials,</if>
            <if test="advancedDocumentNumber != null">advanced_document_number,</if>
            <if test="advancedRequirementDay != null">advanced_requirement_day,</if>
            <if test="isPlanComplete != null">is_plan_complete,</if>
            <if test="isStockComplete != null">is_stock_complete,</if>
            <if test="hasTurnback != null">has_turnback,</if>
            <if test="hasRisk != null">has_risk,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null and id != ''">#{id},</if>
            <if test="masterPlanner != null">#{masterPlanner},</if>
            <if test="weekDay != null">#{weekDay},</if>
            <if test="weekCycle != null">#{weekCycle},</if>
            <if test="mainPartNumber != null">#{mainPartNumber},</if>
            <if test="mainPartDrawingNumber != null">#{mainPartDrawingNumber},</if>
            <if test="customer != null">#{customer},</if>
            <if test="businessType != null">#{businessType},</if>
            <if test="documentNumber != null">#{documentNumber},</if>
            <if test="requirementType != null">#{requirementType},</if>
            <if test="documentStatus != null">#{documentStatus},</if>
            <if test="itemNumber != null">#{itemNumber},</if>
            <if test="drawingNo != null">#{drawingNo},</if>
            <if test="versionNumber != null">#{versionNumber},</if>
            <if test="productionQuantity != null">#{productionQuantity},</if>
            <if test="goodProductsQuantity != null">#{goodProductsQuantity},</if>
            <if test="processNumber != null">#{processNumber},</if>
            <if test="workCenter != null">#{workCenter},</if>
            <if test="department != null">#{department},</if>
            <if test="planStartDay != null">#{planStartDay},</if>
            <if test="planEndDay != null">#{planEndDay},</if>
            <if test="standbyNumber != null">#{standbyNumber},</if>
            <if test="standbyName != null">#{standbyName},</if>
            <if test="standbyStock != null">#{standbyStock},</if>
            <if test="nextProcessDeparment != null">#{nextProcessDeparment},</if>
            <if test="isSuspended != null">#{isSuspended},</if>
            <if test="isOutsourcing != null">#{isOutsourcing},</if>
            <if test="account != null">#{account},</if>
            <if test="advancedMaterials != null">#{advancedMaterials},</if>
            <if test="advancedDocumentNumber != null">#{advancedDocumentNumber},</if>
            <if test="advancedRequirementDay != null">#{advancedRequirementDay},</if>
            <if test="isPlanComplete != null">#{isPlanComplete},</if>
            <if test="isStockComplete != null">#{isStockComplete},</if>
            <if test="hasTurnback != null">#{hasTurnback},</if>
            <if test="hasRisk != null">#{hasRisk},</if>
         </trim>
    </insert>

    <update id="updateApsPlatePlan" parameterType="ApsPlatePlan">
        update aps_plate_plan
        <trim prefix="SET" suffixOverrides=",">
            <if test="masterPlanner != null">master_planner = #{masterPlanner},</if>
            <if test="weekDay != null">week_day = #{weekDay},</if>
            <if test="weekCycle != null">week_cycle = #{weekCycle},</if>
            <if test="mainPartNumber != null">main_part_number = #{mainPartNumber},</if>
            <if test="mainPartDrawingNumber != null">main_part_drawing_number = #{mainPartDrawingNumber},</if>
            <if test="customer != null">customer = #{customer},</if>
            <if test="businessType != null">business_type = #{businessType},</if>
            <if test="documentNumber != null">document_number = #{documentNumber},</if>
            <if test="requirementType != null">requirement_type = #{requirementType},</if>
            <if test="documentStatus != null">document_status = #{documentStatus},</if>
            <if test="itemNumber != null">item_number = #{itemNumber},</if>
            <if test="drawingNo != null">drawing_no = #{drawingNo},</if>
            <if test="versionNumber != null">version_number = #{versionNumber},</if>
            <if test="productionQuantity != null">production_quantity = #{productionQuantity},</if>
            <if test="goodProductsQuantity != null">good_products_quantity = #{goodProductsQuantity},</if>
            <if test="processNumber != null">process_number = #{processNumber},</if>
            <if test="workCenter != null">work_center = #{workCenter},</if>
            <if test="department != null">department = #{department},</if>
            <if test="planStartDay != null">plan_start_day = #{planStartDay},</if>
            <if test="planEndDay != null">plan_end_day = #{planEndDay},</if>
            <if test="standbyNumber != null">standby_number = #{standbyNumber},</if>
            <if test="standbyName != null">standby_name = #{standbyName},</if>
            <if test="standbyStock != null">standby_stock = #{standbyStock},</if>
            <if test="nextProcessDeparment != null">next_process_deparment = #{nextProcessDeparment},</if>
            <if test="isSuspended != null">is_suspended = #{isSuspended},</if>
            <if test="isOutsourcing != null">is_outsourcing = #{isOutsourcing},</if>
            <if test="account != null">account = #{account},</if>
            <if test="advancedMaterials != null">advanced_materials = #{advancedMaterials},</if>
            <if test="advancedDocumentNumber != null">advanced_document_number = #{advancedDocumentNumber},</if>
            <if test="advancedRequirementDay != null">advanced_requirement_day = #{advancedRequirementDay},</if>
            <if test="isPlanComplete != null">is_plan_complete = #{isPlanComplete},</if>
            <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>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteApsPlatePlanById" parameterType="String">
        delete from aps_plate_plan where id = #{id}
    </delete>

    <delete id="deleteApsPlatePlanByIds" parameterType="String">
        delete from aps_plate_plan where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>

 aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanTempMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,205 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.core.mapper.ApsPlatePlanTempMapper">
    
    <resultMap type="ApsPlatePlanTemp" id="ApsPlatePlanTempResult">
        <result property="id"    column="id"    />
        <result property="masterPlanner"    column="master_planner"    />
        <result property="weekDay"    column="week_day"    />
        <result property="weekCycle"    column="week_cycle"    />
        <result property="mainPartNumber"    column="main_part_number"    />
        <result property="mainPartDrawingNumber"    column="main_part_drawing_number"    />
        <result property="customer"    column="customer"    />
        <result property="businessType"    column="business_type"    />
        <result property="documentNumber"    column="document_number"    />
        <result property="requirementType"    column="requirement_type"    />
        <result property="documentStatus"    column="document_status"    />
        <result property="itemNumber"    column="item_number"    />
        <result property="drawingNo"    column="drawing_no"    />
        <result property="versionNumber"    column="version_number"    />
        <result property="productionQuantity"    column="production_quantity"    />
        <result property="goodProductsQuantity"    column="good_products_quantity"    />
        <result property="processNumber"    column="process_number"    />
        <result property="workCenter"    column="work_center"    />
        <result property="department"    column="department"    />
        <result property="planStartDay"    column="plan_start_day"    />
        <result property="planEndDay"    column="plan_end_day"    />
        <result property="standbyNumber"    column="standby_number"    />
        <result property="standbyName"    column="standby_name"    />
        <result property="standbyStock"    column="standby_stock"    />
        <result property="nextProcessDeparment"    column="next_process_deparment"    />
        <result property="isSuspended"    column="is_suspended"    />
        <result property="isOutsourcing"    column="is_outsourcing"    />
        <result property="account"    column="account"    />
        <result property="advancedMaterials"    column="advanced_materials"    />
        <result property="advancedDocumentNumber"    column="advanced_document_number"    />
        <result property="advancedRequirementDay"    column="advanced_requirement_day"    />
        <result property="isPlanComplete"    column="is_plan_complete"    />
        <result property="isStockComplete"    column="is_stock_complete"    />
        <result property="hasTurnback"    column="has_turnback"    />
        <result property="hasRisk"    column="has_risk"    />
        <result property="batchNumber"    column="batch_number"    />
    </resultMap>

    <sql id="selectApsPlatePlanTempVo">
        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="ApsPlatePlanTemp" resultMap="ApsPlatePlanTempResult">
        <include refid="selectApsPlatePlanTempVo"/>
        <where>  
            <if test="nextProcessDeparment != null  and nextProcessDeparment != ''"> and next_process_deparment = #{nextProcessDeparment}</if>
            <if test="isSuspended != null "> and is_suspended = #{isSuspended}</if>
            <if test="isOutsourcing != null  and isOutsourcing != ''"> and is_outsourcing = #{isOutsourcing}</if>
            <if test="account != null  and account != ''"> and account = #{account}</if>
            <if test="advancedMaterials != null  and advancedMaterials != ''"> and advanced_materials = #{advancedMaterials}</if>
            <if test="advancedDocumentNumber != null  and advancedDocumentNumber != ''"> and advanced_document_number = #{advancedDocumentNumber}</if>
            <if test="advancedRequirementDay != null "> and advanced_requirement_day = #{advancedRequirementDay}</if>
            <if test="isPlanComplete != null "> and is_plan_complete = #{isPlanComplete}</if>
            <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="batchNumber != null  and batchNumber != ''"> and batch_number = #{batchNumber}</if>
        </where>
    </select>
    
    <select id="selectApsPlatePlanTempById" parameterType="String" resultMap="ApsPlatePlanTempResult">
        <include refid="selectApsPlatePlanTempVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsPlatePlanTemp" parameterType="ApsPlatePlanTemp">
        insert into aps_plate_plan_temp
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null and id != ''">id,</if>
            <if test="masterPlanner != null">master_planner,</if>
            <if test="weekDay != null">week_day,</if>
            <if test="weekCycle != null">week_cycle,</if>
            <if test="mainPartNumber != null">main_part_number,</if>
            <if test="mainPartDrawingNumber != null">main_part_drawing_number,</if>
            <if test="customer != null">customer,</if>
            <if test="businessType != null">business_type,</if>
            <if test="documentNumber != null">document_number,</if>
            <if test="requirementType != null">requirement_type,</if>
            <if test="documentStatus != null">document_status,</if>
            <if test="itemNumber != null">item_number,</if>
            <if test="drawingNo != null">drawing_no,</if>
            <if test="versionNumber != null">version_number,</if>
            <if test="productionQuantity != null">production_quantity,</if>
            <if test="goodProductsQuantity != null">good_products_quantity,</if>
            <if test="processNumber != null">process_number,</if>
            <if test="workCenter != null">work_center,</if>
            <if test="department != null">department,</if>
            <if test="planStartDay != null">plan_start_day,</if>
            <if test="planEndDay != null">plan_end_day,</if>
            <if test="standbyNumber != null">standby_number,</if>
            <if test="standbyName != null">standby_name,</if>
            <if test="standbyStock != null">standby_stock,</if>
            <if test="nextProcessDeparment != null">next_process_deparment,</if>
            <if test="isSuspended != null">is_suspended,</if>
            <if test="isOutsourcing != null">is_outsourcing,</if>
            <if test="account != null">account,</if>
            <if test="advancedMaterials != null">advanced_materials,</if>
            <if test="advancedDocumentNumber != null">advanced_document_number,</if>
            <if test="advancedRequirementDay != null">advanced_requirement_day,</if>
            <if test="isPlanComplete != null">is_plan_complete,</if>
            <if test="isStockComplete != null">is_stock_complete,</if>
            <if test="hasTurnback != null">has_turnback,</if>
            <if test="hasRisk != null">has_risk,</if>
            <if test="batchNumber != null">batch_number,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null and id != ''">#{id},</if>
            <if test="masterPlanner != null">#{masterPlanner},</if>
            <if test="weekDay != null">#{weekDay},</if>
            <if test="weekCycle != null">#{weekCycle},</if>
            <if test="mainPartNumber != null">#{mainPartNumber},</if>
            <if test="mainPartDrawingNumber != null">#{mainPartDrawingNumber},</if>
            <if test="customer != null">#{customer},</if>
            <if test="businessType != null">#{businessType},</if>
            <if test="documentNumber != null">#{documentNumber},</if>
            <if test="requirementType != null">#{requirementType},</if>
            <if test="documentStatus != null">#{documentStatus},</if>
            <if test="itemNumber != null">#{itemNumber},</if>
            <if test="drawingNo != null">#{drawingNo},</if>
            <if test="versionNumber != null">#{versionNumber},</if>
            <if test="productionQuantity != null">#{productionQuantity},</if>
            <if test="goodProductsQuantity != null">#{goodProductsQuantity},</if>
            <if test="processNumber != null">#{processNumber},</if>
            <if test="workCenter != null">#{workCenter},</if>
            <if test="department != null">#{department},</if>
            <if test="planStartDay != null">#{planStartDay},</if>
            <if test="planEndDay != null">#{planEndDay},</if>
            <if test="standbyNumber != null">#{standbyNumber},</if>
            <if test="standbyName != null">#{standbyName},</if>
            <if test="standbyStock != null">#{standbyStock},</if>
            <if test="nextProcessDeparment != null">#{nextProcessDeparment},</if>
            <if test="isSuspended != null">#{isSuspended},</if>
            <if test="isOutsourcing != null">#{isOutsourcing},</if>
            <if test="account != null">#{account},</if>
            <if test="advancedMaterials != null">#{advancedMaterials},</if>
            <if test="advancedDocumentNumber != null">#{advancedDocumentNumber},</if>
            <if test="advancedRequirementDay != null">#{advancedRequirementDay},</if>
            <if test="isPlanComplete != null">#{isPlanComplete},</if>
            <if test="isStockComplete != null">#{isStockComplete},</if>
            <if test="hasTurnback != null">#{hasTurnback},</if>
            <if test="hasRisk != null">#{hasRisk},</if>
            <if test="batchNumber != null">#{batchNumber},</if>
         </trim>
    </insert>

    <update id="updateApsPlatePlanTemp" parameterType="ApsPlatePlanTemp">
        update aps_plate_plan_temp
        <trim prefix="SET" suffixOverrides=",">
            <if test="masterPlanner != null">master_planner = #{masterPlanner},</if>
            <if test="weekDay != null">week_day = #{weekDay},</if>
            <if test="weekCycle != null">week_cycle = #{weekCycle},</if>
            <if test="mainPartNumber != null">main_part_number = #{mainPartNumber},</if>
            <if test="mainPartDrawingNumber != null">main_part_drawing_number = #{mainPartDrawingNumber},</if>
            <if test="customer != null">customer = #{customer},</if>
            <if test="businessType != null">business_type = #{businessType},</if>
            <if test="documentNumber != null">document_number = #{documentNumber},</if>
            <if test="requirementType != null">requirement_type = #{requirementType},</if>
            <if test="documentStatus != null">document_status = #{documentStatus},</if>
            <if test="itemNumber != null">item_number = #{itemNumber},</if>
            <if test="drawingNo != null">drawing_no = #{drawingNo},</if>
            <if test="versionNumber != null">version_number = #{versionNumber},</if>
            <if test="productionQuantity != null">production_quantity = #{productionQuantity},</if>
            <if test="goodProductsQuantity != null">good_products_quantity = #{goodProductsQuantity},</if>
            <if test="processNumber != null">process_number = #{processNumber},</if>
            <if test="workCenter != null">work_center = #{workCenter},</if>
            <if test="department != null">department = #{department},</if>
            <if test="planStartDay != null">plan_start_day = #{planStartDay},</if>
            <if test="planEndDay != null">plan_end_day = #{planEndDay},</if>
            <if test="standbyNumber != null">standby_number = #{standbyNumber},</if>
            <if test="standbyName != null">standby_name = #{standbyName},</if>
            <if test="standbyStock != null">standby_stock = #{standbyStock},</if>
            <if test="nextProcessDeparment != null">next_process_deparment = #{nextProcessDeparment},</if>
            <if test="isSuspended != null">is_suspended = #{isSuspended},</if>
            <if test="isOutsourcing != null">is_outsourcing = #{isOutsourcing},</if>
            <if test="account != null">account = #{account},</if>
            <if test="advancedMaterials != null">advanced_materials = #{advancedMaterials},</if>
            <if test="advancedDocumentNumber != null">advanced_document_number = #{advancedDocumentNumber},</if>
            <if test="advancedRequirementDay != null">advanced_requirement_day = #{advancedRequirementDay},</if>
            <if test="isPlanComplete != null">is_plan_complete = #{isPlanComplete},</if>
            <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="batchNumber != null">batch_number = #{batchNumber},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteApsPlatePlanTempById" parameterType="String">
        delete from aps_plate_plan_temp where id = #{id}
    </delete>

    <delete id="deleteApsPlatePlanTempByIds" parameterType="String">
        delete from aps_plate_plan_temp where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>