| | |
|---|
| | | @Select("select dev_no from agv_bas_devp where loc_sts = 'O'") |
|---|
| | | List<String> getAvailableEmptyInSite(); |
|---|
| | | |
|---|
| | | @Select("select station_code from agv_bas_devp where floor = #{floor} and cache_shelves = 'Y' group by station_code") |
|---|
| | | @Select("select station_code from agv_bas_devp where cache_shelves = 'N' and in_enable = 'Y' group by station_code") |
|---|
| | | List<String> selectCacheShelvesStationCodeByFloor(@Param("floor") int floor); |
|---|
| | | |
|---|
| | | @Select("select dev_no from agv_bas_devp where loc_type1 = #{locType} and out_enable = 'Y'") |
|---|
| | | List<String> selectCacheShelvesStationCodeByLocType(@Param("locType") Short locType); |
|---|
| | | |
|---|
| | | @Select("SELECT\n" + |
|---|
| | | "\tbas.dev_no,\n" + |
|---|
| | | "\tCOUNT ( mast.loc_no ) AS num \n" + |
|---|
