From f77fbfc8c07881f5239ce49b0dc78faaec3628b0 Mon Sep 17 00:00:00 2001
From: eight <641137800@qq.com>
Date: 星期二, 10 十二月 2024 12:09:24 +0800
Subject: [PATCH] Fix Bug: 无预约时间的在预约表会有多条记录

---
 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/appointment/AppointmentServiceImpl.java |  107 +++++++++++++++++++++++++++++++++++++++++------------
 1 files changed, 83 insertions(+), 24 deletions(-)

diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/appointment/AppointmentServiceImpl.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/appointment/AppointmentServiceImpl.java
index fb405e9..525e33b 100644
--- a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/appointment/AppointmentServiceImpl.java
+++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/appointment/AppointmentServiceImpl.java
@@ -3,13 +3,18 @@
 import cn.lihu.jh.framework.common.util.date.DateUtils;
 import cn.lihu.jh.framework.common.util.date.LocalDateTimeUtils;
 import cn.lihu.jh.module.ecg.controller.admin.queue.vo.QueueSaveReqVO;
+import cn.lihu.jh.module.ecg.dal.dataobject.checktype.CheckTypeDO;
+import cn.lihu.jh.module.ecg.dal.dataobject.patient.PatDetails;
+import cn.lihu.jh.module.ecg.dal.dataobject.queue.QueueDO;
 import cn.lihu.jh.module.ecg.feign.RemoteDataService;
 import cn.lihu.jh.module.ecg.feign.RestApiReqBodyVo;
 import cn.lihu.jh.module.ecg.feign.RestApiResult;
 import cn.lihu.jh.module.ecg.feign.dto.AppointmentExternal;
 import cn.lihu.jh.module.ecg.service.config.EcgConfigService;
 import cn.lihu.jh.module.ecg.service.queue.QueueService;
+import cn.lihu.jh.module.ecg.service.queue.QueueServiceTxFunctions;
 import cn.lihu.jh.module.ecg.service.queuesequence.QueueSequenceService;
+import lombok.extern.slf4j.Slf4j;
 import org.springframework.dao.DuplicateKeyException;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
@@ -28,7 +33,10 @@
 import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.util.ArrayList;
+import java.util.HashMap;
 import java.util.List;
+import java.util.Map;
+import java.util.stream.Collectors;
 
 import static cn.lihu.jh.framework.common.exception.util.ServiceExceptionUtil.exception;
 import static cn.lihu.jh.framework.common.pojo.CommonResult.error;
@@ -41,6 +49,7 @@
  */
 @Service
 @Validated
+@Slf4j
 public class AppointmentServiceImpl implements AppointmentService {
 
     @Resource
@@ -64,7 +73,6 @@
         AppointmentDO appointment = BeanUtils.toBean(createReqVO, AppointmentDO.class);
 
         appointment.setBookTime( LocalDateTime.now() );
-        appointment.setBookSrc( 1 );
 
         try {
             appointmentMapper.insert(appointment);
@@ -104,37 +112,50 @@
         return appointmentMapper.selectById(id);
     }
 
-    // TODO 灏氫笉鏀寔, 涓�浣嶆偅鑰呭綋澶╀袱绉嶆鏌ラ」鐩殑鎯呭喌
     @Override
-    public AppointmentDO getCurAppointmentByPatId(String patId) {
-        List<AppointmentDO> appointmentDOList = appointmentMapper.getCurrentPatId( patId );
-        return 0 == appointmentDOList.size() ? null : appointmentDOList.get(0);
+    public AppointmentDO getCurAppointmentByPatIdAndCheckType(String patId, Integer checkType) {
+        AppointmentDO appointmentDO = appointmentMapper.getByPatAndCheckTypeAndBookDate( patId, checkType, LocalDate.now() );
+        return appointmentDO;
     }
 
     /**
-     * // TODO 灏氫笉鏀寔, 涓�浣嶆偅鑰呭綋澶╀袱绉嶆鏌ラ」鐩殑鎯呭喌
      * @param patCode 缂栧彿 : !!! 涓嶄竴瀹氬氨鏄湰绯荤粺鐨� 鎮h�呯紪鍙�(patID), 鏍规簮鍦ㄤ簬 妫�鏌ュ崟鎵弿鍑烘潵鐨勭紪鍙� 涓嶄竴瀹氭槸 鏈郴缁熺殑 鎮h�呯紪鍙�(patID)
      * @return
      */
     @Override
-    public AppointmentDO queryAndCreateAppointmentByPatId(String patCode) {
-        // 鍏堜粠鍖婚櫌骞冲彴鏌ヨ
+    public List<AppointmentDO> queryAndCreateAppointmentByPatId(String patCode) {
+        // 浠庡尰闄㈠钩鍙版煡璇�
         List<AppointmentDO> appointmentExtermalList = getAppointmentExtermal( patCode );
+
         for ( int appointmentIndex = 0; appointmentIndex < appointmentExtermalList.size(); appointmentIndex++ ) {
             AppointmentDO appointmentExtermal = appointmentExtermalList.get(appointmentIndex);
-            if (null != appointmentExtermal && null != appointmentExtermal.getBookDate() && appointmentExtermal.getBookDate().isEqual(LocalDate.now())) {
-                // 鏌ュ埌褰撳ぉ鐨勯绾﹀悗锛屾煡璇B涓� 鏄惁宸茬粡瀛樺湪
-                AppointmentDO appointmentDO = appointmentMapper.getCurrentByPatAndCheckType(appointmentExtermal.getPatId(), appointmentExtermal.getBookCheckType());
-                if (null == appointmentDO) {
-                    appointmentMapper.insert(appointmentExtermal);
-                    return appointmentExtermal;
-                }
-                return appointmentDO;
+            if (null == appointmentExtermal )
+                continue;
+
+            // 浠嶥B鏌ヨ棰勭害锛屾槸鍚﹀凡缁忓瓨鍦�
+            AppointmentDO appointmentDO = appointmentMapper.getByEpisodeIdAndApplyNo(appointmentExtermal.getEpisodeId(), appointmentExtermal.getApplyNo());
+            if (null == appointmentDO) {
+                appointmentMapper.insert(appointmentExtermal);
+            } else {
+                appointmentExtermal.setId( appointmentDO.getId() ); // 纭繚 杩斿洖鍊煎寘鍚� appointment id
             }
         }
 
-        List<AppointmentDO> appointmentDOList = appointmentMapper.getCurrentPatId( patCode );
-        return 0 == appointmentDOList.size() ? null : appointmentDOList.get(0);
+        // 鏌ヨ[queue琛╙琛ュ厖 book_seq_num 鍒拌繑鍥炲�间腑
+        if (!appointmentExtermalList.isEmpty()) {
+            List<Long> appointIdlist = appointmentExtermalList.stream().map(appointmentDO -> appointmentDO.getId()).toList();
+            List<QueueDO> simpleQueueDOList = queueService.selectBookSeqNumByAppointIdList(appointIdlist);
+            if (!simpleQueueDOList.isEmpty()) {
+                Map<Long, Integer> mapAppointIdVsBookSeqNo = simpleQueueDOList.stream().collect(Collectors.toMap(QueueDO::getAppointId, QueueDO::getBookSeqNum));
+                appointmentExtermalList.forEach(appointmentExterma -> appointmentExterma.setBookSeqNum(mapAppointIdVsBookSeqNo.get(appointmentExterma.getId())));
+            }
+        }
+
+        // 涓嶄粠DB鏌ヨ
+        //List<AppointmentDO> appointmentDOList = appointmentMapper.getCurrentPatId( patCode );
+        //return 0 == appointmentDOList.size() ? null : appointmentDOList.get(0);
+
+        return appointmentExtermalList;
     }
 
     @Override
@@ -163,6 +184,9 @@
             AppointmentExternal appointmentExternal = result.getRow().get( appointIndex );
 
             AppointmentDO appointmentDO = BeanUtils.toBean(appointmentExternal, AppointmentDO.class);
+            appointmentDO.setApplyNo( appointmentExternal.getReqIdeApplyno() );
+            appointmentDO.setEpisodeId( appointmentExternal.getEpisodeID() );
+            appointmentDO.setPatSrc( getCorrespondingPatientSource(appointmentExternal.getAdmTypeCode()) );
             appointmentDO.setPatId(appointmentExternal.getPatientID()); // 鍐呭涓� 韬唤璇佸彿 鎴� 闂ㄨ瘖浣忛櫌鍙�
             appointmentDO.setPatName(appointmentExternal.getPatName());
             appointmentDO.setPatGender(Byte.valueOf(appointmentExternal.getPatgender()));
@@ -175,9 +199,9 @@
             appointmentDO.setPatWardDesc(appointmentExternal.getPatLocWardDesc());
             appointmentDO.setPatMobile(appointmentExternal.getPhone());
             appointmentDO.setPatBedNo(appointmentExternal.getEnBedno());
-            appointmentDO.setBookId(appointmentExternal.getReqIdeApplyno());
             appointmentDO.setBookCheckType(getCorrespondingCheckType(appointmentExternal.getPlanDefItemList().getPlanDefItem().getPlanDefItemcode()));
             appointmentDO.setBookTime(DateUtils.ofUTC(appointmentExternal.getReqAuthoredOn()));  // 寮�鍗曟椂闂�
+            appointmentDO.setBookSrc( 0 );
 
             // 鍏夊紑鍗曠殑鎯呭喌锛屾病鏈夐绾︽椂闂�
             if (null != appointmentExternal.getReqExtBooktime() ) {
@@ -187,8 +211,7 @@
                 appointmentDO.setBookTimeslot((bookStartTime.getHour() * 100 + bookStartTime.getMinute()) * 10000 + bookEndTime.getHour() * 100 + bookEndTime.getMinute());
             }
 
-            appointmentDO.setBookSrc(0);
-            appointmentDO.setPaid(1);
+            appointmentDO.setPaid( 0 );
 
             curAppointDOList.add( appointmentDO );
         }
@@ -203,6 +226,11 @@
         if (null == appointment)
             throw exception(PATIENT_NOT_EXISTS);
 
+        // 鎵嬪姩棰勭害锛岀洿鎺ヨ缃绾︽棩鏈熶负褰撳ぉ
+        if (confirmReqVO.getIsVip() == 1) {
+            appointment.setBookDate( LocalDate.now() );
+        }
+
         if ( !DateUtils.isToday(appointment.getBookDate()) )
             throw exception( APPOINTMENT_NOT_TODAY);
 
@@ -216,17 +244,20 @@
 
         try {
             QueueSaveReqVO queueSaveReqVO = new QueueSaveReqVO();
+            queueSaveReqVO.setApplyNo( appointment.getApplyNo() );
+            queueSaveReqVO.setEpisodeId( appointment.getEpisodeId() );
+            queueSaveReqVO.setAppointId(appointment.getId());
             queueSaveReqVO.setPatId(appointment.getPatId());
             queueSaveReqVO.setPatName(appointment.getPatName());
             queueSaveReqVO.setPatGender(appointment.getPatGender());
             queueSaveReqVO.setBookDate(appointment.getBookDate());
-            queueSaveReqVO.setBookTimeslot(appointment.getBookTimeslot());
+            queueSaveReqVO.setBookTimeslot( confirmReqVO.getBookTimeslot() ); /*appointment.getBookTimeslot()*/
             queueSaveReqVO.setBookCheckType(appointment.getBookCheckType());
             queueSaveReqVO.setBookSeqNum( newSeqNo );
             queueSaveReqVO.setIsVip( confirmReqVO.getIsVip() );
             queueSaveReqVO.setPassed((byte) 0);
             queueSaveReqVO.setExpired((byte) 0);
-            queueSaveReqVO.setPatDetails( appointment.getPatDeptDesc() + "-" + appointment.getPatWardDesc() + "-" + appointment.getPatBedNo());
+            queueSaveReqVO.setPatDetails( getPatDetails(appointment) );
             queueService.queue(queueSaveReqVO);
         } catch (DuplicateKeyException duplicateKeyException) {
             throw exception(APPOINTMENT_HAVE_QUEUED);
@@ -269,4 +300,32 @@
 
         return 100;
     }
-}
\ No newline at end of file
+
+    private Integer getCorrespondingPatientSource(String admTypeCode) {
+        if (admTypeCode.equals("AMB"))
+            return 1;
+        else if (admTypeCode.equals("EMER"))
+            return 2;
+        else if (admTypeCode.equals("IMP"))
+            return 3;
+        else if (admTypeCode.equals("PHY"))
+            return 4;
+
+        return 0;
+    }
+
+    private PatDetails getPatDetails(AppointmentDO appointment) {
+        PatDetails patDetails = new PatDetails();
+        patDetails.setId( appointment.getPatId() );
+        patDetails.setName( appointment.getPatName() );
+        patDetails.setMobile( appointment.getPatMobile() );
+        patDetails.setDeptCode( appointment.getPatDeptCode() );
+        patDetails.setDeptDesc( appointment.getPatDeptDesc() );
+        patDetails.setWardCode( appointment.getPatWardCode() );
+        patDetails.setWardDesc( appointment.getPatWardDesc() );
+        patDetails.setBedNo( appointment.getPatBedNo() );
+        patDetails.setSource( appointment.getPatSrc() );
+        return patDetails;
+    }
+}
+

--
Gitblit v1.9.3