import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
  OneToMany,
  Index,
} from "typeorm"
import { BaseEntity } from "../../common/entities/base.entity"
import { Company } from "../../company/entities/company.entity"
import { PayrollEntry } from "./payroll-entry.entity"

export enum PayrollCycleStatus {
  DRAFT = "0",
  FINALIZED = "1",
  PAID = "2",
}

@Entity("payroll_cycles")
@Index(["company_id", "month", "year"], { unique: true })
export class PayrollCycle extends BaseEntity {
  @PrimaryGeneratedColumn()
  id: number

  @Column({ type: "int", nullable: false })
  company_id: number

  @Column({ type: "int", nullable: false, comment: "1-12" })
  month: number

  @Column({ type: "int", nullable: false, comment: "e.g., 2025" })
  year: number

  @Column({
    type: "varchar",
    default: PayrollCycleStatus.DRAFT,
    comment: "0=Draft, 1=Finalized, 2=Paid",
  })
  status: PayrollCycleStatus

  @Column({ type: "int", nullable: true })
  locked_by: number

  @Column({ type: "timestamp", nullable: true })
  locked_at: Date

  // Relations
  @ManyToOne(() => Company)
  @JoinColumn({ name: "company_id" })
  company: Company

  @OneToMany(() => PayrollEntry, (payrollEntry) => payrollEntry.payroll_cycle)
  payroll_entries: PayrollEntry[]
}