From 26c801991efedbd692ace4add657823594ff5455 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 23 七月 2024 18:02:40 +0800
Subject: [PATCH] zjh 2024/07/23-1

---
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReportController.java           |   31 +---------
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java                      |    3 +
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java            |   10 ++
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java            |   27 +++++---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjJianchajianyanTreeMapper.java            |    3 
 ltkj-admin/src/main/resources/application.yml                                             |    2 
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java              |    5 +
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java                     |    3 +
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java                         |    6 ++
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcbgdServiceImpl.java          |    5 +
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcbgdService.java                   |    2 
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java                     |    4 
 ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisPDFUtil.java                      |   70 +++++++++++++++++++++++
 ltkj-framework/src/main/java/com/ltkj/framework/web/exception/GlobalExceptionHandler.java |    7 +-
 14 files changed, 130 insertions(+), 48 deletions(-)

diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisPDFUtil.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisPDFUtil.java
index c9518ba..1315849 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisPDFUtil.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisPDFUtil.java
@@ -14,6 +14,7 @@
 import com.ltkj.hosp.domain.*;
 import com.ltkj.hosp.mapper.DictUserInfoMapper;
 import com.ltkj.hosp.service.*;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
 import com.ltkj.hosp.sqlDomain.LtkjHybgd;
 import com.ltkj.hosp.sqlDomain.LtkjHysqd;
 import com.ltkj.system.service.ISysConfigService;
@@ -24,6 +25,7 @@
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Component;
 
+import javax.annotation.Resource;
 import java.io.*;
 import java.lang.reflect.Field;
 import java.lang.reflect.InvocationTargetException;
@@ -74,6 +76,10 @@
     private DictUserInfoMapper dictUserInfoMapper;
     @Autowired
     private ISysConfigService sysConfigService;
+    @Resource
+    private LtkjExamJcbgdService jcbgdService;
+    @Resource
+    private LtkjExamJcsqdService jcsqdService;
 
     private List<Map<String, Object>> makePDFInfo(HashMap<String, Object> map, AjaxResult ajaxResult, String key) {
         List<Map<String, Object>> data = null;
@@ -127,7 +133,10 @@
         // 缁勮妫�楠屾暟鎹�
         HashMap<String, Object> map = makeHisJianYan(tjOrder, customer);
         makeHisJianYanTable(document1, map);
+
+
         List<ByteArrayOutputStream> jianchas = makeHisJianChaTable(tjOrder);
+//        List<ByteArrayOutputStream> jianchas = makeCcgcHisJianChaTable(tjOrder);
         document1.close();
         pdfWriter.close();
         PdfReader reader = null;
@@ -273,6 +282,67 @@
         return jianchas;
     }
 
+
+    /**
+     * 鐢熸垚妫�鏌ヨ〃鏍煎瓨鍌ㄨ繃绋嬫椂鐢�
+     *
+     * @param tjOrder
+     * @return
+     */
+    private List<ByteArrayOutputStream> makeCcgcHisJianChaTable(TjOrder tjOrder) throws Exception {
+
+        TjCustomer customer = tjCustomerService.getById(tjOrder.getUserId());
+
+       List<LtkjExamJcbgd> list=jcbgdService.getJianJcBaoGaoDanByTjh(tjOrder.getCardId());
+
+        List<ByteArrayOutputStream> jianchas = new ArrayList<>();
+        Paragraph elements = new Paragraph();
+        elements.setLeading(5f);
+        elements.setSpacingBefore(10f);
+        elements.setSpacingAfter(10f);
+        elements.setAlignment(Element.ALIGN_RIGHT);
+
+        for (LtkjExamJcbgd getexamreportinfo : list) {
+            String xm = customer.getCusName();
+            String xb = customer.getCusSex()==2 ? "濂�" : "鐢�";
+            String nl = customer.getAge();
+            String jcks = "浣撴涓績";
+            String sjks = "";
+            String jcsb = "";
+            String jch = getexamreportinfo.getTmh();
+            String jcxm = getexamreportinfo.getXmmc();
+            String ms = getexamreportinfo.getYxbx();
+            String ts = getexamreportinfo.getYxzd();
+            String bgysqm = getexamreportinfo.getShysxm();
+            String shysqm = getexamreportinfo.getShysdm();
+            String sqrxm = "鐜嬪仴钀�";
+            String zyh = "";
+            String ch = "";
+            String jcysqm = getexamreportinfo.getShysdm();
+            StringBuilder builder;
+            String footer;
+            builder = new StringBuilder();
+            if (null != sqrxm && StrUtil.isNotBlank(sqrxm)){
+                builder.append("鐢宠浜猴細").append(sqrxm);
+            }
+            if (null != jcysqm && StrUtil.isNotBlank(jcysqm)){
+                builder.append("     妫�鏌ュ尰甯堬細").append(jcysqm);
+            }
+            if (null != shysqm && StrUtil.isNotBlank(shysqm)){
+                builder.append("     瀹℃牳鍖诲笀锛�").append(shysqm);
+            }
+            if (null != bgysqm && StrUtil.isNotBlank(bgysqm)){
+                builder.append("     鎶ュ憡鍖诲笀锛�").append(bgysqm);
+            }
+            footer = builder.toString().trim();
+            ByteArrayOutputStream outputStream = makeJcPDFByteArrayStream(xm, xb, nl, jcks, zyh, ch, sjks, jcsb, jch, jcxm, ms, ts, null, footer,elements);
+            if (outputStream == null)
+                throw new Exception();
+            jianchas.add(outputStream);
+        }
+        return jianchas;
+    }
+
     /**
      * 鍖诲笀淇℃伅琛�
      * @param phrase
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java
index f66af80..34766c9 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java
@@ -110,7 +110,8 @@
     private HisApiMethodService controller;
     @Autowired
     private HisApiGetMethodService service;
-
+    @Autowired
+    private HisApiConfigService hisApiConfigService;
 
     @GetMapping ("/getOperationPermissionsByTjNum")
     @ApiOperation (value = "(鍒濆椤甸潰  鍜� 鍖荤敓椤甸潰)鏍规嵁浣撴鍙疯幏鍙栨槸鍚﹀彲鎿嶄綔鏉冮檺鎺ュ彛  true鍙搷浣�  鍙嶄箣涓嶅彲")
@@ -474,12 +475,16 @@
 
                     /*鍚屾妫�鏌� his鎺ュ彛*/
 
-//                    Map<String, Object> maps = new HashMap<>();
-//                    maps.put("his_registration_id", order.getCardId());
-//                    maps.put("ksbm", "浣撴涓績");
-//                    maps.put("pagecount", 100);
-//                    maps.put("page", 1);
+                    Map<String, Object> maps = new HashMap<>();
+                    maps.put("his_registration_id", order.getCardId());
+                    maps.put("ksbm", "浣撴涓績");
+                    maps.put("pagecount", 100);
+                    maps.put("page", 1);
 //                    AjaxResult results = service.getHISDataNew("Getexamreportinfo", maps);
+
+                    LambdaQueryWrapper<HisApiConfig> lambdaQueryWrapper = new LambdaQueryWrapper<>();
+                    lambdaQueryWrapper.eq(HisApiConfig::getApiMethod, "Getexamreportinfo");
+                    HisApiConfig hisApiConfig = hisApiConfigService.getOne(lambdaQueryWrapper);
 
 
                     /*鍚屾妫�鏌� his瀛樺偍杩囩▼*/
@@ -494,11 +499,11 @@
                             jcsqdService.deletedLtkjJcsqdByTjhAndTmh(order.getCardId());
                             jcbgdService.deletedLtkjJcbgdByTjhAndTmh(order.getCardId());
                             for (Map<String, Object> objectMap : datas) {
-//                                LtkjExamJcsqd jybgid = jcsqdService.getLtkjJcsqdByTjhAndTmh(order.getCardId(), objectMap.get("JCBGID").toString());
-//                                if (null != jybgid) {
-//                                    jcsqdService.deletedLtkjJcsqdByTjhAndTmh(order.getCardId(), objectMap.get("JCBGID").toString());
-//                                    jcbgdService.deletedLtkjJcbgdByTjhAndTmh(jybgid.getTmh());
-//                                }
+                                //淇濆瓨鍏ュ弬鍑哄弬
+//                                service.save((JSONObject)objectMap,"Getexamreportinfo",hisApiConfig,JSONUtil.toJsonStr(maps));
+                                service.save(JSONUtil.parseObj(objectMap),"Getexamreportinfo",hisApiConfig,JSONUtil.toJsonStr(maps));
+
+
                                 LtkjExamJcbgd jcbgd=new LtkjExamJcbgd();
                                 jcbgd.setTjh(order.getCardId());
                                 if(null !=objectMap.get("JCBGID") || !objectMap.get("JCBGID").equals(""))
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java
index 65fc1f7..d63f658 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java
@@ -386,6 +386,7 @@
                                    @ApiParam (value = "鏄剧ず鏉℃暟(榛樿10)") @RequestParam (defaultValue = "10") Integer pageSize,
                                    @ApiParam (value = "浣撴鍙�)") @RequestParam (required = false) String tjNum,
                                    @ApiParam (value = "濮撳悕)") @RequestParam (required = false) String name,
+                                   @ApiParam (value = "椤圭洰鍚�)") @RequestParam (required = false) String xmmc,
                                    @ApiParam (value = "鐧昏寮�濮嬫椂闂�") @RequestParam (required = false) Date djbeginTime,
                                    @ApiParam (value = "鐧昏缁撴潫鏃堕棿") @RequestParam (required = false) Date djendTime,
                                    @ApiParam (value = "鎶ュ憡寮�濮嬫椂闂�") @RequestParam (required = false) Date bgbeginTime,
@@ -459,6 +460,12 @@
         if (null != tjNum) {
             wq.eq(TjOrder::getTjNumber, tjNum);
         }
+
+
+        if (null != xmmc) {
+            wq.in(TjOrder::getTjNumber, projectService.getTjNumLIstByXmmx(xmmc));
+        }
+
         wq.orderByDesc(TjOrder::getCreateTime);
         Page<TjOrder> page2 = tjOrderService.page(page1, wq);
         List<TjOrder> list = page2.getRecords();
@@ -470,7 +477,6 @@
                     order.setTjCustomerAge(DateUtil.ageOfNow(tjCustomer.getCusBrithday()));
                     order.setTjCustomerName(tjCustomer.getCusName());
                     order.setTjCustomerPhone(tjCustomer.getCusPhone());
-//                    order.setTjCusIdCard(MatchUtils.hideIdCardNum(tjCustomer.getCusIdcard()));
                     order.setTjCusIdCard(tjCustomer.getCusIdcard());
                     order.setCareer(tjCustomer.getCareer());
                     order.setIdType(tjCustomer.getIdType());
@@ -484,7 +490,7 @@
                 if (null != order.getPacId()) {
                     if (null != tjPackageService.getById(order.getPacId())) {
                         order.setPacName(tjPackageService.getById(order.getPacId()).getPacName());
-                    }
+                    }else
                     if (null != dwDeptService.getById(order.getPacId())) {
                         order.setPacName(dwDeptService.getById(order.getPacId()).getDwDeptName());
                     }
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReportController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReportController.java
index e95577f..5a847c7 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReportController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjReportController.java
@@ -96,7 +96,6 @@
     private ISysDictDataService dictDataService;
     @Resource
     private ITbTransitionService transitionService;
-
     @Autowired
     private ITjBigPositiveService tjBigPositiveService;
     @Autowired
@@ -420,8 +419,7 @@
         return AjaxResult.error();
     }
 
-    @Autowired
-    private TjReportController tjReportController;
+
 
     /**
      * 鎾ら攢
@@ -1466,34 +1464,11 @@
         //鍒涘缓map 閿负鐖堕」鐩�  鍊间负瀛愰」鐩泦鍚�
         Map<TjOrderRemark, List<TjPdfVO>> printReport = new LinkedHashMap<>();
         //鏌ュ埌璇ュ鎴风殑浣撴璁板綍
-//        LambdaQueryWrapper<TjOrder> wq1 = new LambdaQueryWrapper<>();
-//        wq1.eq(TjOrder::getTjNumber, tjNumber);
-//        TjOrder one = tjOrderService.getOne(wq1);
 
         //鎷垮埌浣撴璁板綍鐨刼rderid锛屾煡鍑洪」鐩缁嗕俊鎭�
-//        LambdaQueryWrapper<TjOrderDetail> wq = new LambdaQueryWrapper<>();
-//        wq.eq(TjOrderDetail::getOrderId, one.getOrderId());
-//        //20230323鍒ゆ柇椤圭洰宸叉
-//        wq.ne(TjOrderDetail::getTjStatus, 0);
-//        wq.eq(TjOrderDetail::getProId,projectService.getHuaYanProId());
-//        List<TjOrderDetail> tjOrderDetails = tjOrderDetailService.list(wq);
-        List<TjOrderDetail> tjOrderDetails = tjOrderDetailService.addHuaYanAndCgTable(tjNumber);
-        //閬嶅巻浣撴璁板綍 灏嗛」鐩殑鍏蜂綋淇℃伅
-        //閬嶅巻瀹㈡埛鎵�閫夌殑椤圭洰(鍖呭惈瀛愰」鐖堕」)
-//        for (TjOrderDetail tjOrderDetail : tjOrderDetails) {
-//            TjProject tjProject = projectService.getById(tjOrderDetail.getProId());
-//            if (null != tjProject) {
-//                tjOrderDetail.setProject(tjProject);
-//            }
-//        }
 
-//        LambdaQueryWrapper<TjCustomer> wq22 = new LambdaQueryWrapper<>();
-//        wq22.eq(TjCustomer::getCusId, one.getUserId());
-//        TjCustomer customer = tjCustomerService.getOne(wq22);
-//        LambdaQueryWrapper<TjOrderRemark> wqq = new LambdaQueryWrapper<>();
-//        wqq.eq(TjOrderRemark::getTjNumber, tjNumber);
-//        wqq.eq(TjOrderRemark::getDeptId,"241");
-//        List<TjOrderRemark> tjOrderRemarks = tjOrderRemarkService.list(wqq);
+        List<TjOrderDetail> tjOrderDetails = tjOrderDetailService.addHuaYanAndCgTable(tjNumber);
+
         List<TjOrderRemark> tjOrderRemarks = tjOrderRemarkService.addHuaYanAndCgTable(tjNumber);
         for (TjOrderRemark tjOrderRemark : tjOrderRemarks) {
             printReport.put(tjOrderRemark, null);
diff --git a/ltkj-admin/src/main/resources/application.yml b/ltkj-admin/src/main/resources/application.yml
index 343d3cf..967aa1c 100644
--- a/ltkj-admin/src/main/resources/application.yml
+++ b/ltkj-admin/src/main/resources/application.yml
@@ -5,4 +5,4 @@
 #xiaochengxu 娉惧窛鍘块儴缃插皬绋嬪簭鐜浣跨敤
 spring:
   profiles:
-    active: prod
\ No newline at end of file
+    active: dev
\ No newline at end of file
diff --git a/ltkj-framework/src/main/java/com/ltkj/framework/web/exception/GlobalExceptionHandler.java b/ltkj-framework/src/main/java/com/ltkj/framework/web/exception/GlobalExceptionHandler.java
index 3eb24be..dd5acd0 100644
--- a/ltkj-framework/src/main/java/com/ltkj/framework/web/exception/GlobalExceptionHandler.java
+++ b/ltkj-framework/src/main/java/com/ltkj/framework/web/exception/GlobalExceptionHandler.java
@@ -53,7 +53,8 @@
     public AjaxResult handleServiceException(ServiceException e, HttpServletRequest request) {
         log.error(e.getMessage(), e);
         Integer code = e.getCode();
-        return StringUtils.isNotNull(code) ? AjaxResult.error(code, e.getMessage()) : AjaxResult.error(e.getMessage());
+//        return StringUtils.isNotNull(code) ? AjaxResult.error(code, e.getMessage()) : AjaxResult.error(e.getMessage());
+        return AjaxResult.error("鏁版嵁澶勭悊寮傚父锛岃鑱旂郴绠$悊鍛�!");
     }
 
     /**
@@ -63,7 +64,7 @@
     public AjaxResult handleRuntimeException(RuntimeException e, HttpServletRequest request) {
         String requestURI = request.getRequestURI();
         log.error("璇锋眰鍦板潃'{}',鍙戠敓鏈煡寮傚父.", requestURI, e);
-        return AjaxResult.error(e.getMessage());
+        return AjaxResult.error("鏁版嵁澶勭悊寮傚父锛岃鑱旂郴绠$悊鍛�!");
     }
 
     /**
@@ -73,7 +74,7 @@
     public AjaxResult handleException(Exception e, HttpServletRequest request) {
         String requestURI = request.getRequestURI();
         log.error("璇锋眰鍦板潃'{}',鍙戠敓绯荤粺寮傚父.", requestURI, e);
-        return AjaxResult.error(e.getMessage());
+        return AjaxResult.error("鏁版嵁澶勭悊寮傚父锛岃鑱旂郴绠$悊鍛�!");
     }
 
     /**
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java
index 3caa03c..9d0812d 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java
@@ -28,4 +28,7 @@
 
     @Select("SELECT * FROM ltkj_exam_jcbgd WHERE tmh=#{tmh} GROUP BY xmmc ")
     List<LtkjExamJcbgd> getJianJcBaoGaoDanList(String tmh);
+
+@Select("SELECT * FROM ltkj_exam_jcbgd WHERE tjh=#{cardId}")
+    List<LtkjExamJcbgd> getJianJcBaoGaoDanByTjh(String cardId);
 }
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjJianchajianyanTreeMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjJianchajianyanTreeMapper.java
index fbcd1bd..5b0fd25 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjJianchajianyanTreeMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjJianchajianyanTreeMapper.java
@@ -23,7 +23,8 @@
     @Select("SELECT COUNT(zb.sqdh) sfjf FROM (\n" +
             "SELECT aa.sqdh,SUM(aa.fyhj) hj FROM (\n" +
             "SELECT DISTINCT a.sqdh,  a.fyhj FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId}) aa  GROUP BY aa.sqdh) zb\n" +
-            "LEFT JOIN   ( SELECT a.adv_id ,SUM(a.catefee) hj FROM ltkj_querypay a WHERE a.ghxh=#{cardId} GROUP BY a.adv_id) cb ON\n" +
+            "LEFT JOIN   ( SELECT a.adv_id ,SUM(a.catefee) hj FROM ltkj_querypay a WHERE a.ghxh=#{cardId} GROUP BY" +
+            " CASE WHEN a.adv_id IS NOT NULL AND LOCATE( '_', a.adv_id )> 0 THEN SUBSTRING_INDEX( a.adv_id, '_',- 1 ) ELSE a.adv_id END) cb ON\n" +
             "\t\tzb.sqdh=(case when cb.adv_id is not null and LOCATE('_',cb.adv_id)>0 then SUBSTRING_INDEX(cb.adv_id,'_',-1) else cb.adv_id end) \n" +
             "WHERE  zb.hj <> cb.hj or cb.adv_id is null;")
     int getSfsfByCardId(String cardId);
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
index 7632d10..3c8526c 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
@@ -125,8 +125,8 @@
             "\tLEFT JOIN tj_project pro ON re.pro_id = pro.pro_id\n" +
             "\tLEFT JOIN sys_user us ON us.user_id = re.doctor_name \n" +
             "WHERE\n" +
-            "\tre.type != 2  \n" +//and pro.need_report='Y'
-            "\tAND re.tj_number =#{tjNumber}")
+            "re.type != 2  \n" +//and pro.need_report='Y'
+            "AND re.tj_number =#{tjNumber}")
     List<CsProVo> cSWebGetProByTjNumAndOrderId(String tjNumber);
 
 
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java
index 82aaf00..956d744 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java
@@ -173,4 +173,10 @@
     @Select("SELECT * FROM tj_project WHERE pro_parent_id=#{proParentId} AND deleted='0' and pro_id in" +
             " (SELECT a.pro_id FROM tb_transition a WHERE a.tj_num=#{tjNumber}) ")
     List<TjProject> getTjProjectListByTbTransition(@Param("proParentId") String proParentId,@Param("tjNumber")String tjNumber);
+
+
+    @Select("SELECT b.tj_number FROM tj_order_remark b WHERE b.deleted=0 AND b.pro_id IN(\n" +
+            "\n" +
+            "SELECT a.pro_id FROM tj_project a WHERE a.deleted=0 AND a.pro_status=0 AND LOCATE(#{xmmc},a.pro_name) ) GROUP BY b.tj_number")
+    List<String> getTjNumLIstByXmmx(String xmmc);
 }
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java
index 94bc5bf..5edf9cc 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java
@@ -128,4 +128,7 @@
 
 
     List<TjProject> getTjProjectListByTbTransition(String proParentId, String tjNumber);
+
+    //鏍规嵁椤圭洰鍚嶆ā绯婃悳绱綋妫�鍙�
+    List<String> getTjNumLIstByXmmx(String xmmc);
 }
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcbgdService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcbgdService.java
index ba9df46..0d2f330 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcbgdService.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcbgdService.java
@@ -20,4 +20,6 @@
     List<String> getJianJcBaoGaoDan(String cardId);
 
     List<LtkjExamJcbgd> getJianJcBaoGaoDanList(String tmh);
+
+    List<LtkjExamJcbgd> getJianJcBaoGaoDanByTjh(String cardId);
 }
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcbgdServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcbgdServiceImpl.java
index 7f5996c..215f935 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcbgdServiceImpl.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcbgdServiceImpl.java
@@ -39,4 +39,9 @@
     public List<LtkjExamJcbgd> getJianJcBaoGaoDanList(String tmh) {
         return mapper.getJianJcBaoGaoDanList(tmh);
     }
+
+    @Override
+    public List<LtkjExamJcbgd> getJianJcBaoGaoDanByTjh(String cardId) {
+        return mapper.getJianJcBaoGaoDanByTjh(cardId);
+    }
 }
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java
index fdd92c5..f212620 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java
@@ -251,6 +251,11 @@
         return tjProjectMapper.getTjProjectListByTbTransition(proParentId,tjNumber);
     }
 
+    @Override
+    public List<String> getTjNumLIstByXmmx(String xmmc) {
+        return tjProjectMapper.getTjNumLIstByXmmx(xmmc);
+    }
+
     /**
      * 閫掑綊鍒楄〃
      */

--
Gitblit v1.8.0