package com.northglass.repository;
|
|
import java.util.List;
|
|
import org.springframework.data.domain.Page;
|
import org.springframework.data.domain.Pageable;
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Query;
|
|
import com.northglass.constants.StateConstants.ShelfRankState;
|
import com.northglass.entity.ShelfRack;
|
import com.northglass.entity.ShelfRack2;
|
|
public interface ShelfRackDao2 extends JpaRepository<ShelfRack2, Long>{
|
|
/*@Query("select t from RawPackage t where t.fileName = '052-123' and t.fileUrl = '1' and t.state = '已下发' and t.operator = '1' and t.createTime = '2021-09-22 13:22:18' and t.receiveTime = '2021-09-22 13:22:21' ")
|
public List<RawPackage> findMachineDispose();*/
|
|
@Query("select r from ShelfRack2 r where r.id =?1")
|
public ShelfRack2 findRankByRawId(Long id);
|
|
|
|
@Query("select r from ShelfRack2 r where r.state ='空闲' or r.state ='空架'")
|
public List<ShelfRack2> findFreeRanks();
|
|
@Query("select r from ShelfRack2 r where r.state ='使用中'")
|
public List<ShelfRack2> findFreeRanks1();
|
|
@Query("select r from ShelfRack2 r where r.state <>'正在使用' ")
|
public List<ShelfRack2> findBystate();
|
|
@Query("select r from ShelfRack2 r where r.falg ='启用' ")
|
public List<ShelfRack2> findrackfalg();
|
|
@Query("select r from ShelfRack2 r where r.state = '使用中' or r.state = '空闲' or r.state = '禁用' or r.state = '等待使用'")
|
public Page<ShelfRack2> findNotUsedRanks(Pageable pageable);
|
|
@Query("select count(r) from ShelfRack2 r where r.state = '使用中' or r.state = '空闲' or r.state = '禁用'")
|
public int countNotUseRanks();
|
|
@Query("select r from ShelfRack2 r where r.id=?1")
|
public ShelfRack2 selectrackid(Long id);
|
|
@Query("select r from ShelfRack2 r where r.number = ?1")
|
public ShelfRack findShelfRankByNumber(String number);
|
|
|
|
|
|
}
|
