1、农户用水量日统计中增加属性“次数”； 2、临时任务中增加“转存农户日取水量，由纵型改为横型”

liurunyu

2024-12-28 fd17cc4990f991bdd69ad4f7f0b6e288b1d1fc47

1、农户用水量日统计中增加属性“次数”；
2、临时任务中增加“转存农户日取水量，由纵型改为横型”

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmClientAmountDayMapper.java

@@ -98,4 +98,6 @@
     */
    List<VoClientAmountStatistics> statisticsByClient(@Param("startId")Long statisticsStartId, @Param("endId")Long statisticsEndId) ;



}

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountDayMapper.java

New file
@@ -0,0 +1,78 @@
package com.dy.pipIrrGlobal.daoSt;

import com.dy.pipIrrGlobal.pojoSt.StClientAmountDay;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Author: liurunyu
 * @Date: 2024/12/28 11:58
 * @Description
 */
@Mapper
public interface StClientAmountDayMapper {
    /**
     * delete by primary key
     *
     * @param id primaryKey
     * @return deleteCount
     */
    int deleteByPrimaryKey(Long id);

    /**
     * insert record to table
     *
     * @param record the record
     * @return insert count
     */
    int insert(StClientAmountDay record);

    /**
     * insert record to table selective
     *
     * @param record the record
     * @return insert count
     */
    int insertSelective(StClientAmountDay record);

    /**
     * select by primary key
     *
     * @param id primary key
     * @return object by primary key
     */
    StClientAmountDay selectByPrimaryKey(Long id);

    /**
     * update record selective
     *
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKeySelective(StClientAmountDay record);

    /**
     * update record
     *
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKey(StClientAmountDay record);


    //////////////////////////////////////
    //统计相关

    /**
     * æŸ¥è¯¢ç”¨æ°´æˆ·ä¸€ä¸ªæœˆæ‰€æœ‰æ—¥çš„用水量
     * @param clientId
     * @param year
     * @param month
     * @return
     */
    List<StClientAmountDay> selectByClientIdAndYearAndMonthAndDay(@Param("clientId")Long clientId,
                                                                  @Param("year")Integer year,
                                                                  @Param("month")Integer month) ;
}

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoSt/StClientAmountDay.java

New file
@@ -0,0 +1,581 @@
package com.dy.pipIrrGlobal.pojoSt;

/**
 * @Author: liurunyu
 * @Date: 2024/12/28 11:16
 * @Description
 */

import com.alibaba.fastjson2.annotation.JSONField;
import com.alibaba.fastjson2.writer.ObjectWriterImplToString;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.dy.common.po.BaseEntity;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.*;

@TableName(value="st_client_amount_day", autoResultMap = true)
@Data
@Builder
@ToString
@NoArgsConstructor
@AllArgsConstructor
@Schema(name = "农户用水量日统计")
public class StClientAmountDay implements BaseEntity {

    public static final long serialVersionUID = 202412281145001L;
    /**
     * ä¸»é”®
     */
    @Schema(description = "主键", requiredMode = Schema.RequiredMode.REQUIRED)
    @JSONField(serializeUsing= ObjectWriterImplToString.class)
    @TableId(type = IdType.INPUT)
    public Long id;

    /**
     * å¤–键，指向农户
     */
    @Schema(description = "农户外键", requiredMode = Schema.RequiredMode.NOT_REQUIRED)
    @JSONField(serializeUsing= ObjectWriterImplToString.class)
    public Long clientId;

    /**
     * å¹´åº¦
     */
    public Integer year;

    /**
     * æœˆä»½
     */
    public Integer month;

    /**
     * 1号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount1;

    /**
     * 1号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money1;

    /**
     * 1号用水次数
     */
    public Integer times1;

    /**
     * 2号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount2;

    /**
     * 2号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money2;

    /**
     * 2号用水次数
     */
    public Integer times2;

    /**
     * 3号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount3;

    /**
     * 3号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money3;

    /**
     * 3号用水次数
     */
    public Integer times3;

    /**
     * 4号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount4;

    /**
     * 4号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money4;

    /**
     * 4号用水次数
     */
    public Integer times4;

    /**
     * 5号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount5;

    /**
     * 5号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money5;

    /**
     * 5号用水次数
     */
    public Integer times5;

    /**
     * 6号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount6;

    /**
     * 6号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money6;

    /**
     * 6号用水次数
     */
    public Integer times6;

    /**
     * 7号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount7;

    /**
     * 7号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money7;

    /**
     * 7号用水次数
     */
    public Integer times7;

    /**
     * 8号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount8;

    /**
     * 8号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money8;

    /**
     * 8号用水次数
     */
    public Integer times8;

    /**
     * 9号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount9;

    /**
     * 9号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money9;

    /**
     * 9号用水次数
     */
    public Integer times9;

    /**
     * 10号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount10;

    /**
     * 10号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money10;

    /**
     * 10号用水次数
     */
    public Integer times10;

    /**
     * 11号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount11;

    /**
     * 11号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money11;

    /**
     * 11号用水次数
     */
    public Integer times11;

    /**
     * 12号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount12;

    /**
     * 12号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money12;

    /**
     * 12号用水次数
     */
    public Integer times12;

    /**
     * 13号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount13;

    /**
     * 13号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money13;

    /**
     * 13号用水次数
     */
    public Integer times13;

    /**
     * 14号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount14;

    /**
     * 14号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money14;

    /**
     * 14号用水次数
     */
    public Integer times14;

    /**
     * 15号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount15;

    /**
     * 15号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money15;

    /**
     * 15号用水次数
     */
    public Integer times15;

    /**
     * 16号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount16;

    /**
     * 16号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money16;

    /**
     * 16号用水次数
     */
    public Integer times16;

    /**
     * 17号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount17;

    /**
     * 17号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money17;

    /**
     * 17号用水次数
     */
    public Integer times17;

    /**
     * 18号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount18;

    /**
     * 18号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money18;

    /**
     * 18号用水次数
     */
    public Integer times18;

    /**
     * 19号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount19;

    /**
     * 19号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money19;

    /**
     * 19号用水次数
     */
    public Integer times19;

    /**
     * 20号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount20;

    /**
     * 20号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money20;

    /**
     * 20号用水次数
     */
    public Integer times20;

    /**
     * 21号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount21;

    /**
     * 21号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money21;

    /**
     * 21号用水次数
     */
    public Integer times21;

    /**
     * 22号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount22;

    /**
     * 22号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money22;

    /**
     * 22号用水次数
     */
    public Integer times22;

    /**
     * 23号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount23;

    /**
     * 23号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money23;

    /**
     * 23号用水次数
     */
    public Integer times23;

    /**
     * 24号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount24;

    /**
     * 24号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money24;

    /**
     * 24号用水次数
     */
    public Integer times24;

    /**
     * 25号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount25;

    /**
     * 25号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money25;

    /**
     * 25号用水次数
     */
    public Integer times25;

    /**
     * 26号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount26;

    /**
     * 26号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money26;

    /**
     * 26号用水次数
     */
    public Integer times26;

    /**
     * 27号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount27;

    /**
     * 27号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money27;

    /**
     * 27号用水次数
     */
    public Integer times27;

    /**
     * 28号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount28;

    /**
     * 28号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money28;

    /**
     * 28号用水次数
     */
    public Integer times28;

    /**
     * 29号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount29;

    /**
     * 29号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money29;

    /**
     * 29号用水次数
     */
    public Integer times29;

    /**
     * 30号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount30;

    /**
     * 30号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money30;

    /**
     * 30号用水次数
     */
    public Integer times30;

    /**
     * 31号用水量统计
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount31;

    /**
     * 31号花费金额
     */
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money31;

    /**
     * 31号用水次数
     */
    public Integer times31;

}

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voSt/VoClientAmountStatistics.java

@@ -12,7 +12,8 @@
public class VoClientAmountStatistics {
    public Long clientId ;
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double amount;
    public Double amount;//用水量
    @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" )
    public Double money;
    public Double money;//水费金额
    public Integer times;//次数
}

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/StClientAmountDayMapper.xml

New file
@@ -0,0 +1,1195 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dy.pipIrrGlobal.daoSt.StClientAmountDayMapper">
  <resultMap id="BaseResultMap" type="com.dy.pipIrrGlobal.pojoSt.StClientAmountDay">
    <!--@mbg.generated-->
    <!--@Table st_client_amount_day-->
    <id column="id" jdbcType="BIGINT" property="id" />
    <result column="client_id" jdbcType="BIGINT" property="clientId" />
    <result column="year" jdbcType="INTEGER" property="year" />
    <result column="month" jdbcType="INTEGER" property="month" />
    <result column="amount1" jdbcType="FLOAT" property="amount1" />
    <result column="money1" jdbcType="FLOAT" property="money1" />
    <result column="times1" jdbcType="INTEGER" property="times1" />
    <result column="amount2" jdbcType="FLOAT" property="amount2" />
    <result column="money2" jdbcType="FLOAT" property="money2" />
    <result column="times2" jdbcType="INTEGER" property="times2" />
    <result column="amount3" jdbcType="FLOAT" property="amount3" />
    <result column="money3" jdbcType="FLOAT" property="money3" />
    <result column="times3" jdbcType="INTEGER" property="times3" />
    <result column="amount4" jdbcType="FLOAT" property="amount4" />
    <result column="money4" jdbcType="FLOAT" property="money4" />
    <result column="times4" jdbcType="INTEGER" property="times4" />
    <result column="amount5" jdbcType="FLOAT" property="amount5" />
    <result column="money5" jdbcType="FLOAT" property="money5" />
    <result column="times5" jdbcType="INTEGER" property="times5" />
    <result column="amount6" jdbcType="FLOAT" property="amount6" />
    <result column="money6" jdbcType="FLOAT" property="money6" />
    <result column="times6" jdbcType="INTEGER" property="times6" />
    <result column="amount7" jdbcType="FLOAT" property="amount7" />
    <result column="money7" jdbcType="FLOAT" property="money7" />
    <result column="times7" jdbcType="INTEGER" property="times7" />
    <result column="amount8" jdbcType="FLOAT" property="amount8" />
    <result column="money8" jdbcType="FLOAT" property="money8" />
    <result column="times8" jdbcType="INTEGER" property="times8" />
    <result column="amount9" jdbcType="FLOAT" property="amount9" />
    <result column="money9" jdbcType="FLOAT" property="money9" />
    <result column="times9" jdbcType="INTEGER" property="times9" />
    <result column="amount10" jdbcType="FLOAT" property="amount10" />
    <result column="money10" jdbcType="FLOAT" property="money10" />
    <result column="times10" jdbcType="INTEGER" property="times10" />
    <result column="amount11" jdbcType="FLOAT" property="amount11" />
    <result column="money11" jdbcType="FLOAT" property="money11" />
    <result column="times11" jdbcType="INTEGER" property="times11" />
    <result column="amount12" jdbcType="FLOAT" property="amount12" />
    <result column="money12" jdbcType="FLOAT" property="money12" />
    <result column="times12" jdbcType="INTEGER" property="times12" />
    <result column="amount13" jdbcType="FLOAT" property="amount13" />
    <result column="money13" jdbcType="FLOAT" property="money13" />
    <result column="times13" jdbcType="INTEGER" property="times13" />
    <result column="amount14" jdbcType="FLOAT" property="amount14" />
    <result column="money14" jdbcType="FLOAT" property="money14" />
    <result column="times14" jdbcType="INTEGER" property="times14" />
    <result column="amount15" jdbcType="FLOAT" property="amount15" />
    <result column="money15" jdbcType="FLOAT" property="money15" />
    <result column="times15" jdbcType="INTEGER" property="times15" />
    <result column="amount16" jdbcType="FLOAT" property="amount16" />
    <result column="money16" jdbcType="FLOAT" property="money16" />
    <result column="times16" jdbcType="INTEGER" property="times16" />
    <result column="amount17" jdbcType="FLOAT" property="amount17" />
    <result column="money17" jdbcType="FLOAT" property="money17" />
    <result column="times17" jdbcType="INTEGER" property="times17" />
    <result column="amount18" jdbcType="FLOAT" property="amount18" />
    <result column="money18" jdbcType="FLOAT" property="money18" />
    <result column="times18" jdbcType="INTEGER" property="times18" />
    <result column="amount19" jdbcType="FLOAT" property="amount19" />
    <result column="money19" jdbcType="FLOAT" property="money19" />
    <result column="times19" jdbcType="INTEGER" property="times19" />
    <result column="amount20" jdbcType="FLOAT" property="amount20" />
    <result column="money20" jdbcType="FLOAT" property="money20" />
    <result column="times20" jdbcType="INTEGER" property="times20" />
    <result column="amount21" jdbcType="FLOAT" property="amount21" />
    <result column="money21" jdbcType="FLOAT" property="money21" />
    <result column="times21" jdbcType="INTEGER" property="times21" />
    <result column="amount22" jdbcType="FLOAT" property="amount22" />
    <result column="money22" jdbcType="FLOAT" property="money22" />
    <result column="times22" jdbcType="INTEGER" property="times22" />
    <result column="amount23" jdbcType="FLOAT" property="amount23" />
    <result column="money23" jdbcType="FLOAT" property="money23" />
    <result column="times23" jdbcType="INTEGER" property="times23" />
    <result column="amount24" jdbcType="FLOAT" property="amount24" />
    <result column="money24" jdbcType="FLOAT" property="money24" />
    <result column="times24" jdbcType="INTEGER" property="times24" />
    <result column="amount25" jdbcType="FLOAT" property="amount25" />
    <result column="money25" jdbcType="FLOAT" property="money25" />
    <result column="times25" jdbcType="INTEGER" property="times25" />
    <result column="amount26" jdbcType="FLOAT" property="amount26" />
    <result column="money26" jdbcType="FLOAT" property="money26" />
    <result column="times26" jdbcType="INTEGER" property="times26" />
    <result column="amount27" jdbcType="FLOAT" property="amount27" />
    <result column="money27" jdbcType="FLOAT" property="money27" />
    <result column="times27" jdbcType="INTEGER" property="times27" />
    <result column="amount28" jdbcType="FLOAT" property="amount28" />
    <result column="money28" jdbcType="FLOAT" property="money28" />
    <result column="times28" jdbcType="INTEGER" property="times28" />
    <result column="amount29" jdbcType="FLOAT" property="amount29" />
    <result column="money29" jdbcType="FLOAT" property="money29" />
    <result column="times29" jdbcType="INTEGER" property="times29" />
    <result column="amount30" jdbcType="FLOAT" property="amount30" />
    <result column="money30" jdbcType="FLOAT" property="money30" />
    <result column="times30" jdbcType="INTEGER" property="times30" />
    <result column="amount31" jdbcType="FLOAT" property="amount31" />
    <result column="money31" jdbcType="FLOAT" property="money31" />
    <result column="times31" jdbcType="INTEGER" property="times31" />
  </resultMap>
  <sql id="Base_Column_List">
    <!--@mbg.generated-->
    id, client_id, `year`, `month`, amount1, money1, times1, amount2, money2, times2, 
    amount3, money3, times3, amount4, money4, times4, amount5, money5, times5, amount6, 
    money6, times6, amount7, money7, times7, amount8, money8, times8, amount9, money9, 
    times9, amount10, money10, times10, amount11, money11, times11, amount12, money12, 
    times12, amount13, money13, times13, amount14, money14, times14, amount15, money15, 
    times15, amount16, money16, times16, amount17, money17, times17, amount18, money18, 
    times18, amount19, money19, times19, amount20, money20, times20, amount21, money21, 
    times21, amount22, money22, times22, amount23, money23, times23, amount24, money24, 
    times24, amount25, money25, times25, amount26, money26, times26, amount27, money27, 
    times27, amount28, money28, times28, amount29, money29, times29, amount30, money30, 
    times30, amount31, money31, times31
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
    <!--@mbg.generated-->
    select 
    <include refid="Base_Column_List" />
    from st_client_amount_day
    where id = #{id,jdbcType=BIGINT}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
    <!--@mbg.generated-->
    delete from st_client_amount_day
    where id = #{id,jdbcType=BIGINT}
  </delete>
  <insert id="insert" parameterType="com.dy.pipIrrGlobal.pojoSt.StClientAmountDay">
    <!--@mbg.generated-->
    insert into st_client_amount_day (id, client_id, `year`, 
      `month`, amount1, money1, 
      times1, amount2, money2, 
      times2, amount3, money3, 
      times3, amount4, money4, 
      times4, amount5, money5, 
      times5, amount6, money6, 
      times6, amount7, money7, 
      times7, amount8, money8, 
      times8, amount9, money9, 
      times9, amount10, money10, 
      times10, amount11, money11, 
      times11, amount12, money12, 
      times12, amount13, money13, 
      times13, amount14, money14, 
      times14, amount15, money15, 
      times15, amount16, money16, 
      times16, amount17, money17, 
      times17, amount18, money18, 
      times18, amount19, money19, 
      times19, amount20, money20, 
      times20, amount21, money21, 
      times21, amount22, money22, 
      times22, amount23, money23, 
      times23, amount24, money24, 
      times24, amount25, money25, 
      times25, amount26, money26, 
      times26, amount27, money27, 
      times27, amount28, money28, 
      times28, amount29, money29, 
      times29, amount30, money30, 
      times30, amount31, money31, 
      times31)
    values (#{id,jdbcType=BIGINT}, #{clientId,jdbcType=BIGINT}, #{year,jdbcType=INTEGER}, 
      #{month,jdbcType=INTEGER}, #{amount1,jdbcType=FLOAT}, #{money1,jdbcType=FLOAT}, 
      #{times1,jdbcType=INTEGER}, #{amount2,jdbcType=FLOAT}, #{money2,jdbcType=FLOAT}, 
      #{times2,jdbcType=INTEGER}, #{amount3,jdbcType=FLOAT}, #{money3,jdbcType=FLOAT}, 
      #{times3,jdbcType=INTEGER}, #{amount4,jdbcType=FLOAT}, #{money4,jdbcType=FLOAT}, 
      #{times4,jdbcType=INTEGER}, #{amount5,jdbcType=FLOAT}, #{money5,jdbcType=FLOAT}, 
      #{times5,jdbcType=INTEGER}, #{amount6,jdbcType=FLOAT}, #{money6,jdbcType=FLOAT}, 
      #{times6,jdbcType=INTEGER}, #{amount7,jdbcType=FLOAT}, #{money7,jdbcType=FLOAT}, 
      #{times7,jdbcType=INTEGER}, #{amount8,jdbcType=FLOAT}, #{money8,jdbcType=FLOAT}, 
      #{times8,jdbcType=INTEGER}, #{amount9,jdbcType=FLOAT}, #{money9,jdbcType=FLOAT}, 
      #{times9,jdbcType=INTEGER}, #{amount10,jdbcType=FLOAT}, #{money10,jdbcType=FLOAT}, 
      #{times10,jdbcType=INTEGER}, #{amount11,jdbcType=FLOAT}, #{money11,jdbcType=FLOAT}, 
      #{times11,jdbcType=INTEGER}, #{amount12,jdbcType=FLOAT}, #{money12,jdbcType=FLOAT}, 
      #{times12,jdbcType=INTEGER}, #{amount13,jdbcType=FLOAT}, #{money13,jdbcType=FLOAT}, 
      #{times13,jdbcType=INTEGER}, #{amount14,jdbcType=FLOAT}, #{money14,jdbcType=FLOAT}, 
      #{times14,jdbcType=INTEGER}, #{amount15,jdbcType=FLOAT}, #{money15,jdbcType=FLOAT}, 
      #{times15,jdbcType=INTEGER}, #{amount16,jdbcType=FLOAT}, #{money16,jdbcType=FLOAT}, 
      #{times16,jdbcType=INTEGER}, #{amount17,jdbcType=FLOAT}, #{money17,jdbcType=FLOAT}, 
      #{times17,jdbcType=INTEGER}, #{amount18,jdbcType=FLOAT}, #{money18,jdbcType=FLOAT}, 
      #{times18,jdbcType=INTEGER}, #{amount19,jdbcType=FLOAT}, #{money19,jdbcType=FLOAT}, 
      #{times19,jdbcType=INTEGER}, #{amount20,jdbcType=FLOAT}, #{money20,jdbcType=FLOAT}, 
      #{times20,jdbcType=INTEGER}, #{amount21,jdbcType=FLOAT}, #{money21,jdbcType=FLOAT}, 
      #{times21,jdbcType=INTEGER}, #{amount22,jdbcType=FLOAT}, #{money22,jdbcType=FLOAT}, 
      #{times22,jdbcType=INTEGER}, #{amount23,jdbcType=FLOAT}, #{money23,jdbcType=FLOAT}, 
      #{times23,jdbcType=INTEGER}, #{amount24,jdbcType=FLOAT}, #{money24,jdbcType=FLOAT}, 
      #{times24,jdbcType=INTEGER}, #{amount25,jdbcType=FLOAT}, #{money25,jdbcType=FLOAT}, 
      #{times25,jdbcType=INTEGER}, #{amount26,jdbcType=FLOAT}, #{money26,jdbcType=FLOAT}, 
      #{times26,jdbcType=INTEGER}, #{amount27,jdbcType=FLOAT}, #{money27,jdbcType=FLOAT}, 
      #{times27,jdbcType=INTEGER}, #{amount28,jdbcType=FLOAT}, #{money28,jdbcType=FLOAT}, 
      #{times28,jdbcType=INTEGER}, #{amount29,jdbcType=FLOAT}, #{money29,jdbcType=FLOAT}, 
      #{times29,jdbcType=INTEGER}, #{amount30,jdbcType=FLOAT}, #{money30,jdbcType=FLOAT}, 
      #{times30,jdbcType=INTEGER}, #{amount31,jdbcType=FLOAT}, #{money31,jdbcType=FLOAT}, 
      #{times31,jdbcType=INTEGER})
  </insert>
  <insert id="insertSelective" parameterType="com.dy.pipIrrGlobal.pojoSt.StClientAmountDay">
    <!--@mbg.generated-->
    insert into st_client_amount_day
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="clientId != null">
        client_id,
      </if>
      <if test="year != null">
        `year`,
      </if>
      <if test="month != null">
        `month`,
      </if>
      <if test="amount1 != null">
        amount1,
      </if>
      <if test="money1 != null">
        money1,
      </if>
      <if test="times1 != null">
        times1,
      </if>
      <if test="amount2 != null">
        amount2,
      </if>
      <if test="money2 != null">
        money2,
      </if>
      <if test="times2 != null">
        times2,
      </if>
      <if test="amount3 != null">
        amount3,
      </if>
      <if test="money3 != null">
        money3,
      </if>
      <if test="times3 != null">
        times3,
      </if>
      <if test="amount4 != null">
        amount4,
      </if>
      <if test="money4 != null">
        money4,
      </if>
      <if test="times4 != null">
        times4,
      </if>
      <if test="amount5 != null">
        amount5,
      </if>
      <if test="money5 != null">
        money5,
      </if>
      <if test="times5 != null">
        times5,
      </if>
      <if test="amount6 != null">
        amount6,
      </if>
      <if test="money6 != null">
        money6,
      </if>
      <if test="times6 != null">
        times6,
      </if>
      <if test="amount7 != null">
        amount7,
      </if>
      <if test="money7 != null">
        money7,
      </if>
      <if test="times7 != null">
        times7,
      </if>
      <if test="amount8 != null">
        amount8,
      </if>
      <if test="money8 != null">
        money8,
      </if>
      <if test="times8 != null">
        times8,
      </if>
      <if test="amount9 != null">
        amount9,
      </if>
      <if test="money9 != null">
        money9,
      </if>
      <if test="times9 != null">
        times9,
      </if>
      <if test="amount10 != null">
        amount10,
      </if>
      <if test="money10 != null">
        money10,
      </if>
      <if test="times10 != null">
        times10,
      </if>
      <if test="amount11 != null">
        amount11,
      </if>
      <if test="money11 != null">
        money11,
      </if>
      <if test="times11 != null">
        times11,
      </if>
      <if test="amount12 != null">
        amount12,
      </if>
      <if test="money12 != null">
        money12,
      </if>
      <if test="times12 != null">
        times12,
      </if>
      <if test="amount13 != null">
        amount13,
      </if>
      <if test="money13 != null">
        money13,
      </if>
      <if test="times13 != null">
        times13,
      </if>
      <if test="amount14 != null">
        amount14,
      </if>
      <if test="money14 != null">
        money14,
      </if>
      <if test="times14 != null">
        times14,
      </if>
      <if test="amount15 != null">
        amount15,
      </if>
      <if test="money15 != null">
        money15,
      </if>
      <if test="times15 != null">
        times15,
      </if>
      <if test="amount16 != null">
        amount16,
      </if>
      <if test="money16 != null">
        money16,
      </if>
      <if test="times16 != null">
        times16,
      </if>
      <if test="amount17 != null">
        amount17,
      </if>
      <if test="money17 != null">
        money17,
      </if>
      <if test="times17 != null">
        times17,
      </if>
      <if test="amount18 != null">
        amount18,
      </if>
      <if test="money18 != null">
        money18,
      </if>
      <if test="times18 != null">
        times18,
      </if>
      <if test="amount19 != null">
        amount19,
      </if>
      <if test="money19 != null">
        money19,
      </if>
      <if test="times19 != null">
        times19,
      </if>
      <if test="amount20 != null">
        amount20,
      </if>
      <if test="money20 != null">
        money20,
      </if>
      <if test="times20 != null">
        times20,
      </if>
      <if test="amount21 != null">
        amount21,
      </if>
      <if test="money21 != null">
        money21,
      </if>
      <if test="times21 != null">
        times21,
      </if>
      <if test="amount22 != null">
        amount22,
      </if>
      <if test="money22 != null">
        money22,
      </if>
      <if test="times22 != null">
        times22,
      </if>
      <if test="amount23 != null">
        amount23,
      </if>
      <if test="money23 != null">
        money23,
      </if>
      <if test="times23 != null">
        times23,
      </if>
      <if test="amount24 != null">
        amount24,
      </if>
      <if test="money24 != null">
        money24,
      </if>
      <if test="times24 != null">
        times24,
      </if>
      <if test="amount25 != null">
        amount25,
      </if>
      <if test="money25 != null">
        money25,
      </if>
      <if test="times25 != null">
        times25,
      </if>
      <if test="amount26 != null">
        amount26,
      </if>
      <if test="money26 != null">
        money26,
      </if>
      <if test="times26 != null">
        times26,
      </if>
      <if test="amount27 != null">
        amount27,
      </if>
      <if test="money27 != null">
        money27,
      </if>
      <if test="times27 != null">
        times27,
      </if>
      <if test="amount28 != null">
        amount28,
      </if>
      <if test="money28 != null">
        money28,
      </if>
      <if test="times28 != null">
        times28,
      </if>
      <if test="amount29 != null">
        amount29,
      </if>
      <if test="money29 != null">
        money29,
      </if>
      <if test="times29 != null">
        times29,
      </if>
      <if test="amount30 != null">
        amount30,
      </if>
      <if test="money30 != null">
        money30,
      </if>
      <if test="times30 != null">
        times30,
      </if>
      <if test="amount31 != null">
        amount31,
      </if>
      <if test="money31 != null">
        money31,
      </if>
      <if test="times31 != null">
        times31,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=BIGINT},
      </if>
      <if test="clientId != null">
        #{clientId,jdbcType=BIGINT},
      </if>
      <if test="year != null">
        #{year,jdbcType=INTEGER},
      </if>
      <if test="month != null">
        #{month,jdbcType=INTEGER},
      </if>
      <if test="amount1 != null">
        #{amount1,jdbcType=FLOAT},
      </if>
      <if test="money1 != null">
        #{money1,jdbcType=FLOAT},
      </if>
      <if test="times1 != null">
        #{times1,jdbcType=INTEGER},
      </if>
      <if test="amount2 != null">
        #{amount2,jdbcType=FLOAT},
      </if>
      <if test="money2 != null">
        #{money2,jdbcType=FLOAT},
      </if>
      <if test="times2 != null">
        #{times2,jdbcType=INTEGER},
      </if>
      <if test="amount3 != null">
        #{amount3,jdbcType=FLOAT},
      </if>
      <if test="money3 != null">
        #{money3,jdbcType=FLOAT},
      </if>
      <if test="times3 != null">
        #{times3,jdbcType=INTEGER},
      </if>
      <if test="amount4 != null">
        #{amount4,jdbcType=FLOAT},
      </if>
      <if test="money4 != null">
        #{money4,jdbcType=FLOAT},
      </if>
      <if test="times4 != null">
        #{times4,jdbcType=INTEGER},
      </if>
      <if test="amount5 != null">
        #{amount5,jdbcType=FLOAT},
      </if>
      <if test="money5 != null">
        #{money5,jdbcType=FLOAT},
      </if>
      <if test="times5 != null">
        #{times5,jdbcType=INTEGER},
      </if>
      <if test="amount6 != null">
        #{amount6,jdbcType=FLOAT},
      </if>
      <if test="money6 != null">
        #{money6,jdbcType=FLOAT},
      </if>
      <if test="times6 != null">
        #{times6,jdbcType=INTEGER},
      </if>
      <if test="amount7 != null">
        #{amount7,jdbcType=FLOAT},
      </if>
      <if test="money7 != null">
        #{money7,jdbcType=FLOAT},
      </if>
      <if test="times7 != null">
        #{times7,jdbcType=INTEGER},
      </if>
      <if test="amount8 != null">
        #{amount8,jdbcType=FLOAT},
      </if>
      <if test="money8 != null">
        #{money8,jdbcType=FLOAT},
      </if>
      <if test="times8 != null">
        #{times8,jdbcType=INTEGER},
      </if>
      <if test="amount9 != null">
        #{amount9,jdbcType=FLOAT},
      </if>
      <if test="money9 != null">
        #{money9,jdbcType=FLOAT},
      </if>
      <if test="times9 != null">
        #{times9,jdbcType=INTEGER},
      </if>
      <if test="amount10 != null">
        #{amount10,jdbcType=FLOAT},
      </if>
      <if test="money10 != null">
        #{money10,jdbcType=FLOAT},
      </if>
      <if test="times10 != null">
        #{times10,jdbcType=INTEGER},
      </if>
      <if test="amount11 != null">
        #{amount11,jdbcType=FLOAT},
      </if>
      <if test="money11 != null">
        #{money11,jdbcType=FLOAT},
      </if>
      <if test="times11 != null">
        #{times11,jdbcType=INTEGER},
      </if>
      <if test="amount12 != null">
        #{amount12,jdbcType=FLOAT},
      </if>
      <if test="money12 != null">
        #{money12,jdbcType=FLOAT},
      </if>
      <if test="times12 != null">
        #{times12,jdbcType=INTEGER},
      </if>
      <if test="amount13 != null">
        #{amount13,jdbcType=FLOAT},
      </if>
      <if test="money13 != null">
        #{money13,jdbcType=FLOAT},
      </if>
      <if test="times13 != null">
        #{times13,jdbcType=INTEGER},
      </if>
      <if test="amount14 != null">
        #{amount14,jdbcType=FLOAT},
      </if>
      <if test="money14 != null">
        #{money14,jdbcType=FLOAT},
      </if>
      <if test="times14 != null">
        #{times14,jdbcType=INTEGER},
      </if>
      <if test="amount15 != null">
        #{amount15,jdbcType=FLOAT},
      </if>
      <if test="money15 != null">
        #{money15,jdbcType=FLOAT},
      </if>
      <if test="times15 != null">
        #{times15,jdbcType=INTEGER},
      </if>
      <if test="amount16 != null">
        #{amount16,jdbcType=FLOAT},
      </if>
      <if test="money16 != null">
        #{money16,jdbcType=FLOAT},
      </if>
      <if test="times16 != null">
        #{times16,jdbcType=INTEGER},
      </if>
      <if test="amount17 != null">
        #{amount17,jdbcType=FLOAT},
      </if>
      <if test="money17 != null">
        #{money17,jdbcType=FLOAT},
      </if>
      <if test="times17 != null">
        #{times17,jdbcType=INTEGER},
      </if>
      <if test="amount18 != null">
        #{amount18,jdbcType=FLOAT},
      </if>
      <if test="money18 != null">
        #{money18,jdbcType=FLOAT},
      </if>
      <if test="times18 != null">
        #{times18,jdbcType=INTEGER},
      </if>
      <if test="amount19 != null">
        #{amount19,jdbcType=FLOAT},
      </if>
      <if test="money19 != null">
        #{money19,jdbcType=FLOAT},
      </if>
      <if test="times19 != null">
        #{times19,jdbcType=INTEGER},
      </if>
      <if test="amount20 != null">
        #{amount20,jdbcType=FLOAT},
      </if>
      <if test="money20 != null">
        #{money20,jdbcType=FLOAT},
      </if>
      <if test="times20 != null">
        #{times20,jdbcType=INTEGER},
      </if>
      <if test="amount21 != null">
        #{amount21,jdbcType=FLOAT},
      </if>
      <if test="money21 != null">
        #{money21,jdbcType=FLOAT},
      </if>
      <if test="times21 != null">
        #{times21,jdbcType=INTEGER},
      </if>
      <if test="amount22 != null">
        #{amount22,jdbcType=FLOAT},
      </if>
      <if test="money22 != null">
        #{money22,jdbcType=FLOAT},
      </if>
      <if test="times22 != null">
        #{times22,jdbcType=INTEGER},
      </if>
      <if test="amount23 != null">
        #{amount23,jdbcType=FLOAT},
      </if>
      <if test="money23 != null">
        #{money23,jdbcType=FLOAT},
      </if>
      <if test="times23 != null">
        #{times23,jdbcType=INTEGER},
      </if>
      <if test="amount24 != null">
        #{amount24,jdbcType=FLOAT},
      </if>
      <if test="money24 != null">
        #{money24,jdbcType=FLOAT},
      </if>
      <if test="times24 != null">
        #{times24,jdbcType=INTEGER},
      </if>
      <if test="amount25 != null">
        #{amount25,jdbcType=FLOAT},
      </if>
      <if test="money25 != null">
        #{money25,jdbcType=FLOAT},
      </if>
      <if test="times25 != null">
        #{times25,jdbcType=INTEGER},
      </if>
      <if test="amount26 != null">
        #{amount26,jdbcType=FLOAT},
      </if>
      <if test="money26 != null">
        #{money26,jdbcType=FLOAT},
      </if>
      <if test="times26 != null">
        #{times26,jdbcType=INTEGER},
      </if>
      <if test="amount27 != null">
        #{amount27,jdbcType=FLOAT},
      </if>
      <if test="money27 != null">
        #{money27,jdbcType=FLOAT},
      </if>
      <if test="times27 != null">
        #{times27,jdbcType=INTEGER},
      </if>
      <if test="amount28 != null">
        #{amount28,jdbcType=FLOAT},
      </if>
      <if test="money28 != null">
        #{money28,jdbcType=FLOAT},
      </if>
      <if test="times28 != null">
        #{times28,jdbcType=INTEGER},
      </if>
      <if test="amount29 != null">
        #{amount29,jdbcType=FLOAT},
      </if>
      <if test="money29 != null">
        #{money29,jdbcType=FLOAT},
      </if>
      <if test="times29 != null">
        #{times29,jdbcType=INTEGER},
      </if>
      <if test="amount30 != null">
        #{amount30,jdbcType=FLOAT},
      </if>
      <if test="money30 != null">
        #{money30,jdbcType=FLOAT},
      </if>
      <if test="times30 != null">
        #{times30,jdbcType=INTEGER},
      </if>
      <if test="amount31 != null">
        #{amount31,jdbcType=FLOAT},
      </if>
      <if test="money31 != null">
        #{money31,jdbcType=FLOAT},
      </if>
      <if test="times31 != null">
        #{times31,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.dy.pipIrrGlobal.pojoSt.StClientAmountDay">
    <!--@mbg.generated-->
    update st_client_amount_day
    <set>
      <if test="clientId != null">
        client_id = #{clientId,jdbcType=BIGINT},
      </if>
      <if test="year != null">
        `year` = #{year,jdbcType=INTEGER},
      </if>
      <if test="month != null">
        `month` = #{month,jdbcType=INTEGER},
      </if>
      <if test="amount1 != null">
        amount1 = #{amount1,jdbcType=FLOAT},
      </if>
      <if test="money1 != null">
        money1 = #{money1,jdbcType=FLOAT},
      </if>
      <if test="times1 != null">
        times1 = #{times1,jdbcType=INTEGER},
      </if>
      <if test="amount2 != null">
        amount2 = #{amount2,jdbcType=FLOAT},
      </if>
      <if test="money2 != null">
        money2 = #{money2,jdbcType=FLOAT},
      </if>
      <if test="times2 != null">
        times2 = #{times2,jdbcType=INTEGER},
      </if>
      <if test="amount3 != null">
        amount3 = #{amount3,jdbcType=FLOAT},
      </if>
      <if test="money3 != null">
        money3 = #{money3,jdbcType=FLOAT},
      </if>
      <if test="times3 != null">
        times3 = #{times3,jdbcType=INTEGER},
      </if>
      <if test="amount4 != null">
        amount4 = #{amount4,jdbcType=FLOAT},
      </if>
      <if test="money4 != null">
        money4 = #{money4,jdbcType=FLOAT},
      </if>
      <if test="times4 != null">
        times4 = #{times4,jdbcType=INTEGER},
      </if>
      <if test="amount5 != null">
        amount5 = #{amount5,jdbcType=FLOAT},
      </if>
      <if test="money5 != null">
        money5 = #{money5,jdbcType=FLOAT},
      </if>
      <if test="times5 != null">
        times5 = #{times5,jdbcType=INTEGER},
      </if>
      <if test="amount6 != null">
        amount6 = #{amount6,jdbcType=FLOAT},
      </if>
      <if test="money6 != null">
        money6 = #{money6,jdbcType=FLOAT},
      </if>
      <if test="times6 != null">
        times6 = #{times6,jdbcType=INTEGER},
      </if>
      <if test="amount7 != null">
        amount7 = #{amount7,jdbcType=FLOAT},
      </if>
      <if test="money7 != null">
        money7 = #{money7,jdbcType=FLOAT},
      </if>
      <if test="times7 != null">
        times7 = #{times7,jdbcType=INTEGER},
      </if>
      <if test="amount8 != null">
        amount8 = #{amount8,jdbcType=FLOAT},
      </if>
      <if test="money8 != null">
        money8 = #{money8,jdbcType=FLOAT},
      </if>
      <if test="times8 != null">
        times8 = #{times8,jdbcType=INTEGER},
      </if>
      <if test="amount9 != null">
        amount9 = #{amount9,jdbcType=FLOAT},
      </if>
      <if test="money9 != null">
        money9 = #{money9,jdbcType=FLOAT},
      </if>
      <if test="times9 != null">
        times9 = #{times9,jdbcType=INTEGER},
      </if>
      <if test="amount10 != null">
        amount10 = #{amount10,jdbcType=FLOAT},
      </if>
      <if test="money10 != null">
        money10 = #{money10,jdbcType=FLOAT},
      </if>
      <if test="times10 != null">
        times10 = #{times10,jdbcType=INTEGER},
      </if>
      <if test="amount11 != null">
        amount11 = #{amount11,jdbcType=FLOAT},
      </if>
      <if test="money11 != null">
        money11 = #{money11,jdbcType=FLOAT},
      </if>
      <if test="times11 != null">
        times11 = #{times11,jdbcType=INTEGER},
      </if>
      <if test="amount12 != null">
        amount12 = #{amount12,jdbcType=FLOAT},
      </if>
      <if test="money12 != null">
        money12 = #{money12,jdbcType=FLOAT},
      </if>
      <if test="times12 != null">
        times12 = #{times12,jdbcType=INTEGER},
      </if>
      <if test="amount13 != null">
        amount13 = #{amount13,jdbcType=FLOAT},
      </if>
      <if test="money13 != null">
        money13 = #{money13,jdbcType=FLOAT},
      </if>
      <if test="times13 != null">
        times13 = #{times13,jdbcType=INTEGER},
      </if>
      <if test="amount14 != null">
        amount14 = #{amount14,jdbcType=FLOAT},
      </if>
      <if test="money14 != null">
        money14 = #{money14,jdbcType=FLOAT},
      </if>
      <if test="times14 != null">
        times14 = #{times14,jdbcType=INTEGER},
      </if>
      <if test="amount15 != null">
        amount15 = #{amount15,jdbcType=FLOAT},
      </if>
      <if test="money15 != null">
        money15 = #{money15,jdbcType=FLOAT},
      </if>
      <if test="times15 != null">
        times15 = #{times15,jdbcType=INTEGER},
      </if>
      <if test="amount16 != null">
        amount16 = #{amount16,jdbcType=FLOAT},
      </if>
      <if test="money16 != null">
        money16 = #{money16,jdbcType=FLOAT},
      </if>
      <if test="times16 != null">
        times16 = #{times16,jdbcType=INTEGER},
      </if>
      <if test="amount17 != null">
        amount17 = #{amount17,jdbcType=FLOAT},
      </if>
      <if test="money17 != null">
        money17 = #{money17,jdbcType=FLOAT},
      </if>
      <if test="times17 != null">
        times17 = #{times17,jdbcType=INTEGER},
      </if>
      <if test="amount18 != null">
        amount18 = #{amount18,jdbcType=FLOAT},
      </if>
      <if test="money18 != null">
        money18 = #{money18,jdbcType=FLOAT},
      </if>
      <if test="times18 != null">
        times18 = #{times18,jdbcType=INTEGER},
      </if>
      <if test="amount19 != null">
        amount19 = #{amount19,jdbcType=FLOAT},
      </if>
      <if test="money19 != null">
        money19 = #{money19,jdbcType=FLOAT},
      </if>
      <if test="times19 != null">
        times19 = #{times19,jdbcType=INTEGER},
      </if>
      <if test="amount20 != null">
        amount20 = #{amount20,jdbcType=FLOAT},
      </if>
      <if test="money20 != null">
        money20 = #{money20,jdbcType=FLOAT},
      </if>
      <if test="times20 != null">
        times20 = #{times20,jdbcType=INTEGER},
      </if>
      <if test="amount21 != null">
        amount21 = #{amount21,jdbcType=FLOAT},
      </if>
      <if test="money21 != null">
        money21 = #{money21,jdbcType=FLOAT},
      </if>
      <if test="times21 != null">
        times21 = #{times21,jdbcType=INTEGER},
      </if>
      <if test="amount22 != null">
        amount22 = #{amount22,jdbcType=FLOAT},
      </if>
      <if test="money22 != null">
        money22 = #{money22,jdbcType=FLOAT},
      </if>
      <if test="times22 != null">
        times22 = #{times22,jdbcType=INTEGER},
      </if>
      <if test="amount23 != null">
        amount23 = #{amount23,jdbcType=FLOAT},
      </if>
      <if test="money23 != null">
        money23 = #{money23,jdbcType=FLOAT},
      </if>
      <if test="times23 != null">
        times23 = #{times23,jdbcType=INTEGER},
      </if>
      <if test="amount24 != null">
        amount24 = #{amount24,jdbcType=FLOAT},
      </if>
      <if test="money24 != null">
        money24 = #{money24,jdbcType=FLOAT},
      </if>
      <if test="times24 != null">
        times24 = #{times24,jdbcType=INTEGER},
      </if>
      <if test="amount25 != null">
        amount25 = #{amount25,jdbcType=FLOAT},
      </if>
      <if test="money25 != null">
        money25 = #{money25,jdbcType=FLOAT},
      </if>
      <if test="times25 != null">
        times25 = #{times25,jdbcType=INTEGER},
      </if>
      <if test="amount26 != null">
        amount26 = #{amount26,jdbcType=FLOAT},
      </if>
      <if test="money26 != null">
        money26 = #{money26,jdbcType=FLOAT},
      </if>
      <if test="times26 != null">
        times26 = #{times26,jdbcType=INTEGER},
      </if>
      <if test="amount27 != null">
        amount27 = #{amount27,jdbcType=FLOAT},
      </if>
      <if test="money27 != null">
        money27 = #{money27,jdbcType=FLOAT},
      </if>
      <if test="times27 != null">
        times27 = #{times27,jdbcType=INTEGER},
      </if>
      <if test="amount28 != null">
        amount28 = #{amount28,jdbcType=FLOAT},
      </if>
      <if test="money28 != null">
        money28 = #{money28,jdbcType=FLOAT},
      </if>
      <if test="times28 != null">
        times28 = #{times28,jdbcType=INTEGER},
      </if>
      <if test="amount29 != null">
        amount29 = #{amount29,jdbcType=FLOAT},
      </if>
      <if test="money29 != null">
        money29 = #{money29,jdbcType=FLOAT},
      </if>
      <if test="times29 != null">
        times29 = #{times29,jdbcType=INTEGER},
      </if>
      <if test="amount30 != null">
        amount30 = #{amount30,jdbcType=FLOAT},
      </if>
      <if test="money30 != null">
        money30 = #{money30,jdbcType=FLOAT},
      </if>
      <if test="times30 != null">
        times30 = #{times30,jdbcType=INTEGER},
      </if>
      <if test="amount31 != null">
        amount31 = #{amount31,jdbcType=FLOAT},
      </if>
      <if test="money31 != null">
        money31 = #{money31,jdbcType=FLOAT},
      </if>
      <if test="times31 != null">
        times31 = #{times31,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=BIGINT}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.dy.pipIrrGlobal.pojoSt.StClientAmountDay">
    <!--@mbg.generated-->
    update st_client_amount_day
    set client_id = #{clientId,jdbcType=BIGINT},
      `year` = #{year,jdbcType=INTEGER},
      `month` = #{month,jdbcType=INTEGER},
      amount1 = #{amount1,jdbcType=FLOAT},
      money1 = #{money1,jdbcType=FLOAT},
      times1 = #{times1,jdbcType=INTEGER},
      amount2 = #{amount2,jdbcType=FLOAT},
      money2 = #{money2,jdbcType=FLOAT},
      times2 = #{times2,jdbcType=INTEGER},
      amount3 = #{amount3,jdbcType=FLOAT},
      money3 = #{money3,jdbcType=FLOAT},
      times3 = #{times3,jdbcType=INTEGER},
      amount4 = #{amount4,jdbcType=FLOAT},
      money4 = #{money4,jdbcType=FLOAT},
      times4 = #{times4,jdbcType=INTEGER},
      amount5 = #{amount5,jdbcType=FLOAT},
      money5 = #{money5,jdbcType=FLOAT},
      times5 = #{times5,jdbcType=INTEGER},
      amount6 = #{amount6,jdbcType=FLOAT},
      money6 = #{money6,jdbcType=FLOAT},
      times6 = #{times6,jdbcType=INTEGER},
      amount7 = #{amount7,jdbcType=FLOAT},
      money7 = #{money7,jdbcType=FLOAT},
      times7 = #{times7,jdbcType=INTEGER},
      amount8 = #{amount8,jdbcType=FLOAT},
      money8 = #{money8,jdbcType=FLOAT},
      times8 = #{times8,jdbcType=INTEGER},
      amount9 = #{amount9,jdbcType=FLOAT},
      money9 = #{money9,jdbcType=FLOAT},
      times9 = #{times9,jdbcType=INTEGER},
      amount10 = #{amount10,jdbcType=FLOAT},
      money10 = #{money10,jdbcType=FLOAT},
      times10 = #{times10,jdbcType=INTEGER},
      amount11 = #{amount11,jdbcType=FLOAT},
      money11 = #{money11,jdbcType=FLOAT},
      times11 = #{times11,jdbcType=INTEGER},
      amount12 = #{amount12,jdbcType=FLOAT},
      money12 = #{money12,jdbcType=FLOAT},
      times12 = #{times12,jdbcType=INTEGER},
      amount13 = #{amount13,jdbcType=FLOAT},
      money13 = #{money13,jdbcType=FLOAT},
      times13 = #{times13,jdbcType=INTEGER},
      amount14 = #{amount14,jdbcType=FLOAT},
      money14 = #{money14,jdbcType=FLOAT},
      times14 = #{times14,jdbcType=INTEGER},
      amount15 = #{amount15,jdbcType=FLOAT},
      money15 = #{money15,jdbcType=FLOAT},
      times15 = #{times15,jdbcType=INTEGER},
      amount16 = #{amount16,jdbcType=FLOAT},
      money16 = #{money16,jdbcType=FLOAT},
      times16 = #{times16,jdbcType=INTEGER},
      amount17 = #{amount17,jdbcType=FLOAT},
      money17 = #{money17,jdbcType=FLOAT},
      times17 = #{times17,jdbcType=INTEGER},
      amount18 = #{amount18,jdbcType=FLOAT},
      money18 = #{money18,jdbcType=FLOAT},
      times18 = #{times18,jdbcType=INTEGER},
      amount19 = #{amount19,jdbcType=FLOAT},
      money19 = #{money19,jdbcType=FLOAT},
      times19 = #{times19,jdbcType=INTEGER},
      amount20 = #{amount20,jdbcType=FLOAT},
      money20 = #{money20,jdbcType=FLOAT},
      times20 = #{times20,jdbcType=INTEGER},
      amount21 = #{amount21,jdbcType=FLOAT},
      money21 = #{money21,jdbcType=FLOAT},
      times21 = #{times21,jdbcType=INTEGER},
      amount22 = #{amount22,jdbcType=FLOAT},
      money22 = #{money22,jdbcType=FLOAT},
      times22 = #{times22,jdbcType=INTEGER},
      amount23 = #{amount23,jdbcType=FLOAT},
      money23 = #{money23,jdbcType=FLOAT},
      times23 = #{times23,jdbcType=INTEGER},
      amount24 = #{amount24,jdbcType=FLOAT},
      money24 = #{money24,jdbcType=FLOAT},
      times24 = #{times24,jdbcType=INTEGER},
      amount25 = #{amount25,jdbcType=FLOAT},
      money25 = #{money25,jdbcType=FLOAT},
      times25 = #{times25,jdbcType=INTEGER},
      amount26 = #{amount26,jdbcType=FLOAT},
      money26 = #{money26,jdbcType=FLOAT},
      times26 = #{times26,jdbcType=INTEGER},
      amount27 = #{amount27,jdbcType=FLOAT},
      money27 = #{money27,jdbcType=FLOAT},
      times27 = #{times27,jdbcType=INTEGER},
      amount28 = #{amount28,jdbcType=FLOAT},
      money28 = #{money28,jdbcType=FLOAT},
      times28 = #{times28,jdbcType=INTEGER},
      amount29 = #{amount29,jdbcType=FLOAT},
      money29 = #{money29,jdbcType=FLOAT},
      times29 = #{times29,jdbcType=INTEGER},
      amount30 = #{amount30,jdbcType=FLOAT},
      money30 = #{money30,jdbcType=FLOAT},
      times30 = #{times30,jdbcType=INTEGER},
      amount31 = #{amount31,jdbcType=FLOAT},
      money31 = #{money31,jdbcType=FLOAT},
      times31 = #{times31,jdbcType=INTEGER}
    where id = #{id,jdbcType=BIGINT}
  </update>

  <select id="selectByClientIdAndYearAndMonthAndDay" resultType="com.dy.pipIrrGlobal.pojoSt.StClientAmountDay">
    select
    <include refid="Base_Column_List" />
    from st_client_amount_day
    where client_id = #{clientId,jdbcType=BIGINT}
    and year = #{year,jdbcType=INTEGER}
    and month = #{month,jdbcType=INTEGER}
  </select>
</mapper>

 pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/p206V1/TkDealClientAmountDay.java

@@ -40,8 +40,8 @@
        if (cdObj != null && cdObj instanceof DataCd83CloseVo) {
            /*
            åªèƒ½é‡‡ç”¨DataCd83CloseVo来计算农户日用水量的原因：
            1、如果采用DataCd84Vo来计算农户日用水量，必须采用本次累计流量减上次累流量的差值作为阶段农户用水量，
               ç„¶åŽå„个阶段相加，得到本次农户用水量，这个用水量还没加到农户日用水量中，因为只有收不到DataCd83CloseVo
            1、如果采用DataCd84Vo(开阀工作报)来计算农户日用水量，必须采用本次累计流量减上次累流量的差值作为阶段农户用水量，
               ç„¶åŽå„个阶段相加，得到本次农户用水量，这个用水量还没加到农户日用水量中，因为只有收不到DataCd83CloseVo(关阀报)
               ä¸ŠæŠ¥æ•°æ®æ—¶æ‰èƒ½åŠ åˆ°å†œæˆ·ç”¨æ°´é‡ä¸­ï¼Œå¦åˆ™å°±ä¼šé‡å¤è®¡ç®—，但什么时候及能否收到DataCd83CloseVo不可预知。
            2、如果农户有多张IC卡，同时在多个取水口取水，将会是更复杂的计算，许多情形更不可预测，且时间复杂度
               å¿…然很高，这样程序运行时间更长，将会造成上行数据堵塞现象。
@@ -51,7 +51,7 @@
             è¡¥æŠ¥DataCd83CloseVo处理方法：
             é‡‡ç”¨DataCd83CloseVo数据中的关阀时间closeDt计算出农户用水日期，不能用数据接收日期时间作为农户用水日期，
             ä½†è¿™ç§è®¡ç®—方法可能会有重复上报情况发生，即重复计算了，如果要判断重复，必然要增加一个关阀时间数据库表，增加时间
             å¤æ‚度，计算用时将会长，本系统假设只要RTU上报上来数据了，说明当前网络较好，必然能收到下行应答，不会发行重复补报。
             å¤æ‚度，计算用时将会长，本系统假设只要RTU上报上来数据了，说明当前网络较好，必然能收到下行应答，不会发生重复补报。
             */
            Object[] objs = this.getTaskResults(TkPreGenObjs.taskId);
            DbSv sv = (DbSv) objs[0];
@@ -173,6 +173,7 @@
            }else{
                poHistory.money = lastPo.money ;
            }
            poHistory.times = 1 ;
            poHistory.dt = lastPo.dt ;
            poHistory.openDtLast = lastPo.openDtLast ;
            poHistory.closeDtLast = lastPo.closeDtLast ;
@@ -183,6 +184,7 @@
        }else{
            poHistory.amount = cdData.thisAmount ;
            poHistory.money = cdData.thisMoney ;
            poHistory.times = 1 ;
            poHistory.dt = DateTime.dateFrom_yyyy_MM_dd1(cdData.closeDt);//采用关阀日期作为统计日期
            poHistory.openDtLast = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.openDt);
            poHistory.closeDtLast = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.closeDt);
@@ -325,6 +327,11 @@
        }else{
            poHistory.money = cdData.thisMoney ;
        }
        if(poHistory.times != null){
            poHistory.times += 1 ;
        }else{
            poHistory.times = 1 ;
        }
        poHistory.dt = DateTime.dateFrom_yyyy_MM_dd1(cdData.closeDt);//采用关阀日期作为统计日期
        poHistory.openDtLast = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.openDt) ;
        poHistory.closeDtLast = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.closeDt) ;
@@ -334,8 +341,4 @@
        poHistory.rtuDtLast = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.rtuDt) ;
        return poHistory ;
    }




}

 pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StClientAmount.java

@@ -18,8 +18,22 @@

    private Integer statisticsYear;
    private Integer statisticsMonth;
    private Integer statisticsDay;
    private Long statisticsStartId ;
    private Long statisticsEndId ;

    protected void statistics4Day(Integer statisticsYear,
                              Integer statisticsMonth,
                              Integer statisticsDay,
                              Long statisticsStartId,
                              Long statisticsEndId){
        this.statisticsYear = statisticsYear ;
        this.statisticsMonth = statisticsMonth ;
        this.statisticsDay = statisticsDay ;
        this.statisticsStartId = statisticsStartId ;
        this.statisticsEndId = statisticsEndId ;
        this.statisticsDay() ;
    }

    protected void statistics(Integer statisticsYear,
                              Integer statisticsMonth,
@@ -29,11 +43,19 @@
        this.statisticsMonth = statisticsMonth ;
        this.statisticsStartId = statisticsStartId ;
        this.statisticsEndId = statisticsEndId ;
        this.statisticsDay() ;
        this.statisticsMonth() ;
        this.statisticsYear() ;
    }

    /**
     * æ—¥ç»Ÿè®¡---农户
     */
    private void statisticsDay(){
        sv.statisticsDay(statisticsYear, statisticsMonth, statisticsDay, statisticsStartId, statisticsEndId);
    }

    /**
     * æœˆç»Ÿè®¡---农户
     */
    private void statisticsMonth(){

 pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StClientAmountSv.java

@@ -1,11 +1,14 @@
package com.dy.pipIrrStatistics.statistics;

import com.dy.pipIrrGlobal.daoRm.RmClientAmountDayMapper;
import com.dy.pipIrrGlobal.daoSt.StClientAmountDayMapper;
import com.dy.pipIrrGlobal.daoSt.StClientAmountMonthMapper;
import com.dy.pipIrrGlobal.daoSt.StClientAmountYearMapper;
import com.dy.pipIrrGlobal.pojoSt.StClientAmountMonth;
import com.dy.pipIrrGlobal.pojoSt.StClientAmountYear;
import com.dy.pipIrrGlobal.pojoRm.RmClientAmountDay;
import com.dy.pipIrrGlobal.pojoSt.*;
import com.dy.pipIrrGlobal.voRm.VoClientAmountDay;
import com.dy.pipIrrGlobal.voSt.VoClientAmountStatistics;
import com.dy.pipIrrGlobal.voSt.VoClientConsumeStatistics;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;
@@ -24,10 +27,43 @@
    protected RmClientAmountDayMapper rmClientAmountDayDao;

    @Autowired
    protected StClientAmountDayMapper stClientAmountDayDao;

    @Autowired
    protected StClientAmountMonthMapper stClientAmountMonthDao ;

    @Autowired
    protected StClientAmountYearMapper stClientAmountYearDao ;

    /**
     * æ—¥ç»Ÿè®¡---农户用水量及金额，由纵型数据改成行型数据
     */
    @Transactional
    protected void statisticsDay(Integer statisticsYear, Integer statisticsMonth, Integer statisticsDay, Long statisticsStartId, Long statisticsEndId){
        List<VoClientAmountStatistics> list = rmClientAmountDayDao.statisticsByClient(statisticsStartId, statisticsEndId) ;
        if(list != null && list.size() > 0){
            for(VoClientAmountStatistics vo : list){
                List<StClientAmountDay> listOfDay = stClientAmountDayDao.selectByClientIdAndYearAndMonthAndDay(vo.clientId, statisticsYear, statisticsMonth) ;
                StClientAmountDay po = null ;
                if(listOfDay != null && listOfDay.size() > 0){
                    //程序逻辑控制上，集合中只有一个对象
                    po = listOfDay.get(0) ;
                }
                if(po == null){
                    po = new StClientAmountDay() ;
                    po.clientId = vo.clientId ;
                    po.year = statisticsYear ;
                    po.month = statisticsMonth ;
                }
                this.setValueOfDayOfMonth(statisticsDay, vo, po);
                if(po.id == null) {
                    stClientAmountDayDao.insert(po);
                }else{
                    stClientAmountDayDao.updateByPrimaryKeySelective(po) ;
                }
            }
        }
    }

    /**
     * æœˆç»Ÿè®¡---农户用水量及金额
@@ -89,4 +125,191 @@
            }
        }
    }

    private void setValueOfDayOfMonth(Integer statisticsDay, VoClientAmountStatistics vo, StClientAmountDay po){
        switch (statisticsDay) {
            case 1:
                po.amount1 = vo.amount;
                po.times1 = vo.times;
                break;
            case 2:
                po.amount2 = vo.amount;
                po.times2 = vo.times;
                break;
            case 3:
                po.amount3 = vo.amount;
                po.times3 = vo.times;
                break;
            case 4:
                po.amount4 = vo.amount;
                po.times4 = vo.times;
                break;
            case 5:
                po.amount5 = vo.amount;
                po.times5 = vo.times;
                break;
            case 6:
                po.amount6 = vo.amount;
                po.times6 = vo.times;
                break;
            case 7:
                po.amount7 = vo.amount;
                po.times7 = vo.times;
                break;
            case 8:
                po.amount8 = vo.amount;
                po.times8 = vo.times;
                break;
            case 9:
                po.amount9 = vo.amount;
                po.times9 = vo.times;
                break;
            case 10:
                po.amount10 = vo.amount;
                po.times10 = vo.times;
                break;
            case 11:
                po.amount11 = vo.amount;
                po.times11 = vo.times;
                break;
            case 12:
                po.amount12 = vo.amount;
                po.times12 = vo.times;
                break;
            case 13:
                po.amount13 = vo.amount;
                po.times13 = vo.times;
                break;
            case 14:
                po.amount14 = vo.amount;
                po.times14 = vo.times;
                break;
            case 15:
                po.amount15 = vo.amount;
                po.times15 = vo.times;
                break;
            case 16:
                po.amount16 = vo.amount;
                po.times16 = vo.times;
                break;
            case 17:
                po.amount17 = vo.amount;
                po.times17 = vo.times;
                break;
            case 18:
                po.amount18 = vo.amount;
                po.times18 = vo.times;
                break;
            case 19:
                po.amount19 = vo.amount;
                po.times19 = vo.times;
                break;
            case 20:
                po.amount20 = vo.amount;
                po.times20 = vo.times;
                break;
            case 21:
                po.amount21 = vo.amount;
                po.times21 = vo.times;
                break;
            case 22:
                po.amount22 = vo.amount;
                po.times22 = vo.times;
                break;
            case 23:
                po.amount23 = vo.amount;
                po.times23 = vo.times;
                break;
            case 24:
                po.amount24 = vo.amount;
                po.times24 = vo.times;
                break;
            case 25:
                po.amount25 = vo.amount;
                po.times25 = vo.times;
                break;
            case 26:
                po.amount26 = vo.amount;
                po.times26 = vo.times;
                break;
            case 27:
                po.amount27 = vo.amount;
                po.times27 = vo.times;
                break;
            case 28:
                po.amount28 = vo.amount;
                po.times28 = vo.times;
                break;
            case 29:
                po.amount29 = vo.amount;
                po.times29 = vo.times;
                break;
            case 30:
                po.amount30 = vo.amount;
                po.times30 = vo.times;
                break;
            case 31:
                po.amount31 = vo.amount;
                po.times31 = vo.times;
                break;
        }
    }

    private void setValueOfMonthOfYear(Integer statisticsMonth, VoClientConsumeStatistics vo, StConsumeClientMonth po){
        switch (statisticsMonth) {
            case 1:
                po.amount1 = vo.amount;
                po.times1 = vo.times;
                break;
            case 2:
                po.amount2 = vo.amount;
                po.times2 = vo.times;
                break;
            case 3:
                po.amount3 = vo.amount;
                po.times3 = vo.times;
                break;
            case 4:
                po.amount4 = vo.amount;
                po.times4 = vo.times;
                break;
            case 5:
                po.amount5 = vo.amount;
                po.times5 = vo.times;
                break;
            case 6:
                po.amount6 = vo.amount;
                po.times6 = vo.times;
                break;
            case 7:
                po.amount7 = vo.amount;
                po.times7 = vo.times;
                break;
            case 8:
                po.amount8 = vo.amount;
                po.times8 = vo.times;
                break;
            case 9:
                po.amount9 = vo.amount;
                po.times9 = vo.times;
                break;
            case 10:
                po.amount10 = vo.amount;
                po.times10 = vo.times;
                break;
            case 11:
                po.amount11 = vo.amount;
                po.times11 = vo.times;
                break;
            case 12:
                po.amount12 = vo.amount;
                po.times12 = vo.times;
                break;
        }
    }

    private void setValueOfYear(VoClientConsumeStatistics vo, StConsumeClientYear po){
        po.amount = vo.amount;
        po.times = vo.times;
    }
}

 pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/statistics/StatisticsJob.java

@@ -71,8 +71,8 @@
            statisticsYear = yesterdayGrp[0] ;//统计年
            statisticsMonth = yesterdayGrp[1] ;//统计月
            statisticsDay = yesterdayGrp[2] ;//统计日
            statistics4DayStartId = IDLongGenerator.generateOneDayStartId(statisticsYear, statisticsMonth, 1) ;
            statistics4DayEndId = IDLongGenerator.generateOneDayEndId(statisticsYear, statisticsMonth, DateTime.endDayOfMonth(statisticsYear, statisticsMonth)) ;
            statistics4DayStartId = IDLongGenerator.generateOneDayStartId(statisticsYear, statisticsMonth, statisticsDay) ;
            statistics4DayEndId = IDLongGenerator.generateOneDayEndId(statisticsYear, statisticsMonth, statisticsDay) ;
            statistics4DayStartDt = DateTime.startOfDay(statisticsYear, statisticsMonth, statisticsDay) ;
            statistics4DayEndDt = DateTime.endOfDay(statisticsYear, statisticsMonth, statisticsDay) ;
            //统计日的量
@@ -107,6 +107,7 @@
     * ç»Ÿè®¡
     */
    private void doStatisticsDay(){
        stClientAmount.statistics4Day(statisticsYear, statisticsMonth, statisticsDay, statistics4DayStartId, statistics4DayEndId) ;
        stChargeByIc.statistics4Day(statisticsYear, statisticsMonth, statisticsDay, statistics4DayStartId, statistics4DayEndId);
        stChargeByClient.statistics4Day(statisticsYear, statisticsMonth, statisticsDay, statistics4DayStartId, statistics4DayEndId);
        stConsumeByIc.statistics4Day(statisticsYear, statisticsMonth, statisticsDay, statistics4DayStartDt, statistics4DayEndDt);

 pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StClientAmountSv.java

New file
@@ -0,0 +1,284 @@
package com.dy.pipIrrTemp.statistics;

import com.dy.common.util.DateTime;
import com.dy.common.util.IDLongGenerator;
import com.dy.pipIrrGlobal.daoRm.RmClientAmountDayMapper;
import com.dy.pipIrrGlobal.daoSt.StClientAmountDayMapper;
import com.dy.pipIrrGlobal.pojoSt.StClientAmountDay;
import com.dy.pipIrrGlobal.pojoSt.StConsumeClientMonth;
import com.dy.pipIrrGlobal.pojoSt.StConsumeClientYear;
import com.dy.pipIrrGlobal.voSt.VoClientAmountStatistics;
import com.dy.pipIrrGlobal.voSt.VoClientConsumeStatistics;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

/**
 * @Author: liurunyu
 * @Date: 2024/12/28 12:52
 * @Description
 */

@Slf4j
@Service
public class StClientAmountSv {

    @Autowired
    protected RmClientAmountDayMapper rmClientAmountDayDao;

    @Autowired
    protected StClientAmountDayMapper stClientAmountDayDao;

    @Autowired
    private void setDao(RmClientAmountDayMapper dao) {
        this.rmClientAmountDayDao = dao;
    }

    @Autowired
    private void setDao(StClientAmountDayMapper dao) {
        this.stClientAmountDayDao = dao;
    }

    private static final int[][] yearMonthGrp = {{2024, 9}, {2024, 10}, {2024, 11}, {2024, 12}, {2025, 1}, {2025, 2}, {2025, 3}, {2025, 4}};

    /**
     * è½¬å­˜å†œæˆ·æ—¥å–水量，由纵型改为横型
     *
     * @throws Exception
     */
    public void transSaveClientAmountDay() throws Exception {
        Long yesterday = Long.parseLong(DateTime.lastXDay_yyyy_MM_dd(1).replaceAll("-", ""));
        Long atDay = Long.MAX_VALUE ;
        int endDayOfMonth = 0 ;
        for(int[] ym : yearMonthGrp) {
            endDayOfMonth = DateTime.endDayOfMonth(ym[0], ym[1]) ;
            for (int day = 1; day <= endDayOfMonth; day++) {
                atDay = Long.parseLong(ym[0] + "" + (ym[1] < 10?("0" + ym[1]):ym[1]) + "" + (day < 10?("0" + day):day)) ;
                if(atDay <= yesterday) {
                    Long statistics4DayStartId = IDLongGenerator.generateOneDayStartId(ym[0], ym[1], day);
                    Long statistics4DayEndId = IDLongGenerator.generateOneDayEndId(ym[0], ym[1], day);
                    this.statisticsDay(ym[0], ym[1], day, statistics4DayStartId, statistics4DayEndId);
                }
            }
        }
     }


    @Transactional
    protected void statisticsDay(Integer statisticsYear, Integer statisticsMonth, Integer statisticsDay, Long statisticsStartId, Long statisticsEndId){
        List<VoClientAmountStatistics> list = rmClientAmountDayDao.statisticsByClient(statisticsStartId, statisticsEndId) ;
        if(list != null && list.size() > 0){
            for(VoClientAmountStatistics vo : list){
                List<StClientAmountDay> listOfDay = stClientAmountDayDao.selectByClientIdAndYearAndMonthAndDay(vo.clientId, statisticsYear, statisticsMonth) ;
                StClientAmountDay po = null ;
                if(listOfDay != null && listOfDay.size() > 0){
                    //程序逻辑控制上，集合中只有一个对象
                    po = listOfDay.get(0) ;
                }
                if(po == null){
                    po = new StClientAmountDay() ;
                    po.clientId = vo.clientId ;
                    po.year = statisticsYear ;
                    po.month = statisticsMonth ;
                }
                this.setValueOfDayOfMonth(statisticsDay, vo, po);
                if(po.id == null) {
                    stClientAmountDayDao.insert(po);
                }else{
                    stClientAmountDayDao.updateByPrimaryKeySelective(po) ;
                }
            }
        }
    }

    private void setValueOfDayOfMonth(Integer statisticsDay, VoClientAmountStatistics vo, StClientAmountDay po){
        switch (statisticsDay) {
            case 1:
                po.amount1 = vo.amount;
                po.times1 = vo.times;
                break;
            case 2:
                po.amount2 = vo.amount;
                po.times2 = vo.times;
                break;
            case 3:
                po.amount3 = vo.amount;
                po.times3 = vo.times;
                break;
            case 4:
                po.amount4 = vo.amount;
                po.times4 = vo.times;
                break;
            case 5:
                po.amount5 = vo.amount;
                po.times5 = vo.times;
                break;
            case 6:
                po.amount6 = vo.amount;
                po.times6 = vo.times;
                break;
            case 7:
                po.amount7 = vo.amount;
                po.times7 = vo.times;
                break;
            case 8:
                po.amount8 = vo.amount;
                po.times8 = vo.times;
                break;
            case 9:
                po.amount9 = vo.amount;
                po.times9 = vo.times;
                break;
            case 10:
                po.amount10 = vo.amount;
                po.times10 = vo.times;
                break;
            case 11:
                po.amount11 = vo.amount;
                po.times11 = vo.times;
                break;
            case 12:
                po.amount12 = vo.amount;
                po.times12 = vo.times;
                break;
            case 13:
                po.amount13 = vo.amount;
                po.times13 = vo.times;
                break;
            case 14:
                po.amount14 = vo.amount;
                po.times14 = vo.times;
                break;
            case 15:
                po.amount15 = vo.amount;
                po.times15 = vo.times;
                break;
            case 16:
                po.amount16 = vo.amount;
                po.times16 = vo.times;
                break;
            case 17:
                po.amount17 = vo.amount;
                po.times17 = vo.times;
                break;
            case 18:
                po.amount18 = vo.amount;
                po.times18 = vo.times;
                break;
            case 19:
                po.amount19 = vo.amount;
                po.times19 = vo.times;
                break;
            case 20:
                po.amount20 = vo.amount;
                po.times20 = vo.times;
                break;
            case 21:
                po.amount21 = vo.amount;
                po.times21 = vo.times;
                break;
            case 22:
                po.amount22 = vo.amount;
                po.times22 = vo.times;
                break;
            case 23:
                po.amount23 = vo.amount;
                po.times23 = vo.times;
                break;
            case 24:
                po.amount24 = vo.amount;
                po.times24 = vo.times;
                break;
            case 25:
                po.amount25 = vo.amount;
                po.times25 = vo.times;
                break;
            case 26:
                po.amount26 = vo.amount;
                po.times26 = vo.times;
                break;
            case 27:
                po.amount27 = vo.amount;
                po.times27 = vo.times;
                break;
            case 28:
                po.amount28 = vo.amount;
                po.times28 = vo.times;
                break;
            case 29:
                po.amount29 = vo.amount;
                po.times29 = vo.times;
                break;
            case 30:
                po.amount30 = vo.amount;
                po.times30 = vo.times;
                break;
            case 31:
                po.amount31 = vo.amount;
                po.times31 = vo.times;
                break;
        }
    }

    private void setValueOfMonthOfYear(Integer statisticsMonth, VoClientConsumeStatistics vo, StConsumeClientMonth po){
        switch (statisticsMonth) {
            case 1:
                po.amount1 = vo.amount;
                po.times1 = vo.times;
                break;
            case 2:
                po.amount2 = vo.amount;
                po.times2 = vo.times;
                break;
            case 3:
                po.amount3 = vo.amount;
                po.times3 = vo.times;
                break;
            case 4:
                po.amount4 = vo.amount;
                po.times4 = vo.times;
                break;
            case 5:
                po.amount5 = vo.amount;
                po.times5 = vo.times;
                break;
            case 6:
                po.amount6 = vo.amount;
                po.times6 = vo.times;
                break;
            case 7:
                po.amount7 = vo.amount;
                po.times7 = vo.times;
                break;
            case 8:
                po.amount8 = vo.amount;
                po.times8 = vo.times;
                break;
            case 9:
                po.amount9 = vo.amount;
                po.times9 = vo.times;
                break;
            case 10:
                po.amount10 = vo.amount;
                po.times10 = vo.times;
                break;
            case 11:
                po.amount11 = vo.amount;
                po.times11 = vo.times;
                break;
            case 12:
                po.amount12 = vo.amount;
                po.times12 = vo.times;
                break;
        }
    }

    private void setValueOfYear(VoClientConsumeStatistics vo, StConsumeClientYear po){
        po.amount = vo.amount;
        po.times = vo.times;
    }
}


 pipIrr-platform/pipIrr-web/pipIrr-web-temp/src/main/java/com/dy/pipIrrTemp/statistics/StSomeCtrl.java

New file
@@ -0,0 +1,45 @@
package com.dy.pipIrrTemp.statistics;

import com.dy.common.aop.SsoAop;
import com.dy.common.webUtil.BaseResponse;
import com.dy.common.webUtil.BaseResponseUtils;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * @Author: liurunyu
 * @Date: 2024/12/28 13:05
 * @Description
 */
@Slf4j
@RestController
@RequestMapping(path = "stSome")
public class StSomeCtrl {

    private StClientAmountSv stSomeClientAmountSv;

    @Autowired
    private void setSv(StClientAmountSv sv) {
        this.stSomeClientAmountSv = sv;
    }

    ///////////////////////////////////////////
    //
    // å†œæˆ·ç›¸å…³å–水量
    //
    ///////////////////////////////////////////
    /**
     * è½¬å­˜å†œæˆ·æ—¥å–水量，由纵型改为横型
     * @return
     */
    @GetMapping(path = "transSaveClientAmountDay")
    @SsoAop()
    public BaseResponse<Boolean> transSaveClientAmountDay() throws Exception{
        this.stSomeClientAmountSv.transSaveClientAmountDay();
        return BaseResponseUtils.buildSuccess(true);
    }

}

 pipIrr-platform/pipIrr-web/pipIrr-web-temp/˵Ã÷.txt

@@ -18,8 +18,6 @@
6、重新统计取水口年取水量
/temp/chSome/reStatisticsAllIntakeYearAmount



7、修改一些取水口日漏损量统计---因为新安装水量，表底值比较大
/temp/chSome/changeSomeIntakeDayLoss
8、重新统计取水口月漏损量