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

package com.cyksj.model.views;

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

import java.util.Date;

/**
 * 项目名: yhlxj2
 * 文件名: GoodsDonQaView
 * 创建者: JavaZou
 * 创建时间:2024/5/24 16:04
 */
@Getter
@Setter
@SearchBean(tables = "goods_don_qa gq left join goods_don_qa_relate gqr on gqr.question_id = gq.id" +
		" left join goods_don g on g.id = gqr.goods_id",
		where = "gq.deleted is true",
		orderBy = "gq.update_time desc",
		groupBy = "gq.id,gq.type,gq.problem,gq.status,gq.created_time,gq.update_time")
public class GoodsDonQaView {
	@DbField("gq.id")
	private Long id;

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

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

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

	@DbField("gq.status")
	private Boolean status;

	@DbField("gq.sorted")
	private Integer sorted;

	@DbField("gq.created_time")
	private Date createdTime;

	@DbField("gq.update_time")
	private Date updateTime;
}