From f489850355bae6d690b2d3e6d0627f90bde79b1d Mon Sep 17 00:00:00 2001
From: 陶杰 <1378534974@qq.com>
Date: 星期五, 06 九月 2024 18:59:51 +0800
Subject: [PATCH] 1.优惠券记录新增category查询字段 2.小程序-商品历史记录根据更新时间排序 3.优惠券-用户优惠券控制已下架的优惠券不可重新上架，及当前优惠券的已经发放的情况下不可再次下发
---
src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java | 20 ++++++++++++++++++++
1 files changed, 20 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 d1f488e..f36c8d7 100644
--- a/src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/customer/CustomerMapper.java
@@ -6,6 +6,8 @@
import com.mzl.flower.dto.response.customer.CustomerDTO;
import com.mzl.flower.entity.customer.Customer;
import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;
import java.util.List;
@@ -17,4 +19,22 @@
CustomerDTO getCurrentCustomer(@Param("userId") String userId);
void bindPartner(@Param("id") Long id, @Param("partnerId")Long partnerId, @Param("userId")String userId);
+
+ @Select("select count(1) from t_customer_info where level_id = #{levelId} and deleted = '0' ")
+ Integer getByLevelId(@Param("levelId") String levelId);
+
+ @Update("UPDATE t_customer_info c " +
+ "JOIN ( " +
+ " SELECT user_id, " +
+ " SUM(growth) as sumgrowthvalue " +
+ " FROM t_member_growth_record " +
+ " WHERE deleted = '0' " +
+ " GROUP BY user_id " +
+ " HAVING SUM(growth) > 0 " +
+ ") t1 ON c.user_id = t1.user_id " +
+ "SET c.level_id = #{levelId} " +
+ "WHERE t1.sumgrowthvalue BETWEEN #{startPoint} AND #{endPoint} ")
+ Boolean updateMemberLevelByPoint(@Param("levelId") Long levelId, @Param("startPoint") int startPoint, @Param("endPoint") int endPoint);
+
+
}
--
Gitblit v1.9.3