package com.cyksj.model.manage.views; import com.cyksj.model.entity.OrderMasterDon; import com.ejlchina.searcher.bean.DbField; import com.ejlchina.searcher.bean.DbIgnore; import com.ejlchina.searcher.bean.SearchBean; import lombok.Getter; import lombok.Setter; import java.math.BigDecimal; import java.util.Date; import java.util.List; /** * 项目名: yhlxj * 文件名: OrderMasterDonBackView * 创建者: JavaZou * 创建时间:2023/10/16 11:30 */ @Getter @Setter @SearchBean(tables = "order_master_don o" + " left join user u on o.user_id = u.id" + " left join order_don_transport odt on odt.order_id = o.id", where = ":condition:" ) public class OrderMasterDonBackView { @DbField("o.id") private Long mOid; @DbIgnore private String channel; /** * 是否是额外硬塞的虚拟车票订单 */ @DbField("o.is_ot") private Boolean isOt; @DbField("o.order_no") private String orderNo; @DbField("o.transaction_id") private String transactionId; @DbField("o.user_id") private Long userId; @DbField("u.nickname") private String nickname; @DbField("case when u.login_phone != '' then 'phone' when u.email != '' then 'email' when u.open_id != '' then 'wechat' else 'wechat' end") private String register; /** * 登录注册手机号 */ @DbField("u.login_phone") private String loginPhone; /** * 登录注册邮箱 */ @DbField("u.email") private String email; @DbField("u.is_google") private Boolean isGoogle; @DbField("o.money") private BigDecimal money; @DbField("o.refund_money") private BigDecimal refundMoney; @DbField("o.status") private OrderMasterDon.Status status; @DbField("o.type") private OrderMasterDon.Type type; @DbField("o.order_type") private Integer orderType; @DbField("o.num") private Integer num; @DbField("o.created_time") private Date createdTime; @DbField("o.popularize_id") private Long popularizeId; @DbField("o.pay_time") private Date payTime; @DbField("o.is_dp") private Boolean isDp; @DbField("o.pay_title") private String payTitle; /** * 收货人 */ @DbField("odt.receiver") private String receiver; /** * 手机号 */ @DbField("odt.phone") private String phone; /** * 省份 */ @DbField("odt.province") private String province; /** * 城市 */ @DbField("odt.city") private String city; /** * 区/县 */ @DbField("odt.district") private String district; /** * 详细地址 */ @DbField("odt.address") private String address; @DbIgnore private List orderDonViews; }