EEnterprisePowerInfo.java 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220
  1. package com.zksy.info.domain;
  2. import com.alibaba.excel.annotation.ExcelIgnore;
  3. import com.alibaba.excel.annotation.ExcelProperty;
  4. import com.alibaba.excel.annotation.format.DateTimeFormat;
  5. import com.baomidou.mybatisplus.annotation.IdType;
  6. import com.baomidou.mybatisplus.annotation.TableField;
  7. import com.baomidou.mybatisplus.annotation.TableId;
  8. import com.baomidou.mybatisplus.annotation.TableName;
  9. import com.fasterxml.jackson.annotation.JsonFormat;
  10. import io.swagger.annotations.ApiModel;
  11. import io.swagger.annotations.ApiModelProperty;
  12. import java.io.Serializable;
  13. import java.math.BigDecimal;
  14. import java.time.LocalDate;
  15. import java.time.LocalDateTime;
  16. import java.util.Date;
  17. import lombok.Data;
  18. /**
  19. * 企业用电信息表
  20. * @TableName e_enterprise_power_info
  21. */
  22. @TableName(value ="e_enterprise_power_info")
  23. @Data
  24. @ApiModel(value="EEnterprisePowerInfo对象", description="企业用电相关信息")
  25. public class EEnterprisePowerInfo implements Serializable {
  26. /**
  27. * 主键
  28. */
  29. @TableId(type = IdType.ASSIGN_UUID)
  30. @ApiModelProperty(value = "用电信息唯一标识", position = 1)
  31. @ExcelIgnore
  32. private String id;
  33. /**
  34. * 企业名称
  35. */
  36. @ExcelProperty(value = "企业名称",index = 0)
  37. @ApiModelProperty(value = "用电企业全称", position = 2)
  38. private String enterpriseName;
  39. /**
  40. * 统一社会信用代码
  41. */
  42. @ExcelProperty(value = "统一社会信用代码",index = 1)
  43. @ApiModelProperty(value = "企业信用代码", position = 3, example = "913101156312345678")
  44. private String unifiedSocialCreditCode;
  45. /**
  46. * 电网户号
  47. */
  48. @ExcelProperty(value = "电网户号",index = 2)
  49. @ApiModelProperty(value = "供电系统中的用户编号", position = 4, example = "310000123456")
  50. private String powerGridAccountNumber;
  51. /**
  52. * 用户地址
  53. */
  54. @ExcelProperty(value = "用户地址",index = 3)
  55. @ApiModelProperty(value = "用电地址", position = 5)
  56. private String userAddress;
  57. /**
  58. * 运行容量
  59. */
  60. @ExcelProperty(value = "运行容量",index = 4)
  61. @ApiModelProperty(value = "当前运行的设备容量(单位:kW)", position = 6, example = "1250.00")
  62. private BigDecimal operatingCapacity;
  63. /**
  64. * 合同容量
  65. */
  66. @ExcelProperty(value = "合同容量",index = 5)
  67. @ApiModelProperty(value = "与供电部门签订的用电容量(单位:kW)", position = 7, example = "1600.00")
  68. private BigDecimal contractCapacity;
  69. /**
  70. * 首次供电时间
  71. */
  72. @ExcelProperty(value = "首次供电时间",index = 6)
  73. @ApiModelProperty(value = "首次通电日期")
  74. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
  75. private LocalDate firstPowerSupplyDate;
  76. /**
  77. * 用电账户状态
  78. */
  79. @ExcelProperty(value = "用电账户状态",index = 7)
  80. @ApiModelProperty(value = "账户状态(正常/暂停/注销等)", position = 9, example = "正常")
  81. private String powerAccountStatus;
  82. /**
  83. * 欠费金额
  84. */
  85. @ExcelProperty(value = "欠费金额",index = 8)
  86. @ApiModelProperty(value = "当前欠费金额(单位:元)", position = 10, example = "0.00")
  87. private BigDecimal arrearsAmount;
  88. /**
  89. * 近两年违约次数
  90. */
  91. @ExcelProperty(value = "近两年违约次数",index = 9)
  92. @ApiModelProperty(value = "近24个月内违约记录次数", position = 11, example = "0")
  93. private Integer defaultTimesInRecentTwoYears;
  94. /**
  95. * 用电类型
  96. */
  97. @ExcelProperty(value = "用电类型",index = 10)
  98. @ApiModelProperty(value = "用电分类(如大工业/一般工商业等)", position = 12, example = "大工业")
  99. private String powerConsumptionType;
  100. /**
  101. * 地区地方名(省级)
  102. */
  103. @ExcelProperty(value = "地区地方名(省级)",index = 11)
  104. @ApiModelProperty(value = "企业所在省级行政区", position = 13, example = "上海市")
  105. private String provinceName;
  106. /**
  107. * 地区地方名(市级)
  108. */
  109. @ExcelProperty(value = "地区地方名(市级)",index = 12)
  110. @ApiModelProperty(value = "企业所在市级行政区", position = 14, example = "上海市")
  111. private String cityName;
  112. /**
  113. * 近3月月均用电金额
  114. */
  115. @ExcelProperty(value = "近3月月均用电金额",index = 13)
  116. @ApiModelProperty(value = "最近3个月平均电费(单位:元)", position = 15, example = "52680.35")
  117. private BigDecimal averageMonthlyPowerCostRecentThreeMonths;
  118. /**
  119. * 近6月月均用电金额
  120. */
  121. @ExcelProperty(value = "近6月月均用电金额",index = 14)
  122. @ApiModelProperty(value = "最近6个月平均电费(单位:元)", position = 16, example = "53210.78")
  123. private BigDecimal averageMonthlyPowerCostRecentSixMonths;
  124. /**
  125. * 近一年月均用电金额
  126. */
  127. @ExcelProperty(value = "近一年月均用电金额",index = 15)
  128. @ApiModelProperty(value = "最近12个月平均电费(单位:元)", position = 17, example = "51890.23")
  129. private BigDecimal averageMonthlyPowerCostRecentTwelveMonths;
  130. /**
  131. * 当前是否欠费
  132. */
  133. @ExcelProperty(value = "当前是否欠费",index = 16)
  134. @ApiModelProperty(value = "当前是否欠费", position = 18, example = "0")
  135. private String isCurrentlyInArrears;
  136. /**
  137. * 统计时间
  138. */
  139. @ExcelProperty(value = "统计时间",index = 17)
  140. @DateTimeFormat("yyyy-MM-dd")
  141. @ApiModelProperty(value = "数据统计日期")
  142. @JsonFormat(pattern = "yyyy-MM-dd")
  143. private LocalDate statisticsTime;
  144. /**
  145. * 统计基准日期
  146. */
  147. @ExcelProperty(value = "统计基准日期",index = 18)
  148. @DateTimeFormat("yyyy-MM-dd")
  149. @ApiModelProperty(value = "统计数据的截止日期")
  150. @JsonFormat(pattern = "yyyy-MM-dd")
  151. private LocalDate statisticsBaseDate;
  152. /**
  153. * 备注
  154. */
  155. @ExcelProperty(value = "备注",index = 19)
  156. @ApiModelProperty(value = "特殊说明信息", position = 21)
  157. private String remarks;
  158. /**
  159. * 行政区域编码
  160. */
  161. @ExcelProperty(value = "行政区域编码",index = 20)
  162. @ApiModelProperty(value = "行政区划代码", position = 22, example = "310115")
  163. private String administrativeRegionCode;
  164. /**
  165. * 创建时间
  166. */
  167. @ExcelIgnore
  168. @ApiModelProperty(value = "记录创建时间")
  169. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
  170. private LocalDateTime createTime;
  171. /**
  172. * 创建人
  173. */
  174. @ExcelIgnore
  175. @ApiModelProperty(value = "创建记录的用户", position = 24)
  176. private String createBy;
  177. /**
  178. * 修改时间
  179. */
  180. @ExcelIgnore
  181. @ApiModelProperty(value = "记录最后修改时间")
  182. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
  183. private LocalDateTime updateTime;
  184. /**
  185. * 修改人
  186. */
  187. @ExcelIgnore
  188. @ApiModelProperty(value = "最后修改记录的用户", position = 26)
  189. private String updateBy;
  190. @TableField(exist = false)
  191. private static final long serialVersionUID = 1L;
  192. }