from django.db import models
from utils.models import CoreModel
from apps.project.models import Project
from tinymce.models import HTMLField

# ~~~~~~~~~~~~~字典以及字典item~~~~~~~~~~~~~
class Dict(CoreModel):
    objects = models.Manager()
    name = models.CharField(max_length=100, blank=True, null=True, verbose_name="字典名称", help_text="字典名称")
    code = models.CharField(max_length=100, blank=True, null=True, verbose_name="编码", help_text="编码")
    status = models.CharField(max_length=8, blank=True, null=True, verbose_name="状态", help_text="状态", default='1')
    remark = models.CharField(max_length=2000, blank=True, null=True, verbose_name="备注", help_text="备注")

    def __str__(self):
        return f'字典名称:{self.name}-字典类码:{self.code}'

    class Meta:
        db_table = 'system_dict'
        verbose_name = "字典表"
        verbose_name_plural = verbose_name
        ordering = ('-create_datetime',)

class DictItem(CoreModel):
    objects = models.Manager()
    title = models.CharField(max_length=100, blank=True, null=True, verbose_name="显示名称", help_text="显示名称")
    key = models.CharField(max_length=100, blank=True, null=True, verbose_name="实际值", help_text="实际值")
    show_title = models.CharField(max_length=64, blank=True, verbose_name="类型转文字", help_text="类型转文字")
    status = models.CharField(max_length=8, blank=True, null=True, verbose_name="状态", help_text="状态", default='1')
    dict = models.ForeignKey(to="Dict", db_constraint=False, related_name="dictItem", on_delete=models.CASCADE,
                             help_text="字典")
    remark = models.CharField(max_length=2000, blank=True, null=True, verbose_name="备注", help_text="备注")
    # 针对依据文件的字段
    doc_name = models.CharField(max_length=64, blank=True, null=True, verbose_name="文档名称", help_text="文档名称")
    publish_date = models.CharField(max_length=64, blank=True, null=True, verbose_name="发布日期", help_text="发布日期")
    source = models.CharField(max_length=32, blank=True, null=True, verbose_name='来源', help_text="来源")

    def __str__(self):
        return f'字典项名称:{self.title}-字典项显示名称:{self.show_title}'

    class Meta:
        db_table = 'system_dict_item'
        verbose_name = "字典表item表"
        verbose_name_plural = verbose_name
        ordering = ('-create_datetime',)

# ~~~~~~~~~~~~~用户文档片段~~~~~~~~~~~~~
# fragment表
class Fragment(CoreModel):
    name = models.CharField(verbose_name='片段名称-必须和文件名一致', max_length=128)
    is_main = models.BooleanField(default=False, verbose_name='是否替换磁盘的片段')
    content = HTMLField(null=True, blank=True, verbose_name='片段富文本', help_text='文档片段的富文本')
    # 关联的项目
    project = models.ForeignKey(Project, related_name='frag', related_query_name='qFrag', on_delete=models.CASCADE)

    class Meta:
        db_table = 'fragment_core'
        verbose_name = '文档片段'
        verbose_name_plural = verbose_name
        ordering = ('-create_datetime', '-id')
        # 片段名称name和所属产品文档联合唯一
        constraints = [
            models.UniqueConstraint(fields=['name', 'project_id'], name='unique_name')
        ]