From d907d12941bb8339b651900b0f85792367270e23 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Mon, 06 Dec 2021 13:51:13 +0800
Subject: [PATCH] 保安员统计查询修改
---
src/main/java/org/springblade/modules/information/mapper/InformationMapper.java | 56 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 55 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 fb6b7b1..ec5b39b 100644
--- a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
+++ b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
@@ -60,7 +60,19 @@
Map<String, String> queryYearPz(String year,String jurisdiction,String deptid);
Map<String, String> queryYearAn(String year,String jurisdiction,String deptid);
List<Map<Object,Object>> queryCountB(String jurisdiction,String deptid);
- List selectLi(IPage page, String jurisdiction, String deptid,String stats,String startTime,String endTime);
+
+ /**
+ * 保安员统计查询
+ * @param page
+ * @param jurisdiction
+ * @param deptid
+ * @param stats
+ * @param startTime
+ * @param endTime
+ * @return
+ */
+ List<InformationStatisticsVO> selectLi(IPage page, String jurisdiction, String deptid,String stats,String startTime,String endTime);
+
List<Map<Object,Object>> queryCountZc(String jurisdiction,String deptid);
List<Map<Object,Object>> queryCountCz(String jurisdiction,String deptid);
List<Map<Object,Object>> queryCountSb(String jurisdiction,String deptid);
@@ -233,4 +245,46 @@
*/
List<Dept> getDeptHashChildren(@Param("information") InformationVO informationVO);
List<Map<Object,Object>> selectBxc(IPage page, String jurisdiction,String type);
+
+ /**
+ * 查询单位的未派遣人数
+ * @param dept
+ * @return
+ */
+ Integer selectInformationNotDispatcherNumCount(@Param("dept")Dept dept);
+
+ /**
+ * 查询单位的已采集照片人数
+ * @param dept
+ * @return
+ */
+ Integer selectInformationUnitAvatarNumCount(@Param("dept")Dept dept);
+
+ /**
+ * 查询单位的未采集照片人数
+ * @param dept
+ * @return
+ */
+ Integer selectInformationUnitNotAvatarNumCount(@Param("dept")Dept dept);
+
+ /**
+ * 已采集指纹
+ * @param dept
+ * @return
+ */
+ Integer selectInformationUnitZwNumCount(@Param("dept")Dept dept);
+
+ /**
+ * 审查异常
+ * @param dept
+ * @return
+ */
+ Integer selectInformationUnitYcNumCount(@Param("dept")Dept dept);
+
+ /**
+ * 缴纳社保
+ * @param dept
+ * @return
+ */
+ Integer selectInformationUnitJnsbNumCount(@Param("dept")Dept dept);
}
--
Gitblit v1.9.3