From cdcd2d540de3e6ba4c2e9e7c6a879416da78c17b Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 16 Dec 2021 10:53:51 +0800
Subject: [PATCH] 保安员导出过多导致报错问题处理

---
 src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java |   10 ++++++++--
 1 files changed, 8 insertions(+), 2 deletions(-)

diff --git a/src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java b/src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java
index 97f5bcb..d221fdf 100644
--- a/src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java
+++ b/src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java
@@ -84,7 +84,7 @@
 			//判断类型,如果是证书的,审核未通过的可以再次申请,审核通过的,暂时不给于新增记录
 			if (accreditationRecords.getType()==2){
 				//查询当前人员是否有待审核和审核通过的记录数
-				int count  = baseMapper.getAccreditationRecordsByUserIdAuditCount(id);
+				int count  = baseMapper.getAccreditationRecordsByUserIdAuditCount(id,2);
 				if (count<1){
 					//新增
 					this.save(records);
@@ -135,6 +135,12 @@
 				excel.setRealName(accreditationRecordsVo.getRealName());
 				excel.setIdCardNo(accreditationRecordsVo.getIdCardNo());
 				excel.setDeptName(accreditationRecordsVo.getDeptName());
+				if (accreditationRecordsVo.getSex().equals("1")){
+					excel.setSex("男");
+				}else {
+					excel.setSex("女");
+				}
+				excel.setPaperTime(new SimpleDateFormat("yyyy-MM-dd").format(new Date()));
 				//如果头像有
 				if (null != accreditationRecordsVo.getAvatar() && accreditationRecordsVo.getAvatar() != "") {
 					try {
@@ -188,7 +194,7 @@
 	public List<AccreditationRecordsVo> exportSecurityBookPapers(AccreditationRecordsVo accreditationRecords) {
 		//查询数据
 		List<AccreditationRecordsVo> accreditationRecordsVos = baseMapper.exportSecurityBookPapers(accreditationRecords);
-		System.out.println("accreditationRecordsVos = " + accreditationRecordsVos.size());
+//		System.out.println("accreditationRecordsVos = " + accreditationRecordsVos.size());
 		return accreditationRecordsVos;
 	}
 }

--
Gitblit v1.9.3