package com.qianwen.smartman.modules.mdc.service; import java.time.LocalDate; import java.time.LocalDateTime; import java.util.List; import com.qianwen.smartman.modules.mdc.entity.SuperAggregateState; import com.qianwen.smartman.modules.mdc.enums.StatisticalMethodEnum; import com.qianwen.smartman.modules.mdc.vo.StatusTimeTopVO; public interface ISuperAggregateStateService { /** * 根据日期获取工位状态数据 * @param workstationIds * @param statisticalMethod * @param startDate * @param endDate * @return */ List getStatusData(List workstationIds, StatisticalMethodEnum statisticalMethod, LocalDate startDate, LocalDate endDate); /** * 稼动率数据查询 * @param workstationIds * @param statisticalMethod * @param startDate * @param endDate * @return */ List getStatusDataWithFeedback(List workstationIds, StatisticalMethodEnum statisticalMethod, LocalDate startDate, LocalDate endDate); List getStatusByCondition(List workstationIds, LocalDateTime startTime, LocalDateTime endTime); /** * 统计首页稼动率排名时使用的查询 * @param workstationIds * @param startTime * @param endTime * @return */ List getStatusByTimeSection(List workstationIds, LocalDateTime startTime, LocalDateTime endTime); /** * 根据状态,起止时间获取聚合状态数据列表 * @param workstationIds * @param startTime 开始时间 * @param endTime 结束时间 * @param status 状态值,查询wcs=status的数据 * @param top top多少(统计后取出最高的top个数据) * @return 数据列表 */ List getStatusTimeByWcs(List workstationIds, LocalDateTime startTime, LocalDateTime endTime, Integer status, Integer top); List getOeeAnalysis(List workStationIdList, LocalDateTime startTime, LocalDateTime endTime); List getShiftStatusData(List workstationIdList, String factoryDate, Integer shiftIndex); List getStatusByFactory(List workstationIdList, String factoryDate, Integer shiftIndex); List listsState(List ids, LocalDate queryTime, List shiftIndex); List getDataByWeek(List ids, Integer year, List weekList); List getDataByMonth(List ids, Integer year, List monthList); List crossDay(LocalDateTime start, LocalDateTime end); //void saveState(List collect); List getStatusDataByTime(List workstationIdList, LocalDateTime startTime, LocalDateTime endTime); List queryPerfByDay(Long workstationId, String startTime, String endTime, Long employeeId); List queryPerfByWeek(Long workstationId, List weeks, Long employeeId); List queryPerfByMonth(Long workstationId, List months, Long employeeId); List queryPerfByEtDay(Long employeeId, String queryTime); List queryPerfByEtWeek(Long employeeId, Integer week); List queryPerfByEtMonth(Long employeeId, Integer month); List queryPerfByWtDay(Long workstationId, String time); List queryPerfByWtWeek(Long workstationId, Integer week); List queryPerfByWtMonth(Long workstationId, Integer month); List getCurrMonthState(List ids, Integer month); List getCurrMonthAlarmState(List workIds, Integer month, Integer code); List getCurrWeekAlarmState(List workIds, Integer week, Integer code); }