From 3432fad3ebcecd73d3d50fa8dfb7934cc61cfd06 Mon Sep 17 00:00:00 2001 From: Administrator <admin> Date: Mon, 16 Aug 2021 15:04:16 +0800 Subject: [PATCH] 保安员查询新增审查排序 --- src/main/java/org/springblade/modules/information/mapper/InformationMapper.java | 26 ++++++++++++++++++++------ 1 files changed, 20 insertions(+), 6 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 c59468f..324434d 100644 --- a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java +++ b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java @@ -44,20 +44,34 @@ void deleteSh(String creditcode); void deleteMe(String creditcode); Map selectCount(String departmentid); + Map selectPcount(String jurisdiction,String deptid); + Map selectWPcount(String jurisdiction,String deptid); 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); + List<Map<Object,Object>> queryCountB(String jurisdiction,String deptid); + List<Map<Object,Object>> selectLi(String jurisdiction,String deptid); + 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); + List<Map<Object,Object>> queryCountKh(String jurisdiction,String deptid); + List<Map<Object,Object>> queryCountPq(String jurisdiction,String deptid); + List<Map<Object,Object>> selectJur(); + int selectExtypeUser(); + List<Map<Object,Object>> selectExtype(String jurisdiction,String deptid,String type); + List<Map<Object,Object>> selectBx(String jurisdiction,String deptid,String type); + List<Map<Object,Object>> seCountI(String jurisdiction,String deptid); + String seCountUm(String jurisdiction,String deptid); + String seCountUg(String jurisdiction,String deptid); + List<Map<Object,Object>> selectIn(String jurisdiction); 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); + Map<String, String> queryYearBanan(String year,String jurisdiction,String deptid); + Map<String, String> queryYearDe(String year,String jurisdiction,String deptid); + void deleteDept(String ids); } -- Gitblit v1.9.3