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/controller/InformationsController.java | 152 ++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 144 insertions(+), 8 deletions(-)
diff --git a/src/main/java/org/springblade/modules/information/controller/InformationsController.java b/src/main/java/org/springblade/modules/information/controller/InformationsController.java
index 5e0822a..2e63a57 100644
--- a/src/main/java/org/springblade/modules/information/controller/InformationsController.java
+++ b/src/main/java/org/springblade/modules/information/controller/InformationsController.java
@@ -7,9 +7,16 @@
import org.springblade.core.tool.api.R;
import org.springblade.modules.information.service.IInformationService;
import org.springblade.modules.information.vo.InformationVO;
+import org.springblade.modules.information.vo.ResponseVo;
+import org.springblade.modules.system.vo.UserVO;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
+
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
/**
* 组织机构详情控制层 2
@@ -63,8 +70,8 @@
* @param information 查询条件
* @return
*/
- @GetMapping("/getSecurityUnitHoldLess50Page")
- public R<IPage<InformationVO>> getSecurityUnitHoldLess50Page(InformationVO information, Query query){
+ @GetMapping("/getSecurityUnitHoldLessPage")
+ public R<IPage<InformationVO>> getSecurityUnitHoldLessPage(InformationVO information, Query query){
return R.data(informationService.getSecurityUnitHoldLess50Page(Condition.getPage(query), information));
}
@@ -74,8 +81,8 @@
* @param information 查询条件
* @return
*/
- @GetMapping("/getSecurityUnitDispatcherLess50Page")
- public R<IPage<InformationVO>> getSecurityUnitDispatcherLess50Page(InformationVO information, Query query){
+ @GetMapping("/getSecurityUnitDispatcherLessPage")
+ public R<IPage<InformationVO>> getSecurityUnitDispatcherLessPage(InformationVO information, Query query){
return R.data(informationService.getSecurityUnitDispatcherLess50Page(Condition.getPage(query), information));
}
@@ -85,9 +92,20 @@
* @param information 查询条件
* @return
*/
- @GetMapping("/getSecurityUnitSoilLess50Page")
- public R<IPage<InformationVO>> getSecurityUnitSoilLess50Page(InformationVO information, Query query){
+ @GetMapping("/getSecurityUnitSoilLessPage")
+ public R<IPage<InformationVO>> getSecurityUnitSoilLessPage(InformationVO information, Query query){
return R.data(informationService.getSecurityUnitSoilLess50Page(Condition.getPage(query), information));
+ }
+
+ /**
+ * 根据辖区查询统计保安公司保险缴纳率低于90%的保安公司个数及保安公司分页信息（本市保安公司，分公司）
+ * @param query 分页条件
+ * @param information 查询条件
+ * @return
+ */
+ @GetMapping("/getSecurityUnitInsuranceLessPage")
+ public R<IPage<InformationVO>> getSecurityUnitInsuranceLessPage(InformationVO information, Query query){
+ return R.data(informationService.getSecurityUnitInsuranceLessPage(Condition.getPage(query), information));
}
/**
@@ -96,8 +114,8 @@
* @param information 查询条件
* @return
*/
- @GetMapping("/getSecurityUnitExamLess50Page")
- public R<IPage<InformationVO>> getSecurityUnitExamLess50Page(InformationVO information, Query query){
+ @GetMapping("/getSecurityUnitExamLessPage")
+ public R<IPage<InformationVO>> getSecurityUnitExamLessPage(InformationVO information, Query query){
return R.data(informationService.getSecurityUnitExamLess50Page(Condition.getPage(query), information));
}
@@ -111,4 +129,122 @@
public R<IPage<InformationVO>> getSubstationWarnInfoPage(InformationVO information, Query query){
return R.data(informationService.getSubstationWarnInfoPage(Condition.getPage(query), information));
}
+
+ /**
+ * 根据辖区查询统计当前辖区下的保安公司（本市保安公司，分公司））服务对象小于2家的公司数量的分页信息
+ * @param query 分页条件
+ * @param information 查询条件
+ * @return
+ */
+ @GetMapping("/getSecurityUnitServerLessPage")
+ public R<IPage<InformationVO>> getSecurityUnitServerLessPage(InformationVO information, Query query){
+ return R.data(informationService.getSecurityUnitServerLess2Page(Condition.getPage(query), information));
+ }
+
+ /**
+ * 首页分局预警统计(保安员预警（表现差，审查异常），保安公司预警（考试通过率低于50%，持证率低于50%，社保缴纳率低于50%，派遣率低于50%）)
+ * @return
+ */
+ @GetMapping("/selectSubstationWarnInfo")
+ public R selectSubstationWarnInfo() {
+ //辖区信息
+ List<Map<Object, Object>> list = informationService.selectJur();
+ List<Map<String, Object>> lists = new ArrayList<>();
+
+ //1.保安员表现差预警数量
+ List<ResponseVo> performanceGroupCountList = informationService.getSecurityPerformanceGroupCountList();
+ System.out.println("保安员表现差预警数量 = " + performanceGroupCountList);
+
+ //2.保安员资格异常的数量
+ List<ResponseVo> examinationGroupCountList = informationService.getSecurityExaminationGroupCountList();
+ System.out.println("保安员资格异常的数量 = " + examinationGroupCountList);
+
+ //3.考试通过率低于50%
+ List<ResponseVo> examPassingGroupCountList = informationService.getSecurityExamPassingGroupCountList();
+ System.out.println("考试通过率低于50% = " + examPassingGroupCountList);
+
+ //4.持证率低于50%
+ List<ResponseVo> holdGroupCountList = informationService.getSecurityHoldAndSoidAndDispatchGroupCountList(1);
+ System.out.println("持证率低于50% = " + holdGroupCountList);
+
+ //5.社保缴纳率低于50%
+ List<ResponseVo> soidGroupCountList = informationService.getSecurityHoldAndSoidAndDispatchGroupCountList(2);
+ System.out.println("社保缴纳率低于50% = " + soidGroupCountList);
+
+ //6.派遣率低于50%
+ List<ResponseVo> dispatchGroupCountList = informationService.getSecurityHoldAndSoidAndDispatchGroupCountList(3);
+ System.out.println("派遣率低于50% = " + dispatchGroupCountList);
+
+
+ for (int i = 0; i < list.size(); i++) {
+ int count = 0;
+ Map<String, Object> map = new HashMap<String, Object>();
+ //辖区id
+ String id = list.get(i).get("id").toString();
+ //辖区名称
+ String jurname = list.get(i).get("dept_name").toString();
+
+ //1.保安员表现差预警数量
+ //遍历计算总数
+ for (ResponseVo responseVo : performanceGroupCountList) {
+ //辖区id相同则数量相加
+ if (responseVo.getId().equals(id)){
+ count += responseVo.getNum();
+ }
+ }
+
+
+ //2.保安员资格异常的数量
+ //遍历计算总数
+ for (ResponseVo responseVo : examinationGroupCountList) {
+ //辖区id相同则数量相加
+ if (responseVo.getId().equals(id)){
+ count += responseVo.getNum();
+ }
+ }
+
+ //3.考试通过率低于50%
+ //遍历计算总数
+ for (ResponseVo responseVo : examPassingGroupCountList) {
+ //辖区id相同则数量相加
+ if (responseVo.getId().equals(id)){
+ count += responseVo.getNum();
+ }
+ }
+
+ //4.持证率低于50%
+ //遍历计算总数
+ for (ResponseVo responseVo : holdGroupCountList) {
+ //辖区id相同则数量相加
+ if (responseVo.getId().equals(id)){
+ count += responseVo.getNum();
+ }
+ }
+
+ //5.社保缴纳率低于50%
+ //遍历计算总数
+ for (ResponseVo responseVo : soidGroupCountList) {
+ //辖区id相同则数量相加
+ if (responseVo.getId().equals(id)){
+ count += responseVo.getNum();
+ }
+ }
+
+ //6.派遣率低于50%
+ //遍历计算总数
+ for (ResponseVo responseVo : dispatchGroupCountList) {
+ //辖区id相同则数量相加
+ if (responseVo.getId().equals(id)){
+ count += responseVo.getNum();
+ }
+ }
+
+ //封装数据
+ map.put("Count", count);
+ map.put("jurname", jurname);
+ map.put("id", id);
+ lists.add(map);
+ }
+ return R.data(lists);
+ }
}
--
Gitblit v1.9.3