TableUtils.js 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268
  1. /**
  2. * 同步列表,可以同步新增、修改、删除
  3. * @author sunjianlei
  4. * */
  5. export function syncAllTable(vm, table1) {
  6. vm.$refs.editableTable.resetScrollTop()
  7. let deleteIds = table1.$refs.editableTable.getDeleteIds()
  8. let table1Value
  9. table1.$refs.editableTable.getValuesPromise(false).then((values) => {
  10. table1Value = values
  11. return vm.$refs.editableTable.getValuesPromise(false)
  12. }).then((values) => {
  13. table1Value.forEach(value => {
  14. let flag = false
  15. values.forEach((thisValue) => {
  16. if (value.id === thisValue.id) {
  17. // 判断是否修改了值
  18. let dbFieldName = thisValue['dbFieldName']
  19. let dbFieldTxt = thisValue['dbFieldTxt']
  20. // return
  21. if (value.dbFieldName !== dbFieldName
  22. || value.dbFieldTxt !== dbFieldTxt) {
  23. // 修改了
  24. vm.$refs.editableTable.setValues([{
  25. rowKey: thisValue.id,
  26. values: {
  27. dbFieldName: value.dbFieldName,
  28. dbFieldTxt: value.dbFieldTxt
  29. }
  30. }])
  31. }
  32. flag = true
  33. } else {
  34. // id不匹配则有可能是新增也有可能是删除了的
  35. // 遍历传进来的 deleteIds 进行对比
  36. deleteIds.forEach(delId => {
  37. // 对比成功,则删除该条数据
  38. if (delId === thisValue.id) {
  39. vm.$refs.editableTable.removeRows(vm.$refs.editableTable.caseId + delId)
  40. flag = true
  41. }
  42. })
  43. }
  44. })
  45. // return
  46. // 判断是否操作了该条数据,若没有操作则代表要执行新增操作
  47. if (!flag) {
  48. let record = Object.assign({}, value)
  49. vm.columns.forEach(column => {
  50. if (
  51. column.dataIndex !== 'dbFieldName' &&
  52. column.dataIndex !== 'dbFieldTxt'
  53. ) {
  54. record[column.dataIndex] = column.defaultValue
  55. }
  56. })
  57. vm.$refs.editableTable.push(record)
  58. }
  59. })
  60. })
  61. }
  62. /**
  63. * 将数据分类并Set进dataSource
  64. * @author sunjianlei
  65. **/
  66. export function setDataSource(vm, queryData) {
  67. let dataSource = []
  68. // 遍历查询出来的数据
  69. queryData.forEach(value => {
  70. let data = { id: value['id'] }
  71. vm.columns.forEach(column => {
  72. let key = column.key
  73. if (key) {
  74. data[key] = value[key]
  75. // 由于多选下拉框返回的是一个数组,所以需要改成 [1,2,3] 数组的形式,否则组件不识别
  76. // if (key === 'indexField') {
  77. // data[key] = value[key].split(',')
  78. // }
  79. }
  80. })
  81. dataSource.push(data)
  82. })
  83. vm.dataSource = dataSource
  84. }
  85. /** 获取主表的初始化数据 */
  86. export function getMasterTableInitialData() {
  87. return [
  88. {
  89. dbFieldName: 'id',
  90. dbFieldTxt: '主键',
  91. dbLength: 36,
  92. dbPointLength: 0,
  93. dbDefaultVal: '',
  94. dbType: 'string',
  95. dbIsKey: '1',
  96. dbIsNull: '0',
  97. // table2
  98. isShowForm: '0',
  99. isShowList: '0',
  100. fieldShowType: 'text',
  101. fieldLength: '120',
  102. queryMode: 'single',
  103. orderNum: 1
  104. },
  105. {
  106. dbFieldName: 'create_by',
  107. dbFieldTxt: '创建人',
  108. dbLength: 50,
  109. dbPointLength: 0,
  110. dbDefaultVal: '',
  111. dbType: 'string',
  112. dbIsKey: '0',
  113. dbIsNull: '1',
  114. // table2
  115. isShowForm: '0',
  116. isShowList: '0',
  117. fieldShowType: 'text',
  118. fieldLength: '120',
  119. queryMode: 'single',
  120. orderNum: 2
  121. },
  122. {
  123. dbFieldName: 'create_time',
  124. dbFieldTxt: '创建日期',
  125. dbLength: 20,
  126. dbPointLength: 0,
  127. dbDefaultVal: '',
  128. dbType: 'Date',
  129. dbIsKey: '0',
  130. dbIsNull: '1',
  131. // table2
  132. isShowForm: '0',
  133. isShowList: '0',
  134. fieldShowType: 'datetime',
  135. fieldLength: '120',
  136. queryMode: 'single',
  137. orderNum: 3
  138. },
  139. {
  140. dbFieldName: 'update_by',
  141. dbFieldTxt: '更新人',
  142. dbLength: 50,
  143. dbPointLength: 0,
  144. dbDefaultVal: '',
  145. dbType: 'string',
  146. dbIsKey: '0',
  147. dbIsNull: '1',
  148. // table2
  149. isShowForm: '0',
  150. isShowList: '0',
  151. fieldShowType: 'text',
  152. fieldLength: '120',
  153. queryMode: 'single',
  154. orderNum: 4
  155. },
  156. {
  157. dbFieldName: 'update_time',
  158. dbFieldTxt: '更新日期',
  159. dbLength: 20,
  160. dbPointLength: 0,
  161. dbDefaultVal: '',
  162. dbType: 'Date',
  163. dbIsKey: '0',
  164. dbIsNull: '1',
  165. // table2
  166. isShowForm: '0',
  167. isShowList: '0',
  168. fieldShowType: 'datetime',
  169. fieldLength: '120',
  170. queryMode: 'single',
  171. orderNum: 5
  172. },{
  173. dbFieldName: 'sys_org_code',
  174. dbFieldTxt: '所属部门',
  175. dbLength: 64,
  176. dbPointLength: 0,
  177. dbDefaultVal: '',
  178. dbType: 'string',
  179. dbIsKey: '0',
  180. dbIsNull: '1',
  181. // table2
  182. isShowForm: '0',
  183. isShowList: '0',
  184. fieldShowType: 'text',
  185. fieldLength: '120',
  186. queryMode: 'single',
  187. orderNum: 6
  188. }
  189. // {
  190. // dbFieldName: 'sys_org_code',
  191. // dbFieldTxt: '所属部门',
  192. // dbLength: 50,
  193. // dbPointLength: 0,
  194. // dbDefaultVal: '',
  195. // dbType: 'string',
  196. // dbIsKey: false,
  197. // dbIsNull: true
  198. // }, {
  199. // dbFieldName: 'sys_company_code',
  200. // dbFieldTxt: '所属公司',
  201. // dbLength: 50,
  202. // dbPointLength: 0,
  203. // dbDefaultVal: '',
  204. // dbType: 'string',
  205. // dbIsKey: false,
  206. // dbIsNull: true
  207. // }, {
  208. // dbFieldName: 'bpm_status',
  209. // dbFieldTxt: '流程状态',
  210. // dbLength: 32,
  211. // dbPointLength: 0,
  212. // dbDefaultVal: '',
  213. // dbType: 'string',
  214. // dbIsKey: false,
  215. // dbIsNull: true
  216. // }
  217. ]
  218. }
  219. /** 获取树的初始化数据 */
  220. export function getTreeNeedFields() {
  221. return [{
  222. dbFieldName: 'pid',
  223. dbFieldTxt: '父级节点',
  224. dbLength: 32,
  225. dbPointLength: 0,
  226. dbDefaultVal: '',
  227. dbType: 'string',
  228. dbIsKey: '0',
  229. dbIsNull: '1',
  230. // table2
  231. isShowForm: '1',
  232. isShowList: '0',
  233. fieldShowType: 'text',
  234. fieldLength: '120',
  235. queryMode: 'single',
  236. orderNum: 7
  237. },{
  238. dbFieldName: 'has_child',
  239. dbFieldTxt: '是否有子节点',
  240. dbLength: 3,
  241. dbPointLength: 0,
  242. dbDefaultVal: '',
  243. dbType: 'string',
  244. dbIsKey: '0',
  245. dbIsNull: '1',
  246. // table2
  247. isShowForm: '0',
  248. isShowList: '0',
  249. fieldShowType: 'list',
  250. fieldLength: '120',
  251. queryMode: 'single',
  252. orderNum: 8,
  253. // table3
  254. dictField:"yn"
  255. }]
  256. }