Function GetUsageStatisticsSummary

model/usage_statistics.go:267–318

GetUsageStatisticsSummary 获取用量统计摘要信息

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

// GetUsageStatisticsSummary 获取用量统计摘要信息
func GetUsageStatisticsSummary(startDate, endDate string, tokenId int, modelName string) (map[string]interface{}, error) {
	query := DB.Model(&UsageStatistics{})

	// 添加查询条件
	if startDate != "" {
		query = query.Where("date >= ?", startDate)
	}
	if endDate != "" {
		query = query.Where("date <= ?", endDate)
	}
	if tokenId > 0 {
		query = query.Where("token_id = ?", tokenId)
	}
	if modelName != "" {
		query = query.Where("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(total_requests) as total_requests",
		"SUM(successful_requests) as successful_requests",
		"SUM(failed_requests) as failed_requests",
		"SUM(total_tokens) as total_tokens",
		"SUM(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
}

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