Quick Start Guide

// Handle Excel file upload
handleImport(data: any[]) {
  const currentData = this.ordersService.ots;
  const importedData = data;
  let updatedData = [...currentData];

  importedData.forEach((row: any) => {
    if (!row.OT) return;
    const rowOtStr = String(row.OT).trim();
    const index = updatedData.findIndex(
      item => String(item.OT).trim() === rowOtStr
    );
    
    if (index !== -1) {
      // Update existing
      const currentStatus = updatedData[index].Estado_pedido;
      updatedData[index] = { ...updatedData[index], ...row };
      if (currentStatus) updatedData[index].Estado_pedido = currentStatus;
    } else {
      // Add new
      updatedData.push({ ...row, Estado_pedido: 'PENDIENTE' });
    }
  });
  
  this.ordersService.updateOts(updatedData);
  alert(`Importación completada. ${importedData.length} registros procesados.`);
}

// Export dashboard to Excel
exportToExcel() {
  const wb = XLSX.utils.book_new();
  const dateStr = new Date().toISOString().split('T')[0];

  // Sheet 1: KPIs
  const statsData = [
    ['REPORTE GENERAL DE PLANTA', dateStr],
    [''],
    ['METRICAS PRINCIPALES'],
    ['OEE Global', '82.4%'],
    ['OTs Activas', this.activeProduction.length],
    ['Metros Totales', '45.2k']
  ];
  const wsStats = XLSX.utils.aoa_to_sheet(statsData);
  XLSX.utils.book_append_sheet(wb, wsStats, "KPIs");

  // Sheet 2: Active Orders
  const activeOTsData = this.activeProduction.map(ot => ({
    OT: ot.OT,
    Cliente: ot['Razon Social'],
    Producto: ot.descripcion,
    Maquina: ot.maquina,
    Metros: ot.total_mtl
  }));
  const wsOTs = XLSX.utils.json_to_sheet(activeOTsData);
  XLSX.utils.book_append_sheet(wb, wsOTs, "Producción");

  XLSX.writeFile(wb, `Dashboard_Data_${dateStr}.xlsx`);
}