From ec15861e14c66c38b1a8f5fffc6975d7da6c315c Mon Sep 17 00:00:00 2001
From: zhujie <leon.zhu@cloudroam.com.cn>
Date: 星期三, 23 四月 2025 02:31:00 +0800
Subject: [PATCH] 1
---
src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java | 36 ++++++++++++++++++++++++++++++++++--
1 files changed, 34 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java b/src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java
index 2a1ee52..4fa9a5b 100644
--- a/src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java
@@ -49,9 +49,41 @@
@Select("select count(1) from t_customer_info where reintervialcode = #{code}")
Integer getInvitatCountByCode(@Param("code") String code);
- @Select("select user_id as userId,name as userName,t1.reward from t_customer_info c" +
- "inner join (select reintervialcode,count(DISTINCT id) as reward from t_customer_info where reintervialcode is not null and reintervialcode <> '' group by reintervialcode) t1 on c.intervialcode=t1.reintervialcode")
+ @Select("SELECT " +
+ " c.user_id as userId," +
+ " c.name as userName," +
+ " CASE " +
+ " WHEN t1.reward < 3 THEN '获得了3天会员' " +
+ " WHEN t1.reward >= 3 AND t1.reward < 5 THEN '获得了15天会员' " +
+ " WHEN t1.reward >=5 THEN '获得了30天会员' " +
+ " ELSE '' " +
+ " END AS reward ," +
+ " '已注册' as status " +
+ "FROM " +
+ " t_customer_info c " +
+ " INNER JOIN (" +
+ " SELECT " +
+ " reintervialcode, " +
+ " COUNT(DISTINCT id) AS reward" +
+ " FROM " +
+ " t_customer_info " +
+ " WHERE " +
+ " reintervialcode IS NOT NULL " +
+ " AND reintervialcode <> '' " +
+ " GROUP BY " +
+ " reintervialcode " +
+ " ) t1 ON c.intervialcode = t1.reintervialcode")
List<InviteDTO> getReward();
+ @Select("SELECT " +
+ "c.user_id AS userId, " +
+ "c.NAME AS userName, " +
+ "'' AS reward, " +
+ "'已注册' AS STATUS , c.cover " +
+ "FROM " +
+ "t_customer_info c " +
+ "WHERE " +
+ "reintervialcode IN ( SELECT intervialcode FROM t_customer_info WHERE user_id = #{userid} )")
+ List<InviteDTO> getMyReward(String userid);
void checkVipExpireTime();
}
--
Gitblit v1.9.3