MachineAttrHistory.java 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316
  1. package com.jeesite.modules.tianHong.entity;
  2. import java.util.Date;
  3. import java.util.List;
  4. import org.springframework.format.annotation.DateTimeFormat;
  5. import com.fasterxml.jackson.annotation.JsonFormat;
  6. import com.jeesite.common.entity.DataEntity;
  7. /**
  8. * 设备历史属性Entity
  9. * 列表/详情由主库 tianhong_backup 按秒展开填充
  10. * @author ljr
  11. * @version 2026-08-15
  12. */
  13. public class MachineAttrHistory extends DataEntity<MachineAttrHistory> {
  14. private static final long serialVersionUID = 1L;
  15. // ===== machine_attr_history 主表字段(按 eqp_id 聚合,行转列取关键属性)=====
  16. private String eqpId; // 设备号
  17. private String aluVal; // 剩余模次(attr='alu_val')
  18. private String pressurizeTime; // 保压时间(attr='pressurizeTime')
  19. private String coolingTime; // 冷却时间(attr='coolingTime')
  20. private String prePres; // 预压压力设定(attr='PrePres')
  21. private String holdPressure; // 保压开始信号(attr='HoldPressure')
  22. private String moldFillingPre; // 充型压力(attr='moldFillingPre')
  23. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
  24. private Date attrEventTime; // 属性更新时间(秒)
  25. // ===== 关联表:crutemphistory 炉膛温度 =====
  26. private String cruTemp; // 炉膛温度
  27. private Date cruTempTime; // 炉膛温度时间
  28. // ===== 关联表:alutemphistory 铝水温度 =====
  29. private String aluTemp; // 铝水温度
  30. private Date aluTempTime; // 铝水温度时间
  31. // ===== 关联表:mouldtemphistory 模具温度(一个设备可能多个测温点,拼接展示)=====
  32. private String mouldInfo; // 模具温度信息(如 "M1:725.5, M2:730.2")
  33. private Date mouldTempTime; // 模具温度时间
  34. // ===== 关联表:pressurehistory 压力(理论压力与实际压力)=====
  35. private String theoryPressure; // 理论压力
  36. private String realPressure; // 实际压力
  37. private String pressureLevel; // 压力段位
  38. private Date pressureTime; // 压力时间
  39. // ===== 关联表:EleConsumeHistory 电量(总计)=====
  40. private String eleConsume; // 电量
  41. private Date eleConsumeTime; // 电量时间
  42. // ===== 查询参数:时间范围(映射 tianhong_backup.create_date)=====
  43. @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
  44. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
  45. private Date beginTime;
  46. @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
  47. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
  48. private Date endTime;
  49. // ===== 手工分页(避免拦截器对复杂 SQL 二次 LIMIT)=====
  50. private Integer limit;
  51. private Integer offset;
  52. // ===== 详情:该设备的所有属性记录列表 =====
  53. private List<MachineAttrHistory> attrList;
  54. // ===== 行转列详情字段(findAttrList 查询时使用)=====
  55. private String attr;
  56. private String val;
  57. private Date eventTime;
  58. /** 列表行快照时间键(DATE_FORMAT event_time '%Y%m%d%H%i%s%f'),用于精确查明细 */
  59. private String eventTimeKey;
  60. public MachineAttrHistory() {
  61. this(null);
  62. }
  63. public MachineAttrHistory(String id) {
  64. super(id);
  65. }
  66. public String getEqpId() {
  67. return eqpId;
  68. }
  69. public void setEqpId(String eqpId) {
  70. this.eqpId = eqpId;
  71. }
  72. public String getAluVal() {
  73. return aluVal;
  74. }
  75. public void setAluVal(String aluVal) {
  76. this.aluVal = aluVal;
  77. }
  78. public String getPressurizeTime() {
  79. return pressurizeTime;
  80. }
  81. public void setPressurizeTime(String pressurizeTime) {
  82. this.pressurizeTime = pressurizeTime;
  83. }
  84. public String getCoolingTime() {
  85. return coolingTime;
  86. }
  87. public void setCoolingTime(String coolingTime) {
  88. this.coolingTime = coolingTime;
  89. }
  90. public String getPrePres() {
  91. return prePres;
  92. }
  93. public void setPrePres(String prePres) {
  94. this.prePres = prePres;
  95. }
  96. public String getHoldPressure() {
  97. return holdPressure;
  98. }
  99. public void setHoldPressure(String holdPressure) {
  100. this.holdPressure = holdPressure;
  101. }
  102. public String getMoldFillingPre() {
  103. return moldFillingPre;
  104. }
  105. public void setMoldFillingPre(String moldFillingPre) {
  106. this.moldFillingPre = moldFillingPre;
  107. }
  108. public Date getAttrEventTime() {
  109. return attrEventTime;
  110. }
  111. public void setAttrEventTime(Date attrEventTime) {
  112. this.attrEventTime = attrEventTime;
  113. }
  114. public String getCruTemp() {
  115. return cruTemp;
  116. }
  117. public void setCruTemp(String cruTemp) {
  118. this.cruTemp = cruTemp;
  119. }
  120. public Date getCruTempTime() {
  121. return cruTempTime;
  122. }
  123. public void setCruTempTime(Date cruTempTime) {
  124. this.cruTempTime = cruTempTime;
  125. }
  126. public String getAluTemp() {
  127. return aluTemp;
  128. }
  129. public void setAluTemp(String aluTemp) {
  130. this.aluTemp = aluTemp;
  131. }
  132. public Date getAluTempTime() {
  133. return aluTempTime;
  134. }
  135. public void setAluTempTime(Date aluTempTime) {
  136. this.aluTempTime = aluTempTime;
  137. }
  138. public String getMouldInfo() {
  139. return mouldInfo;
  140. }
  141. public void setMouldInfo(String mouldInfo) {
  142. this.mouldInfo = mouldInfo;
  143. }
  144. public Date getMouldTempTime() {
  145. return mouldTempTime;
  146. }
  147. public void setMouldTempTime(Date mouldTempTime) {
  148. this.mouldTempTime = mouldTempTime;
  149. }
  150. public String getTheoryPressure() {
  151. return theoryPressure;
  152. }
  153. public void setTheoryPressure(String theoryPressure) {
  154. this.theoryPressure = theoryPressure;
  155. }
  156. public String getRealPressure() {
  157. return realPressure;
  158. }
  159. public void setRealPressure(String realPressure) {
  160. this.realPressure = realPressure;
  161. }
  162. public String getPressureLevel() {
  163. return pressureLevel;
  164. }
  165. public void setPressureLevel(String pressureLevel) {
  166. this.pressureLevel = pressureLevel;
  167. }
  168. public Date getPressureTime() {
  169. return pressureTime;
  170. }
  171. public void setPressureTime(Date pressureTime) {
  172. this.pressureTime = pressureTime;
  173. }
  174. public String getEleConsume() {
  175. return eleConsume;
  176. }
  177. public void setEleConsume(String eleConsume) {
  178. this.eleConsume = eleConsume;
  179. }
  180. public Date getEleConsumeTime() {
  181. return eleConsumeTime;
  182. }
  183. public void setEleConsumeTime(Date eleConsumeTime) {
  184. this.eleConsumeTime = eleConsumeTime;
  185. }
  186. public Date getBeginTime() {
  187. return beginTime;
  188. }
  189. public void setBeginTime(Date beginTime) {
  190. this.beginTime = beginTime;
  191. }
  192. public Date getEndTime() {
  193. return endTime;
  194. }
  195. public void setEndTime(Date endTime) {
  196. this.endTime = endTime;
  197. }
  198. public Integer getLimit() {
  199. return limit;
  200. }
  201. public void setLimit(Integer limit) {
  202. this.limit = limit;
  203. }
  204. public Integer getOffset() {
  205. return offset;
  206. }
  207. public void setOffset(Integer offset) {
  208. this.offset = offset;
  209. }
  210. public List<MachineAttrHistory> getAttrList() {
  211. return attrList;
  212. }
  213. public void setAttrList(List<MachineAttrHistory> attrList) {
  214. this.attrList = attrList;
  215. }
  216. public String getAttr() {
  217. return attr;
  218. }
  219. public void setAttr(String attr) {
  220. this.attr = attr;
  221. }
  222. public String getVal() {
  223. return val;
  224. }
  225. public void setVal(String val) {
  226. this.val = val;
  227. }
  228. public Date getEventTime() {
  229. return eventTime;
  230. }
  231. public void setEventTime(Date eventTime) {
  232. this.eventTime = eventTime;
  233. }
  234. public String getEventTimeKey() {
  235. return eventTimeKey;
  236. }
  237. public void setEventTimeKey(String eventTimeKey) {
  238. this.eventTimeKey = eventTimeKey;
  239. }
  240. }