From cf9a5039e6db9d1d5963e3fe1a37d00169ec2ef7 Mon Sep 17 00:00:00 2001 From: whyclxw <810412026@qq.com> Date: 星期三, 25 六月 2025 11:18:22 +0800 Subject: [PATCH] 验收报告修改 --- src/main/java/com/whyc/service/SoftwareService.java | 84 +++++++++++++++++++++++++++++++++++++++++- 1 files changed, 82 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/whyc/service/SoftwareService.java b/src/main/java/com/whyc/service/SoftwareService.java index d66ac7f..4c6b142 100644 --- a/src/main/java/com/whyc/service/SoftwareService.java +++ b/src/main/java/com/whyc/service/SoftwareService.java @@ -6,9 +6,13 @@ 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; +import com.whyc.mapper.SoftcodeMapper; import com.whyc.mapper.SoftwareMapper; +import com.whyc.pojo.Softcode; import com.whyc.pojo.Software; import com.whyc.util.ActionUtil; import com.whyc.util.CommonUtil; @@ -29,6 +33,11 @@ import java.io.*; import java.net.URLEncoder; import java.text.ParseException; +import java.time.LocalDate; +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; @@ -38,6 +47,9 @@ public class SoftwareService { @Autowired(required = false) private SoftwareMapper mapper; + + @Autowired(required = false) + private SoftcodeMapper codeMapper; @Autowired private DocLogService logService; @@ -134,9 +146,26 @@ } //鏌ヨ杞欢鍒楄〃鐨勪俊鎭� - public Response getAllSoftware(Integer lockFlag, String fileName, String applyMaterialCode, String applyModel, String owner, String boardNumber, int pageCurr, int pageSize) { + public Response getAllSoftware(Integer lockFlag, String fileName, String applyMaterialCode, String applyModel, String owner, String boardNumber + ,String version, int pageCurr, int pageSize) { PageHelper.startPage(pageCurr,pageSize); - List list=mapper.getFileUrl(lockFlag,fileName,applyMaterialCode,applyModel,owner,boardNumber); + List<SoftDto> list=mapper.getFileUrl(lockFlag,fileName,applyMaterialCode,applyModel,owner,boardNumber,version); + //鏍规嵁杞欢鍚嶇О鏌ヨ鏄惁瀛樺湪婧愮爜锛�0锛氬惁锛�1锛氬瓨鍦級 + for (SoftDto dto:list) { + QueryWrapper wrapper=new QueryWrapper(); + wrapper.eq("file_name",dto.getFileName()); + wrapper.last("limit 1"); + Softcode code=codeMapper.selectOne(wrapper); + if(code!=null){ + dto.setCodeNum(code.getNum()); + dto.setCodeFlag(1); + dto.setCodeName(code.getCodeName()); + }else{ + dto.setCodeNum(0); + dto.setCodeFlag(0); + dto.setCodeName(""); + } + } PageInfo pageInfo=new PageInfo(list); return new Response().setII(1,list.size()>0,pageInfo,"杞欢淇℃伅杩斿洖"); } @@ -329,4 +358,55 @@ int flag=mapper.delete(wrapper); return new Response().set(1,flag>0,"浠秈d瀹炵幇杞欢鍒犻櫎"); } + + //鏌ヨ鏃ユ湡涓夊ぉ鍐呯殑鎵�鏈変笂浼犺蒋浠� + public Response getFileNameByCreateTime(String createTime) { + //鑾峰彇endtime鐨勪笁澶╁墠鐨勬椂闂� + LocalDate createDay= LocalDate.parse(createTime); + LocalDateTime end = createDay.atTime(LocalTime.MAX); + Date endtime=Date.from(end.atZone(ZoneId.systemDefault()).toInstant()); + //鑾峰彇createTime鐨勪笁澶╁墠鐨勬椂闂� + LocalDate threeDaysAgo = createDay.minusDays(3); + LocalDateTime startOfDay = threeDaysAgo.atStartOfDay(); + 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"); + wrapper.ge("create_time",starttime); + wrapper.le("create_time",endtime); + wrapper.eq("owner",ActionUtil.getUser().getName()); + List<Software> list=mapper.selectList(wrapper); + //鑾峰彇list涓璮ileName鐨勯泦鍚� + //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涓璮ileName鐨勯泦鍚� + 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()); + softcodeList.add(s); + } + codeMapper.insertBatchSomeColumn(softcodeList); + return new Response().set(1,true,"鎵归噺娣诲姞婧愮爜鍖�"); + } + } } -- Gitblit v1.9.1