import { Customer } from "src/modules/customers/entities/customer.entity"
import { Trip } from "src/modules/trips/entities/trip.entity"
import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  CreateDateColumn,
  UpdateDateColumn,
  DeleteDateColumn,
  ManyToOne,
  JoinColumn,
  ManyToMany,
} from "typeorm"

@Entity("escort")
export class Escort {
  @PrimaryGeneratedColumn()
  id: number

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

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

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

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

  @Column({ type: "varchar", nullable: true })
  date_of_birth?: Date

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

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

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

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

  @Column({ type: "varchar", nullable: true })
  visa_start_date?: Date

  @Column({ type: "varchar", nullable: true })
  visa_end_date?: Date

  @Column({ type: "boolean", default: false })
  is_sponsered?: boolean

  @Column({ type: "varchar", nullable: true })
  escort_type?: 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(() => Customer, (customer) => customer.escort)
  @JoinColumn({ name: "customer_id" })
  customer: Customer

  @ManyToMany(() => Trip, (trip) => trip.escorts)
  trips: Trip[]
}