From 92fb3070e7b46a1afd7e6b038f45a9fb37d0eaa3 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Fri, 23 Apr 2021 16:20:45 +0800
Subject: [PATCH] 20210423
---
src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java | 12 ++++++++++++
src/main/resources/mapper/system/UserMapper.xml | 18 ++++++++++++++++++
2 files changed, 30 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java b/src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java
index 3acb1f8..7d120c5 100644
--- a/src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java
+++ b/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;
+
}
diff --git a/src/main/resources/mapper/system/UserMapper.xml b/src/main/resources/mapper/system/UserMapper.xml
index 7c0c290..e1b32cf 100644
--- a/src/main/resources/mapper/system/UserMapper.xml
+++ b/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>
--
Gitblit v1.9.1