资源池管理

bluejay

2025-04-10 e011e3415512137e83c9c4533cb792ae1cf90ef9

资源池管理

 aps-modules/aps-core/pom.xml

@@ -90,6 +90,11 @@
            <groupId>com.aps</groupId>
            <artifactId>aps-common-swagger</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <scope>provided</scope>
        </dependency>
    </dependencies>

    <build>

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

@@ -12,6 +12,7 @@
import com.aps.core.domain.ApsPlatePlan;
import com.aps.core.domain.ApsPlatePlanTemp;
import com.aps.core.service.IApsPlatePlanService;
import com.aps.core.service.IApsPlatePlanTempService;
import com.aps.system.api.domain.SysDictData;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
@@ -32,7 +33,8 @@
public class ApsPlatePlanController extends BaseController {
    @Autowired
    private IApsPlatePlanService apsPlatePlanService;

    @Autowired
    private IApsPlatePlanTempService apsPlatePlanTempService;
    /**
     * æŸ¥è¯¢é’£é‡‘计划管理列表
     */
@@ -61,7 +63,7 @@
    /**
     * å¯¼å‡ºé’£é‡‘计划管理列表
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:export")
//    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:export")
    @Log(title = "钣金计划管理", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ApsPlatePlan apsPlatePlan) {
@@ -102,7 +104,7 @@
    /**
     * èŽ·å–钣金计划管理详细信息
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:query")
//    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:query")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") String id) {
        return success(apsPlatePlanService.selectApsPlatePlanById(id));
@@ -111,7 +113,7 @@
    /**
     * æ–°å¢žé’£é‡‘计划管理
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:add")
//    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:add")
    @Log(title = "钣金计划管理", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ApsPlatePlan apsPlatePlan) {
@@ -121,7 +123,7 @@
    /**
     * ä¿®æ”¹é’£é‡‘计划管理
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:edit")
//    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:edit")
    @Log(title = "钣金计划管理", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ApsPlatePlan apsPlatePlan) {
@@ -131,7 +133,7 @@
    /**
     * åˆ é™¤é’£é‡‘计划管理
     */
    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:remove")
//    @RequiresPermissions("ApsPlatePlan:ApsPlatePlan:remove")
    @Log(title = "钣金计划管理", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable String[] ids) {
@@ -165,4 +167,13 @@
    public AjaxResult confirmPart(ApsPlatePlanTemp planTemp) {
        return toAjax(apsPlatePlanService.confirmPlan(planTemp));
    }
    /**
     * æŸ¥è¯¢é’£é‡‘计划临时表列表
     */
    @GetMapping("/queryTempPlan")
    public TableDataInfo list(ApsPlatePlanTemp apsPlatePlanTemp)
    {
        List<ApsPlatePlanTemp> list = apsPlatePlanTempService.selectApsPlatePlanTempList(apsPlatePlanTemp);
        return getDataTable(list);
    }
}

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

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

import com.aps.common.core.utils.poi.ExcelUtil;
import com.aps.common.core.web.controller.BaseController;
import com.aps.common.core.web.domain.AjaxResult;
import com.aps.common.core.web.page.TableDataInfo;
import com.aps.common.log.annotation.Log;
import com.aps.common.log.enums.BusinessType;
import com.aps.core.domain.ApsResourceGroup;
import com.aps.core.domain.ApsResourceGroupTemp;
import com.aps.core.param.ApsResourceGroupParam;
import com.aps.core.service.IApsResourceGroupService;
import com.aps.core.service.IApsResourceGroupTempService;
import jakarta.annotation.Resource;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import java.time.format.DateTimeFormatter;
import java.util.List;

/**
 * èµ„源组Controller
 * 
 * @author ruoyi
 * &#064;date  2025-04-10
 */
@RestController
@RequestMapping("/ApsResourceGroup")
public class ApsResourceGroupController extends BaseController
{
    @Resource
    private IApsResourceGroupService apsResourceGroupService;
    @Resource
    private IApsResourceGroupTempService apsResourceGroupTempService;

    /**
     * æŸ¥è¯¢èµ„源组列表
     */
    /*@RequiresPermissions("ApsResourceGroup:list")*/
    @GetMapping("/list")
    public TableDataInfo list(ApsResourceGroupParam apsResourceGroup)
    {
        //startPage();
        List<ApsResourceGroup> list = apsResourceGroupService.selectApsResourceGroupList(apsResourceGroup);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºèµ„源组列表
     */
    /*@RequiresPermissions("ApsResourceGroup:ApsResourceGroup:export")*/
    @Log(title = "资源组", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ApsResourceGroupParam apsResourceGroup)
    {
        List<ApsResourceGroup> list = apsResourceGroupService.selectApsResourceGroupList(apsResourceGroup);
        ExcelUtil<ApsResourceGroup> util = new ExcelUtil<>(ApsResourceGroup.class);
        util.exportExcel(response, list, "资源组数据");
    }

    /**
     * èŽ·å–资源组详细信息
     */
   /* @RequiresPermissions("ApsResourceGroup:ApsResourceGroup:query")*/
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") String id)
    {
        return success(apsResourceGroupService.selectApsResourceGroupById(id));
    }

    /**
     * æ–°å¢žèµ„源组
     */
   /* @RequiresPermissions("ApsResourceGroup:ApsResourceGroup:add")*/
    @Log(title = "资源组", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ApsResourceGroup apsResourceGroup)
    {
        return toAjax(apsResourceGroupService.insertApsResourceGroup(apsResourceGroup));
    }

    /**
     * ä¿®æ”¹èµ„源组
     */
    /*@RequiresPermissions("ApsResourceGroup:ApsResourceGroup:edit")*/
    @Log(title = "资源组", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ApsResourceGroup apsResourceGroup)
    {
        return toAjax(apsResourceGroupService.updateApsResourceGroup(apsResourceGroup));
    }

    /**
     * åˆ é™¤èµ„源组
     */
    /*@RequiresPermissions("ApsResourceGroup:ApsResourceGroup:remove")*/
    @Log(title = "资源组", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable String[] ids)
    {
        return toAjax(apsResourceGroupService.deleteApsResourceGroupByIds(ids));
    }
    @GetMapping("/tempList")
    public TableDataInfo tempList(ApsResourceGroupTemp apsResourceGroupTemp)
    {
        //startPage();
        apsResourceGroupTemp.setDelFlag("1");
        List<ApsResourceGroupTemp> list = apsResourceGroupTempService.selectApsResourceGroupTempList(apsResourceGroupTemp);
        return getDataTable(list);
    }
    /**
     * å¯¼å…¥èµ„源组
     */
    @PostMapping("/importData")
    public AjaxResult importData(MultipartFile file) throws Exception {
        ExcelUtil<ApsResourceGroupTemp> util = new ExcelUtil<>(ApsResourceGroupTemp.class);
        List<ApsResourceGroupTemp> tempList = util.importExcel(file.getInputStream());
        //判断导入数据是否为空
        if (!tempList.isEmpty()) {
            String batchNum = apsResourceGroupService.importData(tempList);
            return AjaxResult.success("导入成功！",batchNum);
        } else {
            return AjaxResult.error("模板内容为空");
        }
    }
    /**
     * ç¡®è®¤æ•°æ®
     */
    @PostMapping("/confirmData")
    public AjaxResult confirmData(@RequestBody ApsResourceGroupTemp temp) {

        apsResourceGroupService.confirmData(temp.getBatchNumber(),temp.getRequestDate());
        return AjaxResult.success("确认成功！");
    }
}

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

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

import com.aps.common.core.utils.poi.ExcelUtil;
import com.aps.common.core.web.controller.BaseController;
import com.aps.common.core.web.domain.AjaxResult;
import com.aps.common.core.web.page.TableDataInfo;
import com.aps.common.log.annotation.Log;
import com.aps.common.log.enums.BusinessType;
import com.aps.common.security.annotation.RequiresPermissions;
import com.aps.core.domain.ApsResourceGroupTemp;
import com.aps.core.service.IApsResourceGroupTempService;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

/**
 * èµ„源组临时上传Controller
 * 
 * @author ruoyi
 * @date 2025-04-10
 */
@RestController
@RequestMapping("/ApsResourceGroupTemp")
public class ApsResourceGroupTempController extends BaseController
{
    @Autowired
    private IApsResourceGroupTempService apsResourceGroupTempService;

    /**
     * æŸ¥è¯¢èµ„源组临时上传列表
     */
//    @RequiresPermissions("ApsResourceGroupTemp:ApsResourceGroupTemp:list")
    @GetMapping("/list")
    public TableDataInfo list(ApsResourceGroupTemp apsResourceGroupTemp)
    {
        startPage();
        List<ApsResourceGroupTemp> list = apsResourceGroupTempService.selectApsResourceGroupTempList(apsResourceGroupTemp);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºèµ„源组临时上传列表
     */
//    @RequiresPermissions("ApsResourceGroupTemp:ApsResourceGroupTemp:export")
    @Log(title = "资源组临时上传", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ApsResourceGroupTemp apsResourceGroupTemp)
    {
        List<ApsResourceGroupTemp> list = apsResourceGroupTempService.selectApsResourceGroupTempList(apsResourceGroupTemp);
        ExcelUtil<ApsResourceGroupTemp> util = new ExcelUtil<ApsResourceGroupTemp>(ApsResourceGroupTemp.class);
        util.exportExcel(response, list, "资源组临时上传数据");
    }

    /**
     * èŽ·å–资源组临时上传详细信息
     */
//    @RequiresPermissions("ApsResourceGroupTemp:ApsResourceGroupTemp:query")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") String id)
    {
        return success(apsResourceGroupTempService.selectApsResourceGroupTempById(id));
    }

    /**
     * æ–°å¢žèµ„源组临时上传
     */
//    @RequiresPermissions("ApsResourceGroupTemp:ApsResourceGroupTemp:add")
    @Log(title = "资源组临时上传", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ApsResourceGroupTemp apsResourceGroupTemp)
    {
        return toAjax(apsResourceGroupTempService.insertApsResourceGroupTemp(apsResourceGroupTemp));
    }

    /**
     * ä¿®æ”¹èµ„源组临时上传
     */
//    @RequiresPermissions("ApsResourceGroupTemp:ApsResourceGroupTemp:edit")
    @Log(title = "资源组临时上传", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ApsResourceGroupTemp apsResourceGroupTemp)
    {
        return toAjax(apsResourceGroupTempService.updateApsResourceGroupTemp(apsResourceGroupTemp));
    }

    /**
     * åˆ é™¤èµ„源组临时上传
     */
//    @RequiresPermissions("ApsResourceGroupTemp:ApsResourceGroupTemp:remove")
    @Log(title = "资源组临时删除", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable String[] ids)
    {
        return toAjax(apsResourceGroupTempService.deleteApsResourceGroupTempByIds(ids));
    }
}

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

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

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.aps.common.core.annotation.Excel;
import com.aps.common.core.web.domain.BaseEntity;

import java.time.LocalDateTime;

/**
 * èµ„源组对象 aps_resource_group
 * 
 * @author ruoyi
 * @date 2025-04-10
 */
public class ApsResourceGroup extends BaseEntity
{
    private static final long serialVersionUID = 1L;

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

    /** èµ„源组名称 */
    @Excel(name = "资源组名称")
    private String resourceGroupName;

    /** è®¾å¤‡æ•°é‡ */
    @Excel(name = "设备数量")
    private Long devicesQuantity;

    /** æ¯æ—¥ç†è®ºæ—¶é—´ */
    @Excel(name = "每日理论时间")
    private Long theoryHours;

    /** æˆªæ­¢éœ€æ±‚日剩余天数  */
    @Excel(name = "截止需求日剩余天数 ")
    private Long restDays;

    /** ç†è®ºäº§èƒ½ */
    @Excel(name = "理论产能")
    private Long theoryCapacity;

    /** æœºåŠ éœ€æ±‚日期 */
    @Excel(name = "机加需求日期")
    private LocalDateTime requestDate;

    /** åˆ é™¤æ ‡å¿—（0代表存在 2代表删除） */
    private String delFlag;

    /** å·¥åŽ‚ */
    @Excel(name = "工厂")
    private String plant;

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

    public String getId() 
    {
        return id;
    }

    public void setResourceGroupName(String resourceGroupName) 
    {
        this.resourceGroupName = resourceGroupName;
    }

    public String getResourceGroupName() 
    {
        return resourceGroupName;
    }

    public void setDevicesQuantity(Long devicesQuantity) 
    {
        this.devicesQuantity = devicesQuantity;
    }

    public Long getDevicesQuantity() 
    {
        return devicesQuantity;
    }

    public void setTheoryHours(Long theoryHours) 
    {
        this.theoryHours = theoryHours;
    }

    public Long getTheoryHours() 
    {
        return theoryHours;
    }

    public void setRestDays(Long restDays) 
    {
        this.restDays = restDays;
    }

    public Long getRestDays() 
    {
        return restDays;
    }

    public void setTheoryCapacity(Long theoryCapacity) 
    {
        this.theoryCapacity = theoryCapacity;
    }

    public Long getTheoryCapacity() 
    {
        return theoryCapacity;
    }

    public void setRequestDate(LocalDateTime requestDate)
    {
        this.requestDate = requestDate;
    }

    public LocalDateTime getRequestDate()
    {
        return requestDate;
    }

    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }

    public void setPlant(String plant) 
    {
        this.plant = plant;
    }

    public String getPlant() 
    {
        return plant;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("resourceGroupName", getResourceGroupName())
            .append("devicesQuantity", getDevicesQuantity())
            .append("theoryHours", getTheoryHours())
            .append("restDays", getRestDays())
            .append("theoryCapacity", getTheoryCapacity())
            .append("requestDate", getRequestDate())
            .append("delFlag", getDelFlag())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("plant", getPlant())
            .toString();
    }
}

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

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

import com.fasterxml.jackson.annotation.JsonFormat;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.aps.common.core.annotation.Excel;
import com.aps.common.core.web.domain.BaseEntity;

import java.time.LocalDateTime;

/**
 * èµ„源组临时上传对象 aps_resource_group_temp
 * 
 * @author ruoyi
 * @date 2025-04-10
 */

public class ApsResourceGroupTemp extends BaseEntity
{
    private static final long serialVersionUID = 1L;

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

    /** èµ„源组名称 */
    @Excel(name = "资源组")
    private String resourceGroupName;

    /** è®¾å¤‡æ•°é‡ */
    @Excel(name = "设备数量")
    private Long devicesQuantity;

    /** æ¯æ—¥ç†è®ºæ—¶é—´ */
    @Excel(name = "每日理论时间")
    private Long theoryHours;

    /** æˆªæ­¢éœ€æ±‚日剩余天数  */
    @Excel(name = "截止需求日剩余天数")
    private Long restDays;

    /** ç†è®ºäº§èƒ½ */
    @Excel(name = "理论产能")
    private Long theoryCapacity;

    /** æœºåŠ éœ€æ±‚日期 */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @Excel(name = "机加需求日期")
    private LocalDateTime requestDate;

    /** æ‰¹æ¬¡å· */
    @Excel(name = "批次号")
    private String batchNumber;
    /** åˆ é™¤æ ‡å¿—（0代表存在 2代表删除） */
    private String delFlag;

    /** å·¥åŽ‚ */
    //@Excel(name = "工厂")
    private String plant;

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

    public String getId() 
    {
        return id;
    }

    public void setResourceGroupName(String resourceGroupName) 
    {
        this.resourceGroupName = resourceGroupName;
    }

    public String getResourceGroupName() 
    {
        return resourceGroupName;
    }

    public void setDevicesQuantity(Long devicesQuantity) 
    {
        this.devicesQuantity = devicesQuantity;
    }

    public Long getDevicesQuantity() 
    {
        return devicesQuantity;
    }

    public void setTheoryHours(Long theoryHours) 
    {
        this.theoryHours = theoryHours;
    }

    public Long getTheoryHours() 
    {
        return theoryHours;
    }

    public void setRestDays(Long restDays) 
    {
        this.restDays = restDays;
    }

    public Long getRestDays() 
    {
        return restDays;
    }

    public void setTheoryCapacity(Long theoryCapacity) 
    {
        this.theoryCapacity = theoryCapacity;
    }

    public Long getTheoryCapacity() 
    {
        return theoryCapacity;
    }

    public void setRequestDate(LocalDateTime requestDate)
    {
        this.requestDate = requestDate;
    }

    public LocalDateTime getRequestDate()
    {
        return requestDate;
    }

    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }

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

    public String getBatchNumber() 
    {
        return batchNumber;
    }

    public void setPlant(String plant) 
    {
        this.plant = plant;
    }

    public String getPlant() 
    {
        return plant;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("resourceGroupName", getResourceGroupName())
            .append("devicesQuantity", getDevicesQuantity())
            .append("theoryHours", getTheoryHours())
            .append("restDays", getRestDays())
            .append("theoryCapacity", getTheoryCapacity())
            .append("requestDate", getRequestDate())
            .append("delFlag", getDelFlag())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .append("batchNumber", getBatchNumber())
            .append("plant", getPlant())
            .toString();
    }

    /**通过ApsResourceGroupTemp èŽ·å– é€šè¿‡ApsResourceGroup */
    public ApsResourceGroup getApsResourceGroup() {
        ApsResourceGroup apsResourceGroup = new ApsResourceGroup();
        apsResourceGroup.setId(this.getId());
        apsResourceGroup.setResourceGroupName(this.getResourceGroupName());
        apsResourceGroup.setDevicesQuantity(this.getDevicesQuantity());
        apsResourceGroup.setTheoryHours(this.getTheoryHours());
        apsResourceGroup.setRestDays(this.getRestDays());
        apsResourceGroup.setTheoryCapacity(this.getTheoryCapacity());
        apsResourceGroup.setRequestDate(this.getRequestDate());
        return apsResourceGroup;
    }
}

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

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

import java.util.List;
import com.aps.core.domain.ApsResourceGroup;
import com.aps.core.param.ApsResourceGroupParam;
import org.apache.ibatis.annotations.Mapper;

/**
 * èµ„源组Mapper接口
 * 
 * @author ruoyi
 * @date 2025-04-10
 */
@Mapper
public interface ApsResourceGroupMapper 
{
    /**
     * æŸ¥è¯¢èµ„源组
     * 
     * @param id èµ„源组主键
     * @return èµ„源组
     */
    public ApsResourceGroup selectApsResourceGroupById(String id);

    /**
     * æŸ¥è¯¢èµ„源组列表
     * 
     * @param params èµ„源组
     * @return èµ„源组集合
     */
    public List<ApsResourceGroup> selectApsResourceGroupList(ApsResourceGroupParam params);

    /**
     * æ–°å¢žèµ„源组
     * 
     * @param apsResourceGroup èµ„源组
     * @return ç»“æžœ
     */
    public int insertApsResourceGroup(ApsResourceGroup apsResourceGroup);

    /**
     * ä¿®æ”¹èµ„源组
     * 
     * @param apsResourceGroup èµ„源组
     * @return ç»“æžœ
     */
    public int updateApsResourceGroup(ApsResourceGroup apsResourceGroup);

    /**
     * åˆ é™¤èµ„源组
     * 
     * @param id èµ„源组主键
     * @return ç»“æžœ
     */
    public int deleteApsResourceGroupById(String id);

    /**
     * æ‰¹é‡åˆ é™¤èµ„源组
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsResourceGroupByIds(String[] ids);

    /**
     * æ ¹æ®èµ„源组名称批量删除资源组
     * @param groupName
     * @return ç»“æžœ
     */
    public int deleteResourceGroupByNames(String[]  groupName);

    public int deleteApsResourceGroupTempByBatchNumber(String batchNum);
}

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

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

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

/**
 * èµ„源组临时上传Mapper接口
 * 
 * @author ruoyi
 * @date 2025-04-10
 */
@Mapper
public interface ApsResourceGroupTempMapper 
{
    /**
     * æŸ¥è¯¢èµ„源组临时上传
     * 
     * @param id èµ„源组临时上传主键
     * @return èµ„源组临时上传
     */
    public ApsResourceGroupTemp selectApsResourceGroupTempById(String id);

    /**
     * æŸ¥è¯¢èµ„源组临时上传列表
     * 
     * @param apsResourceGroupTemp èµ„源组临时上传
     * @return èµ„源组临时上传集合
     */
    public List<ApsResourceGroupTemp> selectApsResourceGroupTempList(ApsResourceGroupTemp apsResourceGroupTemp);

    /**
     * æ–°å¢žèµ„源组临时上传
     * 
     * @param apsResourceGroupTemp èµ„源组临时上传
     * @return ç»“æžœ
     */
    public int insertApsResourceGroupTemp(ApsResourceGroupTemp apsResourceGroupTemp);

    /**
     * ä¿®æ”¹èµ„源组临时上传
     * 
     * @param apsResourceGroupTemp èµ„源组临时上传
     * @return ç»“æžœ
     */
    public int updateApsResourceGroupTemp(ApsResourceGroupTemp apsResourceGroupTemp);

    /**
     * åˆ é™¤èµ„源组临时上传
     * 
     * @param id èµ„源组临时上传主键
     * @return ç»“æžœ
     */
    public int deleteApsResourceGroupTempById(String id);

    /**
     * æ‰¹é‡åˆ é™¤èµ„源组临时上传
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsResourceGroupTempByIds(String[] ids);
}

 aps-modules/aps-core/src/main/java/com/aps/core/param/ApsResourceGroupParam.java

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

import lombok.Data;

@Data
public class ApsResourceGroupParam   {

    private String resourceGroupName;
    private String beginRequestDate;
    private String endRequestDate;

}

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

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

import com.aps.core.domain.ApsResourceGroup;
import com.aps.core.domain.ApsResourceGroupTemp;
import com.aps.core.param.ApsResourceGroupParam;

import java.time.LocalDateTime;
import java.util.List;

/**
 * èµ„源组Service接口
 * 
 * @author ruoyi
 * &#064;date  2025-04-10
 */
public interface IApsResourceGroupService 
{
    /**
     * æŸ¥è¯¢èµ„源组
     * 
     * @param id èµ„源组主键
     * @return èµ„源组
     */
    ApsResourceGroup selectApsResourceGroupById(String id);

    /**
     * æŸ¥è¯¢èµ„源组列表
     * 
     * @param apsResourceGroup èµ„源组
     * @return èµ„源组集合
     */
    List<ApsResourceGroup> selectApsResourceGroupList(ApsResourceGroupParam apsResourceGroup);

    /**
     * æ–°å¢žèµ„源组
     * 
     * @param apsResourceGroup èµ„源组
     * @return ç»“æžœ
     */
    int insertApsResourceGroup(ApsResourceGroup apsResourceGroup);

    /**
     * ä¿®æ”¹èµ„源组
     * 
     * @param apsResourceGroup èµ„源组
     * @return ç»“æžœ
     */
    int updateApsResourceGroup(ApsResourceGroup apsResourceGroup);

    /**
     * æ‰¹é‡åˆ é™¤èµ„源组
     * 
     * @param ids éœ€è¦åˆ é™¤çš„资源组主键集合
     * @return ç»“æžœ
     */
    int deleteApsResourceGroupByIds(String[] ids);

    /**
     * åˆ é™¤èµ„源组信息
     * 
     * @param id èµ„源组主键
     * @return ç»“æžœ
     */
    int deleteApsResourceGroupById(String id);

    String importData(List<ApsResourceGroupTemp> tempList);

    void confirmData(String batchNum, LocalDateTime requestDate);
}

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

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

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

/**
 * èµ„源组临时上传Service接口
 * 
 * @author ruoyi
 * @date 2025-04-10
 */
public interface IApsResourceGroupTempService 
{
    /**
     * æŸ¥è¯¢èµ„源组临时上传
     * 
     * @param id èµ„源组临时上传主键
     * @return èµ„源组临时上传
     */
    public ApsResourceGroupTemp selectApsResourceGroupTempById(String id);

    /**
     * æŸ¥è¯¢èµ„源组临时上传列表
     * 
     * @param apsResourceGroupTemp èµ„源组临时上传
     * @return èµ„源组临时上传集合
     */
    public List<ApsResourceGroupTemp> selectApsResourceGroupTempList(ApsResourceGroupTemp apsResourceGroupTemp);

    /**
     * æ–°å¢žèµ„源组临时上传
     * 
     * @param apsResourceGroupTemp èµ„源组临时上传
     * @return ç»“æžœ
     */
    public int insertApsResourceGroupTemp(ApsResourceGroupTemp apsResourceGroupTemp);

    /**
     * ä¿®æ”¹èµ„源组临时上传
     * 
     * @param apsResourceGroupTemp èµ„源组临时上传
     * @return ç»“æžœ
     */
    public int updateApsResourceGroupTemp(ApsResourceGroupTemp apsResourceGroupTemp);

    /**
     * æ‰¹é‡åˆ é™¤èµ„源组临时上传
     * 
     * @param ids éœ€è¦åˆ é™¤çš„资源组临时上传主键集合
     * @return ç»“æžœ
     */
    public int deleteApsResourceGroupTempByIds(String[] ids);

    /**
     * åˆ é™¤èµ„源组临时上传信息
     * 
     * @param id èµ„源组临时上传主键
     * @return ç»“æžœ
     */
    public int deleteApsResourceGroupTempById(String id);
}

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

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

import java.time.LocalDateTime;
import java.util.List;
import java.util.stream.Stream;

import com.aps.common.core.utils.DateUtils;
import com.aps.common.core.utils.uuid.IdUtils;
import com.aps.core.domain.ApsResourceGroupTemp;
import com.aps.core.mapper.ApsResourceGroupTempMapper;
import com.aps.core.param.ApsResourceGroupParam;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.aps.core.mapper.ApsResourceGroupMapper;
import com.aps.core.domain.ApsResourceGroup;
import com.aps.core.service.IApsResourceGroupService;
import org.springframework.transaction.annotation.Transactional;

/**
 * èµ„源组Service业务层处理
 * 
 * @author ruoyi
 * @date 2025-04-10
 */
@Service
public class ApsResourceGroupServiceImpl implements IApsResourceGroupService 
{
    @Autowired
    private ApsResourceGroupMapper apsResourceGroupMapper;
    @Autowired
    private ApsResourceGroupTempMapper apsResourceGroupTempMapper;

    /**
     * æŸ¥è¯¢èµ„源组
     * 
     * @param id èµ„源组主键
     * @return èµ„源组
     */
    @Override
    public ApsResourceGroup selectApsResourceGroupById(String id)
    {
        return apsResourceGroupMapper.selectApsResourceGroupById(id);
    }

    /**
     * æŸ¥è¯¢èµ„源组列表
     * 
     * @param apsResourceGroup èµ„源组
     * @return èµ„源组
     */
    @Override
    public List<ApsResourceGroup> selectApsResourceGroupList(ApsResourceGroupParam apsResourceGroup)
    {
        return apsResourceGroupMapper.selectApsResourceGroupList(apsResourceGroup);
    }

    /**
     * æ–°å¢žèµ„源组
     * 
     * @param apsResourceGroup èµ„源组
     * @return ç»“æžœ
     */
    @Override
    public int insertApsResourceGroup(ApsResourceGroup apsResourceGroup)
    {
        apsResourceGroup.setCreateTime(DateUtils.getNowDate());
        return apsResourceGroupMapper.insertApsResourceGroup(apsResourceGroup);
    }

    /**
     * ä¿®æ”¹èµ„源组
     * 
     * @param apsResourceGroup èµ„源组
     * @return ç»“æžœ
     */
    @Override
    public int updateApsResourceGroup(ApsResourceGroup apsResourceGroup)
    {
        apsResourceGroup.setUpdateTime(DateUtils.getNowDate());
        return apsResourceGroupMapper.updateApsResourceGroup(apsResourceGroup);
    }

    /**
     * æ‰¹é‡åˆ é™¤èµ„源组
     * 
     * @param ids éœ€è¦åˆ é™¤çš„资源组主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsResourceGroupByIds(String[] ids)
    {
        return apsResourceGroupMapper.deleteApsResourceGroupByIds(ids);
    }

    /**
     * åˆ é™¤èµ„源组信息
     * 
     * @param id èµ„源组主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsResourceGroupById(String id)
    {
        return apsResourceGroupMapper.deleteApsResourceGroupById(id);
    }

    /**
     * å¯¼å…¥æ•°æ®
     * @param tempList
     * @return æ‰¹æ¬¡å·
     */
    @Override
    public String importData(List<ApsResourceGroupTemp> tempList) {
        String batchNum= IdUtils.fastUUID();
        if (!tempList.isEmpty()) {
            tempList.forEach(temp->{
                temp.setId(IdUtils.simpleUUID());
                //计算逻辑：理论产能=设备数量x每日理论时间x截止需求日剩余天数
                temp.setTheoryCapacity(temp.getDevicesQuantity()*temp.getTheoryHours()*temp.getRestDays());
                temp.setBatchNumber(batchNum);
                temp.setCreateTime(DateUtils.getNowDate());
                apsResourceGroupTempMapper.insertApsResourceGroupTemp(temp);
            });
        }
        return batchNum;
    }
    /**
     * ç¡®è®¤æ•°æ®
     * @param batchNum
     * @param requestDate
     */
    @Transactional
    public void confirmData(String batchNum, LocalDateTime requestDate){
        ApsResourceGroupTemp param = new ApsResourceGroupTemp();
        param.setBatchNumber(batchNum);
        List<ApsResourceGroupTemp> tempList = apsResourceGroupTempMapper.selectApsResourceGroupTempList(param);
        List<String> groupName = tempList.stream().map(x -> x.getResourceGroupName()).distinct().toList();
        if (!tempList.isEmpty()) {
            /*根据资源组名称删除旧的数据*/
            apsResourceGroupMapper.deleteResourceGroupByNames(groupName.toArray(new String[0]));
            Stream<ApsResourceGroup> apsResourceGroupStream = tempList.stream().map(x -> x.getApsResourceGroup());
            apsResourceGroupStream.forEach(x->{
                x.setRequestDate(requestDate);
                x.setCreateTime(DateUtils.getNowDate());
                apsResourceGroupMapper.insertApsResourceGroup(x);
            });
            apsResourceGroupMapper.deleteApsResourceGroupTempByBatchNumber(batchNum);

        }
    }
}

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

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

import com.aps.common.core.utils.DateUtils;
import com.aps.core.domain.ApsResourceGroupTemp;
import com.aps.core.mapper.ApsResourceGroupTempMapper;
import com.aps.core.service.IApsResourceGroupTempService;
import jakarta.annotation.Resource;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * èµ„源组临时上传Service业务层处理
 * 
 * @author ruoyi
 * &#064;date  2025-04-10
 */
@Service
public class ApsResourceGroupTempServiceImpl implements IApsResourceGroupTempService 
{
    @Resource
    private ApsResourceGroupTempMapper apsResourceGroupTempMapper;

    /**
     * æŸ¥è¯¢èµ„源组临时上传
     * 
     * @param id èµ„源组临时上传主键
     * @return èµ„源组临时上传
     */
    @Override
    public ApsResourceGroupTemp selectApsResourceGroupTempById(String id)
    {
        return apsResourceGroupTempMapper.selectApsResourceGroupTempById(id);
    }

    /**
     * æŸ¥è¯¢èµ„源组临时上传列表
     * 
     * @param apsResourceGroupTemp èµ„源组临时上传
     * @return èµ„源组临时上传
     */
    @Override
    public List<ApsResourceGroupTemp> selectApsResourceGroupTempList(ApsResourceGroupTemp apsResourceGroupTemp)
    {
        return apsResourceGroupTempMapper.selectApsResourceGroupTempList(apsResourceGroupTemp);
    }

    /**
     * æ–°å¢žèµ„源组临时上传
     * 
     * @param apsResourceGroupTemp èµ„源组临时上传
     * @return ç»“æžœ
     */
    @Override
    public int insertApsResourceGroupTemp(ApsResourceGroupTemp apsResourceGroupTemp)
    {
        apsResourceGroupTemp.setCreateTime(DateUtils.getNowDate());
        return apsResourceGroupTempMapper.insertApsResourceGroupTemp(apsResourceGroupTemp);
    }

    /**
     * ä¿®æ”¹èµ„源组临时上传
     * 
     * @param apsResourceGroupTemp èµ„源组临时上传
     * @return ç»“æžœ
     */
    @Override
    public int updateApsResourceGroupTemp(ApsResourceGroupTemp apsResourceGroupTemp)
    {
        apsResourceGroupTemp.setUpdateTime(DateUtils.getNowDate());
        return apsResourceGroupTempMapper.updateApsResourceGroupTemp(apsResourceGroupTemp);
    }

    /**
     * æ‰¹é‡åˆ é™¤èµ„源组临时上传
     * 
     * @param ids éœ€è¦åˆ é™¤çš„资源组临时上传主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsResourceGroupTempByIds(String[] ids)
    {
        return apsResourceGroupTempMapper.deleteApsResourceGroupTempByIds(ids);
    }

    /**
     * åˆ é™¤èµ„源组临时上传信息
     * 
     * @param id èµ„源组临时上传主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsResourceGroupTempById(String id)
    {
        return apsResourceGroupTempMapper.deleteApsResourceGroupTempById(id);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,123 @@
<?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.ApsResourceGroupMapper">
    
    <resultMap type="ApsResourceGroup" id="ApsResourceGroupResult">
        <result property="id"    column="id"    />
        <result property="resourceGroupName"    column="resource_group_name"    />
        <result property="devicesQuantity"    column="devices_quantity"    />
        <result property="theoryHours"    column="theory_hours"    />
        <result property="restDays"    column="rest_days"    />
        <result property="theoryCapacity"    column="theory_capacity"    />
        <result property="requestDate"    column="request_date"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
        <result property="plant"    column="plant"    />
    </resultMap>

    <sql id="selectApsResourceGroupVo">
        select id, resource_group_name, devices_quantity, theory_hours, rest_days, theory_capacity, request_date, del_flag, create_by, create_time, update_by, update_time, plant from aps_resource_group
    </sql>

    <select id="selectApsResourceGroupList" parameterType="ApsResourceGroupParam" resultMap="ApsResourceGroupResult">
        <include refid="selectApsResourceGroupVo"/>
        <where>  
            <if test="resourceGroupName != null  and resourceGroupName != ''"> and resource_group_name like '%' || #{resourceGroupName|| '%')</if>

            <if test="beginRequestDate != null and beginRequestDate != '' and endRequestDate != null and endRequestDate != ''"> and request_date between #{beginRequestDate} and #{endRequestDate}</if>
            <!--<if test="plant != null  and plant != ''"> and plant = #{plant}</if>
            <if test="devicesQuantity != null "> and devices_quantity = #{devicesQuantity}</if>
            <if test="theoryHours != null "> and theory_hours = #{theoryHours}</if>
            <if test="restDays != null "> and rest_days = #{restDays}</if>
            <if test="theoryCapacity != null "> and theory_capacity = #{theoryCapacity}</if>-->
            and del_flag = '0'
        </where>
    </select>
    
    <select id="selectApsResourceGroupById" parameterType="String" resultMap="ApsResourceGroupResult">
        <include refid="selectApsResourceGroupVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsResourceGroup" parameterType="ApsResourceGroup">
        insert into aps_resource_group
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="resourceGroupName != null">resource_group_name,</if>
            <if test="devicesQuantity != null">devices_quantity,</if>
            <if test="theoryHours != null">theory_hours,</if>
            <if test="restDays != null">rest_days,</if>
            <if test="theoryCapacity != null">theory_capacity,</if>
            <if test="requestDate != null">request_date,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="plant != null">plant,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="resourceGroupName != null">#{resourceGroupName},</if>
            <if test="devicesQuantity != null">#{devicesQuantity},</if>
            <if test="theoryHours != null">#{theoryHours},</if>
            <if test="restDays != null">#{restDays},</if>
            <if test="theoryCapacity != null">#{theoryCapacity},</if>
            <if test="requestDate != null">#{requestDate},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="plant != null">#{plant},</if>
         </trim>
    </insert>

    <update id="updateApsResourceGroup" parameterType="ApsResourceGroup">
        update aps_resource_group
        <trim prefix="SET" suffixOverrides=",">
            <if test="resourceGroupName != null">resource_group_name = #{resourceGroupName},</if>
            <if test="devicesQuantity != null">devices_quantity = #{devicesQuantity},</if>
            <if test="theoryHours != null">theory_hours = #{theoryHours},</if>
            <if test="restDays != null">rest_days = #{restDays},</if>
            <if test="theoryCapacity != null">theory_capacity = #{theoryCapacity},</if>
            <if test="requestDate != null">request_date = #{requestDate},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="plant != null">plant = #{plant},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteApsResourceGroupById" parameterType="String">
        delete from aps_resource_group where id = #{id}
    </delete>

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

    <!--根据资源名称进行批量删除-->
    <update id="deleteResourceGroupByNames" parameterType="String">
        update  aps_resource_group
        set del_flag = 1
        where resource_group_name in
        <foreach item="groupName" collection="array" open="(" separator="," close=")">
            #{groupName}
        </foreach>
    </update>
    <delete id="deleteApsResourceGroupTempByBatchNumber" parameterType="String">
        delete from aps_resource_group_temp where batch_number = #{batch_number}
    </delete>
</mapper>

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,116 @@
<?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.ApsResourceGroupTempMapper">
    
    <resultMap type="ApsResourceGroupTemp" id="ApsResourceGroupTempResult">
        <result property="id"    column="id"    />
        <result property="resourceGroupName"    column="resource_group_name"    />
        <result property="devicesQuantity"    column="devices_quantity"    />
        <result property="theoryHours"    column="theory_hours"    />
        <result property="restDays"    column="rest_days"    />
        <result property="theoryCapacity"    column="theory_capacity"    />
        <result property="requestDate"    column="request_date"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
        <result property="batchNumber"    column="batch_number"    />
        <result property="plant"    column="plant"    />
    </resultMap>

    <sql id="selectApsResourceGroupTempVo">
        select id, resource_group_name, devices_quantity, theory_hours, rest_days, theory_capacity, request_date, del_flag, create_by, create_time, update_by, update_time, batch_number, plant from aps_resource_group_temp
    </sql>

    <select id="selectApsResourceGroupTempList" parameterType="ApsResourceGroupTemp" resultMap="ApsResourceGroupTempResult">
        <include refid="selectApsResourceGroupTempVo"/>
        <where>  
            <if test="resourceGroupName != null  and resourceGroupName != ''"> and resource_group_name like concat('%', #{resourceGroupName}, '%')</if>
            <if test="devicesQuantity != null "> and devices_quantity = #{devicesQuantity}</if>
            <if test="theoryHours != null "> and theory_hours = #{theoryHours}</if>
            <if test="restDays != null "> and rest_days = #{restDays}</if>
            <if test="theoryCapacity != null "> and theory_capacity = #{theoryCapacity}</if>
            <if test="params.beginRequestDate != null and params.beginRequestDate != '' and params.endRequestDate != null and params.endRequestDate != ''"> and request_date between #{params.beginRequestDate} and #{params.endRequestDate}</if>
            <if test="batchNumber != null  and batchNumber != ''"> and batch_number = #{batchNumber}</if>
            <if test="plant != null  and plant != ''"> and plant = #{plant}</if>
            and del_flag = '0'
        </where>
    </select>
    
    <select id="selectApsResourceGroupTempById" parameterType="String" resultMap="ApsResourceGroupTempResult">
        <include refid="selectApsResourceGroupTempVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsResourceGroupTemp" parameterType="ApsResourceGroupTemp">
        insert into aps_resource_group_temp
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="resourceGroupName != null">resource_group_name,</if>
            <if test="devicesQuantity != null">devices_quantity,</if>
            <if test="theoryHours != null">theory_hours,</if>
            <if test="restDays != null">rest_days,</if>
            <if test="theoryCapacity != null">theory_capacity,</if>
            <if test="requestDate != null">request_date,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="batchNumber != null">batch_number,</if>
            <if test="plant != null">plant,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="resourceGroupName != null">#{resourceGroupName},</if>
            <if test="devicesQuantity != null">#{devicesQuantity},</if>
            <if test="theoryHours != null">#{theoryHours},</if>
            <if test="restDays != null">#{restDays},</if>
            <if test="theoryCapacity != null">#{theoryCapacity},</if>
            <if test="requestDate != null">#{requestDate},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="batchNumber != null">#{batchNumber},</if>
            <if test="plant != null">#{plant},</if>
         </trim>
    </insert>

    <update id="updateApsResourceGroupTemp" parameterType="ApsResourceGroupTemp">
        update aps_resource_group_temp
        <trim prefix="SET" suffixOverrides=",">
            <if test="resourceGroupName != null">resource_group_name = #{resourceGroupName},</if>
            <if test="devicesQuantity != null">devices_quantity = #{devicesQuantity},</if>
            <if test="theoryHours != null">theory_hours = #{theoryHours},</if>
            <if test="restDays != null">rest_days = #{restDays},</if>
            <if test="theoryCapacity != null">theory_capacity = #{theoryCapacity},</if>
            <if test="requestDate != null">request_date = #{requestDate},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="batchNumber != null">batch_number = #{batchNumber},</if>
            <if test="plant != null">plant = #{plant},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteApsResourceGroupTempById" parameterType="String">
        delete from aps_resource_group_temp where id = #{id}
    </delete>

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


</mapper>