增加查看钣金需求接口

sfd

2025-05-08 705b09f47d6388e7e7632ed625d12e7cad57310a

增加查看钣金需求接口

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

@@ -4,6 +4,7 @@
import com.aps.common.core.web.page.TableDataInfo;
import com.aps.common.security.annotation.RequiresPermissions;
import com.aps.core.domain.ApsPlateOrderPlanManager;
import com.aps.core.domain.ApsPlateStandardRequire;
import com.aps.core.service.IApsPlateOrderPlanManagerService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
@@ -28,7 +29,7 @@
    /**
     * 查询钣金工单计划
     */
    @RequiresPermissions("ApsPlatOrderPlanManager:list")
//    @RequiresPermissions("ApsPlatOrderPlanManager:list")
    @GetMapping("/list")
    public TableDataInfo list(ApsPlateOrderPlanManager apsPlateOrderPlanManager)
    {
@@ -37,4 +38,15 @@
        return getDataTable(list);
    }

    /**
     * 查询钣金工单需求
     */
//    @RequiresPermissions("ApsPlatOrderPlanManager:requirement:list")
    @GetMapping("/requirement/list")
    public List<ApsPlateStandardRequire> list(String workOrderNo)
    {
        List<ApsPlateStandardRequire> list = iapPlateOrderPlanManagerService.selectApsPlanStandardRequire(workOrderNo);
        return list;
    }

}

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

@@ -22,11 +22,11 @@

    /** 需求ID */
    @Excel(name = "需求ID")
    private String requireId;
    private Long requireId;

    /** 需求追溯ID */
    @Excel(name = "需求追溯ID")
    private String requireTraceId;
    private Long requireTraceId;

    /** 工单号 */
    @Excel(name = "工单号")
@@ -79,6 +79,7 @@
    private Date planEndDay;

    /** 未匹配的生产数量*/
    @Excel(name = "未匹配的生产数量")
    private BigDecimal unmatchedQuantity;

    /** 工单创建时间 */

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

@@ -1,6 +1,7 @@
package com.aps.core.mapper;

import com.aps.core.domain.ApsPlateOrderPlanManager;
import com.aps.core.domain.ApsPlateStandardRequire;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
@@ -22,4 +23,12 @@
     * @return 钣金工单计划管理
     */
    List<ApsPlateOrderPlanManager> selectApsPlanOrderManager(ApsPlateOrderPlanManager apsPlateOrderPlanManager);

    /**
     * 查询钣金工单需求
     *
     * @param workOrderNo 工单号
     * @return 查询钣金工单需求
     */
    List<ApsPlateStandardRequire> selectApsPlanStandardRequire(String workOrderNo);
}

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

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

import com.aps.core.domain.ApsPlateOrderPlanManager;
import com.aps.core.domain.ApsPlateStandardRequire;

import java.util.List;

@@ -14,4 +15,6 @@
{

    List<ApsPlateOrderPlanManager> selectApsPlanOrderManager(ApsPlateOrderPlanManager apsPlateOrderPlanManager);

    List<ApsPlateStandardRequire> selectApsPlanStandardRequire(String workOrderNo);
}

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

@@ -5,6 +5,7 @@
import com.aps.common.security.utils.SecurityUtils;
import com.aps.core.domain.ApsPlant;
import com.aps.core.domain.ApsPlateOrderPlanManager;
import com.aps.core.domain.ApsPlateStandardRequire;
import com.aps.core.mapper.ApsPlantMapper;
import com.aps.core.mapper.ApsPlateOrderPlanManagerMapper;
import com.aps.core.service.IApsPlantService;
@@ -36,4 +37,9 @@
    public List<ApsPlateOrderPlanManager> selectApsPlanOrderManager(ApsPlateOrderPlanManager apsPlateOrderPlanManager) {
        return apsPlateOrderPlanManagerMapper.selectApsPlanOrderManager(apsPlateOrderPlanManager);
    }

    @Override
    public List<ApsPlateStandardRequire> selectApsPlanStandardRequire(String workOrderNo) {
        return apsPlateOrderPlanManagerMapper.selectApsPlanStandardRequire(workOrderNo);
    }
}

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

@@ -49,4 +49,73 @@
        </where>
    </select>


    <resultMap type="ApsPlateStandardRequire" id="ApsPlateStandardRequireResult">
        <result property="id"    column="id"    />
        <result property="requireId"    column="require_id"    />
        <result property="bomLineId"    column="bom_line_id"    />
        <result property="bomLineCode"    column="bom_line_code"    />
        <result property="bomLineLevel"    column="bom_line_level"    />
        <result property="bomUseAmount"    column="bom_use_amount"    />
        <result property="processRouteId"    column="process_route_id"    />
        <result property="processRouteHours"    column="process_route_hours"    />
        <result property="requireAmount"    column="require_amount"    />
        <result property="netRequirement"    column="net_requirement"    />
        <result property="startDate"    column="start_date"    />
        <result property="completeDate"    column="complete_date"    />
        <result property="demandDate"    column="demand_date"    />
        <result property="orgCode"    column="org_code"    />
        <result property="productionBase"    column="production_base"    />
        <result property="matchState"    column="match_state"    />
        <result property="matchMode"    column="match_mode"    />
        <result property="unmatchedDemandAmount"    column="unmatched_demand_amount"    />
        <result property="suggestedCompletionDate"    column="suggested_completion_date"    />
        <result property="hasDelayRisk"    column="has_delay_risk"    />
        <result property="batchNumber"    column="batch_number"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="createTime"    column="create_time"    />
        <result property="createBy"    column="create_by"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
    </resultMap>

    <sql id="selectApsPlateStandardRequireVo">
        select require.id,
               require.require_id,
               require.bom_line_id,
               require.bom_line_code,
               require.bom_line_level,
               require.bom_use_amount,
               require.process_route_id,
               require.process_route_hours,
               require.require_amount,
               require.net_requirement,
               require.start_date,
               require.complete_date,
               require.demand_date,
               require.org_code,
               require.production_base,
               require.match_state,
               require.match_mode,
               require.unmatched_demand_amount,
               require.suggested_completion_date,
               require.has_delay_risk,
               require.batch_number,
               require.del_flag,
               require.create_time,
               require.create_by,
               require.update_by,
               require.update_time
        from
             aps_plate_standard_require require
            left join aps_plate_standard_require_bom_order_detail detail on detail.require_id = require.id
    </sql>

    <select id="selectApsPlanStandardRequire" parameterType="String" resultMap="ApsPlateStandardRequireResult">
        <include refid="selectApsPlateStandardRequireVo"/>
        <where>
            <if test="workOrderNo != null  and workOrderNo != ''"> and detail.doc_no = #{workOrderNo}</if>
        </where>
    </select>

</mapper>