气体管路相关

wenwj

2025-04-09 9616ac1d0297e009ba662ce061d8d42dc8238978

气体管路相关

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

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

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

import com.aps.common.core.utils.uuid.IdUtils;
import com.aps.common.security.utils.DictUtils;
import com.aps.core.domain.ApsGasPipingPlanTemp;
import com.aps.core.domain.ApsPartPlanTemp;
import com.aps.core.service.IApsGasPipingPlanTempService;
import com.aps.system.api.domain.SysDictData;
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.ApsGasPipingPlan;
import com.aps.core.service.IApsGasPipingPlanService;
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 wwj
 * @date 2025-04-09
 */
@RestController
@RequestMapping("/gasPiping")
public class ApsGasPipingPlanController extends BaseController
{
    @Autowired
    private IApsGasPipingPlanService apsGasPipingPlanService;
    @Autowired
    private IApsGasPipingPlanTempService apsGasPipingPlanTempService;
    /**
     * æŸ¥è¯¢æ°”体管路计划管理列表
     */
    @RequiresPermissions("gasPiping:gasPiping:list")
    @GetMapping("/list")
    public TableDataInfo list(ApsGasPipingPlan apsGasPipingPlan)
    {
//        startPage();
        List<ApsGasPipingPlan> list = apsGasPipingPlanService.selectApsGasPipingPlanList(apsGasPipingPlan);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ°”体管路计划管理列表
     */
    @RequiresPermissions("gasPiping:gasPiping:export")
    @Log(title = "气体管路计划管理", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ApsGasPipingPlan apsGasPipingPlan)
    {
        List<ApsGasPipingPlan> apsGasPipingPlans = apsGasPipingPlanService.selectApsGasPipingPlanList(apsGasPipingPlan);
        List<SysDictData> list = DictUtils.getDictCache("aps_is_suspended");
        for (int i = 0; i < apsGasPipingPlans.size(); i++) {
            for (int j = 0; j < list.size(); j++) {
                if (apsGasPipingPlans.get(i).getIsSuspended().equals(Integer.parseInt(list.get(j).getDictValue()))) {
                    apsGasPipingPlans.get(i).setIsSuspendedTxt(list.get(j).getDictLabel());
                    break;
                }
            }
        }
        ExcelUtil<ApsGasPipingPlan> util = new ExcelUtil<ApsGasPipingPlan>(ApsGasPipingPlan.class);
        util.exportExcel(response, apsGasPipingPlans, "气体管路计划管理数据");
    }

    /**
     * èŽ·å–气体管路计划管理详细信息
     */
    @RequiresPermissions("gasPiping:gasPiping:query")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") String id)
    {
        return success(apsGasPipingPlanService.selectApsGasPipingPlanById(id));
    }

    /**
     * æ–°å¢žæ°”体管路计划管理
     */
    @RequiresPermissions("gasPiping:gasPiping:add")
    @Log(title = "气体管路计划管理", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ApsGasPipingPlan apsGasPipingPlan)
    {
        return toAjax(apsGasPipingPlanService.insertApsGasPipingPlan(apsGasPipingPlan));
    }

    /**
     * ä¿®æ”¹æ°”体管路计划管理
     */
    @RequiresPermissions("gasPiping:gasPiping:edit")
    @Log(title = "气体管路计划管理", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ApsGasPipingPlan apsGasPipingPlan)
    {
        return toAjax(apsGasPipingPlanService.updateApsGasPipingPlan(apsGasPipingPlan));
    }

    /**
     * åˆ é™¤æ°”体管路计划管理
     */
    @RequiresPermissions("gasPiping:gasPiping:remove")
    @Log(title = "气体管路计划管理", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable String[] ids)
    {
        return toAjax(apsGasPipingPlanService.deleteApsGasPipingPlanByIds(ids));
    }
    /**
     * æ°”体管路计划导入
     */
    @PostMapping("/importData")
    public AjaxResult importData(MultipartFile file) throws Exception {
        ExcelUtil<ApsGasPipingPlanTemp> util = new ExcelUtil<ApsGasPipingPlanTemp>(ApsGasPipingPlanTemp.class);
        List<ApsGasPipingPlanTemp> apsGasPipingPlanTemps = util.importExcel(file.getInputStream());
        //判断导入数据是否为空
        if (apsGasPipingPlanTemps.size() > 0) {
            String batchNum= IdUtils.fastUUID();
            List<SysDictData> list = DictUtils.getDictCache("aps_is_suspended");
            for (int i = 0; i < apsGasPipingPlanTemps.size(); i++) {
                for (int j = 0; j < list.size(); j++) {
                    if (apsGasPipingPlanTemps.get(i).getIsSuspendedTxt().equals(list.get(j).getDictLabel())) {
                        apsGasPipingPlanTemps.get(i).setIsSuspended(Integer.parseInt(list.get(j).getDictValue()));
                        break;
                    }
                }
                //插入版本号
                apsGasPipingPlanTemps.get(i).setBatchNumber(batchNum);
                //插入临时表
                apsGasPipingPlanTempService.insertApsGasPipingPlanTemp(apsGasPipingPlanTemps.get(i));
            }
            return AjaxResult.success(batchNum);
        } else {
            return AjaxResult.error("模板内容为空");
        }
    }
    /***
     * @Description: ç¡®è®¤ä¸Šä¼ 
     * @Param: [apsPartPlan]
     * @return: com.aps.common.core.web.domain.AjaxResult
     * @Author: wwj
     * @Date: 2025/4/9
     */
    @GetMapping("/confirmGasPiping")
    public AjaxResult confirmGasPiping(ApsGasPipingPlanTemp apsGasPipingPlanTemp) {
        return toAjax(apsGasPipingPlanService.confirmGasPiping(apsGasPipingPlanTemp));
    }
}

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

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

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 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.ApsGasPipingPlanTemp;
import com.aps.core.service.IApsGasPipingPlanTempService;
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;

/**
 * æ°”体管路计划管理-临时Controller
 * 
 * @author wwj
 * @date 2025-04-09
 */
@RestController
@RequestMapping("/gasPipingTemp")
public class ApsGasPipingPlanTempController extends BaseController
{
    @Autowired
    private IApsGasPipingPlanTempService apsGasPipingPlanTempService;

    /**
     * æŸ¥è¯¢æ°”体管路计划管理-临时列表
     */
    @RequiresPermissions("gasPipingTemp:gasPipingTemp:list")
    @GetMapping("/list")
    public TableDataInfo list(ApsGasPipingPlanTemp apsGasPipingPlanTemp)
    {
//        startPage();
        List<ApsGasPipingPlanTemp> list = apsGasPipingPlanTempService.selectApsGasPipingPlanTempList(apsGasPipingPlanTemp);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ°”体管路计划管理-临时列表
     */
    @RequiresPermissions("gasPipingTemp:gasPipingTemp:export")
    @Log(title = "气体管路计划管理-临时", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ApsGasPipingPlanTemp apsGasPipingPlanTemp)
    {
        List<ApsGasPipingPlanTemp> list = apsGasPipingPlanTempService.selectApsGasPipingPlanTempList(apsGasPipingPlanTemp);
        ExcelUtil<ApsGasPipingPlanTemp> util = new ExcelUtil<ApsGasPipingPlanTemp>(ApsGasPipingPlanTemp.class);
        util.exportExcel(response, list, "气体管路计划管理-临时数据");
    }

    /**
     * èŽ·å–气体管路计划管理-临时详细信息
     */
    @RequiresPermissions("gasPipingTemp:gasPipingTemp:query")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") String id)
    {
        return success(apsGasPipingPlanTempService.selectApsGasPipingPlanTempById(id));
    }

    /**
     * æ–°å¢žæ°”体管路计划管理-临时
     */
    @RequiresPermissions("gasPipingTemp:gasPipingTemp:add")
    @Log(title = "气体管路计划管理-临时", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ApsGasPipingPlanTemp apsGasPipingPlanTemp)
    {
        return toAjax(apsGasPipingPlanTempService.insertApsGasPipingPlanTemp(apsGasPipingPlanTemp));
    }

    /**
     * ä¿®æ”¹æ°”体管路计划管理-临时
     */
    @RequiresPermissions("gasPipingTemp:gasPipingTemp:edit")
    @Log(title = "气体管路计划管理-临时", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ApsGasPipingPlanTemp apsGasPipingPlanTemp)
    {
        return toAjax(apsGasPipingPlanTempService.updateApsGasPipingPlanTemp(apsGasPipingPlanTemp));
    }

    /**
     * åˆ é™¤æ°”体管路计划管理-临时
     */
    @RequiresPermissions("gasPipingTemp:gasPipingTemp:remove")
    @Log(title = "气体管路计划管理-临时", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable String[] ids)
    {
        return toAjax(apsGasPipingPlanTempService.deleteApsGasPipingPlanTempByIds(ids));
    }
}

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

@@ -40,7 +40,7 @@
    @RequiresPermissions("partPlan:list")
    @GetMapping("/list")
    public TableDataInfo list(ApsPartPlan apsPartPlan) {
        startPage();
//        startPage();
        List<ApsPartPlan> list = apsPartPlanService.selectApsPartPlanList(apsPartPlan);
        return getDataTable(list);
    }
@@ -133,4 +133,18 @@
            return AjaxResult.error("模板内容为空");
        }
    }
    /***
    * @Description: ç¡®è®¤ä¸Šä¼ 
    * @Param: [apsPartPlan] 
    * @return: com.aps.common.core.web.domain.AjaxResult
    * @Author: wwj
    * @Date: 2025/4/9
    */
    @GetMapping("/confirmPart")
    public AjaxResult confirmPart(ApsPartPlanTemp apsPartPlanTemp) {
        return toAjax(apsPartPlanService.confirmPart(apsPartPlanTemp));
    }



}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,562 @@
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_gas_piping_plan
 * 
 * @author wwj
 * @date 2025-04-09
 */
public class ApsGasPipingPlan 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 = "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 isSuspendedTxt;
    /** å¤–协标识 */
    @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 Integer isPlanComplete;

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

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

    /** é£Žé™©æ ‡è¯† */
    @Excel(name = "风险标识")
    private Integer 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(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(Integer isPlanComplete)
    {
        this.isPlanComplete = isPlanComplete;
    }

    public Integer getIsPlanComplete()
    {
        return isPlanComplete;
    }

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

    public Integer getIsStockComplete()
    {
        return isStockComplete;
    }

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

    public Integer getHasTurnback()
    {
        return hasTurnback;
    }

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

    public Integer 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();
    }

    public String getIsSuspendedTxt() {
        return isSuspendedTxt;
    }

    public void setIsSuspendedTxt(String isSuspendedTxt) {
        this.isSuspendedTxt = isSuspendedTxt;
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,578 @@
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_gas_piping_plan_temp
 * 
 * @author wwj
 * @date 2025-04-09
 */
public class ApsGasPipingPlanTemp 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 = "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 isSuspendedTxt;
    /** å¤–协标识 */
    @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 Integer isPlanComplete;

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

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

    /** é£Žé™©æ ‡è¯† */
    @Excel(name = "风险标识")
    private Integer 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(Integer isPlanComplete)
    {
        this.isPlanComplete = isPlanComplete;
    }

    public Integer getIsPlanComplete()
    {
        return isPlanComplete;
    }

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

    public Integer getIsStockComplete()
    {
        return isStockComplete;
    }

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

    public Integer getHasTurnback()
    {
        return hasTurnback;
    }

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

    public Integer 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();
    }

    public String getIsSuspendedTxt() {
        return isSuspendedTxt;
    }

    public void setIsSuspendedTxt(String isSuspendedTxt) {
        this.isSuspendedTxt = isSuspendedTxt;
    }
}

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

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

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

/**
 * æ°”体管路计划管理Mapper接口
 * 
 * @author wwj
 * @date 2025-04-09
 */
@Mapper
public interface ApsGasPipingPlanMapper 
{
    /**
     * æŸ¥è¯¢æ°”体管路计划管理
     * 
     * @param id æ°”体管路计划管理主键
     * @return æ°”体管路计划管理
     */
    public ApsGasPipingPlan selectApsGasPipingPlanById(String id);

    /**
     * æŸ¥è¯¢æ°”体管路计划管理列表
     * 
     * @param apsGasPipingPlan æ°”体管路计划管理
     * @return æ°”体管路计划管理集合
     */
    public List<ApsGasPipingPlan> selectApsGasPipingPlanList(ApsGasPipingPlan apsGasPipingPlan);

    /**
     * æ–°å¢žæ°”体管路计划管理
     * 
     * @param apsGasPipingPlan æ°”体管路计划管理
     * @return ç»“æžœ
     */
    public int insertApsGasPipingPlan(ApsGasPipingPlan apsGasPipingPlan);

    /**
     * ä¿®æ”¹æ°”体管路计划管理
     * 
     * @param apsGasPipingPlan æ°”体管路计划管理
     * @return ç»“æžœ
     */
    public int updateApsGasPipingPlan(ApsGasPipingPlan apsGasPipingPlan);

    /**
     * åˆ é™¤æ°”体管路计划管理
     * 
     * @param id æ°”体管路计划管理主键
     * @return ç»“æžœ
     */
    public int deleteApsGasPipingPlanById(String id);

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

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

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

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

/**
 * æ°”体管路计划管理-临时Mapper接口
 * 
 * @author wwj
 * @date 2025-04-09
 */
@Mapper
public interface ApsGasPipingPlanTempMapper 
{
    /**
     * æŸ¥è¯¢æ°”体管路计划管理-临时
     * 
     * @param id æ°”体管路计划管理-临时主键
     * @return æ°”体管路计划管理-临时
     */
    public ApsGasPipingPlanTemp selectApsGasPipingPlanTempById(String id);

    /**
     * æŸ¥è¯¢æ°”体管路计划管理-临时列表
     * 
     * @param apsGasPipingPlanTemp æ°”体管路计划管理-临时
     * @return æ°”体管路计划管理-临时集合
     */
    public List<ApsGasPipingPlanTemp> selectApsGasPipingPlanTempList(ApsGasPipingPlanTemp apsGasPipingPlanTemp);

    /**
     * æ–°å¢žæ°”体管路计划管理-临时
     * 
     * @param apsGasPipingPlanTemp æ°”体管路计划管理-临时
     * @return ç»“æžœ
     */
    public int insertApsGasPipingPlanTemp(ApsGasPipingPlanTemp apsGasPipingPlanTemp);

    /**
     * ä¿®æ”¹æ°”体管路计划管理-临时
     * 
     * @param apsGasPipingPlanTemp æ°”体管路计划管理-临时
     * @return ç»“æžœ
     */
    public int updateApsGasPipingPlanTemp(ApsGasPipingPlanTemp apsGasPipingPlanTemp);

    /**
     * åˆ é™¤æ°”体管路计划管理-临时
     * 
     * @param id æ°”体管路计划管理-临时主键
     * @return ç»“æžœ
     */
    public int deleteApsGasPipingPlanTempById(String id);

    /**
     * æ‰¹é‡åˆ é™¤æ°”体管路计划管理-临时
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsGasPipingPlanTempByIds(String[] ids);
}

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

@@ -2,6 +2,7 @@

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

/**
 * é›¶ä»¶è®¡åˆ’管理临时Mapper接口
@@ -9,6 +10,7 @@
 * @author wwj
 * @date 2025-04-08
 */
@Mapper
public interface ApsPartPlanTempMapper 
{
    /**

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

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

import java.util.List;
import com.aps.core.domain.ApsGasPipingPlan;
import com.aps.core.domain.ApsGasPipingPlanTemp;

/**
 * æ°”体管路计划管理Service接口
 * 
 * @author wwj
 * @date 2025-04-09
 */
public interface IApsGasPipingPlanService 
{
    /**
     * æŸ¥è¯¢æ°”体管路计划管理
     * 
     * @param id æ°”体管路计划管理主键
     * @return æ°”体管路计划管理
     */
    public ApsGasPipingPlan selectApsGasPipingPlanById(String id);

    /**
     * æŸ¥è¯¢æ°”体管路计划管理列表
     * 
     * @param apsGasPipingPlan æ°”体管路计划管理
     * @return æ°”体管路计划管理集合
     */
    public List<ApsGasPipingPlan> selectApsGasPipingPlanList(ApsGasPipingPlan apsGasPipingPlan);

    /**
     * æ–°å¢žæ°”体管路计划管理
     * 
     * @param apsGasPipingPlan æ°”体管路计划管理
     * @return ç»“æžœ
     */
    public int insertApsGasPipingPlan(ApsGasPipingPlan apsGasPipingPlan);

    /**
     * ä¿®æ”¹æ°”体管路计划管理
     * 
     * @param apsGasPipingPlan æ°”体管路计划管理
     * @return ç»“æžœ
     */
    public int updateApsGasPipingPlan(ApsGasPipingPlan apsGasPipingPlan);

    /**
     * æ‰¹é‡åˆ é™¤æ°”体管路计划管理
     * 
     * @param ids éœ€è¦åˆ é™¤çš„气体管路计划管理主键集合
     * @return ç»“æžœ
     */
    public int deleteApsGasPipingPlanByIds(String[] ids);

    /**
     * åˆ é™¤æ°”体管路计划管理信息
     * 
     * @param id æ°”体管路计划管理主键
     * @return ç»“æžœ
     */
    public int deleteApsGasPipingPlanById(String id);

    int confirmGasPiping(ApsGasPipingPlanTemp apsGasPipingPlanTemp);
}

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

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

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

/**
 * æ°”体管路计划管理-临时Service接口
 * 
 * @author wwj
 * @date 2025-04-09
 */
public interface IApsGasPipingPlanTempService 
{
    /**
     * æŸ¥è¯¢æ°”体管路计划管理-临时
     * 
     * @param id æ°”体管路计划管理-临时主键
     * @return æ°”体管路计划管理-临时
     */
    public ApsGasPipingPlanTemp selectApsGasPipingPlanTempById(String id);

    /**
     * æŸ¥è¯¢æ°”体管路计划管理-临时列表
     * 
     * @param apsGasPipingPlanTemp æ°”体管路计划管理-临时
     * @return æ°”体管路计划管理-临时集合
     */
    public List<ApsGasPipingPlanTemp> selectApsGasPipingPlanTempList(ApsGasPipingPlanTemp apsGasPipingPlanTemp);

    /**
     * æ–°å¢žæ°”体管路计划管理-临时
     * 
     * @param apsGasPipingPlanTemp æ°”体管路计划管理-临时
     * @return ç»“æžœ
     */
    public int insertApsGasPipingPlanTemp(ApsGasPipingPlanTemp apsGasPipingPlanTemp);

    /**
     * ä¿®æ”¹æ°”体管路计划管理-临时
     * 
     * @param apsGasPipingPlanTemp æ°”体管路计划管理-临时
     * @return ç»“æžœ
     */
    public int updateApsGasPipingPlanTemp(ApsGasPipingPlanTemp apsGasPipingPlanTemp);

    /**
     * æ‰¹é‡åˆ é™¤æ°”体管路计划管理-临时
     * 
     * @param ids éœ€è¦åˆ é™¤çš„气体管路计划管理-临时主键集合
     * @return ç»“æžœ
     */
    public int deleteApsGasPipingPlanTempByIds(String[] ids);

    /**
     * åˆ é™¤æ°”体管路计划管理-临时信息
     * 
     * @param id æ°”体管路计划管理-临时主键
     * @return ç»“æžœ
     */
    public int deleteApsGasPipingPlanTempById(String id);
}

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

@@ -2,6 +2,7 @@

import java.util.List;
import com.aps.core.domain.ApsPartPlan;
import com.aps.core.domain.ApsPartPlanTemp;

/**
 * é›¶ä»¶è®¡åˆ’管理Service接口
@@ -58,4 +59,6 @@
     * @return ç»“æžœ
     */
    public int deleteApsPartPlanById(String id);

    int confirmPart(ApsPartPlanTemp apsPartPlanTemp);
}

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

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

import java.util.List;

import com.aps.common.core.utils.uuid.IdUtils;
import com.aps.core.domain.ApsGasPipingPlanTemp;
import com.aps.core.domain.ApsPartPlan;
import com.aps.core.domain.ApsPartPlanTemp;
import com.aps.core.mapper.ApsGasPipingPlanTempMapper;
import com.aps.core.mapper.ApsPartPlanMapper;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.aps.core.mapper.ApsGasPipingPlanMapper;
import com.aps.core.domain.ApsGasPipingPlan;
import com.aps.core.service.IApsGasPipingPlanService;

/**
 * æ°”体管路计划管理Service业务层处理
 * 
 * @author wwj
 * @date 2025-04-09
 */
@Service
public class ApsGasPipingPlanServiceImpl implements IApsGasPipingPlanService 
{
    @Autowired
    private ApsGasPipingPlanMapper apsGasPipingPlanMapper;
    @Autowired
    private ApsGasPipingPlanTempMapper apsGasPipingPlanTempMapper;

    /**
     * æŸ¥è¯¢æ°”体管路计划管理
     * 
     * @param id æ°”体管路计划管理主键
     * @return æ°”体管路计划管理
     */
    @Override
    public ApsGasPipingPlan selectApsGasPipingPlanById(String id)
    {
        return apsGasPipingPlanMapper.selectApsGasPipingPlanById(id);
    }

    /**
     * æŸ¥è¯¢æ°”体管路计划管理列表
     * 
     * @param apsGasPipingPlan æ°”体管路计划管理
     * @return æ°”体管路计划管理
     */
    @Override
    public List<ApsGasPipingPlan> selectApsGasPipingPlanList(ApsGasPipingPlan apsGasPipingPlan)
    {
        return apsGasPipingPlanMapper.selectApsGasPipingPlanList(apsGasPipingPlan);
    }

    /**
     * æ–°å¢žæ°”体管路计划管理
     * 
     * @param apsGasPipingPlan æ°”体管路计划管理
     * @return ç»“æžœ
     */
    @Override
    public int insertApsGasPipingPlan(ApsGasPipingPlan apsGasPipingPlan)
    {
        apsGasPipingPlan.setId(IdUtils.fastUUID());
        return apsGasPipingPlanMapper.insertApsGasPipingPlan(apsGasPipingPlan);
    }

    /**
     * ä¿®æ”¹æ°”体管路计划管理
     * 
     * @param apsGasPipingPlan æ°”体管路计划管理
     * @return ç»“æžœ
     */
    @Override
    public int updateApsGasPipingPlan(ApsGasPipingPlan apsGasPipingPlan)
    {
        return apsGasPipingPlanMapper.updateApsGasPipingPlan(apsGasPipingPlan);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ°”体管路计划管理
     * 
     * @param ids éœ€è¦åˆ é™¤çš„气体管路计划管理主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsGasPipingPlanByIds(String[] ids)
    {
        return apsGasPipingPlanMapper.deleteApsGasPipingPlanByIds(ids);
    }

    /**
     * åˆ é™¤æ°”体管路计划管理信息
     * 
     * @param id æ°”体管路计划管理主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsGasPipingPlanById(String id)
    {
        return apsGasPipingPlanMapper.deleteApsGasPipingPlanById(id);
    }

    @Override
    public int confirmGasPiping(ApsGasPipingPlanTemp apsGasPipingPlanTemp) {
        //查询临时表数据
        List<ApsGasPipingPlanTemp> apsGasPipingPlanTemps=apsGasPipingPlanTempMapper.selectApsGasPipingPlanTempList(apsGasPipingPlanTemp);
        int count=0;
        String[] ids=new String[apsGasPipingPlanTemps.size()];
        for (int i = 0; i <apsGasPipingPlanTemps.size() ; i++) {
            //记录临时表id
            ids[i]=apsGasPipingPlanTemps.get(i).getId();
            ApsGasPipingPlan apsGasPipingPlan=new ApsGasPipingPlan();
            BeanUtils.copyProperties(apsGasPipingPlanTemps.get(i), apsGasPipingPlan);
            apsGasPipingPlan.setId(IdUtils.fastUUID());
            //插入正式表，并记录
            apsGasPipingPlanMapper.insertApsGasPipingPlan(apsGasPipingPlan);
            count++;
        }
        //插入数量与临时表查询一直则删除临时表数据
        if (count==apsGasPipingPlanTemps.size()) {
            apsGasPipingPlanTempMapper.deleteApsGasPipingPlanTempByIds(ids);
        }
        return 0;
    }
}

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

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

import java.util.List;

import com.aps.common.core.utils.uuid.IdUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.aps.core.mapper.ApsGasPipingPlanTempMapper;
import com.aps.core.domain.ApsGasPipingPlanTemp;
import com.aps.core.service.IApsGasPipingPlanTempService;

/**
 * æ°”体管路计划管理-临时Service业务层处理
 * 
 * @author wwj
 * @date 2025-04-09
 */
@Service
public class ApsGasPipingPlanTempServiceImpl implements IApsGasPipingPlanTempService 
{
    @Autowired
    private ApsGasPipingPlanTempMapper apsGasPipingPlanTempMapper;

    /**
     * æŸ¥è¯¢æ°”体管路计划管理-临时
     * 
     * @param id æ°”体管路计划管理-临时主键
     * @return æ°”体管路计划管理-临时
     */
    @Override
    public ApsGasPipingPlanTemp selectApsGasPipingPlanTempById(String id)
    {
        return apsGasPipingPlanTempMapper.selectApsGasPipingPlanTempById(id);
    }

    /**
     * æŸ¥è¯¢æ°”体管路计划管理-临时列表
     * 
     * @param apsGasPipingPlanTemp æ°”体管路计划管理-临时
     * @return æ°”体管路计划管理-临时
     */
    @Override
    public List<ApsGasPipingPlanTemp> selectApsGasPipingPlanTempList(ApsGasPipingPlanTemp apsGasPipingPlanTemp)
    {
        return apsGasPipingPlanTempMapper.selectApsGasPipingPlanTempList(apsGasPipingPlanTemp);
    }

    /**
     * æ–°å¢žæ°”体管路计划管理-临时
     * 
     * @param apsGasPipingPlanTemp æ°”体管路计划管理-临时
     * @return ç»“æžœ
     */
    @Override
    public int insertApsGasPipingPlanTemp(ApsGasPipingPlanTemp apsGasPipingPlanTemp)
    {
        apsGasPipingPlanTemp.setId(IdUtils.fastUUID());
        return apsGasPipingPlanTempMapper.insertApsGasPipingPlanTemp(apsGasPipingPlanTemp);
    }

    /**
     * ä¿®æ”¹æ°”体管路计划管理-临时
     * 
     * @param apsGasPipingPlanTemp æ°”体管路计划管理-临时
     * @return ç»“æžœ
     */
    @Override
    public int updateApsGasPipingPlanTemp(ApsGasPipingPlanTemp apsGasPipingPlanTemp)
    {
        return apsGasPipingPlanTempMapper.updateApsGasPipingPlanTemp(apsGasPipingPlanTemp);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ°”体管路计划管理-临时
     * 
     * @param ids éœ€è¦åˆ é™¤çš„气体管路计划管理-临时主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsGasPipingPlanTempByIds(String[] ids)
    {
        return apsGasPipingPlanTempMapper.deleteApsGasPipingPlanTempByIds(ids);
    }

    /**
     * åˆ é™¤æ°”体管路计划管理-临时信息
     * 
     * @param id æ°”体管路计划管理-临时主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsGasPipingPlanTempById(String id)
    {
        return apsGasPipingPlanTempMapper.deleteApsGasPipingPlanTempById(id);
    }
}

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

@@ -3,6 +3,10 @@
import java.util.List;

import com.aps.common.core.utils.uuid.IdUtils;
import com.aps.core.domain.ApsPartPlanTemp;
import com.aps.core.mapper.ApsPartPlanTempMapper;
import org.checkerframework.checker.units.qual.A;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.aps.core.mapper.ApsPartPlanMapper;
@@ -20,6 +24,8 @@
{
    @Autowired
    private ApsPartPlanMapper apsPartPlanMapper;
    @Autowired
    private ApsPartPlanTempMapper apsPartPlanTempMapper;

    /**
     * æŸ¥è¯¢é›¶ä»¶è®¡åˆ’管理
@@ -93,4 +99,27 @@
    {
        return apsPartPlanMapper.deleteApsPartPlanById(id);
    }

    @Override
    public int confirmPart(ApsPartPlanTemp apsPartPlanTemp) {
        //查询临时表数据
        List<ApsPartPlanTemp> apsPartPlanTemps=apsPartPlanTempMapper.selectApsPartPlanTempList(apsPartPlanTemp);
        int count=0;
        String[] ids=new String[apsPartPlanTemps.size()];
        for (int i = 0; i <apsPartPlanTemps.size() ; i++) {
            //记录临时表id
            ids[i]=apsPartPlanTemps.get(i).getId();
            ApsPartPlan apsPartPlan=new ApsPartPlan();
            BeanUtils.copyProperties(apsPartPlanTemps.get(i), apsPartPlan);
            apsPartPlan.setId(IdUtils.fastUUID());
            //插入正式表，并记录
            apsPartPlanMapper.insertApsPartPlan(apsPartPlan);
            count++;
        }
        //插入数量与临时表查询一直则删除临时表数据
        if (count==apsPartPlanTemps.size()) {
            apsPartPlanTempMapper.deleteApsPartPlanTempByIds(ids);
        }
        return 1;
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,219 @@
<?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.ApsGasPipingPlanMapper">
    
    <resultMap type="ApsGasPipingPlan" id="ApsGasPipingPlanResult">
        <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="selectApsGasPipingPlanVo">
        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_gas_piping_plan
    </sql>

    <select id="selectApsGasPipingPlanList" parameterType="ApsGasPipingPlan" resultMap="ApsGasPipingPlanResult">
        <include refid="selectApsGasPipingPlanVo"/>
        <where>  
            <if test="masterPlanner != null  and masterPlanner != ''"> and master_planner like concat('%', #{masterPlanner}, '%')</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 = #{documentNumber}</if>
            <if test="requirementType != null  and requirementType != ''"> and requirement_type = #{requirementType}</if>
            <if test="documentStatus != null  and documentStatus != ''"> and document_status = #{documentStatus}</if>
            <if test="itemNumber != null  and itemNumber != ''"> and item_number = #{itemNumber}</if>
            <if test="drawingNo != null  and drawingNo != ''"> and drawing_no = #{drawingNo}</if>
            <if test="versionNumber != null  and versionNumber != ''"> and version_number = #{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 = #{processNumber}</if>
            <if test="workCenter != null  and workCenter != ''"> and work_center = #{workCenter}</if>
            <if test="department != null  and department != ''"> and department = #{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 = #{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 = #{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>
        </where>
    </select>
    
    <select id="selectApsGasPipingPlanById" parameterType="String" resultMap="ApsGasPipingPlanResult">
        <include refid="selectApsGasPipingPlanVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsGasPipingPlan" parameterType="ApsGasPipingPlan">
        insert into aps_gas_piping_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="updateApsGasPipingPlan" parameterType="ApsGasPipingPlan">
        update aps_gas_piping_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="deleteApsGasPipingPlanById" parameterType="String">
        delete from aps_gas_piping_plan where id = #{id}
    </delete>

    <delete id="deleteApsGasPipingPlanByIds" parameterType="String">
        delete from aps_gas_piping_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/ApsGasPipingPlanTempMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,194 @@
<?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.ApsGasPipingPlanTempMapper">
    
    <resultMap type="ApsGasPipingPlanTemp" id="ApsGasPipingPlanTempResult">
        <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="selectApsGasPipingPlanTempVo">
        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_gas_piping_plan_temp
    </sql>

    <select id="selectApsGasPipingPlanTempList" parameterType="ApsGasPipingPlanTemp" resultMap="ApsGasPipingPlanTempResult">
        <include refid="selectApsGasPipingPlanTempVo"/>
        <where>  
            <if test="batchNumber != null  and batchNumber != ''"> and batch_number = #{batchNumber}</if>
        </where>
    </select>
    
    <select id="selectApsGasPipingPlanTempById" parameterType="String" resultMap="ApsGasPipingPlanTempResult">
        <include refid="selectApsGasPipingPlanTempVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsGasPipingPlanTemp" parameterType="ApsGasPipingPlanTemp">
        insert into aps_gas_piping_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="updateApsGasPipingPlanTemp" parameterType="ApsGasPipingPlanTemp">
        update aps_gas_piping_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="deleteApsGasPipingPlanTempById" parameterType="String">
        delete from aps_gas_piping_plan_temp where id = #{id}
    </delete>

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