批量添加源码包

whyclxw

2025-03-13 aca4324415aba0e5462ae6462ca8d99ca282b71c

批量添加源码包

 src/main/java/com/whyc/controller/SoftcodeController.java

@@ -1,5 +1,6 @@
package com.whyc.controller;

import com.whyc.dto.CodeFilesDto;
import com.whyc.dto.Response;
import com.whyc.pojo.Software;
import com.whyc.service.SoftcodeService;
@@ -43,4 +44,15 @@
    public Response getFileNameByCreateTime(@RequestParam String createTime){
        return wareService.getFileNameByCreateTime(createTime);
    }

    @ApiOperation(value = "查询当前owner的未上传源码记录")
    @GetMapping("getFileNameByOwnerWithCode")
    public Response getFileNameByOwnerWithCode(@RequestParam String owner){
        return wareService.getFileNameByOwnerWithCode(owner);
    }
    @ApiOperation(value = "批量添加源码包")
    @PostMapping("setCodeByFileNmaes")
    public Response setCodeByFileNmaes(@RequestBody CodeFilesDto dto){
        return wareService.setCodeByFileNmaes(dto);
    }
}

 src/main/java/com/whyc/dto/CodeFilesDto.java

New file
@@ -0,0 +1,25 @@
package com.whyc.dto;

import java.util.List;

public class CodeFilesDto {
    private  Integer num;
    private List<String> fileNames;


    public Integer getNum() {
        return num;
    }

    public void setNum(Integer num) {
        this.num = num;
    }

    public List<String> getFileNames() {
        return fileNames;
    }

    public void setFileNames(List<String> fileNames) {
        this.fileNames = fileNames;
    }
}

 src/main/java/com/whyc/mapper/SoftwareMapper.java

@@ -11,4 +11,7 @@
    //查询软件列表的信息
    List getFileUrl(@Param("lockFlag") Integer lockFlag, @Param("fileName") String fileName, @Param("applyMaterialCode") String applyMaterialCode
            ,@Param("applyModel") String applyModel, @Param("owner") String owner, @Param("boardNumber") String boardNumber, @Param("version") String version);

    //查询当前owner的未上传源码记录
    List<Software> getFileNameByOwnerWithCode(String owner);
}

 src/main/java/com/whyc/service/SoftwareService.java

@@ -6,6 +6,7 @@
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.whyc.constant.UserOperation;
import com.whyc.dto.CodeFilesDto;
import com.whyc.dto.FileDirPath;
import com.whyc.dto.Response;
import com.whyc.dto.SoftDto;
@@ -36,6 +37,7 @@
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.time.ZoneId;
import java.util.ArrayList;
import java.util.Date;
import java.util.LinkedList;
import java.util.List;
@@ -367,7 +369,7 @@
        Date starttime=Date.from(startOfDay.atZone(ZoneId.systemDefault()).toInstant());

        QueryWrapper wrapper=new QueryWrapper();
        wrapper.select("distinct file_name","type","version","based_version","owner","filing_date","create_time","owner");
        wrapper.select("distinct file_name","type","version","based_version","owner","filing_date","create_time");
        wrapper.ge("create_time",starttime);
        wrapper.le("create_time",endtime);
        wrapper.eq("owner",ActionUtil.getUser().getName());
@@ -376,4 +378,32 @@
        //List<String> nameList = list.stream().map(Software::getFileName).collect(Collectors.toList());
        return new Response().setII(1,list!=null,list,"查询日期三天内的所有上传软件");
    }
    //查询当前owner的未上传源码记录
    public Response getFileNameByOwnerWithCode(String owner) {
        List<Software> list=mapper.getFileNameByOwnerWithCode(owner);
        return new Response().setII(1,list!=null,list,"查询当前owner的未上传源码记录");
    }
    //批量添加源码包
    public Response setCodeByFileNmaes(CodeFilesDto dto) {
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("num",dto.getNum());
        wrapper.last("limit 1");
        Softcode softcode=codeMapper.selectOne(wrapper);
        if(softcode==null){
            return new Response().set(1,false,"源码包不存在");
        }else{
            //获取list中fileName的集合
            List<String> nameList = dto.getFileNames();
            List<Softcode> softcodeList=new ArrayList<>();
            for (String fileName : nameList) {
                Softcode s=new Softcode();
                s.setFileName(fileName);
                s.setCodeUrl(softcode.getCodeUrl());
                s.setCodeName(softcode.getCodeName());
                s.setCreateTime(new Date());
            }
            codeMapper.insertBatchSomeColumn(softcodeList);
            return new Response().set(1,true,"批量添加源码包");
        }
    }
}

 src/main/resources/mapper/SoftwareMapper.xml

@@ -48,4 +48,10 @@
    <select id="selectSoftWare" resultType="software">
        select * from tb_software where file_url=#{fileUrl} and lock_flag = #{lockFlag}
    </select>
    <select id="getFileNameByOwnerWithCode" resultType="com.whyc.pojo.Software">
        SELECT distinct file_name,based_version,owner
        FROM tb_software w
        LEFT JOINtb_softcode c ON w.file_name = c.file_name
        WHERE c.file_name IS NULL;
    </select>
</mapper>