package model

import (
	"encoding/json"
	"time"

	"gorm.io/gorm"
)

// Category represents a help center category.
// Reference: Chatwoot Category model + P2B M9 spec
type Category struct {
	ID          uint           `gorm:"primaryKey" json:"id"`
	PortalID    uint           `gorm:"not null;index" json:"portal_id"`
	Name        string         `gorm:"size:255;not null" json:"name"`
	Slug        string         `gorm:"size:255;not null;index" json:"slug"`
	Description string         `gorm:"type:text" json:"description"`
	Icon        string         `gorm:"size:255" json:"icon"`
	Position    int            `gorm:"default:0" json:"position"`
	Locale      string         `gorm:"size:10;default:'en'" json:"locale"`
	ParentID    *uint          `gorm:"index" json:"parent_id,omitempty"`
	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"`
	Parent *Category  `gorm:"foreignKey:ParentID" json:"parent,omitempty"`
	Articles []Article `gorm:"foreignKey:CategoryID" json:"articles,omitempty"`
}

func (Category) TableName() string { return "categories" }