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

package com.cyksj.model.views;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.cyksj.model.entity.OrderDon;
import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.SearchBean;
import lombok.Getter;
import lombok.Setter;

import java.math.BigDecimal;
import java.util.Date;

/*
 *项目名: netflix
 *文件名: ServiceOrdersDetail
 *创建者: JavaZou
 *创建时间:2022/12/30 15:07
 */
@Getter
@Setter
@SearchBean(tables = "real_goods_order_handle rh left join order_don od on od.id = rh.order_id" +
		" left join goods_don_sku gdk on gdk.id = od.sku_id" +
		" left join goods_don gd on gd.id = gdk.goods_id" +
		" left join user u on u.id = od.user_id")
public class ServiceOrdersDetailView {
	@DbField("gd.id")
	@ExcelIgnore
	private Long goodsId;

	@DbField("gd.title")
	private String goodsName;

	@DbField("gdk.id")
	private Long skuId;

	@DbField("gdk.spec_val")
	private String specVal;

	@DbField("od.money")
	private BigDecimal money;

	@DbField("u.nickname")
	private String nickname;

	@DbField("u.id")
	private Long userId;

	@DbField("od.status")
	@ExcelIgnore
	private OrderDon.Status status;

	/**
	 * 订单标注来源
	 * 用于客服标注订单来源
	 */
	@DbField("rh.label_source")
	private String labelSource;

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

	@DbField("rh.before_service_name")
	@ExcelIgnore
	private String beforeServiceName;

	@DbField("rh.after_service_name")
	@ExcelIgnore
	private String afterServiceName;

	@DbField("rh.created_time")
	@ExcelIgnore
	private Date recordCreatedTime;
}