import { Column, Entity, Index, JoinColumn, ManyToOne } from 'typeorm';
import { AreaUnit, HarvestType } from '@wh/shared';
import { idColumn, idColumnNullable, money } from '../../common/columns';
import { AuditedEntity } from '../../common/entities/audited.entity';
import { Agent } from '../agents/agent.schema';
import { Customer } from '../customers/customer.schema';
import { Harvester } from '../harvesters/harvester.schema';

/** A harvesting job on a plot of land, carrying its commercial terms. */
@Entity('plots')
@Index(['tenantId', 'harvesterId', 'harvestDate'])
@Index(['tenantId', 'customerId', 'harvestDate'])
@Index(['tenantId', 'agentId'])
export class Plot extends AuditedEntity {
  @Column(idColumn)
  customerId!: string;

  @Column(idColumn)
  harvesterId!: string;

  @Column({ type: 'varchar', length: 120 })
  plotName!: string;

  @Column({ type: 'varchar', length: 120, nullable: true })
  village?: string | null;

  @Column(money())
  area!: number;

  @Column({ type: 'enum', enum: AreaUnit, default: AreaUnit.BIGHA })
  areaUnit!: AreaUnit;

  @Column({ type: 'datetime' })
  harvestDate!: Date;

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

  @Column({ type: 'enum', enum: HarvestType })
  harvestType!: HarvestType;

  // Harvesting charge to the landowner (both types)
  @Column(money())
  ratePerBigha!: number;

  @Column(money())
  harvestingAmount!: number;

  @Column(money())
  totalAmount!: number;

  // Optional commission agent for this job.
  @Column(idColumnNullable)
  agentId?: string | null;

  @Column(money({ default: 0 }))
  commissionAmount?: number;

  // --- Foreign keys (the id columns above are the FK columns) ---
  @ManyToOne(() => Customer, { onDelete: 'RESTRICT' })
  @JoinColumn({ name: 'customerId' })
  customer?: Customer;

  @ManyToOne(() => Harvester, { onDelete: 'RESTRICT' })
  @JoinColumn({ name: 'harvesterId' })
  harvester?: Harvester;

  @ManyToOne(() => Agent, { onDelete: 'SET NULL' })
  @JoinColumn({ name: 'agentId' })
  agent?: Agent | null;

  // --- Bhusa buyers (Type 2) live in the plot_bhusa_buyers join table. These
  // are NOT columns; LinksService hydrates them for the API response, keeping
  // the legacy bhusaBuyerId/bhusaAmount fields the mobile app still reads. ---
  bhusaBuyers?: { customerId: string; amount: number }[];
  bhusaBuyerId?: string | null;
  bhusaAmount?: number;
}