import {
  BaseEntity,
  Column,
  Entity,
  Index,
  JoinColumn,
  ManyToOne,
  PrimaryGeneratedColumn,
} from 'typeorm';
import { UserEntity } from '../../user/entities/user.entity';
import { PaymentEntity } from '../../payment/entities/payment.entity';

export enum NegativeScoreStatus {
  pending = 'pending',
  paid_inquiry = 'paid_inquiry',
  inquired = 'inquired',
}

export enum NegativeScoreType {
  basic = 'basic',
  advanced = 'advanced',
}

export enum NegativeScoreClient {
  site = 'site',
  app = 'app',
  panel = 'panel',
}

@Index('fk_negative_scores_payments1_idx', ['paymentInquiryId'], {})
@Index('fk_negative_scores_users1_idx', ['userId'], {})
@Entity('negative_scores')
export class NegativeScoreEntity extends BaseEntity {
  @PrimaryGeneratedColumn({ type: 'int', name: 'id' })
  id: number;

  @Column('char', { name: 'userId', length: 36 })
  userId: string;

  @Column('int', { name: 'paymentInquiryId', nullable: true })
  paymentInquiryId: number | null;

  @Column('varchar', { name: 'licenseNumber', length: 128 })
  licenseNumber: string;

  @Column('varchar', { name: 'negativeScore', nullable: true, length: 128 })
  negativeScore: string | null;

  @Column('int', { name: 'offenseCount', nullable: true })
  offenseCount: number | null;

  @Column('tinyint', { name: 'allowedToDrive', nullable: true, width: 1 })
  allowedToDrive: boolean | null;

  @Column('int', { name: 'inquiryAmount' })
  inquiryAmount: number;

  @Column('varchar', { name: 'rule', nullable: true, length: 128 })
  rule: string | null;

  @Column('enum', {
    name: 'status',
    enum: NegativeScoreStatus,
    default: () => NegativeScoreStatus.pending,
  })
  status: NegativeScoreStatus;

  @Column('enum', {
    name: 'type',
    nullable: true,
    enum: NegativeScoreType,
    default: () => NegativeScoreType.basic,
  })
  type: NegativeScoreType | null;

  @Column('enum', {
    name: 'client',
    enum: NegativeScoreClient,
    default: () => NegativeScoreClient.site,
  })
  client: NegativeScoreClient;

  @Column('datetime', { name: 'createdAt' })
  createdAt: Date;

  @Column('datetime', { name: 'updatedAt' })
  updatedAt: Date;

  /**
   * relations
   */
  @ManyToOne(() => PaymentEntity, (payments) => payments.negativeScores, {
    onDelete: 'NO ACTION',
    onUpdate: 'NO ACTION',
  })
  @JoinColumn([{ name: 'paymentInquiryId', referencedColumnName: 'id' }])
  paymentInquiry: PaymentEntity;

  @ManyToOne(() => UserEntity, (users) => users.negativeScores, {
    onDelete: 'NO ACTION',
    onUpdate: 'NO ACTION',
  })
  @JoinColumn([{ name: 'userId', referencedColumnName: 'id' }])
  user: UserEntity;
}