From 7e622820bca4011788ed676e9a2af74a7b0d0e7d Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期三, 04 六月 2025 17:36:20 +0800 Subject: [PATCH] 查报告增加时间范围以及配置 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java | 10 ++++++++++ 1 files changed, 10 insertions(+), 0 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java index e8a7e94..e2dbf3e 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java @@ -1,6 +1,7 @@ package com.ltkj.hosp.mapper; import java.sql.ResultSet; +import java.util.Date; import java.util.List; import java.util.Map; @@ -104,4 +105,13 @@ List<Map<String, Object>> vcustomerlist(@Param("name")String name, @Param("sjh")String sjh, @Param("sfzh") String sfzh); List<TjCustomer> getcusList(TjCustomer tjCustomer); + + List<Map<String ,Object >> getCusInfoList(@Param("card") String card,@Param("time") Date time); + + List<Map<String ,Object >> getCusInfoListByCardAndName(@Param("card") String card,@Param("name") String name); + + + @Select("SELECT IF(b.cus_sex=0,'鐢�','濂�') xb FROM tj_order a JOIN tj_customer b ON b.cus_id=a.user_id \n" + + "WHERE a.tj_number=#{tjNumber}") + String getSexByTjh(String tjNumber); } -- Gitblit v1.8.0