package com.doumee.dao.business.model; import com.baomidou.mybatisplus.annotation.TableField; import com.doumee.core.annotation.excel.ExcelColumn; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import com.fasterxml.jackson.annotation.JsonFormat; import java.util.Date; import java.math.BigDecimal; import java.util.List; /** * 商品信息表 * @author 江蹄蹄 * @date 2023/03/21 15:48 */ @Data @ApiModel("商品信息表") @TableName("`goods`") public class Goods { @ApiModelProperty(value = "主键", example = "1") @ExcelColumn(name="主键") @TableId(value = "id",type = IdType.AUTO) private Integer id; @ApiModelProperty(value = "创建人编码", example = "1") @ExcelColumn(name="创建人编码") private Integer creator; @ApiModelProperty(value = "创建时间") @ExcelColumn(name="创建时间") private Date createDate; @ApiModelProperty(value = "更新人编码", example = "1") @ExcelColumn(name="更新人编码") private Integer editor; @ApiModelProperty(value = "更新时间") @ExcelColumn(name="更新时间") private Date editDate; @ApiModelProperty(value = "是否删除0否 1是", example = "1") @ExcelColumn(name="是否删除0否 1是") private Integer isdeleted; @ApiModelProperty(value = "备注") @ExcelColumn(name="备注") private String remark; @ApiModelProperty(value = "列表图") @ExcelColumn(name="列表图") private String imgurl; @ApiModelProperty(value = "名称") @ExcelColumn(name="名称") private String name; @ApiModelProperty(value = "商品描述") @ExcelColumn(name="商品描述") private String info; @ApiModelProperty(value = "分类编码(关联labels表)", example = "1") @ExcelColumn(name="分类编码(关联labels表)") private Integer categoryId; @ApiModelProperty(value = "品牌编码(关联labels表)", example = "1") @ExcelColumn(name="品牌编码(关联labels表)") private Integer brandId; @ApiModelProperty(value = "展示价格", example = "1") @ExcelColumn(name="展示价格") private BigDecimal price; @ApiModelProperty(value = "初始销量", example = "1") @ExcelColumn(name="初始销量") private Integer salenum; @ApiModelProperty(value = "商品详情") @ExcelColumn(name="商品详情") private String content; @ApiModelProperty(value = "排序码", example = "1") @ExcelColumn(name="排序码") private Integer sortnum; @ApiModelProperty(value = "总浏览量", example = "1") @ExcelColumn(name="总浏览量") private Integer looknum; @ApiModelProperty(value = "类型 0平台商城 1咖豆商城 2咖啡计划商品", example = "1") @ExcelColumn(name="类型 0平台商城 1咖豆商城 2咖啡计划商品") private Integer type; @ApiModelProperty(value = "状态 0上架 1下架", example = "1") @ExcelColumn(name="状态 0上架 1下架") private Integer status; @ApiModelProperty(value = "是否推荐 0否 1是", example = "1") @ExcelColumn(name="是否推荐 0否 1是") private Integer isrec; @ApiModelProperty(value = "咖豆风味图") @ExcelColumn(name="咖豆风味图") private String styleImg; @ApiModelProperty(value = "商品标签集合,多个用英文逗号隔开") @ExcelColumn(name="商品标签集合,多个用英文逗号隔开") private String labels; @ApiModelProperty(value = "所属专区ID集合,([1],[2])") @ExcelColumn(name="所属专区ID集合,([1],[2])") private String zhuanquIds; @ApiModelProperty(value = "适用品牌ID集合,([1],[2])") @ExcelColumn(name="适用品牌ID集合,([1],[2])") private String brandIds; @ApiModelProperty(value = "适用品牌系列ID集合,([1],[2])") @ExcelColumn(name="适用品牌系列ID集合,([1],[2])") private String serialIds; @ApiModelProperty(value = "一级分类") @ExcelColumn(name="一级分类") private String parentCategoryId; @ApiModelProperty(value = "抵扣比例(0.1%~100%)", example = "1") private BigDecimal deductRata; @ApiModelProperty(value = "sku金额", hidden = true) @TableField(exist = false) private BigDecimal skuPrice; @ApiModelProperty(value = "sku总金额", hidden = true) @TableField(exist = false) private BigDecimal skuAmount; @ApiModelProperty(value = "skuId", hidden = true) @TableField(exist = false) private Integer skuId; @ApiModelProperty(value = "商品轮播图", example = "1") @TableField(exist = false) private List fileList; @ApiModelProperty(value = "文件地址") @TableField(exist = false) private String resourcePath; @ApiModelProperty(value = "子类名称") @TableField(exist = false) private String categoryName; @ApiModelProperty(value = "品牌名称") @TableField(exist = false) private String brandName; @ApiModelProperty(value = "父类名称") @TableField(exist = false) private String parentName; @ApiModelProperty(value = "库存量") @TableField(exist = false) private BigDecimal stockNum; @ApiModelProperty(value = "实际销量") @TableField(exist = false) private BigDecimal salesVolume; @ApiModelProperty(value = "tab切换状态;1全部,2,已售罄,3回收") @TableField(exist = false) private Integer tabStatus; @ApiModelProperty(value = "商品sku信息") @TableField(exist = false) private List skuList; @ApiModelProperty(value = "商品SKU规格组") @TableField(exist = false) private List goodsSkuList; }