From 19f40c8e0649ae81b3f0183a6f4c8aa6c3db39bc Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 18 Nov 2021 17:54:37 +0800
Subject: [PATCH] 证书打印信息导出修改,已过考试的,系统每天凌晨1点定时清理,标记为缺考,并生成缺考记录,保安员导入新增年龄判断,超过60岁的不能导入

---
 src/main/java/org/springblade/modules/accreditation/mapper/AccreditationRecordsMapper.java |   14 ++++++++++++++
 1 files changed, 14 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/accreditation/mapper/AccreditationRecordsMapper.java b/src/main/java/org/springblade/modules/accreditation/mapper/AccreditationRecordsMapper.java
index 789d5df..12ced06 100644
--- a/src/main/java/org/springblade/modules/accreditation/mapper/AccreditationRecordsMapper.java
+++ b/src/main/java/org/springblade/modules/accreditation/mapper/AccreditationRecordsMapper.java
@@ -53,4 +53,18 @@
 	 * 导出证书制证信息(包含照片)
 	 */
 	List<AccreditationRecordsVo> exportSecurityBookPapers(@Param("accreditationRecords") AccreditationRecordsVo accreditationRecords);
+
+	/**
+	 * 根据用户 id 查询上岗证申请记录
+	 * @param id 用户id
+	 * @return
+	 */
+	int getAccreditationRecordsByUserIdCount(@Param("userId") String id);
+
+	/**
+	 * 根据用户 id 查询当前人员是否有待审核和审核通过的记录数
+	 * @param id 用户id
+	 * @return
+	 */
+	int getAccreditationRecordsByUserIdAuditCount(@Param("userId") String id);
 }

--
Gitblit v1.9.3