shanxia/bx/bx-backend/app/models/advance.py

from datetime import datetime
from decimal import Decimal

from sqlalchemy import BigInteger, DateTime, ForeignKey, Integer, Numeric, String, func
from sqlalchemy.orm import Mapped, mapped_column, relationship

from app.database import Base
from app.models.base import BaseModel, SoftDeleteMixin


class AdvanceApply(BaseModel, SoftDeleteMixin):
    __tablename__ = "bx_advance_apply"

    apply_code: Mapped[str] = mapped_column(String(32), nullable=False, unique=True)
    applicant_id: Mapped[int] = mapped_column(BigInteger, nullable=False)
    applicant_name: Mapped[str] = mapped_column(String(64), nullable=False)
    reason: Mapped[str] = mapped_column(String(1024), nullable=False)
    purpose: Mapped[str | None] = mapped_column(String(1024))
    expense_item_id: Mapped[int | None] = mapped_column(BigInteger, nullable=True)
    amount: Mapped[Decimal] = mapped_column(Numeric(14, 2), nullable=False)
    status: Mapped[str] = mapped_column(String(32), nullable=False, default="draft", server_default="draft")
    current_node: Mapped[str | None] = mapped_column(String(128))
    wf_id: Mapped[int | None] = mapped_column(BigInteger)
    issue_status: Mapped[str | None] = mapped_column(String(32))
    issue_time: Mapped[datetime | None] = mapped_column(DateTime)
    issue_user_id: Mapped[int | None] = mapped_column(BigInteger)
    issue_user_name: Mapped[str | None] = mapped_column(String(64))
    issue_remark: Mapped[str | None] = mapped_column(String(512))
    actual_amount: Mapped[Decimal | None] = mapped_column(Numeric(14, 2))
    remark: Mapped[str | None] = mapped_column(String(512))

    approvals: Mapped[list["AdvanceApproval"]] = relationship(back_populates="apply")


class AdvanceApproval(Base):
    __tablename__ = "bx_advance_approval"

    id: Mapped[int] = mapped_column(BigInteger, primary_key=True, autoincrement=True)
    apply_id: Mapped[int] = mapped_column(BigInteger, ForeignKey("bx_advance_apply.id"), nullable=False)
    node_order: Mapped[int] = mapped_column(Integer, nullable=False)
    node_name: Mapped[str] = mapped_column(String(128), nullable=False)
    approver_id: Mapped[int] = mapped_column(BigInteger, nullable=False)
    approver_name: Mapped[str] = mapped_column(String(64), nullable=False)
    approval_status: Mapped[str] = mapped_column(String(32), nullable=False)
    approval_opinion: Mapped[str | None] = mapped_column(String(1024))
    approval_time: Mapped[datetime] = mapped_column(DateTime, nullable=False)

    apply: Mapped["AdvanceApply"] = relationship(back_populates="approvals")