ltkj-admin/src/main/java/com/ltkj/web/controller/app/ReportController.java
@@ -335,7 +335,6 @@ @ApiOperation(value = "小程序-体检报告查询详情") public AjaxResult getShenGaoTiZhong(@RequestParam @ApiParam(value = "体检号") String tjNumber) { Map<String, Object> objectMap = new HashMap<>(); List<Map<String, Object>> list = new ArrayList<>(); LambdaQueryWrapper<TjOrder> wq1 = new LambdaQueryWrapper<>(); wq1.eq(TjOrder::getTjNumber, tjNumber); wq1.eq(TjOrder::getCheckStatus, 1); @@ -344,62 +343,38 @@ return AjaxResult.success("体检暂未完成!!"); } LambdaQueryWrapper<TjOrderDetail> wq = new LambdaQueryWrapper<>(); wq.eq(TjOrderDetail::getOrderId, one.getOrderId()); wq.in(TjOrderDetail::getProId, "1633660948860522524"); final TjOrderDetail one1 = detailService.getOne(wq); if (one1 == null) { objectMap.put("shenggao", "无"); } else { objectMap.put("shenggao", one1.getProResult()); } List<Map<String, Object>> maps = detailService.getShenGaoTiZhongList(one.getTjNumber()); // if(null !=maps && maps.size()>0){ // for (Map<String, Object> map : maps) { // if (map.get("") == null) { // objectMap.put("shenggao", "无"); // } else { // objectMap.put("shenggao", one1.getProResult()); // } // if (one2 == null) { // objectMap.put("tizhong", "无"); // } else { // objectMap.put("tizhong", one2.getProResult()); // } // if (one3 == null) { // objectMap.put("tizhongzhishu", "无"); // } else { // objectMap.put("tizhongzhishu", one3.getProResult()); // } // if (one4 == null) { // objectMap.put("shousuoya", "无"); // } else { // objectMap.put("shousuoya", one4.getProResult()); // } // if (one5 == null) { // objectMap.put("shuzhangya", "无"); // } else { // objectMap.put("shuzhangya", one5.getProResult()); // } // } // } LambdaQueryWrapper<TjOrderDetail> wq2 = new LambdaQueryWrapper<>(); wq2.eq(TjOrderDetail::getOrderId, one.getOrderId()); wq2.in(TjOrderDetail::getProId, "1633660948860522525"); final TjOrderDetail one2 = detailService.getOne(wq2); if (one2 == null) { objectMap.put("tizhong", "无"); } else { objectMap.put("tizhong", one2.getProResult()); } LambdaQueryWrapper<TjOrderDetail> wq3 = new LambdaQueryWrapper<>(); wq3.eq(TjOrderDetail::getOrderId, one.getOrderId()); wq3.in(TjOrderDetail::getProId, "1633660948860522526"); final TjOrderDetail one3 = detailService.getOne(wq3); if (one3 == null) { objectMap.put("tizhongzhishu", "无"); } else { objectMap.put("tizhongzhishu", one3.getProResult()); } LambdaQueryWrapper<TjOrderDetail> wq4 = new LambdaQueryWrapper<>(); wq4.eq(TjOrderDetail::getOrderId, one.getOrderId()); wq4.in(TjOrderDetail::getProId, "1633660948860522527"); final TjOrderDetail one4 = detailService.getOne(wq4); if (one4 == null) { objectMap.put("shousuoya", "无"); } else { objectMap.put("shousuoya", one4.getProResult()); } LambdaQueryWrapper<TjOrderDetail> wq5 = new LambdaQueryWrapper<>(); wq5.eq(TjOrderDetail::getOrderId, one.getOrderId()); wq5.in(TjOrderDetail::getProId, "1633660948860522528"); final TjOrderDetail one5 = detailService.getOne(wq5); if (one5 == null) { objectMap.put("shuzhangya", "无"); } else { objectMap.put("shuzhangya", one5.getProResult()); } return AjaxResult.success(objectMap); return AjaxResult.success(maps); } ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java
@@ -297,7 +297,7 @@ tjOrder.setConfirmStatus(String.valueOf(status)); if (status == 0) { tjOrder.setStatus(TjConstants.TJ_CHECK); asyncService.updateCheckType(tjNumber); // asyncService.updateCheckType(tjNumber); } else { tjOrder.setStatus(TjConstants.TJ_REFUSED); } @@ -307,8 +307,8 @@ confirmLog.setTjNum(tjNumber); confirmLog.setStatus(status); confirmLogService.save(confirmLog); asyncService.wCScheckSetCustomerLisByRedis(orderService.getCsTjOrderList(tjNumber, 0, null, null, null)); asyncService.yCScheckSetCustomerLisByRedis(orderService.getCsTjOrderList(tjNumber, 1, null, null, null)); // asyncService.wCScheckSetCustomerLisByRedis(orderService.getCsTjOrderList(tjNumber, 0, null, null, null)); // asyncService.yCScheckSetCustomerLisByRedis(orderService.getCsTjOrderList(tjNumber, 1, null, null, null)); return AjaxResult.success("操作成功"); } return AjaxResult.error("操作失败"); ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCustomerController.java
@@ -227,7 +227,7 @@ tjCustomer1.setTjType(tjReservation.getTjType()); tjCustomer1.setCusName(tjReservation.getName()); tjCustomer1.setCusSex(Long.valueOf(tjReservation.getSex())); tjCustomer1.setCusBrithday(tjReservation.getBirthday()); tjCustomer1.setCusBrithday(DateUtil.parse(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()), "yyyy-MM-dd")); tjCustomer1.setCusPhone(tjReservation.getPhoe()); tjCustomer1.setCusEmail(tjReservation.getEmail()); tjCustomer1.setCusAddr(tjReservation.getAddress()); @@ -239,7 +239,33 @@ tjCustomer1.setAgeUnit(tjReservation.getAgeUnit()); tjCustomer1.setCareer(tjReservation.getCareer()); tjCustomer1.setPym(PinyinUtil.getFirstLetter(tjReservation.getName(),"")); tjCustomerService.updateById(tjCustomer1); if (null != key && key.equals("Y")) { AjaxResult result = controller.Outpincreateapply(tjCustomer1); String result1 = getAjaxResult(result); JSONObject object = getJSONObject(result1); String code = object.getStr("ResultCode"); if (code.equals("0")) { JSONArray resultDatass = object.getJSONArray("ResultData"); Map<String, Object> resultData = (Map<String, Object>) resultDatass.get(0); if (null != resultData && resultData.size() > 0) { String pationid = resultData.get("PationId").toString(); if (null != pationid) { tjCustomer1.setPationId(pationid); tjCustomerService.updateById(tjCustomer1); //保存注册入参出参 resultData.put("cardId",pationid); JSONObject object4 = JSONUtil.parseObj(resultData); LambdaQueryWrapper<HisApiConfig> lambdaQueryWrapper = new LambdaQueryWrapper<>(); lambdaQueryWrapper.eq(HisApiConfig::getApiMethod, "Outpincreateapply"); HisApiConfig hisApiConfig = hisApiConfigService.getOne(lambdaQueryWrapper); hisApiGetMethodService.save(object4, "Outpincreateapply", hisApiConfig, JSONUtil.toJsonStr(BeanUtil.beanToMap(tjCustomer1))); } } } }else { tjCustomerService.updateById(tjCustomer1); } tjCustomer1.setTeamNo(tjReservation.getTeamNo()); tjCustomer1.setCompId(tjReservation.getCompanyId()); tjCustomer1.setReservationId(tjReservation.getId()); @@ -251,7 +277,7 @@ tjCustomer.setCusIdcard(tjReservation.getIdCard()); tjCustomer.setCusName(tjReservation.getName()); tjCustomer.setCusSex(Long.valueOf(tjReservation.getSex())); tjCustomer.setCusBrithday(tjReservation.getBirthday()); tjCustomer.setCusBrithday(DateUtil.parse(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()), "yyyy-MM-dd")); tjCustomer.setCusPhone(tjReservation.getPhoe()); tjCustomer.setCusEmail(tjReservation.getEmail()); tjCustomer.setCusAddr(tjReservation.getAddress()); @@ -271,7 +297,6 @@ tjCustomer.setCusPassword(substring); tjCustomer.setTjType(tjReservation.getTjType()); tjCustomer.setPym(PinyinUtil.getFirstLetter(tjReservation.getName(),"")); tjCustomerService.save(tjCustomer); if (null != key && key.equals("Y")) { AjaxResult result = controller.Outpincreateapply(tjCustomer); @@ -285,7 +310,7 @@ String pationid = resultData.get("PationId").toString(); if (null != pationid) { tjCustomer.setPationId(pationid); tjCustomerService.updateById(tjCustomer); tjCustomerService.save(tjCustomer); //保存注册入参出参 resultData.put("cardId",pationid); JSONObject object4 = JSONUtil.parseObj(resultData); @@ -296,6 +321,8 @@ } } } }else { tjCustomerService.save(tjCustomer); } tjCustomer.setTeamNo(tjReservation.getTeamNo()); tjCustomer.setCompId(tjReservation.getCompanyId()); ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjDiscardInspectionController.java
@@ -44,11 +44,11 @@ public TableDataInfo list(TjDiscardInspection tjDiscardInspection) { startPage(); List<TjDiscardInspection> list = tjDiscardInspectionService.selectTjDiscardInspectionList(tjDiscardInspection); if (null != list && list.size() > 0) { for (TjDiscardInspection discardInspection : list) { discardInspection.setCusName(MatchUtils.hideCusName(discardInspection.getCusName())); } } // if (null != list && list.size() > 0) { // for (TjDiscardInspection discardInspection : list) { // discardInspection.setCusName(MatchUtils.hideCusName(discardInspection.getCusName())); // } // } return getDataTable(list); } ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java
@@ -1,6 +1,7 @@ package com.ltkj.hosp.mapper; import java.util.List; import java.util.Map; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ltkj.hosp.domain.TjOrderDetail; @@ -194,4 +195,34 @@ " from tj_order_detail\n" + " where jxbz = #{jxbz}") void deleteTjOrderDetailByjxbz(String jxbz); @Select("SELECT\n" + "\tIFNULL(SUM(CASE WHEN aa.mc LIKE '%身高%' THEN aa.jg END),'无') shenggao,\n" + "\tIFNULL(SUM(CASE WHEN aa.mc LIKE '%体重%' THEN aa.jg END),'无') tizhong,\n" + "\tIFNULL(SUM(CASE WHEN aa.mc LIKE '%指数%' THEN aa.jg END),'无') tizhongzhishu,\n" + "\tIFNULL(SUM(CASE WHEN aa.mc LIKE '%收缩压%' THEN aa.jg END),'无') shousuoya,\n" + "\tIFNULL(SUM(CASE WHEN aa.mc LIKE '%舒张压%' THEN aa.jg END),'无') shuzhangya\n" + "FROM\n" + "\t(\n" + "\tSELECT\n" + "\t\tc.pro_name mc,\n" + "\t\tb.pro_result jg \n" + "\tFROM\n" + "\t\ttj_order a\n" + "\t\tJOIN tj_order_detail b ON a.order_id = b.order_id\n" + "\t\tJOIN tj_project c ON c.pro_id = b.pro_id \n" + "\tWHERE\n" + "\t\ta.tj_number =#{tjNum} \n" + "\t\tAND c.pro_parent_id != 0 \n" + "\t\tAND (\n" + "\t\t\tc.pro_name LIKE '%身高%' \n" + "\t\t\tOR c.pro_name LIKE '%体重%' \n" + "\t\t\tOR c.pro_name LIKE '%指数%' \n" + "\t\t\tOR c.pro_name LIKE '%收缩压%' \n" + "\t\tOR c.pro_name LIKE '%舒张压%' \n" + "\t)) aa ") List<Map<String,Object>> getShenGaoTiZhongList(String tjNum); } ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderDetailService.java
@@ -1,6 +1,7 @@ package com.ltkj.hosp.service; import java.util.List; import java.util.Map; import com.baomidou.mybatisplus.extension.service.IService; import com.ltkj.common.core.domain.entity.SysUser; @@ -111,4 +112,8 @@ List<TjOrderDetail> addHuaYanAndCgTable(String tjnumber); void deleteTjOrderDetailByjxbz(String jxbz); List<Map<String,Object>> getShenGaoTiZhongList(String tjNum); } ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderDetailServiceImpl.java
@@ -1,6 +1,7 @@ package com.ltkj.hosp.service.impl; import java.util.List; import java.util.Map; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ltkj.common.core.domain.entity.SysUser; @@ -184,4 +185,9 @@ tjOrderDetailMapper.deleteTjOrderDetailByjxbz(jxbz); } @Override public List<Map<String, Object>> getShenGaoTiZhongList(String tjNum) { return tjOrderDetailMapper.getShenGaoTiZhongList(tjNum); } }