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.ShelfRank;
|
|
|
public interface ShelfRankDao extends JpaRepository<ShelfRank, Long> {
|
|
@Query(nativeQuery=true,value="select * from gmms_shelf_rank where id>=51 and id<=56")
|
public List<ShelfRank> shelfranktopeight();
|
|
|
@Query(nativeQuery=true,value="select * from gmms_shelf_rank where raw_package_id=?1")
|
public ShelfRank findshelfbyRawpackageId(Long rawid);
|
|
@Query(nativeQuery=true,value="SELECT * FROM gmms_shelf_rank where id>=1 and id<=10")
|
public List<ShelfRank> shelfranktopten();
|
|
@Query(nativeQuery=true,value="SELECT * FROM gmms_shelf_rank where id>=11 and id<=26")
|
public List<ShelfRank> shelfranktopsixteen();
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.FREE + "'")
|
public List<ShelfRank> findFreeRanks();
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' or r.state = '" +
|
ShelfRankState.FREE +"' or r.state = '" + ShelfRankState.NOT_WORK + "'or r.state = '" + ShelfRankState.ON_WAITING + "'")
|
public Page<ShelfRank> findNotUsedRanks(Pageable pageable);
|
|
@Query("select count(r) from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' or r.state = '" +
|
ShelfRankState.FREE +"' or r.state = '" + ShelfRankState.NOT_WORK + "'")
|
public int countNotUseRanks();
|
|
@Query("select r from ShelfRank r where (r.state = '" + ShelfRankState.IN_WORK + "' or r.state = '" +
|
ShelfRankState.FREE +"' or r.state = '" + ShelfRankState.NOT_WORK + "'or r.state = '" + ShelfRankState.ON_WAITING + "') and r.thickness = ?1")
|
public Page<ShelfRank> findNotUsedRanks1(Double thickness,Pageable pageable);
|
|
@Query("select count(r) from ShelfRank r where (r.state = '" + ShelfRankState.IN_WORK + "' or r.state = '" +
|
ShelfRankState.FREE +"' or r.state = '" + ShelfRankState.NOT_WORK + "') and r.thickness=?1")
|
public int countNotUseRanks1(Double thickness);
|
|
@Query("select r from ShelfRank r where (r.state = '" + ShelfRankState.IN_WORK + "' or r.state = '" +
|
ShelfRankState.FREE +"' or r.state = '" + ShelfRankState.NOT_WORK + "' or r.state = '" + ShelfRankState.ON_WAITING + "') and r.glassId = ?1")
|
public Page<ShelfRank> findNotUsedRanks2(String color,Pageable pageable);
|
|
@Query("select count(r) from ShelfRank r where (r.state = '" + ShelfRankState.IN_WORK + "' or r.state = '" +
|
ShelfRankState.FREE +"' or r.state = '" + ShelfRankState.NOT_WORK + "') and r.glassId = ?1")
|
public int countNotUseRanks2(String color);
|
|
@Query("select r from ShelfRank r where (r.state = '" + ShelfRankState.IN_WORK + "' or r.state = '" +
|
ShelfRankState.FREE +"' or r.state = '" + ShelfRankState.NOT_WORK + "') and r.thickness=?1 and r.glassId=?2")
|
public Page<ShelfRank> findNotUsedRanks3(Double thickness,String color,Pageable pageable);
|
|
@Query("select count(r) from ShelfRank r where (r.state = '" + ShelfRankState.IN_WORK + "' or r.state = '" +
|
ShelfRankState.FREE +"' or r.state = '" + ShelfRankState.NOT_WORK + "') and r.thickness=?1 and r.glassId=?2")
|
public int countNotUseRanks3(Double thickness,String color);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "'")
|
public List<ShelfRank> findInWorkRanks();
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK +"'or r.state='"+ShelfRankState.IN_WORKING+"'")
|
public List<ShelfRank> findInWorkRankAndInWorkingRanks();
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORKING + "'")
|
public List<ShelfRank> findInWorkingRanks();
|
|
@Query("select r from ShelfRank r where r.number = ?1")
|
public ShelfRank findShelfRankByNumber(String number);
|
|
@Query("select r from ShelfRank r where r.rawPackage.id =?1")
|
public ShelfRank findRankByRawId(Long id);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.width =?1")
|
public List<ShelfRank> findInWorkRanks1(double width);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.height =?1")
|
public List<ShelfRank> findInWorkRanks2(double height);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.thickness =?1")
|
public List<ShelfRank> findInWorkRanks3(double thickness);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.color =?1")
|
public List<ShelfRank> findInWorkRanks4(String color);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.width =?1 and r.rawPackage.height =?2")
|
public List<ShelfRank> findInWorkRanks5(double width,double height);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.width =?1 and r.rawPackage.thickness =?2")
|
public List<ShelfRank> findInWorkRanks6(double width,double thickness);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.width =?1 and r.rawPackage.color =?2")
|
public List<ShelfRank> findInWorkRanks7(double width,String color);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.height =?1 and r.rawPackage.thickness =?2")
|
public List<ShelfRank> findInWorkRanks8(double height,double thickness);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.height =?1 and r.rawPackage.color =?2")
|
public List<ShelfRank> findInWorkRanks9(double height,String color);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.thickness =?1 and r.rawPackage.color =?2")
|
public List<ShelfRank> findInWorkRanks10(double thickness,String color);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.width =?1 and r.rawPackage.height =?2 and r.rawPackage.thickness =?3")
|
public List<ShelfRank> findInWorkRanks11(double width,double height,double thickness);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.width =?1 and r.rawPackage.height =?2 and r.rawPackage.color =?3")
|
public List<ShelfRank> findInWorkRanks12(double width,double height,String color);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.width =?1 and r.rawPackage.thickness =?2 and r.rawPackage.color =?3")
|
public List<ShelfRank> findInWorkRanks13(double width,double thickness,String color);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.height =?1 and r.rawPackage.thickness =?2 and r.rawPackage.color =?3")
|
public List<ShelfRank> findInWorkRanks14(double height,double thickness,String color);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.width =?1 and r.rawPackage.height =?2 and r.rawPackage.thickness =?3 and r.rawPackage.color =?4")
|
public List<ShelfRank> findInWorkRanks15(double width,double height,double thickness,String color);
|
|
@Query("select r from ShelfRank r where r.state = '" + ShelfRankState.IN_WORK + "' and r.rawPackage.width =?1 and r.rawPackage.height =?2 and r.rawPackage.thickness =?3 and r.rawPackage.color =?4 and r.usestatu =null")
|
public List<ShelfRank> findInWorkRanks16(double width,double height,double thickness,String color);
|
}
|
