【UPDATE】钣金供应缺口报表接口

huangjiayang

2025-05-07 dfa0c439d2d7626d56c37dbee2f72f5e5cd0f553

【UPDATE】钣金供应缺口报表接口

 aps-modules/aps-core/src/main/java/com/aps/core/controller/mainPlan/ApsPlateStandardRequireController.java

@@ -1,26 +1,19 @@
package com.aps.core.controller.mainPlan;

import java.util.List;

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.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.ApsPlateStandardRequire;
import com.aps.core.service.IApsPlateStandardRequireService;
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 jakarta.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

/**
 * 钣金工单标准需求Controller
@@ -110,4 +103,16 @@
    {
        return toAjax(apsPlateStandardRequireService.deleteApsPlateStandardRequireByIds(ids));
    }

    /**
     * 钣金供应缺口报表
     */
//    @RequiresPermissions("ApsPlateStandardRequire:ApsPlateStandardRequire:supplyGapList")
    @GetMapping("/supplyGapList")
    public TableDataInfo selectPlateSupplyGapList(ApsPlateStandardRequire apsPlateStandardRequire)
    {
        startPage();
        List<ApsPlateStandardRequire> list = apsPlateStandardRequireService.selectPlateSupplyGapList(apsPlateStandardRequire);
        return getDataTable(list);
    }
}

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

@@ -1,8 +1,9 @@
package com.aps.core.mapper;

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

import java.util.List;

/**
 * 钣金工单标准需求Mapper接口
@@ -60,4 +61,12 @@
     * @return 结果
     */
    public int deleteApsPlateStandardRequireByIds(Long[] ids);


    /**
     * 钣金供应缺口报表
     * @param apsPlateStandardRequire
     * @return
     */
    public List<ApsPlateStandardRequire> selectPlateSupplyGapList(ApsPlateStandardRequire apsPlateStandardRequire);
}

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

@@ -1,7 +1,8 @@
package com.aps.core.service;

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

import java.util.List;

/**
 * 钣金工单标准需求Service接口
@@ -58,4 +59,11 @@
     * @return 结果
     */
    public int deleteApsPlateStandardRequireById(Long id);

    /**
     * 钣金供应缺口报表
     * @param apsPlateStandardRequire
     * @return
     */
    public List<ApsPlateStandardRequire> selectPlateSupplyGapList(ApsPlateStandardRequire apsPlateStandardRequire);
}

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

@@ -1,12 +1,13 @@
package com.aps.core.service.impl;

import java.util.List;
import com.aps.common.core.utils.DateUtils;
import com.aps.core.domain.ApsPlateStandardRequire;
import com.aps.core.mapper.ApsPlateStandardRequireMapper;
import com.aps.core.service.IApsPlateStandardRequireService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.aps.core.mapper.ApsPlateStandardRequireMapper;
import com.aps.core.domain.ApsPlateStandardRequire;
import com.aps.core.service.IApsPlateStandardRequireService;

import java.util.List;

/**
 * 钣金工单标准需求Service业务层处理
@@ -93,4 +94,14 @@
    {
        return apsPlateStandardRequireMapper.deleteApsPlateStandardRequireById(id);
    }

    /**
     * 钣金供应缺口报表
     * @param apsPlateStandardRequire
     * @return
     */
    @Override
    public List<ApsPlateStandardRequire> selectPlateSupplyGapList(ApsPlateStandardRequire apsPlateStandardRequire) {
        return apsPlateStandardRequireMapper.selectPlateSupplyGapList(apsPlateStandardRequire);
    }
}

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

@@ -170,4 +170,11 @@
            #{id}
        </foreach>
    </delete>

    <select id="selectPlateSupplyGapList" parameterType="ApsPlateStandardRequire" resultMap="ApsPlateStandardRequireResult">
        select id, require_id, bom_line_code, bom_line_level, match_state, match_mode, unmatched_demand_amount, start_date, complete_date, demand_date, org_code, production_base
        from aps_plate_standard_require where unmatched_demand_amount>0
        <if test="requireId != null and requireId != ''"> and require_id like '%' || #{requireId} || '%'</if>
        <if test="bomLineCode != null and bomLineCode != ''"> and bom_line_code like '%' || #{bomLineCode} || '%'</if>
    </select>
</mapper>