【UPDATE】增加去重获取工序名称列表接口

huangjiayang

2025-04-21 20a7ac081e3ee0afbf7e0cc7203435401016c9b8

【UPDATE】增加去重获取工序名称列表接口

 aps-modules/aps-core/src/main/java/com/aps/core/controller/basicData/ApsProcessRouteController.java

@@ -18,6 +18,7 @@
import org.springframework.web.multipart.MultipartFile;

import java.util.List;
import java.util.Map;

/**
 * 工艺路线Controller
@@ -139,4 +140,14 @@
        return toAjax(apsProcessRouteService.confirmProcessRoute(apsProcessRouteTemp));
    }

    /**
     * 获取工序列表（去重）
     * @return
     */
    @PostMapping("/selectProcessNameList")
    public TableDataInfo selectProcessNameList(@RequestBody Map<String, String> params) {
        return getDataTable(apsProcessRouteService.selectProcessNameList(params.get("orgCode")));
    }


}

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

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

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

import java.util.List;

/**
 * 工艺路线Mapper接口
@@ -60,4 +61,10 @@
     * @return 结果
     */
    public int deleteApsProcessRouteByIds(String[] ids);

    /**
     * 去重查询工序名称列表
     * @return
     */
    public List<ApsProcessRoute> selectProcessNameList(String orgCode);
}

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

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

import java.util.List;
import com.aps.core.domain.ApsProcessRoute;
import com.aps.core.domain.ApsProcessRouteTemp;

import java.util.List;

/**
 * 工艺路线Service接口
@@ -61,4 +62,10 @@
    public int deleteApsProcessRouteById(String id);

    int confirmProcessRoute(ApsProcessRouteTemp apsProcessRouteTemp);

    /**
     * 去重查询工序名称列表
     * @return
     */
    public List<ApsProcessRoute> selectProcessNameList(String orgCode);
}

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

@@ -1,16 +1,17 @@
package com.aps.core.service.impl;

import java.util.List;
import com.aps.common.core.utils.DateUtils;
import com.aps.common.core.utils.uuid.IdUtils;
import com.aps.core.domain.ApsProcessRoute;
import com.aps.core.domain.ApsProcessRouteTemp;
import com.aps.core.mapper.ApsProcessRouteMapper;
import com.aps.core.mapper.ApsProcessRouteTempMapper;
import com.aps.core.service.IApsProcessRouteService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.aps.core.mapper.ApsProcessRouteMapper;
import com.aps.core.domain.ApsProcessRoute;
import com.aps.core.service.IApsProcessRouteService;

import java.util.List;

/**
 * 工艺路线Service业务层处理
@@ -139,4 +140,9 @@
        }
        return 1;
    }

    @Override
    public List<ApsProcessRoute> selectProcessNameList(String orgCode) {
        return apsProcessRouteMapper.selectProcessNameList(orgCode);
    }
}

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

@@ -132,4 +132,8 @@
            #{id}
        </foreach>
    </delete>

    <select id="selectProcessNameList" parameterType="String" resultMap="ApsProcessRouteResult">
        select DISTINCT process_name from aps_process_route where org_code = #{orgCode}
    </select>
</mapper>