template.js 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192
  1. const mapTemplateToTable = {
  2. '销售方公司编码': 'companyNo', // *
  3. '销售方公司名称': 'value0',
  4. '购买方公司编码': 'khNo', // *
  5. '购买方公司名称': 'value1',
  6. '供应商公司编码': 'supplierNo', // *
  7. '供应商公司名称': 'value2',
  8. '所属平台': 'platform_id',
  9. '商品分类': 'cat_id',
  10. '商品名称': 'goodName',
  11. '单位': 'goodUnit',
  12. '税率': 'tax',
  13. '数量': 'goodNum',
  14. '销售单价': 'goodPrice',
  15. '采购单价': 'cgdPrice',
  16. '采购毛利率': 'cgd_tax',
  17. '销售总额': 'good_total',
  18. '收货人': 'contactor',
  19. '联系电话': 'mobile',
  20. '收货地址': 'addr',
  21. '发货时间': 'sendtime',
  22. 'PO编号': 'poCode',
  23. '单据号': 'workCode'
  24. }
  25. export const template = Array(1).fill(1).map(() => Object.keys(mapTemplateToTable).reduce((prev, property) => {
  26. prev[property] = ''
  27. return prev
  28. }, {}))
  29. export const getTableProperty = (key) => mapTemplateToTable[key]
  30. export const columns = [
  31. {
  32. type: 'index',
  33. label: '序号',
  34. width: '70px'
  35. },
  36. {
  37. prop: getTableProperty('销售方公司编码'),
  38. label: '销售方公司编码',
  39. width: '156px'
  40. },
  41. {
  42. prop: getTableProperty('销售方公司名称'),
  43. label: '销售方公司名称',
  44. width: '156px'
  45. },
  46. {
  47. prop: getTableProperty('购买方公司编码'),
  48. label: '购买方公司编码',
  49. width: '180px'
  50. },
  51. {
  52. prop: getTableProperty('购买方公司名称'),
  53. label: '购买方公司名称',
  54. width: '180px'
  55. },
  56. {
  57. prop: getTableProperty('供应商公司编码'),
  58. label: '供应商公司编码',
  59. width: '120px'
  60. },
  61. {
  62. prop: getTableProperty('供应商公司名称'),
  63. label: '供应商公司名称',
  64. width: '120px'
  65. },
  66. {
  67. prop: getTableProperty('所属平台'),
  68. label: '所属平台',
  69. width: '110px'
  70. },
  71. {
  72. prop: getTableProperty('商品分类'),
  73. label: '商品分类',
  74. width: '150px'
  75. },
  76. {
  77. prop: getTableProperty('商品名称'),
  78. label: '商品名称',
  79. width: '150px'
  80. },
  81. {
  82. prop: getTableProperty('单位'),
  83. label: '单位',
  84. width: '150px'
  85. },
  86. {
  87. prop: getTableProperty('税率'),
  88. label: '税率',
  89. width: '150px'
  90. },
  91. {
  92. prop: getTableProperty('数量'),
  93. label: '数量',
  94. width: '140px'
  95. },
  96. {
  97. prop: getTableProperty('销售单价'),
  98. label: '销售单价',
  99. 'width': '150px'
  100. },
  101. {
  102. prop: getTableProperty('采购单价'),
  103. label: '采购单价',
  104. 'width': '150px'
  105. },
  106. {
  107. prop: getTableProperty('采购毛利率'),
  108. label: '采购毛利率',
  109. 'width': '150px'
  110. },
  111. {
  112. prop: getTableProperty('销售总额'),
  113. label: '销售总额',
  114. 'width': '150px'
  115. },
  116. {
  117. prop: getTableProperty('收货人'),
  118. label: '收货人',
  119. 'width': '150px'
  120. },
  121. {
  122. prop: getTableProperty('联系电话'),
  123. label: '联系电话',
  124. 'width': '150px'
  125. },
  126. {
  127. prop: getTableProperty('收货地址'),
  128. label: '收货地址',
  129. 'width': '150px'
  130. },
  131. {
  132. prop: getTableProperty('发货时间'),
  133. label: '发货时间',
  134. 'width': '150px'
  135. },
  136. {
  137. prop: getTableProperty('PO编号'),
  138. label: 'PO编号',
  139. 'width': '150px'
  140. },
  141. {
  142. prop: getTableProperty('单据号'),
  143. label: '单据号',
  144. 'width': '150px'
  145. }
  146. ]
  147. export function createErrorMessage(messages) {
  148. const rows = Object.keys(messages)
  149. return rows.reduce((prev, row, index) => {
  150. const suffix = index === rows.length - 1 ? '</ul>' : ''
  151. const content = prev + `
  152. <li>
  153. <strong style="font-weight:700">第${row}行</strong>,${messages[row]}
  154. </li>
  155. `
  156. return content + suffix
  157. }, '<ul>')
  158. }
  159. export const createFieldVerification = (message) => ({
  160. notValidRows: [],
  161. isValid: true,
  162. message
  163. })
  164. export const requsetFields = [
  165. getTableProperty('销售方公司编码'),
  166. getTableProperty('购买方公司编码'),
  167. getTableProperty('供应商公司编码'),
  168. getTableProperty('所属平台'),
  169. getTableProperty('商品分类'),
  170. getTableProperty('商品名称'),
  171. getTableProperty('单位'),
  172. getTableProperty('税率'),
  173. getTableProperty('数量'),
  174. getTableProperty('销售单价'),
  175. getTableProperty('采购单价'),
  176. getTableProperty('采购毛利率'),
  177. getTableProperty('收货人'),
  178. getTableProperty('联系电话'),
  179. getTableProperty('收货地址'),
  180. getTableProperty('发货时间'),
  181. getTableProperty('PO编号')
  182. ]