/* * Copyright (c) 2018-2025, ztt All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the pig4cloud.com developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: ztt */ package com.chinaztt.mes.aps.mapper; import com.chinaztt.mes.aps.core.domain.OperationBo; import com.chinaztt.mes.aps.vo.GanttTaskVo; import com.chinaztt.mes.aps.vo.ResourceVo; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.time.LocalDate; import java.time.LocalDateTime; import java.util.List; import java.util.Set; /** * @author zhangxy */ @Mapper public interface ApsCoreMapper { /** * 查询工序 * * @param operationId * @return */ OperationBo queryOperation(Long operationId); /** * 区间查询,场景task * * @param sceneId * @param start * @param end * @param resourceIds * @return */ List querySceneTaskByTimeRange(@Param("sceneId") Long sceneId, @Param("start") LocalDate start, @Param("end") LocalDate end, @Param("resourceIds") Set resourceIds); /** * 区间查询,正式工单 * * @param start * @param end * @param resourceIds * @return */ List queryOperationTaskByTimeRange(@Param("start") LocalDate start, @Param("end") LocalDate end, @Param("resourceIds") Set resourceIds); /** * 查询分组下所有资源 * * @param groupId * @return */ List queryResourceByGroupId(Long groupId); /** * 获取所有资源 * * @return */ List getAllResourceVo(); /** * 区间查询,正式工单 * * @param start * @param end * @param workstationIds * @param stateList * @return */ List queryOperationTaskByTimeRangeGantt(@Param("start") LocalDate start, @Param("end") LocalDate end , @Param("workstationIds") Set workstationIds, @Param("stateList") List stateList); /** * 根据工作站数组id去查工作站 * * @param workStationList * @return */ List queryResourceByGroupIdGantt(@Param("workStationList") List workStationList, @Param("workcenter") String workcenter); /** * 查询所有工作站 * * @return */ List getAllResourceVoGantt(); /** * 根据工作站 查询 工单的最大 计划完成时间 * * @param workstationId * @return */ LocalDateTime getOperatioTaskMaxPlanEndTime(Long workstationId); /** * 根据工作中心 和 零件id 查询配置了资源的工作站id * * @param workCenter * @return */ List getWorkstationIdByWorkcenter(@Param("workCenter") String workCenter, @Param("partId") Long partId); }