package com.dk.mdm.model.vo.sale; import cn.afterturn.easypoi.excel.annotation.Excel; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import com.dk.common.infrastructure.annotaiton.ExportTitle; import com.dk.common.infrastructure.handler.JsonTypeHandler; import com.dk.common.infrastructure.handler.TimestampTypeHandler; import com.dk.common.infrastructure.handler.UuidTypeHandler; import com.dk.common.model.pojo.PageInfo; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.AllArgsConstructor; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.NoArgsConstructor; import lombok.experimental.Accessors; import java.io.Serializable; import java.math.BigDecimal; import java.time.LocalDate; import java.time.LocalDateTime; import java.util.List; /** * 销售订单 */ @Data @AllArgsConstructor @NoArgsConstructor @EqualsAndHashCode(callSuper = true) @Accessors(chain = true) @ExportTitle("销售订单") @TableName(value = "t_psi_order", autoResultMap = true) @ApiModel(value="实体类:销售订单", description="表名:t_psi_order") public class OrderVO extends PageInfo implements Serializable { /* * 数据库字段 */ /** * 销售订单ID */ //@TableId(value = "order_id", type = IdType.AUTO) @ApiModelProperty(value = "销售订单ID") @TableField(typeHandler = UuidTypeHandler.class) private String orderId; /** * 销售订单号 */ @Excel(name = "销售订单号") @ApiModelProperty(value = "销售订单号") private String orderNo; /** * 订单类型 (【系统字典】销售订单) */ @Excel(name = "订单类型 (【系统字典】销售订单)") @ApiModelProperty(value = "订单类型 (【系统字典】销售订单)") private String orderType; /** * 部门 */ @Excel(name = "部门") @ApiModelProperty(value = "部门") @TableField(typeHandler = UuidTypeHandler.class) private String orgId; /** * 员工 */ @Excel(name = "员工") @ApiModelProperty(value = "员工") @TableField(typeHandler = UuidTypeHandler.class) private String staffId; /** * 客户ID */ @Excel(name = "客户ID") @ApiModelProperty(value = "客户ID") @TableField(typeHandler = UuidTypeHandler.class) private String cusId; /** * 行政区划 (a1:省 a2:市 a3:区) */ @Excel(name = "行政区划 (a1:省 a2:市 a3:区)") @ApiModelProperty(value = "行政区划 (a1:省 a2:市 a3:区)") @TableField(typeHandler = JsonTypeHandler.class) private JSONObject addressArea; /** * 小区或POI */ @Excel(name = "小区或POI") @ApiModelProperty(value = "小区或POI") private String addressName; /** * 门牌号 */ @Excel(name = "门牌号") @ApiModelProperty(value = "门牌号") private String addressNo; /** * 地址坐标(gcj02) (LAT:纬度的值 LON:经度的值) */ @Excel(name = "地址坐标(gcj02) (LAT:纬度的值 LON:经度的值)") @ApiModelProperty(value = "地址坐标(gcj02) (LAT:纬度的值 LON:经度的值)") @TableField(typeHandler = JsonTypeHandler.class) private JSONObject addressGcj02; /** * 详细地址 */ @Excel(name = "详细地址") @ApiModelProperty(value = "详细地址") private String addressFull; /** * 联系人 */ @Excel(name = "联系人") @ApiModelProperty(value = "联系人") private String contactName; /** * 联系电话 */ @Excel(name = "联系电话") @ApiModelProperty(value = "联系电话") private String contactPhone; /** * 销售渠道 */ @Excel(name = "销售渠道") @ApiModelProperty(value = "销售渠道") @TableField(typeHandler = UuidTypeHandler.class) private String salesChannel; /** * 送货日期 */ @Excel(name = "送货日期") @ApiModelProperty(value = "送货日期") @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDate deliveryDate; /** * 商品总数量 */ @Excel(name = "商品总数量") @ApiModelProperty(value = "商品总数量") private BigDecimal sumQuantity; /** * 标价合计 */ @Excel(name = "标价合计") @ApiModelProperty(value = "标价合计") private BigDecimal sumStandard; /** * 合计金额 */ @Excel(name = "合计金额") @ApiModelProperty(value = "合计金额") private BigDecimal sumAmount; /** * 销售折扣 (合计金额/标价合计) */ @Excel(name = "销售折扣 (合计金额/标价合计)") @ApiModelProperty(value = "销售折扣 (合计金额/标价合计)") private BigDecimal saleDiscount; /** * 订单状态 (【系统字典】) */ @Excel(name = "订单状态 (【系统字典】)") @ApiModelProperty(value = "订单状态 (【系统字典】)") private String orderStatus; /** * 出库状态 (【系统字典】) */ @Excel(name = "出库状态 (【系统字典】)") @ApiModelProperty(value = "出库状态 (【系统字典】)") private String outStatus; /** * 出库中数量 */ @Excel(name = "出库中数量") @ApiModelProperty(value = "出库中数量") private BigDecimal outingQty; /** * 出库中金额 */ @Excel(name = "出库中金额") @ApiModelProperty(value = "出库中金额") private BigDecimal outingAmt; /** * 已出库数量 */ @Excel(name = "已出库数量") @ApiModelProperty(value = "已出库数量") private BigDecimal outQty; /** * 已出库金额 */ @Excel(name = "已出库金额") @ApiModelProperty(value = "已出库金额") private BigDecimal outAmt; /** * 已出库退货数量 */ @Excel(name = "已出库退货数量") @ApiModelProperty(value = "已出库退货数量") private BigDecimal returnQty; /** * 已出库退货金额 */ @Excel(name = "已出库退货金额") @ApiModelProperty(value = "已出库退货金额") private BigDecimal returnAmt; /** * 应收金额 */ @Excel(name = "应收金额") @ApiModelProperty(value = "应收金额") private BigDecimal amtReceivable; /** * 还款金额 */ @Excel(name = "还款金额") @ApiModelProperty(value = "还款金额") private BigDecimal amtHandle; /** * 剩余应收 */ @Excel(name = "剩余应收") @ApiModelProperty(value = "剩余应收") private BigDecimal amtResidue; /** * 备注 */ @Excel(name = "备注") @ApiModelProperty(value = "备注") private String remarks; /** * 附件 (index(显示顺序)、name(文件名)、path(路径)、type(类型)、time(上传时间)...) */ @Excel(name = "附件 (index(显示顺序)、name(文件名)、path(路径)、type(类型)、time(上传时间)...)") @ApiModelProperty(value = "附件 (index(显示顺序)、name(文件名)、path(路径)、type(类型)、time(上传时间)...)") @TableField(typeHandler = JsonTypeHandler.class) private JSONObject annexPaths; /** * 制单员 */ @Excel(name = "制单员") @ApiModelProperty(value = "制单员") @TableField(typeHandler = UuidTypeHandler.class) private String makeStaff; /** * 制单时间 */ @Excel(name = "制单时间") @ApiModelProperty(value = "制单时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDateTime makeTime; /** * 有效标识 (1:正常 0:停用) */ @Excel(name = "有效标识 (1:正常 0:停用)") @ApiModelProperty(value = "有效标识 (1:正常 0:停用)") private Boolean flgValid; /** * 企业ID */ @Excel(name = "企业ID") @ApiModelProperty(value = "企业ID") private Integer cpId; /** * 创建时间 (触发器自动处理) */ @Excel(name = "创建时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20) @ApiModelProperty(value = "创建时间 (触发器自动处理)") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDateTime opCreateTime; /** * 创建用户 (触发器自动处理) */ @Excel(name = "创建用户 (触发器自动处理)") @ApiModelProperty(value = "创建用户 (触发器自动处理)") @TableField(typeHandler = UuidTypeHandler.class) private String opCreateUserId; /** * 修改时间 (触发器自动处理) */ @Excel(name = "修改时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20) @ApiModelProperty(value = "修改时间 (触发器自动处理)") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDateTime opUpdateTime; /** * 修改用户 (触发器自动处理) */ @Excel(name = "修改用户 (触发器自动处理)") @ApiModelProperty(value = "修改用户 (触发器自动处理)") @TableField(typeHandler = UuidTypeHandler.class) private String opUpdateUserId; /** * 数据操作应用 (触发器自动处理) */ @Excel(name = "数据操作应用 (触发器自动处理)") @ApiModelProperty(value = "数据操作应用 (触发器自动处理)") private String opAppCode; /** * 数据时间戳 (触发器自动处理) */ @Excel(name = "数据时间戳 (触发器自动处理)") @ApiModelProperty(value = "数据时间戳 (触发器自动处理)") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDateTime opTimestamp; /** * 数据操作数据库用户 (触发器自动处理) */ @Excel(name = "数据操作数据库用户 (触发器自动处理)") @ApiModelProperty(value = "数据操作数据库用户 (触发器自动处理)") private String opDbUser; @ApiModelProperty(value = "明细") private List itemList; @ApiModelProperty(value = "删除明细") private List deleteItemList; @ApiModelProperty(value = "客户编号") private String cusCode; @ApiModelProperty(value = "客户名称") private String cusName; @ApiModelProperty(value = "客户电话") private String cusPhone; @ApiModelProperty(value = "客户来源 (【数据字典】)") private String cusFrom; /* * 相关属性 * @TableField(exist = false) */ /* * 关联属性 + 查询条件 * @TableField(exist = false) */ private static final long serialVersionUID = 1L; }