package com.chinaztt.mes.production.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.chinaztt.mes.production.dto.ArtificialInformationDTO;
|
import com.chinaztt.mes.production.entity.ArtificialInformation;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
|
/**
|
* 杂工明细
|
*
|
* @author cxf
|
* @date 2021-01-21 13:22:22
|
*/
|
@Mapper
|
public interface ArtificialInformationMapper extends BaseMapper<ArtificialInformation> {
|
|
/**
|
* 根据上班记录查询杂工记录
|
*
|
* @param dutyRecordIdList
|
* @return
|
*/
|
List<ArtificialInformationDTO> getArtificialInformationByDutyRecordId(@Param("dutyRecordIdList")List<Long> dutyRecordIdList);
|
|
/**
|
* 查询工时计算杂工记录
|
*
|
* @param artificialInformation
|
* @return
|
*/
|
List<ArtificialInformationDTO> getComputationArtificialInformation(@Param("param") ArtificialInformation artificialInformation);
|
|
/**
|
* 查询工时计算杂工记录
|
*
|
* @param dutyRecordIdList
|
* @param handymanTypeId
|
* @return
|
*/
|
List<ArtificialInformationDTO> getComputationArtificialInformationByList(@Param("dutyRecordIdList")List<Long> dutyRecordIdList,@Param("handymanTypeId")Long handymanTypeId);
|
|
/**
|
* 根据id备份人工
|
*
|
* @param id
|
* @param type
|
* @return
|
*/
|
int backArtificialInformationById(@Param("id") Long id, @Param("type") String type);
|
|
/**
|
* 根据id记录删除人工
|
*
|
* @param id
|
* @param operator
|
* @return
|
*/
|
int backDeleteArtificialInformationByIds(@Param("id") Long id, @Param("operator") String operator);
|
|
/**
|
* 查询该人当前班次的人工总工时
|
*
|
* @param originalArtificialInformation
|
* @return
|
*/
|
BigDecimal selectTotalWorkTime(@Param("param") ArtificialInformation originalArtificialInformation);
|
|
/**
|
* 查询
|
*
|
* @param id
|
* @return
|
*/
|
ArtificialInformationDTO selectDtoById(Long id);
|
|
/**
|
* 查询该人当天的人工总工时
|
*
|
* @param originalArtificialInformation
|
* @return
|
*/
|
BigDecimal selectTotalDayWorkTime(@Param("param") ArtificialInformationDTO originalArtificialInformation);
|
|
int batchInsert(@Param("list") List<ArtificialInformation> list);
|
}
|
