From 0fdd6b6113fe6e120ca5731fbab562f56eca8ae5 Mon Sep 17 00:00:00 2001 From: fei <791364011@qq.com> Date: 星期一, 22 九月 2025 08:29:09 +0800 Subject: [PATCH] 新增了代码 --- archiveManager/src/main/java/com/ruoyi/service/impl/ArchiveRecordsServiceImpl.java | 115 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 110 insertions(+), 5 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 4036f57..834babd 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涓氬姟灞傚鐞� @@ -40,10 +45,18 @@ private LambdaQueryWrapper<ArchiveRecords> buildCondition(ArchiveRecords archiveRecords, Long userId){ LambdaQueryWrapper<ArchiveRecords> lqw = new LambdaQueryWrapper<>(); + System.out.println(archiveRecords.getIds()); lqw.like(!StringUtils.isEmpty(archiveRecords.getProjectName()), ArchiveRecords::getProjectName, archiveRecords.getProjectName()) .like(!StringUtils.isEmpty(archiveRecords.getFilingNumber()), ArchiveRecords::getFilingNumber, archiveRecords.getFilingNumber()) .like(!StringUtils.isEmpty(archiveRecords.getArchiveRoomNumber()), ArchiveRecords::getArchiveRoomNumber, archiveRecords.getArchiveRoomNumber()) - .like(!StringUtils.isEmpty(archiveRecords.getRecordId()), ArchiveRecords::getRecordId, archiveRecords.getRecordId()); + .like(!StringUtils.isEmpty(archiveRecords.getRecordId()), ArchiveRecords::getRecordId, archiveRecords.getRecordId()) + .eq(!StringUtils.isEmpty(archiveRecords.getRecordStatus()), ArchiveRecords::getRecordStatus, archiveRecords.getRecordStatus()) + ; + 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()) @@ -166,7 +179,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 @@ -198,11 +225,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; } /** @@ -216,4 +245,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