From e97ceaa936df7125aa5b36e8c26a146d31f2b136 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 03 四月 2025 17:57:38 +0800
Subject: [PATCH] 小程序接口调整
---
ltkj-hosp/src/main/resources/mapper/TjCustomerMapper.xml | 30 ++++++++++++++++++++++++++++++
ltkj-admin/src/main/java/com/ltkj/web/controller/api/DefaultController.java | 15 +++++++++++++++
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java | 2 ++
3 files changed, 47 insertions(+), 0 deletions(-)
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/api/DefaultController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/api/DefaultController.java
index ab252d4..fc88d4c 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/api/DefaultController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/api/DefaultController.java
@@ -74,6 +74,21 @@
return AjaxResult.success(customer);
}
+ /**
+ * 瀵逛簬灏忕▼搴忔彁渚�
+ * 鏍规嵁韬唤璇佸彿鏌ヨ杩斿洖浣撴璁板綍锛氬寘鍚鍚嶃�佽韩浠借瘉鍙枫�佹�у埆銆佸嚭鐢熸棩鏈熴�佸勾榫勩�佷綋妫�鍙枫�佽仈绯荤數璇濓紝浣撴鏃ユ湡锛屾姤鍛婄姸鎬�
+ * @param json
+ * @return
+ */
+ @PostMapping("/getCusInfo")
+ public AjaxResult getInfoCus(@RequestBody String json){
+ JSONObject entries = JSONUtil.parseObj(json);
+ String card = entries.getStr("card");
+ String name = entries.getStr("name");
+ List<Map<String ,Object>> customer = tjCustomerMapper.getCusInfoListByCardAndName(card,name);
+ return AjaxResult.success(customer);
+ }
+
public static void removeNullFields(JSONObject jsonObject) {
ArrayList<String> strings = new ArrayList<>();
strings.add("orderId");
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 1127618..457e893 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
@@ -108,4 +108,6 @@
TjCustomer getCusInfo(@Param("card") String card);
List<Map<String ,Object >> getCusInfoList(String card);
+
+ List<Map<String ,Object >> getCusInfoListByCardAndName(@Param("card") String card,@Param("name") String name);
}
diff --git a/ltkj-hosp/src/main/resources/mapper/TjCustomerMapper.xml b/ltkj-hosp/src/main/resources/mapper/TjCustomerMapper.xml
index 7892bcc..f4bfd4e 100644
--- a/ltkj-hosp/src/main/resources/mapper/TjCustomerMapper.xml
+++ b/ltkj-hosp/src/main/resources/mapper/TjCustomerMapper.xml
@@ -310,4 +310,34 @@
ORDER BY
o.create_time DESC
</select>
+ <select id="getCusInfoListByCardAndName" resultType="java.util.Map">
+ SELECT
+ c.cus_name as name,
+ c.cus_idcard as card,
+ CASE c.cus_sex
+ WHEN 0 THEN '鐢�'
+ WHEN 1 THEN '濂�'
+ ELSE '鏈煡'
+ END AS sex,
+ c.cus_brithday as csrq,
+ o.tj_number as tjNum,
+ c.cus_phone as phone,
+ DATE_FORMAT(o.create_time, '%Y-%m-%d %H:%i:%s') as time,
+ TIMESTAMPDIFF(YEAR, c.cus_brithday, CURDATE()) -
+ CASE
+ WHEN MONTH(c.cus_brithday) > MONTH(CURDATE())
+ OR (MONTH(c.cus_brithday) = MONTH(CURDATE()) AND DAY(c.cus_brithday) > DAY(CURDATE()))
+ THEN 1
+ ELSE 0
+ END AS age,
+ CASE WHEN r.re_id IS NOT NULL THEN 1 ELSE 0 END AS type
+FROM
+ tj_order o
+ JOIN tj_customer c ON o.user_id = c.cus_id
+ LEFT JOIN tj_report r ON o.tj_number = r.tj_number
+WHERE
+ c.cus_idcard = #{card} AND c.cus_name = #{name} AND c.deleted = 0
+ ORDER BY
+ o.create_time DESC
+ </select>
</mapper>
--
Gitblit v1.8.0