From ba421d977e745d18a6264353c739bcaaf44c40d6 Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期一, 08 四月 2024 18:39:41 +0800
Subject: [PATCH] 历史数据模块接口
---
ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbDeptServiceImpl.java | 125 +++++++++++++++++++++++++++++------------
1 files changed, 88 insertions(+), 37 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbDeptServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbDeptServiceImpl.java
index dfe0464..0237113 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbDeptServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbDeptServiceImpl.java
@@ -3,17 +3,24 @@
import cn.afterturn.easypoi.excel.ExcelImportUtil;
import cn.afterturn.easypoi.excel.entity.ImportParams;
import cn.afterturn.easypoi.excel.entity.result.ExcelImportResult;
-import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
-import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.ruoyi.common.basic.PageVO;
-import com.ruoyi.common.utils.StringUtils;
-import com.ruoyi.common.utils.bean.BeanUtils;
+import com.ruoyi.common.basic.PageDTO;
+import com.ruoyi.common.core.domain.R;
+import com.ruoyi.common.core.domain.entity.SysUser;
+import com.ruoyi.common.enums.ReportingStatusEnum;
+import com.ruoyi.common.enums.UserTypeEnum;
+import com.ruoyi.common.exception.ServiceException;
+import com.ruoyi.common.utils.*;
+import com.ruoyi.system.domain.TbBasicData;
import com.ruoyi.system.domain.TbDept;
+import com.ruoyi.system.dto.update.DeptFocusDTO;
import com.ruoyi.system.handler.DeptVerifyHandler;
+import com.ruoyi.system.importExcel.DeptExcel;
import com.ruoyi.system.mapper.TbDeptMapper;
import com.ruoyi.system.query.DeptQuery;
+import com.ruoyi.system.service.ISysUserService;
+import com.ruoyi.system.service.TbBasicDataService;
import com.ruoyi.system.service.TbDeptService;
import com.ruoyi.system.vo.DeptVO;
import lombok.RequiredArgsConstructor;
@@ -22,9 +29,12 @@
import org.springframework.util.CollectionUtils;
import org.springframework.web.multipart.MultipartFile;
-import javax.servlet.http.HttpServletResponse;
import java.io.InputStream;
+import java.time.Instant;
+import java.time.LocalDate;
+import java.time.ZoneId;
import java.util.*;
+import java.util.stream.Collectors;
/**
* <p>
@@ -37,29 +47,26 @@
@Service
@RequiredArgsConstructor
public class TbDeptServiceImpl extends ServiceImpl<TbDeptMapper, TbDept> implements TbDeptService {
+
private final DeptVerifyHandler deptVerifyHandler;
- private final HttpServletResponse response;
+ private final ISysUserService sysUserService;
+ private final TbBasicDataService tbBasicDataService;
+
@Override
- public PageVO<DeptVO> queryPage(DeptQuery query) {
- Page<TbDept> page = new Page<>(query.getPageNum(), query.getPageSize());
- LambdaQueryWrapper<TbDept> queryWrapper = new LambdaQueryWrapper<TbDept>()
- .like(StringUtils.isNotEmpty(query.getAreaName()), TbDept::getAreaName, query.getAreaName())
- .like(StringUtils.isNotEmpty(query.getAccount()), TbDept::getAccount, query.getAccount())
- .like(StringUtils.isNotEmpty(query.getPhone()), TbDept::getPhone, query.getPhone())
- .orderByDesc(TbDept::getCreateTime);
- Page<TbDept> deptPage = this.baseMapper.selectPage(page, queryWrapper);
- PageVO<DeptVO> pageVO = new PageVO<>();
- pageVO.setPageNo(deptPage.getPages());
- pageVO.setPageSize(deptPage.getSize());
- pageVO.setTotalPages(deptPage.getTotal());
- pageVO.setTotalCount(deptPage.getTotal());
- IPage<DeptVO> convert = deptPage.convert(result -> {
- DeptVO deptVO = new DeptVO();
- BeanUtils.copyBeanProp(deptVO, result);
- return deptVO;
- });
- pageVO.setRecords(convert.getRecords());
- return pageVO;
+ public PageDTO<DeptVO> queryPage(DeptQuery query) {
+ Page<SysUser> page = new Page<>(query.getPageNum(), query.getPageSize());
+ Page<SysUser> userPage = sysUserService.lambdaQuery()
+ .eq(SysUser::getUserType, UserTypeEnum.DEPARTMENT.getCode())
+ .like(StringUtils.isNotEmpty(query.getAreaName()), SysUser::getAreaName, query.getAreaName())
+ .like(StringUtils.isNotEmpty(query.getUserName()), SysUser::getUserName, query.getUserName())
+ .like(StringUtils.isNotEmpty(query.getPhone()), SysUser::getPhoneNumber, query.getPhone())
+ .orderByDesc(SysUser::getCreateTime)
+ .page(page);
+
+ if (CollUtils.isEmpty(userPage.getRecords())) {
+ return PageDTO.empty(page);
+ }
+ return PageDTO.of(userPage, DeptVO.class);
}
@Override
@@ -73,34 +80,78 @@
//使用自定义校验规则
importParams.setVerifyHandler(deptVerifyHandler);
InputStream inputStream = file.getInputStream();
- ExcelImportResult<TbDept> result = ExcelImportUtil.importExcelMore(inputStream, TbDept.class, importParams);
+ ExcelImportResult<DeptExcel> result = ExcelImportUtil.importExcelMore(inputStream, DeptExcel.class, importParams);
inputStream.close();
- List<TbDept> list = result.getList();
- if (Objects.requireNonNull(result).isVerfiyFail() || CollectionUtils.isEmpty(list)) {
- throw new RuntimeException("文件校验失败，请检查数据填写是否完整");
+ List<DeptExcel> list = result.getList();
+
+ if (result.isVerifyFail() || CollectionUtils.isEmpty(list)) {
+ throw new ServiceException("文件校验失败，请检查数据填写是否完整");
}
List<String> strings = hasDuplicateAreaCode(list);
if (!CollectionUtils.isEmpty(strings)) {
- throw new RuntimeException(String.format("区划代码%s重复，请修改后重新导入", String.join(",", strings)));
+ throw new ServiceException(String.format("区划代码%s重复，请修改后重新导入", String.join(",", strings)));
}else {
+ List<TbDept> tbDeptList = BeanUtils.copyList(list, TbDept.class);
this.remove(null);
- this.saveBatch(list);
+ tbDeptList.forEach(dept->{
+ dept.setPassword(SecurityUtils.encryptPassword(dept.getPassword()));
+ });
+ this.saveBatch(tbDeptList);
}
}
/**
* 校验区划代码是否重复
- * @param deptList
- * @return
+ * @param deptList 部门列表
+ * @return 重复的区划代码
*/
- public List<String> hasDuplicateAreaCode(List<TbDept> deptList) {
+ public List<String> hasDuplicateAreaCode(List<DeptExcel> deptList) {
Set<String> areaCodes = new HashSet<>();
List<String> result = new ArrayList<>();
- for (TbDept dept : deptList) {
+ for (DeptExcel dept : deptList) {
if (!areaCodes.add(dept.getAreaCode())) {
result.add(dept.getAreaCode());
}
}
return result;
}
+
+ @Override
+ public void focus(DeptFocusDTO dto) {
+ Optional<SysUser> sysUser = sysUserService.lambdaQuery().eq(SysUser::getUserId, dto.getUserId()).oneOpt();
+ if (sysUser.isPresent()) {
+ sysUserService.lambdaUpdate()
+ .eq(SysUser::getUserId, dto.getUserId())
+ .set(SysUser::getFocussed, dto.getFocussed())
+ .update();
+ }
+ }
+
+ @Override
+ public R<Void> reportingMessage() {
+ Map<String, Date> quarterDate = DateUtils.getQuarterDate(new Date());
+ //当前季度开始
+ Date quarterStart = quarterDate.get("first");
+ //当前季度结束
+ Date quarterEnd = quarterDate.get("last");
+ //判断当前时间是否在季度初1-15号
+ Instant instant = quarterStart.toInstant();
+ LocalDate quarterStartLocalDate = instant.atZone(ZoneId.systemDefault()).toLocalDate();
+ LocalDate fifteenDaysLimit = quarterStartLocalDate.plusDays(15);
+ LocalDate now = LocalDate.now();
+ //如果当前时间不在规定范围内：季度初1-15号
+ if (now.isAfter(quarterStartLocalDate) || now.isBefore(fifteenDaysLimit)) {
+ //查询所有的部门
+ List<SysUser> list = sysUserService.lambdaQuery().eq(SysUser::getUserType, UserTypeEnum.DEPARTMENT.getCode()).list();
+ Set<String> deptAreaCodeList = list.stream().map(SysUser::getAreaCode).collect(Collectors.toSet());
+ //查询当前季度填报了数据的部门
+ List<TbBasicData> filledBasicData = tbBasicDataService.lambdaQuery().between(TbBasicData::getCreateTime, quarterStartLocalDate, fifteenDaysLimit)
+ .eq(TbBasicData::getStatus, ReportingStatusEnum.FILLED).list();
+ Set<String> filledDeptCodes = filledBasicData.stream().map(TbBasicData::getDeptAreaCode).collect(Collectors.toSet());
+ if (!filledDeptCodes.containsAll(deptAreaCodeList)) {
+ return R.fail("有部门未上传季度数据");
+ }
+ }
+ return R.ok();
+ }
}
--
Gitblit v1.7.1