From 1d51512c49e89a84c4042a9e3fa48fc4bf438056 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 14 Dec 2021 10:01:40 +0800
Subject: [PATCH] 1. 新增保安员统计查询，业务情况统计查询 2. 新增保安员统计导出，业务情况统计导出
---
src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java | 177 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 177 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 83de7b1..ef66d98 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
@@ -32,9 +32,12 @@
import org.springblade.core.tool.utils.Func;
import org.springblade.core.tool.utils.StringUtil;
import org.springblade.modules.information.entity.Information;
+import org.springblade.modules.information.excel.ExportInformationExcel;
+import org.springblade.modules.information.excel.ExportInformationSecurityStatistics;
import org.springblade.modules.information.excel.InforExcel;
import org.springblade.modules.information.mapper.InformationMapper;
import org.springblade.modules.information.service.IInformationService;
+import org.springblade.modules.information.vo.InformationStatisticsVO;
import org.springblade.modules.information.vo.InformationVO;
import org.springblade.modules.system.entity.Dept;
import org.springblade.modules.system.entity.Role;
@@ -213,4 +216,178 @@
public String selJurchilder(String id) {
return baseMapper.selJurchilder(id);
}
+
+ /**
+ * 业务统计情况
+ * @param page
+ * @param information
+ * @return
+ */
+ @Override
+ public IPage selectBusinessStatistics(IPage page, InformationVO information) {
+ List<InformationStatisticsVO> list = baseMapper.selectBusinessStatistics(page, information);
+ if (list.size()>0) {
+ //遍历
+ for (InformationStatisticsVO informationStatisticsVO : list) {
+ List<Dept> deptList = baseMapper.getDeptHashChildrens(informationStatisticsVO);
+ //有子级
+ if (deptList.size()>0){
+ Dept dept = new Dept();
+ dept.setId(Long.parseLong(informationStatisticsVO.getDepartmentid()));
+ //查询当前子单位的人数
+ Integer z = baseMapper.selectInformationUserNumCount(dept) + informationStatisticsVO.getZnum();
+ informationStatisticsVO.setZnum(z);
+ //已派遣人数
+ Integer p = baseMapper.selectInformationDispatcherNumCount(dept) + informationStatisticsVO.getPqnum();
+ informationStatisticsVO.setPqnum(p);
+ //持证人数
+ Integer c = baseMapper.selectInformationHoldNumCount(dept) + informationStatisticsVO.getCznum();
+ informationStatisticsVO.setCznum(c);
+ //服务单位数
+ Integer f = baseMapper.selectInformationUnitNumCount(dept) + informationStatisticsVO.getFwnum();
+ informationStatisticsVO.setFwnum(f);
+ //服务单位到期数
+ Integer d = baseMapper.selectInformationUnitExpireNumCount(dept) + informationStatisticsVO.getDqnum();
+ informationStatisticsVO.setDqnum(d);
+ }
+ }
+ }
+ return page.setRecords(list);
+ }
+
+ /**
+ * 保安员情况统计
+ * @param page
+ * @param information
+ * @return
+ */
+ @Override
+ public IPage selectSecurityStatistics(IPage page, InformationVO information) {
+ List<InformationStatisticsVO> list = baseMapper.selectSecurityStatistics(page,information);
+ if (list.size()>0) {
+ //遍历
+ for (InformationStatisticsVO informationStatisticsVO : list) {
+ List<Dept> deptList = baseMapper.getDeptHashChildrens(informationStatisticsVO);
+ //有子级
+ if (deptList.size()>0){
+ Dept dept = new Dept();
+ dept.setId(Long.parseLong(informationStatisticsVO.getDepartmentid()));
+ //查询当前子单位的人数
+ Integer z = baseMapper.selectInformationUserNumCount(dept) + informationStatisticsVO.getNum();
+ informationStatisticsVO.setNum(z);
+ //持证人数
+ Integer c = baseMapper.selectInformationHoldNumCount(dept) + informationStatisticsVO.getCznum();
+ informationStatisticsVO.setCznum(c);
+ //已派遣人数
+ Integer p = baseMapper.selectInformationDispatcherNumCount(dept) + informationStatisticsVO.getPqnum();
+ informationStatisticsVO.setPqnum(p);
+ //未派遣人数
+ Integer wpq = baseMapper.selectInformationNotDispatcherNumCount(dept) + informationStatisticsVO.getWpqnum();
+ informationStatisticsVO.setWpqnum(wpq);
+ //已采集照片数
+ Integer ycjzp = baseMapper.selectInformationUnitAvatarNumCount(dept) + informationStatisticsVO.getYcjzpnum();
+ informationStatisticsVO.setYcjzpnum(ycjzp);
+ //未采集照片数
+ Integer wcjzp = baseMapper.selectInformationUnitNotAvatarNumCount(dept) + informationStatisticsVO.getWcjzpnum();
+ informationStatisticsVO.setWcjzpnum(wcjzp);
+ //已采集指纹数
+ Integer ycjzw = baseMapper.selectInformationUnitZwNumCount(dept) + informationStatisticsVO.getYcjzwnum();
+ informationStatisticsVO.setYcjzwnum(ycjzw);
+ //审查异常数
+ Integer scyc = baseMapper.selectInformationUnitYcNumCount(dept) + informationStatisticsVO.getScycnum();
+ informationStatisticsVO.setScycnum(scyc);
+ //缴纳社保数
+ Integer jnsb = baseMapper.selectInformationUnitJnsbNumCount(dept) + informationStatisticsVO.getJnsbnum();
+ informationStatisticsVO.setJnsbnum(jnsb);
+ }
+ }
+ }
+ return page.setRecords(list);
+ }
+
+ /**
+ * 业务统计导出
+ * @param information
+ * @return
+ */
+ @Override
+ public List<ExportInformationExcel> exportBusinessStatis(InformationVO information) {
+ List<ExportInformationExcel> list = baseMapper.exportBusinessStatis(information);
+ if (list.size()>0) {
+ //遍历
+ for (ExportInformationExcel informationStatisticsVO : list) {
+ List<Dept> deptList = baseMapper.getDeptChildrens(informationStatisticsVO.getDepartmentid());
+ //有子级
+ if (deptList.size()>0){
+ Dept dept = new Dept();
+ dept.setId(Long.parseLong(informationStatisticsVO.getDepartmentid()));
+ //查询当前子单位的人数
+ Integer z = baseMapper.selectInformationUserNumCount(dept) + informationStatisticsVO.getZnum();
+ informationStatisticsVO.setZnum(z);
+ //已派遣人数
+ Integer p = baseMapper.selectInformationDispatcherNumCount(dept) + informationStatisticsVO.getPqnum();
+ informationStatisticsVO.setPqnum(p);
+ //持证人数
+ Integer c = baseMapper.selectInformationHoldNumCount(dept) + informationStatisticsVO.getCznum();
+ informationStatisticsVO.setCznum(c);
+ //服务单位数
+ Integer f = baseMapper.selectInformationUnitNumCount(dept) + informationStatisticsVO.getFwnum();
+ informationStatisticsVO.setFwnum(f);
+ //服务单位到期数
+ Integer d = baseMapper.selectInformationUnitExpireNumCount(dept) + informationStatisticsVO.getDqnum();
+ informationStatisticsVO.setDqnum(d);
+ }
+ }
+ }
+ return list;
+ }
+
+ /**
+ * 保安员统计导出
+ * @param information
+ * @return
+ */
+ @Override
+ public List<ExportInformationSecurityStatistics> exportSecurityStatisInfo(InformationVO information) {
+ List<ExportInformationSecurityStatistics> list = baseMapper.exportSecurityStatisInfo(information);
+ if (list.size()>0) {
+ //遍历
+ for (ExportInformationSecurityStatistics informationStatisticsVO : list) {
+ List<Dept> deptList = baseMapper.getDeptChildrens(informationStatisticsVO.getDepartmentid());
+ //有子级
+ if (deptList.size()>0){
+ Dept dept = new Dept();
+ dept.setId(Long.parseLong(informationStatisticsVO.getDepartmentid()));
+ //查询当前子单位的人数
+ Integer z = baseMapper.selectInformationUserNumCount(dept) + informationStatisticsVO.getNum();
+ informationStatisticsVO.setNum(z);
+ //持证人数
+ Integer c = baseMapper.selectInformationHoldNumCount(dept) + informationStatisticsVO.getCznum();
+ informationStatisticsVO.setCznum(c);
+ //已派遣人数
+ Integer p = baseMapper.selectInformationDispatcherNumCount(dept) + informationStatisticsVO.getPqnum();
+ informationStatisticsVO.setPqnum(p);
+ //未派遣人数
+ Integer wpq = baseMapper.selectInformationNotDispatcherNumCount(dept) + informationStatisticsVO.getWpqnum();
+ informationStatisticsVO.setWpqnum(wpq);
+ //已采集照片数
+ Integer ycjzp = baseMapper.selectInformationUnitAvatarNumCount(dept) + informationStatisticsVO.getYcjzpnum();
+ informationStatisticsVO.setYcjzpnum(ycjzp);
+ //未采集照片数
+ Integer wcjzp = baseMapper.selectInformationUnitNotAvatarNumCount(dept) + informationStatisticsVO.getWcjzpnum();
+ informationStatisticsVO.setWcjzpnum(wcjzp);
+ //已采集指纹数
+ Integer ycjzw = baseMapper.selectInformationUnitZwNumCount(dept) + informationStatisticsVO.getYcjzwnum();
+ informationStatisticsVO.setYcjzwnum(ycjzw);
+ //审查异常数
+ Integer scyc = baseMapper.selectInformationUnitYcNumCount(dept) + informationStatisticsVO.getScycnum();
+ informationStatisticsVO.setScycnum(scyc);
+ //缴纳社保数
+ Integer jnsb = baseMapper.selectInformationUnitJnsbNumCount(dept) + informationStatisticsVO.getJnsbnum();
+ informationStatisticsVO.setJnsbnum(jnsb);
+ }
+ }
+ }
+ return list;
+ }
}
--
Gitblit v1.9.3