用户类 邀请码 商城
Change-Id: If3a9ef5c464386647ae3b876104cbf4c71265c4b
diff --git a/src/main/java/com/pt5/pthouduan/mapper/InvitesMapper.java b/src/main/java/com/pt5/pthouduan/mapper/InvitesMapper.java
index fddf6df..62eb977 100644
--- a/src/main/java/com/pt5/pthouduan/mapper/InvitesMapper.java
+++ b/src/main/java/com/pt5/pthouduan/mapper/InvitesMapper.java
@@ -9,18 +9,32 @@
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * <p>
+ * Mapper 接口
+ * </p>
+ *
+ * @author ljx
+ * @since 2025-04-14
+ */
@Repository
public interface InvitesMapper extends BaseMapper<Invites> {
@Select("SELECT * FROM invite WHERE code = #{code}")
- Invites selectByCode(String code);
+ Map<String, Object> selectByCode(String code);
@Update("UPDATE invite SET isUsed = 1, username = #{username} WHERE code = #{code}")
int updateInviteByCode(@Param("code") String code, @Param("username") String username);
- @Select("SELECT * FROM invite WHERE buyername = '' LIMIT 1")
- Invites selectFirstEmptyBuyername();
+ @Select("SELECT * FROM invite WHERE (buyername = '' OR buyername IS NULL) LIMIT 1")
+ Map<String, Object> selectFirstEmptyBuyername();
@Update("UPDATE invite SET buyername = #{buyername} WHERE code = #{code}")
int updatebuyer(@Param("code") String code, @Param("buyername") String buyername);
+
+ @Select("SELECT * FROM invite WHERE buyername = #{username}")
+ List<Map<String, Object>> selectInvitesByUsername(@Param("username") String username);
}