锦中融合门户系统

# 示例数据
articles = [
    {'id': 1, 'title': '文章一', 'views': 1000, 'likes': 200, 'timestamp': '2024-01-01'},
    {'id': 2, 'title': '文章二', 'views': 800, 'likes': 300, 'timestamp': '2024-01-05'},
    {'id': 3, 'title': '文章三', 'views': 500, 'likes': 100, 'timestamp': '2024-01-10'}
]

# 计算时间差（以天为单位）
from datetime import datetime

def days_since(timestamp):
    today = datetime.today()
    article_date = datetime.strptime(timestamp, '%Y-%m-%d')
    return (today - article_date).days + 1  # 避免除以零

# 计算综合得分
def calculate_score(article):
    views_weight = 0.5
    likes_weight = 0.3
    time_weight = 0.2
    score = (
        article['views'] * views_weight +
        article['likes'] * likes_weight +
        (1 / days_since(article['timestamp'])) * time_weight
    )
    return score

# 排序
sorted_articles = sorted(articles, key=lambda x: calculate_score(x), reverse=True)

# 输出结果
for article in sorted_articles:
    print(f"ID: {article['id']}, 标题: {article['title']}, 得分: {calculate_score(article):.2f}")
      

SELECT 
    id,
    title,
    views,
    likes,
    timestamp,
    ROW_NUMBER() OVER (ORDER BY (views * 0.5 + likes * 0.3 + (1 / DATEDIFF(CURDATE(), timestamp)) * 0.2) DESC) AS rank
FROM articles;
      

<div id="rank-list"></div>

<script>
fetch('/api/rank')
  .then(response => response.json())
  .then(data => {
    const list = document.getElementById('rank-list');
    data.forEach((item, index) => {
      const li = document.createElement('div');
      li.textContent = `${index + 1}. ${item.title} - 得分: ${item.score}`;
      list.appendChild(li);
    });
  })
  .catch(error => console.error('Error fetching rank data:', error));
</script>