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 UpdateTask implements ITask { @Override public void run() { // TODO Auto-generated method stub DataService dService = ServiceFactory.getService(DataService.class); JSONArray jsonArray = dService.getExamListConfirmed(10); for (Object object : jsonArray) { try { JSONObject jsonObject = JSON.parseObject(object.toString()); Record record = Db.use("connected").findFirst("select * from examinfo where studyuid=?", jsonObject.getString("studyuid")); if (record == null) { continue; } Map params = new HashMap<>(); params.put("exam_id", jsonObject.getString("id")); //报告医生姓名 params.put("report_doctor_name", ""); //报告时间 params.put("report_datetime", parseStringToDate()); //审核医生姓名 params.put("review_doctor_name", ""); //审核时间 params.put("review_datetime", parseStringToDate()); //确认医生姓名 params.put("confirm_doctor_name", ""); //确认时间 params.put("confirm_datetime", parseStringToDate()); //意见建议 params.put("impression", ""); //影像所见 params.put("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")); //检查结果1阴2阳 params.put("report_result", "0"); //门诊号住院号 params.put("hopitalized_no", ""); ThreadPoolService tService = ServiceFactory.getService(ThreadPoolService.class); tService.execute(() -> { dService.updatePatientInfo(params); }); } catch (Exception e) { // TODO: handle exception continue; } } } @Override public void stop() { // TODO Auto-generated method stub } /** * 日期字符串格式转换 * @param dateStr * @return */ private String parseStringToDate() { SimpleDateFormat sdf= new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Date date = new Date(); String timeString = sdf.format(date); return timeString; } }