优化SQL语句，以提高查询速度

liurunyu

2025-07-29 83c1bbca96beb5461fff56d861214444348e86d0

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voAllRound/VoArIntakeLossDay.java

New file
@@ -0,0 +1,38 @@
package com.dy.pipIrrGlobal.voAllRound;

import com.alibaba.fastjson2.annotation.JSONField;
import com.alibaba.fastjson2.writer.ObjectWriterImplToString;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.annotation.JsonPropertyOrder;
import lombok.Data;

import java.util.Date;

/**
 * @Author: liurunyu
 * @Date: 2025/2/5 9:59
 * @Description
 */
@Data
@JsonPropertyOrder({ "intakeId", "dt", "loss" })
public class VoArIntakeLossDay {
    public static final long serialVersionUID = 202502051001001L;

    /**
     * 取水口ID
     */
    @JSONField(serializeUsing= ObjectWriterImplToString.class)
    public Long intakeId;

    /**
     * 日期时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    public Date dt ;

    /**
     * 日漏损量
     */
    public Double loss ;

}