1. 新增保安员统计查询，业务情况统计查询 2. 新增保安员统计导出，业务情况统计导出

Administrator

2021-12-14 1d51512c49e89a84c4042a9e3fa48fc4bf438056

 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;
   }
}