package com.doumee.dao.business.model;

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;

/**
 * 交控-线路优化记录信息表
 * @author 江蹄蹄
 * @date 2025/09/28 09:01
 */
@Data
@ApiModel("交控-线路优化记录信息表")
@TableName("`jk_sketch`")
public class JkSketch {

    @ApiModelProperty(value = "主键", example = "1")
    @ExcelColumn(name="主键")
    private Integer id;

    @ApiModelProperty(value = "创建人编码", example = "1")
    @ExcelColumn(name="创建人编码")
    private Integer creator;

    @ApiModelProperty(value = "创建时间")
    @ExcelColumn(name="创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date createDate;

    @ApiModelProperty(value = "更新人编码", example = "1")
    @ExcelColumn(name="更新人编码")
    private Integer editor;

    @ApiModelProperty(value = "更新时间")
    @ExcelColumn(name="更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date editDate;

    @ApiModelProperty(value = "是否删除0否 1是", example = "1")
    @ExcelColumn(name="是否删除0否 1是")
    private Integer isdeleted;

    @ApiModelProperty(value = "备注")
    @ExcelColumn(name="备注")
    private String info;

    @ApiModelProperty(value = "主线路编码（关联category)", example = "1")
    @ExcelColumn(name="主线路编码（关联category)")
    private Integer categoryId;

    @ApiModelProperty(value = "送货量", example = "1")
    @ExcelColumn(name="送货量")
    private Integer totalNum;

    @ApiModelProperty(value = "客户数", example = "1")
    @ExcelColumn(name="客户数")
    private Integer orderNum;

    @ApiModelProperty(value = "状态 0未优化 1优化中 2已优化", example = "1")
    @ExcelColumn(name="状态 0未优化 1优化中 2已优化")
    private Integer status;

    @ApiModelProperty(value = "排序码", example = "1")
    @ExcelColumn(name="排序码")
    private Integer sortnum;

    @ApiModelProperty(value = "日期")
    @ExcelColumn(name="日期")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date dateInfo;

    @ApiModelProperty(value = "优化记录编码(作为key值存redis）")
    @ExcelColumn(name="优化记录编码(作为key值存redis）")
    private String jobId;

}