import {
  Column,
  CreateDateColumn,
  DeleteDateColumn,
  Entity,
  Index,
  ManyToOne,
  OneToMany,
  PrimaryGeneratedColumn,
  UpdateDateColumn,
} from 'typeorm';
import { Member } from './member.entity';
import { Office } from './office.entity';
import { SavingsTransaction } from './savings-transaction.entity';

@Entity({ name: 'savings_accounts' })
@Index('idx_savings_status_type', ['status', 'accountType'])
export class SavingsAccount {
  @PrimaryGeneratedColumn('uuid')
  id!: string;

  @Index()
  @Column({ type: 'varchar', name: 'account_number', length: 30, nullable: true })
  accountNumber?: string;

  @Index()
  @Column({ type: 'varchar', name: 'member_id', nullable: true })
  memberId?: string;

  @ManyToOne(() => Member, { nullable: true, onDelete: 'SET NULL' })
  member?: Member;

  @Column({ type: 'varchar', name: 'office_id', nullable: true })
  officeId?: string;

  @ManyToOne(() => Office, { nullable: true, onDelete: 'SET NULL' })
  office?: Office;

  @Column({ type: 'varchar', name: 'account_type', length: 50, default: 'regular' })
  accountType!: string;

  @Column({ type: 'varchar', name: 'open_date', length: 20, nullable: true })
  openDate?: string;

  @Column({ type: 'varchar', name: 'open_date_bs', length: 20, nullable: true })
  openDateBs?: string;

  @Column({ name: 'current_balance', type: 'decimal', precision: 15, scale: 2, default: 0 })
  currentBalance!: number;

  @Column({ name: 'interest_rate', type: 'decimal', precision: 5, scale: 2, default: 0 })
  interestRate!: number;

  @Column({ name: 'minimum_balance', type: 'decimal', precision: 15, scale: 2, default: 0 })
  minimumBalance!: number;

  @Index()
  @Column({ type: 'varchar', name: 'status', length: 20, default: 'active' })
  status!: string;

  @Column({ type: 'varchar', name: 'close_date', length: 20, nullable: true })
  closeDate?: string;

  @Column({ type: 'varchar', name: 'close_date_bs', length: 20, nullable: true })
  closeDateBs?: string;

  @Column({ type: 'varchar', name: 'fiscal_year', length: 20, nullable: true })
  fiscalYear?: string;

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

  @OneToMany(() => SavingsTransaction, (tx) => tx.account, { cascade: true })
  transactions?: SavingsTransaction[];

  @DeleteDateColumn({ name: 'deleted_at' })
  deletedAt?: Date;

  @CreateDateColumn({ name: 'created_at' })
  createdAt!: Date;

  @UpdateDateColumn({ name: 'updated_at' })
  updatedAt!: Date;
}