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

package com.cyksj.model.manage.views;

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;

/**
 * @author chan
 * @date 2022/9/27 6:56 PM
 */
@Getter
@Setter
@SearchBean(tables = "order_don o,goods_don g,goods_don_sku sku,platform p,user u"
        ,where = "o.sku_id = sku.id and g.id = sku.id and p.id = g.platform_id and o.user_id = u.id"
)
public class OrderDonView {

    @DbField("o.id")
    private Long id;

    @DbField("o.order_no")
    private String orderNo;

    @DbField("p.title")
    private String platform;

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

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

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

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

    @DbField("o.status")
    private String status;

    @DbField("o.created_time")
    private Date createdTime;
}