越南二期初次提交

严智鑫

2025-11-13 945bc394f40d8af1072a53da9a94f24207124e6d

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
package com.northglass.repository;
 
import java.util.List;
 
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
 
import com.northglass.constants.StateConstants.CutMachineTaskState;
import com.northglass.entity.CutMachineTask;
 
public interface CutMachineTaskDao extends JpaRepository<CutMachineTask, Long> {
 
       
    
    @Query("select t from CutMachineTask t where t.state='" + CutMachineTaskState.TO_ASSIGN + "'")
    public List<CutMachineTask> findToAssignTasks();
    
    @Query("select t from CutMachineTask t where t.cutMachine.id= ?1 ")
    public List<CutMachineTask> findById(Long cutMachineId);
    
    //-----------------------------------------------------------------------------------------------------------------------//
    
    @Query("select t from CutMachineTask t where t.state='" + CutMachineTaskState.IN_WORK + "'")
    public List<CutMachineTask> findInWorkTasks();
    
    @Query("select t from CutMachineTask t where t.state='" + CutMachineTaskState.IN_WORK + "' and t.cutMachine.id = ?1")
    public CutMachineTask findInWorkTaskByCutMachineId(Long cutMachineId);
    
    //-----------------------------------------------------------------------------------------------------------------------//
    
    @Query("select t from CutMachineTask t where t.state='" + CutMachineTaskState.WAITING + "'")
    public List<CutMachineTask> findWaitingTasks();
    
    @Query("select t from CutMachineTask t where t.state='" + CutMachineTaskState.WAITING + "' and t.cutMachine.id = ?1")
    public List<CutMachineTask> findWaitingTasksByCutMachineId(Long cutMachineId);
    
    //-----------------------------------------------------------------------------------------------------------------------//
    
    @Query("select t from CutMachineTask t where t.state='" + CutMachineTaskState.COMPLETED + "'")
    public List<CutMachineTask> findCompletedTasks();
    
    @Query("select t from CutMachineTask t where t.state='" + CutMachineTaskState.COMPLETED + "' and t.cutMachine.id = ?1")
    public List<CutMachineTask> findCompletedTasksByCutMachineId(Long cutMachineId);
    
    //-----------------------------------------------------------------------------------------------------------------------//
    
    @Query("select t from CutMachineTask t where t.state='" + CutMachineTaskState.WARNING + "'")
    public List<CutMachineTask> findWarningTasks();
    
    @Query("select t from CutMachineTask t where t.state='" + CutMachineTaskState.WARNING + "' and t.cutMachine.id = ?1")
    public List<CutMachineTask> findWarningTasksByCutMachineId(Long cutMachineId);
    
    //-----------------------------------------------------------------------------------------------------------------------//
    
    @Query("select t from CutMachineTask t where (t.state='" + CutMachineTaskState.IN_WORK 
            + "' or t.state='" + CutMachineTaskState.WARNING 
            + "' or t.state='" + CutMachineTaskState.WAITING 
            + "') and t.cutMachine.id = ?1")
    public List<CutMachineTask> findExecuteTasksByCutMachineId(Long cutMachineId);
    
}