package com.yeshi.fanli.entity.jd;
|
|
import java.math.BigDecimal;
|
import java.util.Date;
|
|
import org.yeshi.utils.mybatis.Column;
|
import org.yeshi.utils.mybatis.Table;
|
|
@Table("yeshi_ec_jd_order_item")
|
public class JDOrderItem {
|
// 子订单维度
|
@Column(name = "joi_id")
|
private Long id;
|
|
@Column(name = "joi_order_id")
|
private Long orderId;
|
|
@Column(name = "joi_actual_cos_price")
|
private BigDecimal actualCosPrice;// 实际计算佣金的金额。订单完成后，会将误扣除的运费券金额更正。如订单完成后发生退款，此金额会更新。
|
|
@Column(name = "joi_actual_fee")
|
private BigDecimal actualFee;// 推客获得的实际佣金（实际计佣金额*佣金比例*最终比例）。如订单完成后发生退款，此金额会更新。
|
|
@Column(name = "joi_commission_rate")
|
private BigDecimal commissionRate;// 佣金比例
|
|
@Column(name = "joi_estimate_cos_price")
|
private BigDecimal estimateCosPrice;// 预估计佣金额
|
|
@Column(name = "joi_estimate_fee")
|
private BigDecimal estimateFee;// 推客的预估佣金（预估计佣金额*佣金比例*最终比例），如订单完成前发生退款，此金额不会更新。
|
|
@Column(name = "joi_final_rate")
|
private BigDecimal finalRate;// 最终比例（分成比例+补贴比例）
|
|
@Column(name = "joi_cid1")
|
private Long cid1;// 一级类目ID
|
|
@Column(name = "joi_frozen_sku_num")
|
private Long frozenSkuNum;// 商品售后中数量
|
|
@Column(name = "joi_pid")
|
private String pid;// 联盟子站长身份标识，格式：子站长ID_子站长网站ID_子站长推广位ID
|
|
@Column(name = "joi_position_id")
|
private Long positionId;// 推广位ID,0代表无推广位
|
|
@Column(name = "joi_price")
|
private BigDecimal price;// 商品单价
|
|
@Column(name = "joi_cid2")
|
private Long cid2;// 二级类目ID
|
|
@Column(name = "joi_site_id")
|
private Long siteId;// 网站ID，0：无网站
|
|
@Column(name = "joi_sku_id")
|
private Long skuId;// 商品ID
|
|
@Column(name = "joi_sku_name")
|
private String skuName;// 商品名称
|
|
@Column(name = "joi_sku_num")
|
private Long skuNum;// 商品数量
|
|
@Column(name = "joi_sku_return_num")
|
private Long skuReturnNum;// 商品已退货数量
|
|
@Column(name = "joi_sub_side_rate")
|
private BigDecimal subSideRate;// 分成比例
|
|
@Column(name = "joi_sub_sidy_rate")
|
private BigDecimal subsidyRate;// 补贴比例
|
|
@Column(name = "joi_cid3")
|
private Long cid3;// 三级类目ID
|
|
@Column(name = "joi_union_alias")
|
private String unionAlias;// PID所属母账号平台名称（原第三方服务商来源）
|
|
@Column(name = "joi_union_tag")
|
private String unionTag;// 联盟标签数据（整型的二进制字符串(32位)，目前只返回8位：00000001。数据从右向左进行，每一位为1表示符合联盟的标签特征，第1位：京喜红包，第2位：组合推广订单，第3位：拼购订单，第5位：有效首次购订单（00011XXX表示有效首购，最终奖励活动结算金额会结合订单状态判断，以联盟后台对应活动效果数据报表https://union.jd.com/active为准）。例如：00000001:京喜红包订单，00000010:组合推广订单，00000100:拼购订单，00011000:有效首购，00000111：京喜红包+组合推广+拼购等）
|
|
@Column(name = "joi_union_traffic_group")
|
private Integer unionTrafficGroup;// 渠道组 1：1号店，其他：京东
|
|
@Column(name = "joi_valid_code")
|
private Integer validCode;// sku维度的有效码（-1：未知,2.无效-拆单,3.无效-取消,4.无效-京东帮帮主订单,5.无效-账号异常,6.无效-赠品类目不返佣,7.无效-校园订单,8.无效-企业订单,9.无效-团购订单,10.无效-开增值税专用发票订单,11.无效-乡村推广员下单,12.无效-自己推广自己下单,13.无效-违规订单,14.无效-来源与备案网址不符,15.待付款,16.已付款,17.已完成,18.已结算（5.9号不再支持结算状态回写展示））注：自2018/7/13起，自己推广自己下单已经允许返佣，故12无效码仅针对历史数据有效
|
|
@Column(name = "joi_sub_union_id")
|
private String subUnionId;// 子联盟ID(需要联系运营开放白名单才能拿到数据)
|
|
@Column(name = "joi_trace_type")
|
private Integer traceType;// 2：同店；3：跨店
|
|
@Column(name = "joi_pay_month")
|
private Integer payMonth;// 订单行维度预估结算时间（格式：yyyyMMdd）
|
// ，0：未结算。订单的预估结算时间仅供参考。账号未通过资质审核或订单发生售后，会影响订单实际结算时间。
|
@Column(name = "joi_pop_id")
|
private Long popId;// 商家ID，订单行维度
|
|
@Column(name = "joi_ext1")
|
private String ext1;// 推客生成推广链接时传入的扩展字段（需要联系运营开放白名单才能拿到数据）。<订单行维度>
|
|
@Column(name = "joi_trade_id")
|
private String tradeId;// 交易ID=orderId+商品ID
|
|
@Column(name = "joi_create_time")
|
private Date createTime;
|
|
@Column(name = "joi_update_time")
|
private Date updateTime;
|
|
@Column(name = "joi_order_by")
|
private Integer orderBy;
|
|
private JDOrder order;// 父订单
|
|
public JDOrder getOrder() {
|
return order;
|
}
|
|
public void setOrder(JDOrder order) {
|
this.order = order;
|
}
|
|
public Long getId() {
|
return id;
|
}
|
|
public void setId(Long id) {
|
this.id = id;
|
}
|
|
public Long getOrderId() {
|
return orderId;
|
}
|
|
public void setOrderId(Long orderId) {
|
this.orderId = orderId;
|
}
|
|
public BigDecimal getActualCosPrice() {
|
return actualCosPrice;
|
}
|
|
public void setActualCosPrice(BigDecimal actualCosPrice) {
|
this.actualCosPrice = actualCosPrice;
|
}
|
|
public BigDecimal getActualFee() {
|
return actualFee;
|
}
|
|
public void setActualFee(BigDecimal actualFee) {
|
this.actualFee = actualFee;
|
}
|
|
public BigDecimal getCommissionRate() {
|
return commissionRate;
|
}
|
|
public void setCommissionRate(BigDecimal commissionRate) {
|
this.commissionRate = commissionRate;
|
}
|
|
public BigDecimal getEstimateCosPrice() {
|
return estimateCosPrice;
|
}
|
|
public void setEstimateCosPrice(BigDecimal estimateCosPrice) {
|
this.estimateCosPrice = estimateCosPrice;
|
}
|
|
public BigDecimal getEstimateFee() {
|
return estimateFee;
|
}
|
|
public void setEstimateFee(BigDecimal estimateFee) {
|
this.estimateFee = estimateFee;
|
}
|
|
public BigDecimal getFinalRate() {
|
return finalRate;
|
}
|
|
public void setFinalRate(BigDecimal finalRate) {
|
this.finalRate = finalRate;
|
}
|
|
public Long getCid1() {
|
return cid1;
|
}
|
|
public void setCid1(Long cid1) {
|
this.cid1 = cid1;
|
}
|
|
public Long getFrozenSkuNum() {
|
return frozenSkuNum;
|
}
|
|
public void setFrozenSkuNum(Long frozenSkuNum) {
|
this.frozenSkuNum = frozenSkuNum;
|
}
|
|
public String getPid() {
|
return pid;
|
}
|
|
public void setPid(String pid) {
|
this.pid = pid;
|
}
|
|
public Long getPositionId() {
|
return positionId;
|
}
|
|
public void setPositionId(Long positionId) {
|
this.positionId = positionId;
|
}
|
|
public BigDecimal getPrice() {
|
return price;
|
}
|
|
public void setPrice(BigDecimal price) {
|
this.price = price;
|
}
|
|
public Long getCid2() {
|
return cid2;
|
}
|
|
public void setCid2(Long cid2) {
|
this.cid2 = cid2;
|
}
|
|
public Long getSiteId() {
|
return siteId;
|
}
|
|
public void setSiteId(Long siteId) {
|
this.siteId = siteId;
|
}
|
|
public Long getSkuId() {
|
return skuId;
|
}
|
|
public void setSkuId(Long skuId) {
|
this.skuId = skuId;
|
}
|
|
public String getSkuName() {
|
return skuName;
|
}
|
|
public void setSkuName(String skuName) {
|
this.skuName = skuName;
|
}
|
|
public Long getSkuNum() {
|
return skuNum;
|
}
|
|
public void setSkuNum(Long skuNum) {
|
this.skuNum = skuNum;
|
}
|
|
public Long getSkuReturnNum() {
|
return skuReturnNum;
|
}
|
|
public void setSkuReturnNum(Long skuReturnNum) {
|
this.skuReturnNum = skuReturnNum;
|
}
|
|
public BigDecimal getSubSideRate() {
|
return subSideRate;
|
}
|
|
public void setSubSideRate(BigDecimal subSideRate) {
|
this.subSideRate = subSideRate;
|
}
|
|
public BigDecimal getSubsidyRate() {
|
return subsidyRate;
|
}
|
|
public void setSubsidyRate(BigDecimal subsidyRate) {
|
this.subsidyRate = subsidyRate;
|
}
|
|
public Long getCid3() {
|
return cid3;
|
}
|
|
public void setCid3(Long cid3) {
|
this.cid3 = cid3;
|
}
|
|
public String getUnionAlias() {
|
return unionAlias;
|
}
|
|
public void setUnionAlias(String unionAlias) {
|
this.unionAlias = unionAlias;
|
}
|
|
public String getUnionTag() {
|
return unionTag;
|
}
|
|
public void setUnionTag(String unionTag) {
|
this.unionTag = unionTag;
|
}
|
|
public Integer getUnionTrafficGroup() {
|
return unionTrafficGroup;
|
}
|
|
public void setUnionTrafficGroup(Integer unionTrafficGroup) {
|
this.unionTrafficGroup = unionTrafficGroup;
|
}
|
|
public Integer getValidCode() {
|
return validCode;
|
}
|
|
public void setValidCode(Integer validCode) {
|
this.validCode = validCode;
|
}
|
|
public String getSubUnionId() {
|
return subUnionId;
|
}
|
|
public void setSubUnionId(String subUnionId) {
|
this.subUnionId = subUnionId;
|
}
|
|
public Integer getTraceType() {
|
return traceType;
|
}
|
|
public void setTraceType(Integer traceType) {
|
this.traceType = traceType;
|
}
|
|
public Integer getPayMonth() {
|
return payMonth;
|
}
|
|
public void setPayMonth(Integer payMonth) {
|
this.payMonth = payMonth;
|
}
|
|
public Long getPopId() {
|
return popId;
|
}
|
|
public void setPopId(Long popId) {
|
this.popId = popId;
|
}
|
|
public String getExt1() {
|
return ext1;
|
}
|
|
public void setExt1(String ext1) {
|
this.ext1 = ext1;
|
}
|
|
public String getTradeId() {
|
return tradeId;
|
}
|
|
public void setTradeId(String tradeId) {
|
this.tradeId = tradeId;
|
}
|
|
public Date getCreateTime() {
|
return createTime;
|
}
|
|
public void setCreateTime(Date createTime) {
|
this.createTime = createTime;
|
}
|
|
public Date getUpdateTime() {
|
return updateTime;
|
}
|
|
public void setUpdateTime(Date updateTime) {
|
this.updateTime = updateTime;
|
}
|
|
public Integer getOrderBy() {
|
return orderBy;
|
}
|
|
public void setOrderBy(Integer orderBy) {
|
this.orderBy = orderBy;
|
}
|
|
}
|
