import type { StabilityAnalysisRow } from '#/api/x/lims/wendingxing';
import { formatDisplayNumber, formatPeriodUnit } from './stabilityAnalysis';
const MIME_TYPE = 'application/vnd.ms-excel;charset=utf-8' as const;
const HEADER_CELL_STYLE =
'border:1px solid rgb(0, 0, 0);background-color:rgb(38, 183, 255);color:rgb(255, 255, 255);font-weight:700;text-align:center;vertical-align:middle;white-space:nowrap;';
interface ExportColumn {
className?: string;
title: string;
value: (row: StabilityAnalysisRow, index: number) => string;
width: number;
}
export interface StabilityExportFile {
fileName: string;
html: string;
mimeType: typeof MIME_TYPE;
}
const columns: ExportColumn[] = [
{ title: '序号', value: (_row, index) => String(index), width: 8 },
{ className: 'text', title: '品名', value: (row) => row.yangpin_mingcheng, width: 18 },
{ className: 'text', title: '稳定性考察编号', value: (row) => row.jihua_bianhao, width: 28 },
{ className: 'text', title: '批号', value: (row) => row.pihao, width: 20 },
{ className: 'date', title: '录入日期', value: (row) => formatDate(row.jieguo_luru_riqi), width: 15 },
{ title: '考察周期', value: (row) => formatPeriod(row.zhouqi), width: 12 },
{ className: 'text', title: '周期单位', value: (row) => formatExportPeriodUnit(row.zhouqi, row.zhouqi_danwei), width: 12 },
{ className: 'text', title: '项目名称', value: (row) => row.xiangmu_mingcheng, width: 20 },
{ className: 'text', title: '数据', value: (row) => row.raw_result, width: 14 },
{ className: 'text', title: '上限', value: (row) => row.shangxian, width: 12 },
{ className: 'text', title: '下限', value: (row) => row.xiaxian, width: 12 },
{ className: 'text', title: '单位', value: (row) => row.unit, width: 12 },
];
export function buildStabilityExport(rows: StabilityAnalysisRow[], now = new Date()): StabilityExportFile {
const columnMarkup = columns.map((column) => ``).join('');
const headerMarkup = columns.map((column) => `| ${escapeHtml(column.title)} | `).join('');
const bodyMarkup = rows
.map(
(row, index) =>
`${columns
.map((column) => `${escapeHtml(column.value(row, index) || '')}`)
.join('')}
`,
)
.join('');
return {
fileName: `稳定性数据分析表_${formatTimestamp(now)}.xls`,
html: `
${columnMarkup}${headerMarkup}
${bodyMarkup}
`,
mimeType: MIME_TYPE,
};
}
export function downloadStabilityExport(rows: StabilityAnalysisRow[], now = new Date()) {
const file = buildStabilityExport(rows, now);
const url = URL.createObjectURL(new Blob([`\uFEFF${file.html}`], { type: file.mimeType }));
const anchor = document.createElement('a');
anchor.download = file.fileName;
anchor.href = url;
anchor.style.display = 'none';
document.body.append(anchor);
try {
anchor.click();
} finally {
anchor.remove();
URL.revokeObjectURL(url);
}
}
function escapeHtml(value: string) {
return String(value ?? '')
.replaceAll('&', '&')
.replaceAll('<', '<')
.replaceAll('>', '>')
.replaceAll('"', '"')
.replaceAll("'", ''');
}
function formatDate(value: string) {
return String(value ?? '').match(/\d{4}-\d{2}-\d{2}/)?.[0] || String(value ?? '');
}
function formatExportPeriodUnit(period: string, unit: string) {
return Number(period) === 0 ? '/' : formatPeriodUnit(unit);
}
function formatPeriod(value: string) {
const normalized = String(value ?? '').trim();
return normalized ? formatDisplayNumber(normalized) : '';
}
function formatTimestamp(value: Date) {
return [value.getFullYear(), pad(value.getMonth() + 1), pad(value.getDate()), pad(value.getHours()), pad(value.getMinutes()), pad(value.getSeconds())].join(
'',
);
}
function pad(value: number) {
return String(value).padStart(2, '0');
}