From 75605bab29e6e5db93f4ba1f12d9f2fe9015990c Mon Sep 17 00:00:00 2001 From: 赵文轩 <1652863494@qq.com> Date: 星期四, 31 十月 2024 10:04:50 +0800 Subject: [PATCH] 采样登记抽出合并以及确认采样接口 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java index b42e88c..4fcb764 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java @@ -5,6 +5,7 @@ import java.util.Map; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.ltkj.hosp.domain.LtkjJianchajianyanTree; import com.ltkj.hosp.domain.TjCustomer; import com.ltkj.hosp.domain.TjOrder; import com.ltkj.hosp.vodomain.LineChartsVo; @@ -147,6 +148,9 @@ @Select("SELECT * FROM tj_order WHERE tj_number = #{tjNum} AND deleted='0' ") public TjOrder getOrderByTjNum(String tjNum); + @Select("SELECT * FROM tj_order WHERE card_id = #{cardId} AND deleted='0' ") + public TjOrder getOrderByCardId(String cardId); + List<TjOrder> getTjOrderList(@Param("tjNum")String tjNum, @Param("checkStatus")Integer checkStatus, @Param("compId")Long compId, @@ -268,4 +272,14 @@ List<String> getHuoQuBlZlsqdh(@Param("cardId")String cardId,@Param("bldh") String bldh); @Delete("DELETE FROM ltkj_jianchajianyan_tree WHERE card_id=#{cardId} and jxbz=#{bldh} AND type='澶勭疆'") Boolean delHuoQuZlsqdh(@Param("cardId")String cardId,@Param("bldh") String bldh); + + + List<List<?>> getgetBghsList(Map<String,Object> map); + + + @Select({"<script>","SELECT * FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} AND a.jxbz IN ","<foreach collection='bldh' item='id' open='(' separator=',' close=')'>", + "#{id}", + "</foreach>", + "</script>" }) + List<LtkjJianchajianyanTree> getBuLuXmXinXi(@Param("bldh") List<String> bldh,@Param("cardId")String cardId); } -- Gitblit v1.8.0