/*
|
* Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
|
*
|
* Redistribution and use in source and binary forms, with or without
|
* modification, are permitted provided that the following conditions are met:
|
*
|
* Redistributions of source code must retain the above copyright notice,
|
* this list of conditions and the following disclaimer.
|
* Redistributions in binary form must reproduce the above copyright
|
* notice, this list of conditions and the following disclaimer in the
|
* documentation and/or other materials provided with the distribution.
|
* Neither the name of the dreamlu.net developer nor the names of its
|
* contributors may be used to endorse or promote products derived from
|
* this software without specific prior written permission.
|
* Author: Chill 庄骞 (smallchill@163.com)
|
*/
|
package org.springblade.modules.information.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import org.apache.ibatis.annotations.Param;
|
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.vo.InformationStatisticsVO;
|
import org.springblade.modules.information.vo.InformationVO;
|
import org.springblade.modules.system.entity.Dept;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* Mapper 接口
|
*
|
* @author BladeX
|
* @since 2021-07-07
|
*/
|
public interface InformationMapper extends BaseMapper<Information> {
|
|
/**
|
* 自定义分页
|
*
|
* @param page
|
* @param information
|
* @return
|
*/
|
List<InformationVO> selectInformationPage(IPage<InformationVO> page, @Param("information")InformationVO information);
|
void insertIn(@Param("information")Information information);
|
void deleteIn(@Param("departmentid")String departmentid);
|
void deleteSh(@Param("deptId")String deptId);
|
void deleteMe(@Param("deptId")String deptId);
|
Map selectCount(String departmentid);
|
List<Map<Object,String>> selectInCount();
|
void deleteDept(@Param("id") String id);
|
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);
|
|
/**
|
* 查询培训单位信息(可以报名)
|
* @param page
|
* @param information 保安单位信息对象
|
* @return
|
*/
|
List<InformationVO> securityPage(IPage<InformationVO> page, @Param("information") InformationVO information);
|
List queryYearKh(@Param("year") String year,@Param("jurisdiction")String jurisdiction,@Param("deptid")String deptid);
|
|
/**
|
* 根据deptid 删除用户信息
|
* @param deptId
|
*/
|
void deleteUserByDeptId(@Param("deptId") String deptId);
|
String selJurchilder(String id);
|
|
/**
|
* 查询当前单位是否有子级单位
|
* @param informationVO
|
* @return
|
*/
|
List<Dept> getDeptHashChildren(@Param("information") InformationVO informationVO);
|
|
/**
|
* 查询单位的人数
|
* @param dept
|
* @return
|
*/
|
int selectInformationUserNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 查询单位的已派遣人数
|
* @param dept
|
* @return
|
*/
|
int selectInformationDispatcherNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 查询单位持证的人数
|
* @param dept
|
* @return
|
*/
|
int selectInformationHoldNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 业务统计情况
|
* @param page
|
* @param information
|
* @return
|
*/
|
List<InformationStatisticsVO> selectBusinessStatistics(@Param("page")IPage page,@Param("information") InformationVO information);
|
|
/**
|
* 查询当前单位是否有子级单位
|
* @param informationStatisticsVO
|
* @return
|
*/
|
List<Dept> getDeptHashChildrens(@Param("information") InformationStatisticsVO informationStatisticsVO);
|
|
/**
|
* 服务单位数
|
* @param dept
|
* @return
|
*/
|
Integer selectInformationUnitNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 服务单位到期数
|
* @param dept
|
* @return
|
*/
|
Integer selectInformationUnitExpireNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 查询单位的未派遣人数
|
* @param dept
|
* @return
|
*/
|
Integer selectInformationNotDispatcherNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 查询单位的已采集照片人数
|
* @param dept
|
* @return
|
*/
|
Integer selectInformationUnitAvatarNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 查询单位的未采集照片人数
|
* @param dept
|
* @return
|
*/
|
Integer selectInformationUnitNotAvatarNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 已采集指纹
|
* @param dept
|
* @return
|
*/
|
Integer selectInformationUnitZwNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 审查异常
|
* @param dept
|
* @return
|
*/
|
Integer selectInformationUnitYcNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 缴纳社保
|
* @param dept
|
* @return
|
*/
|
Integer selectInformationUnitJnsbNumCount(@Param("dept")Dept dept);
|
|
/**
|
* 保安员情况统计
|
* @param page
|
* @param information
|
* @return
|
*/
|
List<InformationStatisticsVO> selectSecurityStatistics(@Param("page") IPage page, @Param("information") InformationVO information);
|
|
/**
|
* 查询部门信息
|
* @param departmentid
|
* @return
|
*/
|
List<Dept> getDeptChildrens(String departmentid);
|
|
/**
|
* 保安员统计导出
|
* @param information
|
* @return
|
*/
|
List<ExportInformationSecurityStatistics> exportSecurityStatisInfo(@Param("information") InformationVO information);
|
|
/**
|
* 业务情况统计导出
|
* @param information
|
* @return
|
*/
|
List<ExportInformationExcel> exportBusinessStatis(@Param("information") InformationVO information);
|
|
/**
|
* 保安员详情
|
* @param page
|
* @param deptid
|
* @param name
|
* @param hold
|
* @param photo
|
* @param examinationtype
|
* @param dispatch
|
* @param soil
|
* @return
|
*/
|
List<List> selectUIn(IPage<List> page, String deptid, String name, String hold, String photo, String examinationtype, String dispatch, String soil);
|
}
|
