李林
2023-10-07 658d4927d468c47208fd012d9128b09249c07eff
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
package com.chinaztt.mes.production.mapper;
 
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.chinaztt.mes.production.dto.ShiftWageDTO;
import com.chinaztt.mes.production.entity.ShiftWage;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
 
import java.util.List;
 
/**
 * @Description : 班次工资
 * @interfaceName : ShiftWageMapper
 * @Author : sll
 * @Date: 2022-12-03  19:23
 */
@Mapper
public interface ShiftWageMapper extends BaseMapper<ShiftWage>{
    /**
     * 根据班次id查询班次工资
     * @param dutyRecordId
     * @return
     */
    List<ShiftWageDTO> qryShiftWageByDutyRecordId(@Param("dutyRecordId") Long dutyRecordId);
 
    /**
     * 根据班次idList查询班次工资
     * @param dutyRecordIdList
     * @return
     */
    List<ShiftWageDTO> qryShiftWageByDutyRecordIdList(@Param("dutyRecordIdList") List<Long> dutyRecordIdList);
 
    /**
     * 根据班次id查询并计算杂工工资汇总
     * @param dutyRecordId
     * @return
     */
    List<ShiftWageDTO.HandymanWageBean> qryHandymanWageByDutyRecordId(@Param("dutyRecordId") Long dutyRecordId);
 
    /**
     * 根据班次id删除班次工资
     * @param dutyRecordId
     */
    void delShiftWageByDutyRecordId(@Param("dutyRecordId") Long dutyRecordId);
 
    /**
     * 根据班次id更新“是否审核”字段值
     * @param dutyRecordId
     * @param value
     */
    void updShiftWageIsAuditValue(@Param("dutyRecordId") Long dutyRecordId,@Param("value") Boolean value);
 
    /**
     * 根据班次idList删除班次工资
     * @param dutyRecordIdList
     */
    void delShiftWageByDutyRecordIdList(@Param("dutyRecordIdList") List<Long> dutyRecordIdList);
 
    /**
     * 根据班次idList更新“是否审核”字段值
     * @param dutyRecordIdList
     * @param value
     */
    void updShiftWageIsAuditValueByList(@Param("dutyRecordIdList") List<Long> dutyRecordIdList,@Param("value") Boolean value);
}