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")