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; }