123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192 |
- const mapTemplateToTable = {
- '销售方公司编码': 'companyNo', // *
- '销售方公司名称': 'value0',
- '购买方公司编码': 'khNo', // *
- '购买方公司名称': 'value1',
- '供应商公司编码': 'supplierNo', // *
- '供应商公司名称': 'value2',
- '所属平台': 'platform_id',
- '商品分类': 'cat_id',
- '商品名称': 'goodName',
- '单位': 'goodUnit',
- '税率': 'tax',
- '数量': 'goodNum',
- '销售单价': 'goodPrice',
- '采购单价': 'cgdPrice',
- '采购毛利率': 'cgd_tax',
- '销售总额': 'good_total',
- '收货人': 'contactor',
- '联系电话': 'mobile',
- '收货地址': 'addr',
- '发货时间': 'sendtime',
- 'PO编号': 'poCode',
- '单据号': 'workCode'
- }
- export const template = Array(1).fill(1).map(() => Object.keys(mapTemplateToTable).reduce((prev, property) => {
- prev[property] = ''
- return prev
- }, {}))
- export const getTableProperty = (key) => mapTemplateToTable[key]
- export const columns = [
- {
- type: 'index',
- label: '序号',
- width: '70px'
- },
- {
- prop: getTableProperty('销售方公司编码'),
- label: '销售方公司编码',
- width: '156px'
- },
- {
- prop: getTableProperty('销售方公司名称'),
- label: '销售方公司名称',
- width: '156px'
- },
- {
- prop: getTableProperty('购买方公司编码'),
- label: '购买方公司编码',
- width: '180px'
- },
- {
- prop: getTableProperty('购买方公司名称'),
- label: '购买方公司名称',
- width: '180px'
- },
- {
- prop: getTableProperty('供应商公司编码'),
- label: '供应商公司编码',
- width: '120px'
- },
- {
- prop: getTableProperty('供应商公司名称'),
- label: '供应商公司名称',
- width: '120px'
- },
- {
- prop: getTableProperty('所属平台'),
- label: '所属平台',
- width: '110px'
- },
- {
- prop: getTableProperty('商品分类'),
- label: '商品分类',
- width: '150px'
- },
- {
- prop: getTableProperty('商品名称'),
- label: '商品名称',
- width: '150px'
- },
- {
- prop: getTableProperty('单位'),
- label: '单位',
- width: '150px'
- },
- {
- prop: getTableProperty('税率'),
- label: '税率',
- width: '150px'
- },
- {
- prop: getTableProperty('数量'),
- label: '数量',
- width: '140px'
- },
- {
- prop: getTableProperty('销售单价'),
- label: '销售单价',
- 'width': '150px'
- },
- {
- prop: getTableProperty('采购单价'),
- label: '采购单价',
- 'width': '150px'
- },
- {
- prop: getTableProperty('采购毛利率'),
- label: '采购毛利率',
- 'width': '150px'
- },
- {
- prop: getTableProperty('销售总额'),
- label: '销售总额',
- 'width': '150px'
- },
- {
- prop: getTableProperty('收货人'),
- label: '收货人',
- 'width': '150px'
- },
- {
- prop: getTableProperty('联系电话'),
- label: '联系电话',
- 'width': '150px'
- },
- {
- prop: getTableProperty('收货地址'),
- label: '收货地址',
- 'width': '150px'
- },
- {
- prop: getTableProperty('发货时间'),
- label: '发货时间',
- 'width': '150px'
- },
- {
- prop: getTableProperty('PO编号'),
- label: 'PO编号',
- 'width': '150px'
- },
- {
- prop: getTableProperty('单据号'),
- label: '单据号',
- 'width': '150px'
- }
- ]
- export function createErrorMessage(messages) {
- const rows = Object.keys(messages)
- return rows.reduce((prev, row, index) => {
- const suffix = index === rows.length - 1 ? '</ul>' : ''
- const content = prev + `
- <li>
- <strong style="font-weight:700">第${row}行</strong>,${messages[row]}
- </li>
- `
- return content + suffix
- }, '<ul>')
- }
- export const createFieldVerification = (message) => ({
- notValidRows: [],
- isValid: true,
- message
- })
- export const requsetFields = [
- getTableProperty('销售方公司编码'),
- getTableProperty('购买方公司编码'),
- getTableProperty('供应商公司编码'),
- getTableProperty('所属平台'),
- getTableProperty('商品分类'),
- getTableProperty('商品名称'),
- getTableProperty('单位'),
- getTableProperty('税率'),
- getTableProperty('数量'),
- getTableProperty('销售单价'),
- getTableProperty('采购单价'),
- getTableProperty('采购毛利率'),
- getTableProperty('收货人'),
- getTableProperty('联系电话'),
- getTableProperty('收货地址'),
- getTableProperty('发货时间'),
- getTableProperty('PO编号')
- ]
|