From 48679fc5bb7e8dc8b8d45a5d2373bd11dc612413 Mon Sep 17 00:00:00 2001 From: tangzy <tangzy123456> Date: Fri, 26 Nov 2021 10:02:27 +0800 Subject: [PATCH] 1.统计 --- src/main/java/org/springblade/modules/information/service/IInformationService.java | 39 +++++++++++++++++++++++++++++++++++++-- 1 files changed, 37 insertions(+), 2 deletions(-) diff --git a/src/main/java/org/springblade/modules/information/service/IInformationService.java b/src/main/java/org/springblade/modules/information/service/IInformationService.java index 649b79f..b848b49 100644 --- a/src/main/java/org/springblade/modules/information/service/IInformationService.java +++ b/src/main/java/org/springblade/modules/information/service/IInformationService.java @@ -22,6 +22,7 @@ import org.springblade.modules.information.vo.InformationVO; import com.baomidou.mybatisplus.extension.service.IService; import com.baomidou.mybatisplus.core.metadata.IPage; +import org.springblade.modules.information.vo.ResponseVo; import java.util.List; import java.util.Map; @@ -71,14 +72,14 @@ Map selectWPcount(String jurisdiction,String deptid); List<Map<Object,Object>> selectIn(String jurisdiction); void deleteDept(String ids); - IPage selectLi(IPage<List> page,String jurisdiction, String deptid,String stats); + IPage selectLi(IPage<List> page,String jurisdiction, String deptid,String stats,String startTime,String endTime); List<Map<Object,Object>> seCountI(String jurisdiction,String deptid); String seCountUm(String jurisdiction,String deptid); String seCountUg(String jurisdiction,String deptid); Map<String, String> queryYearPz(String year,String jurisdiction,String deptid); IPage selectTb(IPage<List> page,String jurisdiction,String enterpriseName); IPage selectJj(IPage<List> page,String jurisdiction,String enterpriseName); - IPage selectYw(IPage<List> page,String jurisdiction,String deptid,String stats); + IPage selectYw(IPage<List> page,String jurisdiction,String deptid,String stats,String startTime,String endTime); IPage selectUIn(IPage<List> page,String deptid,String name,String hold,String photo,String examinationtype,String dispatch,String soil); IPage selectDis(IPage<List> page,String jurisdiction,String deptid,String fid); List<Map<Object,Object>> selectFw(); @@ -169,4 +170,38 @@ * @return */ IPage<InformationVO> getSecurityUnitInsuranceLessPage(IPage<InformationVO> page, InformationVO information); + + /** + * 分局表现差的数量 + * @param jurisdiction + * @return + */ + List<Map<Object,Object>> selectBxs(String jurisdiction); + List<Map<String, Object>> seleP(String jurisdiction,String deptid); + + /** + * 统计表现差的信息 + * @return + */ + List<ResponseVo> getSecurityPerformanceGroupCountList(); + + /** + * 统计资格审查异常信息 + * @return + */ + List<ResponseVo> getSecurityExaminationGroupCountList(); + + /** + * 考试通过率低于50% + * @return + */ + List<ResponseVo> getSecurityExamPassingGroupCountList(); + + /** + * 查询 1 持证率低于50%, 2 社保缴纳率低于50%, 3 派遣率低于50% + * @param type 1 持证率低于50%, 2 社保缴纳率低于50%, 3 派遣率低于50% + * @return + */ + List<ResponseVo> getSecurityHoldAndSoidAndDispatchGroupCountList(Integer type); + List<Map<Object,Object>> seleFj(String jurisdiction); } -- Gitblit v1.9.3