越南二期初次提交

严智鑫

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
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.ArrangeMachineRankState;
import com.northglass.entity.ArrangeMachineRank;
 
 
public interface ArrangeMachineRankDao extends JpaRepository<ArrangeMachineRank, Long> {
 
    @Query("select r from ArrangeMachineRank r where r.state = '" + ArrangeMachineRankState.FREE + "'")
    public List<ArrangeMachineRank> findFreeRanks();
    
    @Query("select r from ArrangeMachineRank r where r.state = '" + ArrangeMachineRankState.IN_WORK + "'")
    public List<ArrangeMachineRank> findInWorkRanks();
    
    @Query("select r from ArrangeMachineRank r where r.state = '" + ArrangeMachineRankState.IN_WORK + "' or "
            + "r.state = '" + ArrangeMachineRankState.ON_WAITING + "'")
    public List<ArrangeMachineRank> findInWorkRank();
    
    @Query("select r from ArrangeMachineRank r where r.state = '" + ArrangeMachineRankState.IN_WORK + "' or "
            + "r.state = '" + ArrangeMachineRankState.WORK_WAITING + "'")
    public List<ArrangeMachineRank> findWorkingRanks();
    
    @Query("select r from ArrangeMachineRank r where r.state = '" + ArrangeMachineRankState.WORK_WAITING + "'")
    public List<ArrangeMachineRank> findWorkWaitingRanks();
    
//    @Query("select r from ArrangeMachineRank r where r.tougheningGlass.glass.id=1?")
//    public ArrangeMachineRank findGlassRanks(Long glassid);
    @Query("select r from ArrangeMachineRank r where r.tougheningGlass.id=?1")
    public ArrangeMachineRank findRanksbytouid(long id);
    
    @Query("select r from ArrangeMachineRank r where r.tougheningGlass.glass.id=?1")
    public List<ArrangeMachineRank> findRanksbyglassid(long id);
    
 //   select *from gmms_arrange_machine_rank where id>0 and id<41 and state = '空闲'
    @Query("select r from ArrangeMachineRank r where id>?1 and id<?2 and state = ?3")
    public List<ArrangeMachineRank> findRanksbyStatu(Long s1,Long s2,String s3);
}