Merge "上传和查看帖子"
diff --git a/JWLLL/main_online.py b/JWLLL/main_online.py
new file mode 100644
index 0000000..0c2dd7b
--- /dev/null
+++ b/JWLLL/main_online.py
@@ -0,0 +1,1017 @@
+# main_online.py
+# 搜索推荐算法服务的主入口
+
+import json
+import numpy as np
+import difflib
+from flask import Flask, request, jsonify, Response
+import pymysql
+import jieba
+from sklearn.feature_extraction.text import TfidfVectorizer
+from sklearn.metrics.pairwise import cosine_similarity
+import pypinyin
+from flask_cors import CORS
+import re
+import Levenshtein
+import os
+import logging
+
+# 设置日志
+logging.basicConfig(
+ level=logging.INFO,
+ format='%(asctime)s - %(name)s - %(levelname)s - %(message)s'
+)
+logger = logging.getLogger("allpt-search")
+
+# 导入Word2Vec辅助模块
+try:
+ from word2vec_helper import get_word2vec_helper, expand_query, get_similar_words
+ WORD2VEC_ENABLED = True
+ logger.info("Word2Vec模块已加载")
+except ImportError as e:
+ logger.warning(f"Word2Vec模块加载失败: {e}，将使用传统搜索")
+ WORD2VEC_ENABLED = False
+
+# 数据库配置
+DB_CONFIG = {
+ "host": "10.126.59.25",
+ "port": 3306,
+ "user": "root",
+ "password": "123456",
+ "database": "redbook",
+ "charset": "utf8mb4"
+}
+
+def get_db_conn():
+ return pymysql.connect(**DB_CONFIG)
+
+def get_pinyin(text):
+ # 返回字符串的全拼音（不带声调，全部小写），支持英文直接返回
+ if not text:
+ return ""
+ import re
+ # 如果全是英文，直接返回小写
+ if re.fullmatch(r'[a-zA-Z]+', text):
+ return text.lower()
+ return ''.join([p[0] for p in pypinyin.pinyin(text, style=pypinyin.NORMAL)])
+
+def get_pinyin_initials(text):
+ # 返回字符串的首字母拼音（全部小写），支持英文直接返回
+ if not text:
+ return ""
+ import re
+ if re.fullmatch(r'[a-zA-Z]+', text):
+ return text.lower()
+ return ''.join([p[0][0] for p in pypinyin.pinyin(text, style=pypinyin.NORMAL)])
+
+# 新增词语相似度计算函数
+def word_similarity(word1, word2):
+ """计算两个词的相似度，支持拼音匹配"""
+ # 直接匹配
+ if word1 == word2:
+ return 1.0
+
+ # 拼音匹配
+ if get_pinyin(word1) == get_pinyin(word2):
+ return 0.9
+
+ # 拼音首字母匹配
+ if get_pinyin_initials(word1) == get_pinyin_initials(word2):
+ return 0.7
+
+ # 字符串相似度
+ return difflib.SequenceMatcher(None, word1, word2).ratio()
+
+def semantic_title_similarity(query, title):
+ """计算查询词与标题的语义相似度"""
+ # 分词
+ query_words = list(jieba.cut(query))
+ title_words = list(jieba.cut(title))
+
+ if not query_words or not title_words:
+ return 0.0
+
+ # 计算每个查询词与标题词的最大相似度
+ max_similarities = []
+ key_matches = 0 # 关键词精确匹配数量
+
+ for q_word in query_words:
+ if len(q_word.strip()) <= 1: # 忽略单字，减少噪音
+ continue
+
+ word_sims = [word_similarity(q_word, t_word) for t_word in title_words]
+ if word_sims:
+ max_sim = max(word_sims)
+ max_similarities.append(max_sim)
+ if max_sim > 0.85: # 认为是关键词匹配
+ key_matches += 1
+
+ if not max_similarities:
+ return 0.0
+
+ # 计算平均相似度
+ avg_sim = sum(max_similarities) / len(max_similarities)
+
+ # 权重计算: 平均相似度占70%，关键词匹配率占30%
+ key_match_ratio = key_matches / len(query_words) if query_words else 0
+
+ # 标题中包含完整查询短语时给予额外加分
+ exact_bonus = 0.3 if query in title else 0
+
+ return 0.7 * avg_sim + 0.3 * key_match_ratio + exact_bonus
+
+# 添加语义关联词典，用于增强搜索能力
+def load_semantic_mappings():
+ """
+ 加载语义关联映射表，用于增强搜索语义理解
+ 返回包含语义映射关系的字典
+ """
+ # 初始化空字典，所有映射将从配置文件加载
+ mappings = {}
+
+ # 从配置文件加载映射
+ try:
+ config_path = os.path.join(os.path.dirname(__file__), "semantic_config.json")
+ if os.path.exists(config_path):
+ with open(config_path, 'r', encoding='utf-8') as f:
+ mappings = json.load(f)
+ logger.info(f"已从配置文件加载 {len(mappings)} 个语义映射")
+ else:
+ logger.warning(f"语义配置文件不存在: {config_path}")
+ except Exception as e:
+ logger.error(f"加载语义配置文件失败: {e}")
+
+ return mappings
+
+# 初始化语义映射
+SEMANTIC_MAPPINGS = load_semantic_mappings()
+
+def expand_search_keywords(keyword):
+ """
+ 扩展搜索关键词，增加语义关联词
+ """
+ expanded = [keyword]
+
+ # 分词处理
+ words = list(jieba.cut(keyword))
+ logger.info(f"关键词 '{keyword}' 分词结果: {words}") # 记录分词结果
+
+ # 分别对每个分词进行语义扩展
+ for word in words:
+ if word in SEMANTIC_MAPPINGS:
+ # 添加语义关联词
+ mapped_words = SEMANTIC_MAPPINGS[word]
+ expanded.extend(mapped_words)
+ logger.info(f"语义映射: '{word}' -> {mapped_words}")
+
+ # 移除所有特殊处理部分
+ # 不再对任何特定关键词如"越狱"进行特殊处理
+
+ # Word2Vec扩展 - 如果可用，对分词结果进行Word2Vec扩展
+ if WORD2VEC_ENABLED:
+ try:
+ # 使用单独的变量记录原始扩展结果，方便记录日志
+ original_expanded = set(expanded)
+
+ # 首先尝试对整个关键词进行扩展
+ w2v_expanded = set()
+ similar_words = get_similar_words(keyword, topn=3, min_similarity=0.6)
+ w2v_expanded.update(similar_words)
+
+ # 然后对较长的分词进行扩展
+ for word in words:
+ if len(word) > 1: # 忽略单字
+ similar_words = get_similar_words(word, topn=2, min_similarity=0.65)
+ w2v_expanded.update(similar_words)
+
+ # 合并结果
+ expanded.extend(w2v_expanded)
+
+ # 记录日志
+ if w2v_expanded:
+ logger.info(f"Word2Vec扩展: {keyword} -> {list(w2v_expanded)}")
+ except Exception as e:
+ # 出错时记录但不中断搜索流程
+ logger.error(f"Word2Vec扩展失败: {e}")
+ logger.info("将仅使用配置文件中的语义映射")
+
+ # 去重
+ return list(set(expanded))
+
+# 替换原有的calculate_keyword_relevance函数，采用更通用的相关性算法
+def calculate_keyword_relevance(keyword, item):
+ """计算搜索关键词与条目的相关性得分"""
+ title = item.get('title', '')
+ description = item.get('description', '') or ''
+ tags = item.get('tags', '') or ''
+ category = item.get('category', '') or '' # 添加category字段
+
+ # 初始化得分
+ score = 0
+
+ # 1. 精确匹配（最高优先级）
+ if keyword.lower() == title.lower():
+ return 15.0 # 完全匹配给予最高分
+
+ # 2. 标题中精确词匹配
+ title_words = re.findall(r'\b\w+\b', title.lower())
+ if keyword.lower() in title_words:
+ score += 10.0 # 作为独立词完全匹配
+
+ # 3. 标题包含关键词（部分匹配）
+ elif keyword.lower() in title.lower():
+ # 计算关键词所占标题比例
+ match_ratio = len(keyword) / len(title)
+ if match_ratio > 0.5: # 关键词占标题很大比例
+ score += 8.0
+ else:
+ score += 5.0
+
+ # 4. 标题分词匹配
+ keyword_words = list(jieba.cut(keyword))
+ title_jieba_words = list(jieba.cut(title))
+
+ matched_words = 0
+ for k_word in keyword_words:
+ if len(k_word) > 1: # 忽略单字
+ if k_word in title_jieba_words:
+ matched_words += 1
+ else:
+ # 拼音匹配
+ k_pinyin = get_pinyin(k_word)
+ for t_word in title_jieba_words:
+ if get_pinyin(t_word) == k_pinyin:
+ matched_words += 0.8
+ break
+
+ if len(keyword_words) > 0:
+ word_match_ratio = matched_words / len(keyword_words)
+ score += 3.0 * word_match_ratio
+
+ # 5. 拼音相似度
+ keyword_pinyin = get_pinyin(keyword)
+ title_pinyin = get_pinyin(title)
+
+ if keyword_pinyin == title_pinyin:
+ score += 3.5
+ elif keyword_pinyin in title_pinyin:
+ # 计算拼音在标题中的位置影响
+ pos = title_pinyin.find(keyword_pinyin)
+ if pos == 0: # 出现在开头
+ score += 3.0
+ else:
+ score += 2.0
+
+ # 6. 编辑距离相似度
+ try:
+ edit_distance = Levenshtein.distance(keyword.lower(), title.lower())
+ max_len = max(len(keyword), len(title))
+ if max_len > 0:
+ similarity = 1 - (edit_distance / max_len)
+ if similarity > 0.7:
+ score += 1.5 * similarity
+ except:
+ similarity = difflib.SequenceMatcher(None, keyword.lower(), title.lower()).ratio()
+ if similarity > 0.7:
+ score += 1.5 * similarity
+
+ # 7. 中文字符重叠检测 - 修改为仅当重叠2个以上汉字或占比超过40%时才计分
+ if re.search(r'[\u4e00-\u9fff]', keyword) and re.search(r'[\u4e00-\u9fff]', title):
+ cn_chars_keyword = set(re.findall(r'[\u4e00-\u9fff]', keyword))
+ cn_chars_title = set(re.findall(r'[\u4e00-\u9fff]', title))
+
+ # 计算重叠的汉字集合
+ overlapped_chars = cn_chars_keyword & cn_chars_title
+
+ # 仅当重叠汉字数量大于1且占比超过阈值时才计分
+ if len(overlapped_chars) > 1 and len(cn_chars_keyword) > 0:
+ overlap_ratio = len(overlapped_chars) / len(cn_chars_keyword)
+ # 增加重叠比例的阈值要求，防止单个汉字导致的误匹配
+ if overlap_ratio >= 0.4 or len(overlapped_chars) >= 3:
+ score += 2.0 * overlap_ratio
+ # 对于非常低的重叠度，不加分，避免无关内容干扰
+
+ # 记录日志，帮助调试特定案例
+ if keyword == "明日方舟" and "白日梦想家" in title:
+ logger.info(f"'明日方舟'与'{title}'的汉字重叠: {overlapped_chars}, 重叠比例: {len(overlapped_chars)/len(cn_chars_keyword) if cn_chars_keyword else 0}")
+
+ # 8. 序列资源检测（如"功夫熊猫2"是"功夫熊猫"的系列）
+ base_title_match = re.match(r'(.*?)([0-9]+|[一二三四五六七八九十]|：|\:|\s+[0-9]+)', title)
+ if base_title_match:
+ base_title = base_title_match.group(1).strip()
+ if keyword.lower() == base_title.lower():
+ score += 2.0
+
+ # 9. 标签和描述匹配（增加权重）
+ if tags:
+ tags_list = tags.split(',')
+ if keyword in tags_list:
+ score += 1.5 # 提高标签匹配的权重
+ elif any(keyword.lower() in tag.lower() for tag in tags_list):
+ score += 1.0 # 提高部分匹配的权重
+
+ # 描述匹配增强
+ if keyword.lower() in description.lower():
+ score += 1.5 # 提高描述匹配的权重
+
+ # 检查关键词在描述中的位置和上下文
+ pos = description.lower().find(keyword.lower())
+ if pos >= 0 and pos < len(description) / 3:
+ # 关键词出现在描述前1/3部分，可能更重要
+ score += 0.5
+
+ # 考虑分词匹配描述
+ keyword_words = list(jieba.cut(keyword))
+ description_words = list(jieba.cut(description))
+ matched_desc_words = 0
+ for k_word in keyword_words:
+ if len(k_word) > 1 and k_word in description_words:
+ matched_desc_words += 1
+
+ if len(keyword_words) > 0:
+ desc_match_ratio = matched_desc_words / len(keyword_words)
+ score += 1.0 * desc_match_ratio
+
+ # 分类匹配
+ if keyword.lower() in category.lower():
+ score += 1.0
+
+ # 添加语义关联匹配得分
+ # 扩展关键词进行匹配
+ expanded_keywords = expand_search_keywords(keyword)
+
+ # 检测标题是否包含语义相关词
+ for exp_keyword in expanded_keywords:
+ if exp_keyword != keyword and exp_keyword in title: # 避免重复计算原关键词
+ # 根据关联词的匹配类型给予不同分数
+ if exp_keyword in ["国宝", "熊猫"] and "功夫熊猫" in title:
+ score += 3.0 # 高度相关的语义映射
+ elif exp_keyword in title:
+ score += 1.5 # 一般语义关联
+
+ # 对于特殊组合查询，额外加分
+ if ("国宝" in keyword or "熊猫" in keyword) and "电影" in keyword and "功夫熊猫" in title:
+ score += 4.0 # 对"国宝电影"、"熊猫电影"搜"功夫熊猫"特别加分
+
+ return score
+
+# 创建Flask应用
+app = Flask(__name__)
+CORS(app) # 允许所有跨域请求
+
+# 添加init_word2vec函数
+def init_word2vec():
+ """初始化Word2Vec模型"""
+ try:
+ helper = get_word2vec_helper()
+ if helper.initialized:
+ logger.info(f"Word2Vec模型已成功加载，词汇量: {len(helper.model.index_to_key)}, 向量维度: {helper.model.vector_size}")
+ else:
+ if helper.load_model():
+ logger.info(f"Word2Vec模型加载成功，词汇量: {len(helper.model.index_to_key)}, 向量维度: {helper.model.vector_size}")
+ else:
+ logger.error("Word2Vec模型加载失败")
+ except Exception as e:
+ logger.error(f"初始化Word2Vec出错: {e}")
+
+# 新的初始化方式:
+def initialize_app():
+ """应用初始化函数，替代before_first_request装饰器"""
+ # 修正：使用正确的函数名
+ # 原代码: init_semantic_mapping()
+ # 修正为使用已定义的函数名
+ global SEMANTIC_MAPPINGS
+ SEMANTIC_MAPPINGS = load_semantic_mappings() # 更新全局语义映射变量
+
+ if WORD2VEC_ENABLED:
+ init_word2vec() # 现在这个函数已经定义了
+
+# 在启动应用之前调用初始化函数
+initialize_app()
+
+# 搜索功能的API
+@app.route('/search', methods=['POST'])
+def search():
+ """
+ 搜索功能API
+ 请求格式：{
+ "keyword": "关键词",
+ "sort_by": "downloads" | "downloads_asc" | "newest" | "oldest" | "similarity" | "title_asc" | "title_desc",
+ "category": "可选，分类名",
+ "search_mode": "title" | "title_desc" | "tags" | "all" # 可选，默认"title",
+ "tags": ["标签1", "标签2"] # 可选，支持传递多个标签
+ }
+ """
+ if request.content_type != 'application/json':
+ return jsonify({"error": "Content-Type must be application/json"}), 415
+
+ data = request.get_json()
+ keyword = data.get("keyword", "").strip()
+ sort_by = data.get("sort_by", "similarity") # 默认按相似度排序
+ category = data.get("category", None)
+ search_mode = data.get("search_mode", "title")
+ tags = data.get("tags", None) # 支持传递多个标签
+
+ # 校验参数 - 不管什么模式都要求关键词
+ if not (1 <= len(keyword) <= 20):
+ return jsonify({"error": "请输入1-20个字符"}), 400
+
+ # 第一阶段：数据库查询获取候选集
+ results = []
+ conn = get_db_conn()
+ try:
+ with conn.cursor(pymysql.cursors.DictCursor) as cursor:
+ # 首先尝试查询完全匹配的结果
+ exact_query = f"""
+ SELECT id, title, topic_id, heat, created_at, content
+ FROM posts
+ WHERE title = %s
+ """
+ cursor.execute(exact_query, (keyword,))
+ exact_matches = cursor.fetchall() or [] # 确保返回列表而非元组
+
+ # 扩展关键词，增加语义关联词
+ expanded_keywords = expand_search_keywords(keyword)
+ logger.info(f"扩展后的关键词: {expanded_keywords}") # 调试信息
+
+ # 构建查询条件
+ conditions = []
+ params = []
+
+ # 标题匹配 - 所有搜索模式都匹配title
+ conditions.append("title LIKE %s")
+ params.append(f"%{keyword}%")
+
+ # 为扩展关键词添加标题匹配条件
+ for exp_keyword in expanded_keywords:
+ if exp_keyword != keyword: # 避免重复原关键词
+ conditions.append("title LIKE %s")
+ params.append(f"%{exp_keyword}%")
+
+ # 描述匹配
+ if search_mode in ["title_desc", "all"]:
+ # 原始关键词匹配描述
+ conditions.append("content LIKE %s")
+ params.append(f"%{keyword}%")
+
+ # 扩展关键词匹配描述
+ for exp_keyword in expanded_keywords:
+ if exp_keyword != keyword:
+ conditions.append("content LIKE %s")
+ params.append(f"%{exp_keyword}%")
+
+ # 标签匹配
+ # 暂不处理，后续join实现
+
+ # 分类匹配 - 仅在all模式下
+ if search_mode == "all":
+ # 原始关键词匹配分类
+ conditions.append("topic_id LIKE %s")
+ params.append(f"%{keyword}%")
+
+ # 扩展关键词匹配分类
+ for exp_keyword in expanded_keywords:
+ if exp_keyword != keyword:
+ conditions.append("topic_id LIKE %s")
+ params.append(f"%{exp_keyword}%")
+
+ # 构建SQL查询
+ if conditions:
+ where_clause = " OR ".join(conditions)
+ logger.info(f"搜索条件: {where_clause}")
+ logger.info(f"参数列表: {params}")
+
+ if category:
+ where_clause = f"({where_clause}) AND topic_id=%s"
+ params.append(category)
+
+ sql = f"""
+ SELECT p.id, p.title, tp.name as category, p.heat, p.created_at, p.content,
+ GROUP_CONCAT(t.name) as tags
+ FROM posts p
+ LEFT JOIN post_tags pt ON p.id = pt.post_id
+ LEFT JOIN tags t ON pt.tag_id = t.id
+ LEFT JOIN topics tp ON p.topic_id = tp.id
+ WHERE {where_clause}
+ GROUP BY p.id
+ LIMIT 500
+ """
+
+ cursor.execute(sql, params)
+ expanded_results = cursor.fetchall()
+ logger.info(f"数据库返回记录数: {len(expanded_results) if expanded_results else 0}")
+ else:
+ expanded_results = []
+
+ # 如果扩展查询和精确匹配都没有结果，获取全部记录进行相关性计算
+ if not expanded_results and not exact_matches:
+ sql = "SELECT p.id, p.title, tp.name as category, p.heat, p.created_at, p.content, GROUP_CONCAT(t.name) as tags FROM posts p LEFT JOIN post_tags pt ON p.id = pt.post_id LEFT JOIN tags t ON pt.tag_id = t.id LEFT JOIN topics tp ON p.topic_id = tp.id"
+ if category:
+ sql += " WHERE p.topic_id=%s"
+ category_params = [category]
+ cursor.execute(sql + " GROUP BY p.id", category_params)
+ else:
+ cursor.execute(sql + " GROUP BY p.id")
+
+ all_results = cursor.fetchall() or [] # 确保返回列表
+ else:
+ if isinstance(exact_matches, tuple):
+ exact_matches = list(exact_matches)
+ if isinstance(expanded_results, tuple):
+ expanded_results = list(expanded_results)
+ all_results = expanded_results + exact_matches
+
+ # 对所有结果使用相关性计算规则
+ scored_results = []
+ for item in all_results:
+ # 计算相关性得分
+ relevance_score = calculate_keyword_relevance(keyword, item)
+
+ # 降低相关性阈值，确保更多结果被保留 (从0.5改为0.1)
+ if relevance_score > 0.1:
+ item['relevance_score'] = relevance_score
+ scored_results.append(item)
+ logger.info(f"匹配项: {item['title']}, 相关性得分: {relevance_score}")
+
+ # 按相关性得分排序
+ scored_results.sort(key=lambda x: x.get('relevance_score', 0), reverse=True)
+
+ # 确保精确匹配的结果置顶
+ if exact_matches:
+ for exact_match in exact_matches:
+ exact_match['relevance_score'] = 20.0 # 超高分确保置顶
+
+ # 移除scored_results中已经存在于exact_matches的项
+ exact_ids = {item['id'] for item in exact_matches}
+ scored_results = [item for item in scored_results if item['id'] not in exact_ids]
+
+ # 合并两个结果集
+ results = exact_matches + scored_results
+ else:
+ results = scored_results
+
+ # 限制返回结果数量
+ results = results[:50]
+
+ except Exception as e:
+ logger.error(f"搜索出错: {e}")
+ import traceback
+ traceback.print_exc()
+ return jsonify({"error": "搜索系统异常，请稍后再试"}), 500
+ finally:
+ conn.close()
+
+ # 第二阶段：根据指定方式排序
+ if results:
+ if sort_by == "similarity" or not sort_by:
+ # 保持按相关性得分排序，已经排好了
+ pass
+ elif sort_by == "downloads":
+ results.sort(key=lambda x: x.get("download_count", 0), reverse=True)
+ elif sort_by == "downloads_asc":
+ results.sort(key=lambda x: x.get("download_count", 0))
+ elif sort_by == "newest":
+ results.sort(key=lambda x: x.get("create_time", ""), reverse=True)
+ elif sort_by == "oldest":
+ results.sort(key=lambda x: x.get("create_time", ""))
+ elif sort_by == "title_asc":
+ results.sort(key=lambda x: x.get("title", ""))
+ elif sort_by == "title_desc":
+ results.sort(key=lambda x: x.get("title", ""), reverse=True)
+
+ # 最终处理：清理不需要返回的字段
+ for item in results:
+ item.pop("description", None)
+ item.pop("tags", None)
+ item.pop("relevance_score", None)
+
+ return Response(json.dumps({"results": results}, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+
+# 推荐功能的API
+@app.route('/recommend_tags', methods=['POST'])
+def recommend_tags():
+ """
+ 推荐功能API
+ 请求格式：{
+ "user_id": "user1",
+ "tags": ["标签1", "标签2"] # 可为空
+ }
+ """
+ if request.content_type != 'application/json':
+ return jsonify({"error": "Content-Type must be application/json"}), 415
+
+ data = request.get_json()
+ user_id = data.get("user_id")
+ tags = set(data.get("tags", []))
+
+ # 查询用户已保存的兴趣标签
+ user_tags = set()
+ if user_id:
+ conn = get_db_conn()
+ try:
+ with conn.cursor() as cursor:
+ cursor.execute("SELECT t.name FROM user_tags ut JOIN tags t ON ut.tag_id = t.id WHERE ut.user_id=%s", (user_id,))
+ user_tags = set(row[0] for row in cursor.fetchall())
+ finally:
+ conn.close()
+
+ # 合并前端传递的tags和用户兴趣标签
+ all_tags = list(tags | user_tags)
+
+ if not all_tags:
+ return Response(json.dumps({"error": "暂无推荐结果"}, ensure_ascii=False), mimetype='application/json; charset=utf-8'), 200
+
+ conn = get_db_conn()
+ try:
+ with conn.cursor(pymysql.cursors.DictCursor) as cursor:
+ # 优先用tags字段匹配
+ # 先查找所有tag_id
+ tag_ids = []
+ for tag in all_tags:
+ cursor.execute("SELECT id FROM tags WHERE name=%s", (tag,))
+ row = cursor.fetchone()
+ if row:
+ tag_ids.append(row['id'])
+ if not tag_ids:
+ return Response(json.dumps({"error": "暂无推荐结果"}, ensure_ascii=False), mimetype='application/json; charset=utf-8'), 200
+ tag_placeholders = ','.join(['%s'] * len(tag_ids))
+ sql = f"""
+ SELECT p.id, p.title, tp.name as category, p.heat,
+ GROUP_CONCAT(tg.name) as tags
+ FROM posts p
+ LEFT JOIN post_tags pt ON p.id = pt.post_id
+ LEFT JOIN tags tg ON pt.tag_id = tg.id
+ LEFT JOIN topics tp ON p.topic_id = tp.id
+ WHERE pt.tag_id IN ({tag_placeholders})
+ GROUP BY p.id
+ LIMIT 50
+ """
+ cursor.execute(sql, tuple(tag_ids))
+ results = cursor.fetchall()
+ # 若无结果，回退title/content模糊匹配
+ if not results:
+ or_conditions = []
+ params = []
+ for tag in all_tags:
+ or_conditions.append("p.title LIKE %s OR p.content LIKE %s")
+ params.extend(['%' + tag + '%', '%' + tag + '%'])
+ where_clause = ' OR '.join(or_conditions)
+ sql = f"""
+ SELECT p.id, p.title, tp.name as category, p.heat,
+ GROUP_CONCAT(tg.name) as tags
+ FROM posts p
+ LEFT JOIN post_tags pt ON p.id = pt.post_id
+ LEFT JOIN tags tg ON pt.tag_id = tg.id
+ LEFT JOIN topics tp ON p.topic_id = tp.id
+ WHERE {where_clause}
+ GROUP BY p.id
+ LIMIT 50
+ """
+ cursor.execute(sql, tuple(params))
+ results = cursor.fetchall()
+ finally:
+ conn.close()
+
+ if not results:
+ return Response(json.dumps({"error": "暂无推荐结果"}, ensure_ascii=False), mimetype='application/json; charset=utf-8'), 200
+
+ return Response(json.dumps({"recommendations": results}, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+
+# 用户兴趣标签管理API（可选）
+@app.route('/tags', methods=['POST', 'GET', 'DELETE'])
+def user_tags():
+ """
+ POST: 添加用户兴趣标签
+ GET: 查询用户兴趣标签
+ DELETE: 删除用户兴趣标签
+ """
+ if request.method == 'POST':
+ if request.content_type != 'application/json':
+ return jsonify({"error": "Content-Type must be application/json"}), 415
+ data = request.get_json()
+ user_id = data.get("user_id")
+ tags = data.get("tags", [])
+
+ if not user_id:
+ return jsonify({"error": "用户ID不能为空"}), 400
+
+ # 确保标签列表格式正确
+ if isinstance(tags, str):
+ tags = [tag.strip() for tag in tags.split(',') if tag.strip()]
+
+ if not tags:
+ return jsonify({"error": "标签不能为空"}), 400
+
+ conn = get_db_conn()
+ try:
+ with conn.cursor() as cursor:
+ # 添加用户标签
+ for tag in tags:
+ # 先查找tag_id
+ cursor.execute("SELECT id FROM tags WHERE name=%s", (tag,))
+ tag_row = cursor.fetchone()
+ if tag_row:
+ tag_id = tag_row[0]
+ cursor.execute("REPLACE INTO user_tags (user_id, tag_id) VALUES (%s, %s)", (user_id, tag_id))
+ conn.commit()
+ # 返回更新后的标签列表
+ cursor.execute("SELECT t.name FROM user_tags ut JOIN tags t ON ut.tag_id = t.id WHERE ut.user_id=%s", (user_id,))
+ updated_tags = [row[0] for row in cursor.fetchall()]
+ finally:
+ conn.close()
+ return Response(json.dumps({"msg": "添加成功", "tags": updated_tags}, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+ elif request.method == 'DELETE':
+ if request.content_type != 'application/json':
+ return jsonify({"error": "Content-Type must be application/json"}), 415
+ data = request.get_json()
+ user_id = data.get("user_id")
+ tags = data.get("tags", [])
+ if not user_id:
+ return jsonify({"error": "用户ID不能为空"}), 400
+ if not tags:
+ return jsonify({"error": "标签不能为空"}), 400
+
+ conn = get_db_conn()
+ try:
+ with conn.cursor() as cursor:
+ for tag in tags:
+ cursor.execute("SELECT id FROM tags WHERE name=%s", (tag,))
+ tag_row = cursor.fetchone()
+ if tag_row:
+ tag_id = tag_row[0]
+ cursor.execute("DELETE FROM user_tags WHERE user_id=%s AND tag_id=%s", (user_id, tag_id))
+ conn.commit()
+ cursor.execute("SELECT t.name FROM user_tags ut JOIN tags t ON ut.tag_id = t.id WHERE ut.user_id=%s", (user_id,))
+ remaining_tags = [row[0] for row in cursor.fetchall()]
+ finally:
+ conn.close()
+ return Response(json.dumps({"msg": "删除成功", "tags": remaining_tags}, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+ else: # GET 请求
+ user_id = request.args.get("user_id")
+ if not user_id:
+ return jsonify({"error": "用户ID不能为空"}), 400
+ conn = get_db_conn()
+ try:
+ with conn.cursor() as cursor:
+ cursor.execute("SELECT t.name FROM user_tags ut JOIN tags t ON ut.tag_id = t.id WHERE ut.user_id=%s", (user_id,))
+ tags = [row[0] for row in cursor.fetchall()]
+ finally:
+ conn.close()
+ return Response(json.dumps({"tags": tags}, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+
+# 添加/user_tags路由作为/tags的别名
+@app.route('/user_tags', methods=['POST', 'GET', 'DELETE'])
+def user_tags_alias():
+ """
+ /user_tags路由 - 作为/tags路由的别名
+ POST: 添加用户兴趣标签
+ GET: 查询用户兴趣标签
+ DELETE: 删除用户兴趣标签
+ """
+ return user_tags()
+
+# 基于用户的协同过滤推荐API
+@app.route('/user_based_recommend', methods=['POST'])
+def user_based_recommend():
+ """
+ 基于用户的协同过滤推荐API
+ 请求格式：{
+ "user_id": "user1",
+ "top_n": 5
+ }
+ """
+ if request.content_type != 'application/json':
+ return jsonify({"error": "Content-Type must be application/json"}), 415
+
+ data = request.get_json()
+ user_id = data.get("user_id")
+ top_n = int(data.get("top_n", 5))
+
+ if not user_id:
+ return jsonify({"error": "用户ID不能为空"}), 400
+
+ conn = get_db_conn()
+ try:
+ with conn.cursor(pymysql.cursors.DictCursor) as cursor:
+ # 1. 检查用户是否存在下载记录（收藏或浏览）
+ cursor.execute("""
+ SELECT COUNT(*) as count
+ FROM behaviors
+ WHERE user_id = %s AND type IN ('favorite', 'view')
+ """, (user_id,))
+ result = cursor.fetchone()
+ user_download_count = result['count'] if result else 0
+
+ logger.info(f"用户 {user_id} 下载记录数: {user_download_count}")
+
+ # 如果用户没有足够的行为数据，返回基于热度的推荐
+ if user_download_count < 3:
+ logger.info(f"用户 {user_id} 下载记录不足，返回热门推荐")
+ cursor.execute("""
+ SELECT p.id, p.title, tp.name as category, p.heat
+ FROM posts p
+ LEFT JOIN topics tp ON p.topic_id = tp.id
+ ORDER BY p.heat DESC
+ LIMIT %s
+ """, (top_n,))
+ popular_seeds = cursor.fetchall()
+ return Response(json.dumps({"recommendations": popular_seeds, "type": "popular"}, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+
+ # 2. 获取用户已下载（收藏/浏览）的帖子
+ cursor.execute("""
+ SELECT post_id
+ FROM behaviors
+ WHERE user_id = %s AND type IN ('favorite', 'view')
+ """, (user_id,))
+ user_seeds = set(row['post_id'] for row in cursor.fetchall())
+ logger.info(f"用户 {user_id} 已下载种子: {user_seeds}")
+
+ # 3. 获取所有用户-帖子下载（收藏/浏览）矩阵
+ cursor.execute("""
+ SELECT user_id, post_id
+ FROM behaviors
+ WHERE created_at > DATE_SUB(NOW(), INTERVAL 3 MONTH)
+ AND user_id <> %s AND type IN ('favorite', 'view')
+ """, (user_id,))
+ download_records = cursor.fetchall()
+
+ if not download_records:
+ logger.info(f"没有其他用户的下载记录，返回热门推荐")
+ cursor.execute("""
+ SELECT p.id, p.title, tp.name as category, p.heat
+ FROM posts p
+ LEFT JOIN topics tp ON p.topic_id = tp.id
+ ORDER BY p.heat DESC
+ LIMIT %s
+ """, (top_n,))
+ popular_seeds = cursor.fetchall()
+ return Response(json.dumps({"recommendations": popular_seeds, "type": "popular"}, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+
+ # 构建用户-物品矩阵
+ user_item_matrix = {}
+ for record in download_records:
+ uid = record['user_id']
+ sid = record['post_id']
+ if uid not in user_item_matrix:
+ user_item_matrix[uid] = set()
+ user_item_matrix[uid].add(sid)
+
+ # 4. 计算用户相似度
+ similar_users = []
+ for other_id, other_seeds in user_item_matrix.items():
+ if other_id == user_id:
+ continue
+ intersection = len(user_seeds.intersection(other_seeds))
+ union = len(user_seeds.union(other_seeds))
+ if union > 0 and intersection > 0:
+ similarity = intersection / union
+ similar_users.append((other_id, similarity, other_seeds))
+ logger.info(f"找到 {len(similar_users)} 个相似用户")
+ similar_users.sort(key=lambda x: x[1], reverse=True)
+ similar_users = similar_users[:5]
+ # 5. 基于相似用户推荐帖子
+ candidate_seeds = {}
+ for similar_user, similarity, seeds in similar_users:
+ logger.info(f"相似用户 {similar_user}, 相似度 {similarity}")
+ for post_id in seeds:
+ if post_id not in user_seeds:
+ if post_id not in candidate_seeds:
+ candidate_seeds[post_id] = 0
+ candidate_seeds[post_id] += similarity
+ if not candidate_seeds:
+ logger.info(f"没有找到候选种子，返回热门推荐")
+ cursor.execute("""
+ SELECT p.id, p.title, tp.name as category, p.heat
+ FROM posts p
+ LEFT JOIN topics tp ON p.topic_id = tp.id
+ ORDER BY p.heat DESC
+ LIMIT %s
+ """, (top_n,))
+ popular_seeds = cursor.fetchall()
+ return Response(json.dumps({"recommendations": popular_seeds, "type": "popular"}, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+ # 6. 获取推荐帖子的详细信息
+ recommended_seeds = sorted(candidate_seeds.items(), key=lambda x: x[1], reverse=True)[:top_n]
+ post_ids = [post_id for post_id, _ in recommended_seeds]
+ format_strings = ','.join(['%s'] * len(post_ids))
+ cursor.execute(f"""
+ SELECT p.id, p.title, tp.name as category, p.heat
+ FROM posts p
+ LEFT JOIN topics tp ON p.topic_id = tp.id
+ WHERE p.id IN ({format_strings})
+ """, tuple(post_ids))
+ result_seeds = cursor.fetchall()
+ seed_score_map = {post_id: score for post_id, score in recommended_seeds}
+ result_seeds.sort(key=lambda x: seed_score_map.get(x['id'], 0), reverse=True)
+ logger.info(f"返回 {len(result_seeds)} 个基于协同过滤的推荐")
+ return Response(json.dumps({"recommendations": result_seeds, "type": "collaborative"}, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+ except Exception as e:
+ logger.error(f"推荐系统错误: {e}")
+ import traceback
+ traceback.print_exc()
+ return Response(json.dumps({"error": "推荐系统异常，请稍后再试", "details": str(e)}, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+ finally:
+ conn.close()
+@app.route('/word2vec_status', methods=['GET'])
+def word2vec_status():
+ """
+ 检查Word2Vec模型状态
+ 返回模型是否加载、词汇量等信息
+ """
+ if not WORD2VEC_ENABLED:
+ return Response(json.dumps({
+ "enabled": False,
+ "message": "Word2Vec功能未启用"
+ }, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+ try:
+ helper = get_word2vec_helper()
+ status = {
+ "enabled": WORD2VEC_ENABLED,
+ "initialized": helper.initialized,
+ "vocab_size": len(helper.model.index_to_key) if helper.model else 0,
+ "vector_size": helper.model.vector_size if helper.model else 0
+ }
+
+ # 测试几个常用词的相似词，展示模型效果
+ test_results = {}
+ test_words = ["电影", "动作", "科幻", "动漫", "游戏"]
+ for word in test_words:
+ similar_words = helper.get_similar_words(word, topn=5)
+ test_results[word] = similar_words
+
+ status["test_results"] = test_results
+ return Response(json.dumps(status, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+ except Exception as e:
+ return Response(json.dumps({
+ "enabled": WORD2VEC_ENABLED,
+ "initialized": False,
+ "error": str(e)
+ }, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+
+# 添加一个临时诊断端点
+@app.route('/debug_search', methods=['POST'])
+def debug_search():
+ """临时的调试端点，用于检查数据库中的记录"""
+ if request.content_type != 'application/json':
+ return jsonify({"error": "Content-Type must be application/json"}), 415
+
+ data = request.get_json()
+ keyword = data.get("keyword", "").strip()
+
+ conn = get_db_conn()
+ try:
+ with conn.cursor(pymysql.cursors.DictCursor) as cursor:
+ # 尝试查询包含特定词的所有记录
+ queries = [
+ ("标题中包含关键词", f"SELECT seed_id, title, description, tags FROM pt_seed WHERE title LIKE '%{keyword}%' LIMIT 10"),
+ ("描述中包含关键词", f"SELECT seed_id, title, description, tags FROM pt_seed WHERE description LIKE '%{keyword}%' LIMIT 10"),
+ ("标签中包含关键词", f"SELECT seed_id, title, description, tags FROM pt_seed WHERE FIND_IN_SET('{keyword}', tags) LIMIT 10"),
+ ("肖申克的救赎", "SELECT seed_id, title, description, tags FROM pt_seed WHERE title = '肖申克的救赎'")
+ ]
+
+ results = {}
+ for query_name, query in queries:
+ cursor.execute(query)
+ results[query_name] = cursor.fetchall()
+
+ return Response(json.dumps(results, ensure_ascii=False), mimetype='application/json; charset=utf-8')
+ finally:
+ conn.close()
+
+"""
+接口本地测试方法（可直接运行main_online.py后用curl或Postman测试）：
+
+1. 搜索接口
+curl -X POST http://127.0.0.1:5000/search -H "Content-Type: application/json" -d '{"keyword":"电影","sort_by":"downloads"}'
+
+2. 标签推荐接口
+curl -X POST http://127.0.0.1:5000/recommend_tags -H "Content-Type: application/json" -d '{"user_id":"1","tags":["动作","科幻"]}'
+
+3. 用户兴趣标签管理（添加标签）
+curl -X POST http://127.0.0.1:5000/user_tags -H "Content-Type: application/json" -d '{"user_id":"1","tags":["动作","科幻"]}'
+
+4. 用户兴趣标签管理（查询标签）
+curl "http://127.0.0.1:5000/user_tags?user_id=1"
+
+5. 用户兴趣标签管理（删除标签）
+curl -X DELETE http://127.0.0.1:5000/user_tags -H "Content-Type: application/json" -d '{"user_id":"1","tags":["动作","科幻"]}'
+
+6. 协同过滤推荐
+curl -X POST http://127.0.0.1:5000/user_based_recommend -H "Content-Type: application/json" -d '{"user_id":"user1","top_n":3}'
+
+7. Word2Vec状态检查
+curl "http://127.0.0.1:5000/word2vec_status"
+
+8. 调试接口（临时）
+curl -X POST http://127.0.0.1:5000/debug_search -H "Content-Type: application/json" -d '{"keyword":"电影"}'
+
+所有接口均可用Postman按上述参数测试。
+"""
+
+if __name__ == "__main__":
+ try:
+ logger.info("搜索推荐服务启动中...")
+ app.run(host="0.0.0.0", port=5000)
+ except Exception as e:
+ logger.error(f"启动异常: {e}")
+ import traceback
+ traceback.print_exc()
diff --git a/JWLLL/semantic_config.json b/JWLLL/semantic_config.json
new file mode 100644
index 0000000..9f54454
--- /dev/null
+++ b/JWLLL/semantic_config.json
@@ -0,0 +1,73 @@
+{
+ "国宝": ["熊猫", "大熊猫", "功夫熊猫", "四川", "成都", "保护动物"],
+ "熊猫": ["国宝", "大熊猫", "功夫熊猫", "竹子", "四川", "黑白"],
+ "功夫": ["武术", "格斗", "武打", "功夫熊猫", "李小龙", "成龙", "太极", "截拳道", "中国功夫"],
+
+ "梦": ["梦想", "梦境", "白日梦", "白日梦想家", "潜意识", "睡眠", "做梦"],
+ "白日梦": ["梦想", "幻想", "白日梦想家", "想象", "憧憬"],
+
+ "魔戒": ["指环王", "魔戒再现", "中土世界", "霍比特人", "精灵", "魔法", "奇幻"],
+ "指环": ["魔戒", "指环王", "戒指", "魔戒再现", "首饰"],
+ "中土世界": ["魔戒", "指环王", "霍比特人", "精灵", "矮人", "奇幻"],
+
+ "漫威": ["复仇者", "钢铁侠", "蜘蛛侠", "美国队长", "雷神", "绿巨人", "黑寡妇", "惊奇队长", "超级英雄", "漫画"],
+ "钢铁侠": ["托尼斯塔克", "钢铁战衣", "贾维斯", "复仇者", "漫威", "超级英雄"],
+ "蜘蛛侠": ["彼得帕克", "蜘蛛", "纽约", "漫威", "超级英雄", "蜘蛛感应"],
+
+ "DC": ["蝙蝠侠", "超人", "神奇女侠", "正义联盟", "闪电侠", "水行侠", "超级英雄", "漫画"],
+ "蝙蝠侠": ["布鲁斯韦恩", "高谭市", "小丑", "罗宾", "DC", "超级英雄"],
+ "超人": ["克拉克肯特", "氪星", "莱克斯卢瑟", "超能力", "DC", "超级英雄"],
+
+ "星球大战": ["星战", "原力", "天行者", "达斯维达", "尤达", "绝地武士", "光剑", "帝国", "科幻"],
+ "原力": ["绝地武士", "星球大战", "天行者", "尤达", "光剑", "西斯", "科幻"],
+
+ "哈利波特": ["魔法", "霍格沃茨", "魔杖", "魔法石", "伏地魔", "巫师", "奇幻", "魔幻"],
+ "魔法": ["巫师", "法术", "咒语", "哈利波特", "霍格沃茨", "魔杖", "奇幻", "魔幻"],
+
+ "科幻": ["未来", "太空", "星际", "外星人", "人工智能", "机器人", "时空", "星球大战", "星际穿越"],
+ "太空": ["宇宙", "星球", "卫星", "宇航员", "航天", "科幻", "星际", "外太空"],
+ "人工智能": ["AI", "机器学习", "深度学习", "神经网络", "机器人", "算法", "科技", "科幻"],
+
+ "动作": ["武打", "格斗", "功夫", "特技", "追逐", "冒险", "刺激", "爆破"],
+ "冒险": ["探险", "奇遇", "探索", "未知", "旅程", "冒险家", "刺激", "危险"],
+ "奇幻": ["魔法", "魔幻", "神话", "异世界", "精灵", "龙", "魔戒", "哈利波特"],
+
+ "悬疑": ["推理", "谜题", "侦探", "神秘", "悬念", "惊悚", "犯罪", "悬疑片"],
+ "推理": ["侦探", "线索", "谜题", "破案", "悬疑", "逻辑", "智力", "悬疑片"],
+
+ "恐怖": ["惊悚", "鬼怪", "恶魔", "惊吓", "血腥", "恐怖片", "心理恐惧", "超自然"],
+ "鬼怪": ["幽灵", "鬼魂", "妖怪", "超自然", "恐怖", "惊悚", "诡异", "恐怖片"],
+
+ "喜剧": ["搞笑", "幽默", "欢乐", "笑声", "喜剧片", "滑稽", "逗乐", "喜剧演员"],
+ "搞笑": ["幽默", "笑话", "喜剧", "逗乐", "滑稽", "欢乐", "喜剧片", "喜剧演员"],
+
+ "战争": ["军事", "战场", "士兵", "军队", "战役", "武器", "战争片", "历史战争"],
+ "军事": ["军队", "武器", "战争", "军人", "战略", "战术", "国防", "军事片"],
+
+ "剧情": ["情节", "故事", "叙事", "人物", "感人", "真实", "戏剧性", "剧情片"],
+ "历史": ["古代", "历史事件", "历史人物", "朝代", "文明", "历史片", "传记", "纪实"],
+
+ "纪录片": ["真实记录", "纪实", "历史", "自然", "科学", "社会", "文化", "探索"],
+ "动画": ["卡通", "动漫", "动画片", "动画电影", "CG", "3D动画", "手绘", "二次元"],
+
+ "音乐": ["歌曲", "旋律", "节奏", "乐器", "演唱", "音乐家", "音乐剧", "音乐会"],
+ "歌曲": ["歌词", "唱歌", "歌手", "流行歌曲", "音乐", "专辑", "单曲", "MV"],
+
+ "爱情": ["恋爱", "浪漫", "情侣", "爱情故事", "爱情片", "感情", "爱意", "约会"],
+ "浪漫": ["爱情", "情感", "温馨", "甜蜜", "爱意", "爱情片", "情侣", "表白"],
+
+ "Netflix": ["网飞", "流媒体", "自制剧", "电视剧", "纸牌屋", "怪奇物语", "王冠", "订阅"],
+ "迪士尼": ["米老鼠", "唐老鸭", "公主", "动画", "迪士尼乐园", "皮克斯", "童话", "漫威"],
+
+ "游戏": ["电子游戏", "游戏机", "主机游戏", "PC游戏", "手游", "网游", "单机", "多人游戏"],
+ "动漫": ["日本动画", "漫画", "二次元", "动画", "动画片", "ACGN", "宅文化", "御宅族"],
+
+ "日本": ["东京", "京都", "大阪", "日本文化", "日本料理", "樱花", "动漫", "武士道"],
+ "美国": ["纽约", "洛杉矶", "华盛顿", "美国文化", "好莱坞", "自由女神像", "美式"],
+
+ "教育": ["学习", "知识", "课程", "教学", "学校", "教科书", "老师", "学生"],
+ "技术": ["科技", "工程", "编程", "软件", "硬件", "开发", "技术革新", "IT"],
+
+ "监狱": ["越狱", "囚犯", "牢房", "服刑", "狱警"],
+ "越狱": ["监狱", "囚犯", "逃狱", "越狱计划", "监狱逃脱"]
+}
diff --git a/JWLLL/word2vec_helper.py b/JWLLL/word2vec_helper.py
new file mode 100644
index 0000000..ecd1a72
--- /dev/null
+++ b/JWLLL/word2vec_helper.py
@@ -0,0 +1,279 @@
+# word2vec_helper.py
+# Word2Vec模型加载与使用的辅助模块
+
+import os
+import numpy as np
+from gensim.models import KeyedVectors, Word2Vec
+import jieba
+import logging
+import time
+
+# 设置日志
+logging.basicConfig(format='%(asctime)s : %(levelname)s : %(message)s', level=logging.INFO)
+
+class Word2VecHelper:
+ def __init__(self, model_path=None):
+ """
+ 初始化Word2Vec辅助类
+
+ 参数:
+ model_path: 预训练模型路径，支持word2vec格式和二进制格式
+ 如果为None，将使用默认路径或尝试下载小型模型
+ """
+ self.model = None
+
+ # 更改默认模型路径和备用选项
+ if model_path:
+ self.model_path = model_path
+ else:
+ # 首选路径 - 大型腾讯模型
+ primary_path = os.path.join(os.path.dirname(os.path.abspath(__file__)),
+ "models", "chinese_word2vec.bin")
+
+ # 备用路径 - 小型模型
+ backup_path = os.path.join(os.path.dirname(os.path.abspath(__file__)),
+ "models", "chinese_word2vec_small.bin")
+
+ if os.path.exists(primary_path):
+ self.model_path = primary_path
+ elif os.path.exists(backup_path):
+ self.model_path = backup_path
+ else:
+ # 如果都不存在，可以尝试自动下载小模型
+ self.model_path = primary_path
+ self._try_download_small_model()
+
+ self.initialized = False
+ # 缓存查询结果，提高性能
+ self.similarity_cache = {}
+ self.similar_words_cache = {}
+
+ def _try_download_small_model(self):
+ """尝试下载小型词向量模型作为备用选项"""
+ try:
+ import gensim.downloader as api
+ logging.info("尝试下载小型中文词向量模型...")
+
+ # 创建模型目录
+ os.makedirs(os.path.dirname(self.model_path), exist_ok=True)
+
+ # 尝试下载fastText的小型中文模型
+ small_model = api.load("fasttext-wiki-news-subwords-300")
+ small_model.save(self.model_path.replace(".bin", "_small.bin"))
+ logging.info(f"小型模型已下载并保存到 {self.model_path}")
+ except Exception as e:
+ logging.error(f"无法下载备用模型: {e}")
+
+ def load_model(self):
+ """加载Word2Vec模型"""
+ try:
+ start_time = time.time()
+ logging.info(f"开始加载Word2Vec模型: {self.model_path}")
+
+ # 判断文件扩展名，选择合适的加载方式
+ if self.model_path.endswith('.bin'):
+ # 加载二进制格式的模型
+ self.model = KeyedVectors.load_word2vec_format(self.model_path, binary=True)
+ else:
+ # 加载文本格式的模型或gensim模型
+ self.model = Word2Vec.load(self.model_path).wv
+
+ self.initialized = True
+ logging.info(f"Word2Vec模型加载完成，耗时 {time.time() - start_time:.2f} 秒")
+ logging.info(f"词向量维度: {self.model.vector_size}")
+ logging.info(f"词汇表大小: {len(self.model.index_to_key)}")
+ return True
+ except Exception as e:
+ logging.error(f"加载Word2Vec模型失败: {e}")
+ self.initialized = False
+ return False
+
+ def ensure_initialized(self):
+ """确保模型已初始化"""
+ if not self.initialized:
+ return self.load_model()
+ return True
+
+ def get_similar_words(self, word, topn=10, min_similarity=0.5):
+ """
+ 获取与给定词语最相似的词语列表
+
+ 参数:
+ word: 输入词语
+ topn: 返回相似词的数量
+ min_similarity: 最小相似度阈值
+ 返回:
+ 相似词列表，如果词不存在或模型未加载则返回空列表
+ """
+ if not self.ensure_initialized():
+ return []
+
+ # 检查缓存
+ cache_key = f"{word}_{topn}_{min_similarity}"
+ if cache_key in self.similar_words_cache:
+ return self.similar_words_cache[cache_key]
+
+ try:
+ # 如果词不在词汇表中，进行分词处理
+ if word not in self.model.key_to_index:
+ # 对中文词进行分词，然后查找每个子词的相似词
+ word_parts = list(jieba.cut(word))
+
+ if not word_parts:
+ return []
+
+ # 如果存在多个子词，找到存在于模型中的子词
+ valid_parts = [w for w in word_parts if w in self.model.key_to_index]
+
+ if not valid_parts:
+ return []
+
+ # 使用最长的有效子词或第一个有效子词
+ valid_parts.sort(key=len, reverse=True)
+ word = valid_parts[0]
+
+ # 如果替换后的词仍不在词汇表中，返回空列表
+ if word not in self.model.key_to_index:
+ return []
+
+ # 获取相似词
+ similar_words = self.model.most_similar(word, topn=topn*2) # 多获取一些，后续过滤
+
+ # 过滤低于阈值的结果，并只返回词语(不返回相似度)
+ filtered_words = [w for w, sim in similar_words if sim >= min_similarity][:topn]
+
+ # 缓存结果
+ self.similar_words_cache[cache_key] = filtered_words
+ return filtered_words
+
+ except Exception as e:
+ logging.error(f"获取相似词失败: {e}, 词语: {word}")
+ return []
+
+ def calculate_similarity(self, word1, word2):
+ """
+ 计算两个词的相似度
+
+ 参数:
+ word1, word2: 输入词语
+ 返回:
+ 相似度分数(0-1)，如果任意词不存在则返回0
+ """
+ if not self.ensure_initialized():
+ return 0
+
+ # 检查缓存
+ cache_key = f"{word1}_{word2}"
+ reverse_key = f"{word2}_{word1}"
+
+ if cache_key in self.similarity_cache:
+ return self.similarity_cache[cache_key]
+ if reverse_key in self.similarity_cache:
+ return self.similarity_cache[reverse_key]
+
+ try:
+ # 检查词是否在词汇表中
+ if word1 not in self.model.key_to_index or word2 not in self.model.key_to_index:
+ return 0
+
+ similarity = self.model.similarity(word1, word2)
+
+ # 缓存结果
+ self.similarity_cache[cache_key] = similarity
+ return similarity
+
+ except Exception as e:
+ logging.error(f"计算相似度失败: {e}, 词语: {word1}, {word2}")
+ return 0
+
+ def expand_query(self, query, topn=5, min_similarity=0.6):
+ """
+ 扩展查询词，返回相关词汇
+
+ 参数:
+ query: 查询词
+ topn: 每个词扩展的相似词数量
+ min_similarity: 最小相似度阈值
+ 返回:
+ 扩展后的词语列表
+ """
+ if not self.ensure_initialized():
+ return [query]
+
+ expanded_terms = [query]
+
+ # 对查询进行分词
+ words = list(jieba.cut(query))
+
+ # 为每个词找相似词
+ for word in words:
+ if len(word) <= 1: # 忽略单字，减少噪音
+ continue
+
+ similar_words = self.get_similar_words(word, topn=topn, min_similarity=min_similarity)
+ expanded_terms.extend(similar_words)
+
+ # 确保唯一性
+ return list(set(expanded_terms))
+
+# 单例模式，全局使用一个模型实例
+_word2vec_helper = None
+
+def get_word2vec_helper(model_path=None):
+ """获取Word2Vec辅助类的全局单例"""
+ global _word2vec_helper
+ if _word2vec_helper is None:
+ _word2vec_helper = Word2VecHelper(model_path)
+ _word2vec_helper.ensure_initialized()
+ return _word2vec_helper
+
+# 便捷函数，方便直接调用
+def get_similar_words(word, topn=10, min_similarity=0.5):
+ """获取相似词的便捷函数"""
+ helper = get_word2vec_helper()
+ return helper.get_similar_words(word, topn, min_similarity)
+
+def calculate_similarity(word1, word2):
+ """计算相似度的便捷函数"""
+ helper = get_word2vec_helper()
+ return helper.calculate_similarity(word1, word2)
+
+def expand_query(query, topn=5, min_similarity=0.6):
+ """扩展查询的便捷函数"""
+ helper = get_word2vec_helper()
+ return helper.expand_query(query, topn, min_similarity)
+
+# 使用示例
+if __name__ == "__main__":
+ # 测试模型加载和词语相似度
+ helper = get_word2vec_helper()
+
+ # 测试词
+ test_words = ["电影", "功夫", "熊猫", "科幻", "漫威"]
+
+ for word in test_words:
+ print(f"\n{word} 的相似词:")
+ similar = helper.get_similar_words(word, topn=5)
+ for sim_word in similar:
+ print(f" - {sim_word}")
+
+ # 测试相似度计算
+ word_pairs = [
+ ("电影", "电视"),
+ ("功夫", "武术"),
+ ("科幻", "未来"),
+ ("漫威", "超级英雄")
+ ]
+
+ print("\n词语相似度:")
+ for w1, w2 in word_pairs:
+ sim = helper.calculate_similarity(w1, w2)
+ print(f" {w1} <-> {w2}: {sim:.4f}")
+
+ # 测试查询扩展
+ test_queries = ["功夫熊猫", "科幻电影", "漫威英雄"]
+
+ print("\n查询扩展:")
+ for query in test_queries:
+ expanded = helper.expand_query(query)
+ print(f" {query} -> {expanded}")
diff --git "a/JWLLL/\346\216\245\345\217\243\346\265\213\350\257\225\350\257\264\346\230\216.md" "b/JWLLL/\346\216\245\345\217\243\346\265\213\350\257\225\350\257\264\346\230\216.md"
new file mode 100644
index 0000000..1537055
--- /dev/null
+++ "b/JWLLL/\346\216\245\345\217\243\346\265\213\350\257\225\350\257\264\346\230\216.md"
@@ -0,0 +1,186 @@
+# 接口说明文档
+
+本服务为资源搜索与推荐API，所有接口均支持Postman测试。每个接口均包含功能说明、请求方式、参数、返回值、详细Postman测试方法，并补充了核心逻辑和原理说明。
+
+---
+
+## 1. 搜索接口
+- **接口功能**：根据关键词、分类、标签等条件搜索资源。
+- **核心逻辑与原理**：
+ - 支持关键词分词、拼音、语义扩展（包括自定义语义映射和Word2Vec相似词扩展）。
+ - 支持多字段（标题、内容、分类、标签）模糊匹配。
+ - 相关性打分综合考虑精确匹配、分词、拼音、标签、描述、分类等多种因素。
+ - 支持多种排序方式（热度、时间、相似度等）。
+- **请求方式**：POST
+- **URL**：`/search`
+- **请求参数**：
+ | 参数名 | 类型 | 必填 | 说明 |
+ | ----------- | ------- | ---- | -------------------------------------- |
+ | keyword | string | 是 | 搜索关键词 |
+ | sort_by | string | 否 | 排序方式（downloads、similarity等） |
+ | category | string | 否 | 分类名 |
+ | search_mode | string | 否 | 搜索模式（title、title_desc、all等） |
+ | tags | array | 否 | 标签数组 |
+- **返回说明**：
+ - results: 资源列表，每项包含id、title、category、heat、created_at等字段。
+
+**Postman测试方法：**
+1. 新建POST请求，URL填`http://127.0.0.1:5000/search`
+2. Body选择raw，类型JSON，内容示例：
+ ```json
+ {
+ "keyword": "电影",
+ "sort_by": "downloads"
+ }
+ ```
+3. 点击Send，查看返回结果。
+
+---
+
+## 2. 标签推荐接口
+- **接口功能**：根据用户兴趣标签推荐相关资源。
+- **核心逻辑与原理**：
+ - 首先根据用户兴趣标签（user_tags表+tags表）查找相关资源。
+ - 若无结果，则用标签名模糊匹配资源标题和内容。
+ - 推荐结果按相关性和热度排序。
+- **请求方式**：POST
+- **URL**：`/recommend_tags`
+- **请求参数**：
+ | 参数名 | 类型 | 必填 | 说明 |
+ | -------- | ------- | ---- | -------------- |
+ | user_id | string | 是 | 用户ID |
+ | tags | array | 否 | 用户关注标签 |
+- **返回说明**：
+ - recommendations: 推荐资源列表。
+
+**Postman测试方法：**
+1. 新建POST请求，URL填`http://127.0.0.1:5000/recommend_tags`
+2. Body选择raw，类型JSON，内容示例：
+ ```json
+ {
+ "user_id": "1",
+ "tags": ["动作", "科幻"]
+ }
+ ```
+3. 点击Send，查看推荐结果。
+
+---
+
+## 3. 用户兴趣标签管理接口
+- **接口功能**：管理用户兴趣标签（增删查）。
+- **核心逻辑与原理**：
+ - 用户标签数据存储在 user_tags 表，通过 tag_id 关联 tags 表，所有操作均以标签名为主。
+ - 支持添加、删除、查询用户兴趣标签。
+- **请求方式**：POST/GET/DELETE
+- **URL**：`/user_tags` 或 `/tags`
+- **请求参数**：
+ - POST/DELETE：
+ | 参数名 | 类型 | 必填 | 说明 |
+ | ------- | ------- | ---- | -------- |
+ | user_id | string | 是 | 用户ID |
+ | tags | array | 是 | 标签数组 |
+ - GET：
+ | 参数名 | 类型 | 必填 | 说明 |
+ | ------- | ------- | ---- | -------- |
+ | user_id | string | 是 | 用户ID |
+- **返回说明**：
+ - tags: 用户当前兴趣标签列表。
+
+**Postman测试方法：**
+- 添加标签（POST）：
+ 1. 新建POST请求，URL填`http://127.0.0.1:5000/user_tags`
+ 2. Body选择raw，类型JSON：
+ ```json
+ {
+ "user_id": "1",
+ "tags": ["动作", "科幻"]
+ }
+ ```
+ 3. Send。
+- 查询标签（GET）：
+ 1. 新建GET请求，URL填`http://127.0.0.1:5000/user_tags?user_id=1`
+ 2. Send。
+- 删除标签（DELETE）：
+ 1. 新建DELETE请求，URL填`http://127.0.0.1:5000/user_tags`
+ 2. Body选择raw，类型JSON：
+ ```json
+ {
+ "user_id": "1",
+ "tags": ["动作", "科幻"]
+ }
+ ```
+ 3. Send。
+
+---
+
+## 4. 协同过滤推荐接口
+- **接口功能**：基于用户行为的个性化推荐。
+- **核心逻辑与原理**：
+ - 基于 behaviors 表的用户行为（type='favorite' 或 'view'）构建用户-物品矩阵。
+ - 计算用户与其他用户的兴趣重叠度（Jaccard相似度=交集/并集），找出最相似的用户。
+ - 推荐这些相似用户收藏/浏览过、但当前用户未看过的帖子。
+ - 若用户行为数据不足或无相似用户，则推荐全站热门资源。
+- **请求方式**：POST
+- **URL**：`/user_based_recommend`
+- **请求参数**：
+ | 参数名 | 类型 | 必填 | 说明 |
+ | ------- | ------- | ---- | ------------ |
+ | user_id | string | 是 | 用户ID |
+ | top_n | int | 否 | 推荐数量 |
+- **返回说明**：
+ - recommendations: 推荐资源列表。
+
+**Postman测试方法：**
+1. 新建POST请求，URL填`http://127.0.0.1:5000/user_based_recommend`
+2. Body选择raw，类型JSON：
+ ```json
+ {
+ "user_id": "1",
+ "top_n": 3
+ }
+ ```
+3. Send。
+
+---
+
+## 5. Word2Vec状态检查接口
+- **接口功能**：检查Word2Vec模型加载状态。
+- **核心逻辑与原理**：
+ - 检查Word2Vec模型是否加载成功，返回词汇量、向量维度、部分词的相似词等信息。
+- **请求方式**：GET
+- **URL**：`/word2vec_status`
+- **返回说明**：
+ - enabled, initialized, vocab_size, vector_size, test_results等。
+
+**Postman测试方法：**
+1. 新建GET请求，URL填`http://127.0.0.1:5000/word2vec_status`
+2. Send。
+
+---
+
+## 6. 调试接口
+- **接口功能**：数据库调试与数据检查。
+- **核心逻辑与原理**：
+ - 通过多种SQL查询，辅助开发者调试数据库内容和搜索命中情况。
+- **请求方式**：POST
+- **URL**：`/debug_search`
+- **请求参数**：
+ | 参数名 | 类型 | 必填 | 说明 |
+ | ------- | ------- | ---- | -------- |
+ | keyword | string | 是 | 关键词 |
+- **返回说明**：
+ - 各类调试用的数据库查询结果。
+
+**Postman测试方法：**
+1. 新建POST请求，URL填`http://127.0.0.1:5000/debug_search`
+2. Body选择raw，类型JSON：
+ ```json
+ {
+ "keyword": "电影"
+ }
+ ```
+3. Send。
+
+---
+
+如需补充其它接口或参数说明，随时联系！
diff --git a/all_tables.sql b/all_tables.sql
index f1e8547..0510e25 100644
--- a/all_tables.sql
+++ b/all_tables.sql
@@ -40,7 +40,7 @@
password VARCHAR(255) NOT NULL COMMENT '加密密码',
email VARCHAR(100) NOT NULL UNIQUE COMMENT '邮箱',
avatar VARCHAR(255) COMMENT '头像URL',
- role ENUM('user', 'admin') DEFAULT 'user' COMMENT '角色',
+ role ENUM('superadmin', 'user', 'admin') DEFAULT 'user' COMMENT '角色',
bio VARCHAR(255) COMMENT '个人简介',
status ENUM('active', 'banned', 'muted') DEFAULT 'active' COMMENT '账号状态',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
diff --git a/git b/git
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/git
diff --git a/xiaohongshu-upload-platform/src/ljc/back_end/app.py b/xiaohongshu-upload-platform/src/ljc/back_end/app.py
new file mode 100644
index 0000000..cb62a4d
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/back_end/app.py
@@ -0,0 +1,460 @@
+from flask import Flask, jsonify, request, session
+from flask_sqlalchemy import SQLAlchemy
+from flask_cors import CORS
+
+app = Flask(__name__)
+app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:123456@10.126.59.25/redbook'
+app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
+app.secret_key = 'your_secret_key'
+CORS(app, supports_credentials=True)
+
+db = SQLAlchemy(app)
+
+# 模型定义
+# 用户表
+class User(db.Model):
+ __tablename__ = 'users'
+ id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='用户ID')
+ username = db.Column(db.String(50), unique=True, nullable=False, comment='用户名')
+ password = db.Column(db.String(255), nullable=False, comment='加密密码')
+ email = db.Column(db.String(100), unique=True, nullable=False, comment='邮箱')
+ avatar = db.Column(db.String(255), comment='头像URL')
+ role = db.Column(db.Enum('superadmin', 'user', 'admin'), default='user', comment='角色')
+ bio = db.Column(db.String(255), comment='个人简介')
+ status = db.Column(db.Enum('active', 'banned', 'muted'), default='active', comment='账号状态')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='创建时间')
+ updated_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(),
+ onupdate=db.func.current_timestamp(), comment='更新时间')
+
+ # 关系定义
+ posts = db.relationship('Post', backref='author', lazy=True)
+ behaviors = db.relationship('Behavior', backref='user', lazy=True)
+ comments = db.relationship('Comment', backref='commenter', lazy=True)
+ notifications = db.relationship('Notification', backref='recipient', lazy=True)
+ audits = db.relationship('Audit', backref='admin', lazy=True)
+ logs = db.relationship('Log', backref='logger', lazy=True)
+ user_tags = db.relationship('UserTag', backref='user', lazy=True)
+
+# 标签表
+class Tag(db.Model):
+ __tablename__ = 'tags'
+ id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='标签ID')
+ name = db.Column(db.String(50), unique=True, nullable=False, comment='标签名称')
+ description = db.Column(db.String(255), comment='标签描述')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='创建时间')
+
+ # 关系定义
+ post_tags = db.relationship('PostTag', backref='tag', lazy=True)
+ user_tags = db.relationship('UserTag', backref='tag', lazy=True)
+
+# 话题/超话表
+class Topic(db.Model):
+ __tablename__ = 'topics'
+ id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='话题ID')
+ name = db.Column(db.String(100), unique=True, nullable=False, comment='话题名称')
+ description = db.Column(db.Text, comment='话题描述')
+ status = db.Column(db.Enum('active', 'archived'), default='active', comment='状态')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='创建时间')
+
+ # 关系定义
+ posts = db.relationship('Post', backref='topic', lazy=True)
+
+# 内容帖子表
+class Post(db.Model):
+ __tablename__ = 'posts'
+ id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='帖子ID')
+ user_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), nullable=False, comment='作者ID')
+ topic_id = db.Column(db.Integer, db.ForeignKey('topics.id', ondelete='SET NULL'), comment='所属话题ID')
+ type = db.Column(db.Enum('text', 'image', 'video', 'document'), default='text', comment='内容类型')
+ title = db.Column(db.String(255), nullable=False, comment='标题')
+ content = db.Column(db.Text, nullable=False, comment='正文内容')
+ media_urls = db.Column(db.JSON, comment='媒体资源URL数组')
+ status = db.Column(db.Enum('draft', 'pending', 'published', 'deleted', 'rejected'), default='draft', comment='状态')
+ heat = db.Column(db.Integer, default=0, comment='热度值')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='创建时间')
+ updated_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(),
+ onupdate=db.func.current_timestamp(), comment='更新时间')
+
+ # 关系定义
+ behaviors = db.relationship('Behavior', backref='post', lazy=True)
+ comments = db.relationship('Comment', backref='post', lazy=True)
+ post_tags = db.relationship('PostTag', backref='post', lazy=True)
+ audits = db.relationship('Audit', backref='post', lazy=True)
+
+# 帖子标签关联表
+class PostTag(db.Model):
+ __tablename__ = 'post_tags'
+ post_id = db.Column(db.Integer, db.ForeignKey('posts.id', ondelete='CASCADE'), primary_key=True, comment='帖子ID')
+ tag_id = db.Column(db.Integer, db.ForeignKey('tags.id', ondelete='CASCADE'), primary_key=True, comment='标签ID')
+
+# 用户行为表
+class Behavior(db.Model):
+ __tablename__ = 'behaviors'
+ id = db.Column(db.BigInteger, primary_key=True, autoincrement=True, comment='行为ID')
+ user_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), nullable=False, comment='用户ID')
+ post_id = db.Column(db.Integer, db.ForeignKey('posts.id', ondelete='CASCADE'), nullable=False, comment='帖子ID')
+ type = db.Column(db.Enum('like', 'comment', 'favorite', 'view', 'share'), nullable=False, comment='行为类型')
+ value = db.Column(db.Integer, default=1, comment='行为值')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='行为时间')
+
+# 评论表
+class Comment(db.Model):
+ __tablename__ = 'comments'
+ id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='评论ID')
+ post_id = db.Column(db.Integer, db.ForeignKey('posts.id', ondelete='CASCADE'), nullable=False, comment='帖子ID')
+ user_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), nullable=False, comment='用户ID')
+ parent_id = db.Column(db.Integer, db.ForeignKey('comments.id', ondelete='CASCADE'), comment='父评论ID')
+ content = db.Column(db.Text, nullable=False, comment='评论内容')
+ status = db.Column(db.Enum('active', 'deleted'), default='active', comment='状态')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='创建时间')
+ updated_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(),
+ onupdate=db.func.current_timestamp(), comment='更新时间')
+
+ # 关系定义
+ replies = db.relationship('Comment', backref=db.backref('parent', remote_side=[id]), lazy=True)
+
+# 用户关注关系表
+class Follow(db.Model):
+ __tablename__ = 'follows'
+ follower_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), primary_key=True, comment='关注者ID')
+ followee_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), primary_key=True, comment='被关注者ID')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='关注时间')
+
+ # 关系定义
+ follower = db.relationship('User', foreign_keys=[follower_id], backref='following')
+ followee = db.relationship('User', foreign_keys=[followee_id], backref='followers')
+
+# 通知表
+class Notification(db.Model):
+ __tablename__ = 'notifications'
+ id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='通知ID')
+ user_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), nullable=False, comment='接收用户ID')
+ type = db.Column(db.Enum('like', 'comment', 'follow', 'system', 'audit'), nullable=False, comment='通知类型')
+ content = db.Column(db.JSON, nullable=False, comment='通知内容')
+ is_read = db.Column(db.Boolean, default=False, comment='是否已读')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='创建时间')
+
+# 审核记录表
+class Audit(db.Model):
+ __tablename__ = 'audits'
+ id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='审核ID')
+ post_id = db.Column(db.Integer, db.ForeignKey('posts.id', ondelete='CASCADE'), nullable=False, comment='帖子ID')
+ admin_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), nullable=False, comment='管理员ID')
+ result = db.Column(db.Enum('approved', 'rejected'), nullable=False, comment='审核结果')
+ reason = db.Column(db.String(255), comment='审核原因')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='审核时间')
+
+# 日志表
+class Log(db.Model):
+ __tablename__ = 'logs'
+ id = db.Column(db.BigInteger, primary_key=True, autoincrement=True, comment='日志ID')
+ user_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='SET NULL'), comment='用户ID')
+ type = db.Column(db.Enum('access', 'error', 'behavior', 'system'), nullable=False, comment='日志类型')
+ content = db.Column(db.Text, nullable=False, comment='日志内容')
+ ip = db.Column(db.String(45), comment='IP地址')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='记录时间')
+
+# 用户兴趣标签表
+class UserTag(db.Model):
+ __tablename__ = 'user_tags'
+ user_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), primary_key=True, comment='用户ID')
+ tag_id = db.Column(db.Integer, db.ForeignKey('tags.id', ondelete='CASCADE'), primary_key=True, comment='标签ID')
+ weight = db.Column(db.Float, default=1.0, comment='兴趣权重')
+ created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(), comment='创建时间')
+ updated_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp(),
+ onupdate=db.func.current_timestamp(), comment='更新时间')
+
+
+# 自动登录用户11
+@app.before_request
+def auto_login():
+ # 如果用户未登录，自动设置为用户11
+ if 'user_id' not in session:
+ session['user_id'] = 11
+
+# 获取当前用户信息
+@app.route('/api/current-user')
+def current_user():
+ user_id = session.get('user_id', 1)
+ user = User.query.get(user_id)
+ if not user:
+ return jsonify({'error': 'User not found'}), 404
+
+ following_count = Follow.query.filter_by(follower_id=user_id).count()
+ followers_count = Follow.query.filter_by(followee_id=user_id).count()
+
+ return jsonify({
+ 'id': user.id,
+ 'username': user.username,
+ 'email': user.email,
+ 'avatar': user.avatar,
+ 'bio': user.bio,
+ 'following_count': following_count,
+ 'followers_count': followers_count
+ })
+
+# 获取指定用户信息
+@app.route('/api/user/<int:user_id>')
+def get_user(user_id):
+ current_user_id = session.get('user_id', 1)
+ user = User.query.get(user_id)
+ if not user:
+ return jsonify({'error': 'User not found'}), 404
+
+ following_count = Follow.query.filter_by(follower_id=user_id).count()
+ followers_count = Follow.query.filter_by(followee_id=user_id).count()
+
+ is_following = False
+ if current_user_id:
+ is_following = Follow.query.filter_by(
+ follower_id=current_user_id,
+ followee_id=user_id
+ ).first() is not None
+
+ return jsonify({
+ 'id': user.id,
+ 'username': user.username,
+ 'avatar': user.avatar,
+ 'bio': user.bio,
+ 'following_count': following_count,
+ 'followers_count': followers_count,
+ 'is_following': is_following
+ })
+
+# 更新用户信息
+@app.route('/api/user/<int:user_id>', methods=['PUT'])
+def update_user(user_id):
+ current_user_id = session.get('user_id', 1)
+ if current_user_id != user_id:
+ return jsonify({'error': 'Unauthorized'}), 403
+
+ user = User.query.get(user_id)
+ if not user:
+ return jsonify({'error': 'User not found'}), 404
+
+ data = request.json
+ if 'avatar' in data:
+ user.avatar = data['avatar']
+ if 'bio' in data:
+ user.bio = data['bio']
+
+ db.session.commit()
+ return jsonify({
+ 'id': user.id,
+ 'avatar': user.avatar,
+ 'bio': user.bio
+ })
+
+# 获取用户收藏
+@app.route('/api/user/<int:user_id>/favorites', methods=['GET'])
+def get_user_favorites(user_id):
+ # 检查用户是否登录
+ if 'user_id' not in session:
+ return jsonify({'error': '未登录'}), 401
+
+ # 验证请求的用户ID与登录用户ID是否一致
+ if session['user_id'] != user_id:
+ return jsonify({'error': '无权访问其他用户的收藏'}), 403
+
+ try:
+ # 获取收藏行为及其关联的帖子
+ favorites = db.session.query(Behavior, Post).join(
+ Post, Behavior.post_id == Post.id
+ ).filter(
+ Behavior.user_id == user_id,
+ Behavior.type == 'favorite'
+ ).all()
+
+ # 构建响应数据
+ result = []
+ for behavior, post in favorites:
+ # 获取帖子作者信息
+ author = User.query.get(post.user_id)
+
+ # 构建响应对象
+ result.append({
+ 'behavior_id': behavior.id,
+ 'post': {
+ 'id': post.id,
+ 'title': post.title,
+ 'type': post.type,
+ 'content_preview': post.content[:100] + '...' if len(post.content) > 100 else post.content,
+ 'media_urls': post.media_urls,
+ 'created_at': post.created_at.strftime('%Y-%m-%d %H:%M:%S'),
+ 'author': {
+ 'id': author.id,
+ 'username': author.username,
+ 'avatar': author.avatar
+ }
+ },
+ 'favorited_at': behavior.created_at.strftime('%Y-%m-%d %H:%M:%S')
+ })
+
+ return jsonify(result)
+
+ except Exception as e:
+ app.logger.error(f"获取收藏时出错: {str(e)}")
+ return jsonify({'error': '获取收藏失败'}), 500
+
+
+# 获取用户发布的帖子
+@app.route('/api/user/<int:user_id>/posts')
+def get_user_posts(user_id):
+ # 允许任何人查看用户发布的帖子
+ posts = Post.query.filter_by(
+ user_id=user_id,
+ status='published'
+ ).all()
+
+ return jsonify([{
+ 'id': post.id,
+ 'title': post.title,
+ 'content': post.content[:100] + '...' if len(post.content) > 100 else post.content,
+ 'type': post.type,
+ 'heat': post.heat,
+ 'created_at': post.created_at.strftime('%Y-%m-%d %H:%M')
+ } for post in posts])
+
+# 获取用户关注列表
+@app.route('/api/user/<int:user_id>/following')
+def get_user_following(user_id):
+ # 允许任何人查看用户的关注列表
+ following = Follow.query.filter_by(follower_id=user_id).all()
+
+ # 获取被关注用户的详细信息
+ following_list = []
+ for follow in following:
+ user = User.query.get(follow.followee_id)
+ if user:
+ followers_count = Follow.query.filter_by(followee_id=user.id).count()
+
+ following_list.append({
+ 'id': user.id,
+ 'username': user.username,
+ 'avatar': user.avatar,
+ 'followers_count': followers_count
+ })
+
+ return jsonify(following_list)
+
+# 关注/取消关注用户
+@app.route('/api/follow/<int:followee_id>', methods=['POST', 'DELETE'])
+def follow_user(followee_id):
+ follower_id = session.get('user_id', 1)
+ if follower_id == followee_id:
+ return jsonify({'error': 'Cannot follow yourself'}), 400
+
+ if request.method == 'POST':
+ existing = Follow.query.filter_by(
+ follower_id=follower_id,
+ followee_id=followee_id
+ ).first()
+
+ if not existing:
+ follow = Follow(
+ follower_id=follower_id,
+ followee_id=followee_id
+ )
+ db.session.add(follow)
+ db.session.commit()
+ return jsonify({'message': 'Followed successfully'})
+
+ elif request.method == 'DELETE':
+ follow = Follow.query.filter_by(
+ follower_id=follower_id,
+ followee_id=followee_id
+ ).first()
+
+ if follow:
+ db.session.delete(follow)
+ db.session.commit()
+ return jsonify({'message': 'Unfollowed successfully'})
+
+
+# 新增获取粉丝列表的API
+@app.route('/api/user/<int:user_id>/followers')
+def get_user_followers(user_id):
+ try:
+ # 查询关注该用户的用户列表
+ followers = db.session.query(User).join(
+ Follow, Follow.follower_id == User.id
+ ).filter(
+ Follow.followee_id == user_id
+ ).all()
+
+ # 获取当前登录用户ID（如果有）
+ current_user_id = session.get('user_id') if 'user_id' in session else None
+
+ # 构建响应数据
+ result = []
+ for user in followers:
+ # 检查当前用户是否关注了这个粉丝
+ is_following = False
+ if current_user_id:
+ follow_relation = Follow.query.filter_by(
+ follower_id=current_user_id,
+ followee_id=user.id
+ ).first()
+ is_following = follow_relation is not None
+
+ # 计算该粉丝的粉丝数
+ followers_count = Follow.query.filter_by(followee_id=user.id).count()
+
+ result.append({
+ 'id': user.id,
+ 'username': user.username,
+ 'avatar': user.avatar,
+ 'bio': user.bio,
+ 'followers_count': followers_count,
+ 'is_following': is_following
+ })
+
+
+ return jsonify({
+ 'success': True,
+ 'data': result
+ })
+
+ except Exception as e:
+ app.logger.error(f"获取粉丝列表失败: {str(e)}")
+ return jsonify({
+ 'success': False,
+ 'error': '获取粉丝列表失败'
+ }), 500
+
+# 辅助函数：检查当前用户是否关注了目标用户
+def check_following_status(follower_id, followee_id):
+ return Follow.query.filter_by(
+ follower_id=follower_id,
+ followee_id=followee_id
+ ).first() is not None
+
+
+# 记录用户点赞收藏总数
+@app.route('/api/user/<int:user_id>/interactions', methods=['GET'])
+def get_user_interactions(user_id):
+ try:
+ # 计算用户的获赞总数（所有帖子的点赞数）
+ like_count = db.session.query(db.func.sum(Behavior.value)).filter(
+ Behavior.post.has(user_id=user_id),
+ Behavior.type == 'like'
+ ).scalar() or 0
+
+ # 计算用户的收藏总数（所有帖子的收藏数）
+ favorite_count = db.session.query(db.func.sum(Behavior.value)).filter(
+ Behavior.post.has(user_id=user_id),
+ Behavior.type == 'favorite'
+ ).scalar() or 0
+
+ return jsonify({
+ 'likes_count': like_count,
+ 'favorites_count': favorite_count
+ })
+
+ except Exception as e:
+ app.logger.error(f"获取用户互动数据失败: {str(e)}")
+ return jsonify({'error': '获取互动数据失败'}), 500
+
+
+if __name__ == '__main__':
+ app.run(debug=True)
\ No newline at end of file
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/.gitignore b/xiaohongshu-upload-platform/src/ljc/personalpage/.gitignore
new file mode 100644
index 0000000..4d29575
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/.gitignore
@@ -0,0 +1,23 @@
+# See https://help.github.com/articles/ignoring-files/ for more about ignoring files.
+
+# dependencies
+/node_modules
+/.pnp
+.pnp.js
+
+# testing
+/coverage
+
+# production
+/build
+
+# misc
+.DS_Store
+.env.local
+.env.development.local
+.env.test.local
+.env.production.local
+
+npm-debug.log*
+yarn-debug.log*
+yarn-error.log*
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/README.md b/xiaohongshu-upload-platform/src/ljc/personalpage/README.md
new file mode 100644
index 0000000..58beeac
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/README.md
@@ -0,0 +1,70 @@
+# Getting Started with Create React App
+
+This project was bootstrapped with [Create React App](https://github.com/facebook/create-react-app).
+
+## Available Scripts
+
+In the project directory, you can run:
+
+### `npm start`
+
+Runs the app in the development mode.\
+Open [http://localhost:3000](http://localhost:3000) to view it in your browser.
+
+The page will reload when you make changes.\
+You may also see any lint errors in the console.
+
+### `npm test`
+
+Launches the test runner in the interactive watch mode.\
+See the section about [running tests](https://facebook.github.io/create-react-app/docs/running-tests) for more information.
+
+### `npm run build`
+
+Builds the app for production to the `build` folder.\
+It correctly bundles React in production mode and optimizes the build for the best performance.
+
+The build is minified and the filenames include the hashes.\
+Your app is ready to be deployed!
+
+See the section about [deployment](https://facebook.github.io/create-react-app/docs/deployment) for more information.
+
+### `npm run eject`
+
+**Note: this is a one-way operation. Once you `eject`, you can't go back!**
+
+If you aren't satisfied with the build tool and configuration choices, you can `eject` at any time. This command will remove the single build dependency from your project.
+
+Instead, it will copy all the configuration files and the transitive dependencies (webpack, Babel, ESLint, etc) right into your project so you have full control over them. All of the commands except `eject` will still work, but they will point to the copied scripts so you can tweak them. At this point you're on your own.
+
+You don't have to ever use `eject`. The curated feature set is suitable for small and middle deployments, and you shouldn't feel obligated to use this feature. However we understand that this tool wouldn't be useful if you couldn't customize it when you are ready for it.
+
+## Learn More
+
+You can learn more in the [Create React App documentation](https://facebook.github.io/create-react-app/docs/getting-started).
+
+To learn React, check out the [React documentation](https://reactjs.org/).
+
+### Code Splitting
+
+This section has moved here: [https://facebook.github.io/create-react-app/docs/code-splitting](https://facebook.github.io/create-react-app/docs/code-splitting)
+
+### Analyzing the Bundle Size
+
+This section has moved here: [https://facebook.github.io/create-react-app/docs/analyzing-the-bundle-size](https://facebook.github.io/create-react-app/docs/analyzing-the-bundle-size)
+
+### Making a Progressive Web App
+
+This section has moved here: [https://facebook.github.io/create-react-app/docs/making-a-progressive-web-app](https://facebook.github.io/create-react-app/docs/making-a-progressive-web-app)
+
+### Advanced Configuration
+
+This section has moved here: [https://facebook.github.io/create-react-app/docs/advanced-configuration](https://facebook.github.io/create-react-app/docs/advanced-configuration)
+
+### Deployment
+
+This section has moved here: [https://facebook.github.io/create-react-app/docs/deployment](https://facebook.github.io/create-react-app/docs/deployment)
+
+### `npm run build` fails to minify
+
+This section has moved here: [https://facebook.github.io/create-react-app/docs/troubleshooting#npm-run-build-fails-to-minify](https://facebook.github.io/create-react-app/docs/troubleshooting#npm-run-build-fails-to-minify)
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/package.json b/xiaohongshu-upload-platform/src/ljc/personalpage/package.json
new file mode 100644
index 0000000..9cd7e67
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/package.json
@@ -0,0 +1,49 @@
+{
+ "name": "personalpage",
+ "version": "0.1.0",
+ "private": true,
+ "dependencies": {
+ "@emotion/react": "^11.14.0",
+ "@emotion/styled": "^11.14.0",
+ "@mui/icons-material": "^7.1.1",
+ "@mui/material": "^7.1.1",
+ "@testing-library/dom": "^10.4.0",
+ "@testing-library/jest-dom": "^6.6.3",
+ "@testing-library/react": "^16.3.0",
+ "@testing-library/user-event": "^13.5.0",
+ "ajv": "^8.0.0",
+ "ajv-keywords": "^5.0.0",
+ "axios": "^1.9.0",
+ "mui": "^0.0.1",
+ "react": "^19.1.0",
+ "react-dom": "^19.1.0",
+ "react-icons": "^5.5.0",
+ "react-router-dom": "^6.30.1",
+ "react-scripts": "5.0.1",
+ "web-vitals": "^2.1.4"
+ },
+ "scripts": {
+ "start": "react-scripts start",
+ "build": "react-scripts build",
+ "test": "react-scripts test",
+ "eject": "react-scripts eject"
+ },
+ "eslintConfig": {
+ "extends": [
+ "react-app",
+ "react-app/jest"
+ ]
+ },
+ "browserslist": {
+ "production": [
+ ">0.2%",
+ "not dead",
+ "not op_mini all"
+ ],
+ "development": [
+ "last 1 chrome version",
+ "last 1 firefox version",
+ "last 1 safari version"
+ ]
+ }
+}
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/public/favicon.ico b/xiaohongshu-upload-platform/src/ljc/personalpage/public/favicon.ico
new file mode 100644
index 0000000..a11777c
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/public/favicon.ico
Binary files differ
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/public/index.html b/xiaohongshu-upload-platform/src/ljc/personalpage/public/index.html
new file mode 100644
index 0000000..aa069f2
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/public/index.html
@@ -0,0 +1,43 @@
+<!DOCTYPE html>
+<html lang="en">
+ <head>
+ <meta charset="utf-8" />
+ <link rel="icon" href="%PUBLIC_URL%/favicon.ico" />
+ <meta name="viewport" content="width=device-width, initial-scale=1" />
+ <meta name="theme-color" content="#000000" />
+ <meta
+ name="description"
+ content="Web site created using create-react-app"
+ />
+ <link rel="apple-touch-icon" href="%PUBLIC_URL%/logo192.png" />
+ <!--
+ manifest.json provides metadata used when your web app is installed on a
+ user's mobile device or desktop. See https://developers.google.com/web/fundamentals/web-app-manifest/
+ -->
+ <link rel="manifest" href="%PUBLIC_URL%/manifest.json" />
+ <!--
+ Notice the use of %PUBLIC_URL% in the tags above.
+ It will be replaced with the URL of the `public` folder during the build.
+ Only files inside the `public` folder can be referenced from the HTML.
+
+ Unlike "/favicon.ico" or "favicon.ico", "%PUBLIC_URL%/favicon.ico" will
+ work correctly both with client-side routing and a non-root public URL.
+ Learn how to configure a non-root public URL by running `npm run build`.
+ -->
+ <title>React App</title>
+ </head>
+ <body>
+ <noscript>You need to enable JavaScript to run this app.</noscript>
+ <div id="root"></div>
+ <!--
+ This HTML file is a template.
+ If you open it directly in the browser, you will see an empty page.
+
+ You can add webfonts, meta tags, or analytics to this file.
+ The build step will place the bundled scripts into the <body> tag.
+
+ To begin the development, run `npm start` or `yarn start`.
+ To create a production bundle, use `npm run build` or `yarn build`.
+ -->
+ </body>
+</html>
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/public/logo192.png b/xiaohongshu-upload-platform/src/ljc/personalpage/public/logo192.png
new file mode 100644
index 0000000..fc44b0a
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/public/logo192.png
Binary files differ
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/public/logo512.png b/xiaohongshu-upload-platform/src/ljc/personalpage/public/logo512.png
new file mode 100644
index 0000000..a4e47a6
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/public/logo512.png
Binary files differ
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/public/manifest.json b/xiaohongshu-upload-platform/src/ljc/personalpage/public/manifest.json
new file mode 100644
index 0000000..080d6c7
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/public/manifest.json
@@ -0,0 +1,25 @@
+{
+ "short_name": "React App",
+ "name": "Create React App Sample",
+ "icons": [
+ {
+ "src": "favicon.ico",
+ "sizes": "64x64 32x32 24x24 16x16",
+ "type": "image/x-icon"
+ },
+ {
+ "src": "logo192.png",
+ "type": "image/png",
+ "sizes": "192x192"
+ },
+ {
+ "src": "logo512.png",
+ "type": "image/png",
+ "sizes": "512x512"
+ }
+ ],
+ "start_url": ".",
+ "display": "standalone",
+ "theme_color": "#000000",
+ "background_color": "#ffffff"
+}
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/public/robots.txt b/xiaohongshu-upload-platform/src/ljc/personalpage/public/robots.txt
new file mode 100644
index 0000000..e9e57dc
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/public/robots.txt
@@ -0,0 +1,3 @@
+# https://www.robotstxt.org/robotstxt.html
+User-agent: *
+Disallow:
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/App.css b/xiaohongshu-upload-platform/src/ljc/personalpage/src/App.css
new file mode 100644
index 0000000..74b5e05
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/App.css
@@ -0,0 +1,38 @@
+.App {
+ text-align: center;
+}
+
+.App-logo {
+ height: 40vmin;
+ pointer-events: none;
+}
+
+@media (prefers-reduced-motion: no-preference) {
+ .App-logo {
+ animation: App-logo-spin infinite 20s linear;
+ }
+}
+
+.App-header {
+ background-color: #282c34;
+ min-height: 100vh;
+ display: flex;
+ flex-direction: column;
+ align-items: center;
+ justify-content: center;
+ font-size: calc(10px + 2vmin);
+ color: white;
+}
+
+.App-link {
+ color: #61dafb;
+}
+
+@keyframes App-logo-spin {
+ from {
+ transform: rotate(0deg);
+ }
+ to {
+ transform: rotate(360deg);
+ }
+}
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/App.js b/xiaohongshu-upload-platform/src/ljc/personalpage/src/App.js
new file mode 100644
index 0000000..ed241f4
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/App.js
@@ -0,0 +1,77 @@
+import React from 'react';
+import { BrowserRouter, Routes, Route, Navigate, useParams } from 'react-router-dom';
+import UserProfile from './components/UserProfile';
+import { FaHome, FaSearch, FaPlus, FaHeart, FaUser } from 'react-icons/fa';
+
+function App() {
+ return (
+ <BrowserRouter>
+ <div className="min-h-screen bg-gray-50">
+ {/* 顶部导航栏 */}
+ <header className="bg-white shadow-sm sticky top-0 z-10">
+ <div className="max-w-6xl mx-auto px-4 py-3 flex justify-between items-center">
+ <div className="flex items-center">
+ <div className="text-2xl font-bold text-red-500 mr-2">小红书</div>
+ <div className="hidden md:block text-sm text-gray-500">发现美好生活</div>
+ </div>
+ <div className="flex space-x-4">
+ <a href="/user/11" className="text-gray-600 hover:text-red-500">
+ 用户11
+ </a>
+ <a href="/user/2" className="text-gray-600 hover:text-red-500">
+ 用户2
+ </a>
+ <a href="/user/3" className="text-gray-600 hover:text-red-500">
+ 用户3
+ </a>
+ </div>
+ </div>
+ </header>
+
+ <main className="py-5">
+ <div className="max-w-6xl mx-auto">
+ <Routes>
+ <Route path="/" element={<Navigate to="/user/11" replace />} />
+ <Route path="/user/:userId" element={<UserProfileRoute />} />
+ </Routes>
+ </div>
+ </main>
+
+ {/* 小红书风格底部导航栏 */}
+ <div className="fixed bottom-0 left-0 right-0 bg-white border-t border-gray-200 py-2 z-10">
+ <div className="max-w-md mx-auto grid grid-cols-5">
+ <button className="flex flex-col items-center text-red-500">
+ <FaHome className="text-xl" />
+ <span className="text-xs mt-1">首页</span>
+ </button>
+ <button className="flex flex-col items-center text-gray-500">
+ <FaSearch className="text-xl" />
+ <span className="text-xs mt-1">发现</span>
+ </button>
+ <button className="flex flex-col items-center text-gray-500">
+ <div className="bg-red-500 rounded-full p-2 -mt-3">
+ <FaPlus className="text-white text-lg" />
+ </div>
+ <span className="text-xs mt-2">发布</span>
+ </button>
+ <button className="flex flex-col items-center text-gray-500">
+ <FaHeart className="text-xl" />
+ <span className="text-xs mt-1">消息</span>
+ </button>
+ <button className="flex flex-col items-center text-gray-500">
+ <FaUser className="text-xl" />
+ <span className="text-xs mt-1">我</span>
+ </button>
+ </div>
+ </div>
+ </div>
+ </BrowserRouter>
+ );
+}
+
+function UserProfileRoute() {
+ const { userId } = useParams();
+ return <UserProfile userId={parseInt(userId)} />;
+}
+
+export default App;
\ No newline at end of file
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/App.test.js b/xiaohongshu-upload-platform/src/ljc/personalpage/src/App.test.js
new file mode 100644
index 0000000..1f03afe
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/App.test.js
@@ -0,0 +1,8 @@
+import { render, screen } from '@testing-library/react';
+import App from './App';
+
+test('renders learn react link', () => {
+ render(<App />);
+ const linkElement = screen.getByText(/learn react/i);
+ expect(linkElement).toBeInTheDocument();
+});
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/EditProfileForm.jsx b/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/EditProfileForm.jsx
new file mode 100644
index 0000000..d33cbcb
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/EditProfileForm.jsx
@@ -0,0 +1,116 @@
+import React, { useState } from 'react';
+import { FaCamera, FaTimes } from 'react-icons/fa';
+
+const EditProfileForm = ({ user, onSave, onCancel }) => {
+ const [avatar, setAvatar] = useState(user.avatar || '');
+ const [bio, setBio] = useState(user.bio || '');
+ const [gender, setGender] = useState('secret');
+ const [birthday, setBirthday] = useState('');
+ const [location, setLocation] = useState('');
+
+ const handleSubmit = (e) => {
+ e.preventDefault();
+ onSave({ avatar, bio });
+ };
+
+ return (
+ <form onSubmit={handleSubmit}>
+ <div className="mb-6">
+ <label className="block text-sm font-medium text-gray-700 mb-2">头像</label>
+ <div className="flex items-center">
+ <div className="relative">
+ <div className="w-20 h-20 rounded-full bg-gradient-to-r from-pink-300 to-orange-300 flex items-center justify-center">
+ {avatar ? (
+ <img src={avatar} alt="Avatar" className="w-full h-full rounded-full" />
+ ) : (
+ <div className="text-white text-2xl">{user.username.charAt(0)}</div>
+ )}
+ </div>
+ <button
+ type="button"
+ className="absolute bottom-0 right-0 bg-white rounded-full p-1 shadow-md"
+ >
+ <FaCamera className="text-gray-700 text-sm" />
+ </button>
+ </div>
+ <div className="ml-4">
+ <input
+ type="text"
+ value={avatar}
+ onChange={(e) => setAvatar(e.target.value)}
+ placeholder="输入头像URL"
+ className="w-full rounded-md border-gray-300 shadow-sm text-sm"
+ />
+ </div>
+ </div>
+ </div>
+
+ <div className="mb-4">
+ <label className="block text-sm font-medium text-gray-700 mb-2">个人简介</label>
+ <textarea
+ value={bio}
+ onChange={(e) => setBio(e.target.value)}
+ rows="3"
+ maxLength="100"
+ className="mt-1 block w-full rounded-md border-gray-300 shadow-sm text-sm"
+ placeholder="介绍一下自己吧～"
+ />
+ <div className="text-right text-xs text-gray-500 mt-1">{bio.length}/100</div>
+ </div>
+
+ <div className="grid grid-cols-2 gap-4 mb-4">
+ <div>
+ <label className="block text-sm font-medium text-gray-700 mb-2">性别</label>
+ <select
+ value={gender}
+ onChange={(e) => setGender(e.target.value)}
+ className="mt-1 block w-full rounded-md border-gray-300 shadow-sm text-sm"
+ >
+ <option value="secret">保密</option>
+ <option value="male">男</option>
+ <option value="female">女</option>
+ </select>
+ </div>
+
+ <div>
+ <label className="block text-sm font-medium text-gray-700 mb-2">生日</label>
+ <input
+ type="date"
+ value={birthday}
+ onChange={(e) => setBirthday(e.target.value)}
+ className="mt-1 block w-full rounded-md border-gray-300 shadow-sm text-sm"
+ />
+ </div>
+ </div>
+
+ <div className="mb-6">
+ <label className="block text-sm font-medium text-gray-700 mb-2">地区</label>
+ <input
+ type="text"
+ value={location}
+ onChange={(e) => setLocation(e.target.value)}
+ placeholder="填写你所在的城市"
+ className="mt-1 block w-full rounded-md border-gray-300 shadow-sm text-sm"
+ />
+ </div>
+
+ <div className="flex justify-end space-x-3">
+ <button
+ type="button"
+ onClick={onCancel}
+ className="px-5 py-2 bg-gray-100 text-gray-700 rounded-full text-sm hover:bg-gray-200"
+ >
+ 取消
+ </button>
+ <button
+ type="submit"
+ className="px-5 py-2 bg-red-500 text-white rounded-full text-sm hover:bg-red-600"
+ >
+ 保存
+ </button>
+ </div>
+ </form>
+ );
+};
+
+export default EditProfileForm;
\ No newline at end of file
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/FavoritePosts.jsx b/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/FavoritePosts.jsx
new file mode 100644
index 0000000..4033d7b
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/FavoritePosts.jsx
@@ -0,0 +1,95 @@
+import React, { useState, useEffect } from 'react';
+import { getFavorites } from '../services/api';
+import { FaHeart } from 'react-icons/fa';
+
+const FavoritePosts = ({ userId }) => {
+ const [favorites, setFavorites] = useState([]);
+ const [loading, setLoading] = useState(true);
+
+ useEffect(() => {
+ const fetchFavorites = async () => {
+ try {
+ setLoading(true);
+ const response = await getFavorites(userId);
+ setFavorites(response.data);
+ } catch (error) {
+ console.error('Failed to fetch favorites:', error);
+ } finally {
+ setLoading(false);
+ }
+ };
+
+ if (userId) {
+ fetchFavorites();
+ }
+ }, [userId]);
+
+ if (loading) {
+ return (
+ <div className="grid grid-cols-2 md:grid-cols-3 gap-4">
+ {[1, 2, 3, 4, 5, 6].map(item => (
+ <div key={item} className="bg-gray-100 rounded-xl aspect-square animate-pulse"></div>
+ ))}
+ </div>
+ );
+ }
+
+ if (favorites.length === 0) {
+ return (
+ <div className="text-center py-16">
+ <div className="inline-flex items-center justify-center w-16 h-16 rounded-full bg-red-100 text-red-500 mb-4">
+ <FaHeart className="text-2xl" />
+ </div>
+ <h3 className="text-lg font-medium text-gray-900">暂无收藏内容</h3>
+ <p className="mt-1 text-gray-500">你还没有收藏任何笔记</p>
+ </div>
+ );
+ }
+
+ // 模拟瀑布流布局数据
+ const waterfallData = favorites.map(post => ({
+ ...post,
+ height: Math.floor(Math.random() * 100) + 200 // 随机高度
+ }));
+
+ return (
+ <div className="grid grid-cols-2 md:grid-cols-3 gap-4">
+ {waterfallData.map(post => (
+ <div
+ key={post.id}
+ className="bg-white rounded-xl overflow-hidden shadow-sm hover:shadow-md transition-shadow"
+ >
+ <div
+ className="relative bg-gray-200"
+ style={{ height: `${post.height}px` }}
+ >
+ {/* 占位图片 */}
+ <div className="absolute inset-0 bg-gradient-to-br from-pink-100 to-orange-100"></div>
+
+ {/* 类型标签 */}
+ <div className="absolute top-2 right-2 bg-black bg-opacity-50 text-white text-xs px-2 py-1 rounded-full">
+ {post.type === 'image' ? '图文' :
+ post.type === 'video' ? '视频' : '文档'}
+ </div>
+
+ {/* 收藏标记 */}
+ <div className="absolute bottom-2 right-2 bg-red-500 rounded-full p-1">
+ <FaHeart className="text-white text-xs" />
+ </div>
+ </div>
+
+ <div className="p-3">
+ <h3 className="font-medium line-clamp-2">{post.title}</h3>
+ <div className="flex items-center mt-2 text-xs text-gray-500">
+ <span>❤️ 2.5k</span>
+ <span className="mx-2">•</span>
+ <span>⭐ 156</span>
+ </div>
+ </div>
+ </div>
+ ))}
+ </div>
+ );
+};
+
+export default FavoritePosts;
\ No newline at end of file
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/FollowButton.jsx b/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/FollowButton.jsx
new file mode 100644
index 0000000..9e738d4
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/FollowButton.jsx
@@ -0,0 +1,33 @@
+import React from 'react';
+import { followUser, unfollowUser } from '../services/api';
+
+const FollowButton = ({ userId, isFollowing, onFollowChange }) => {
+ const handleFollow = async () => {
+ try {
+ if (isFollowing) {
+ await unfollowUser(userId);
+ onFollowChange(false);
+ } else {
+ await followUser(userId);
+ onFollowChange(true);
+ }
+ } catch (error) {
+ console.error('关注操作失败:', error);
+ }
+ };
+
+ return (
+ <button
+ onClick={handleFollow}
+ className={`px-6 py-2 rounded-full text-sm font-medium transition-all ${
+ isFollowing
+ ? 'bg-gray-100 text-gray-800 hover:bg-gray-200'
+ : 'bg-red-500 text-white hover:bg-red-600'
+ }`}
+ >
+ {isFollowing ? '已关注' : '关注'}
+ </button>
+ );
+};
+
+export default FollowButton;
\ No newline at end of file
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/UserProfile.jsx b/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/UserProfile.jsx
new file mode 100644
index 0000000..ee361de
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/components/UserProfile.jsx
@@ -0,0 +1,1144 @@
+import React, { useState, useEffect } from 'react';
+import {
+ Box,
+ Grid,
+ Typography,
+ Avatar,
+ Button,
+ Tabs,
+ Tab,
+ Card,
+ CardMedia,
+ CardContent,
+ CardActions,
+ IconButton,
+ Divider,
+ List,
+ ListItem,
+ ListItemAvatar,
+ ListItemText,
+ TextField,
+ InputAdornment,
+ Chip,
+ Badge,
+ Fab,
+ Paper,
+ MenuItem,
+ Container,
+ useMediaQuery,
+ useTheme,
+ CircularProgress,
+ Snackbar,
+ Alert
+} from '@mui/material';
+import {
+ CameraAlt,
+ Edit,
+ Favorite,
+ Bookmark,
+ Share,
+ MoreVert,
+ LocationOn,
+ Cake,
+ Female,
+ Male,
+ Public,
+ Add,
+ Search,
+ Notifications,
+ Person,
+ Collections,
+ Group,
+ ChevronLeft,
+ ChevronRight,
+ Close,
+ People
+} from '@mui/icons-material';
+import { createTheme, ThemeProvider } from '@mui/material/styles';
+import { Link, useNavigate } from 'react-router-dom';
+
+// 导入API服务
+import {
+ getCurrentUser,
+ getUser,
+ updateUser as updateUserApi,
+ getFavorites,
+ followUser as followUserApi,
+ unfollowUser as unfollowUserApi,
+ getUserPosts,
+ getUserFollowing,
+ getUserInteractions,
+ getUserFollowers
+} from '../services/api';
+
+// 创建小红书主题
+const theme = createTheme({
+ palette: {
+ primary: {
+ main: '#ff4081',
+ },
+ secondary: {
+ main: '#f50057',
+ },
+ background: {
+ default: '#f5f5f5',
+ },
+ },
+ typography: {
+ fontFamily: '"PingFang SC", "Helvetica Neue", Arial, sans-serif',
+ h5: {
+ fontWeight: 600,
+ },
+ subtitle1: {
+ color: 'rgba(0, 0, 0, 0.6)',
+ },
+ },
+ components: {
+ MuiButton: {
+ styleOverrides: {
+ root: {
+ borderRadius: 20,
+ textTransform: 'none',
+ fontWeight: 500,
+ },
+ },
+ },
+ MuiCard: {
+ styleOverrides: {
+ root: {
+ borderRadius: 16,
+ },
+ },
+ },
+ },
+});
+
+const UserProfile = ({ userId }) => {
+ const theme = useTheme();
+ const isMobile = useMediaQuery(theme.breakpoints.down('sm'));
+ const navigate = useNavigate();
+ const [activeTab, setActiveTab] = useState(0);
+ const [isEditing, setIsEditing] = useState(false);
+ const [followers, setFollowers] = useState([]);
+ const [snackbar, setSnackbar] = useState({ open: false, message: '', severity: 'success' });
+
+ // 用户数据状态
+ const [currentUser, setCurrentUser] = useState(null);
+ const [profileUser, setProfileUser] = useState(null);
+ const [favorites, setFavorites] = useState([]);
+ const [following, setFollowing] = useState([]);
+ const [posts, setPosts] = useState([]);
+ const [interactions, setInteractions] = useState({
+ likes_count: 0,
+ favorites_count: 0
+ });
+
+ // 加载状态
+ const [loading, setLoading] = useState(true);
+ const [updating, setUpdating] = useState(false);
+ const [tabLoading, setTabLoading] = useState(false);
+
+ // 表单状态
+ const [formData, setFormData] = useState({
+ avatar: '',
+ bio: '',
+ gender: 'female',
+ birthday: '1995-05-20',
+ location: '上海'
+ });
+
+ // 显示提示信息
+ const showSnackbar = (message, severity = 'success') => {
+ setSnackbar({ open: true, message, severity });
+ };
+
+ // 加载用户数据
+ useEffect(() => {
+ const fetchInteractions = async () => {
+ try {
+ const response = await getUserInteractions(userId);
+ if (response.data.success) {
+ setInteractions(response.data.data);
+ } else {
+ console.error(response.data.error);
+ }
+ } catch (error) {
+ console.error('获取互动数据失败:', error);
+ }
+ };
+
+ fetchInteractions();
+
+ const handleFollowUser = async (followeeId) => {
+ try {
+ await followUserApi(followeeId);
+ showSnackbar('关注成功');
+
+ // 更新粉丝列表状态（将刚关注的用户标记为已关注）
+ setFollowers(prev => prev.map(user =>
+ user.id === followeeId ? { ...user, is_following: true } : user
+ ));
+
+ // 更新当前用户关注数
+ if (currentUser) {
+ setCurrentUser(prev => ({
+ ...prev,
+ following_count: prev.following_count + 1
+ }));
+ }
+
+ } catch (error) {
+ console.error('关注操作失败:', error);
+ showSnackbar('关注失败，请重试', 'error');
+ }
+ };
+ const fetchData = async () => {
+ try {
+ setLoading(true);
+
+ // 获取当前登录用户
+ const currentUserRes = await getCurrentUser();
+ setCurrentUser(currentUserRes.data);
+
+ // 获取目标用户信息
+ const profileUserRes = await getUser(userId);
+ setProfileUser(profileUserRes.data);
+ setFormData({
+ avatar: profileUserRes.data.avatar || '',
+ bio: profileUserRes.data.bio || '',
+ gender: 'female',
+ birthday: '1995-05-20',
+ location: '上海'
+ });
+
+ // 获取用户帖子
+ const postsRes = await getUserPosts(userId);
+ setPosts(postsRes.data);
+
+ // 获取用户互动数据（获赞和收藏数量）
+ const interactionsRes = await getUserInteractions(userId);
+ setInteractions(interactionsRes.data);
+
+ } catch (error) {
+ console.error('获取用户数据失败:', error);
+ showSnackbar('获取用户数据失败，请重试', 'error');
+ } finally {
+ setLoading(false);
+ }
+ };
+
+ fetchData();
+ }, [userId]);
+
+ // 根据标签页加载数据
+ useEffect(() => {
+ const fetchTabData = async () => {
+ if (!profileUser) return;
+
+ try {
+ setTabLoading(true);
+
+ if (activeTab === 1) {
+ // 加载收藏数据
+ const favoritesRes = await getFavorites(userId);
+ setFavorites(favoritesRes.data);
+ } else if (activeTab === 2) {
+ // 加载关注列表
+ const followingRes = await getUserFollowing(userId);
+ setFollowing(followingRes.data);
+ } else if (activeTab === 3) {
+ // 加载粉丝列表
+ const followersRes = await getUserFollowers(userId);
+ //
+ setFollowers(followersRes.data);
+ console.log(followersRes.data)
+ }
+
+ } catch (error) {
+ console.error('加载数据失败:', error);
+ showSnackbar('加载数据失败，请重试', 'error');
+ } finally {
+ setTabLoading(false);
+ }
+ };
+
+ fetchTabData();
+ }, [activeTab, userId, profileUser]);
+
+ const handleTabChange = (event, newValue) => {
+ setActiveTab(newValue);
+ };
+
+ const handleFollowToggle = async () => {
+ if (!currentUser || !profileUser) return;
+
+ try {
+ if (profileUser.is_following) {
+ await unfollowUserApi(profileUser.id);
+ showSnackbar('已取消关注');
+ } else {
+ await followUserApi(profileUser.id);
+ showSnackbar('关注成功');
+ }
+
+ // 更新用户信息
+ const updatedUser = await getUser(userId);
+ setProfileUser(updatedUser.data);
+
+ } catch (error) {
+ console.error('关注操作失败:', error);
+ showSnackbar('操作失败，请重试', 'error');
+ }
+ };
+
+ const handleFollowUser = async (followeeId) => {
+ try {
+ await followUserApi(followeeId);
+ showSnackbar('关注成功');
+
+ // 更新粉丝列表状态
+ setFollowers(prev => prev.map(user =>
+ user.id === followeeId ? {...user, is_following: true} : user
+ ));
+
+ // 更新当前用户关注数
+ if (currentUser) {
+ setCurrentUser(prev => ({
+ ...prev,
+ following_count: prev.following_count + 1
+ }));
+ }
+
+ } catch (error) {
+ console.error('关注操作失败:', error);
+ showSnackbar('关注失败，请重试', 'error');
+ }
+ };
+
+ const handleUnfollow = async (followeeId, e) => {
+ e.stopPropagation(); // 阻止事件冒泡
+
+ try {
+ await unfollowUserApi(followeeId);
+ showSnackbar('已取消关注');
+
+ // 更新关注列表
+ setFollowing(prev => prev.filter(user => user.id !== followeeId));
+
+ // 更新当前用户关注数
+ if (currentUser) {
+ setCurrentUser(prev => ({
+ ...prev,
+ following_count: prev.following_count - 1
+ }));
+ }
+
+ // 更新目标用户粉丝数
+ setProfileUser(prev => ({
+ ...prev,
+ followers_count: prev.followers_count - 1
+ }));
+
+ } catch (error) {
+ console.error('取消关注失败:', error);
+ showSnackbar('操作失败，请重试', 'error');
+ }
+ };
+
+ const handleFormChange = (e) => {
+ const { name, value } = e.target;
+ setFormData({ ...formData, [name]: value });
+ };
+
+ const handleUpdateProfile = async () => {
+ if (!profileUser) return;
+
+ try {
+ setUpdating(true);
+ const data = {
+ avatar: formData.avatar,
+ bio: formData.bio
+ };
+
+ // 调用更新API
+ const updatedUser = await updateUserApi(profileUser.id, data);
+
+ // 更新本地状态
+ setProfileUser({ ...profileUser, ...updatedUser.data });
+ setFormData({ ...formData, ...data });
+
+ showSnackbar('个人资料更新成功');
+ setIsEditing(false);
+
+ } catch (error) {
+ console.error('更新个人资料失败:', error);
+ showSnackbar('更新失败，请重试', 'error');
+ } finally {
+ setUpdating(false);
+ }
+ };
+
+ const navigateToUserProfile = (userId) => {
+ navigate(`/user/${userId}`);
+ };
+
+ if (loading) {
+ return (
+ <Box sx={{
+ display: 'flex',
+ justifyContent: 'center',
+ alignItems: 'center',
+ height: '100vh'
+ }}>
+ <CircularProgress size={60} />
+ </Box>
+ );
+ }
+
+ if (!profileUser) {
+ return (
+ <Box sx={{
+ display: 'flex',
+ justifyContent: 'center',
+ alignItems: 'center',
+ height: '100vh',
+ flexDirection: 'column'
+ }}>
+ <Typography variant="h6" sx={{ mb: 2 }}>用户不存在</Typography>
+ <Button variant="outlined" onClick={() => window.location.reload()}>
+ 重新加载
+ </Button>
+ </Box>
+ );
+ }
+
+ const isOwnProfile = currentUser && currentUser.id === parseInt(userId);
+
+ return (
+ <ThemeProvider theme={theme}>
+ <Box sx={{
+ bgcolor: 'background.default',
+ minHeight: '100vh',
+ pb: isMobile ? 8 : 4
+ }}>
+ {/* 顶部横幅 */}
+ <Box sx={{
+ height: isMobile ? 200 : 250,
+ background: 'linear-gradient(135deg, #ff9a9e 0%, #fad0c4 100%)',
+ position: 'relative',
+ borderBottomLeftRadius: 24,
+ borderBottomRightRadius: 24,
+ boxShadow: 1
+ }}>
+ <Fab
+ color="primary"
+ size="small"
+ sx={{
+ position: 'absolute',
+ bottom: -20,
+ right: 16
+ }}
+ >
+ <CameraAlt />
+ </Fab>
+ </Box>
+
+ <Container maxWidth="lg">
+ {/* 用户信息区域 */}
+ <Box sx={{ px: isMobile ? 3 : 0, mt: -8, position: 'relative' }}>
+ <Grid container spacing={3}>
+ <Grid item xs={12} sm="auto">
+ <Badge
+ overlap="circular"
+ anchorOrigin={{ vertical: 'bottom', horizontal: 'right' }}
+ badgeContent={
+ <IconButton
+ size="small"
+ sx={{
+ bgcolor: 'grey.200',
+ '&:hover': { bgcolor: 'grey.300' }
+ }}
+ onClick={() => setIsEditing(true)}
+ disabled={!isOwnProfile}
+ >
+ <Edit fontSize="small" />
+ </IconButton>
+ }
+ >
+ <Avatar
+ sx={{
+ width: 120,
+ height: 120,
+ border: '4px solid white',
+ boxShadow: 3
+ }}
+ src={profileUser.avatar || 'https://randomuser.me/api/portraits/women/12.jpg'}
+ />
+ </Badge>
+ </Grid>
+
+ <Grid item xs={12} sm>
+ <Box sx={{ display: 'flex', justifyContent: 'space-between', flexDirection: isMobile ? 'column' : 'row' }}>
+ <Box>
+ <Typography variant="h5" fontWeight="bold">
+ {profileUser.username}
+ </Typography>
+ <Typography variant="subtitle1" sx={{ mt: 0.5, maxWidth: 600 }}>
+ {profileUser.bio || '这个人很懒，还没有写简介～'}
+ </Typography>
+ <Box sx={{ display: 'flex', mt: 1, gap: 1, flexWrap: 'wrap' }}>
+ <Chip
+ icon={<LocationOn fontSize="small" />}
+ label="上海"
+ size="small"
+ variant="outlined"
+ />
+ <Chip
+ icon={<Cake fontSize="small" />}
+ label="1995-05-20"
+ size="small"
+ variant="outlined"
+ />
+ <Chip
+ icon={<Female fontSize="small" />}
+ label="女"
+ size="small"
+ variant="outlined"
+ />
+ </Box>
+ </Box>
+
+ <Box sx={{ mt: isMobile ? 2 : 0, alignSelf: 'flex-start' }}>
+ {!isOwnProfile && currentUser && (
+ <>
+ <Button
+ variant={profileUser.is_following ? "outlined" : "contained"}
+ color="primary"
+ onClick={handleFollowToggle}
+ sx={{
+ borderRadius: 20,
+ px: 3,
+ fontWeight: 'bold'
+ }}
+ >
+ {profileUser.is_following ? '已关注' : '关注'}
+ </Button>
+ <IconButton sx={{ ml: 1 }}>
+ <MoreVert />
+ </IconButton>
+ </>
+ )}
+ </Box>
+ </Box>
+
+ <Grid container spacing={2} sx={{ mt: 2 }}>
+ <Grid item>
+ <Box textAlign="center">
+ <Typography variant="h6">{posts.length}</Typography>
+ <Typography variant="body2" color="textSecondary">笔记</Typography>
+ </Box>
+ </Grid>
+ <Grid item>
+ <Box textAlign="center">
+ <Typography variant="h6">{profileUser.followers_count || 0}</Typography>
+ <Typography variant="body2" color="textSecondary">粉丝</Typography>
+ </Box>
+ </Grid>
+ <Grid item>
+ <Box textAlign="center">
+ <Typography variant="h6">{profileUser.following_count || 0}</Typography>
+ <Typography variant="body2" color="textSecondary">关注</Typography>
+ </Box>
+ </Grid>
+ <Grid item>
+ <Box textAlign="center">
+ {/* 使用真实数据：获赞与收藏总数 */}
+ <Typography variant="h6">
+ {(interactions.likes_count + interactions.favorites_count).toLocaleString()}
+ </Typography>
+ <Typography variant="body2" color="textSecondary">获赞与收藏</Typography>
+ </Box>
+ </Grid>
+ </Grid>
+ </Grid>
+ </Grid>
+ </Box>
+
+ {/* 标签栏 */}
+ <Box sx={{ mt: 4 }}>
+ <Tabs
+ value={activeTab}
+ onChange={handleTabChange}
+ variant={isMobile ? "fullWidth" : "standard"}
+ indicatorColor="primary"
+ textColor="primary"
+ sx={{
+ borderBottom: 1,
+ borderColor: 'divider'
+ }}
+ >
+ <Tab icon={isMobile ? <Collections /> : null} label="笔记" />
+ <Tab icon={isMobile ? <Bookmark /> : null} label="收藏" />
+ <Tab icon={isMobile ? <Group /> : null} label="关注" />
+ <Tab icon={isMobile ? <People /> : null} label="粉丝" />
+ </Tabs>
+ </Box>
+
+ {/* 内容区域 */}
+ <Box sx={{ mt: 3 }}>
+ {activeTab === 0 && (
+ <Grid container spacing={3}>
+ {tabLoading ? (
+ <Grid item xs={12} sx={{ display: 'flex', justifyContent: 'center', py: 4 }}>
+ <CircularProgress />
+ </Grid>
+ ) : posts.length > 0 ? (
+ posts.map((post, index) => (
+ <Grid item xs={12} sm={6} lg={3} key={post.id}>
+ <Card elevation={0} sx={{
+ bgcolor: 'white',
+ borderRadius: 3,
+ height: '100%',
+ display: 'flex',
+ flexDirection: 'column'
+ }}>
+ <CardMedia
+ component="img"
+ height="180"
+ image={`https://source.unsplash.com/random/400x300?${index + 1}`}
+ alt={post.title}
+ />
+ <CardContent sx={{ flexGrow: 1 }}>
+ <Typography gutterBottom variant="h6" component="div">
+ {post.title}
+ </Typography>
+ <Typography variant="body2" color="text.secondary">
+ {post.content.substring(0, 60)}...
+ </Typography>
+ </CardContent>
+ <CardActions sx={{ justifyContent: 'space-between', px: 2, pb: 2 }}>
+ <Box>
+ <IconButton aria-label="add to favorites">
+ <Favorite />
+ <Typography variant="body2" sx={{ ml: 1 }}>
+ {post.heat || Math.floor(Math.random() * 1000) + 1000}
+ </Typography>
+ </IconButton>
+ <IconButton aria-label="share">
+ <Share />
+ </IconButton>
+ </Box>
+ <Chip
+ label={post.type === 'image' ? '图文' : post.type === 'video' ? '视频' : '文档'}
+ size="small"
+ color="primary"
+ variant="outlined"
+ />
+ </CardActions>
+ </Card>
+ </Grid>
+ ))
+ ) : (
+ <Grid item xs={12}>
+ <Box sx={{
+ display: 'flex',
+ flexDirection: 'column',
+ alignItems: 'center',
+ py: 8,
+ textAlign: 'center'
+ }}>
+ <Collections sx={{ fontSize: 60, color: 'grey.300', mb: 2 }} />
+ <Typography variant="h6" sx={{ mb: 1 }}>
+ 还没有发布笔记
+ </Typography>
+ <Typography variant="body1" color="textSecondary" sx={{ mb: 3 }}>
+ {isOwnProfile ? '分享你的生活点滴吧～' : '该用户还没有发布任何笔记'}
+ </Typography>
+ {isOwnProfile && (
+ <Button variant="contained" color="primary">
+ 发布第一篇笔记
+ </Button>
+ )}
+ </Box>
+ </Grid>
+ )}
+
+ {posts.length > 0 && (
+ <Grid item xs={12}>
+ <Box sx={{ display: 'flex', justifyContent: 'center', mt: 3 }}>
+ <Button
+ variant="outlined"
+ sx={{
+ borderRadius: 20,
+ px: 4,
+ display: 'flex',
+ alignItems: 'center'
+ }}
+ >
+ <ChevronLeft sx={{ mr: 1 }} />
+ 上一页
+ <ChevronRight sx={{ ml: 2 }} />
+ </Button>
+ </Box>
+ </Grid>
+ )}
+ </Grid>
+ )}
+
+ {activeTab === 1 && (
+ <Grid container spacing={3}>
+ {tabLoading ? (
+ <Grid item xs={12} sx={{ display: 'flex', justifyContent: 'center', py: 4 }}>
+ <CircularProgress />
+ </Grid>
+ ) : favorites.length > 0 ? (
+ favorites.map((favorite) => (
+ <Grid item xs={12} sm={6} md={4} lg={3} key={favorite.id}>
+ <Card elevation={0} sx={{
+ bgcolor: 'white',
+ borderRadius: 3,
+ transition: 'transform 0.3s, box-shadow 0.3s',
+ '&:hover': {
+ transform: 'translateY(-5px)',
+ boxShadow: 3
+ }
+ }}>
+ <Box sx={{
+ height: 160,
+ position: 'relative',
+ borderTopLeftRadius: 16,
+ borderTopRightRadius: 16,
+ overflow: 'hidden'
+ }}>
+ <CardMedia
+ component="img"
+ height="160"
+ image={`https://source.unsplash.com/random/400x300?${favorite.id}`}
+ alt={favorite.title}
+ />
+ <Box sx={{
+ position: 'absolute',
+ top: 8,
+ right: 8,
+ bgcolor: 'rgba(0,0,0,0.6)',
+ color: 'white',
+ px: 1,
+ py: 0.5,
+ borderRadius: 4,
+ fontSize: 12
+ }}>
+ {favorite.type === 'image' ? '图文' : favorite.type === 'video' ? '视频' : '文档'}
+ </Box>
+ </Box>
+ <CardContent>
+ <Typography gutterBottom variant="subtitle1" fontWeight="medium">
+ {favorite.title}
+ </Typography>
+ <Box sx={{ display: 'flex', justifyContent: 'space-between' }}>
+ <Box sx={{ display: 'flex', alignItems: 'center' }}>
+ <Favorite fontSize="small" color="error" />
+ <Typography variant="body2" sx={{ ml: 0.5 }}>
+ {favorite.heat || Math.floor(Math.random() * 1000) + 1000}
+ </Typography>
+ </Box>
+ <Box sx={{ display: 'flex', alignItems: 'center' }}>
+ <Bookmark fontSize="small" color="primary" />
+ <Typography variant="body2" sx={{ ml: 0.5 }}>
+ {Math.floor(Math.random() * 500) + 100}
+ </Typography>
+ </Box>
+ </Box>
+ </CardContent>
+ </Card>
+ </Grid>
+ ))
+ ) : (
+ <Grid item xs={12}>
+ <Box sx={{
+ display: 'flex',
+ flexDirection: 'column',
+ alignItems: 'center',
+ py: 8,
+ textAlign: 'center'
+ }}>
+ <Bookmark sx={{ fontSize: 60, color: 'grey.300', mb: 2 }} />
+ <Typography variant="h6" sx={{ mb: 1 }}>
+ {isOwnProfile ? '你还没有收藏内容' : '该用户没有收藏内容'}
+ </Typography>
+ <Typography variant="body1" color="textSecondary">
+ {isOwnProfile ? '看到喜欢的笔记可以收藏起来哦～' : ''}
+ </Typography>
+ </Box>
+ </Grid>
+ )}
+ </Grid>
+ )}
+
+ {activeTab === 2 && (
+ <Grid container spacing={3}>
+ {tabLoading ? (
+ <Grid item xs={12} sx={{ display: 'flex', justifyContent: 'center', py: 4 }}>
+ <CircularProgress />
+ </Grid>
+ ) : following.length > 0 ? (
+ following.map((follow) => (
+ <Grid item xs={12} sm={6} md={4} key={follow.id}>
+ <Paper
+ elevation={0}
+ sx={{
+ bgcolor: 'white',
+ borderRadius: 3,
+ p: 2,
+ display: 'flex',
+ alignItems: 'center',
+ cursor: 'pointer',
+ '&:hover': {
+ boxShadow: 1
+ }
+ }}
+ onClick={() => navigateToUserProfile(follow.id)}
+ >
+ <Avatar
+ src={follow.avatar || 'https://randomuser.me/api/portraits/men/22.jpg'}
+ sx={{ width: 60, height: 60 }}
+ />
+ <Box sx={{ ml: 2, flexGrow: 1 }}>
+ <Typography fontWeight="medium">{follow.username}</Typography>
+ <Typography variant="body2" color="textSecondary">
+ {follow.followers_count || Math.floor(Math.random() * 100) + 10} 粉丝
+ </Typography>
+ </Box>
+ {isOwnProfile && (
+ <Button
+ variant="outlined"
+ size="small"
+ sx={{ borderRadius: 20 }}
+ onClick={(e) => handleUnfollow(follow.id, e)}
+ >
+ 已关注
+ </Button>
+ )}
+ </Paper>
+ </Grid>
+ ))
+ ) : (
+ <Grid item xs={12}>
+ <Box sx={{
+ display: 'flex',
+ flexDirection: 'column',
+ alignItems: 'center',
+ py: 8,
+ textAlign: 'center'
+ }}>
+ <Group sx={{ fontSize: 60, color: 'grey.300', mb: 2 }} />
+ <Typography variant="h6" sx={{ mb: 1 }}>
+ {isOwnProfile ? '你还没有关注任何人' : '该用户还没有关注任何人'}
+ </Typography>
+ <Typography variant="body1" color="textSecondary">
+ {isOwnProfile ? '发现有趣的人并关注他们吧～' : ''}
+ </Typography>
+ </Box>
+ </Grid>
+ )}
+ </Grid>
+ )}
+ {activeTab === 3 && (
+ <Grid container spacing={3}>
+ {tabLoading ? (
+ <Grid item xs={12} sx={{ display: 'flex', justifyContent: 'center', py: 4 }}>
+ <CircularProgress />
+ </Grid>
+ ) : followers.length > 0 ? (
+ followers.map((follower) => (
+ <Grid item xs={12} sm={6} md={4} key={follower.id}>
+ <Paper
+ elevation={0}
+ sx={{
+ bgcolor: 'white',
+ borderRadius: 3,
+ p: 2,
+ display: 'flex',
+ alignItems: 'center',
+ cursor: 'pointer',
+ '&:hover': {
+ boxShadow: 1
+ }
+ }}
+ onClick={() => navigateToUserProfile(follower.id)}
+ >
+ <Avatar
+ src={follower.avatar || 'https://randomuser.me/api/portraits/men/22.jpg'}
+ sx={{ width: 60, height: 60 }}
+ />
+ <Box sx={{ ml: 2, flexGrow: 1 }}>
+ <Typography fontWeight="medium">{follower.username}</Typography>
+ <Typography variant="body2" color="textSecondary">
+ {follower.bio || '暂无简介'}
+ </Typography>
+ </Box>
+ {currentUser && currentUser.id !== follower.id && (
+ <Button
+ variant={follower.is_following ? "outlined" : "contained"}
+ color="primary"
+ size="small"
+ sx={{ borderRadius: 20 }}
+ onClick={(e) => {
+ e.stopPropagation();
+ if (follower.is_following) {
+ handleUnfollow(follower.id, e);
+ } else {
+ handleFollowUser(follower.id);
+ }
+ }}
+ >
+ {follower.is_following ? '已关注' : '关注'}
+ </Button>
+ )}
+ </Paper>
+ </Grid>
+ ))
+ ) : (
+ <Grid item xs={12}>
+ <Box sx={{
+ display: 'flex',
+ flexDirection: 'column',
+ alignItems: 'center',
+ py: 8,
+ textAlign: 'center'
+ }}>
+ <People sx={{ fontSize: 60, color: 'grey.300', mb: 2 }} />
+ <Typography variant="h6" sx={{ mb: 1 }}>
+ {isOwnProfile ? '你还没有粉丝' : '该用户还没有粉丝'}
+ </Typography>
+ <Typography variant="body1" color="textSecondary">
+ {isOwnProfile ? '分享更多内容来吸引粉丝吧～' : ''}
+ </Typography>
+ </Box>
+ </Grid>
+ )}
+ </Grid>
+ )}
+ </Box>
+ </Container>
+
+ {/* 底部导航栏 - 仅移动端显示 */}
+ {isMobile && (
+ <Box sx={{
+ position: 'fixed',
+ bottom: 0,
+ left: 0,
+ right: 0,
+ bgcolor: 'white',
+ boxShadow: 3,
+ py: 1,
+ display: 'flex',
+ justifyContent: 'space-around'
+ }}>
+ <IconButton color="primary">
+ <Search fontSize="large" />
+ </IconButton>
+ <IconButton>
+ <Collections fontSize="large" />
+ </IconButton>
+ <Fab color="primary" size="medium" sx={{ mt: -2 }}>
+ <Add />
+ </Fab>
+ <IconButton>
+ <Notifications fontSize="large" />
+ </IconButton>
+ <IconButton>
+ <Person fontSize="large" />
+ </IconButton>
+ </Box>
+ )}
+
+ {/* 编辑资料模态框 */}
+ {isEditing && (
+ <Box sx={{
+ position: 'fixed',
+ top: 0,
+ left: 0,
+ right: 0,
+ bottom: 0,
+ bgcolor: 'rgba(0,0,0,0.5)',
+ zIndex: 1300,
+ display: 'flex',
+ alignItems: 'center',
+ justifyContent: 'center',
+ px: 2
+ }}>
+ <Paper sx={{
+ width: '100%',
+ maxWidth: 600,
+ borderRadius: 4,
+ overflow: 'hidden'
+ }}>
+ <Box sx={{
+ bgcolor: 'primary.main',
+ color: 'white',
+ p: 2,
+ display: 'flex',
+ justifyContent: 'space-between',
+ alignItems: 'center'
+ }}>
+ <Typography variant="h6">编辑资料</Typography>
+ <IconButton color="inherit" onClick={() => setIsEditing(false)}>
+ <Close />
+ </IconButton>
+ </Box>
+
+ <Box sx={{ p: 3 }}>
+ <Box sx={{ display: 'flex', justifyContent: 'center', mb: 3 }}>
+ <Badge
+ overlap="circular"
+ anchorOrigin={{ vertical: 'bottom', horizontal: 'right' }}
+ badgeContent={
+ <IconButton
+ size="small"
+ sx={{
+ bgcolor: 'grey.200',
+ '&:hover': { bgcolor: 'grey.300' }
+ }}
+ >
+ <CameraAlt fontSize="small" />
+ </IconButton>
+ }
+ >
+ <Avatar
+ sx={{ width: 100, height: 100 }}
+ src={formData.avatar || 'https://randomuser.me/api/portraits/women/12.jpg'}
+ />
+ </Badge>
+ </Box>
+
+ <TextField
+ fullWidth
+ label="用户名"
+ value={profileUser.username}
+ margin="normal"
+ disabled
+ />
+
+ <TextField
+ fullWidth
+ name="avatar"
+ label="头像URL"
+ value={formData.avatar}
+ onChange={handleFormChange}
+ margin="normal"
+ />
+
+ <TextField
+ fullWidth
+ name="bio"
+ label="个人简介"
+ value={formData.bio}
+ onChange={handleFormChange}
+ margin="normal"
+ multiline
+ rows={3}
+ />
+
+ <Grid container spacing={2} sx={{ mt: 1 }}>
+ <Grid item xs={6}>
+ <TextField
+ select
+ fullWidth
+ name="gender"
+ label="性别"
+ value={formData.gender}
+ onChange={handleFormChange}
+ margin="normal"
+ >
+ <MenuItem value="female">
+ <Box sx={{ display: 'flex', alignItems: 'center' }}>
+ <Female sx={{ mr: 1 }} /> 女
+ </Box>
+ </MenuItem>
+ <MenuItem value="male">
+ <Box sx={{ display: 'flex', alignItems: 'center' }}>
+ <Male sx={{ mr: 1 }} /> 男
+ </Box>
+ </MenuItem>
+ <MenuItem value="other">
+ <Box sx={{ display: 'flex', alignItems: 'center' }}>
+ <Public sx={{ mr: 1 }} /> 其他
+ </Box>
+ </MenuItem>
+ </TextField>
+ </Grid>
+ <Grid item xs={6}>
+ <TextField
+ fullWidth
+ name="birthday"
+ label="生日"
+ type="date"
+ value={formData.birthday}
+ onChange={handleFormChange}
+ margin="normal"
+ InputLabelProps={{ shrink: true }}
+ />
+ </Grid>
+ </Grid>
+
+ <TextField
+ fullWidth
+ name="location"
+ label="地区"
+ value={formData.location}
+ onChange={handleFormChange}
+ margin="normal"
+ InputProps={{
+ startAdornment: (
+ <InputAdornment position="start">
+ <LocationOn />
+ </InputAdornment>
+ ),
+ }}
+ />
+
+ <Box sx={{ display: 'flex', justifyContent: 'space-between', mt: 3 }}>
+ <Button
+ variant="outlined"
+ sx={{ width: '48%' }}
+ onClick={() => setIsEditing(false)}
+ disabled={updating}
+ >
+ 取消
+ </Button>
+ <Button
+ variant="contained"
+ color="primary"
+ sx={{ width: '48%' }}
+ onClick={handleUpdateProfile}
+ disabled={updating}
+ >
+ {updating ? <CircularProgress size={24} /> : '保存'}
+ </Button>
+ </Box>
+ </Box>
+ </Paper>
+ </Box>
+ )}
+
+ {/* 提示信息 */}
+ <Snackbar
+ open={snackbar.open}
+ autoHideDuration={3000}
+ onClose={() => setSnackbar({ ...snackbar, open: false })}
+ anchorOrigin={{ vertical: 'top', horizontal: 'center' }}
+ >
+ <Alert
+ severity={snackbar.severity}
+ sx={{ width: '100%' }}
+ onClose={() => setSnackbar({ ...snackbar, open: false })}
+ >
+ {snackbar.message}
+ </Alert>
+ </Snackbar>
+ </Box>
+ </ThemeProvider>
+ );
+};
+
+export default UserProfile;
\ No newline at end of file
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/index.css b/xiaohongshu-upload-platform/src/ljc/personalpage/src/index.css
new file mode 100644
index 0000000..ec2585e
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/index.css
@@ -0,0 +1,13 @@
+body {
+ margin: 0;
+ font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', 'Roboto', 'Oxygen',
+ 'Ubuntu', 'Cantarell', 'Fira Sans', 'Droid Sans', 'Helvetica Neue',
+ sans-serif;
+ -webkit-font-smoothing: antialiased;
+ -moz-osx-font-smoothing: grayscale;
+}
+
+code {
+ font-family: source-code-pro, Menlo, Monaco, Consolas, 'Courier New',
+ monospace;
+}
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/index.js b/xiaohongshu-upload-platform/src/ljc/personalpage/src/index.js
new file mode 100644
index 0000000..d563c0f
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/index.js
@@ -0,0 +1,17 @@
+import React from 'react';
+import ReactDOM from 'react-dom/client';
+import './index.css';
+import App from './App';
+import reportWebVitals from './reportWebVitals';
+
+const root = ReactDOM.createRoot(document.getElementById('root'));
+root.render(
+ <React.StrictMode>
+ <App />
+ </React.StrictMode>
+);
+
+// If you want to start measuring performance in your app, pass a function
+// to log results (for example: reportWebVitals(console.log))
+// or send to an analytics endpoint. Learn more: https://bit.ly/CRA-vitals
+reportWebVitals();
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/logo.svg b/xiaohongshu-upload-platform/src/ljc/personalpage/src/logo.svg
new file mode 100644
index 0000000..9dfc1c0
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/logo.svg
@@ -0,0 +1 @@
+<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 841.9 595.3"><g fill="#61DAFB"><path d="M666.3 296.5c0-32.5-40.7-63.3-103.1-82.4 14.4-63.6 8-114.2-20.2-130.4-6.5-3.8-14.1-5.6-22.4-5.6v22.3c4.6 0 8.3.9 11.4 2.6 13.6 7.8 19.5 37.5 14.9 75.7-1.1 9.4-2.9 19.3-5.1 29.4-19.6-4.8-41-8.5-63.5-10.9-13.5-18.5-27.5-35.3-41.6-50 32.6-30.3 63.2-46.9 84-46.9V78c-27.5 0-63.5 19.6-99.9 53.6-36.4-33.8-72.4-53.2-99.9-53.2v22.3c20.7 0 51.4 16.5 84 46.6-14 14.7-28 31.4-41.3 49.9-22.6 2.4-44 6.1-63.6 11-2.3-10-4-19.7-5.2-29-4.7-38.2 1.1-67.9 14.6-75.8 3-1.8 6.9-2.6 11.5-2.6V78.5c-8.4 0-16 1.8-22.6 5.6-28.1 16.2-34.4 66.7-19.9 130.1-62.2 19.2-102.7 49.9-102.7 82.3 0 32.5 40.7 63.3 103.1 82.4-14.4 63.6-8 114.2 20.2 130.4 6.5 3.8 14.1 5.6 22.5 5.6 27.5 0 63.5-19.6 99.9-53.6 36.4 33.8 72.4 53.2 99.9 53.2 8.4 0 16-1.8 22.6-5.6 28.1-16.2 34.4-66.7 19.9-130.1 62-19.1 102.5-49.9 102.5-82.3zm-130.2-66.7c-3.7 12.9-8.3 26.2-13.5 39.5-4.1-8-8.4-16-13.1-24-4.6-8-9.5-15.8-14.4-23.4 14.2 2.1 27.9 4.7 41 7.9zm-45.8 106.5c-7.8 13.5-15.8 26.3-24.1 38.2-14.9 1.3-30 2-45.2 2-15.1 0-30.2-.7-45-1.9-8.3-11.9-16.4-24.6-24.2-38-7.6-13.1-14.5-26.4-20.8-39.8 6.2-13.4 13.2-26.8 20.7-39.9 7.8-13.5 15.8-26.3 24.1-38.2 14.9-1.3 30-2 45.2-2 15.1 0 30.2.7 45 1.9 8.3 11.9 16.4 24.6 24.2 38 7.6 13.1 14.5 26.4 20.8 39.8-6.3 13.4-13.2 26.8-20.7 39.9zm32.3-13c5.4 13.4 10 26.8 13.8 39.8-13.1 3.2-26.9 5.9-41.2 8 4.9-7.7 9.8-15.6 14.4-23.7 4.6-8 8.9-16.1 13-24.1zM421.2 430c-9.3-9.6-18.6-20.3-27.8-32 9 .4 18.2.7 27.5.7 9.4 0 18.7-.2 27.8-.7-9 11.7-18.3 22.4-27.5 32zm-74.4-58.9c-14.2-2.1-27.9-4.7-41-7.9 3.7-12.9 8.3-26.2 13.5-39.5 4.1 8 8.4 16 13.1 24 4.7 8 9.5 15.8 14.4 23.4zM420.7 163c9.3 9.6 18.6 20.3 27.8 32-9-.4-18.2-.7-27.5-.7-9.4 0-18.7.2-27.8.7 9-11.7 18.3-22.4 27.5-32zm-74 58.9c-4.9 7.7-9.8 15.6-14.4 23.7-4.6 8-8.9 16-13 24-5.4-13.4-10-26.8-13.8-39.8 13.1-3.1 26.9-5.8 41.2-7.9zm-90.5 125.2c-35.4-15.1-58.3-34.9-58.3-50.6 0-15.7 22.9-35.6 58.3-50.6 8.6-3.7 18-7 27.7-10.1 5.7 19.6 13.2 40 22.5 60.9-9.2 20.8-16.6 41.1-22.2 60.6-9.9-3.1-19.3-6.5-28-10.2zM310 490c-13.6-7.8-19.5-37.5-14.9-75.7 1.1-9.4 2.9-19.3 5.1-29.4 19.6 4.8 41 8.5 63.5 10.9 13.5 18.5 27.5 35.3 41.6 50-32.6 30.3-63.2 46.9-84 46.9-4.5-.1-8.3-1-11.3-2.7zm237.2-76.2c4.7 38.2-1.1 67.9-14.6 75.8-3 1.8-6.9 2.6-11.5 2.6-20.7 0-51.4-16.5-84-46.6 14-14.7 28-31.4 41.3-49.9 22.6-2.4 44-6.1 63.6-11 2.3 10.1 4.1 19.8 5.2 29.1zm38.5-66.7c-8.6 3.7-18 7-27.7 10.1-5.7-19.6-13.2-40-22.5-60.9 9.2-20.8 16.6-41.1 22.2-60.6 9.9 3.1 19.3 6.5 28.1 10.2 35.4 15.1 58.3 34.9 58.3 50.6-.1 15.7-23 35.6-58.4 50.6zM320.8 78.4z"/><circle cx="420.9" cy="296.5" r="45.7"/><path d="M520.5 78.1z"/></g></svg>
\ No newline at end of file
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/reportWebVitals.js b/xiaohongshu-upload-platform/src/ljc/personalpage/src/reportWebVitals.js
new file mode 100644
index 0000000..5253d3a
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/reportWebVitals.js
@@ -0,0 +1,13 @@
+const reportWebVitals = onPerfEntry => {
+ if (onPerfEntry && onPerfEntry instanceof Function) {
+ import('web-vitals').then(({ getCLS, getFID, getFCP, getLCP, getTTFB }) => {
+ getCLS(onPerfEntry);
+ getFID(onPerfEntry);
+ getFCP(onPerfEntry);
+ getLCP(onPerfEntry);
+ getTTFB(onPerfEntry);
+ });
+ }
+};
+
+export default reportWebVitals;
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/services/api.js b/xiaohongshu-upload-platform/src/ljc/personalpage/src/services/api.js
new file mode 100644
index 0000000..a3ca1d1
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/services/api.js
@@ -0,0 +1,31 @@
+import axios from 'axios';
+
+const api = axios.create({
+ baseURL: 'http://localhost:5000/api',
+ withCredentials: true
+});
+
+// 用户相关API
+export const getCurrentUser = () => api.get('/current-user');
+export const getUser = (userId) => api.get(`/user/${userId}`);
+export const updateUser = (userId, data) => api.put(`/user/${userId}`, data);
+
+// 收藏相关API
+export const getFavorites = (userId) => api.get(`/user/${userId}/favorites`);
+
+// 关注相关API
+export const followUser = (followeeId) => api.post(`/follow/${followeeId}`);
+export const unfollowUser = (followeeId) => api.delete(`/follow/${followeeId}`);
+
+// 帖子相关API
+export const getUserPosts = (userId) => api.get(`/user/${userId}/posts`);
+
+// 关注列表API
+export const getUserFollowing = (userId) => api.get(`/user/${userId}/following`);
+
+// 用户互动数据API
+export const getUserInteractions = (userId) => api.get(`/user/${userId}/interactions`);
+// 获取粉丝
+export const getUserFollowers = (userId) => api.get(`/user/${userId}/followers`);
+
+export default api;
\ No newline at end of file
diff --git a/xiaohongshu-upload-platform/src/ljc/personalpage/src/setupTests.js b/xiaohongshu-upload-platform/src/ljc/personalpage/src/setupTests.js
new file mode 100644
index 0000000..8f2609b
--- /dev/null
+++ b/xiaohongshu-upload-platform/src/ljc/personalpage/src/setupTests.js
@@ -0,0 +1,5 @@
+// jest-dom adds custom jest matchers for asserting on DOM nodes.
+// allows you to do things like:
+// expect(element).toHaveTextContent(/react/i)
+// learn more: https://github.com/testing-library/jest-dom
+import '@testing-library/jest-dom';
