From 3432fad3ebcecd73d3d50fa8dfb7934cc61cfd06 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Mon, 16 Aug 2021 15:04:16 +0800
Subject: [PATCH] 保安员查询新增审查排序
---
src/main/java/org/springblade/modules/information/mapper/InformationMapper.java | 39 +++++++++++++++++++++++++++++++++++++--
1 files changed, 37 insertions(+), 2 deletions(-)
diff --git a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
index 61e63b7..324434d 100644
--- a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
+++ b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.java
@@ -16,17 +16,19 @@
*/
package org.springblade.modules.information.mapper;
+import org.apache.ibatis.annotations.Param;
import org.springblade.modules.information.entity.Information;
import org.springblade.modules.information.vo.InformationVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
+import java.util.Map;
/**
* Mapper 接口
*
* @author BladeX
- * @since 2021-07-06
+ * @since 2021-07-07
*/
public interface InformationMapper extends BaseMapper<Information> {
@@ -37,6 +39,39 @@
* @param information
* @return
*/
- List<InformationVO> selectInformationPage(IPage page, InformationVO information);
+ List<Information> selectInformationPage(IPage page,Information information);
+ void deleteIn(String creditcode);
+ void deleteSh(String creditcode);
+ void deleteMe(String creditcode);
+ Map selectCount(String departmentid);
+ Map selectPcount(String jurisdiction,String deptid);
+ Map selectWPcount(String jurisdiction,String deptid);
+ List<Map<Object,String>> selectInCount(String jurisdiction,String deptid);
+ List<Map<String, Object>> selectCs(String jurisdiction,String deptid);
+ List<Map<String, Object>> selectTo(String jurisdiction,String deptid);
+ Map<String, String> queryYearSoil(String year,String jurisdiction,String deptid);
+ Map<String, String> queryYearAn(String year,String jurisdiction,String deptid);
+ List<Map<Object,Object>> queryCountB(String jurisdiction,String deptid);
+ List<Map<Object,Object>> selectLi(String jurisdiction,String deptid);
+ List<Map<Object,Object>> queryCountZc(String jurisdiction,String deptid);
+ List<Map<Object,Object>> queryCountCz(String jurisdiction,String deptid);
+ List<Map<Object,Object>> queryCountSb(String jurisdiction,String deptid);
+ List<Map<Object,Object>> queryCountKh(String jurisdiction,String deptid);
+ List<Map<Object,Object>> queryCountPq(String jurisdiction,String deptid);
+ List<Map<Object,Object>> selectJur();
+ int selectExtypeUser();
+ List<Map<Object,Object>> selectExtype(String jurisdiction,String deptid,String type);
+ List<Map<Object,Object>> selectBx(String jurisdiction,String deptid,String type);
+ List<Map<Object,Object>> seCountI(String jurisdiction,String deptid);
+ String seCountUm(String jurisdiction,String deptid);
+ String seCountUg(String jurisdiction,String deptid);
+ List<Map<Object,Object>> selectIn(String jurisdiction);
+ Map<String, String> queryYearZ(String year,String jurisdiction,String deptid);
+ Map<String, String> queryYearZc(String year,String jurisdiction,String deptid);
+ Map<String, String> queryYearCz(String year,String jurisdiction,String deptid);
+ Map<String, String> queryYearKh(String year,String jurisdiction,String deptid);
+ Map<String, String> queryYearBanan(String year,String jurisdiction,String deptid);
+ Map<String, String> queryYearDe(String year,String jurisdiction,String deptid);
+ void deleteDept(String ids);
}
--
Gitblit v1.9.3