Spaces:
Sleeping
Sleeping
File size: 1,770 Bytes
6ea020b | 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 | # app/models/hr.py
# Employee and EmployeeAttachment models for HR management.
from typing import Optional, List
from datetime import datetime
from sqlmodel import SQLModel, Field, Relationship
class Employee(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
full_name: str = Field(index=True)
age: Optional[int] = None
phone: Optional[str] = None
address: Optional[str] = None
photo_path: Optional[str] = None
start_date: datetime = Field(default_factory=datetime.now)
# Store working days as a comma-separated string or JSON string (e.g. "Monday, Tuesday, Wednesday")
working_days: Optional[str] = None
# Store hours as "09:00" and "17:00" for simplicity
working_hours_start: Optional[str] = None
working_hours_end: Optional[str] = None
salary: Optional[float] = None
username: Optional[str] = None
is_active: bool = Field(default=True)
created_at: datetime = Field(default_factory=datetime.now)
attachments: List["EmployeeAttachment"] = Relationship(back_populates="employee", cascade_delete=True)
@property
def working_life_months(self) -> int:
if not self.start_date:
return 0
now = datetime.now()
delta = now.year * 12 + now.month - (self.start_date.year * 12 + self.start_date.month)
return delta if delta > 0 else 0
class EmployeeAttachment(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
employee_id: int = Field(foreign_key="employee.id", index=True)
file_name: str
file_path: str
uploaded_at: datetime = Field(default_factory=datetime.now)
employee: Optional["Employee"] = Relationship(back_populates="attachments")
|