Function GetUserMonthlyUsageStatisticsSummary

model/usage_statistics.go:590–673

GetUserMonthlyUsageStatisticsSummary 获取特定用户的月度用量统计摘要信息

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

// GetUserMonthlyUsageStatisticsSummary 获取特定用户的月度用量统计摘要信息
func GetUserMonthlyUsageStatisticsSummary(userId int, startDate, endDate string, tokenId int, modelName string) (map[string]interface{}, error) {
	// 使用原生SQL查询实现按月分组统计
	db := DB.Table("usage_statistics").
		Joins("JOIN tokens ON usage_statistics.token_id = tokens.id").
		Where("tokens.user_id = ?", userId)

	// 构建查询条件
	conditions := " AND tokens.user_id = ?"
	params := []interface{}{userId}

	// 添加日期范围条件（按月查询）
	if startDate != "" {
		conditions += " AND usage_statistics.date >= ?"
		params = append(params, startDate+"-01")
	}
	if endDate != "" {
		// 获取 endDate 所在月份的最后一天
		if len(endDate) >= 7 {
			year := endDate[0:4]
			month := endDate[5:7]
			conditions += " AND usage_statistics.date <= ?"
			params = append(params, year+"-"+month+"-31")
		}
	}
	
	if tokenId > 0 {
		conditions += " AND usage_statistics.token_id = ?"
		params = append(params, tokenId)
	}
	if modelName != "" {
		conditions += " AND usage_statistics.model_name LIKE ?"
		params = append(params, "%"+modelName+"%")
	}

	// 构建完整的SQL查询
	sql := `
		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
		FROM (
			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
			FROM usage_statistics 
			JOIN tokens ON usage_statistics.token_id = tokens.id
			WHERE 1=1` + conditions + `
			GROUP BY SUBSTR(usage_statistics.date, 1, 7), usage_statistics.token_id, usage_statistics.token_name, usage_statistics.model_name
		) as grouped_data
	`

	var result struct {
		TotalRequests      int `json:"total_requests"`