/*
 *      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);

    /**
	 * 查询学历统计信息
	 * @param deptid 部门id
	 * @param jurisdiction 辖区
	 * @return
	 */
	List<Map<String, Object>> getEducationStatistics(@Param("deptId") String deptid, @Param("jurisdiction") String jurisdiction);

	/**
	 * 查询公司所有的父级
	 * @param information
	 * @return
	 */
    List<String> getDeptDetails(@Param("information") InformationVO information);

	/**
	 * 根据部门id 查询公司信息
	 * @param s
	 * @return
	 */
	InformationVO getInformationDetails(@Param("deptId") String deptId);
}