package org.springblade.modules.accreditation.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.accreditation.excel.ExportSecurityBookPaperExcel;
import org.springblade.modules.apply.excel.ApplyInfoExcel;
import org.springblade.modules.accreditation.entity.AccreditationRecords;
import org.springblade.modules.accreditation.vo.AccreditationRecordsVo;
import org.springblade.modules.system.vo.UserVO;

import java.util.List;

/**
 * 制证记录Mapper 接口
 * @author zhongrj
 */
public interface AccreditationRecordsMapper extends BaseMapper<AccreditationRecords> {



	/**
	 * 自定义分页
	 *
	 * @param page   分页
	 * @param recruitment 实体
	 * @return
	 */
	List<AccreditationRecordsVo> selectAccreditationRecordsPage(IPage<AccreditationRecordsVo> page, @Param("accreditationRecords") AccreditationRecordsVo recruitment);

	/**
	 * 自定义详情信息
	 * @param accreditationRecords
	 * @return
	 */
    AccreditationRecordsVo getAccreditationRecordsDetails(@Param("accreditationRecords") AccreditationRecords accreditationRecords);

	/**
	 * 导出保安员证信息
	 * @param accreditationRecords
	 * @return
	 */
	List<AccreditationRecordsVo> exportSecurityPaperList(@Param("accreditationRecords") AccreditationRecordsVo accreditationRecords);

	/**
	 * 导出证书制证信息
	 * @param accreditationRecords
	 * @return
	 */
    List<ExportSecurityBookPaperExcel> exportSecurityBookPaper(@Param("accreditationRecords") AccreditationRecordsVo accreditationRecords);

	/**
	 * 导出证书制证信息(包含照片)
	 */
	List<AccreditationRecordsVo> exportSecurityBookPapers(@Param("accreditationRecords") AccreditationRecordsVo accreditationRecords);

	/**
	 * 根据用户 id 查询上岗证申请记录
	 * @param id 用户id
	 * @return
	 */
	int getAccreditationRecordsByUserIdCount(@Param("userId") String id);

	/**
	 * 根据用户 id 查询当前人员是否有待审核和审核通过的记录数
	 * @param id 用户id
	 * @return
	 */
	int getAccreditationRecordsByUserIdAuditCount(@Param("userId") String id,@Param("type") Integer type);
}