From 30df94c05573a426d030510d4dd58ae1d93bfb7a Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Mon, 06 Dec 2021 14:03:37 +0800
Subject: [PATCH] 1.资格审查排序

---
 src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java |   70 +++++++++++++++++++++++++++++++++++
 1 files changed, 70 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java b/src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java
index 3f40c11..a018c85 100644
--- a/src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java
+++ b/src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java
@@ -22,6 +22,7 @@
 import org.springblade.modules.information.mapper.InformationMapper;
 import org.springblade.modules.information.service.IInformationService;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springblade.modules.information.vo.ResponseVo;
 import org.springframework.stereotype.Service;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 
@@ -286,6 +287,11 @@
 		return baseMapper.seleJuList(substring);
 	}
 
+	@Override
+	public List<Map<String, Object>> seleP(String jurisdiction, String deptid) {
+		return baseMapper.seleP(jurisdiction, deptid);
+	}
+
 	/**
 	 * 获取保安公司信息(本市保安公司,分公司)包含经纬度
 	 * @return
@@ -371,4 +377,68 @@
 	public IPage<InformationVO> getSubstationWarnInfoPage(IPage<InformationVO> page, InformationVO information) {
 		return page.setRecords(baseMapper.getSubstationWarnInfoPage(page, information));
 	}
+
+	/**
+	 * 根据辖区查询统计当前辖区下的保安公司(本市保安公司,分公司))服务对象小于2家的公司数量的分页信息
+	 * @param page  分页条件
+	 * @param information 查询条件
+	 * @return
+	 */
+	@Override
+	public IPage<InformationVO> getSecurityUnitServerLess2Page(IPage<InformationVO> page, InformationVO information) {
+		return page.setRecords(baseMapper.getSecurityUnitServerLess2Page(page, information));
+	}
+
+	/**
+	 * 根据辖区查询统计保安公司保险缴纳率低于90%的保安公司个数及保安公司分页信息(本市保安公司,分公司)
+	 * @param page  分页条件
+	 * @param information 查询条件
+	 * @return
+	 */
+	@Override
+	public IPage<InformationVO> getSecurityUnitInsuranceLessPage(IPage<InformationVO> page, InformationVO information) {
+		return page.setRecords(baseMapper.getSecurityUnitLess50Page(page,4, information));
+	}
+
+	/**
+	 * 统计表现差的信息
+	 * @return
+	 */
+	@Override
+	public List<ResponseVo> getSecurityPerformanceGroupCountList() {
+		return baseMapper.getSecurityPerformanceGroupCountList();
+	}
+
+	/**
+	 * 统计资格审查异常信息
+	 * @return
+	 */
+	@Override
+	public List<ResponseVo> getSecurityExaminationGroupCountList() {
+		return baseMapper.getSecurityExaminationGroupCountList();
+	}
+
+	/**
+	 * 考试通过率低于50%
+	 * @return
+	 */
+	@Override
+	public List<ResponseVo> getSecurityExamPassingGroupCountList() {
+		return baseMapper.getSecurityExamPassingGroupCountList();
+	}
+
+	/**
+	 *  查询 1 持证率低于50%, 2 社保缴纳率低于50%, 3 派遣率低于50%
+	 * @param type 1 持证率低于50%, 2 社保缴纳率低于50%, 3 派遣率低于50%
+	 * @return
+	 */
+	@Override
+	public List<ResponseVo> getSecurityHoldAndSoidAndDispatchGroupCountList(Integer type) {
+		return baseMapper.getSecurityHoldAndSoidAndDispatchGroupCountList(type);
+	}
+
+	@Override
+	public IPage selectBxc(IPage page,String jurisdiction,String type) {
+		return page.setRecords(baseMapper.selectBxc(page,jurisdiction,type));
+	}
 }

--
Gitblit v1.9.3