From ebeecf61232967a9c21ca4aa63ccec8e269b8c0e Mon Sep 17 00:00:00 2001 From: fei <791364011@qq.com> Date: 星期一, 29 九月 2025 09:13:58 +0800 Subject: [PATCH] Merge branch 'master' of http://47.93.189.255:8099/r/archiveSystem --- archiveManager/src/main/java/com/ruoyi/service/impl/ArchiveRecordsServiceImpl.java | 164 ++++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 145 insertions(+), 19 deletions(-) diff --git a/archiveManager/src/main/java/com/ruoyi/service/impl/ArchiveRecordsServiceImpl.java b/archiveManager/src/main/java/com/ruoyi/service/impl/ArchiveRecordsServiceImpl.java index 22f5ae5..c7c3d40 100644 --- a/archiveManager/src/main/java/com/ruoyi/service/impl/ArchiveRecordsServiceImpl.java +++ b/archiveManager/src/main/java/com/ruoyi/service/impl/ArchiveRecordsServiceImpl.java @@ -11,13 +11,18 @@ import com.ruoyi.common.utils.MapUtils; import com.ruoyi.common.utils.SecurityUtils; import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.domain.ArchiveRecords; import com.ruoyi.domain.Archiverecordstouser; +import com.ruoyi.domain.vo.AnalysisResult; +import com.ruoyi.domain.vo.ArchiveInfoVo; +import com.ruoyi.domain.vo.ArchiveRecordSmall; import com.ruoyi.mapper.ArchiveRecordsMapper; import com.ruoyi.mapper.ArchiverecordstouserMapper; import com.ruoyi.service.IArchiveRecordsService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import org.springframework.web.multipart.MultipartFile; /** * 妗f璁板綍Service涓氬姟灞傚鐞� @@ -37,13 +42,38 @@ - private LambdaQueryWrapper<ArchiveRecords> buildCondition(ArchiveRecords archiveRecords){ + private LambdaQueryWrapper<ArchiveRecords> buildCondition(ArchiveRecords archiveRecords, Long userId){ LambdaQueryWrapper<ArchiveRecords> lqw = new LambdaQueryWrapper<>(); - lqw.like(!StringUtils.isEmpty(archiveRecords.getProjectName()), ArchiveRecords::getProjectName, archiveRecords.getProjectName()) + System.out.println(archiveRecords.getIds()); + + lqw.like(!StringUtils.isEmpty(archiveRecords.getRecordId()), ArchiveRecords::getRecordId, archiveRecords.getRecordId()) + .like(!StringUtils.isEmpty(archiveRecords.getInquiryNumber()), ArchiveRecords::getInquiryNumber, archiveRecords.getInquiryNumber()) + .like(!StringUtils.isEmpty(archiveRecords.getCaseTitle()), ArchiveRecords::getCaseTitle, archiveRecords.getCaseTitle()) + .like(!StringUtils.isEmpty(archiveRecords.getPublicAttribute()), ArchiveRecords::getPublicAttribute, archiveRecords.getPublicAttribute()) + .like(!StringUtils.isEmpty(archiveRecords.getPreparationUnit()), ArchiveRecords::getPreparationUnit, archiveRecords.getPreparationUnit()) + .like(!StringUtils.isEmpty(archiveRecords.getRetentionPeriod()), ArchiveRecords::getRetentionPeriod, archiveRecords.getRetentionPeriod()) + .like(!StringUtils.isEmpty(archiveRecords.getSecurityClassification()), ArchiveRecords::getSecurityClassification, archiveRecords.getSecurityClassification()) .like(!StringUtils.isEmpty(archiveRecords.getFilingNumber()), ArchiveRecords::getFilingNumber, archiveRecords.getFilingNumber()) + .like(!StringUtils.isEmpty(archiveRecords.getConstructionUnit()), ArchiveRecords::getConstructionUnit, archiveRecords.getConstructionUnit()) + .like(!StringUtils.isEmpty(archiveRecords.getConstructionAddress()), ArchiveRecords::getConstructionAddress, archiveRecords.getConstructionAddress()) + .like(!StringUtils.isEmpty(archiveRecords.getProjectName()), ArchiveRecords::getProjectName, archiveRecords.getProjectName()) + .like(!StringUtils.isEmpty(archiveRecords.getProjectNumber()), ArchiveRecords::getProjectNumber, archiveRecords.getProjectNumber()) + .like(!StringUtils.isEmpty(archiveRecords.getScanningCompany()), ArchiveRecords::getScanningCompany, archiveRecords.getScanningCompany()) .like(!StringUtils.isEmpty(archiveRecords.getArchiveRoomNumber()), ArchiveRecords::getArchiveRoomNumber, archiveRecords.getArchiveRoomNumber()) - .like(!StringUtils.isEmpty(archiveRecords.getRecordId()), ArchiveRecords::getRecordId, archiveRecords.getRecordId()); + .like(!StringUtils.isEmpty(archiveRecords.getMicrofilmNumber()), ArchiveRecords::getMicrofilmNumber, archiveRecords.getMicrofilmNumber()) + .like(!StringUtils.isEmpty(archiveRecords.getHistoricalReferenceNumber()), ArchiveRecords::getHistoricalReferenceNumber, archiveRecords.getHistoricalReferenceNumber()) + .eq(!StringUtils.isEmpty(archiveRecords.getRecordStatus()), ArchiveRecords::getRecordStatus, archiveRecords.getRecordStatus()) + .like(!StringUtils.isEmpty(archiveRecords.getEveryProjectName()), ArchiveRecords::getEveryProjectName, archiveRecords.getEveryProjectName()) + .like(!StringUtils.isEmpty(archiveRecords.getRemarks()), ArchiveRecords::getRemarks, archiveRecords.getRemarks()); + + + + if(archiveRecords.getIds()!=null) + lqw.in(ArchiveRecords::getId,new ArrayList<>(Arrays.asList(archiveRecords.getIds()))); + + + // .like(!StringUtils.isEmpty(zfProperty.getLocation()), ZfProperty::getLocation, zfProperty.getLocation()) // .like(!StringUtils.isEmpty(zfProperty.getHolder()), ZfProperty::getHolder, zfProperty.getHolder()) // .like(!StringUtils.isEmpty(zfProperty.getAddress()), ZfProperty::getAddress, zfProperty.getAddress()) @@ -53,9 +83,9 @@ // .eq(zfProperty.getHappenTime()!=null,ZfProperty::getHappenTime,zfProperty.getHappenTime()) // .between(zfProperty.getHappenStartTime() != null && zfProperty.getHappenEndTime() != null, ZfProperty::getHappenTime, zfProperty.getHappenStartTime(), zfProperty.getHappenEndTime()); // lqw.orderByDesc(ZfProperty::getCreateTime); - // lqw.orderByDesc(ArchiveRecords::isOwnData); - // lqw.orderByDesc(ArchiveRecords::getCreateTime); - lqw.orderByDesc(ArchiveRecords::getCreateTime); + if(userId==1) + + lqw.orderByDesc(ArchiveRecords::getCreateTime); System.out.println("ssssssssssssddd0000000000000000"); return lqw; @@ -69,8 +99,10 @@ @Override public AjaxResult selectDataList(ArchiveRecords archiveRecords, Integer pageNum, Integer pageSize) { - - LambdaQueryWrapper<ArchiveRecords> lqw = buildCondition(archiveRecords); + //鎷垮埌褰撳墠鐢ㄦ埛鐨刬d + // 鑾峰彇褰撳墠鐢ㄦ埛ID + Long userid = SecurityUtils.getUserId(); + LambdaQueryWrapper<ArchiveRecords> lqw = buildCondition(archiveRecords, userid); System.out.println("-------------"); System.out.println(pageNum); @@ -81,7 +113,7 @@ Page<ArchiveRecords> page = new Page<>(pageNum, pageSize); // 浣跨敤鑷畾涔夌殑鍒嗛〉鏌ヨ鏂规硶锛屽厛杩炴帴鍐嶅垎椤� - Page<ArchiveRecords> pageResult = this.baseMapper.selectJoinUserPage(page, lqw); + Page<ArchiveRecords> pageResult = this.baseMapper.selectJoinUserPage(page, userid, lqw); //selectJoinUserPage(page, lqw); @@ -92,9 +124,7 @@ // List<ArchiveRecords> beanRecords = list(lqw); // log.info("浠庢暟鎹簱涓煡鍒扮殑涓�:{}", beanRecords); // return markOwnData(familyId, fatherFaId, motherFaId, beanRecords); - //鎷垮埌褰撳墠鐢ㄦ埛鐨刬d - // 鑾峰彇褰撳墠鐢ㄦ埛ID - Long userid = SecurityUtils.getUserId(); + beanRecords.forEach(record ->{ if(record.isArchiveRecordsId()!=null&&record.getUserId()==userid) @@ -104,8 +134,9 @@ else record.setOwnData(false); }); - - // Collections.sort(beanRecords, Comparator.comparing(ArchiveRecords::isOwnData)); + //涓嶆槸绠$悊鍛樿繘琛屾帓搴� + // if(userid != 1) + // Collections.sort(beanRecords, Comparator.comparing(ArchiveRecords::isOwnData)); HashMap<String, Object> data = MapUtils.getResult(pageResult, beanRecords); // System.out.println(data.get("data")); // System.out.println(data.get("pageNum")); @@ -143,7 +174,10 @@ @Override public List<ArchiveRecords> selectArchiveRecordsList(ArchiveRecords archiveRecords) { - LambdaQueryWrapper<ArchiveRecords> lambdaQueryWrapper = buildCondition(archiveRecords); + //鎷垮埌褰撳墠鐢ㄦ埛鐨刬d + // 鑾峰彇褰撳墠鐢ㄦ埛ID + Long userid = SecurityUtils.getUserId(); + LambdaQueryWrapper<ArchiveRecords> lambdaQueryWrapper = buildCondition(archiveRecords,userid); List<ArchiveRecords> beanRecords = list(lambdaQueryWrapper); return beanRecords; @@ -162,7 +196,21 @@ Date date = Date.from(time.atZone(ZoneId.systemDefault()).toInstant()); archiveRecords.setCreateTime(date); + System.out.println(archiveRecords.getRecordId()); + //鏍规嵁妗e彿鏌ヨ锛屾槸鍚﹀凡缁忔湁妗e彿锛屾湁鐨勮瘽锛屽氨涓嶈鎻掑叆 + LambdaQueryWrapper<ArchiveRecords> lambdaQueryWrapper = new LambdaQueryWrapper<>(); + lambdaQueryWrapper.eq(!StringUtils.isEmpty(archiveRecords.getRecordId()), ArchiveRecords::getRecordId, + archiveRecords.getRecordId()); + List<ArchiveRecords> lis = list(lambdaQueryWrapper); + if(!lis.isEmpty()) + { + return 0; + } + archiveRecords.setRecordStatus("鏈綍鍏�"); + // archiveRecords boolean res = this.save(archiveRecords); + + //0琛ㄧず澶辫触锛�1琛ㄧず鎴愬姛 if(res) return 1; else @@ -194,11 +242,13 @@ @Override public int deleteArchiveRecordsByIds(Long[] ids) { - if (this.removeByIds(Arrays.asList(ids))) { - return 1; + Long res = 0L; + for(Long id: ids) + { + this.baseMapper.updateAllInfoById(id); + } - else - return 0; + return 1; } /** @@ -212,4 +262,80 @@ { return 0; } + + @Override + public ArchiveInfoVo selectByRecordId(Long id) { + return this.baseMapper.findByRecordId(id); + } + + @Override + public AjaxResult importExcel(MultipartFile file) { + ExcelUtil<ArchiveRecords> util = new ExcelUtil<>(ArchiveRecords.class); + List<ArchiveRecords> dataList = null; + try { + dataList = util.importExcel(file.getInputStream()); + } catch (Exception e) { + throw new RuntimeException("娌℃湁鎸夌収瑙勫垯瀵煎叆鏁版嵁"); + } + + assert dataList != null; + + for (ArchiveRecords archiveRecords : dataList) { + // physcialService.mySave(physcial); + this.mySave(archiveRecords); + } + + return AjaxResult.success(); + } + + @Override + public List<AnalysisResult> statisticAya() { + return this.baseMapper.statisticAyasis(); + } + + @Override + public int updateArchiveById(Long id) { + this.baseMapper.updateStatusById(id); + return 0; + } + + @Override + public int updateStatusByIds(Long[] ids) { + for(Long id : ids) + this.baseMapper.updateStatusById(id); + return 0; + } + + @Override + public List<ArchiveRecordSmall> findByIds(ArchiveRecords archiveRecords) { + + LambdaQueryWrapper<ArchiveRecords> lqw = new LambdaQueryWrapper<>(); + if(archiveRecords.getIds()!=null) + lqw.in(ArchiveRecords::getId,new ArrayList<>(Arrays.asList(archiveRecords.getIds()))); + return this.baseMapper.selectByIds(lqw); + } + + + public AjaxResult mySave(ArchiveRecords archiveRecords) { + + + //妫�鏌ユ槸鍚︽湁閲嶅鏁版嵁鎻掑叆 + LambdaQueryWrapper<ArchiveRecords> lqw = new LambdaQueryWrapper<>(); + lqw.eq(!StringUtils.isEmpty(archiveRecords.getRecordId()), ArchiveRecords::getRecordId,archiveRecords.getRecordId()); + List<ArchiveRecords> list = list(lqw); + if (list.size() > 0) { + // throw new RuntimeException("璇峰嬁鏂板閲嶅鏁版嵁"); + //濡傛灉鏈夐噸澶嶆暟鎹紝鍒欐牴鎹畆ecordId杩涜鏁版嵁淇敼 + this.baseMapper.update(archiveRecords, lqw); + return AjaxResult.success(); + } + else { + if (save(archiveRecords)) { + return AjaxResult.success(); + } else { + return AjaxResult.error(); + } + } + + } } -- Gitblit v1.9.1