| 12345678910111213141516171819202122232425262728293031323334 |
- from datetime import datetime
- from typing import List, Optional
- from sqlalchemy import Column, String, Integer, ForeignKey, DateTime, JSON
- from sqlalchemy.orm import Mapped, mapped_column, relationship
- from app.common.enums import PermissionFilterStrategy
- from app.core.base_model import EnterpriseMixin, PaymentModelMixin, TenantMixin
- class DepartmentModel(PaymentModelMixin, TenantMixin, EnterpriseMixin):
- """部门模型"""
- __tablename__ = "pay_department"
- __table_args__ = {"comment": "部门表"}
- __permission_strategy__ = PermissionFilterStrategy.ENTERPRISE_BASED
- id: Mapped[int] = mapped_column(primary_key=True, index=True, comment="主键ID")
- department_id: Mapped[str] = mapped_column(String(64), unique=True, nullable=False, comment="部门ID")
- department_name: Mapped[str] = mapped_column(String(128), nullable=False, comment="部门名称")
- department_code: Mapped[Optional[str]] = mapped_column(String(64), comment="部门编码")
- parent_department_id: Mapped[Optional[str]] = mapped_column(String(64), comment="上级部门ID")
- status: Mapped[str] = mapped_column(String(32), default="NORMAL", comment="状态")
- sort_order: Mapped[Optional[int]] = mapped_column(Integer, comment="排序值")
- leader_employee_id: Mapped[Optional[str]] = mapped_column(String(64), comment="部门负责人ID")
- leader_employee_name: Mapped[Optional[str]] = mapped_column(String(128), comment="部门负责人姓名")
- created_time: Mapped[datetime] = mapped_column(DateTime, default=datetime.now, comment="创建时间")
- updated_time: Mapped[datetime] = mapped_column(DateTime, default=datetime.now, onupdate=datetime.now, comment="更新时间")
- # 关联关系
- parent_department = relationship("DepartmentModel", remote_side=[department_id], backref="sub_departments", primaryjoin="DepartmentModel.parent_department_id == DepartmentModel.department_id")
- def __repr__(self):
- return f"<DepartmentModel(department_id={self.department_id}, department_name={self.department_name})>"
|
