CusFollowQuery.java 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300
  1. package com.dk.mdm.model.query.mst;
  2. import cn.afterturn.easypoi.excel.annotation.Excel;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.baomidou.mybatisplus.annotation.FieldFill;
  5. import com.baomidou.mybatisplus.annotation.TableField;
  6. import com.baomidou.mybatisplus.annotation.TableName;
  7. import com.dk.common.infrastructure.annotaiton.ExportTitle;
  8. import com.dk.common.infrastructure.handler.JsonTypeHandler;
  9. import com.dk.common.infrastructure.handler.TimestampTypeHandler;
  10. import com.dk.common.infrastructure.handler.UuidTypeHandler;
  11. import com.dk.common.model.pojo.PageInfo;
  12. import com.fasterxml.jackson.annotation.JsonFormat;
  13. import io.swagger.annotations.ApiModel;
  14. import io.swagger.annotations.ApiModelProperty;
  15. import lombok.AllArgsConstructor;
  16. import lombok.Data;
  17. import lombok.EqualsAndHashCode;
  18. import lombok.NoArgsConstructor;
  19. import lombok.experimental.Accessors;
  20. import java.io.Serializable;
  21. import java.time.LocalDateTime;
  22. /**
  23. * 客户跟进
  24. */
  25. @Data
  26. @AllArgsConstructor
  27. @NoArgsConstructor
  28. @EqualsAndHashCode(callSuper = true)
  29. @Accessors(chain = true)
  30. @ExportTitle("客户跟进")
  31. @TableName(value = "t_crm_cus_follow", autoResultMap = true)
  32. @ApiModel(value="实体类:客户跟进", description="表名:t_crm_cus_follow")
  33. public class CusFollowQuery extends PageInfo<CusFollowQuery> implements Serializable {
  34. /*
  35. * 数据库字段
  36. */
  37. /**
  38. * 跟进ID
  39. */
  40. @ApiModelProperty(value = "跟进ID")
  41. @TableField(typeHandler = UuidTypeHandler.class)
  42. private String followId;
  43. /**
  44. * 客户ID (陌生接待时为null)
  45. */
  46. @Excel(name = "客户ID (陌生接待时为null)")
  47. @ApiModelProperty(value = "客户ID (陌生接待时为null)")
  48. @TableField(typeHandler = UuidTypeHandler.class)
  49. private String cusId;
  50. /**
  51. * 跟进状态 (【系统字典】陌生接待、留资接待(报备)、跟进、邀约、约尺)
  52. */
  53. @Excel(name = "跟进状态 (【系统字典】陌生接待、留资接待(报备)、跟进、邀约、约尺)")
  54. @ApiModelProperty(value = "跟进状态 (【系统字典】陌生接待、留资接待(报备)、跟进、邀约、约尺)")
  55. private String followStatus;
  56. /**
  57. * 跟进方式 (【系统字典】电话、微信、上门、进店)
  58. */
  59. @Excel(name = "跟进方式 (【系统字典】电话、微信、上门、进店)")
  60. @ApiModelProperty(value = "跟进方式 (【系统字典】电话、微信、上门、进店)")
  61. private String followType;
  62. /**
  63. * 跟进部门
  64. */
  65. @Excel(name = "跟进部门")
  66. @ApiModelProperty(value = "跟进部门")
  67. @TableField(typeHandler = UuidTypeHandler.class)
  68. private String followOrg;
  69. /**
  70. * 跟进人
  71. */
  72. @Excel(name = "跟进人")
  73. @ApiModelProperty(value = "跟进人")
  74. @TableField(typeHandler = UuidTypeHandler.class)
  75. private String followStaff;
  76. /**
  77. * 跟进时间
  78. */
  79. @Excel(name = "跟进时间")
  80. @ApiModelProperty(value = "跟进时间")
  81. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  82. @TableField(typeHandler = TimestampTypeHandler.class)
  83. private LocalDateTime followTime;
  84. /**
  85. * 跟进内容
  86. */
  87. @Excel(name = "跟进内容")
  88. @ApiModelProperty(value = "跟进内容")
  89. private String followData;
  90. /**
  91. * 跟进时长 (分钟)
  92. */
  93. @Excel(name = "跟进时长 (分钟)")
  94. @ApiModelProperty(value = "跟进时长 (分钟)")
  95. private Integer followTimeLen;
  96. /**
  97. * 留店时长 (【系统字典】10-20、20-30。。)
  98. */
  99. @Excel(name = "留店时长 (【系统字典】10-20、20-30。。)")
  100. @ApiModelProperty(value = "留店时长 (【系统字典】10-20、20-30。。)")
  101. private String stayTimeLen;
  102. /**
  103. * 客户意向 (【系统字典】)
  104. */
  105. @Excel(name = "客户意向 (【系统字典】)")
  106. @ApiModelProperty(value = "客户意向 (【系统字典】)")
  107. private String intention;
  108. /**
  109. * 邀约结果 (【系统字典】)
  110. */
  111. @Excel(name = "邀约结果 (【系统字典】)")
  112. @ApiModelProperty(value = "邀约结果 (【系统字典】)")
  113. private String inviteResult;
  114. /**
  115. * 邀约时间
  116. */
  117. @Excel(name = "邀约时间")
  118. @ApiModelProperty(value = "邀约时间")
  119. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  120. @TableField(typeHandler = TimestampTypeHandler.class)
  121. private LocalDateTime inviteTime;
  122. /**
  123. * 设计师
  124. */
  125. @Excel(name = "设计师")
  126. @ApiModelProperty(value = "设计师")
  127. @TableField(typeHandler = UuidTypeHandler.class)
  128. private String designStaff;
  129. /**
  130. * 下次跟进计划
  131. */
  132. @Excel(name = "下次跟进计划")
  133. @ApiModelProperty(value = "下次跟进计划")
  134. private String nextFollowPlan;
  135. /**
  136. * 下次跟进时间 (提醒时间)
  137. */
  138. @Excel(name = "下次跟进时间 (提醒时间)")
  139. @ApiModelProperty(value = "下次跟进时间 (提醒时间)")
  140. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  141. @TableField(typeHandler = TimestampTypeHandler.class)
  142. private LocalDateTime nextFollowTime;
  143. /**
  144. * 跟进附件 (index(显示顺序)、name(文件名)、path(路径)、type(类型)、time(上传时间)...)
  145. */
  146. @Excel(name = "跟进附件 (index(显示顺序)、name(文件名)、path(路径)、type(类型)、time(上传时间)...)")
  147. @ApiModelProperty(value = "跟进附件 (index(显示顺序)、name(文件名)、path(路径)、type(类型)、time(上传时间)...)")
  148. @TableField(typeHandler = JsonTypeHandler.class)
  149. private JSONObject annexPaths;
  150. /**
  151. * 量尺状态 (【系统字典】)
  152. */
  153. @Excel(name = "量尺状态 (【系统字典】)")
  154. @ApiModelProperty(value = "量尺状态 (【系统字典】)")
  155. private String measureStatus;
  156. /**
  157. * 备注
  158. */
  159. @Excel(name = "备注")
  160. @ApiModelProperty(value = "备注")
  161. private String remarks;
  162. /**
  163. * 有效标识 (1:正常 0:停用)
  164. */
  165. @Excel(name = "有效标识 (1:正常 0:停用)")
  166. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  167. private Boolean flgValid;
  168. /**
  169. * 企业ID
  170. */
  171. @TableField(fill = FieldFill.INSERT)
  172. @Excel(name = "企业ID")
  173. @ApiModelProperty(value = "企业ID")
  174. private Integer cpId;
  175. /**
  176. * 创建时间 (触发器自动处理)
  177. */
  178. @Excel(name = "创建时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  179. @ApiModelProperty(value = "创建时间 (触发器自动处理)")
  180. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  181. @TableField(typeHandler = TimestampTypeHandler.class)
  182. private LocalDateTime opCreateTime;
  183. /**
  184. * 创建用户 (触发器自动处理)
  185. */
  186. @Excel(name = "创建用户 (触发器自动处理)")
  187. @ApiModelProperty(value = "创建用户 (触发器自动处理)")
  188. @TableField(typeHandler = UuidTypeHandler.class)
  189. private String opCreateUserId;
  190. /**
  191. * 修改时间 (触发器自动处理)
  192. */
  193. @Excel(name = "修改时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  194. @ApiModelProperty(value = "修改时间 (触发器自动处理)")
  195. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  196. @TableField(typeHandler = TimestampTypeHandler.class)
  197. private LocalDateTime opUpdateTime;
  198. /**
  199. * 修改用户 (触发器自动处理)
  200. */
  201. @Excel(name = "修改用户 (触发器自动处理)")
  202. @ApiModelProperty(value = "修改用户 (触发器自动处理)")
  203. @TableField(typeHandler = UuidTypeHandler.class)
  204. private String opUpdateUserId;
  205. /**
  206. * 数据操作应用 (触发器自动处理)
  207. */
  208. @Excel(name = "数据操作应用 (触发器自动处理)")
  209. @ApiModelProperty(value = "数据操作应用 (触发器自动处理)")
  210. private String opAppCode;
  211. /**
  212. * 数据时间戳 (触发器自动处理)
  213. */
  214. @Excel(name = "数据时间戳 (触发器自动处理)")
  215. @ApiModelProperty(value = "数据时间戳 (触发器自动处理)")
  216. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  217. @TableField(typeHandler = TimestampTypeHandler.class)
  218. private LocalDateTime opTimestamp;
  219. /**
  220. * 数据操作数据库用户 (触发器自动处理)
  221. */
  222. @Excel(name = "数据操作数据库用户 (触发器自动处理)")
  223. @ApiModelProperty(value = "数据操作数据库用户 (触发器自动处理)")
  224. private String opDbUser;
  225. @ApiModelProperty(value = "模糊查询")
  226. private String searchText;
  227. /*
  228. * 相关属性
  229. * @TableField(exist = false)
  230. */
  231. /*
  232. * 关联属性 + 查询条件
  233. * @TableField(exist = false)
  234. */
  235. private static final long serialVersionUID = 1L;
  236. }