| | |
|---|
| | | IF(#{terminateTime} < sche.start_time, 6, |
|---|
| | | IF(#{terminateTime} < DATE_ADD(sche.start_time, INTERVAL sche.duration MINUTE), 5, 4)) AS state, |
|---|
| | | IF(#{terminateTime} > sche.start_time, sche.start_time, NULL) AS startTime, |
|---|
| | | IF(#{terminateTime} > DATE_ADD(sche.start_time, INTERVAL sche.duration MINUTE), DATE_ADD(sche.start_time, INTERVAL sche.duration MINUTE), |
|---|
| | | IF(#{terminateTime} > sche.start_time, #{terminateTime}, NULL)) AS stopTime, |
|---|
| | | IF(#{terminateTime} > DATE_ADD(sche.start_time, INTERVAL sche.duration MINUTE), DATE_ADD(sche.start_time, INTERVAL sche.duration MINUTE), |
|---|
| | | IF(#{terminateTime} > sche.start_time, #{terminateTime}, NULL)) AS stopTime, |
|---|
| | | <!--sche.duration,--> |
|---|
| | | TIMESTAMPDIFF(MINUTE, |
|---|
| | | IF('2025-04-15 15:27' > sche.start_time, sche.start_time, NULL), |
|---|
| | | IF('2025-04-15 15:27' > DATE_ADD(sche.start_time, INTERVAL sche.duration MINUTE), DATE_ADD(sche.start_time, INTERVAL sche.duration MINUTE), |
|---|
| | | IF('2025-04-15 15:27' > sche.start_time, '2025-04-15 15:27', NULL)) |
|---|
| | | IF(#{terminateTime} > sche.start_time, sche.start_time, NULL), |
|---|
| | | IF(#{terminateTime} > DATE_ADD(sche.start_time, INTERVAL sche.duration MINUTE), DATE_ADD(sche.start_time, INTERVAL sche.duration MINUTE), |
|---|
| | | IF(#{terminateTime} > sche.start_time, #{terminateTime}, NULL)) |
|---|
| | | ) AS duration, |
|---|
| | | NULL AS publishResult |
|---|
| | | FROM ir_irrigate_group grp |
|---|
