easyExcel.java 8.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334
  1. package com.caimei.modules.user.entity;
  2. import com.alibaba.excel.annotation.ExcelIgnore;
  3. import com.alibaba.excel.annotation.ExcelProperty;
  4. import com.thinkgem.jeesite.common.utils.excel.annotation.ExcelField;
  5. /**
  6. * @author zzj
  7. */
  8. public class easyExcel {
  9. @ExcelIgnore
  10. private String firstClubType; // 机构一级分类
  11. @ExcelIgnore
  12. private String classify; // 机构二级分类
  13. @ExcelIgnore
  14. private String address; //详细地址
  15. @ExcelIgnore
  16. private String businessLicenseImage; //营业执照
  17. @ExcelIgnore
  18. private String userIdentity; //用户身份
  19. @ExcelIgnore
  20. private String linkManIdentity; //用户身份
  21. @ExcelIgnore
  22. private String sname; //机构简称
  23. @ExcelIgnore
  24. private String contractEmail; //联系邮箱
  25. @ExcelIgnore
  26. private String contractPhone; //联系电话
  27. @ExcelIgnore
  28. private String fax; //传真
  29. @ExcelIgnore
  30. private String headpic; //门头照
  31. @ExcelIgnore
  32. private String socialCreditCode; //统一社会信用代码 --- 营业执照编号
  33. @ExcelIgnore
  34. private String info; //公司简介
  35. @ExcelIgnore
  36. private Integer number; //百分比数值
  37. @ExcelIgnore
  38. private Integer userID; //user
  39. @ExcelProperty(value = "机构Id",index = 0)
  40. private String clubId; //机构ID
  41. @ExcelProperty(value = "机构名称",index = 1)
  42. private String name; //机构名称
  43. @ExcelProperty(value = "联系人",index = 2)
  44. private String linkMan; //联系人
  45. @ExcelProperty(value = "联系人身份",index = 3)
  46. private String linkManStatus; //联系人身份:1老板,2采购,3运营,4其他
  47. @ExcelProperty(value = "手机号",index = 4)
  48. private String contractMobile; //手机号
  49. @ExcelProperty(value = "协销人员",index = 5)
  50. private String spName; //协销人员
  51. @ExcelProperty(value = "状态",index = 6)
  52. private String clubStatus; //状态
  53. @ExcelProperty(value = "机构类型",index = 7)
  54. private String clubType; //机构类型
  55. @ExcelProperty(value = "机构级别",index = 8)
  56. private String clubRank; //机构级别
  57. @ExcelProperty(value = "资料完整度",index = 9)
  58. private String clubDataIntegrity; //资料完整度
  59. @ExcelProperty(value = "注册时间",index = 10)
  60. private String addTime; //注册时间
  61. @ExcelProperty(value = "近一个月订单数",index = 11)
  62. private String orderCountMonth; //近一个月订单数
  63. @ExcelProperty(value = "近一年订单数",index = 12)
  64. private String orderCountYear; //近一年订单数
  65. @ExcelProperty(value = "近一年购买额",index = 13)
  66. private String payTotalMonth; //近一年购买额
  67. @ExcelProperty(value = "总购买额",index = 14)
  68. private String payTotal; //总购买额
  69. @ExcelProperty(value = "最常搜索词",index = 15)
  70. private String pageLabel; //最常搜索词
  71. @ExcelProperty(value = "最近下单时间",index = 16)
  72. private String lastOrderTime; //最近下单时间
  73. public String getFirstClubType() {
  74. return firstClubType;
  75. }
  76. public void setFirstClubType(String firstClubType) {
  77. this.firstClubType = firstClubType;
  78. }
  79. public String getClassify() {
  80. return classify;
  81. }
  82. public void setClassify(String classify) {
  83. this.classify = classify;
  84. }
  85. public String getAddress() {
  86. return address;
  87. }
  88. public void setAddress(String address) {
  89. this.address = address;
  90. }
  91. public String getBusinessLicenseImage() {
  92. return businessLicenseImage;
  93. }
  94. public void setBusinessLicenseImage(String businessLicenseImage) {
  95. this.businessLicenseImage = businessLicenseImage;
  96. }
  97. public String getUserIdentity() {
  98. return userIdentity;
  99. }
  100. public void setUserIdentity(String userIdentity) {
  101. this.userIdentity = userIdentity;
  102. }
  103. public String getLinkManIdentity() {
  104. return linkManIdentity;
  105. }
  106. public void setLinkManIdentity(String linkManIdentity) {
  107. this.linkManIdentity = linkManIdentity;
  108. }
  109. public String getSname() {
  110. return sname;
  111. }
  112. public void setSname(String sname) {
  113. this.sname = sname;
  114. }
  115. public String getContractEmail() {
  116. return contractEmail;
  117. }
  118. public void setContractEmail(String contractEmail) {
  119. this.contractEmail = contractEmail;
  120. }
  121. public String getContractPhone() {
  122. return contractPhone;
  123. }
  124. public void setContractPhone(String contractPhone) {
  125. this.contractPhone = contractPhone;
  126. }
  127. public String getFax() {
  128. return fax;
  129. }
  130. public void setFax(String fax) {
  131. this.fax = fax;
  132. }
  133. public String getHeadpic() {
  134. return headpic;
  135. }
  136. public void setHeadpic(String headpic) {
  137. this.headpic = headpic;
  138. }
  139. public String getSocialCreditCode() {
  140. return socialCreditCode;
  141. }
  142. public void setSocialCreditCode(String socialCreditCode) {
  143. this.socialCreditCode = socialCreditCode;
  144. }
  145. public String getInfo() {
  146. return info;
  147. }
  148. public void setInfo(String info) {
  149. this.info = info;
  150. }
  151. public Integer getNumber() {
  152. return number;
  153. }
  154. public void setNumber(Integer number) {
  155. this.number = number;
  156. }
  157. public Integer getUserID() {
  158. return userID;
  159. }
  160. public void setUserID(Integer userID) {
  161. this.userID = userID;
  162. }
  163. public String getClubId() {
  164. return clubId;
  165. }
  166. public void setClubId(String clubId) {
  167. this.clubId = clubId;
  168. }
  169. public String getName() {
  170. return name;
  171. }
  172. public void setName(String name) {
  173. this.name = name;
  174. }
  175. public String getLinkMan() {
  176. return linkMan;
  177. }
  178. public void setLinkMan(String linkMan) {
  179. this.linkMan = linkMan;
  180. }
  181. public String getLinkManStatus() {
  182. return linkManStatus;
  183. }
  184. public void setLinkManStatus(String linkManStatus) {
  185. this.linkManStatus = linkManStatus;
  186. }
  187. public String getContractMobile() {
  188. return contractMobile;
  189. }
  190. public void setContractMobile(String contractMobile) {
  191. this.contractMobile = contractMobile;
  192. }
  193. public String getSpName() {
  194. return spName;
  195. }
  196. public void setSpName(String spName) {
  197. this.spName = spName;
  198. }
  199. public String getClubStatus() {
  200. return clubStatus;
  201. }
  202. public void setClubStatus(String clubStatus) {
  203. this.clubStatus = clubStatus;
  204. }
  205. public String getClubType() {
  206. return clubType;
  207. }
  208. public void setClubType(String clubType) {
  209. this.clubType = clubType;
  210. }
  211. public String getClubRank() {
  212. return clubRank;
  213. }
  214. public void setClubRank(String clubRank) {
  215. this.clubRank = clubRank;
  216. }
  217. public String getClubDataIntegrity() {
  218. return clubDataIntegrity;
  219. }
  220. public void setClubDataIntegrity(String clubDataIntegrity) {
  221. this.clubDataIntegrity = clubDataIntegrity;
  222. }
  223. public String getAddTime() {
  224. return addTime;
  225. }
  226. public void setAddTime(String addTime) {
  227. this.addTime = addTime;
  228. }
  229. public String getOrderCountMonth() {
  230. return orderCountMonth;
  231. }
  232. public void setOrderCountMonth(String orderCountMonth) {
  233. this.orderCountMonth = orderCountMonth;
  234. }
  235. public String getOrderCountYear() {
  236. return orderCountYear;
  237. }
  238. public void setOrderCountYear(String orderCountYear) {
  239. this.orderCountYear = orderCountYear;
  240. }
  241. public String getPayTotalMonth() {
  242. return payTotalMonth;
  243. }
  244. public void setPayTotalMonth(String payTotalMonth) {
  245. this.payTotalMonth = payTotalMonth;
  246. }
  247. public String getPayTotal() {
  248. return payTotal;
  249. }
  250. public void setPayTotal(String payTotal) {
  251. this.payTotal = payTotal;
  252. }
  253. public String getPageLabel() {
  254. return pageLabel;
  255. }
  256. public void setPageLabel(String pageLabel) {
  257. this.pageLabel = pageLabel;
  258. }
  259. public String getLastOrderTime() {
  260. return lastOrderTime;
  261. }
  262. public void setLastOrderTime(String lastOrderTime) {
  263. this.lastOrderTime = lastOrderTime;
  264. }
  265. }