From ccd9b262d4e1949ab2456cda9326ead93362c14d Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期三, 16 十月 2024 15:30:58 +0800 Subject: [PATCH] 修改查询为父项 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 57 ++++++++++++++++++++++++++++++++++++--------------------- 1 files changed, 36 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 624d55e..12d6efc 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; @@ -109,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(); @@ -264,4 +269,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