xiaoyong931011
2021-04-23 92fb3070e7b46a1afd7e6b038f45a9fb37d0eaa3
20210423
2 files modified
30 ■■■■■ changed files
src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java 12 ●●●●● patch | view | raw | blame | history
src/main/resources/mapper/system/UserMapper.xml 18 ●●●●● patch | view | raw | blame | history
src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java
@@ -1,5 +1,7 @@
package com.xcong.excoin.modules.agent.pojo;
import com.baomidou.mybatisplus.annotation.TableField;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import javax.validation.constraints.NotBlank;
@@ -91,6 +93,16 @@
    /**
     * 实名状态
     */
    //@TableField(exist = false)
    private Integer certifyStatus;
    private Integer accountType;
    private Integer accountStatus;
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date startTime;
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date endTime;
}
src/main/resources/mapper/system/UserMapper.xml
@@ -186,6 +186,24 @@
                <if test="record.refererId!=null and record.refererId!=''">
                    find_in_set(#{record.refererId}, b.referer_ids)
                </if>
                <if test="record.startTime!=null and record.startTime!=''">
                    and c.create_time >=#{record.startTime}
                </if>
                <if test="record.endTime!=null and record.endTime!=''">
                    and #{record.endTime} >= c.create_time
                </if>
                <if test="record.account!=null and record.account!=''">
                    and (c.phone = #{record.account} or c.email = #{record.account} or c.invite_id=#{record.account})
                </if>
                <if test="record.accountStatus != null and record.accountStatus!=''" >
                    and a.status = #{record.accountStatus}
                </if>
                <if test="record.accountType != null and record.accountType!=''" >
                    and c.account_type = #{record.accountType}
                </if>
                <if test="record.certifyStatus!=null and record.certifyStatus!=''and record.certifyStatus!='6' ">
                    and c.certify_status = #{record.certifyStatus}
                </if>
            </where>
        </if>
    </select>