SFT/mock-server/db/seedOrder.js

111 lines
3.7 KiB
JavaScript

// 订单管理模块种子数据:汇总订单4条(每商户2条,覆盖 REGISTERED/SETTLED 与三种清算状态)+
// 原始订单14条(按 summaryOrderId 关联,每条汇总订单下3-4条)。字段严格对齐 SummaryOrderVo/
// OriginalOrderVo 及前端 SummaryOrderList.vue/OriginalOrderList.vue 实际使用字段。
import { initCounter } from '../utils/id.js'
export const summaryOrders = [
{
id: 1,
orderNo: 'SO20260601001',
merchantNo: 'MC0001',
orderDate: '2026-06-01 00:00:00',
totalAmount: '500000.00',
shippedUncollectedAmount: '120000.00',
estimatedReturnAmount: '15000.00',
estimatedReceivableAmount: '485000.00',
actualReturnAmount: '10000.00',
financeQuota: '400000.00',
accumulatedLoanAmount: '150000.00',
accumulatedSupplementAmount: '5000.00',
orderStatus: 'REGISTERED',
settlementStatus: 'UNSCHEDULED',
remark: '6月第一批汇总订单',
createdAt: '2026-06-01 10:00:00'
},
{
id: 2,
orderNo: 'SO20260601002',
merchantNo: 'MC0001',
orderDate: '2026-05-01 00:00:00',
totalAmount: '320000.00',
shippedUncollectedAmount: '0.00',
estimatedReturnAmount: '8000.00',
estimatedReceivableAmount: '312000.00',
actualReturnAmount: '8000.00',
financeQuota: '250000.00',
accumulatedLoanAmount: '250000.00',
accumulatedSupplementAmount: '0.00',
orderStatus: 'SETTLED',
settlementStatus: 'SETTLED_REPAID',
remark: '5月汇总订单已完结',
createdAt: '2026-05-01 10:00:00'
},
{
id: 3,
orderNo: 'SO20260602001',
merchantNo: 'MC0002',
orderDate: '2026-06-05 00:00:00',
totalAmount: '280000.00',
shippedUncollectedAmount: '60000.00',
estimatedReturnAmount: '5000.00',
estimatedReceivableAmount: '275000.00',
actualReturnAmount: '0.00',
financeQuota: '200000.00',
accumulatedLoanAmount: '60000.00',
accumulatedSupplementAmount: '0.00',
orderStatus: 'REGISTERED',
settlementStatus: 'UNSCHEDULED',
remark: '',
createdAt: '2026-06-05 09:30:00'
},
{
id: 4,
orderNo: 'SO20260602002',
merchantNo: 'MC0002',
orderDate: '2026-05-10 00:00:00',
totalAmount: '150000.00',
shippedUncollectedAmount: '0.00',
estimatedReturnAmount: '3000.00',
estimatedReceivableAmount: '147000.00',
actualReturnAmount: '3000.00',
financeQuota: '100000.00',
accumulatedLoanAmount: '95000.00',
accumulatedSupplementAmount: '2000.00',
orderStatus: 'SETTLED',
settlementStatus: 'FAILED',
remark: '清算失败,待人工核对',
createdAt: '2026-05-10 09:00:00'
}
]
initCounter('summaryOrder', 5)
function buildOriginalOrders(summaryOrderId, merchantId, orderNoPrefix, count, baseDate) {
const list = []
for (let i = 1; i <= count; i += 1) {
list.push({
summaryOrderId,
merchantId,
originalOrderNo: `${orderNoPrefix}${String(i).padStart(4, '0')}`,
orderType: 'ORIGINAL',
orderDate: baseDate,
productName: `商品${i}`,
productQuantity: 10 * i,
unitPrice: (100 + i * 10).toFixed(2),
totalAmount: (10 * i * (100 + i * 10)).toFixed(2),
buyerName: `买家${i}`,
sellerName: '上海凡荣贸易有限公司旗舰店',
orderStatus: i % 4 === 0 ? 'RETURNED' : 'COMPLETED',
remark: ''
})
}
return list
}
export const originalOrders = [
...buildOriginalOrders(1, 1, 'OO202606010', 4, '2026-06-01 00:00:00'),
...buildOriginalOrders(2, 1, 'OO202605010', 3, '2026-05-01 00:00:00'),
...buildOriginalOrders(3, 2, 'OO202606020', 4, '2026-06-05 00:00:00'),
...buildOriginalOrders(4, 2, 'OO202605100', 3, '2026-05-10 00:00:00')
].map((item, index) => ({ id: index + 1, ...item }))
initCounter('originalOrder', originalOrders.length + 1)