package com.chinaztt.mes.production.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.chinaztt.mes.production.dto.PersonBoardDTO;
import com.chinaztt.mes.production.entity.PersonBoard;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 人员上机
 *
 * @author cxf
 * @date 2020-11-04 15:36:55
 */
@Mapper
public interface PersonBoardMapper extends BaseMapper<PersonBoard> {

    /**
     * 查询上机人员
     *
     * @param id
     * @param workstationId
     * @param staffId
     * @return
     */
    List<PersonBoardDTO> selectDtoByParam(@Param("id") Long id, @Param("workstationId") Long workstationId, @Param("staffId") Long staffId);

    /**
     * 根据id查询
     *
     * @param id
     * @return
     */
    PersonBoardDTO selectDtoById(Long id);

    /**
     * 根据上班记录id查询
     *
     * @param dutyRecordId
     * @return
     */
    List<PersonBoardDTO> getPersonByDutyRecordId(Long dutyRecordId);

	/**
	 * 根据上班记录idList查询
	 *
	 * @param dutyRecordIdList
	 * @return
	 */
	List<PersonBoardDTO> getPersonByDutyRecordIdList(@Param("dutyRecordIdList") List<Long> dutyRecordIdList);

    /**
     * 根据id查询
     *
     * @param id
     * @return
     */
    PersonBoardDTO getPersonDtoById(Long id);

    /**
     * 根据人员编号/班次id查出对应的上班人员id
     *
     * @param dutyRecordId
     * @param staffId
     * @return
     */
    PersonBoard selectByDutyRecordIdAndStaffId(@Param("dutyRecordId") Long dutyRecordId, @Param("staffId") Long staffId);

    /**
     * 根据id备份
     *
     * @param id
     * @param type
     * @return
     */
    int backPersonBoardById(@Param("id") Long id, @Param("type") String type);

    /**
     * 根据id备份删除
     *
     * @param id
     * @param operator
     * @return
     */
    int backDeletePersonBoardByIds(@Param("id") Long id, @Param("operator") String operator);

    /**
     * 检查人员当天是否在其他班次机台上机
     *
     * @param personBoard
     * @return
     */
    List<PersonBoardDTO> checkPersonHaveToWork(@Param("personBoard") PersonBoard personBoard);
}