WorkingMapper.java
3.21 KB
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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
package org.jeecg.modules.working.mapper;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.screen.domain.ProdcutionLowBean;
import org.jeecg.modules.working.entity.*;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import java.util.List;
import java.util.Map;
/**
* @Description: 工时统计
* @Author: jeecg-boot
* @Date: 2021-03-10
* @Version: V1.0
*/
public interface WorkingMapper extends BaseMapper<Working> {
/**
* 根据日期查询人员工时
* @param startTime 开始日期
* @param endTime 结束日期
* @return 人员总工时
*/
List<ChartData> selectByWorkTime(@Param(value = "startTime")String startTime, @Param(value = "endTime")String endTime);
List<ChartData> selectByWorkTimeByName (@Param(value = "startTime")String startTime, @Param(value = "endTime")String endTime,@Param(value = "realname")String realname);
/**
* 根据工作令查询人员工时
* @param startTime 开始日期
* @param endTime 结束日期
* @return 工作令总工时
*/
List<WorkOrderChartData> selectByWorkOrderTime(@Param(value = "startTime")String startTime, @Param(value = "endTime")String endTime);
/**
* 根据部门查询人员工时
* @param startTime 开始日期
* @param endTime 结束日期
* @return 部门总工时
*/
List<DepartmentChartData> selectByDepartmentTime(@Param(value = "startTime")String startTime, @Param(value = "endTime")String endTime);
/**
* 获取每个班组工时
* @param startTime 开始时间
* @param endTime 结束时间
* @return
*/
List<TeamAndWorking> selectTeamAndWorking(@Param(value = "startTime")String startTime, @Param(value = "endTime")String endTime);
/**
* 获取车间大屏生产制造模块-质量信息展示数据
* @return list
*/
List<ProdcutionLowBean>getScreenProduceLowCenterData();
/**
* 获取车间大屏生产制造模块-人员报工信息展示数据
* @return list
*/
List<ProdcutionLowBean>getScreenProduceLowRightData();
/**
* 获取按部件统计工时信息
* @return list
*/
List<partWorking>getPartWorking(@Param(value = "workNo")String workNo);
/**
* 获工作令统计总工时信息
* @return list
*/
List<partWorking>getSumPartWorking(@Param(value = "workNo")String workNo);
/**获取bom结构统计表
* @return list
*/
List<partWorking>getBomPartWorking(@Param(value = "headerId")String headerId,@Param(value = "partNo")String partNo,@Param(value = "pno")String cno,@Param(value = "cno")String parCno);
/**获取部件工时统计
* @return String
*/
String getCountWorkByNo(@Param(value = "workNo")String workNo,@Param(value = "no")String no);
/**获取部件工时比较list
* @return list
*/
List<WorkingData>getCompanyWorkList(@Param(value = "id")String id,@Param(value = "drawingNo")String drawingNo);
/**
* 根据生产计划头id获取报工数据
* @return list
*/
List<Working>getSchedulerWorking(@Param(value = "id")String id);
String getProcessByDrawno(@Param(value = "id")String id,@Param(value = "drawno")String drawno);
}