KprAIModelPower/src/main/java/com/shkpr/service/aimodelpower/jsonbean/zilaishui/JPTbMWater.java

package com.shkpr.service.aimodelpower.jsonbean.zilaishui;

import com.global.base.log.LogLevelFlag;
import com.global.base.log.LogPrintMgr;
import com.shkpr.service.aimodelpower.bizmgr.KprAimWaterCollecationBizFun;
import com.shkpr.service.aimodelpower.commtools.TimeTool;
import com.shkpr.service.aimodelpower.controllervalid.CommonParamValidList;
import com.shkpr.service.aimodelpower.controllervalid.CommonParamValidSS;
import lombok.Data;
import org.hibernate.validator.constraints.Range;
import org.springframework.util.StringUtils;

import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.time.temporal.TemporalAdjusters;

/**
 * @ClassName JPTbMWater
 * @Description: TODO 查询日预测数据
 * @Author LX
 * @Date 2024/5/27
 * @Version V1.0
 **/
@Data
public class JPTbMWater {
    private Boolean isPage = false;//是否分页 默认false

    private String orgId;//水厂id

    @Range(min = 0, max = 65535, groups = {CommonParamValidList.class, CommonParamValidSS.class})
    private Integer limit = 20;//若分页 默认数为20

    @Range(min = 0, max = Integer.MAX_VALUE, groups = {CommonParamValidList.class, CommonParamValidSS.class})
    private Integer offset = 0;//若分页 默认起始值为0

    private Long startDate;//开始日期 (实际时间为 年 月 日(就为当月的一号),时分秒为 00:00:00,如2023-03-01 00:00:00)

    private Long endDate;//结束日期 (实际时间为 年 月 日(就为当月的一号),时分秒为 00:00:00,如2023-03-01 00:00:00)

    //业务字段
    private String forDateStr;

    public boolean checkValid(){
        if ("water_volume_prediction_jiangjin2".equals(KprAimWaterCollecationBizFun.databaseName)){
            DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
            if (startDate == null && endDate != null) {
                return false;
            }
            StringBuilder strSql = new StringBuilder("");
            if (!StringUtils.isEmpty(orgId)) {
                strSql.append(" AND \"zone_id\" = '" + orgId + "'");
            }
            if (startDate == null && endDate == null) {
                //TODO 说明前端没传,那么默认为当前月往前推到一号作为开始和结束条件
                LocalDateTime nowDate = LocalDateTime.now();//结束时间
                nowDate = nowDate.with(TemporalAdjusters.lastDayOfMonth());
                nowDate = nowDate.withHour(0);
                nowDate = nowDate.withMinute(0);
                nowDate = nowDate.withSecond(0);

                LocalDateTime startLocalDate = nowDate;
                startLocalDate = startLocalDate.with(TemporalAdjusters.firstDayOfMonth());

                String startLocalDateStr = startLocalDate.format(formatter);
                String endLocalDateStr = nowDate.format(formatter);
                strSql.append(" AND \"date\" BETWEEN  '" + startLocalDateStr + "' " + "AND '" + endLocalDateStr + "'");
                forDateStr = strSql.toString();
                startDate = TimeTool.convertDateStr2UTC(startLocalDateStr);
                endDate = TimeTool.convertDateStr2UTC(endLocalDateStr);
            } else if (startDate != null && endDate != null) {
                try {
                    LocalDateTime startLocalDate = LocalDateTime.parse(TimeTool.convertUTC2DateStr(startDate, TimeTool.TIMESTAMP_FORMAT), DateTimeFormatter.ofPattern(TimeTool.TIMESTAMP_FORMAT));
                    LocalDateTime endLocalDate = LocalDateTime.parse(TimeTool.convertUTC2DateStr(endDate, TimeTool.TIMESTAMP_FORMAT), DateTimeFormatter.ofPattern(TimeTool.TIMESTAMP_FORMAT));
//                long monthsBetween = ChronoUnit.MONTHS.between(startLocalDate, endLocalDate);
                    if (startLocalDate.isAfter(endLocalDate)) {
                        return false;
                    } else if (endLocalDate.isBefore(startLocalDate)) {
                        return false;
                    } else if (startLocalDate.equals(endLocalDate) || startLocalDate.isBefore(endLocalDate)) {
                        //TODO 说明符合可组成查询日期的条件
                        //TODO 按照需求,特殊化结束时间再加4天
                        startLocalDate = startLocalDate.with(TemporalAdjusters.firstDayOfMonth());
                        endLocalDate = endLocalDate.minusDays(-4);
                        String startLocalDateStr = startLocalDate.format(formatter);
                        String endLocalDateStr = endLocalDate.format(formatter);
                        strSql.append(" AND \"date\" BETWEEN  '" + startLocalDateStr + "' " + "AND '" + endLocalDateStr + "'");
                        forDateStr = strSql.toString();
                        startDate = TimeTool.convertDateStr2UTC(startLocalDateStr);
                        endDate = TimeTool.convertDateStr2UTC(endLocalDateStr);
                    }
                } catch (Exception ex) {
                    LogPrintMgr.getInstance().printLogMsg(LogLevelFlag.LOG_ERROR, "JPCustomerMeterSS", "JPCustomerMeterSS"
                            , String.format("errorMsg:%s====>"
                                    , ex.getLocalizedMessage()));
                    return false;
                }
            } else if (startDate != null && endDate == null) {//警告没事,增加代码可读性
                //TODO 说明startDate传了  endDate没传 , 那么endDate为startDate月的最后一天
                LocalDateTime startLocalDate = LocalDateTime.parse(TimeTool.convertUTC2DateStr(startDate, TimeTool.TIMESTAMP_FORMAT), DateTimeFormatter.ofPattern(TimeTool.TIMESTAMP_FORMAT))
                        .with(TemporalAdjusters.firstDayOfMonth());
                LocalDateTime endLocalDate = startLocalDate.with(TemporalAdjusters.lastDayOfMonth());
                String startLocalDateStr = startLocalDate.format(formatter);
                String endLocalDateStr = endLocalDate.format(formatter);
                strSql.append(" AND \"date\" BETWEEN  '" + startLocalDateStr + "' " + "AND '" + endLocalDateStr + "'");
                forDateStr = strSql.toString();
                endDate = TimeTool.convertDateStr2UTC(endLocalDateStr);
            }
            return true;
        }else {
            DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
            if (startDate == null && endDate != null) {
                return false;
            }
            StringBuilder strSql = new StringBuilder("");
            if (!StringUtils.isEmpty(orgId)) {
                strSql.append(" AND \"orgId\" = '" + orgId + "'");
            }
            if (startDate == null && endDate == null) {
                //TODO 说明前端没传,那么默认为当前月往前推到一号作为开始和结束条件
                LocalDateTime nowDate = LocalDateTime.now();//结束时间
                nowDate = nowDate.with(TemporalAdjusters.lastDayOfMonth());
                nowDate = nowDate.withHour(0);
                nowDate = nowDate.withMinute(0);
                nowDate = nowDate.withSecond(0);

                LocalDateTime startLocalDate = nowDate;
                startLocalDate = startLocalDate.with(TemporalAdjusters.firstDayOfMonth());

                String startLocalDateStr = startLocalDate.format(formatter);
                String endLocalDateStr = nowDate.format(formatter);
                strSql.append(" AND \"Date\" BETWEEN  '" + startLocalDateStr + "' " + "AND '" + endLocalDateStr + "'");
                forDateStr = strSql.toString();
                startDate = TimeTool.convertDateStr2UTC(startLocalDateStr);
                endDate = TimeTool.convertDateStr2UTC(endLocalDateStr);
            } else if (startDate != null && endDate != null) {
                try {
                    LocalDateTime startLocalDate = LocalDateTime.parse(TimeTool.convertUTC2DateStr(startDate, TimeTool.TIMESTAMP_FORMAT), DateTimeFormatter.ofPattern(TimeTool.TIMESTAMP_FORMAT));
                    LocalDateTime endLocalDate = LocalDateTime.parse(TimeTool.convertUTC2DateStr(endDate, TimeTool.TIMESTAMP_FORMAT), DateTimeFormatter.ofPattern(TimeTool.TIMESTAMP_FORMAT));
//                long monthsBetween = ChronoUnit.MONTHS.between(startLocalDate, endLocalDate);
                    if (startLocalDate.isAfter(endLocalDate)) {
                        return false;
                    } else if (endLocalDate.isBefore(startLocalDate)) {
                        return false;
                    } else if (startLocalDate.equals(endLocalDate) || startLocalDate.isBefore(endLocalDate)) {
                        //TODO 说明符合可组成查询日期的条件
                        //TODO 按照需求,特殊化结束时间再加4天
                        startLocalDate = startLocalDate.with(TemporalAdjusters.firstDayOfMonth());
                        endLocalDate = endLocalDate.minusDays(-4);
                        String startLocalDateStr = startLocalDate.format(formatter);
                        String endLocalDateStr = endLocalDate.format(formatter);
                        strSql.append(" AND \"Date\" BETWEEN  '" + startLocalDateStr + "' " + "AND '" + endLocalDateStr + "'");
                        forDateStr = strSql.toString();
                        startDate = TimeTool.convertDateStr2UTC(startLocalDateStr);
                        endDate = TimeTool.convertDateStr2UTC(endLocalDateStr);
                    }
                } catch (Exception ex) {
                    LogPrintMgr.getInstance().printLogMsg(LogLevelFlag.LOG_ERROR, "JPCustomerMeterSS", "JPCustomerMeterSS"
                            , String.format("errorMsg:%s====>"
                                    , ex.getLocalizedMessage()));
                    return false;
                }
            } else if (startDate != null && endDate == null) {//警告没事,增加代码可读性
                //TODO 说明startDate传了  endDate没传 , 那么endDate为startDate月的最后一天
                LocalDateTime startLocalDate = LocalDateTime.parse(TimeTool.convertUTC2DateStr(startDate, TimeTool.TIMESTAMP_FORMAT), DateTimeFormatter.ofPattern(TimeTool.TIMESTAMP_FORMAT))
                        .with(TemporalAdjusters.firstDayOfMonth());
                LocalDateTime endLocalDate = startLocalDate.with(TemporalAdjusters.lastDayOfMonth());
                String startLocalDateStr = startLocalDate.format(formatter);
                String endLocalDateStr = endLocalDate.format(formatter);
                strSql.append(" AND \"Date\" BETWEEN  '" + startLocalDateStr + "' " + "AND '" + endLocalDateStr + "'");
                forDateStr = strSql.toString();
                endDate = TimeTool.convertDateStr2UTC(endLocalDateStr);
            }
            return true;
        }
    }
}