From 91b430242c65f742ac06313bff34b6d9ec97ce50 Mon Sep 17 00:00:00 2001
From: 赵文轩 <1652863494@qq.com>
Date: 星期二, 29 十月 2024 11:43:53 +0800
Subject: [PATCH] 错误收费金额修改
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 97 ++++++++++++++++++++++++++++++++++++++----------
1 files changed, 76 insertions(+), 21 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 6f92c49..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,9 +5,11 @@
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;
+import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@@ -108,27 +110,31 @@
// List<Map<Object, Object>> getLine();
@Select("select aa.date,\n" +
- " sum(if(c.tj_type='鍥㈤槦', ifnull(c.coun,0),0)) as tdcoun,\n" +
- " sum(if(c.tj_type='涓汉', ifnull(c.coun,0),0)) as grcoun,\n" +
- " sum(if(c.tj_type='鎶ュ憡', ifnull(c.coun,0),0)) as bgcoun \n" +
- " from (\n" +
- " SELECT date_sub(CURDATE(),interval @i:=@i+1 day) as date\n" +
- " from (select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all \n" +
- " select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all \n" +
- " select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all \n" +
- " select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all \n" +
- " select 1 union all select 1) as a,\n" +
- " (select @i:= -1) b) aa \n" +
- " left join (\n" +
- " select date_format(create_time, '%Y-%m-%d') dat, tj_type, count(*) coun\n" +
- " from tj_order where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(create_time)\n" +
- " group by date_format(create_time, '%Y-%m-%d'),tj_type\n" +
- " union\n" +
- " select date_format(report_time, '%Y-%m-%d') dat, '鎶ュ憡' tj_type, count(*) coun\n" +
- " from tj_order where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(create_time)\n" +
- " group by date_format(report_time, '%Y-%m-%d')\n" +
- " ) c on c.dat =aa.date\n" +
- "group by aa.date")
+ " sum(if(c.tj_type='1', ifnull(c.coun,0),0)) as tdcoun,\n" +
+ " sum(if(c.tj_type='2', ifnull(c.coun,0),0)) as grcoun,\n" +
+ " sum(if(c.tj_type='3', ifnull(c.coun,0),0)) as bgcoun \n" +
+ " from (\n" +
+ " SELECT date_sub(CURDATE(),interval @i:=@i+1 day) as date\n" +
+ " from (select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all \n" +
+ " select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all \n" +
+ " select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all \n" +
+ " select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all \n" +
+ " select 1 union all select 1) as a,\n" +
+ " (select @i:= -1) b) aa\n" +
+ " left join (\n" +
+ " select date_format(create_time, '%Y-%m-%d') dat, tj_type, count(*) coun\n" +
+ " from tj_order where deleted=0 AND tj_type=2 AND DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(create_time)\n" +
+ " group by date_format(create_time, '%Y-%m-%d')\t\n" +
+ "\t\t\t\tunion\n" +
+ " select date_format(create_time, '%Y-%m-%d') dat,tj_type, count(*) coun\n" +
+ " from tj_order where deleted=0 AND tj_type=1 AND DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(create_time)\n" +
+ " group by date_format(create_time, '%Y-%m-%d')\t\t\t\t\t\n" +
+ "\t\t\t\tunion\n" +
+ " select date_format(create_time, '%Y-%m-%d') dat, 3 tj_type, count(*) coun\n" +
+ " from tj_order where deleted=0 AND !ISNULL(report_time) AND DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(create_time)\n" +
+ " group by date_format(create_time, '%Y-%m-%d')\n" +
+ " ) c on c.dat =aa.date\n" +
+ " group by aa.date")
List<LineChartsVo> getLine();
@@ -141,6 +147,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,
@@ -227,4 +236,50 @@
" left join dict_comp d on d.drug_manufacturer_id = c.firm_id\n" +
"where c.tj_number=#{tjNumber}")
Map<String ,Object > selectDjdUserInfo(@Param("tjNumber")String tjNumber);
+
+
+ @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} AND a.type='妫�鏌�' GROUP BY a.sqdh")
+ List<String> getHuoQuJcsqdh(String cardId);
+ @Delete("DELETE FROM ltkj_jianchajianyan_tree WHERE card_id=#{cardId} AND type='妫�鏌�'")
+ Boolean delHuoQuJcsqdh(String cardId);
+
+
+
+ @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} AND a.type='妫�楠�' GROUP BY a.sqdh")
+ List<String> getHuoQuJysqdh(String cardId);
+ @Delete("DELETE FROM ltkj_jianchajianyan_tree WHERE card_id=#{cardId} AND type='妫�楠�'")
+ Boolean delHuoQuJysqdh(String cardId);
+
+ @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} AND a.type='澶勭疆' GROUP BY a.sqdh")
+ List<String> getHuoQuZlsqdh(String cardId);
+ @Delete("DELETE FROM ltkj_jianchajianyan_tree WHERE card_id=#{cardId} AND type='澶勭疆'")
+ Boolean delHuoQuZlsqdh(String cardId);
+
+
+ List<Map<String, Object>> getTjTongJiJieKou(Map<String, Object> map);
+
+ @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} and a.jxbz=#{bldh} AND a.type='妫�鏌�' GROUP BY a.sqdh")
+ List<String> getHuoQuBlJcsqdh(@Param("cardId") String cardId,@Param("bldh") String bldh);
+ @Delete("DELETE FROM ltkj_jianchajianyan_tree WHERE card_id=#{cardId} and jxbz=#{bldh} AND type='妫�鏌�'")
+ Boolean delHuoQuBlJcsqdh(@Param("cardId")String cardId, @Param("bldh")String bldh);
+
+ @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} and a.jxbz=#{bldh} AND a.type='妫�楠�' GROUP BY a.sqdh")
+ List<String> getHuoQuBlJysqdh(@Param("cardId")String cardId,@Param("bldh") String bldh);
+ @Delete("DELETE FROM ltkj_jianchajianyan_tree WHERE card_id=#{cardId} and jxbz=#{bldh} AND type='妫�楠�'")
+ Boolean delHuoQuBlJysqdh(@Param("cardId")String cardId,@Param("bldh") String bldh);
+
+ @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} and a.jxbz=#{bldh} AND a.type='澶勭疆' GROUP BY a.sqdh")
+ 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