| | |
|---|
| | | @Select("SELECT plt_type FROM asr_wrk_mast_log WHERE io_type = 101 AND plt_type IS NOT NULL AND plt_type > 0 AND user_no = #{userNo} AND ((#{batchSeq} IS NULL AND batch_seq IS NULL) OR batch_seq = #{batchSeq})") |
|---|
| | | List<Integer> listOutboundPltTypesByUserNo(@Param("userNo") String userNo, @Param("batchSeq") String batchSeq); |
|---|
| | | |
|---|
| | | @Select("SELECT MIN(ISNULL(appe_time, io_time)) FROM asr_wrk_mast_log WHERE train_no = #{trainNo} AND io_type < 100") |
|---|
| | | Date selectFirstInboundCreateTimeByTrainNo(@Param("trainNo") String trainNo); |
|---|
| | | |
|---|
| | | @Select("SELECT wrk_no FROM asr_wrk_mast_log WHERE train_no = #{trainNo} AND io_type < 100 AND wrk_sts = 5") |
|---|
| | | List<Integer> listFinishedInboundWrkNosByTrainNo(@Param("trainNo") String trainNo); |
|---|
| | | |
|---|
| | | @Select("SELECT ISNULL(SUM(CAST(ISNULL(cost_time, 0) AS BIGINT)), 0) " + |
|---|
| | | "FROM asr_wrk_mast_log " + |
|---|
| | | "WHERE wrk_sts = #{wrkSts} " + |
|---|
