package com.saas.tenant.entity;

import com.saas.shared.enums.KnowledgeType;
import jakarta.persistence.*;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.hibernate.annotations.CreationTimestamp;
import org.hibernate.annotations.JdbcTypeCode;
import org.hibernate.annotations.UpdateTimestamp;
import org.hibernate.type.SqlTypes;

import java.time.LocalDateTime;
import java.util.Map;

/**
 * Tenant AI Knowledge Base
 * 
 * Stores RAG documents and system prompts for AI assistants
 * - Automatically generated when tenant data changes
 * - Synced to Vapi and Retell assistants
 * - Versioned for history tracking
 */
@Entity
@Table(name = "tenant_ai_knowledge")
@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class TenantAIKnowledge {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    /**
     * Tenant identifier
     * Each tenant has its own knowledge base
     */
    @Column(name = "tenant_id", nullable = false)
    private String tenantId;

    /**
     * Type of knowledge
     */
    @Enumerated(EnumType.STRING)
    @Column(name = "knowledge_type", nullable = false)
    private KnowledgeType knowledgeType;

    /**
     * RAG Document (Retrieval-Augmented Generation)
     * 
     * Formatted text document containing:
     * - Doctors information
     * - Services catalog
     * - Prices and durations
     * - Availability information
     * 
     * Used by AI to retrieve relevant information during conversations
     */
    @Column(name = "rag_document", columnDefinition = "TEXT")
    @Lob
    private String ragDocument;

    /**
     * System Prompt for AI
     * 
     * Dynamic prompt that includes:
     * - Clinic context
     * - Available services
     * - Conversation guidelines
     * - Booking instructions
     */
    @Column(name = "system_prompt", columnDefinition = "TEXT")
    @Lob
    private String systemPrompt;

    /**
     * Metadata about the knowledge
     * 
     * Examples:
     * - Number of doctors
     * - Number of services
     * - Last sync timestamp
     * - Generation statistics
     */
    @JdbcTypeCode(SqlTypes.JSON)
    @Column(name = "metadata", columnDefinition = "JSON")
    private Map<String, Object> metadata;

    /**
     * Version number
     * Incremented on each regeneration
     */
    @Column(name = "version")
    @Builder.Default
    private Integer version = 1;

    /**
     * Whether this knowledge is currently active
     */
    @Column(name = "is_active")
    @Builder.Default
    private Boolean isActive = true;

    /**
     * Last time this knowledge was synced to Vapi
     */
    @Column(name = "last_synced_to_vapi")
    private LocalDateTime lastSyncedToVapi;

    /**
     * Last time this knowledge was synced to Retell
     */
    @Column(name = "last_synced_to_retell")
    private LocalDateTime lastSyncedToRetell;

    /**
     * Error message if sync failed
     */
    @Column(name = "sync_error", columnDefinition = "TEXT")
    private String syncError;

    @CreationTimestamp
    @Column(name = "created_at", nullable = false, updatable = false)
    private LocalDateTime createdAt;

    @UpdateTimestamp
    @Column(name = "updated_at")
    private LocalDateTime updatedAt;
}