import {
  Column,
  Entity,
  JoinColumn,
  ManyToOne,
  PrimaryGeneratedColumn,
} from "typeorm"
import { TeamMember } from "src/modules/team-member/entities/team_member.entity"
import { Trip } from "src/modules/trips/entities/trip.entity"
import { FleetManagement } from "src/modules/fleet-management/entities/fleet-management.entity"
import { VehicleType } from "src/modules/vehicle-type/entities/vehicle-type.entity"

@Entity("trip_fleet_assignments")
export class TripFleetAssignment {
  @PrimaryGeneratedColumn()
  id: number

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

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

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

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

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

  @ManyToOne(() => FleetManagement, (fleet) => fleet.assignments, {
    onDelete: "CASCADE",
  })
  @JoinColumn({ name: "fleet_id" })
  fleet: FleetManagement

  @ManyToOne(() => VehicleType, (vehicle_type) => vehicle_type.fleetManagements)
  @JoinColumn({ name: "fleet_type_id" })
  vehicle_type: VehicleType

  @ManyToOne(() => TeamMember, (driver) => driver.trip_driver)
  @JoinColumn({ name: "driver_id" })
  driver?: TeamMember

  @Column({ type: "timestamp", default: () => "CURRENT_TIMESTAMP" })
  assigned_at: Date

  @Column({ type: "timestamp", nullable: true })
  released_at: Date

  @Column({ type: "timestamp", nullable: true })
  trip_completed_at: Date
}