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.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(80); for (Object object : jsonArray) { JSONObject jsonObject = JSON.parseObject(object.toString()); Record record = Db.use("connected").findFirst("select * from reportinfo where studyuid=?", jsonObject.getString("studyuid")); if (record == null) { continue; } if (record.getStr("impression") == null && record.getStr("description") == null) { continue; } Map params = new HashMap<>(); params.put("exam_id", 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("reportdoctor"):""); //审核时间 params.put("review_datetime", record.getStr("reviewdate")); //确认医生姓名 params.put("confirm_doctor_name", record.getStr("reviewdoctor")==null?record.getStr("reportdoctor"):""); //确认时间 params.put("confirm_datetime", record.getStr("reviewdate")); //意见建议 params.put("impression", record.getStr("impression")); //影像所见 params.put("description", record.getStr("description")); //exams表 //申请科室 params.put("application_department", record.getStr("department")); //申请医生 params.put("application_doctor", record.getStr("clinicaldoctor")); //临床诊断 params.put("clin_diag", record.getStr("diagnosis")); //症状 params.put("clin_symp", record.getStr("symptom")); //patient_infos表 //患者姓名 params.put("name", record.getStr("patientname")); //患者手机号 params.put("phone", record.getStr("phone")); //患者身份证号 params.put("card_num", record.getStr("idcard")==null?"":record.getStr("idcard")); //检查结果1阴2阳 params.put("report_result", record.getStr("result").contains("阳")?"2":"1"); //门诊号住院号 params.put("hopitalized_no", record.getStr("inPatientNum")==null?"":record.getStr("inPatientNum")); params.put("out_patient", record.getStr("outPatientNum")==null?"":record.getStr("outPatientNum")); //病人ID params.put("his_patient_id", record.getStr("patientNum")); //检查方法 params.put("exam_project", record.getStr("project")); ThreadPoolService tService = ServiceFactory.getService(ThreadPoolService.class); tService.execute(() -> { dService.saveReport(params); }); } } @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; } }