ExcelRiBaoLYBM4.java 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472
  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 int living;
  48. private int travelRecords;
  49. private Date reportDate;
  50. private int msStatus;
  51. private Long userId;
  52. @ExcelProperty(value = "部门名称", index = 1)
  53. private String loudong = "";
  54. @TableField(exist = false)
  55. @ExcelProperty(value = {"二级部门"}, index = 2)
  56. private String departmentName;
  57. private Integer inoculateStatus;
  58. private Integer vaccineType;
  59. @ExcelProperty(value = "是否接种新冠疫苗", index = 16)
  60. private String inoculateStatusStr = "";
  61. public String getInoculateStatusStr() {
  62. if (inoculateStatus == null) {
  63. inoculateStatusStr = "";
  64. } else if (inoculateStatus == 1) {
  65. inoculateStatusStr = "是";
  66. } else if (inoculateStatus == 2) {
  67. inoculateStatusStr = "否";
  68. }
  69. return inoculateStatusStr;
  70. }
  71. @ExcelProperty(value = "未接种原因", index = 15)
  72. private String reason;
  73. @ExcelProperty(value = "接种疫苗类别", index = 17)
  74. private String vaccineTypeStr;
  75. public String getVaccineTypeStr() {
  76. if (vaccineType == null) {
  77. vaccineTypeStr = "";
  78. } else if (vaccineType == 1) {
  79. vaccineTypeStr = "腺病毒疫苗";
  80. } else if (vaccineType == 2) {
  81. vaccineTypeStr = "灭活疫苗";
  82. } else if (vaccineType == 3) {
  83. vaccineTypeStr = "重组亚单位疫苗";
  84. }
  85. return vaccineTypeStr;
  86. }
  87. @ExcelProperty(value = "今日复工", index = 3)
  88. private String returnWorkMsg;
  89. public String getLoudong() {
  90. if (loudong.length() <= 0) {
  91. loudong = ridgepole + unit;
  92. }
  93. return loudong;
  94. }
  95. @ExcelProperty(value = "工号", index = 6)
  96. private String fanghao = "";
  97. public String getFanghao() {
  98. if (fanghao.length() <= 0) {
  99. fanghao = doorplate;
  100. }
  101. return fanghao;
  102. }
  103. @ExcelProperty(value = "姓名", index = 0)
  104. private String linkman;
  105. @ExcelProperty(value = "联系电话", index = 5)
  106. private String phone;
  107. private String safetyNumStr = "";
  108. public String getSafetyNumStr() {
  109. if (reportStatus == 0) {
  110. return "未填报";
  111. }
  112. safetyNumStr = "" + safetyNum;
  113. return safetyNumStr;
  114. }
  115. private String sureNumStr;
  116. public String getSureNumStr() {
  117. if (reportStatus == 0) {
  118. return "未填报";
  119. }
  120. sureNumStr = "" + sureNum;
  121. return sureNumStr;
  122. }
  123. private String singleNumStr;
  124. public String getSingleNumStr() {
  125. if (reportStatus == 0) {
  126. return "未填报";
  127. }
  128. singleNumStr = "" + singleNum;
  129. return singleNumStr;
  130. }
  131. private String suspectedNumStr;
  132. public String getSuspectedNumStr() {
  133. if (reportStatus == 0) {
  134. return "未填报";
  135. }
  136. suspectedNumStr = "" + suspectedNum;
  137. return suspectedNumStr;
  138. }
  139. private String normalNumStr;
  140. public String getNormalNumStr() {
  141. if (reportStatus == 0) {
  142. return "未填报";
  143. }
  144. normalNumStr = "" + normalNum;
  145. return normalNumStr;
  146. }
  147. private String userName;
  148. //
  149. // @ExcelProperty(value = "性别", index = 10)
  150. // private String grenderStr;
  151. // public String getGrenderStr() {
  152. // if (grender == 1) {
  153. // grenderStr = "男";
  154. // } else if (grender == 2) {
  155. // grenderStr = "女";
  156. // } else {
  157. // grenderStr = "未知";
  158. // }
  159. // return grenderStr;
  160. // }
  161. // @ExcelProperty(value = "年龄", index = 11)
  162. // private String age;
  163. private String temperatureStr;
  164. public String getTemperatureStr() {
  165. if (reportStatus == 0) {
  166. return "未填报";
  167. }
  168. temperatureStr = temperature.floatValue() > 10 ? temperature + "" : "未填报";
  169. return temperatureStr;
  170. }
  171. private String medicalStr;
  172. public String getMedicalStr() {
  173. if (reportStatus == 0) {
  174. return "未填报";
  175. }
  176. if (medical == 0) {
  177. medicalStr = "无";
  178. } else if (medical == 1) {
  179. medicalStr = "确诊";
  180. } else if (medical == 2) {
  181. medicalStr = "疑似";
  182. } else if (medical == 3) {
  183. medicalStr = "有接触史";
  184. } else if (medical == 4) {
  185. medicalStr = "解除隔离";
  186. }
  187. return medicalStr;
  188. }
  189. private String singleRoomStr;
  190. public String getSingleRoomStr() {
  191. if (reportStatus == 0) {
  192. return "未填报";
  193. }
  194. if (singleRoom == 0) {
  195. singleRoomStr = "否";
  196. } else {
  197. singleRoomStr = "是";
  198. }
  199. return singleRoomStr;
  200. }
  201. private String baseDesc = "";
  202. public String getBaseDesc() {
  203. if (reportStatus == 0) {
  204. return "未填报";
  205. }
  206. if (Conv.NI(familyStatus.split(",")[0]) == 1) {
  207. baseDesc += "心血管疾病(服用ARB),";
  208. } else if (Conv.NI(familyStatus.split(",")[1]) == 1) {
  209. baseDesc += "心血管疾病(未服用ARB),";
  210. }
  211. if (Conv.NI(familyStatus.split(",")[2]) == 1) {
  212. baseDesc += "呼吸系统病史,";
  213. }
  214. if (Conv.NI(familyStatus.split(",")[3]) == 1) {
  215. baseDesc += "肿瘤病史,";
  216. }
  217. if (Conv.NI(familyStatus.split(",")[4]) == 1) {
  218. baseDesc += "糖尿病史,";
  219. }
  220. if (Conv.NI(familyStatus.split(",")[5]) == 1) {
  221. baseDesc += "服用过激素药物,";
  222. }
  223. if (Conv.NI(familyStatus.split(",")[6]) == 1) {
  224. baseDesc += "妊娠期";
  225. }
  226. return baseDesc;
  227. }
  228. @ExcelProperty(value = "病情描述", index = 7)
  229. private String bingqingDesc = "";
  230. public String getBingqingDesc() {
  231. if (reportStatus == 0) {
  232. return "未填报";
  233. }
  234. if (medical == 1) {
  235. bingqingDesc += "已确诊、";
  236. } else if (medical == 2) {
  237. bingqingDesc += "疑似、";
  238. } else if (medical == 3) {
  239. bingqingDesc += "有接触史、";
  240. } else if (medical == 5) {
  241. bingqingDesc += "解除隔离、";
  242. }
  243. // if (isContact == 1) {
  244. // bingqingDesc += "家庭成员中有新冠肺炎疫情或有过病例接触史人员、";
  245. // }
  246. if (singleRoom == 1) {
  247. bingqingDesc += "单间隔离、";
  248. }
  249. if(temperature.floatValue() > 37.2){
  250. bingqingDesc = bingqingDesc + "体温:" + getTemperatureStr() + "、";
  251. }else{
  252. bingqingDesc = bingqingDesc + "体温:正常,37.2以下、";
  253. }
  254. if (cough == 1) {
  255. bingqingDesc += "偶尔短暂咳嗽、";
  256. } else if (cough == 2) {
  257. bingqingDesc += "咳嗽轻度影响生活、";
  258. } else if (cough == 3) {
  259. bingqingDesc += "咳嗽严重影响生活、";
  260. }
  261. if (muscle == 1) {
  262. bingqingDesc += "肌肉按压有酸痛、";
  263. } else if (muscle == 2) {
  264. bingqingDesc += "偶尔肌肉按压酸痛、";
  265. } else if (muscle == 3) {
  266. bingqingDesc += "肌肉按压持续酸痛、";
  267. }
  268. if (dyspnea == 1) {
  269. bingqingDesc += "呼吸急走或上坡气短、";
  270. } else if (dyspnea == 2) {
  271. bingqingDesc += "呼吸气短而走路变慢、";
  272. } else if (dyspnea == 3) {
  273. bingqingDesc += "呼吸走路数分钟后气短、";
  274. } else if (dyspnea == 4) {
  275. bingqingDesc += "呼吸气短无法离开房间、";
  276. }
  277. if (fatigue == 1) {
  278. bingqingDesc += "可体力劳动但觉得累、";
  279. } else if (fatigue == 2) {
  280. bingqingDesc += "轻体力劳动后长时间不能恢复、";
  281. } else if (fatigue == 3) {
  282. bingqingDesc += "不能正常生活、";
  283. }
  284. if (diarrhea == 1) {
  285. bingqingDesc += "轻度腹泻少于于3次、";
  286. } else if (diarrhea == 2) {
  287. bingqingDesc += "中度腹泻4-6次、";
  288. } else if (diarrhea == 3) {
  289. bingqingDesc += "重度腹泻超过6次、";
  290. }
  291. if (!Strings.isNullOrEmpty(statusDesp)) {
  292. bingqingDesc += statusDesp;
  293. bingqingDesc += "、";
  294. }
  295. if (!Strings.isNullOrEmpty(others)) {
  296. bingqingDesc += others;
  297. }
  298. bingqingDesc += "评估结果:";
  299. if (scoreRezult == 0) {
  300. bingqingDesc += "未评估";
  301. } else if (scoreRezult == 1) {
  302. if (temperatureScore > 1) {
  303. bingqingDesc += "正常,间隔时间服用退烧药,多休息,多喝水";
  304. } else {
  305. bingqingDesc += "正常";
  306. }
  307. } else if (scoreRezult == 2) {
  308. if (temperatureScore > 1) {
  309. bingqingDesc += "注意观察,间隔时间服用退烧药,多休息,多喝水";
  310. } else {
  311. bingqingDesc += "注意观察";
  312. }
  313. } else if (scoreRezult == 3) {
  314. bingqingDesc += "联系社区医生(或者在线问诊)";
  315. } else if (scoreRezult == 4) {
  316. bingqingDesc += "尽快就诊";
  317. }
  318. return bingqingDesc;
  319. }
  320. // @ExcelProperty(value = "工作驻地", index = 10)
  321. // private String workLoalDesc = "";
  322. //
  323. // public String getWorkLoalDesc() {
  324. // if (reportStatus == 0) {
  325. // return "";
  326. // }
  327. // if (workLocal == 1) {
  328. // workLoalDesc = "武汉市";
  329. // } else if (workLocal == 2) {
  330. // workLoalDesc = "宜昌市";
  331. // } else if (workLocal == 3) {
  332. // workLoalDesc = "当阳市";
  333. // } else if (workLocal == 4) {
  334. // workLoalDesc = "其它地点_" + workLocalOther;
  335. // }
  336. // return workLoalDesc;
  337. // }
  338. //
  339. // @ExcelProperty(value = "今晚住地", index = 11)
  340. // private String todayLoalDesc = "";
  341. //
  342. // public String getTodayLoalDesc() {
  343. // if (reportStatus == 0) {
  344. // return "";
  345. // }
  346. // if (todayLocal == 1) {
  347. // todayLoalDesc = "武汉市";
  348. // } else if (todayLocal == 2) {
  349. // todayLoalDesc = "宜昌市";
  350. // } else if (todayLocal == 3) {
  351. // todayLoalDesc = "当阳市";
  352. // } else if (todayLocal == 4) {
  353. // todayLoalDesc = "其它地点_" + todayLocalOther;
  354. // }
  355. // return todayLoalDesc;
  356. // }
  357. @ExcelProperty(value = "是否出行", index = 12)
  358. private String isTripDesc = "";
  359. public String getIsTripDesc() {
  360. if (reportStatus == 0) {
  361. return "";
  362. }
  363. if (isTrip == 1) {
  364. isTripDesc = "是";
  365. } else if (isTrip == 0) {
  366. isTripDesc = "否";
  367. }
  368. return isTripDesc;
  369. }
  370. @ExcelProperty(value = "出行详细", index = 13)
  371. private String tripDetDesc = "";
  372. public String getLivingDesc() {
  373. if (living == 1) {
  374. livingDesc = "是";
  375. } else if (living == 2) {
  376. livingDesc = "否";
  377. } else {
  378. return "";
  379. }
  380. return livingDesc;
  381. }
  382. @ExcelProperty(value = "居家2公里", index = 14)
  383. private String livingDesc = "";
  384. @ExcelProperty(value = "出行轨迹", index = 14)
  385. private String travelRecordsDesc;
  386. public String getTravelRecordsDesc() {
  387. if (travelRecords == 1) {
  388. travelRecordsDesc = "是";
  389. } else if (travelRecords == 2) {
  390. travelRecordsDesc = "否";
  391. } else {
  392. return "";
  393. }
  394. return travelRecordsDesc;
  395. }
  396. @ExcelProperty(value = "密切接触人员", index = 8)
  397. private String isContactDesc = "";
  398. @ExcelProperty(value = "家人健康异常", index = 9)
  399. private String isSuspectedDesc = "";
  400. @ExcelProperty(value = "个人上报状态", index = 4)
  401. private String reportStatusDesc = "";
  402. private String isBand="";
  403. private String oldOpenId="";
  404. private Long houseId=0L;
  405. }