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/IInformationService.java |   82 +++++++++++++++++++++++++++++++++++++++--
 1 files changed, 78 insertions(+), 4 deletions(-)

diff --git a/src/main/java/org/springblade/modules/information/service/IInformationService.java b/src/main/java/org/springblade/modules/information/service/IInformationService.java
index 56094a9..773ae4f 100644
--- a/src/main/java/org/springblade/modules/information/service/IInformationService.java
+++ b/src/main/java/org/springblade/modules/information/service/IInformationService.java
@@ -16,16 +16,24 @@
  */
 package org.springblade.modules.information.service;
 
-import org.springblade.modules.information.entity.Information;
-import org.springblade.modules.information.vo.InformationVO;
-import com.baomidou.mybatisplus.extension.service.IService;
 import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.service.IService;
+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.vo.InformationVO;
+import org.springblade.modules.system.entity.User;
+import org.springblade.modules.system.excel.UserExcel;
+
+import java.util.List;
+import java.util.Map;
 
 /**
  *  服务类
  *
  * @author BladeX
- * @since 2021-07-06
+ * @since 2021-07-07
  */
 public interface IInformationService extends IService<Information> {
 
@@ -37,5 +45,71 @@
 	 * @return
 	 */
 	IPage<InformationVO> selectInformationPage(IPage<InformationVO> page, InformationVO information);
+	void deleteIn(String departmentid);
+	void deleteSh(String deptId);
+	void insertIn(Information information);
+	void deleteMe(String deptId);
+	Map selectCount(String departmentid);
+	List<Map<Object,String>> selectInCount();
+	void deleteDept(String departmentid);
+	List<Map<Object,Object>> selectExtype(String deptid,String jurisdiction);
+	List<Map<Object,Object>> selectHold(String deptid,String jurisdiction);
+	List<Map<Object,Object>> selectDis(String deptid);
+	List<Map<Object,Object>> selectDisp(String deptid,String jurisdiction);
+	List<Map<Object,Object>> selectSoil(String deptid,String jurisdiction);
+	List queryYearKh(String year,String jurisdiction,String deptid);
 
+	/**
+	 * 查询培训单位信息(可以报名)
+	 * @param page
+	 * @param information 保安单位信息对象
+	 * @return
+	 */
+	IPage<InformationVO> securityPage(IPage<InformationVO> page, InformationVO information);
+
+	/**
+	 * 导入单位数据
+	 *
+	 * @param data
+	 * @param isCovered
+	 * @return
+	 */
+	void importInfor(List<InforExcel> data, Boolean isCovered);
+
+	/**
+	 * 根据deptid 删除用户信息
+	 * @param deptId
+	 */
+    void deleteUserByDeptId(String deptId);
+	String selJurchilder(String id);
+
+	/**
+	 * 业务统计情况
+	 * @param page
+	 * @param information
+	 * @return
+	 */
+    IPage selectBusinessStatistics(IPage<List> page, InformationVO information);
+
+	/**
+	 * 保安员情况统计
+	 * @param page
+	 * @param information
+	 * @return
+	 */
+	IPage selectSecurityStatistics(IPage<List> page, InformationVO information);
+
+	/**
+	 * 业务统计导出
+	 * @param information
+	 * @return
+	 */
+	List<ExportInformationExcel> exportBusinessStatis(InformationVO information);
+
+	/**
+	 * 保安员统计导出
+	 * @param information
+	 * @return
+	 */
+	List<ExportInformationSecurityStatistics> exportSecurityStatisInfo(InformationVO information);
 }

--
Gitblit v1.9.3