import { ProjectData } from '@/types/project';
import type { Project } from '../../../drizzle/schema';

/**
 * Transform database Project to frontend ProjectData format
 */
export function transformProjectToData(project: Project, index: number): ProjectData {
  return {
    no: String(index + 1),
    identity: {
      customerName: project.customerName || '-',
      customerBase: project.customerBase || '-',
      projectName: project.projectName || '-',
      productName: project.productName || '-',
      factory: project.factoryLocation || '-',
      moldSets: project.moldCount || '-',
      partNumber: project.partNumber || '-',
      cavityNumber: project.cavityNumber || '-',
      moldNumber: project.moldId || '-',
      projectManager: project.pmName || '-',
      projectEngineer: project.peName || '-',
      moldProject: project.moldLead || '-',
      qe: project.pqeName || '-',
      riskLevel: project.riskLevel || '正常',
    },
    milestones: {
      projectStart: project.kickoffDate || '-',
      t1: project.t1Date || '-',
      glTime: project.glDate || '-',
      vmp: project.vmpDate || '-',
      mp: project.mpDate || '-',
      currentStage: project.currentStage || '-',
      t1SizeQualified: project.t1DimensionOk || '-',
      trialCount: project.trialCount || '-',
      toolingFAI: project.toolingFai || '-',
      partFAI: project.partFai || '-',
      currentNode: project.currentNode || '-',
    },
    details: {
      detailSequence: String(index + 1),
      detailDate: project.updateDate || '-',
      detailProgress: project.progressDetails || '-',
    },
  };
}

/**
 * Transform frontend ProjectData to database Project format
 */
export function transformDataToProject(data: ProjectData): Record<string, string | undefined> {
  return {
    customerName: data.identity.customerName === '-' ? undefined : data.identity.customerName,
    customerBase: data.identity.customerBase === '-' ? undefined : data.identity.customerBase,
    projectName: data.identity.projectName === '-' ? undefined : data.identity.projectName,
    productName: data.identity.productName === '-' ? undefined : data.identity.productName,
    factoryLocation: data.identity.factory === '-' ? undefined : data.identity.factory,
    moldCount: data.identity.moldSets === '-' ? undefined : data.identity.moldSets,
    partNumber: data.identity.partNumber === '-' ? undefined : data.identity.partNumber,
    cavityNumber: data.identity.cavityNumber === '-' ? undefined : data.identity.cavityNumber,
    moldId: data.identity.moldNumber === '-' ? undefined : data.identity.moldNumber,
    pmName: data.identity.projectManager === '-' ? undefined : data.identity.projectManager,
    peName: data.identity.projectEngineer === '-' ? undefined : data.identity.projectEngineer,
    moldLead: data.identity.moldProject === '-' ? undefined : data.identity.moldProject,
    pqeName: data.identity.qe === '-' ? undefined : data.identity.qe,
    riskLevel: data.identity.riskLevel === '-' ? undefined : data.identity.riskLevel,
    kickoffDate: data.milestones.projectStart === '-' ? undefined : data.milestones.projectStart,
    t1Date: data.milestones.t1 === '-' ? undefined : data.milestones.t1,
    glDate: data.milestones.glTime === '-' ? undefined : data.milestones.glTime,
    vmpDate: data.milestones.vmp === '-' ? undefined : data.milestones.vmp,
    mpDate: data.milestones.mp === '-' ? undefined : data.milestones.mp,
    currentStage: data.milestones.currentStage === '-' ? undefined : data.milestones.currentStage,
    t1DimensionOk: data.milestones.t1SizeQualified === '-' ? undefined : data.milestones.t1SizeQualified,
    trialCount: data.milestones.trialCount === '-' ? undefined : data.milestones.trialCount,
    toolingFai: data.milestones.toolingFAI === '-' ? undefined : data.milestones.toolingFAI,
    partFai: data.milestones.partFAI === '-' ? undefined : data.milestones.partFAI,
    currentNode: data.milestones.currentNode === '-' ? undefined : data.milestones.currentNode,
    progressDetails: data.details.detailProgress === '-' ? undefined : data.details.detailProgress,
    updateDate: data.details.detailDate === '-' ? undefined : data.details.detailDate,
  };
}