import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
  CreateDateColumn,
  UpdateDateColumn,
  DeleteDateColumn,
  AfterLoad,
} from "typeorm"
import { ClientCompanyContact } from "src/modules/client-company-contacts/entities/client-company-contact.entity"
import { Plan } from "src/modules/plans/entities/plan.entity"
import { ClientsCompany } from "src/modules/clients-companies/entities/clients-company.entity"

@Entity("client_company_contracts")
export class ClientCompanyContract {
  @PrimaryGeneratedColumn()
  id: number

  @Column({ type: "int" })
  client_company_id: number

  @Column({ type: "date" })
  start_date: Date

  @Column({ type: "date" })
  end_date: Date

  @Column({ type: "int" })
  payment_plan_id: number

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

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

  @Column({
    type: "varchar",
    nullable: true,
  })
  payment_schedule: string

  @Column({ type: "varchar", nullable: true })
  contract_document: string

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

  @Column({ type: "varchar", nullable: true })
  status: string

  @CreateDateColumn({ type: "timestamp", default: () => "NOW()" })
  created_at: Date

  @UpdateDateColumn({ type: "timestamp", default: () => "NOW()" })
  updated_at: Date

  @DeleteDateColumn({ type: "timestamp", nullable: true })
  deleted_at: Date

  @ManyToOne(() => Plan, (plan) => plan.contracts, { cascade: true })
  @JoinColumn({ name: "payment_plan_id" })
  payment_plan: Plan

  @ManyToOne(() => ClientCompanyContact, (contact) => contact.contracts, {
    cascade: true,
  })
  @JoinColumn({ name: "authorized_contact_id" })
  authorized_contact: ClientCompanyContact

  @ManyToOne(
    () => ClientsCompany,
    (client_company) => client_company.contracts,
    {
      cascade: true,
    },
  )
  @JoinColumn({ name: "client_company_id" })
  client_company: ClientsCompany

  @AfterLoad()
  async contractDocumentUrl() {
    if (this.contract_document) {
      this.contract_document =
        process.env.FILE_UPLOAD === "Local"
          ? `${process.env.BACK_URL}/${this.contract_document}`
          : `${process.env.CLOUDFLARE_R2_PUBLIC_URL}/${this.contract_document}`
    }
  }
}
