const STATUS_META = {
|
1: { text: '正常', type: 'success' },
|
0: { text: '冻结', type: 'info' }
|
}
|
|
export const LOC_DEAD_REPORT_TITLE = '库存停滞报表'
|
|
function normalizeText(value) {
|
return String(value ?? '').trim()
|
}
|
|
function normalizeNumber(value) {
|
if (value === '' || value === null || value === undefined) {
|
return null
|
}
|
const numericValue = Number(value)
|
return Number.isFinite(numericValue) ? numericValue : null
|
}
|
|
export function createLocDeadReportSearchState() {
|
return {
|
condition: '',
|
timeStart: '',
|
timeEnd: '',
|
locCode: '',
|
locId: '',
|
orderId: '',
|
type: '',
|
orderItemId: '',
|
wkType: '',
|
matnrId: '',
|
maktx: '',
|
matnrCode: '',
|
trackCode: '',
|
unit: '',
|
anfme: '',
|
batch: '',
|
splrBatch: '',
|
spec: '',
|
model: '',
|
fieldsIndex: '',
|
memo: '',
|
status: ''
|
}
|
}
|
|
export function getLocDeadReportPaginationKey() {
|
return {
|
current: 'current',
|
size: 'pageSize'
|
}
|
}
|
|
export function buildLocDeadReportSearchParams(params = {}) {
|
const result = {}
|
|
;[
|
'condition',
|
'locCode',
|
'type',
|
'maktx',
|
'matnrCode',
|
'trackCode',
|
'unit',
|
'batch',
|
'splrBatch',
|
'spec',
|
'model',
|
'fieldsIndex',
|
'memo'
|
].forEach((key) => {
|
const value = normalizeText(params[key])
|
if (value) {
|
result[key] = value
|
}
|
})
|
|
;['timeStart', 'timeEnd'].forEach((key) => {
|
const value = normalizeText(params[key])
|
if (value) {
|
result[key] = value
|
}
|
})
|
|
;['locId', 'orderId', 'orderItemId', 'wkType', 'matnrId', 'anfme', 'status'].forEach((key) => {
|
const value = normalizeNumber(params[key])
|
if (value !== null) {
|
result[key] = value
|
}
|
})
|
|
return result
|
}
|
|
export function buildLocDeadReportPageQueryParams(params = {}) {
|
return {
|
current: params.current || 1,
|
pageSize: params.pageSize || params.size || 20,
|
orderBy: params.orderBy || 'create_time asc',
|
...buildLocDeadReportSearchParams(params)
|
}
|
}
|
|
export function getLocDeadReportStatusMeta(value) {
|
return STATUS_META[Number(value)] || { text: '-', type: 'info' }
|
}
|
|
export function normalizeLocDeadReportRow(record = {}) {
|
const statusMeta = getLocDeadReportStatusMeta(record.status)
|
return {
|
...record,
|
id: record.id ?? '--',
|
locCode: record.locCode || '--',
|
deadTime: record.deadTime ?? record['deadTime$'] ?? '--',
|
locId: record.locId ?? '--',
|
orderId: record.orderId ?? '--',
|
typeText: record['type$'] || record.type || '--',
|
orderItemId: record.orderItemId ?? '--',
|
wkTypeText: record['wkType$'] || record.wkType || '--',
|
matnrId: record.matnrId ?? '--',
|
matnrCode: record.matnrCode || '--',
|
maktx: record.maktx || '--',
|
trackCode: record.trackCode || '--',
|
unit: record.unit || '--',
|
anfme: record.anfme ?? '--',
|
batch: record.batch || '--',
|
splrBatch: record.splrBatch || '--',
|
spec: record.spec || '--',
|
model: record.model || '--',
|
fieldsIndex: record.fieldsIndex || '--',
|
createByText: record['createBy$'] || record.createByText || '--',
|
createTimeText: record['createTime$'] || record.createTime || '--',
|
updateByText: record['updateBy$'] || record.updateByText || '--',
|
updateTimeText: record['updateTime$'] || record.updateTime || '--',
|
statusText: record['status$'] || statusMeta.text,
|
statusType: statusMeta.type,
|
memo: record.memo || '--'
|
}
|
}
|
|
export function normalizeLocDeadReportDetail(record = {}) {
|
return normalizeLocDeadReportRow(record)
|
}
|
|
export function getLocDeadReportReportColumns() {
|
return [
|
{ source: 'locCode', label: '库位编码' },
|
{ source: 'deadTime', label: '停留时间（天）', align: 'right' },
|
{ source: 'locId', label: '库位ID', align: 'right' },
|
{ source: 'orderId', label: '单据ID', align: 'right' },
|
{ source: 'typeText', label: '单据类型' },
|
{ source: 'orderItemId', label: '订单明细ID', align: 'right' },
|
{ source: 'wkTypeText', label: '业务类型' },
|
{ source: 'matnrId', label: '物料ID', align: 'right' },
|
{ source: 'matnrCode', label: '物料编码' },
|
{ source: 'maktx', label: '物料名称' },
|
{ source: 'trackCode', label: '物料跟踪码' },
|
{ source: 'unit', label: '单位' },
|
{ source: 'anfme', label: '数量', align: 'right' },
|
{ source: 'batch', label: '库存批次' },
|
{ source: 'splrBatch', label: '供应商批次' },
|
{ source: 'spec', label: '规格' },
|
{ source: 'model', label: '型号' },
|
{ source: 'fieldsIndex', label: '字段索引' },
|
{ source: 'statusText', label: '状态' },
|
{ source: 'createTimeText', label: '创建时间' },
|
{ source: 'updateTimeText', label: '更新时间' }
|
]
|
}
|
|
export function buildLocDeadReportPrintRows(records = []) {
|
return records.map((record) => {
|
const row = normalizeLocDeadReportRow(record)
|
return {
|
locCode: row.locCode,
|
deadTime: row.deadTime,
|
locId: row.locId,
|
orderId: row.orderId,
|
typeText: row.typeText,
|
orderItemId: row.orderItemId,
|
wkTypeText: row.wkTypeText,
|
matnrId: row.matnrId,
|
matnrCode: row.matnrCode,
|
maktx: row.maktx,
|
trackCode: row.trackCode,
|
unit: row.unit,
|
anfme: row.anfme,
|
batch: row.batch,
|
splrBatch: row.splrBatch,
|
spec: row.spec,
|
model: row.model,
|
fieldsIndex: row.fieldsIndex,
|
statusText: row.statusText,
|
createTimeText: row.createTimeText,
|
updateTimeText: row.updateTimeText
|
}
|
})
|
}
|
