yhlxj/netflix-dao/src/main/java/com/cyksj/model/response/ExpiredAccountRep.java

package com.cyksj.model.response;

import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.SearchBean;
import com.fasterxml.jackson.annotation.JsonIgnore;
import lombok.Getter;
import lombok.Setter;

import java.util.Date;

/*
 *项目名: netflix
 *文件名: ExpiredAccountRep
 *创建者: JavaZou
 *创建时间:2023/2/16 15:14
 */
@Getter
@Setter
@SearchBean(tables = "groups_relation gr left join groups_trips gt on gt.id = gr.groups_id" +
		" left join account a on a.id = gt.account_id left join user u on u.id = gr.user_id",
		where = "gr.status = 'validity'")
public class ExpiredAccountRep {
	/**
	 * 账号id
	 */
	@DbField("a.id")
	private Long accountId;

	@DbField("a.goods_id")
	@JsonIgnore
	private Long goodsId;

	/**
	 * 账号
	 */
	@DbField("a.account")
	private String account;

	/**
	 * 密码
	 */
	@DbField("a.password")
	private String password;

	/**
	 * 用户id
	 */
	@DbField("gr.user_id")
	@JsonIgnore
	private Long userId;

	/**
	 * 用户昵称
	 */
	@DbField("u.nickname")
	private String nickname;

	/**
	 * 座位位置
	 */
	@DbField("gr.num")
	private Integer num;

	/**
	 * 过期时间
	 */
	@DbField("gr.expiry_time")
	private Date expiredTime;
}