| | |
|---|
| | | @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") |
|---|
| | | @Select("SELECT wrk_no FROM asr_wrk_mast_log WHERE train_no = #{trainNo} AND io_type = 1 AND wrk_sts = 5") |
|---|
| | | List<Integer> listFinishedInboundWrkNosByTrainNo(@Param("trainNo") String trainNo); |
|---|
| | | |
|---|
| | | @Select("SELECT ISNULL(SUM(CAST(ISNULL(cost_time, 0) AS BIGINT)), 0) " + |
|---|
