File size: 3,457 Bytes
b4f2238 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 | """Database models."""
from datetime import datetime
from typing import Any, ClassVar
from django.core.exceptions import ValidationError
from django.db import models
from django.db.models import Q
from django.utils.translation import gettext_lazy as _
class ReminderType(models.TextChoices):
HEARING = ("hearing", _("开庭"))
ASSET_PRESERVATION_EXPIRES = ("asset_preservation_expires", _("财产保全到期日"))
EVIDENCE_DEADLINE = ("evidence_deadline", _("举证到期日"))
APPEAL_DEADLINE = ("appeal_deadline", _("上诉期到期日"))
STATUTE_LIMITATIONS = ("statute_limitations", _("诉讼时效到期日"))
PAYMENT_DEADLINE = ("payment_deadline", _("缴费期限"))
SUBMISSION_DEADLINE = ("submission_deadline", _("补正/材料提交期限"))
OTHER = ("other", _("其他"))
class Reminder(models.Model):
id: int
contract_id: int | None
case_id: int | None
case_log_id: int | None
contract: Any = models.ForeignKey(
"contracts.Contract",
on_delete=models.CASCADE,
related_name="reminders",
null=True,
blank=True,
verbose_name=_("合同"),
)
case: Any = models.ForeignKey(
"cases.Case",
on_delete=models.CASCADE,
related_name="reminders",
null=True,
blank=True,
verbose_name=_("案件"),
)
case_log: Any = models.ForeignKey(
"cases.CaseLog",
on_delete=models.CASCADE,
related_name="reminders",
null=True,
blank=True,
verbose_name=_("案件日志"),
)
reminder_type: Any = models.CharField(max_length=64, choices=ReminderType.choices, verbose_name=_("类型"))
content: Any = models.CharField(max_length=255, verbose_name=_("提醒事项"))
due_at: Any = models.DateTimeField(verbose_name=_("到期时间"))
metadata: Any = models.JSONField(default=dict, blank=True, verbose_name=_("扩展数据"))
created_at: Any = models.DateTimeField(auto_now_add=True, verbose_name=_("创建时间"))
updated_at: Any = models.DateTimeField(auto_now=True, verbose_name=_("更新时间"))
class Meta:
verbose_name = _("重要日期提醒")
verbose_name_plural = _("重要日期提醒")
constraints: ClassVar = [
models.CheckConstraint(
condition=(Q(contract__isnull=True) | Q(case__isnull=True))
& (Q(contract__isnull=True) | Q(case_log__isnull=True))
& (Q(case__isnull=True) | Q(case_log__isnull=True)),
name="reminders_reminder_bind_at_most_one",
)
]
indexes: ClassVar = [
models.Index(fields=["due_at"]),
models.Index(fields=["reminder_type"]),
]
def clean(self) -> None:
super().clean()
bound_count = sum(target_id is not None for target_id in (self.contract_id, self.case_id, self.case_log_id))
if bound_count > 1:
raise ValidationError(_("合同、案件、案件日志最多只能绑定一个"))
def __str__(self) -> str:
if self.contract_id is not None:
target = f"contract:{self.contract_id}"
elif self.case_id is not None:
target = f"case:{self.case_id}"
elif self.case_log_id is not None:
target = f"case_log:{self.case_log_id}"
else:
target = "unbound"
return f"{target}-{self.reminder_type}-{self.due_at}"
|