package com.zskk.task; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.HashMap; import java.util.Map; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.jfinal.kit.PropKit; import com.jfinal.plugin.activerecord.Db; import com.jfinal.plugin.activerecord.Record; import com.jfinal.plugin.cron4j.ITask; import com.zskk.service.DataService; import com.zskk.service.ServiceFactory; import com.zskk.service.ThreadPoolService; public class DataTask implements ITask { @Override public void run() { // TODO Auto-generated method stub DataService dService = ServiceFactory.getService(DataService.class); JSONArray jsonArray = dService.getExamList(50); for (Object object : jsonArray) { try { JSONObject jsonObject = JSON.parseObject(object.toString()); Record record = Db.use("connected").findFirst("select * from zskk_reportinfo_1 where ACCESSIONNUMBER=?", jsonObject.getString("patient_num")); if (record == null) { continue; } if (record.getStr("IMPRESSION").isBlank() && record.getStr("DESCRIPTION").isBlank()) { continue; } Map params = new HashMap<>(); params.put("type", "1"); params.put("institution_id", PropKit.get("institution_id")); params.put("code", jsonObject.getString("id")); // 报告医生姓名 params.put("report_doctor_name", record.getStr("REPORTDOCTOR")); // 报告时间 params.put("report_datetime", record.getStr("REPORTDATE")); // 审核医生姓名 params.put("review_doctor_name", record.getStr("REVIEWDOCTOR") == null ? "" : record.getStr("REVIEWDOCTOR")); // 审核时间 params.put("review_datetime", record.getStr("REPORTDATE")); // 确认医生姓名 params.put("confirm_doctor_name", record.getStr("REVIEWDOCTOR") == null ? "" : record.getStr("REVIEWDOCTOR")); // 确认时间 params.put("confirm_datetime", record.getStr("REPORTDATE")); // 意见建议 params.put("impression", record.getStr("IMPRESSION")); // 影像所见 params.put("description", record.getStr("DESCRIPTION")); // exams表 // 申请科室 params.put("application_department", record.getStr("DEPATMENT")); // 申请医生 params.put("application_doctor", record.getStr("CLINICALDOCTOR")); // 临床诊断 params.put("clin_diag", ""); // 症状 params.put("clin_symp", record.getStr("SYMPOM") == null ? "" : record.getStr("SYMPOM")); // patient_infos表 // 患者姓名 params.put("name", record.getStr("PATIENTNAME")); // 患者手机号 params.put("phone", record.getStr("PHONE") == null ? "" : record.getStr("PHONE")); // 患者身份证号 params.put("card_num", record.getStr("IDCARD") == null ? "" : record.getStr("IDCARD")); // 检查结果1阴2阳 params.put("report_result", "0"); // 门诊号住院号 // params.put("hopitalized_no", record.getStr("HOPITALIZED_NO")==null?"":record.getStr("HOPITALIZED_NO")); // 门诊号 // params.put("out_patient", record.getStr("PAT_NO")==null?"":record.getStr("PAT_NO")); // 病人ID params.put("his_patient_id", record.getStr("PATIENTID") == null ? "" : record.getStr("PATIENTID")); // 检查方法 // params.put("exam_project", record.getStr("patientNumber")); ThreadPoolService tService = ServiceFactory.getService(ThreadPoolService.class); tService.execute(() -> { dService.saveReport(params); }); } catch (Exception e) { // TODO: handle exception continue; } } } @Override public void stop() { // TODO Auto-generated method stub } /** * 日期字符串格式转换 * * @param dateStr * @return */ private String parseStringToDate(String dateStr) { if (dateStr == null) { return ""; } SimpleDateFormat sdf = new SimpleDateFormat("yyyy.MM.dd HH:mm:ss"); Date date = null; String timeString = null; try { date = sdf.parse(dateStr); SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); timeString = sdf2.format(date); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } return timeString; } }