Function GetUserUsageStatisticsSummary

model/usage_statistics.go:534–587

GetUserUsageStatisticsSummary 获取特定用户的用量统计摘要信息

(userId int, startDate, endDate string, tokenId int, modelName string)

// GetUserUsageStatisticsSummary 获取特定用户的用量统计摘要信息
func GetUserUsageStatisticsSummary(userId int, startDate, endDate string, tokenId int, modelName string) (map[string]interface{}, error) {
	query := DB.Table("usage_statistics").
		Joins("JOIN tokens ON usage_statistics.token_id = tokens.id").
		Where("tokens.user_id = ?", userId)

	// 添加查询条件
	if startDate != "" {
		query = query.Where("usage_statistics.date >= ?", startDate)
	}
	if endDate != "" {
		query = query.Where("usage_statistics.date <= ?", endDate)
	}
	if tokenId > 0 {
		query = query.Where("usage_statistics.token_id = ?", tokenId)
	}
	if modelName != "" {
		query = query.Where("usage_statistics.model_name LIKE ?", "%"+modelName+"%")
	}

	var result struct {
		TotalRequests      int `json:"total_requests"`
		SuccessfulRequests int `json:"successful_requests"`
		FailedRequests     int `json:"failed_requests"`
		TotalTokens        int `json:"total_tokens"`
		TotalQuota         int `json:"total_quota"`
	}

	err := query.Select(
		"SUM(usage_statistics.total_requests) as total_requests",
		"SUM(usage_statistics.successful_requests) as successful_requests",
		"SUM(usage_statistics.failed_requests) as failed_requests",
		"SUM(usage_statistics.total_tokens) as total_tokens",
		"SUM(usage_statistics.total_quota) as total_quota",
	).Scan(&result).Error

	if err != nil {
		return nil, err
	}

	summary := map[string]interface{}{
		"total_requests":      result.TotalRequests,
		"successful_requests": result.SuccessfulRequests,
		"failed_requests":     result.FailedRequests,
		"success_rate":        0.0,
		"total_tokens":        result.TotalTokens,
		"total_quota":         result.TotalQuota,
	}

	if result.TotalRequests > 0 {
		summary["success_rate"] = float64(result.SuccessfulRequests) / float64(result.TotalRequests) * 100
	}

	return summary, nil
}

// GetUserMonthlyUsageStatisticsSummary 获取特定用户的月度用量统计摘要信息
func GetUserMonthlyUsageStatisticsSummary(userId int, startDate, endDate string, tokenId int, modelName string) (map[string]interface{}, error) {