DataTask.java 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. package com.zskk.task;
  2. import java.util.Date;
  3. import java.util.List;
  4. import com.jfinal.plugin.activerecord.Db;
  5. import com.jfinal.plugin.activerecord.Record;
  6. import com.jfinal.plugin.cron4j.ITask;
  7. import com.zskk.model.Reports;
  8. import com.zskk.model.Studies;
  9. public class DataTask implements ITask {
  10. @Override
  11. public void run() {
  12. // TODO Auto-generated method stub
  13. List<Studies> studies = Studies.dao.use("zskk").find("select * from Studies where hospitalId = 74300001 order by createdAt desc limit 50");
  14. for (Studies studies2 : studies) {
  15. Reports reports = Reports.dao.use("zskk").findFirst("select * from Reports where hospitalNo=74300001 and studyuid=?",studies2.getStudyUid());
  16. if (reports == null) {
  17. Record record = Db.use("connected").findFirst("select * from yhxx where STUDYUID=?",studies2.getStudyUid());
  18. if (record == null ) {
  19. continue;
  20. }
  21. Reports newreport = new Reports().use("zskk");
  22. newreport.setTitle("定西市中医院");
  23. newreport.setSubtitle(record.getStr("modality")==null?"":record.getStr("modality") + "诊断报告单");
  24. newreport.setReportDoctor(record.getStr("reportdoctor")==null?"定西市中医院":record.getStr("reportdoctor"));
  25. newreport.setImpression(record.getStr("impression")==null?"暂未出具":record.getStr("impression"));
  26. newreport.setDescription(record.getStr("description")==null?"暂未出具":record.getStr("description"));
  27. newreport.setHospitalNo("74300001");
  28. newreport.setPatientName(record.getStr("patientName")==null?"无":record.getStr("patientName"));
  29. newreport.setExamClass(record.getStr("modality")==null?record.getStr("modality"):record.getStr("modality"));
  30. //newreport.setExamItem(record.getStr("FITEM_CH_NAME")==null?"无":record.getStr("FITEM_CH_NAME"));
  31. newreport.setStatus(1);
  32. newreport.setStudyuid(studies2.getStudyUid());
  33. newreport.setExamNo(record.getStr("patientID")==null?"无":record.getStr("patientID"));
  34. newreport.setStudyid(studies2.getAccessionNumber());
  35. newreport.setCreatedAt(new Date());
  36. newreport.setUpdatedAt(new Date());
  37. newreport.setStudyKey(studies2.getStudyKey());
  38. newreport.setDid(1);
  39. newreport.setPatientid(record.getStr("patientID")==null?"无":record.getStr("patientID"));
  40. newreport.setPatientSex(record.getStr("genderID")==null?"未设置":record.getStr("genderID"));
  41. newreport.setPatientAge(record.getStr("patientage"));
  42. newreport.setExamDateTime(record.getStr("reportDate")==null?"未设置":record.getStr("reportDate"));
  43. newreport.setReportDateTime(record.getStr("reportDate")==null?"未设置":record.getStr("reportDate"));
  44. newreport.setPhone(record.getStr("phone")==null?"未设置":record.getStr("phone"));
  45. newreport.save();
  46. studies2.setModality(record.getStr("modality")==null?record.getStr("modality"):record.getStr("modality"));
  47. studies2.update();
  48. }else {
  49. continue;
  50. }
  51. }
  52. }
  53. @Override
  54. public void stop() {
  55. // TODO Auto-generated method stub
  56. }
  57. }