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

package com.cyksj.model.response;

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

import java.util.Date;

/*
 *项目名: netflix
 *文件名: OrderDonRep
 *创建者: JavaZou
 *创建时间:2023/2/16 14:57
 */
@Getter
@Setter
@SearchBean(tables = "order_don od left join groups_relation gr on gr.id = od.relation_id" +
		" left join groups_trips gt on gt.id = gr.groups_id" +
		" left join account a on a.id = gt.account_id",
		where = ":time: and od.status not in ('close','noPayment','refund')" +
				" and gr.status = 'validity' and gr.expiry_time is not null")
public class OrderDonAccountRep {

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

	/**
	 * 账号id
	 */
	@DbField("a.id")
	private Long accountId;

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

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

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

	/**
	 * 用户昵称
	 */
	@DbIgnore
	private String nickname;

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

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