From a71aa365550b036e3689cb492b45fa1ecf577a4c Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Sat, 04 Dec 2021 16:45:16 +0800
Subject: [PATCH] 统计查询修改

---
 src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml           |    2 +-
 src/main/java/org/springblade/modules/information/controller/InformationsController.java |   33 ---------------------------------
 2 files changed, 1 insertions(+), 34 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 f1e1ae5..2e63a57 100644
--- a/src/main/java/org/springblade/modules/information/controller/InformationsController.java
+++ b/src/main/java/org/springblade/modules/information/controller/InformationsController.java
@@ -247,37 +247,4 @@
 		}
 		return R.data(lists);
 	}
-
-	/**
-	 * 根据辖区及保安公司统计未缴纳社保人员
-	 * @param query  分页条件
-	 * @param information 查询条件
-	 * @return
-	 */
-	@GetMapping("/getNotSocialNumber")
-	public R<IPage<UserVO>> getNotSocialNumber(InformationVO information, Query query){
-		return R.data(informationService.getNotSocialAndInsuranceAndDispatcherNumber(Condition.getPage(query), information,1));
-	}
-
-	/**
-	 * 根据辖区及保安公司统计未缴纳保险人员
-	 * @param query  分页条件
-	 * @param information 查询条件
-	 * @return
-	 */
-	@GetMapping("/getNotInsuranceNumber")
-	public R<IPage<UserVO>> getNotInsuranceNumber(InformationVO information, Query query){
-		return R.data(informationService.getNotSocialAndInsuranceAndDispatcherNumber(Condition.getPage(query), information,2));
-	}
-
-	/**
-	 * 根据辖区及保安公司统计未派遣人员
-	 * @param query  分页条件
-	 * @param information 查询条件
-	 * @return
-	 */
-	@GetMapping("/getNotDispatcherNumber")
-	public R<IPage<UserVO>> getNotDispatcherNumber(InformationVO information, Query query){
-		return R.data(informationService.getNotSocialAndInsuranceAndDispatcherNumber(Condition.getPage(query), information,3));
-	}
 }
diff --git a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml
index 05e9fa5..c378b49 100644
--- a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml
+++ b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml
@@ -3009,7 +3009,7 @@
             and (sj.id = #{information.jurisdiction} or sj.parent_id = #{information.jurisdiction})
         </if>
         ) b
-        where b.znum &lt; 2
+        where b.znum &lt; #{information.proportion}
         <if test="information.departmentid!=null and information.departmentid!=''">
             and b.departmentid = #{information.departmentid}
         </if>

--
Gitblit v1.9.3