// src/server/features/reference_books/lib/contractors.mapper.ts
// Mapper functions for transforming database rows to DTOs

import type { ContractorEntryWithMetadata, ContractorPendingEntry } from '../contractors.schema';
import type { contractorsPending, contractors } from '../db/contractors.table';
import type { employees } from '../../personnel/db/employees.table';

/**
 * Map database row to ContractorEntryWithMetadata
 */
export function mapToContractorEntry(row: typeof contractors.$inferSelect): ContractorEntryWithMetadata {
  return {
    id: row.id,
    name: row.name,
    category: row.category,
    contractNumber: row.contractNumber,
    phone: row.phone,
    email: row.email,
    webLink: row.webLink,
    managerName: row.managerName,
    managerPhone: row.managerPhone,
    managerEmail: row.managerEmail,
    comment: row.comment,
    isApproved: row.isApproved,
    status: row.isApproved ? 'approved' : 'pending',
    targetId: null,
    createdBy: null,
    creatorName: null,
    reviewedBy: null,
    reviewedAt: null,
    rejectionReason: null,
    createdAt: row.createdAt.toISOString(),
    updatedAt: row.updatedAt.toISOString(),
    archivedAt: row.archivedAt?.toISOString() || null,
  };
}

/**
 * Map database row to ContractorPendingEntry
 */
export function mapToContractorPendingEntry(row: typeof contractorsPending.$inferSelect & { creatorName?: string | null }): ContractorPendingEntry {
  return {
    id: row.id,
    name: row.name,
    category: row.category,
    contractNumber: row.contractNumber,
    phone: row.phone,
    email: row.email,
    webLink: row.webLink,
    managerName: row.managerName,
    managerPhone: row.managerPhone,
    managerEmail: row.managerEmail,
    comment: row.comment,
    status: row.status as 'pending' | 'approved' | 'rejected' | 'to_delete',
    targetId: row.targetId,
    createdBy: row.createdBy,
    creatorName: row.creatorName || null,
    reviewedBy: row.reviewedBy,
    reviewedAt: row.reviewedAt?.toISOString() || null,
    rejectionReason: row.rejectionReason,
    createdAt: row.createdAt.toISOString(),
    updatedAt: row.updatedAt.toISOString(),
  };
}

/**
 * Map pending entry with metadata (includes creatorName from join)
 */
export function mapPendingToContractorEntryWithMetadata(row: typeof contractorsPending.$inferSelect & { creatorName?: string | null }): ContractorEntryWithMetadata {
  return {
    id: row.id,
    name: row.name,
    category: row.category,
    contractNumber: row.contractNumber,
    phone: row.phone,
    email: row.email,
    webLink: row.webLink,
    managerName: row.managerName,
    managerPhone: row.managerPhone,
    managerEmail: row.managerEmail,
    comment: row.comment,
    isApproved: false, // Pending entries are not approved
    status: row.status as 'pending' | 'approved' | 'rejected' | 'to_delete',
    targetId: row.targetId,
    createdBy: row.createdBy,
    creatorName: row.creatorName || null,
    reviewedBy: row.reviewedBy,
    reviewedAt: row.reviewedAt?.toISOString() || null,
    rejectionReason: row.rejectionReason,
    createdAt: row.createdAt.toISOString(),
    updatedAt: row.updatedAt.toISOString(),
    archivedAt: null, // Pending entries don't have archivedAt
  };
}