From 960ddab080d2434277bb75c188e2f7380856997e Mon Sep 17 00:00:00 2001
From: “djh” <“3298565835@qq.com”>
Date: Fri, 07 Mar 2025 14:33:53 +0800
Subject: [PATCH] 煤矿修改
---
exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java | 25 +++++++++++++++----------
1 files changed, 15 insertions(+), 10 deletions(-)
diff --git a/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java b/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java
index cbf03bc..48ec04b 100644
--- a/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java
+++ b/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java
@@ -10,10 +10,8 @@
import com.ruoyi.common.core.domain.model.LoginUser;
import com.ruoyi.common.exception.BusinessException;
import com.ruoyi.common.utils.SecurityUtils;
-import org.apache.poi.ss.usermodel.Row;
-import org.apache.poi.ss.usermodel.Sheet;
-import org.apache.poi.ss.usermodel.Workbook;
-import org.apache.poi.ss.usermodel.WorkbookFactory;
+import com.ruoyi.common.utils.StringUtils;
+import org.apache.poi.ss.usermodel.*;
import org.aspectj.weaver.loadtime.Aj;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
@@ -94,14 +92,20 @@
coalPayStudent.setCoalPayId(coalPayId);
if (row!=null){
coalPayStudent.setName(row.getCell(0).getStringCellValue());
- coalPayStudent.setIdCard(row.getCell(1).getStringCellValue());
+ String idCard = row.getCell(1).getStringCellValue();
+ coalPayStudent.setIdCard(idCard);
coalPayStudent.setPhone(row.getCell(2).getStringCellValue());
- String stringCellValue = row.getCell(3).getStringCellValue();
- if (stringCellValue.equals("男")){
- coalPayStudent.setSex(0L);
- }else if (stringCellValue.equals("女")){
- coalPayStudent.setSex(1L);
+ Cell cell = row.getCell(3);
+ if (cell!=null){
+ if (StringUtils.isEmpty(cell.getStringCellValue())){
+ coalPayStudent.setTrain("-");
+ }else{
+ coalPayStudent.setTrain(cell.getStringCellValue());
+ }
}
+
+ idCard = idCard.trim();
+ coalPayStudent.setSex((idCard.charAt(idCard.length() - 2) - '0') % 2 == 0 ? 1L : 0L);
coalPayStudent.setPayStatus(0L);
coalPayStudent.setCreateBy(loginUser.getUsername());
coalPayStudent.setCreateTime(new Date());
@@ -110,6 +114,7 @@
}
// 根据身份证号去重
List<CoalPayStudent> distinctStudents = coalPayStudents.stream()
+ .filter(student -> student.getIdCard()!=null)
.collect(Collectors.toMap(
CoalPayStudent::getIdCard, // 使用身份证号作为键
student -> student, // 使用学生对象作为值
--
Gitblit v1.9.2