Spaces:
Sleeping
Sleeping
Download app/models/order.py from alisaleem97/NexLab_System: direct link, hf CLI and curl.
- Browser
- Download file 3.23 kB
-
https://huggingface.co/spaces/alisaleem97/NexLab_System/resolve/main/app/models/order.py
- Command line
-
hf download hf://spaces/alisaleem97/NexLab_System/app/models/order.py
-
curl -L -o order.py https://huggingface.co/spaces/alisaleem97/NexLab_System/resolve/main/app/models/order.py
3.23 kB
| # app/models/order.py | |
| # Order, Result, and ResultDetail models. | |
| from typing import Optional, List | |
| from datetime import datetime | |
| from sqlmodel import SQLModel, Field, Relationship | |
| from app.models.department import Parameter | |
| class Order(SQLModel, table=True): | |
| id: Optional[int] = Field(default=None, primary_key=True) | |
| order_number: str = Field(unique=True, index=True) | |
| patient_id: int = Field(foreign_key="patient.id") | |
| test_id: int = Field(foreign_key="testdefinition.id") | |
| status: str = Field(default="ordered") | |
| ordered_by: int = Field(foreign_key="user.id") | |
| collected_by: Optional[int] = Field(default=None, foreign_key="user.id") | |
| verified_by: Optional[int] = Field(default=None, foreign_key="user.id") | |
| order_date: datetime = Field(default_factory=datetime.now) | |
| collection_date: Optional[datetime] = None | |
| verified_date: Optional[datetime] = None | |
| visit_id: Optional[int] = Field(default=None, foreign_key="patientvisit.id") | |
| package_name: Optional[str] = Field(default=None) | |
| # Price snapshot at order time | |
| unit_price: float = Field(default=0.0) | |
| discount_amount: float = Field(default=0.0) | |
| final_price: float = Field(default=0.0) | |
| no_sample_reason: Optional[str] = Field(default=None) | |
| # Relationships — use string references for cross-module models | |
| patient: "Patient" = Relationship(back_populates="orders") | |
| test: "TestDefinition" = Relationship() | |
| result: Optional["Result"] = Relationship(back_populates="order") | |
| visit: Optional["PatientVisit"] = Relationship(back_populates="orders") | |
| class Result(SQLModel, table=True): | |
| id: Optional[int] = Field(default=None, primary_key=True) | |
| order_id: int = Field(foreign_key="order.id", unique=True) | |
| result_value: Optional[str] = Field(default=None) | |
| rerun_result: Optional[str] = Field(default=None) | |
| flag: Optional[str] = None | |
| note: Optional[str] = None | |
| device_id: Optional[int] = Field(default=None, foreign_key="device.id") | |
| entered_by: int = Field(foreign_key="user.id") | |
| entered_at: datetime = Field(default_factory=datetime.now) | |
| authorized: bool = Field(default=False) | |
| authorized_by: Optional[int] = Field(default=None, foreign_key="user.id") | |
| authorized_at: Optional[datetime] = None | |
| double_authorized: bool = Field(default=False) | |
| double_authorized_by: Optional[int] = Field(default=None, foreign_key="user.id") | |
| double_authorized_at: Optional[datetime] = None | |
| unauth_reason: Optional[str] = Field(default=None) | |
| order: Order = Relationship(back_populates="result") | |
| details: List["ResultDetail"] = Relationship(back_populates="result") | |
| class ResultDetail(SQLModel, table=True): | |
| id: Optional[int] = Field(default=None, primary_key=True) | |
| result_id: int = Field(foreign_key="result.id") | |
| parameter_id: int = Field(foreign_key="parameter.id") | |
| result_value: Optional[str] = Field(default=None) | |
| rerun_result: Optional[str] = Field(default=None) | |
| flag: Optional[str] = None | |
| device_id: Optional[int] = Field(default=None, foreign_key="device.id") | |
| remark: Optional[str] = Field(default=None) | |
| result: Result = Relationship(back_populates="details") | |
| parameter: Parameter = Relationship() | |