import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
} from "typeorm"
import { BaseEntity } from "../../common/entities/base.entity"
import { Company } from "../../company/entities/company.entity"
import { Employee } from "../../employees/entities/employee.entity"
import { Auth } from "../../auth/entities/auth.entity"
import { decimalTransformer } from "../../../utils/helpers"

@Entity("mis_report_rating_feedbacks")
export class MisReportRatingFeedback extends BaseEntity {
  @PrimaryGeneratedColumn()
  id: number

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

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

  @Column({ type: "text", nullable: true })
  business_feedback: string

  @Column({ type: "text", nullable: true })
  technical_feedback: string

  @Column({ type: "text", nullable: true })
  personal_feedback: string

  @Column({
    type: "decimal",
    precision: 3,
    scale: 2,
    nullable: false,
    default: 0,
    transformer: decimalTransformer,
  })
  business_rating: number

  @Column({
    type: "decimal",
    precision: 3,
    scale: 2,
    nullable: false,
    default: 0,
    transformer: decimalTransformer,
  })
  technical_rating: number

  @Column({
    type: "decimal",
    precision: 3,
    scale: 2,
    nullable: false,
    default: 0,
    transformer: decimalTransformer,
  })
  personal_rating: number

  @Column({
    type: "decimal",
    precision: 3,
    scale: 2,
    nullable: false,
    default: 0,
    transformer: decimalTransformer,
  })
  average_rating: number

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

  @Column({ type: "smallint", nullable: false })
  month: number

  @Column({ type: "smallint", nullable: false })
  year: number

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

  @ManyToOne(() => Employee)
  @JoinColumn({ name: "employee_id" })
  employee: Employee

  @ManyToOne(() => Auth)
  @JoinColumn({ name: "action_by_id" })
  actionBy: Auth
}