whyclxw
2025-03-13 90f2637328f765b3db59333b8c615e61e3365afc
批量添加源码包
2个文件已修改
8 ■■■■■ 已修改文件
src/main/java/com/whyc/service/SoftwareService.java 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/mapper/SoftwareMapper.xml 7 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/whyc/service/SoftwareService.java
@@ -401,6 +401,7 @@
                s.setCodeUrl(softcode.getCodeUrl());
                s.setCodeName(softcode.getCodeName());
                s.setCreateTime(new Date());
                softcodeList.add(s);
            }
            codeMapper.insertBatchSomeColumn(softcodeList);
            return new Response().set(1,true,"批量添加源码包");
src/main/resources/mapper/SoftwareMapper.xml
@@ -49,9 +49,10 @@
        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
        SELECT distinct w.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;
        LEFT JOIN tb_softcode c ON w.file_name = c.file_name
        WHERE c.file_name IS NULL
        and w.owner = #{owner};
    </select>
</mapper>