From e32293a0fa1f6bffbb0d6b7650e637861b194191 Mon Sep 17 00:00:00 2001 From: lxw <810412026@qq.com> Date: 星期三, 08 二月 2023 17:08:09 +0800 Subject: [PATCH] 历史产品信息查看(产品中有0120开头的物料其实是产品,查看产品信息) --- src/main/java/com/whyc/service/ProductBomHistoryService.java | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 55 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/whyc/service/ProductBomHistoryService.java b/src/main/java/com/whyc/service/ProductBomHistoryService.java index 2935ea5..47ad191 100644 --- a/src/main/java/com/whyc/service/ProductBomHistoryService.java +++ b/src/main/java/com/whyc/service/ProductBomHistoryService.java @@ -149,6 +149,61 @@ fIleSilkLock.setAttachLocks(attachLocks); return new Response().setIIII(1,list.size()>0,list,listsoft,fIleSilkLock,"杩斿洖鐗╂枡淇℃伅鍙婂叧鑱旂墿鏂�"); } + //鍘嗗彶浜у搧淇℃伅鏌ョ湅锛堜骇鍝佷腑鏈�0120寮�澶寸殑鐗╂枡鍏跺疄鏄骇鍝侊紝鏌ョ湅浜у搧淇℃伅锛� + public Response getBomHistoryAndMaterial_0120(String parentCode, String parentName, String parentModel) { + + QueryWrapper wrapper=new QueryWrapper(); + wrapper.eq("parent_code",parentCode); + wrapper.eq("parent_name",parentName); + wrapper.eq("parent_model",parentModel); + wrapper.last("limit 1"); + ProductHistory pHistory=pHistoryMapper.selectOne(wrapper); + int productId =pHistory.getId(); + int version = pHistory.getVersion(); + List<ProductBomHistory> list=mapper.getBomHistoryAndMaterial(productId,pHistory.getSubVersionMax()); + if(list!=null&&list.size()>0){ + list.stream().forEach(bomH -> { + if(bomH.getDwgUrl()!=null){ + QueryWrapper qwrapper=new QueryWrapper(); + qwrapper.eq("material_id",bomH.getMaterialId()); + qwrapper.eq("attach_name",bomH.getDwgUrl().substring(bomH.getDwgUrl().lastIndexOf("\\")+1)); + qwrapper.eq("lock_flag",1); + qwrapper.last("limit 1"); + AttachLock attachLock=attachLockMapper.selectOne(qwrapper); + if(attachLock!=null){ + bomH.setDwgUrl(""); + } + } + }); + } + //鏌ヨ浜у搧鐨勮蒋浠� + List<Software> listsoft=mapper.selectSoftware(pHistory.getParentCode()); + //灏嗘病鏈夌鐞咮OM鐨刣wg鏂囦欢 + String withOutDwg="doc_file/product"+File.separator+pHistory.getParentModel(); + if(pHistory.getCustomCode()!=null&&!pHistory.getCustomCode().isEmpty()){ + withOutDwg+=File.separator+pHistory.getCustomCode()+File.separator+version; + }else{ + withOutDwg+=File.separator+"standard"+File.separator+version; + } + String fileDirName = FileDirPath.getFileDirName(); + //灏嗘病鏈夌鐞咮OM鐨刣wg鏂囦欢(涓濆嵃)鎷疯礉涓嬭浇 + fileDirName=fileDirName+File.separator+withOutDwg; + File start = new File(fileDirName); + FIleSilkLock fIleSilkLock=new FIleSilkLock(); + String[] files =new String[]{}; + if(start.exists()) { + files= start.list();//鑾峰彇璇ユ枃浠跺す涓嬬殑鎵�鏈夋枃浠跺悕瀛� + if(files.length>=0){ + for(int i=0;i<files.length;i++) { + files[i]=withOutDwg+File.separator+files[i]; + fIleSilkLock.setFiles(files); + } + } + } + List<AttachLock> attachLocks=mapper.selectInAttachLock(productId); + fIleSilkLock.setAttachLocks(attachLocks); + return new Response().setIIII(1,list.size()>0,list,listsoft,fIleSilkLock,"杩斿洖鐗╂枡淇℃伅鍙婂叧鑱旂墿鏂�"); + } //鍘嗗彶浜у搧涓嬭浇(浜у搧id鍜岀増鏈�<涓嬭浇鐨勭増鏈�>) public void downloadProductHistory(HttpServletRequest req, HttpServletResponse resp, int productId, int version) { //璇诲彇浜у搧淇℃伅 -- Gitblit v1.9.1