alisaleem97's picture
Upload folder using huggingface_hub
6ea020b verified
Raw History Blame Contribute Delete
1.77 kB
# 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")