Customer.java 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348
  1. package com.dk.mdm.model.pojo.mst;
  2. import cn.afterturn.easypoi.excel.annotation.Excel;
  3. import com.baomidou.mybatisplus.annotation.*;
  4. import java.io.Serializable;
  5. import com.dk.common.infrastructure.annotaiton.ExportTitle;
  6. import com.dk.common.infrastructure.handler.*;
  7. import com.dk.common.model.pojo.PageInfo;
  8. import com.fasterxml.jackson.annotation.JsonFormat;
  9. import lombok.Data;
  10. import lombok.AllArgsConstructor;
  11. import lombok.NoArgsConstructor;
  12. import lombok.EqualsAndHashCode;
  13. import lombok.experimental.Accessors;
  14. import io.swagger.annotations.ApiModel;
  15. import io.swagger.annotations.ApiModelProperty;
  16. import com.alibaba.fastjson.JSONObject;
  17. import java.util.List;
  18. import java.time.LocalDateTime;
  19. /**
  20. * 客户资料
  21. */
  22. @Data
  23. @AllArgsConstructor
  24. @NoArgsConstructor
  25. @EqualsAndHashCode(callSuper = true)
  26. @Accessors(chain = true)
  27. @ExportTitle("客户资料")
  28. @TableName(value = "t_mst_customer", autoResultMap = true,schema = "dkic_b")
  29. @ApiModel(value="实体类:客户资料", description="表名:t_mst_customer")
  30. public class Customer extends PageInfo<Customer> implements Serializable {
  31. /*
  32. * 数据库字段
  33. */
  34. /**
  35. * 客户ID
  36. */
  37. // @TableId(value = "cus_id", type = IdType.AUTO)
  38. @ApiModelProperty(value = "客户ID")
  39. @TableField(typeHandler = UuidTypeHandler.class)
  40. private String cusId;
  41. /**
  42. * 客户编号
  43. */
  44. @Excel(name = "客户编号")
  45. @ApiModelProperty(value = "客户编号")
  46. private String cusCode;
  47. /**
  48. * 客户名称
  49. */
  50. @Excel(name = "客户名称")
  51. @ApiModelProperty(value = "客户名称")
  52. private String cusName;
  53. /**
  54. * 客户电话
  55. */
  56. @Excel(name = "客户电话")
  57. @ApiModelProperty(value = "客户电话")
  58. private String cusPhone;
  59. /**
  60. * 行政区划 (a1:省 a2:市 a3:区)
  61. */
  62. @Excel(name = "行政区划 (a1:省 a2:市 a3:区)")
  63. @ApiModelProperty(value = "行政区划 (a1:省 a2:市 a3:区)")
  64. @TableField(typeHandler = JsonTypeHandler.class)
  65. private JSONObject addressArea;
  66. /**
  67. * 小区或POI
  68. */
  69. @Excel(name = "小区或POI")
  70. @ApiModelProperty(value = "小区或POI")
  71. private String addressName;
  72. /**
  73. * 门牌号
  74. */
  75. @Excel(name = "门牌号")
  76. @ApiModelProperty(value = "门牌号")
  77. private String addressNo;
  78. /**
  79. * 地址坐标(gcj02) (LAT:纬度的值 LON:经度的值)
  80. */
  81. @Excel(name = "地址坐标(gcj02) (LAT:纬度的值 LON:经度的值)")
  82. @ApiModelProperty(value = "地址坐标(gcj02) (LAT:纬度的值 LON:经度的值)")
  83. @TableField(typeHandler = JsonTypeHandler.class)
  84. private JSONObject addressGcj02;
  85. /**
  86. * 详细地址
  87. */
  88. @Excel(name = "详细地址")
  89. @ApiModelProperty(value = "详细地址")
  90. private String addressFull;
  91. /**
  92. * 联系人
  93. */
  94. @Excel(name = "联系人")
  95. @ApiModelProperty(value = "联系人")
  96. private String contactName;
  97. /**
  98. * 联系电话
  99. */
  100. @Excel(name = "联系电话")
  101. @ApiModelProperty(value = "联系电话")
  102. private String contactPhone;
  103. /**
  104. * 客户来源 (【数据字典】)
  105. */
  106. @Excel(name = "客户来源 (【数据字典】)")
  107. @ApiModelProperty(value = "客户来源 (【数据字典】)")
  108. @TableField(typeHandler = UuidTypeHandler.class)
  109. private String cusFrom;
  110. /**
  111. * 销售渠道
  112. */
  113. @Excel(name = "销售渠道")
  114. @ApiModelProperty(value = "销售渠道")
  115. @TableField(typeHandler = UuidTypeHandler.class)
  116. private String channelId;
  117. /**
  118. * 部门
  119. */
  120. @Excel(name = "部门")
  121. @ApiModelProperty(value = "部门")
  122. @TableField(typeHandler = UuidTypeHandler.class)
  123. private String orgId;
  124. /**
  125. * 业务员
  126. */
  127. @Excel(name = "业务员")
  128. @ApiModelProperty(value = "业务员")
  129. @TableField(typeHandler = UuidTypeHandler.class)
  130. private String staffId;
  131. /**
  132. * 报备人
  133. */
  134. @Excel(name = "报备人")
  135. @ApiModelProperty(value = "报备人")
  136. @TableField(typeHandler = UuidTypeHandler.class)
  137. private String reportStaff;
  138. /**
  139. * 报备时间
  140. */
  141. @Excel(name = "报备时间")
  142. @ApiModelProperty(value = "报备时间")
  143. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  144. @TableField(typeHandler = TimestampTypeHandler.class)
  145. private LocalDateTime reportTime;
  146. /**
  147. * 销售状态 (【系统字典】客销状态:公海、潜客、成交)
  148. */
  149. @Excel(name = "销售状态 (【系统字典】客销状态:公海、潜客、成交)")
  150. @ApiModelProperty(value = "销售状态 (【系统字典】客销状态:公海、潜客、成交)")
  151. private String saleStatus;
  152. /**
  153. * 备注
  154. */
  155. @Excel(name = "备注")
  156. @ApiModelProperty(value = "备注")
  157. private String remarks;
  158. /**
  159. * 当前跟进人
  160. */
  161. @Excel(name = "当前跟进人")
  162. @ApiModelProperty(value = "当前跟进人")
  163. @TableField(typeHandler = UuidListTypeHandler.class)
  164. private List<String> followStaffs;
  165. /**
  166. * 最后跟进人
  167. */
  168. @Excel(name = "最后跟进人")
  169. @ApiModelProperty(value = "最后跟进人")
  170. @TableField(typeHandler = UuidTypeHandler.class)
  171. private String lastFollowStaff;
  172. /**
  173. * 最后跟进ID
  174. */
  175. @Excel(name = "最后跟进ID")
  176. @ApiModelProperty(value = "最后跟进ID")
  177. @TableField(typeHandler = UuidTypeHandler.class)
  178. private String lastFollowId;
  179. /**
  180. * 最后跟进状态 (【系统字典】跟进状态:报备、跟进、邀约、报价、成交)
  181. */
  182. @Excel(name = "最后跟进状态 (【系统字典】跟进状态:报备、跟进、邀约、报价、成交)")
  183. @ApiModelProperty(value = "最后跟进状态 (【系统字典】跟进状态:报备、跟进、邀约、报价、成交)")
  184. private String lastFollowStatus;
  185. /**
  186. * 最后跟进时间
  187. */
  188. @Excel(name = "最后跟进时间")
  189. @ApiModelProperty(value = "最后跟进时间")
  190. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  191. @TableField(typeHandler = TimestampTypeHandler.class)
  192. private LocalDateTime lastFollowTime;
  193. /**
  194. * 跟进次数
  195. */
  196. @Excel(name = "跟进次数")
  197. @ApiModelProperty(value = "跟进次数")
  198. private Integer followCount;
  199. /**
  200. * 有效标识 (1:正常 0:停用)
  201. */
  202. @Excel(name = "有效标识 (1:正常 0:停用)")
  203. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  204. private Boolean flgValid;
  205. /**
  206. * 企业ID
  207. */
  208. @Excel(name = "企业ID")
  209. @ApiModelProperty(value = "企业ID")
  210. private Integer cpId;
  211. /**
  212. * 创建时间 (触发器自动处理)
  213. */
  214. @Excel(name = "创建时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  215. @ApiModelProperty(value = "创建时间 (触发器自动处理)")
  216. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  217. @TableField(typeHandler = TimestampTypeHandler.class)
  218. private LocalDateTime opCreateTime;
  219. /**
  220. * 创建用户 (触发器自动处理)
  221. */
  222. @Excel(name = "创建用户 (触发器自动处理)")
  223. @ApiModelProperty(value = "创建用户 (触发器自动处理)")
  224. @TableField(typeHandler = UuidTypeHandler.class)
  225. private String opCreateUserId;
  226. /**
  227. * 修改时间 (触发器自动处理)
  228. */
  229. @Excel(name = "修改时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  230. @ApiModelProperty(value = "修改时间 (触发器自动处理)")
  231. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  232. @TableField(typeHandler = TimestampTypeHandler.class)
  233. private LocalDateTime opUpdateTime;
  234. /**
  235. * 修改用户 (触发器自动处理)
  236. */
  237. @Excel(name = "修改用户 (触发器自动处理)")
  238. @ApiModelProperty(value = "修改用户 (触发器自动处理)")
  239. @TableField(typeHandler = UuidTypeHandler.class)
  240. private String opUpdateUserId;
  241. /**
  242. * 数据操作应用 (触发器自动处理)
  243. */
  244. @Excel(name = "数据操作应用 (触发器自动处理)")
  245. @ApiModelProperty(value = "数据操作应用 (触发器自动处理)")
  246. private String opAppCode;
  247. /**
  248. * 数据时间戳 (触发器自动处理)
  249. */
  250. @Excel(name = "数据时间戳 (触发器自动处理)")
  251. @ApiModelProperty(value = "数据时间戳 (触发器自动处理)")
  252. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  253. @TableField(typeHandler = TimestampTypeHandler.class)
  254. private LocalDateTime opTimestamp;
  255. /**
  256. * 数据操作数据库用户 (触发器自动处理)
  257. */
  258. @Excel(name = "数据操作数据库用户 (触发器自动处理)")
  259. @ApiModelProperty(value = "数据操作数据库用户 (触发器自动处理)")
  260. private String opDbUser;
  261. /*
  262. * 相关属性
  263. * @TableField(exist = false)
  264. */
  265. /*
  266. * 关联属性 + 查询条件
  267. * @TableField(exist = false)
  268. */
  269. private static final long serialVersionUID = 1L;
  270. }