From db9900074fa83021a7e3b1445eaf28ab56e675ab Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期四, 17 四月 2025 08:41:30 +0800
Subject: [PATCH] add 分类管理
---
src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 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 b715cc3..2a1ee52 100644
--- a/src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java
@@ -4,6 +4,7 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.mzl.flower.dto.request.customer.QueryCustomerDTO;
import com.mzl.flower.dto.response.customer.CustomerDTO;
+import com.mzl.flower.dto.response.customer.InviteDTO;
import com.mzl.flower.dto.response.supplier.SupplierDTO;
import com.mzl.flower.entity.customer.Customer;
import org.apache.ibatis.annotations.Param;
@@ -41,4 +42,16 @@
@Select("select * from t_customer_info where user_id = ( select id from t_user where tel =#{phone} and type = 'customer')")
CustomerDTO findCustomerByPhone(String phone);
+
+ @Select("select * from t_customer_info where intervialcode =#{code}")
+ Customer findCustomerByInvitationCode(@Param("code") String code);
+
+ @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")
+ List<InviteDTO> getReward();
+
+ void checkVipExpireTime();
}
--
Gitblit v1.9.3