From 5cdadbb29f95f35b5eabdc733ce60b16d0338037 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Tue, 20 Jul 2021 09:29:06 +0800
Subject: [PATCH] 1.保安员证编码

---
 src/main/java/org/springblade/modules/information/mapper/InformationMapper.java |   17 ++++++++++++++++-
 1 files changed, 16 insertions(+), 1 deletions(-)

diff --git a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
index c6c547d..c59468f 100644
--- a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
+++ b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
@@ -44,5 +44,20 @@
 	void deleteSh(String creditcode);
 	void deleteMe(String creditcode);
 	Map selectCount(String departmentid);
-	List<Map<Object,String>> selectInCount();
+	List<Map<Object,String>> selectInCount(String jurisdiction,String deptid);
+	List<Map<String, Object>> selectCs(String jurisdiction,String deptid);
+	List<Map<String, Object>> selectTo(String jurisdiction,String deptid);
+	Map<String, String> queryYearSoil(String year,String jurisdiction,String deptid);
+	Map<String, String> queryYearAn(String year,String jurisdiction,String deptid);
+	List<Map<Object,Integer>> queryCountB(String jurisdiction,String deptid);
+	List<Map<Object,Integer>> queryCountZc(String jurisdiction,String deptid);
+	List<Map<Object,Integer>> queryCountCz(String jurisdiction,String deptid);
+	List<Map<Object,Integer>> queryCountSb(String jurisdiction,String deptid);
+	List<Map<Object,Integer>> queryCountKh(String jurisdiction,String deptid);
+	List<Map<Object,Integer>> queryCountPq(String jurisdiction,String deptid);
+
+	Map<String, String> queryYearZ(String year,String jurisdiction,String deptid);
+	Map<String, String> queryYearZc(String year,String jurisdiction,String deptid);
+	Map<String, String> queryYearCz(String year,String jurisdiction,String deptid);
+	Map<String, String> queryYearKh(String year,String jurisdiction,String deptid);
 }

--
Gitblit v1.9.3