import { Injectable, Logger } from '@nestjs/common';
import type { Action } from '@pac/types';
import { PrismaService } from '../../../prisma/prisma.service';
import { ParserRegistry } from './parsers/parser.registry';
import {
  type BulkEntry,
  FactWriter,
  FactWriteResult,
} from './fact-writer.service';

/**
 * ParserPipeline — transaction → fact 衍生编排器
 *
 * 输入:已写库的 transaction(含 id)+ 对应 canonical row
 * 流程:
 *   1. 按 transaction.action 查 ParserRegistry
 *   2. parser.parse(ctx) → FactDraft[]
 *   3. 逐个调用 FactWriter.writeDraft
 *   4. 汇总 metrics(created / superseded / unchanged / evidence_appended)
 *
 * 设计:
 *   - 无 parser 的 action 静默跳过(返回 zero metrics)— transaction 已落账,稍后补 parser 重放即可
 *   - 单条 transaction 的多 fact 衍生**不开外层事务** — 每 draft 一次 $transaction(FactWriter 内部)
 *     原因:外层事务跨多 subject 会放大锁范围;每 fact 独立写更适配未来 BullMQ jobName=subject_id 串行化
 *   - parser 抛错时单条 transaction 整体计 failed,不影响后续 transaction(由上层捕获)
 */
@Injectable()
export class ParserPipeline {
  private readonly logger = new Logger(ParserPipeline.name);

  constructor(
    private readonly registry: ParserRegistry,
    private readonly writer: FactWriter,
    private readonly prisma: PrismaService,
  ) {}

  /**
   * @returns PipelineRunMetrics 本次 transaction 衍生统计(单条 transaction)
   */
  async runForTransaction(input: {
    transaction: {
      id: string;
      hostId: string;
      tenantId: string;
      patientId: string | null;
      action: Action;
      subjectType: string;
      subjectId: string;
      occurredAt: Date;
      clinicId: string;
    };
    canonicalRow: Record<string, unknown>;
  }): Promise<PipelineRunMetrics> {
    const { transaction, canonicalRow } = input;
    const parser = this.registry.get(transaction.action);
    const metrics: PipelineRunMetrics = {
      action: transaction.action,
      parserMatched: !!parser,
      factsCreated: 0,
      factsSuperseded: 0,
      factsUnchanged: 0,
      factsEvidenceAppended: 0,
      factsStaleSkipped: 0,
      factsFailed: 0,
      writes: [],
    };

    if (!parser) {
      this.logger.debug(
        `no parser for action=${transaction.action};skip(transaction=${transaction.id})`,
      );
      return metrics;
    }

    if (!transaction.patientId) {
      this.logger.warn(
        `parser pipeline: transaction ${transaction.id} has no patientId;skip fact derivation`,
      );
      return metrics;
    }

    const drafts = parser.parse({ transaction, canonicalRow });
    const sourceUpdatedAt = parseSourceUpdatedAt(canonicalRow);

    // fact 的 source_unit = 该患者的 source_unit(集团内 subject_id 撞号消歧)
    const patientSourceUnit =
      (
        await this.prisma.patient.findUnique({
          where: { id: transaction.patientId },
          select: { sourceUnit: true },
        })
      )?.sourceUnit ?? '';

    for (const draft of drafts) {
      try {
        const result = await this.writer.writeDraft({
          draft,
          hostId: transaction.hostId,
          tenantId: transaction.tenantId,
          sourceUnit: patientSourceUnit,
          patientId: transaction.patientId,
          transactionId: transaction.id,
          sourceUpdatedAt,
        });
        metrics.writes.push(result);
        switch (result.action) {
          case 'created':
            metrics.factsCreated++;
            break;
          case 'superseded':
            metrics.factsSuperseded++;
            break;
          case 'unchanged':
            metrics.factsUnchanged++;
            break;
          case 'evidence_appended':
            metrics.factsEvidenceAppended++;
            break;
          case 'stale_skipped':
            metrics.factsStaleSkipped++;
            break;
        }
      } catch (err) {
        metrics.factsFailed++;
        this.logger.error(
          `fact write failed: subjectId=${draft.subjectId} type=${draft.type} err=${
            err instanceof Error ? err.message : String(err)
          }`,
        );
      }
    }

    return metrics;
  }

  /**
   * 批量版 — N 条 transaction 一起跑 parser → 收集所有 draft → 1 次 bulk fact write
   * PR4 引入,跟 runForTransaction 行为等价,但**减少 SQL 往返 ~ N 倍**(单次 batch SELECT + bulk INSERT/UPDATE)
   *
   * 注意:本方法假设所有 transaction 同 hostId+tenantId(processSubject 满足)
   * 返回:整批的 PipelineRunMetrics(汇总)
   */
  async runForBatch(items: BatchItem[]): Promise<PipelineRunMetrics> {
    const metrics: PipelineRunMetrics = {
      action: 'BATCH',
      parserMatched: true,
      factsCreated: 0,
      factsSuperseded: 0,
      factsUnchanged: 0,
      factsEvidenceAppended: 0,
      factsStaleSkipped: 0,
      factsFailed: 0,
      writes: [],
    };

    // fact 的 source_unit = 该患者的 source_unit(集团内 subject_id 撞号消歧)。
    // patient 先于 fact 落库,按 patientId 批量取一次。
    const patientIds = [
      ...new Set(items.map((i) => i.transaction.patientId).filter((p): p is string => !!p)),
    ];
    const suRows = await this.prisma.patient.findMany({
      where: { id: { in: patientIds } },
      select: { id: true, sourceUnit: true },
    });
    const suMap = new Map(suRows.map((p) => [p.id, p.sourceUnit]));

    // 1. 全部 tx 走 parser,收集 drafts(in-memory)
    const bulkEntries: BulkEntry[] = [];
    for (const item of items) {
      const parser = this.registry.get(item.transaction.action);
      if (!parser) {
        this.logger.debug(`no parser for action=${item.transaction.action};skip`);
        continue;
      }
      if (!item.transaction.patientId) continue;
      try {
        const drafts = parser.parse({
          transaction: item.transaction,
          canonicalRow: item.canonicalRow,
        });
        const sourceUpdatedAt = parseSourceUpdatedAt(item.canonicalRow);
        for (const draft of drafts) {
          bulkEntries.push({
            draft,
            hostId: item.transaction.hostId,
            tenantId: item.transaction.tenantId,
            sourceUnit: suMap.get(item.transaction.patientId) ?? '',
            patientId: item.transaction.patientId,
            transactionId: item.transaction.id,
            sourceUpdatedAt,
          });
        }
      } catch (err) {
        metrics.factsFailed++;
        this.logger.error(
          `parser failed: tx=${item.transaction.id} action=${item.transaction.action} ` +
            `err=${err instanceof Error ? err.message : String(err)}`,
        );
      }
    }

    if (bulkEntries.length === 0) return metrics;

    // 2. 一次 bulk write,失败降级 per-entry(写一份保证收尾)
    try {
      const results = await this.writer.bulkWrite(bulkEntries);
      // 逐个 push,不用 push(...results):单资源单批已达 5 万+ 行,spread 实参压栈会炸
      // RangeError(V8 上限 ~6.5万;同型 bug 曾炸 plans 的 selectHits,见 scenario 注释)。
      for (const r of results) {
        metrics.writes.push(r);
        switch (r.action) {
          case 'created':
            metrics.factsCreated++;
            break;
          case 'superseded':
            metrics.factsSuperseded++;
            break;
          case 'unchanged':
            metrics.factsUnchanged++;
            break;
          case 'evidence_appended':
            metrics.factsEvidenceAppended++;
            break;
          case 'stale_skipped':
            metrics.factsStaleSkipped++;
            break;
        }
      }
    } catch (err) {
      this.logger.warn(
        `bulkWrite 批失败,降级 per-entry: ${err instanceof Error ? err.message : String(err)}`,
      );
      // 降级:逐条用 writeDraft(单 entry 失败不影响其他)
      for (const e of bulkEntries) {
        try {
          const r = await this.writer.writeDraft({
            draft: e.draft,
            hostId: e.hostId,
            tenantId: e.tenantId,
            sourceUnit: e.sourceUnit,
            patientId: e.patientId,
            transactionId: e.transactionId,
            sourceUpdatedAt: e.sourceUpdatedAt,
          });
          metrics.writes.push(r);
          switch (r.action) {
            case 'created':
              metrics.factsCreated++;
              break;
            case 'superseded':
              metrics.factsSuperseded++;
              break;
            case 'unchanged':
              metrics.factsUnchanged++;
              break;
            case 'evidence_appended':
              metrics.factsEvidenceAppended++;
              break;
            case 'stale_skipped':
              metrics.factsStaleSkipped++;
              break;
          }
        } catch (subErr) {
          metrics.factsFailed++;
          this.logger.error(
            `fallback writeDraft failed: tx=${e.transactionId} subject=${e.draft.subjectId} ` +
              `err=${subErr instanceof Error ? subErr.message : String(subErr)}`,
          );
        }
      }
    }

    return metrics;
  }
}

export interface BatchItem {
  transaction: {
    id: string;
    hostId: string;
    tenantId: string;
    patientId: string | null;
    action: Action;
    subjectType: string;
    subjectId: string;
    occurredAt: Date;
    clinicId: string;
  };
  canonicalRow: Record<string, unknown>;
}

export interface PipelineRunMetrics {
  action: string;
  parserMatched: boolean;
  factsCreated: number;
  factsSuperseded: number;
  factsUnchanged: number;
  factsEvidenceAppended: number;
  /// 乱序防护跳过数(更旧 sourceUpdatedAt 晚到,未旧覆新)
  factsStaleSkipped: number;
  factsFailed: number;
  writes: FactWriteResult[];
}

/// canonicalRow.updatedAt(宿主末次修改时间,string / Date)→ Date;缺失或不可解析 → null(退回到达顺序语义)。
function parseSourceUpdatedAt(canonicalRow: Record<string, unknown>): Date | null {
  const v = canonicalRow.updatedAt;
  if (v instanceof Date) return isNaN(v.getTime()) ? null : v;
  if (typeof v === 'string' && v.trim()) {
    const d = new Date(v);
    return isNaN(d.getTime()) ? null : d;
  }
  return null;
}
