yhlxj/netflix-dao/src/main/java/com/cyksj/model/views/GoodsDonQaFrontView.java

package com.cyksj.model.views;

import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.SearchBean;
import lombok.Getter;
import lombok.Setter;

/**
 * 项目名: yhlxj2
 * 文件名: GoodsDonQaFrontView
 * 创建者: JavaZou
 * 创建时间:2024/5/27 11:07
 */
@Getter
@Setter
@SearchBean(tables = "goods_don_qa_relate gr inner join goods_don_qa ga on ga.id = gr.question_id" +
		" inner join goods_don g on g.id = gr.goods_id",
		where = "ga.status is true and ga.deleted is true and g.status is true :p:",
		orderBy = "ga.sorted asc,ga.update_time desc")
public class GoodsDonQaFrontView {
	@DbField("ga.id")
	private Long id;

	@DbField("ga.problem")
	private String problem;

	@DbField("ga.type")
	private Integer type;

	@DbField("gr.goods_id")
	private Long goodsId;

	@DbField("g.title")
	private String title;

	@DbField("ga.content")
	private String content;

	@DbField("ga.url")
	private String url;
}