| | |
| | | package com.estate.expert.admin.domain.exam.task.check; |
| | | |
| | | import com.estate.expert.admin.domain.common.EntityBaseRepository; |
| | | import com.estate.expert.admin.domain.plan.PlanState; |
| | | import org.springframework.data.jpa.repository.Query; |
| | | import org.springframework.data.repository.query.Param; |
| | | |
| | | import java.util.List; |
| | | |
| | |
| | | List<CheckTask> findAllByPlanIdAndDeleted(Integer planId, boolean deleted); |
| | | |
| | | CheckTask getFirstByPlanIdAndProjectIdAndDeleted(Integer planId, Integer projectId, boolean deleted); |
| | | |
| | | @Query("select t.id from CheckTask t " + |
| | | "where t.deleted = false " + |
| | | "and t.project.id = :projectId " + |
| | | "and t.plan.deleted = false " + |
| | | "and t.plan.state = :planState") |
| | | List<Integer> listTaskIdsByProjectAndPlanState(@Param("projectId") Integer projectId, |
| | | @Param("planState") PlanState planState); |
| | | } |