src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java | ●●●●● patch | view | raw | blame | history | |
src/main/resources/mapper/system/UserMapper.xml | ●●●●● 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>