feat: 标准查新新增查新时间、查新结果、来源网址及删除接口

吴羡

2026-10-21 92153ecb458b62b04f84666c63fd389a5ee9f738

feat: 标准查新新增查新时间、查新结果、来源网址及删除接口

- 新增删除接口，自动归档记录禁止修改和删除
- 保存新增字段，来源非"其他"时清空来源网址
- 列表返回查新人
- sql 增量脚本增加对应字段

 cnas-process/src/main/java/com/ruoyi/process/controller/ProcessMethodSearchNewController.java

@@ -59,6 +59,15 @@
    }

    /**
     * 删除标准查新
     */
    @Operation(summary = "删除标准查新")
    @DeleteMapping("/delMethodSearchNew")
    public Result delMethodSearchNew(Integer methodSearchNewId) {
        return Result.success(processMethodSearchNewService.delMethodSearchNew(methodSearchNewId));
    }

    /**
     * 标准查新列表
     */
    @Operation(summary = "标准查新列表")

 cnas-process/src/main/java/com/ruoyi/process/pojo/ProcessMethodSearchNew.java

@@ -46,6 +46,20 @@
    @Schema(description = "查新记录来源, 0,标准网, 1委托情报, 2标准数, 3其他")
    private Integer searchNewSource;

    @Schema(description = "查新时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime searchNewTime;

    @Schema(description = "查新结果")
    private String searchNewResult;

    @Schema(description = "来源为其他时填写的具体网址或网站名称")
    private String searchNewWebsite;

    @Schema(description = "查新人")
    @TableField(exist = false)
    private String searchNewUserName;

    @Schema(description = "备注,0作废, 1替换")
    private Integer remark;


 cnas-process/src/main/java/com/ruoyi/process/service/ProcessMethodSearchNewService.java

@@ -31,6 +31,13 @@
    boolean updateMethodSearchNew(ProcessMethodSearchNew processMethodSearchNew);

    /**
     * 删除标准查新
     * @param methodSearchNewId 标准查新记录ID
     * @return
     */
    boolean delMethodSearchNew(Integer methodSearchNewId);

    /**
     * 标准查新列表
     * @param processMethodSearchNew
     * @return

 cnas-process/src/main/java/com/ruoyi/process/service/impl/ProcessMethodSearchNewServiceImpl.java

@@ -77,6 +77,9 @@
            processMethodSearchNew.setStandardMethodId(null);
            processMethodSearchNew.setCurrentAutoStandardId(null);
            processMethodSearchNew.setAutoArchivedTime(null);
            if (!Integer.valueOf(3).equals(processMethodSearchNew.getSearchNewSource())) {
                processMethodSearchNew.setSearchNewWebsite(null);
            }
        }
        // 新增
        this.saveBatch(processMethodSearchNewList);
@@ -101,10 +104,30 @@
                .set(ProcessMethodSearchNew::getNewMethodName, processMethodSearchNew.getNewMethodName())
                .set(ProcessMethodSearchNew::getNewStandardNo, processMethodSearchNew.getNewStandardNo())
                .set(ProcessMethodSearchNew::getSearchNewSource, processMethodSearchNew.getSearchNewSource())
                .set(ProcessMethodSearchNew::getSearchNewTime, processMethodSearchNew.getSearchNewTime())
                .set(ProcessMethodSearchNew::getSearchNewResult, processMethodSearchNew.getSearchNewResult())
                .set(ProcessMethodSearchNew::getSearchNewWebsite,
                        Integer.valueOf(3).equals(processMethodSearchNew.getSearchNewSource())
                                ? processMethodSearchNew.getSearchNewWebsite() : null)
                .set(ProcessMethodSearchNew::getRemark, processMethodSearchNew.getRemark())
                .set(ProcessMethodSearchNew::getIsNewStandard, 1));
    }

    @Override
    public boolean delMethodSearchNew(Integer methodSearchNewId) {
        if (methodSearchNewId == null) {
            throw new ErrorException("缺少标准查新记录id");
        }
        ProcessMethodSearchNew old = getById(methodSearchNewId);
        if (old == null) {
            throw new ErrorException("标准查新记录不存在");
        }
        if (Integer.valueOf(1).equals(old.getIsAutoArchived())) {
            throw new ErrorException("自动归档记录不允许删除");
        }
        return removeById(methodSearchNewId);
    }

    /**
     * 标准查新列表
     *

 cnas-process/src/main/resources/mapper/ProcessMethodSearchNewMapper.xml

@@ -4,7 +4,8 @@

    <!-- 标准查新分页查询 -->
    <select id="pageMethodSearchNew" resultType="com.ruoyi.process.pojo.ProcessMethodSearchNew">
        select *
        select a.*,
               (select u.name from user u where u.id = a.create_user) as searchNewUserName
        from (select *
        from cnas_process_method_search_new
        <where>

 sql/lims_delta.sql

@@ -98,3 +98,10 @@
  update_time       datetime                                   comment '更新时间',
  primary key (column_id)
) engine=innodb auto_increment=1 comment = '代码生成业务表字段';

-- 21、标准查新表增加查新时间、查新结果、其他来源网址
-- 仅在目标库缺少这些列时执行一次
alter table cnas_process_method_search_new
  add column search_new_time    datetime     default null comment '查新时间'                      after search_new_source,
  add column search_new_result  varchar(500) default null comment '查新结果'                      after search_new_time,
  add column search_new_website varchar(500) default null comment '来源为其他时的具体网址或网站名称' after search_new_result;