OpenAI Integration

import { isOpenAIConfigured } from '@/lib/ai/openai';

const isConfigured = await isOpenAIConfigured();

if (isConfigured) {
  console.log('OpenAI is ready!');
} else {
  console.log('Please add OPENAI_API_KEY to settings');
}

import { sendChatMessage } from '@/lib/ai/openai';

const response = await sendChatMessage([
  {
    role: 'system',
    content: 'You are a helpful restaurant CRM assistant.'
  },
  {
    role: 'user',
    content: 'How many VIP customers visited last month?'
  }
]);

if (response.success) {
  console.log('AI Response:', response.content);
  console.log('Tokens used:', response.usage?.total_tokens);
} else {
  console.error('Error:', response.error);
}

import { generateHIROResponse } from '@/lib/ai/openai';

// Provide context about your restaurant
const context = `
Restaurant: La Tasca Alicante
Total Customers: 5,247
VIP Customers (RFM 4-5): 342
Last Month Revenue: €127,450
Average Ticket: €48.30
`;

const response = await generateHIROResponse(
  'What should I focus on this month?',
  context
);

if (response.success) {
  console.log(response.content);
}

import { sendChatMessage } from '@/lib/ai/openai';

const response = await sendChatMessage(
  [
    { role: 'user', content: 'Suggest a campaign for lapsed customers' }
  ],
  {
    model: 'gpt-4-turbo',        // or 'gpt-3.5-turbo'
    temperature: 0.7,             // 0 = deterministic, 1 = creative
    max_tokens: 1000              // Limit response length
  }
);

interface ChatMessage {
    role: 'system' | 'user' | 'assistant';
    content: string;
}

interface ChatResponse {
    success: boolean;
    content?: string;                // AI's response text
    error?: string;                  // Error message if failed
    usage?: {
        prompt_tokens: number;       // Tokens in your request
        completion_tokens: number;   // Tokens in AI response
        total_tokens: number;        // Total cost
    };
}

interface ChatOptions {
    model?: string;                  // 'gpt-4-turbo' | 'gpt-3.5-turbo'
    temperature?: number;            // 0.0 to 1.0
    max_tokens?: number;             // Max response length
}

const HIRO_SYSTEM_PROMPT = `
Eres CONCIERGE AI, el acompañante estratégico de élite para Hiro CRM.

Tu identidad:
- Eres el "Concierge" de datos: sofisticado, impecable, proactivo
- Hablas con la autoridad de un Director de Marketing (CMO)
- No esperas órdenes; sugieres oportunidades basadas en datos

Tus capacidades estratégicas:
- Auditoría de Reservas
- Gestión VIP
- Inteligencia de Campañas
- Análisis Predictivo

Formato:
- Estilo "Luxury Minimalist"
- Usa emojis premium: 👑, ✨, 🍷, 📊, 🥂
- Proporciona un "Insight del Concierge" al final
`;

import { generateHIROResponse } from '@/lib/ai/openai';

const customerStats = {
  totalCustomers: 5247,
  vipCount: 342,
  lapsedCount: 892,
  avgSpend: 48.30,
  avgVisits: 3.2
};

const context = `
Total Customers: ${customerStats.totalCustomers}
VIP Customers: ${customerStats.vipCount}
Lapsed (no visit in 6+ months): ${customerStats.lapsedCount}
Average Spend: €${customerStats.avgSpend}
Average Visits: ${customerStats.avgVisits}
`;

const response = await generateHIROResponse(
  'What marketing campaign should I run this month?',
  context
);

const context = `
Last 30 Days:
- Total Reservations: 1,247
- No-Shows: 87 (7%)
- Average Party Size: 3.4
- Peak Day: Saturday (312 reservations)
- Peak Hour: 21:00 (18% of daily reservations)
`;

const response = await generateHIROResponse(
  'How can I reduce no-shows?',
  context
);

const vipCustomers = [
  { name: 'María García', visits: 23, ltv: 2840 },
  { name: 'Carlos López', visits: 18, ltv: 2340 },
  { name: 'Ana Martínez', visits: 15, ltv: 1980 }
];

const context = `
Top 3 VIP Customers:
${vipCustomers.map(c => `- ${c.name}: ${c.visits} visits, €${c.ltv} LTV`).join('\n')}

Goal: Increase retention of VIP tier customers
`;

const response = await generateHIROResponse(
  'Suggest a VIP retention strategy',
  context
);

CREATE TABLE integration_configs (
  id UUID PRIMARY KEY,
  organization_id UUID REFERENCES organizations(id),
  integration_type TEXT, -- 'openai'
  is_enabled BOOLEAN DEFAULT true,
  config JSONB -- { "api_key": "sk-...", "model": "gpt-4-turbo" }
);