import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  CreateDateColumn,
  UpdateDateColumn,
  DeleteDateColumn,
  ManyToOne,
  OneToMany,
  JoinColumn,
} from 'typeorm';
import { User } from './user.entity';
import { MasterQuestion } from './master-question.entity';

@Entity('master_form_section')
export class MasterFormSection {
  @PrimaryGeneratedColumn({ type: 'bigint' })
  id: number;

  @Column({ name: 'section_key', type: 'varchar', length: 100, unique: true })
  sectionKey: string;

  @Column({ name: 'name', type: 'varchar', length: 255 })
  name: string;

  @Column({ name: 'description', type: 'text', nullable: true })
  description: string;

  @Column({ name: 'parent_section_id', type: 'bigint', nullable: true })
  parentSectionId: number | null;

  @ManyToOne(() => MasterFormSection, { nullable: true, onDelete: 'SET NULL' })
  @JoinColumn({ name: 'parent_section_id' })
  parentSection: MasterFormSection;

  @Column({ name: 'conditional_config', type: 'jsonb', nullable: true })
  conditionalConfig: Record<string, any> | null;

  @Column({ name: 'is_active', type: 'boolean', default: true })
  isActive: boolean;

  @CreateDateColumn({ name: 'created_at', type: 'timestamptz', default: () => 'CURRENT_TIMESTAMP' })
  createdAt: Date;

  @UpdateDateColumn({ name: 'updated_at', type: 'timestamptz', default: () => 'CURRENT_TIMESTAMP', onUpdate: 'CURRENT_TIMESTAMP' })
  updatedAt: Date;

  @DeleteDateColumn({ name: 'deleted_at', type: 'timestamptz', nullable: true })
  deletedAt: Date | null;

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

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

  @ManyToOne(() => User, { nullable: true, onDelete: 'SET NULL' })
  @JoinColumn({ name: 'created_by' })
  createdByUser: User;

  @ManyToOne(() => User, { nullable: true, onDelete: 'SET NULL' })
  @JoinColumn({ name: 'updated_by' })
  updatedByUser: User;

  @OneToMany(() => MasterQuestion, (question) => question.masterFormSection)
  questions: MasterQuestion[];

  constructor(partial: Partial<MasterFormSection>) {
    Object.assign(this, partial);
  }
}