修改bug以及高龄老人报表基础类

huanghongfa

2021-06-10 e07e4546eb630a7ae6a9216c55a0d997d4a644f3

修改bug以及高龄老人报表基础类

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/PageComEldersAuthHistoryRecordDTO.java

New file
@@ -0,0 +1,100 @@
package com.panzhihua.common.model.dtos.community;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import org.hibernate.validator.constraints.Length;

import javax.validation.constraints.*;
import java.util.Date;
import java.math.BigDecimal;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.google.common.base.CaseFormat;

/**
 * 分页查询表单
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @since 1.0
 * @date 2021-06-10
 * */
@Data
@ApiModel("查询高龄老人认证记录请求参数")
public class PageComEldersAuthHistoryRecordDTO {

    @ApiModelProperty(value = "分页-当前页数,默认：1", example = "1", position = 1)
    private Long pageNum = 1L;

    @ApiModelProperty(value = "分页-每页记录数,默认：10", example = "10", position = 2)
    private Long pageSize = 10L;

    @ApiModelProperty(value = "排序字段, 默认createAt", example = "createAt", position = 3)
    private String sortAttr="createAt";

    @ApiModelProperty(value = "排序方式: asc/desc(默认)", example = "desc", position = 4)
    @Pattern(regexp = "asc|desc|ASC|DESC")
    private String sortType="desc";

    @ApiModelProperty(value = "排序列", example = "create_at", hidden = true)
    public String getSortColumns(){
        String dbColumn = CaseFormat.LOWER_CAMEL.to(CaseFormat.LOWER_UNDERSCORE, sortAttr);
        return dbColumn;
    }


    @Max(9223372036854775807L)
    @ApiModelProperty(value = "主键id", hidden = false, example = "1")
    private Long id;


    @Max(9223372036854775807L)
    @ApiModelProperty(value = "老人用户id", hidden = false, example = "1")
    private Long userId;


    @Length(max=50)
    @ApiModelProperty(value = "名称", hidden = false, example = "")
    private String name;


    @Length(max=50)
    @ApiModelProperty(value = "身份证号码", hidden = false, example = "")
    private String idCard;


    @Length(max=50)
    @ApiModelProperty(value = "出生年月", hidden = false, example = "")
    private String brithday;


    @Max(9999999999L)
    @ApiModelProperty(value = "年龄", hidden = false, example = "1")
    private Integer age;


    @Length(max=50)
    @ApiModelProperty(value = "户籍地", hidden = false, example = "")
    private String domicile;


    @Max(127)
    @ApiModelProperty(value = "本月是否已认证（1.是 2.否）", hidden = false, example = "1")
    private Integer isAuth;


    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @ApiModelProperty(value = "创建时间-开始时间", hidden = false, example = "2021-05-01 18:05:50")
    private Date createAtBegin;
    @ApiModelProperty(value = "创建时间-结束时间", hidden = false, example = "2021-05-01 18:05:50")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createAtEnd;


    @ApiModelProperty(value = "(当前操作)用户ID", hidden = true, example = "1")
    private Long operUserId;
    @ApiModelProperty(value = "(当前操作)用户名称", hidden = true, example = "张三")
    private String operUserName;

}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/PageComEldersAuthStatisticsDTO.java

New file
@@ -0,0 +1,90 @@
package com.panzhihua.common.model.dtos.community;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import org.hibernate.validator.constraints.Length;

import javax.validation.constraints.*;
import java.util.Date;
import java.math.BigDecimal;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.google.common.base.CaseFormat;

/**
 * 分页查询表单
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @since 1.0
 * @date 2021-06-10
 * */
@Data
@ApiModel("查询老人认证月统计请求参数")
public class PageComEldersAuthStatisticsDTO {

    @ApiModelProperty(value = "分页-当前页数,默认：1", example = "1", position = 1)
    private Long pageNum = 1L;

    @ApiModelProperty(value = "分页-每页记录数,默认：10", example = "10", position = 2)
    private Long pageSize = 10L;

    @ApiModelProperty(value = "排序字段, 默认createAt", example = "createAt", position = 3)
    private String sortAttr="createAt";

    @ApiModelProperty(value = "排序方式: asc/desc(默认)", example = "desc", position = 4)
    @Pattern(regexp = "asc|desc|ASC|DESC")
    private String sortType="desc";

    @ApiModelProperty(value = "排序列", example = "create_at", hidden = true)
    public String getSortColumns(){
        String dbColumn = CaseFormat.LOWER_CAMEL.to(CaseFormat.LOWER_UNDERSCORE, sortAttr);
        return dbColumn;
    }


    @Max(9223372036854775807L)
    @ApiModelProperty(value = "主键id", hidden = false, example = "1")
    private Long id;


    @Max(9999999999L)
    @ApiModelProperty(value = "年份", hidden = false, example = "1")
    private Integer year;


    @Max(9999999999L)
    @ApiModelProperty(value = "月份", hidden = false, example = "1")
    private Integer month;


    @Max(9999999999L)
    @ApiModelProperty(value = "总人数", hidden = false, example = "1")
    private Integer sum;


    @Max(9999999999L)
    @ApiModelProperty(value = "认证人数", hidden = false, example = "1")
    private Integer authSum;


    @Max(9999999999L)
    @ApiModelProperty(value = "未认证人数", hidden = false, example = "1")
    private Integer noAuthSum;


    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @ApiModelProperty(value = "创建时间-开始时间", hidden = false, example = "2021-05-01 18:05:50")
    private Date createAtBegin;
    @ApiModelProperty(value = "创建时间-结束时间", hidden = false, example = "2021-05-01 18:05:50")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createAtEnd;


    @ApiModelProperty(value = "(当前操作)用户ID", hidden = true, example = "1")
    private Long operUserId;
    @ApiModelProperty(value = "(当前操作)用户名称", hidden = true, example = "张三")
    private String operUserName;

}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComEldersAuthHistoryRecordDetailsVO.java

New file
@@ -0,0 +1,51 @@
package com.panzhihua.common.model.vos.community;

import java.util.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import java.math.BigDecimal;

import com.fasterxml.jackson.annotation.JsonFormat;

/**
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @since 1.0
 * @date 2021-06-10
 * */
@Data
@ApiModel("高龄老人认证记录详细返回参数")
public class ComEldersAuthHistoryRecordDetailsVO {

    @ApiModelProperty(value = "主键id")
    private Long id;

    @ApiModelProperty(value = "老人用户id")
    private Long userId;

    @ApiModelProperty(value = "名称")
    private String name;

    @ApiModelProperty(value = "身份证号码")
    private String idCard;

    @ApiModelProperty(value = "出生年月")
    private String brithday;

    @ApiModelProperty(value = "年龄")
    private Integer age;

    @ApiModelProperty(value = "户籍地")
    private String domicile;

    @ApiModelProperty(value = "本月是否已认证（1.是 2.否）")
    private Integer isAuth;

    @ApiModelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createAt;


}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComEldersAuthHistoryRecordVO.java

New file
@@ -0,0 +1,51 @@
package com.panzhihua.common.model.vos.community;

import java.util.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import java.math.BigDecimal;

import com.fasterxml.jackson.annotation.JsonFormat;

/**
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @since 1.0
 * @date 2021-06-10
 * */
@Data
@ApiModel("高龄老人认证记录返回参数")
public class ComEldersAuthHistoryRecordVO {

    @ApiModelProperty(value = "主键id")
    private Long id;

    @ApiModelProperty(value = "老人用户id")
    private Long userId;

    @ApiModelProperty(value = "名称")
    private String name;

    @ApiModelProperty(value = "身份证号码")
    private String idCard;

    @ApiModelProperty(value = "出生年月")
    private String brithday;

    @ApiModelProperty(value = "年龄")
    private Integer age;

    @ApiModelProperty(value = "户籍地")
    private String domicile;

    @ApiModelProperty(value = "本月是否已认证（1.是 2.否）")
    private Integer isAuth;

    @ApiModelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createAt;


}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComEldersAuthStatisticsDetailsVO.java

New file
@@ -0,0 +1,45 @@
package com.panzhihua.common.model.vos.community;

import java.util.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import java.math.BigDecimal;

import com.fasterxml.jackson.annotation.JsonFormat;

/**
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @since 1.0
 * @date 2021-06-10
 * */
@Data
@ApiModel("老人认证月统计详细返回参数")
public class ComEldersAuthStatisticsDetailsVO {

    @ApiModelProperty(value = "主键id")
    private Long id;

    @ApiModelProperty(value = "年份")
    private Integer year;

    @ApiModelProperty(value = "月份")
    private Integer month;

    @ApiModelProperty(value = "总人数")
    private Integer sum;

    @ApiModelProperty(value = "认证人数")
    private Integer authSum;

    @ApiModelProperty(value = "未认证人数")
    private Integer noAuthSum;

    @ApiModelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createAt;


}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComEldersAuthStatisticsVO.java

New file
@@ -0,0 +1,45 @@
package com.panzhihua.common.model.vos.community;

import java.util.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import java.math.BigDecimal;

import com.fasterxml.jackson.annotation.JsonFormat;

/**
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @since 1.0
 * @date 2021-06-10
 * */
@Data
@ApiModel("老人认证月统计返回参数")
public class ComEldersAuthStatisticsVO {

    @ApiModelProperty(value = "主键id")
    private Long id;

    @ApiModelProperty(value = "年份")
    private Integer year;

    @ApiModelProperty(value = "月份")
    private Integer month;

    @ApiModelProperty(value = "总人数")
    private Integer sum;

    @ApiModelProperty(value = "认证人数")
    private Integer authSum;

    @ApiModelProperty(value = "未认证人数")
    private Integer noAuthSum;

    @ApiModelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createAt;


}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/EldersAuthElderlyApi.java

@@ -74,6 +74,7 @@
     * @param id
     * @return
     */
    @PostMapping("/delete")
    R deleteEldersAuthElderly(@RequestParam("id") Long id){
        return comEldersAuthElderlyService.deleteEldersAuthElderly(id);
    }

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComEldersAuthHistoryRecordMapper.java

New file
@@ -0,0 +1,31 @@
package com.panzhihua.service_community.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.dtos.community.PageComEldersAuthHistoryRecordDTO;
import com.panzhihua.service_community.model.dos.ComEldersAuthHistoryRecordDO;
import com.panzhihua.common.model.vos.community.ComEldersAuthHistoryRecordVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * DAO
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @date 2021-06-10
 * @since 1.0
 */
@Mapper
public interface ComEldersAuthHistoryRecordMapper extends BaseMapper<ComEldersAuthHistoryRecordDO> {

    /**
     * 分页查询
     *
     * @param pageComEldersAuthHistoryRecordDTO
     * @return
     */
    IPage<ComEldersAuthHistoryRecordVO> findByPage(Page page, @Param("pageComEldersAuthHistoryRecordDTO") PageComEldersAuthHistoryRecordDTO pageComEldersAuthHistoryRecordDTO);

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComEldersAuthStatisticsMapper.java

New file
@@ -0,0 +1,30 @@
package com.panzhihua.service_community.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.dtos.community.PageComEldersAuthStatisticsDTO;
import com.panzhihua.service_community.model.dos.ComEldersAuthStatisticsDO;
import com.panzhihua.common.model.vos.community.ComEldersAuthStatisticsVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * DAO
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @since 1.0
 * @date 2021-06-10
 * */
@Mapper
public interface ComEldersAuthStatisticsMapper extends BaseMapper<ComEldersAuthStatisticsDO> {

        /**
         * 分页查询
         * @param pageComEldersAuthStatisticsDTO
         * @return
         */
        IPage<ComEldersAuthStatisticsVO> findByPage(Page page, @Param("pageComEldersAuthStatisticsDTO") PageComEldersAuthStatisticsDTO pageComEldersAuthStatisticsDTO);

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComEldersAuthHistoryRecordDO.java

New file
@@ -0,0 +1,66 @@
package com.panzhihua.service_community.model.dos;

import java.util.*;
import com.baomidou.mybatisplus.annotation.*;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;



/**
 * 高龄老人认证记录实体类
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @since 1.0
 * @date 2021-06-10
 * */
@Data
@TableName("com_elders_auth_history_record")
public class ComEldersAuthHistoryRecordDO implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * 主键id   列: id
     */
    @TableId(type = IdType.AUTO)
    private Long id;
    /**
     * 老人用户id   列: user_id
     */
    private Long userId;
    /**
     * 名称   列: name
     */
    private String name;
    /**
     * 身份证号码   列: id_card
     */
    private String idCard;
    /**
     * 出生年月   列: brithday
     */
    private String brithday;
    /**
     * 年龄   列: age
     */
    private Integer age;
    /**
     * 户籍地   列: domicile
     */
    private String domicile;
    /**
     * 本月是否已认证（1.是 2.否）   列: is_auth
     */
    private Integer isAuth;
    /**
     * 创建时间   列: create_at
     */
    @TableField(fill = FieldFill.INSERT)
    private Date createAt;

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComEldersAuthStatisticsDO.java

New file
@@ -0,0 +1,58 @@
package com.panzhihua.service_community.model.dos;

import java.util.*;
import com.baomidou.mybatisplus.annotation.*;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;



/**
 * 老人认证月统计实体类
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @since 1.0
 * @date 2021-06-10
 * */
@Data
@TableName("com_elders_auth_statistics")
public class ComEldersAuthStatisticsDO implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * 主键id   列: id
     */
    @TableId(type = IdType.AUTO)
    private Long id;
    /**
     * 年份   列: year
     */
    private Integer year;
    /**
     * 月份   列: month
     */
    private Integer month;
    /**
     * 总人数   列: sum
     */
    private Integer sum;
    /**
     * 认证人数   列: auth_sum
     */
    private Integer authSum;
    /**
     * 未认证人数   列: no_auth_sum
     */
    private Integer noAuthSum;
    /**
     * 创建时间   列: create_at
     */
    @TableField(fill = FieldFill.INSERT)
    private Date createAt;

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/EldersAuthServiceImpl.java

@@ -373,6 +373,7 @@
        }
        return R.fail();
    }

    @Override
    public R pageQueryEldersAuthRecord(PageEldersAuthRecordDTO pageEldersAuthElderlyDTO) {
        Page page = new Page();
@@ -380,7 +381,6 @@
        page.setSize(pageEldersAuthElderlyDTO.getPageSize());
        return R.ok(eldersAuthDAO.selectCommunityEldersRecordByPage(page, pageEldersAuthElderlyDTO));
    }

    @Override
    public R setCommunityAuthType(Long communityId, Integer type) {
        List<SysConfDO> authConf =

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComEldersAuthHistoryRecordMapper.xml

New file
@@ -0,0 +1,67 @@
<?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.panzhihua.service_community.dao.ComEldersAuthHistoryRecordMapper">

     <resultMap id="baseResult" type="com.panzhihua.service_community.model.dos.ComEldersAuthHistoryRecordDO">
        <result property="id" column="id"/>
        <result property="userId" column="user_id"/>
        <result property="name" column="name"/>
        <result property="idCard" column="id_card"/>
        <result property="brithday" column="brithday"/>
        <result property="age" column="age"/>
        <result property="domicile" column="domicile"/>
        <result property="isAuth" column="is_auth"/>
        <result property="createAt" column="create_at"/>
    </resultMap>

    <sql id="columns">
    <![CDATA[
        id,user_id,name,id_card,brithday,age,domicile,is_auth,create_at
    ]]>
    </sql>

    <!-- 分页查询 -->
    <select id="findByPage" resultType="com.panzhihua.common.model.vos.community.ComEldersAuthHistoryRecordVO"
        parameterType="com.panzhihua.common.model.dtos.community.PageComEldersAuthHistoryRecordDTO">
        SELECT <include refid="columns" />
        FROM com_elders_auth_history_record
        <where>
           <if test="pageComEldersAuthHistoryRecordDTO.id!=null">
                AND id = #{pageComEldersAuthHistoryRecordDTO.id}
            </if>
           <if test="pageComEldersAuthHistoryRecordDTO.userId!=null">
                AND user_id = #{pageComEldersAuthHistoryRecordDTO.userId}
            </if>
           <if test="pageComEldersAuthHistoryRecordDTO.name!=null">
                AND name = #{pageComEldersAuthHistoryRecordDTO.name}
            </if>
           <if test="pageComEldersAuthHistoryRecordDTO.idCard!=null">
                AND id_card = #{pageComEldersAuthHistoryRecordDTO.idCard}
            </if>
           <if test="pageComEldersAuthHistoryRecordDTO.brithday!=null">
                AND brithday = #{pageComEldersAuthHistoryRecordDTO.brithday}
            </if>
           <if test="pageComEldersAuthHistoryRecordDTO.age!=null">
                AND age = #{pageComEldersAuthHistoryRecordDTO.age}
            </if>
           <if test="pageComEldersAuthHistoryRecordDTO.domicile!=null">
                AND domicile = #{pageComEldersAuthHistoryRecordDTO.domicile}
            </if>
           <if test="pageComEldersAuthHistoryRecordDTO.isAuth!=null">
                AND is_auth = #{pageComEldersAuthHistoryRecordDTO.isAuth}
            </if>
           <if test="pageComEldersAuthHistoryRecordDTO.createAtBegin!=null">
                AND create_at &gt;= #{pageComEldersAuthHistoryRecordDTO.createAtBegin}
           </if>
           <if test="pageComEldersAuthHistoryRecordDTO.createAtEnd!=null">
                AND create_at &lt;= #{pageComEldersAuthHistoryRecordDTO.createAtEnd}
           </if>
        </where>
        <if test="pageComEldersAuthHistoryRecordDTO.sortColumns!=null">
            ORDER BY ${pageComEldersAuthHistoryRecordDTO.sortColumns} ${pageComEldersAuthHistoryRecordDTO.sortType}
        </if>
    </select>

</mapper>

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComEldersAuthStatisticsMapper.xml

New file
@@ -0,0 +1,59 @@
<?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.panzhihua.service_community.dao.ComEldersAuthStatisticsMapper">

     <resultMap id="baseResult" type="com.panzhihua.service_community.model.dos.ComEldersAuthStatisticsDO">
        <result property="id" column="id"/>
        <result property="year" column="year"/>
        <result property="month" column="month"/>
        <result property="sum" column="sum"/>
        <result property="authSum" column="auth_sum"/>
        <result property="noAuthSum" column="no_auth_sum"/>
        <result property="createAt" column="create_at"/>
    </resultMap>

    <sql id="columns">
    <![CDATA[
        id,year,month,sum,auth_sum,no_auth_sum,create_at
    ]]>
    </sql>

    <!-- 分页查询 -->
    <select id="findByPage" resultType="com.panzhihua.common.model.vos.community.ComEldersAuthStatisticsVO"
        parameterType="com.panzhihua.common.model.dtos.community.PageComEldersAuthStatisticsDTO">
        SELECT <include refid="columns" />
        FROM com_elders_auth_statistics
        <where>
           <if test="pageComEldersAuthStatisticsDTO.id!=null">
                AND id = #{pageComEldersAuthStatisticsDTO.id}
            </if>
           <if test="pageComEldersAuthStatisticsDTO.year!=null">
                AND year = #{pageComEldersAuthStatisticsDTO.year}
            </if>
           <if test="pageComEldersAuthStatisticsDTO.month!=null">
                AND month = #{pageComEldersAuthStatisticsDTO.month}
            </if>
           <if test="pageComEldersAuthStatisticsDTO.sum!=null">
                AND sum = #{pageComEldersAuthStatisticsDTO.sum}
            </if>
           <if test="pageComEldersAuthStatisticsDTO.authSum!=null">
                AND auth_sum = #{pageComEldersAuthStatisticsDTO.authSum}
            </if>
           <if test="pageComEldersAuthStatisticsDTO.noAuthSum!=null">
                AND no_auth_sum = #{pageComEldersAuthStatisticsDTO.noAuthSum}
            </if>
           <if test="pageComEldersAuthStatisticsDTO.createAtBegin!=null">
                AND create_at &gt;= #{pageComEldersAuthStatisticsDTO.createAtBegin}
           </if>
           <if test="pageComEldersAuthStatisticsDTO.createAtEnd!=null">
                AND create_at &lt;= #{pageComEldersAuthStatisticsDTO.createAtEnd}
           </if>
        </where>
        <if test="pageComEldersAuthStatisticsDTO.sortColumns!=null">
            ORDER BY ${pageComEldersAuthStatisticsDTO.sortColumns} ${pageComEldersAuthStatisticsDTO.sortType}
        </if>
    </select>

</mapper>