package com.doumee.dao.business.model; import com.baomidou.mybatisplus.annotation.TableField; import com.doumee.core.annotation.excel.ExcelColumn; import com.doumee.core.tsp.DistanceMapParam; import com.doumee.service.business.third.model.LoginUserModel; 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.math.BigDecimal; import java.util.Date; import java.util.List; import java.util.Map; /** * 交控-线路优化线路客户记录信息表 * @author 江蹄蹄 * @date 2025/09/28 09:01 */ @Data @ApiModel("交控-线路优化线路客户记录信息表") @TableName("`jk_sketch_customer`") public class JkSketchCustomer extends LoginUserModel { @ApiModelProperty(value = "主键", example = "1") @TableId(type = IdType.AUTO) //@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 = "线路编码(关联jk_sketch_line)", example = "1") //@ExcelColumn(name="线路编码(关联jk_sketch_line)") private Integer sketchLineId; @ApiModelProperty(value = "线路优化编码(关联jk_sketch)", example = "1") //@ExcelColumn(name="线路优化编码(关联jk_sketch)") private Integer sketchId; @ApiModelProperty(value = "送货量", example = "1") @ExcelColumn(name="送货量(条)",index =5,width = 10) private BigDecimal totalNum; @ApiModelProperty(value = "订单编码(关联jk_orders)", example = "1") //@ExcelColumn(name="订单编码(关联jk_orders)") private Integer orderId; @ApiModelProperty(value = "客户编码(关联jk_customer)", example = "1") //@ExcelColumn(name="客户编码(关联jk_customer)") private Integer customerId; @ApiModelProperty(value = "排序码", example = "1") //@ExcelColumn(name="排序码") private Integer sortnum; @ApiModelProperty(value = "日期") @ExcelColumn(name="送货日期",index = 6,width = 10) @JsonFormat(pattern = "yyyy-MM-dd") private Date dateInfo; @ApiModelProperty(value = "客户编码", example = "1") @ExcelColumn(name="客户编码",index = 1,width = 10) @TableField(exist = false) private String code; @ApiModelProperty(value = "客户姓名", example = "1") @ExcelColumn(name="客户姓名",index = 2,width = 10) @TableField(exist = false) private String name; @ApiModelProperty(value = "线路名称", example = "1") @ExcelColumn(name="线路",index = 4,width = 10) @TableField(exist = false) private String lineName; @ApiModelProperty(value = "所属主线路", example = "1") @ExcelColumn(name="所属主线路",index = 3,width = 10) @TableField(exist = false) private String categoryName; @ApiModelProperty(value = "所属主线路编码", example = "1") //@ExcelColumn(name="所属主线路",index = 2,width = 10) @TableField(exist = false) private Integer categoryId; @ApiModelProperty(value = "经度", example = "1") //@ExcelColumn(name="经度") @TableField(exist = false) private BigDecimal longitude; @ApiModelProperty(value = "所在位置") @TableField(exist = false) private String location; @ApiModelProperty(value = "维度", example = "1") //@ExcelColumn(name="维度") @TableField(exist = false) private BigDecimal latitude; @ApiModelProperty(value = "线路距离", example = "1") @TableField(exist = false) private String distanceJson; @ApiModelProperty(value = "园区距离该客户的距离(米)", example = "1") //@ExcelColumn(name="状态 0正常 禁用") @TableField(exist = false) private Long startDistance; @ApiModelProperty(value = "客户是否完成交通规划", example = "1") //@ExcelColumn(name="状态 0正常 禁用") @TableField(exist = false) private Integer distanceStatus; @ApiModelProperty(value = "该客户返回园区的距离(米)", example = "1") @TableField(exist = false) //@ExcelColumn(name="状态 0正常 禁用") private Long endDistance; @ApiModelProperty(value = "园区距离该客户的路径经纬度集合,分号隔开", example = "1") //@ExcelColumn(name="状态 0正常 禁用") @TableField(exist = false) private String startSteps; @ApiModelProperty(value = "该客户返回园区的路径经纬度集合,分号隔开", example = "1") //@ExcelColumn(name="状态 0正常 禁用") @TableField(exist = false) private String endSteps; @ApiModelProperty(value = "同班组间客户位置距离数组,[{a:12,b:100},{a:13,b:200},...],a:客户编码,b:与客户a之间的距离") @TableField(exist = false) private List distanceMapParamList; @ApiModelProperty(value = "类型 0优化前 1优化后", example = "1") private Integer type; }