ExcelRiBaoLYBM4.java 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403
  1. package com.bofeng.entity;
  2. import com.alibaba.excel.annotation.ExcelProperty;
  3. import com.baomidou.mybatisplus.annotations.TableField;
  4. import com.google.common.base.Strings;
  5. import com.yvan.platform.Conv;
  6. import lombok.Getter;
  7. import lombok.Setter;
  8. import java.math.BigDecimal;
  9. import java.util.Date;
  10. @Getter
  11. @Setter
  12. public class ExcelRiBaoLYBM4 {
  13. private String ridgepole = "";
  14. private String unit = "";
  15. private String doorplate = "";
  16. private BigDecimal temperature = new BigDecimal(0);
  17. private int grender = 0;
  18. private String familyStatus = "0,0,0,0,0,0,0";
  19. private int medical = 0;
  20. private int cough = 0;
  21. private int muscle = 0;
  22. private int dyspnea = 0;
  23. private int fatigue = 0;
  24. private int diarrhea = 0;
  25. private int singleRoom = 0;
  26. private int scoreRezult = 0;
  27. private int temperatureScore = 0;
  28. private int safetyNum = 0;
  29. private int reportStatus = 0;
  30. private int sureNum = 0;
  31. private int singleNum = 0;
  32. private int suspectedNum = 0;
  33. private int normalNum = 0;
  34. private String statusDesp = "";
  35. private String others = "";
  36. private Long tripId = 0L;
  37. private int workLocal = 0;
  38. private String workLocalOther = "";
  39. private int todayLocal = 0;
  40. private String todayLocalOther = "";
  41. private String autoLocal="";
  42. private String autoAddr="";
  43. private int isTrip = 0;
  44. private int isContact = 0;
  45. private int isSuspected = 0;
  46. private int returnWork = 0;
  47. private Date reportDate;
  48. private int msStatus;
  49. private Long userId;
  50. @ExcelProperty(value = "部门名称", index = 1)
  51. private String loudong = "";
  52. @TableField(exist = false)
  53. @ExcelProperty(value = {"二级部门"}, index = 2)
  54. private String departmentName;
  55. @ExcelProperty(value = "今日复工", index = 3)
  56. private String returnWorkMsg;
  57. public String getLoudong() {
  58. if (loudong.length() <= 0) {
  59. loudong = ridgepole + unit;
  60. }
  61. return loudong;
  62. }
  63. @ExcelProperty(value = "工号", index = 6)
  64. private String fanghao = "";
  65. public String getFanghao() {
  66. if (fanghao.length() <= 0) {
  67. fanghao = doorplate;
  68. }
  69. return fanghao;
  70. }
  71. @ExcelProperty(value = "姓名", index = 0)
  72. private String linkman;
  73. @ExcelProperty(value = "联系电话", index = 5)
  74. private String phone;
  75. private String safetyNumStr = "";
  76. public String getSafetyNumStr() {
  77. if (reportStatus == 0) {
  78. return "未填报";
  79. }
  80. safetyNumStr = "" + safetyNum;
  81. return safetyNumStr;
  82. }
  83. private String sureNumStr;
  84. public String getSureNumStr() {
  85. if (reportStatus == 0) {
  86. return "未填报";
  87. }
  88. sureNumStr = "" + sureNum;
  89. return sureNumStr;
  90. }
  91. private String singleNumStr;
  92. public String getSingleNumStr() {
  93. if (reportStatus == 0) {
  94. return "未填报";
  95. }
  96. singleNumStr = "" + singleNum;
  97. return singleNumStr;
  98. }
  99. private String suspectedNumStr;
  100. public String getSuspectedNumStr() {
  101. if (reportStatus == 0) {
  102. return "未填报";
  103. }
  104. suspectedNumStr = "" + suspectedNum;
  105. return suspectedNumStr;
  106. }
  107. private String normalNumStr;
  108. public String getNormalNumStr() {
  109. if (reportStatus == 0) {
  110. return "未填报";
  111. }
  112. normalNumStr = "" + normalNum;
  113. return normalNumStr;
  114. }
  115. private String userName;
  116. //
  117. // @ExcelProperty(value = "性别", index = 10)
  118. // private String grenderStr;
  119. // public String getGrenderStr() {
  120. // if (grender == 1) {
  121. // grenderStr = "男";
  122. // } else if (grender == 2) {
  123. // grenderStr = "女";
  124. // } else {
  125. // grenderStr = "未知";
  126. // }
  127. // return grenderStr;
  128. // }
  129. // @ExcelProperty(value = "年龄", index = 11)
  130. // private String age;
  131. private String temperatureStr;
  132. public String getTemperatureStr() {
  133. if (reportStatus == 0) {
  134. return "未填报";
  135. }
  136. temperatureStr = temperature.floatValue() > 10 ? temperature + "" : "未填报";
  137. return temperatureStr;
  138. }
  139. private String medicalStr;
  140. public String getMedicalStr() {
  141. if (reportStatus == 0) {
  142. return "未填报";
  143. }
  144. if (medical == 0) {
  145. medicalStr = "无";
  146. } else if (medical == 1) {
  147. medicalStr = "确诊";
  148. } else if (medical == 2) {
  149. medicalStr = "疑似";
  150. } else if (medical == 3) {
  151. medicalStr = "有接触史";
  152. } else if (medical == 4) {
  153. medicalStr = "解除隔离";
  154. }
  155. return medicalStr;
  156. }
  157. private String singleRoomStr;
  158. public String getSingleRoomStr() {
  159. if (reportStatus == 0) {
  160. return "未填报";
  161. }
  162. if (singleRoom == 0) {
  163. singleRoomStr = "否";
  164. } else {
  165. singleRoomStr = "是";
  166. }
  167. return singleRoomStr;
  168. }
  169. private String baseDesc = "";
  170. public String getBaseDesc() {
  171. if (reportStatus == 0) {
  172. return "未填报";
  173. }
  174. if (Conv.NI(familyStatus.split(",")[0]) == 1) {
  175. baseDesc += "心血管疾病(服用ARB),";
  176. } else if (Conv.NI(familyStatus.split(",")[1]) == 1) {
  177. baseDesc += "心血管疾病(未服用ARB),";
  178. }
  179. if (Conv.NI(familyStatus.split(",")[2]) == 1) {
  180. baseDesc += "呼吸系统病史,";
  181. }
  182. if (Conv.NI(familyStatus.split(",")[3]) == 1) {
  183. baseDesc += "肿瘤病史,";
  184. }
  185. if (Conv.NI(familyStatus.split(",")[4]) == 1) {
  186. baseDesc += "糖尿病史,";
  187. }
  188. if (Conv.NI(familyStatus.split(",")[5]) == 1) {
  189. baseDesc += "服用过激素药物,";
  190. }
  191. if (Conv.NI(familyStatus.split(",")[6]) == 1) {
  192. baseDesc += "妊娠期";
  193. }
  194. return baseDesc;
  195. }
  196. @ExcelProperty(value = "病情描述", index = 7)
  197. private String bingqingDesc = "";
  198. public String getBingqingDesc() {
  199. if (reportStatus == 0) {
  200. return "未填报";
  201. }
  202. if (medical == 1) {
  203. bingqingDesc += "已确诊、";
  204. } else if (medical == 2) {
  205. bingqingDesc += "疑似、";
  206. } else if (medical == 3) {
  207. bingqingDesc += "有接触史、";
  208. } else if (medical == 5) {
  209. bingqingDesc += "解除隔离、";
  210. }
  211. // if (isContact == 1) {
  212. // bingqingDesc += "家庭成员中有新冠肺炎疫情或有过病例接触史人员、";
  213. // }
  214. if (singleRoom == 1) {
  215. bingqingDesc += "单间隔离、";
  216. }
  217. bingqingDesc = bingqingDesc + "体温:" + getTemperatureStr() + "、";
  218. if (cough == 1) {
  219. bingqingDesc += "偶尔短暂咳嗽、";
  220. } else if (cough == 2) {
  221. bingqingDesc += "咳嗽轻度影响生活、";
  222. } else if (cough == 3) {
  223. bingqingDesc += "咳嗽严重影响生活、";
  224. }
  225. if (muscle == 1) {
  226. bingqingDesc += "肌肉按压有酸痛、";
  227. } else if (muscle == 2) {
  228. bingqingDesc += "偶尔肌肉按压酸痛、";
  229. } else if (muscle == 3) {
  230. bingqingDesc += "肌肉按压持续酸痛、";
  231. }
  232. if (dyspnea == 1) {
  233. bingqingDesc += "呼吸急走或上坡气短、";
  234. } else if (dyspnea == 2) {
  235. bingqingDesc += "呼吸气短而走路变慢、";
  236. } else if (dyspnea == 3) {
  237. bingqingDesc += "呼吸走路数分钟后气短、";
  238. } else if (dyspnea == 4) {
  239. bingqingDesc += "呼吸气短无法离开房间、";
  240. }
  241. if (fatigue == 1) {
  242. bingqingDesc += "可体力劳动但觉得累、";
  243. } else if (fatigue == 2) {
  244. bingqingDesc += "轻体力劳动后长时间不能恢复、";
  245. } else if (fatigue == 3) {
  246. bingqingDesc += "不能正常生活、";
  247. }
  248. if (diarrhea == 1) {
  249. bingqingDesc += "轻度腹泻少于于3次、";
  250. } else if (diarrhea == 2) {
  251. bingqingDesc += "中度腹泻4-6次、";
  252. } else if (diarrhea == 3) {
  253. bingqingDesc += "重度腹泻超过6次、";
  254. }
  255. if (!Strings.isNullOrEmpty(statusDesp)) {
  256. bingqingDesc += statusDesp;
  257. bingqingDesc += "、";
  258. }
  259. if (!Strings.isNullOrEmpty(others)) {
  260. bingqingDesc += others;
  261. }
  262. bingqingDesc += "评估结果:";
  263. if (scoreRezult == 0)
  264. bingqingDesc += "未评估";
  265. else if (scoreRezult == 1) {
  266. if (temperatureScore > 1)
  267. bingqingDesc += "正常,间隔时间服用退烧药,多休息,多喝水";
  268. else
  269. bingqingDesc += "正常";
  270. } else if (scoreRezult == 2) {
  271. if (temperatureScore > 1)
  272. bingqingDesc += "注意观察,间隔时间服用退烧药,多休息,多喝水";
  273. else
  274. bingqingDesc += "注意观察";
  275. } else if (scoreRezult == 3)
  276. bingqingDesc += "联系社区医生(或者在线问诊)";
  277. else if (scoreRezult == 4)
  278. bingqingDesc += "尽快就诊";
  279. return bingqingDesc;
  280. }
  281. @ExcelProperty(value = "工作驻地", index = 10)
  282. private String workLoalDesc = "";
  283. public String getWorkLoalDesc() {
  284. if (reportStatus == 0) {
  285. return "";
  286. }
  287. if (workLocal == 1) {
  288. workLoalDesc = "武汉市";
  289. } else if (workLocal == 2) {
  290. workLoalDesc = "宜昌市";
  291. } else if (workLocal == 3) {
  292. workLoalDesc = "当阳市";
  293. } else if (workLocal == 4) {
  294. workLoalDesc = "其它地点_" + workLocalOther;
  295. }
  296. return workLoalDesc;
  297. }
  298. @ExcelProperty(value = "今晚住地", index = 11)
  299. private String todayLoalDesc = "";
  300. public String getTodayLoalDesc() {
  301. if (reportStatus == 0) {
  302. return "";
  303. }
  304. if (todayLocal == 1) {
  305. todayLoalDesc = "武汉市";
  306. } else if (todayLocal == 2) {
  307. todayLoalDesc = "宜昌市";
  308. } else if (todayLocal == 3) {
  309. todayLoalDesc = "当阳市";
  310. } else if (todayLocal == 4) {
  311. todayLoalDesc = "其它地点_" + todayLocalOther;
  312. }
  313. return todayLoalDesc;
  314. }
  315. @ExcelProperty(value = "是否出行", index = 12)
  316. private String isTripDesc = "";
  317. public String getIsTripDesc() {
  318. if (reportStatus == 0) {
  319. return "";
  320. }
  321. if (isTrip == 1) {
  322. isTripDesc = "是";
  323. } else if (isTrip == 0) {
  324. isTripDesc = "否";
  325. }
  326. return isTripDesc;
  327. }
  328. @ExcelProperty(value = "出行详细", index = 13)
  329. private String tripDetDesc = "";
  330. @ExcelProperty(value = "家人确诊或接触", index = 8)
  331. private String isContactDesc = "";
  332. @ExcelProperty(value = "家人健康异常", index = 9)
  333. private String isSuspectedDesc = "";
  334. @ExcelProperty(value = "个人上报状态", index = 4)
  335. private String reportStatusDesc = "";
  336. @ExcelProperty(value = "是否迁移", index = 14)
  337. private String isBand="";
  338. private String oldOpenId="";
  339. private Long houseId=0L;
  340. }