Usage Analytics

interface LogEntry {
  // Identifiers
  id: string;
  requestId: string;
  organizationId: string;
  projectId: string;
  apiKeyId: string;
  
  // Timestamps and Performance
  createdAt: Date;
  duration: number;  // milliseconds
  
  // Model Information
  requestedModel: string;
  requestedProvider: string | null;
  usedModel: string;
  usedProvider: string;
  
  // Request/Response Data
  messages: any;  // Full conversation history
  content: string | null;  // Response content
  reasoningContent: string | null;  // Extended thinking
  responseSize: number;  // bytes
  
  // Token Usage
  promptTokens: string | null;
  completionTokens: string | null;
  totalTokens: string | null;
  reasoningTokens: string | null;
  imageInputTokens: string | null;
  imageOutputTokens: string | null;
  
  // Costs (USD)
  cost: number | null;
  inputCost: number | null;
  outputCost: number | null;
  requestCost: number | null;
  imageInputCost: number | null;
  imageOutputCost: number | null;
  estimatedCost: boolean | null;
  
  // Request Parameters
  temperature: number | null;
  maxTokens: number | null;
  topP: number | null;
  frequencyPenalty: number | null;
  presencePenalty: number | null;
  reasoningEffort: string | null;
  reasoningMaxTokens: number | null;
  responseFormat: any | null;
  tools: any | null;
  toolChoice: any | null;
  toolResults: any | null;
  
  // Status and Errors
  finishReason: string | null;
  unifiedFinishReason: string | null;
  hasError: boolean | null;
  errorDetails: any | null;
  canceled: boolean | null;
  
  // Flags
  streamed: boolean | null;
  cached: boolean | null;
  
  // Metadata
  customHeaders: any | null;
  mode: "api-keys" | "credits" | "hybrid";
  usedMode: "api-keys" | "credits";
  source: string | null;
  routingMetadata: any | null;
}

const querySchema = z.object({
  // Filtering
  apiKeyId: z.string().optional(),
  providerKeyId: z.string().optional(),
  projectId: z.string().optional(),
  orgId: z.string().optional(),
  
  // Date Range
  startDate: z.string().optional(),  // ISO string
  endDate: z.string().optional(),
  
  // Model/Provider
  model: z.string().optional(),  // e.g., "gpt-4o"
  provider: z.string().optional(),  // e.g., "openai"
  
  // Status
  finishReason: z.string().optional(),
  unifiedFinishReason: z.string().optional(),
  
  // Source Tracking
  source: z.string().optional(),
  
  // Custom Headers
  customHeaderKey: z.string().optional(),
  customHeaderValue: z.string().optional(),
  
  // Pagination
  cursor: z.string().optional(),
  limit: z.number().int().min(1).max(100).optional(),  // default: 50
  orderBy: z.enum(["createdAt_asc", "createdAt_desc"]).optional()  // default: desc
});

export function calculateCosts(params: {
  promptTokens: number;
  completionTokens: number;
  reasoningTokens?: number;
  cachedTokens?: number;
  imageInputCount?: number;
  imageOutputCount?: number;
  model: ModelDefinition;
  provider: ProviderModelMapping;
}) {
  const inputCost = (params.promptTokens / 1_000_000) * (provider.inputPrice ?? 0);
  const outputCost = (params.completionTokens / 1_000_000) * (provider.outputPrice ?? 0);
  const cachedInputCost = (params.cachedTokens ?? 0) / 1_000_000 * (provider.cachedInputPrice ?? 0);
  const requestCost = provider.requestPrice ?? 0;
  
  return {
    inputCost,
    outputCost,
    cachedInputCost,
    requestCost,
    totalCost: inputCost + outputCost + cachedInputCost + requestCost
  };
}