import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
  CreateDateColumn,
  UpdateDateColumn,
  DeleteDateColumn,
} from "typeorm"
import { Invoice } from "src/modules/invoices/entities/invoice.entity"
import { Trip } from "src/modules/trips/entities/trip.entity"

@Entity("invoice_trips")
export class InvoiceTrips {
  @PrimaryGeneratedColumn()
  id: number

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

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

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

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

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

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

  @ManyToOne(() => Invoice, (invoice) => invoice.invoice_trips, {
    onDelete: "CASCADE",
  })
  @JoinColumn({ name: "invoice_id" })
  invoice: Invoice

  @ManyToOne(() => Trip, (trip) => trip.invoice_trips, { onDelete: "CASCADE" })
  @JoinColumn({ name: "trip_id" })
  trip: Trip
}