from sqlalchemy import Column, String, Date, Time, Integer, DateTime, ForeignKey, func
from sqlalchemy.orm import relationship
from app.models.base import BaseModel


class LemburItem(BaseModel):
    __tablename__ = "lembur_items"

    pengajuan_lembur_id = Column(
        String(36),
        ForeignKey("pengajuan_lembur.id", ondelete="NO ACTION"),
        nullable=False,
    )

    user_id = Column(
        String(36), ForeignKey("users.id", ondelete="NO ACTION"), nullable=False
    )

    urutan = Column(Integer, nullable=False)
    tanggal = Column(Date, nullable=False)
    start_time = Column(Time, nullable=False)
    end_time = Column(Time, nullable=False)
    jumlah = Column(Integer, nullable=False)
    user = relationship("User", foreign_keys=[user_id], lazy="joined")
    lembur = relationship("PengajuanLembur", back_populates="list_staff")