
package org.sky.scientific.mapper;

import org.sky.scientific.pojo.dto.TechnicianDTO;
import org.sky.scientific.pojo.entity.TechnicianEntity;
import org.sky.scientific.pojo.vo.TechnicianVO;
import org.sky.scientific.excel.TechnicianExcel;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import java.util.List;

/**
 * 技术人员花名册 Mapper 接口
 *
 * @author Kd
 * @since 2025-06-11
 */
public interface TechnicianMapper extends BaseMapper<TechnicianEntity> {

	/**
	 * 自定义分页
	 *
	 * @param page 分页参数
	 * @param technician 查询参数
	 * @return List<TechnicianVO>
	 */
	List<TechnicianVO> selectTechnicianPage(IPage page, TechnicianDTO technician);

	List<TechnicianExcel> exportTechnicianList(@Param("technician") TechnicianDTO technician);


	Integer countByDateAndNumberOrIdentityCard(TechnicianEntity technician);

	List<TechnicianEntity> selectByYearAndMonth(String yearAndMonth);

}
