From 9616ac1d0297e009ba662ce061d8d42dc8238978 Mon Sep 17 00:00:00 2001 From: wenwj <‘1106994300@qq.com> Date: 星期三, 09 四月 2025 11:02:55 +0800 Subject: [PATCH] 气体管路相关 --- aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPartPlanController.java | 16 aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsGasPipingPlanTempController.java | 106 ++ aps-modules/aps-core/src/main/java/com/aps/core/service/IApsGasPipingPlanService.java | 64 + aps-modules/aps-core/src/main/java/com/aps/core/service/IApsGasPipingPlanTempService.java | 61 + aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingPlanTempServiceImpl.java | 96 ++ aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPartPlanServiceImpl.java | 29 aps-modules/aps-core/src/main/resources/mapper/core/ApsGasPipingPlanMapper.xml | 219 +++++ aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingPlanTempMapper.java | 63 + aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingPlanMapper.java | 63 + aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsGasPipingPlan.java | 562 ++++++++++++++ aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingPlanServiceImpl.java | 127 +++ aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsGasPipingPlanTemp.java | 578 ++++++++++++++ aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPartPlanService.java | 3 aps-modules/aps-core/src/main/resources/mapper/core/ApsGasPipingPlanTempMapper.xml | 194 ++++ aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsGasPipingPlanController.java | 162 ++++ aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPartPlanTempMapper.java | 2 16 files changed, 2,344 insertions(+), 1 deletions(-) diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsGasPipingPlanController.java b/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsGasPipingPlanController.java new file mode 100644 index 0000000..c6f46c5 --- /dev/null +++ b/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)); + } +} diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsGasPipingPlanTempController.java b/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsGasPipingPlanTempController.java new file mode 100644 index 0000000..ace3f71 --- /dev/null +++ b/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)); + } +} diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPartPlanController.java b/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPartPlanController.java index d2da88b..ec9ac29 100644 --- a/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPartPlanController.java +++ b/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)); + } + + + } diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsGasPipingPlan.java b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsGasPipingPlan.java new file mode 100644 index 0000000..4840382 --- /dev/null +++ b/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; + } +} diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsGasPipingPlanTemp.java b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsGasPipingPlanTemp.java new file mode 100644 index 0000000..0aed841 --- /dev/null +++ b/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; + } +} diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingPlanMapper.java b/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingPlanMapper.java new file mode 100644 index 0000000..396974b --- /dev/null +++ b/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); +} diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingPlanTempMapper.java b/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingPlanTempMapper.java new file mode 100644 index 0000000..38137ee --- /dev/null +++ b/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); +} diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPartPlanTempMapper.java b/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPartPlanTempMapper.java index acb74c4..152d8cf 100644 --- a/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPartPlanTempMapper.java +++ b/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 { /** diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/IApsGasPipingPlanService.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/IApsGasPipingPlanService.java new file mode 100644 index 0000000..8974a79 --- /dev/null +++ b/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); +} diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/IApsGasPipingPlanTempService.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/IApsGasPipingPlanTempService.java new file mode 100644 index 0000000..0020c0d --- /dev/null +++ b/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); +} diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPartPlanService.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPartPlanService.java index 8dd27bd..2d82a66 100644 --- a/aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPartPlanService.java +++ b/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); } diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingPlanServiceImpl.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingPlanServiceImpl.java new file mode 100644 index 0000000..06b97cd --- /dev/null +++ b/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++) { + //璁板綍涓存椂琛╥d + ids[i]=apsGasPipingPlanTemps.get(i).getId(); + ApsGasPipingPlan apsGasPipingPlan=new ApsGasPipingPlan(); + BeanUtils.copyProperties(apsGasPipingPlanTemps.get(i), apsGasPipingPlan); + apsGasPipingPlan.setId(IdUtils.fastUUID()); + //鎻掑叆姝e紡琛紝骞惰褰� + apsGasPipingPlanMapper.insertApsGasPipingPlan(apsGasPipingPlan); + count++; + } + //鎻掑叆鏁伴噺涓庝复鏃惰〃鏌ヨ涓�鐩村垯鍒犻櫎涓存椂琛ㄦ暟鎹� + if (count==apsGasPipingPlanTemps.size()) { + apsGasPipingPlanTempMapper.deleteApsGasPipingPlanTempByIds(ids); + } + return 0; + } +} diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingPlanTempServiceImpl.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingPlanTempServiceImpl.java new file mode 100644 index 0000000..e2a35d3 --- /dev/null +++ b/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); + } +} diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPartPlanServiceImpl.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPartPlanServiceImpl.java index 9b209a0..842b6d3 100644 --- a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPartPlanServiceImpl.java +++ b/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++) { + //璁板綍涓存椂琛╥d + ids[i]=apsPartPlanTemps.get(i).getId(); + ApsPartPlan apsPartPlan=new ApsPartPlan(); + BeanUtils.copyProperties(apsPartPlanTemps.get(i), apsPartPlan); + apsPartPlan.setId(IdUtils.fastUUID()); + //鎻掑叆姝e紡琛紝骞惰褰� + apsPartPlanMapper.insertApsPartPlan(apsPartPlan); + count++; + } + //鎻掑叆鏁伴噺涓庝复鏃惰〃鏌ヨ涓�鐩村垯鍒犻櫎涓存椂琛ㄦ暟鎹� + if (count==apsPartPlanTemps.size()) { + apsPartPlanTempMapper.deleteApsPartPlanTempByIds(ids); + } + return 1; + } } diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsGasPipingPlanMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsGasPipingPlanMapper.xml new file mode 100644 index 0000000..cd3e848 --- /dev/null +++ b/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> \ No newline at end of file diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsGasPipingPlanTempMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsGasPipingPlanTempMapper.xml new file mode 100644 index 0000000..10bc513 --- /dev/null +++ b/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> \ No newline at end of file -- Gitblit v1.9.3