| | |
| | | */ |
| | | |
| | | @Data |
| | | @JsonPropertyOrder({"planName", "projectName", "planStartTime", "planStopTime", "groups"}) |
| | | @JsonPropertyOrder({"planName", "projectName", "state", "planStartTime", "planStopTime", "groups"}) |
| | | public class VoPlanDetails { |
| | | private static final long serialVersionUID = 202504091125001L; |
| | | |
| | |
| | | private String projectName; |
| | | |
| | | /** |
| | | * 灌溉计划状态 |
| | | */ |
| | | private Integer state; |
| | | |
| | | /** |
| | | * 灌溉计划开始时间 |
| | | */ |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm", timezone = "GMT+8") |
| | |
| | | SELECT |
| | | plan.plan_name AS planName, |
| | | pro.project_name AS projectName, |
| | | IF(plan.executing_state = 3, '5', |
| | | IF(NOW() < plan.plan_start_time,'2', |
| | | IF(NOW() < plan.plan_stop_time, '3', '4'))) AS state, |
| | | plan.plan_start_time AS planStartTime, |
| | | plan.plan_stop_time AS planStopTime, |
| | | NULL AS groupDetails |