package model

import (
	"encoding/json"
	"time"

	"gorm.io/gorm"
)

// Article represents a help center article.
// Reference: Chatwoot Article model + P2B M9 spec
type Article struct {
	ID               uint           `gorm:"primaryKey" json:"id"`
	PortalID         uint           `gorm:"not null;index" json:"portal_id"`
	CategoryID       *uint          `gorm:"index" json:"category_id,omitempty"`
	FolderID         *uint          `gorm:"index" json:"folder_id,omitempty"`
	AuthorID         *uint          `gorm:"index" json:"author_id,omitempty"`
	Title            string         `gorm:"size:255;not null" json:"title"`
	Slug             string         `gorm:"size:255;not null;uniqueIndex" json:"slug"`
	Content          string         `gorm:"type:text" json:"content"`
	Status           string         `gorm:"size:50;not null;default:'draft'" json:"status"` // draft/published/archived
	Position         int            `gorm:"default:0" json:"position"`
	Views            int            `gorm:"default:0" json:"views"`
	Locale           string         `gorm:"size:10;default:'en'" json:"locale"`
	AssociatedArticleID *uint       `gorm:"index" json:"associated_article_id,omitempty"` // translations
	CustomAttributes json.RawMessage `gorm:"type:jsonb" json:"custom_attributes"`
	CreatedAt        time.Time      `gorm:"autoCreateTime" json:"created_at"`
	UpdatedAt        time.Time      `gorm:"autoUpdateTime" json:"updated_at"`
	DeletedAt        gorm.DeletedAt `gorm:"index" json:"deleted_at,omitempty"`

	Portal            Portal         `gorm:"foreignKey:PortalID" json:"portal,omitempty"`
	Category          *Category      `gorm:"foreignKey:CategoryID" json:"category,omitempty"`
	Folder            *Folder        `gorm:"foreignKey:FolderID" json:"folder,omitempty"`
	Author            *User          `gorm:"foreignKey:AuthorID" json:"author,omitempty"`
	AssociatedArticle *Article       `gorm:"foreignKey:AssociatedArticleID" json:"associated_article,omitempty"`
	Embeddings        []ArticleEmbedding `gorm:"foreignKey:ArticleID" json:"embeddings,omitempty"`
	RelatedCategories []RelatedCategory `gorm:"foreignKey:ArticleID" json:"related_categories,omitempty"`
}

func (Article) TableName() string { return "articles" }