publicFunc.js 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
  1. import { Query, newData, modifyData, moveData } from "@/api/webApi"
  2. export default {
  3. methods: {
  4. formatQuery (arrs, key = '') {
  5. const params = []
  6. if (key) {
  7. const flag = Array.isArray(arrs)
  8. if (flag) {
  9. for (let i = 0; i < arrs.length; i++) {
  10. const obj = {
  11. "left": "(",
  12. "column": `${key[i]}`,
  13. "comparator": "=",
  14. "value": `${arrs[i][key[i]]}`,
  15. "right": ")",
  16. "connector": "and"
  17. }
  18. params.push(obj)
  19. }
  20. } else {
  21. params.push({
  22. "left": "(",
  23. "column": `${key}`,
  24. "comparator": "=",
  25. "value": `${arrs[key]}`,
  26. "right": ")",
  27. "connector": "and"
  28. })
  29. }
  30. } else {
  31. params.push({
  32. "left": "(",
  33. "column": ``,
  34. "comparator": "=",
  35. "value": ``,
  36. "right": ")",
  37. "connector": "and"
  38. })
  39. }
  40. return params
  41. },
  42. formatChange (data, event, key) {
  43. const datas = []
  44. const flag = Array.isArray(data)
  45. if (flag) {
  46. for (let i = 0; i < data.length; i++) {
  47. const obj = {}
  48. if (event == 1) {
  49. obj.Value = data[i]
  50. } else if (event == 2) {
  51. obj.Value = data[i]
  52. obj.filter = {}
  53. if (Array.isArray(key)) {
  54. const keys = Object.keys(key[i])
  55. obj.filter = key[i]
  56. for (let j = 0; j < keys.length; j++) {
  57. if (obj.Value.hasOwnProperty(keys[j])) {
  58. delete obj.Value[keys[j]]
  59. }
  60. }
  61. } else {
  62. obj.filter[key] = data[i][key]
  63. if (obj.Value[key]) {
  64. delete obj.Value[key]
  65. }
  66. }
  67. } else {
  68. obj.filter = data[i]
  69. }
  70. datas.push(obj)
  71. }
  72. } else {
  73. const obj = {}
  74. if (event == 1) {
  75. obj.Value = data
  76. } else if (event == 2) {
  77. obj.Value = data
  78. obj.filter = {}
  79. obj.filter[key] = data[key]
  80. if (obj.Value[key]) {
  81. delete obj.Value[key]
  82. }
  83. } else {
  84. obj.filter = data
  85. }
  86. datas.push(obj)
  87. }
  88. return datas
  89. },
  90. //查询
  91. async getQueryList (id, dataContent = {}, key, pageSize) {
  92. try {
  93. const { code, columnset, returnData } = await Query({
  94. serviceId: id,
  95. page: this.pageIndex,
  96. pageSize: pageSize ?? this.pageSize,
  97. dataContent: this.formatQuery(dataContent, key),
  98. event: '0'
  99. })
  100. if (code == 0) {
  101. return returnData
  102. } else {
  103. return []
  104. }
  105. } catch (error) {
  106. return []
  107. }
  108. },
  109. //增/删/改
  110. async getChangeList (id, data, event, key) {
  111. try {
  112. const params = {
  113. serviceId: id,
  114. dataContent: this.formatChange(data, event, key),
  115. event: `${event}`,
  116. };
  117. const { code } =
  118. event == 1
  119. ? await newData(params)
  120. : event == 2
  121. ? await modifyData(params)
  122. : await moveData(params);
  123. if (code == 0) {
  124. return 1
  125. } else {
  126. return 0
  127. }
  128. } catch (error) {
  129. console.log(error)
  130. return 0
  131. }
  132. },
  133. tipMsg (code, msg) {
  134. if (code) {
  135. this.$message.success(msg ?? '操作成功')
  136. } else {
  137. this.$message.error(msg ?? '操作失败')
  138. }
  139. }
  140. }
  141. }