import { Department } from "src/modules/departments/entities/department.entity"
import { BaseEntity } from "../../common/entities/base.entity"
import { Company } from "../../company/entities/company.entity"
import {
  Column,
  Entity,
  Index,
  JoinColumn,
  JoinTable,
  ManyToMany,
  ManyToOne,
  PrimaryGeneratedColumn,
} from "typeorm"

@Index(["company", "name"], { unique: true })
@Entity("mis_business_kpis")
export class MisBusinessKpis extends BaseEntity {
  @PrimaryGeneratedColumn()
  id: number

  @Column({ type: "varchar", nullable: false })
  name: string

  @Column({ type: "smallint", default: 1 })
  status: number

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

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

  @ManyToMany(() => Department, (department) => department.businessKpis)
  @JoinTable({
    name: "business_kpis_departments",
    joinColumn: { name: "kpi_id" },
    inverseJoinColumn: { name: "department_id" },
  })
  departments: Department[]
}