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);
|
}
|