import assert from 'node:assert/strict'
|
import { test } from 'node:test'
|
import XLSX from 'xlsx'
|
import { parseConsoleImport, consoleImportColumns } from '../src/utils/consoleDataImport.ts'
|
import * as importUtils from '../src/utils/consoleDataImport.ts'
|
import { formatTestDuration, parseTestDuration } from '../src/utils/testDataDuration.ts'
|
|
test('时长保留毫秒、累计小时和空值，非法时长不变成有效值', () => {
|
assert.equal(formatTestDuration(90062.125), '25:01:02.125')
|
assert.equal(parseTestDuration('25:01:02.125'), 90062.125)
|
assert.equal(formatTestDuration(0), '0:00:00.000')
|
assert.equal(formatTestDuration(null), '-')
|
assert.equal(parseTestDuration('-'), null)
|
for (const value of ['-1', '0:60:00.000', '2023-05-08 12:00:00', 'abc']) assert.ok(Number.isNaN(parseTestDuration(value)))
|
})
|
|
test('工步单页模板借同电池 record 时间，系统编号不充当来源编号', () => {
|
const workbook = importUtils.createConsoleImportWorkbook('STEP')
|
assert.deepEqual(workbook.SheetNames, ['工步', 'record'])
|
assert.deepEqual(XLSX.utils.sheet_to_json(workbook.Sheets['工步'], { header: 1 })[0], [
|
'记录编号', '电池', '循环序号', '工步序号', '工步名称', '工步时间(h:min:s.ms)', '容量(mAh)', '能量(mWh)',
|
'起始电压(V)', '终止电压(V)', '充电中值电压(V)', '放电中值电压(V)',
|
])
|
XLSX.utils.sheet_add_aoa(workbook.Sheets['工步'], [['step:999', 'BAT-1', 1, 1, '恒流放电', '1:02:32.125']], { origin: 'A2' })
|
const records = [{ batteryNo: 'BAT-1', recordedAt: '2023-05-08 11:42:11' }, { batteryNo: 'BAT-2', recordedAt: '2023-05-08 12:42:11' }]
|
XLSX.utils.sheet_add_aoa(workbook.Sheets.record, records.map(row => Object.keys(consoleImportColumns.REALTIME).map(key => ({ ...row, cycleNo: 1, stepNo: 1 })[key] ?? '')), { origin: 'A2' })
|
const imported = parseConsoleImport(workbook, 'STEP', ['BAT-1', 'BAT-2'])
|
assert.equal(imported.length, 1)
|
assert.deepEqual(imported[0].errors, [])
|
assert.equal(imported[0].data.recordNo, 'step:1:1')
|
assert.equal(imported[0].data.recordedAt, 1683517331000)
|
assert.equal(imported[0].data.stepDuration, 3752.125)
|
workbook.Sheets.record.A2 = { t: 's', v: '' }
|
workbook.Sheets.record.B2 = { t: 's', v: 'BAT-2' }
|
assert.match(parseConsoleImport(workbook, 'STEP', ['BAT-1', 'BAT-2'])[0].errors.join(), /绝对.*无效/)
|
})
|
|
test('一键模板包含三个标准 Sheet，并逐 Sheet 预览与报告缺失表', () => {
|
const workbook = importUtils.createConsoleImportWorkbook()
|
assert.deepEqual(workbook.SheetNames, ['实时', '工步', '循环'])
|
const row = { recordNo: '17', batteryNo: 'BAT-1', recordedAt: '2023-05-08 11:42:11', cycleNo: 1, stepNo: 1, stepName: '恒流放电', sequenceId: 17 }
|
for (const [index, type] of ['REALTIME', 'STEP', 'CYCLE'].entries()) {
|
const sheet = workbook.Sheets[workbook.SheetNames[index]]
|
assert.deepEqual(XLSX.utils.sheet_to_json(sheet, { header: 1 })[0], Object.values(consoleImportColumns[type]))
|
XLSX.utils.sheet_add_aoa(sheet, [Object.keys(consoleImportColumns[type]).map(key => row[key] ?? '')], { origin: 'A2' })
|
}
|
const sheets = importUtils.parseConsoleImportWorkbook(workbook, ['BAT-1'])
|
assert.deepEqual(sheets.map(sheet => [sheet.type, sheet.rows.length, sheet.errors]), [['REALTIME', 1, []], ['STEP', 1, []], ['CYCLE', 1, []]])
|
delete workbook.Sheets['循环']
|
const missing = importUtils.parseConsoleImportWorkbook(workbook, ['BAT-1'])
|
assert.match(missing[2].errors.join(), /缺少循环工作表/)
|
assert.equal(missing[0].rows.length, 1)
|
})
|
|
function partyWorkbook() {
|
const workbook = XLSX.utils.book_new()
|
XLSX.utils.book_append_sheet(workbook, XLSX.utils.aoa_to_sheet([['设备信息']]), 'Unit')
|
XLSX.utils.book_append_sheet(workbook, XLSX.utils.aoa_to_sheet([
|
['循环序号', '工步序号', '工步名称', '记录序号', '记录时间(h:min:s.ms)', '电压(V)', '电流(mA)', '容量(mAh)', '能量(mWh)', '绝对时间'],
|
[1, 1, '恒流放电', 1, '0:00:00.000', 1.3349, -8165.1, 0, 0, '2023-05-08 11:42:11'],
|
[1, 1, '恒流放电', 2, '1:02:32.000', 0.8999, -8165.1, 8512.2, 9717.8, '2023-05-08 12:44:43'],
|
]), 'record')
|
return workbook
|
}
|
|
test('实时子页选择 record 并保留身份、香港绝对时间及系统单位', () => {
|
const rows = parseConsoleImport(partyWorkbook(), 'REALTIME', ['BAT-1'], 'BAT-1')
|
assert.equal(rows.length, 2)
|
assert.deepEqual(rows[0].errors, [])
|
assert.equal(rows[0].data.recordNo, '1')
|
assert.equal(rows[0].data.sequenceId, 1)
|
assert.equal(rows[0].data.cycleNo, 1)
|
assert.equal(rows[0].data.stepNo, 1)
|
assert.equal(rows[0].data.recordedAt, 1683517331000)
|
assert.equal(rows[0].data.relativeTimeSeconds, 0)
|
assert.equal(rows[1].data.relativeTimeSeconds, 3752)
|
assert.equal(rows[0].data.deviceTimeRaw, '2023-05-08 11:42:11')
|
assert.equal(rows[0].data.current, -8.1651)
|
assert.equal(rows[1].data.capacity, 8.5122)
|
assert.equal(rows[1].data.energy, 9.7178)
|
for (const field of ['temperature', 'positivePotential', 'negativePotential']) {
|
assert.equal(rows[0].data[field], null)
|
}
|
})
|
|
test('汇总时间匹配组中存在非法绝对时间时拒绝，不选择更早有效行代替', () => {
|
const workbook = partyWorkbook()
|
XLSX.utils.book_append_sheet(workbook, XLSX.utils.aoa_to_sheet([
|
Object.values(consoleImportColumns.CYCLE), ['', 'BAT-1', 1, 0, 0, 0, 0, 0],
|
]), '循环')
|
workbook.Sheets.record.J3 = { t: 's', v: '错误时间' }
|
assert.match(parseConsoleImport(workbook, 'CYCLE', ['BAT-1'])[0].errors.join(), /绝对.*无效/)
|
})
|
|
test('采集器三项测量只读取 Excel 已有值，缺列或空格不生成数值', () => {
|
const workbook = partyWorkbook()
|
XLSX.utils.sheet_add_aoa(workbook.Sheets.record, [
|
['温度(℃)', '正电位(V)', '负电位(V)'],
|
[32.75, 1.8234, -0.2045],
|
['', '', ''],
|
], { origin: 'K1' })
|
const rows = parseConsoleImport(workbook, 'REALTIME', ['BAT-1'])
|
assert.deepEqual(rows[0].errors, [])
|
assert.deepEqual(['temperature', 'positivePotential', 'negativePotential'].map(field => rows[0].data[field]), [32.75, 1.8234, -0.2045])
|
assert.deepEqual(['temperature', 'positivePotential', 'negativePotential'].map(field => rows[1].data[field]), [null, null, null])
|
})
|
|
test('标准模板兼容文本、毫秒时间戳和 Excel 日期系统，并拒绝非法日期', () => {
|
const make = (time, date1904 = false) => {
|
const workbook = XLSX.utils.book_new()
|
workbook.Workbook = { WBProps: { date1904 } }
|
const data = { recordNo: '17', batteryNo: 'BAT-1', recordedAt: time, cycleNo: 1, stepNo: 1, stepName: '恒流放电', sequenceId: 17 }
|
XLSX.utils.book_append_sheet(workbook, XLSX.utils.aoa_to_sheet([
|
Object.values(consoleImportColumns.REALTIME), Object.keys(consoleImportColumns.REALTIME).map(field => data[field] ?? ''),
|
]), '实时模板')
|
return parseConsoleImport(workbook, 'REALTIME', ['BAT-1'])[0]
|
}
|
assert.equal(make('2023/5/8 11:42:11.123').data.recordedAt, 1683517331123)
|
assert.equal(make(1683517331123).data.recordedAt, 1683517331123)
|
assert.equal(make(45054).data.recordedAt, 1683475200000)
|
assert.equal(make(43592, true).data.recordedAt, 1683475200000)
|
assert.match(make('2023-02-30 11:00:00').errors.join(), /第2行.*设备时间.*无效/)
|
assert.match(make('1:02:32.000').errors.join(), /设备时间.*无效/)
|
})
|
|
test('多电池文件要求明确归属，保留空白行后的实际错误位置', () => {
|
assert.match(parseConsoleImport(partyWorkbook(), 'REALTIME', ['BAT-1', 'BAT-2'])[0].errors.join(), /电池.*不能为空/)
|
assert.equal(parseConsoleImport(partyWorkbook(), 'REALTIME', ['BAT-1', 'BAT-2'], 'BAT-2')[0].data.batteryNo, 'BAT-2')
|
const workbook = partyWorkbook()
|
XLSX.utils.sheet_add_aoa(workbook.Sheets.record, [[1, 1, '恒流放电', 19, '0:01:00.000', '不是数值', 0, 0, 0, '2023-05-08 11:44:11']], { origin: 'A20' })
|
const last = parseConsoleImport(workbook, 'REALTIME', ['BAT-1']).at(-1)
|
assert.equal(last.sourceRow, 20)
|
assert.match(last.errors.join(), /第20行，列「电压\(V\)」/)
|
})
|
|
test('工步和循环仅转换对应页，时间取匹配 record 的末次绝对时间', () => {
|
const workbook = partyWorkbook()
|
XLSX.utils.book_append_sheet(workbook, XLSX.utils.aoa_to_sheet([
|
['循环序号', '工步序号', '工步名称', '工步时间(h:min:s.ms)', '容量(mAh)', '能量(mWh)', '起始电压(V)', '终止电压(V)', '充电中值电压(V)', '放电中值电压(V)'],
|
[1, 1, '恒流放电', '1:02:32.000', 8512.2, 9717.8, 1.3349, 0.8999, 0, 1.1709],
|
]), 'step')
|
XLSX.utils.book_append_sheet(workbook, XLSX.utils.aoa_to_sheet([
|
['循环序号', '充电容量(mAh)', '放电容量(mAh)', '充放电效率(%)', '充电能量(mWh)', '放电能量(mWh)'],
|
[1, 0, 8512.2, 100, 0, 9717.8],
|
]), 'cycle')
|
const step = parseConsoleImport(workbook, 'STEP', ['BAT-1'])[0]
|
assert.deepEqual(step.errors, [])
|
assert.equal(step.data.recordNo, 'step:1:1')
|
assert.equal(step.data.recordedAt, 1683521083000)
|
assert.equal(step.data.stepDuration, 3752)
|
assert.equal(step.data.chargeMedianVoltage, 0)
|
assert.equal(step.data.dischargeMedianVoltage, 1.1709)
|
// 中值空格和缺列不变成零，也不回退读取同一文件的峰谷值。
|
XLSX.utils.sheet_add_aoa(workbook.Sheets.step, [['', '', '充电峰值电压(V)', '放电谷值电压(V)'], ['', '', 1.8, 0.8]], { origin: 'I1' })
|
const absent = parseConsoleImport(workbook, 'STEP', ['BAT-1'])[0]
|
assert.deepEqual(absent.errors, [])
|
assert.equal(absent.data.chargeMedianVoltage, null)
|
assert.equal(absent.data.dischargeMedianVoltage, null)
|
XLSX.utils.sheet_add_aoa(workbook.Sheets.step, [['充电中值电压(V)', '放电中值电压(V)'], ['', '不是数字']], { origin: 'I1' })
|
const invalid = parseConsoleImport(workbook, 'STEP', ['BAT-1'])[0]
|
assert.equal(invalid.data.chargeMedianVoltage, null)
|
assert.match(invalid.errors.join(), /放电中值电压.*必须是数字或空值/)
|
const cycle = parseConsoleImport(workbook, 'CYCLE', ['BAT-1'])[0]
|
assert.deepEqual(cycle.errors, [])
|
assert.equal(cycle.data.recordNo, 'cycle:1')
|
assert.equal(cycle.data.recordedAt, 1683521083000)
|
assert.equal(cycle.data.dischargeCapacity, 8.5122)
|
delete workbook.Sheets.record
|
assert.match(parseConsoleImport(workbook, 'STEP', ['BAT-1'])[0].errors.join(), /第2行.*绝对时间.*无效/)
|
})
|
