package com.mes.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.mes.entity.PlcTestTask;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* PLC测试任务Mapper
|
*
|
* @author huang
|
* @date 2025/11/04
|
*/
|
@Mapper
|
public interface PlcTestTaskMapper extends BaseMapper<PlcTestTask> {
|
|
/**
|
* 查询指定项目的所有任务
|
* @param projectId 项目ID
|
* @return 任务列表
|
*/
|
// @Select("SELECT * FROM `plc_test_task` WHERE `project_id` = #{projectId} ORDER BY `created_at` DESC")
|
// List<PlcTestTask> selectByProjectId(@Param("projectId") String projectId);
|
//
|
/**
|
* 查询指定项目的运行中任务
|
* 包括RUNNING、WAITING_REPORT等进行中状态
|
* @param projectId 项目ID
|
* @return 进行中的任务列表
|
*/
|
@Select("SELECT * FROM `plc_test_task` WHERE `project_id` = #{projectId} AND `status` IN ('RUNNING', 'WAITING_REPORT', 'WAITING_CONFIRM') ORDER BY `created_at` DESC")
|
List<PlcTestTask> selectRunningTasks(@Param("projectId") String projectId);
|
|
}
|
