chartDict.js 2.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130
  1. /**
  2. * 聚合函数
  3. * @type {string[]}
  4. */
  5. export const aggregateList = ['COUNT', 'SUM', 'AVG', 'MAX', 'MIN', 'COUNT_DISTINCT']
  6. /**
  7. * 过滤条件
  8. * @type {string[]}
  9. */
  10. export const operatorList = [
  11. {
  12. label: '等于',
  13. value: '='
  14. },
  15. {
  16. label: '不等于',
  17. value: '!='
  18. },
  19. {
  20. label: '大于',
  21. value: '>'
  22. },
  23. {
  24. label: '小于',
  25. value: '<'
  26. },
  27. {
  28. label: '大于等于',
  29. value: '>='
  30. },
  31. {
  32. label: '小于等于',
  33. value: '<='
  34. },
  35. {
  36. label: '包含',
  37. value: 'IN'
  38. },
  39. {
  40. label: '不包含',
  41. value: 'NOT IN'
  42. },
  43. {
  44. label: '相似',
  45. value: 'LIKE'
  46. },
  47. {
  48. label: '为空',
  49. value: 'IS NULL'
  50. },
  51. {
  52. label: '不为空',
  53. value: 'IS NOT NULL'
  54. }
  55. ]
  56. /**
  57. * 分页条数
  58. * @type {number[]}
  59. */
  60. export const rowLimits = [10, 50, 100, 250, 500, 1000, 5000, 10000]
  61. /**
  62. * 最近类型的时间范围
  63. * @type {[{label: string, value: string}]}
  64. */
  65. export const lastTimeRangeType = [
  66. {
  67. label: '最近一天',
  68. value: 'lastDay'
  69. },
  70. {
  71. label: '最近一周',
  72. value: 'lastWeek'
  73. },
  74. {
  75. label: '最近一月',
  76. value: 'lastMonth'
  77. },
  78. {
  79. label: '最近一季度',
  80. value: 'lastQuarter'
  81. },
  82. {
  83. label: '最近一年',
  84. value: 'lastYear'
  85. }
  86. ]
  87. /**
  88. * 周期时间范围
  89. * @type {[{label: string, value: string}]}
  90. */
  91. export const previousTimeRangeType = [
  92. {
  93. label: '上一周',
  94. value: 'previousWeek'
  95. },
  96. {
  97. label: '上一月',
  98. value: 'previousMonth'
  99. },
  100. {
  101. label: '上一年',
  102. value: 'previousYear'
  103. }
  104. ]
  105. /**
  106. * 时间粒度
  107. * @type {[{label: string, value: string}]}
  108. */
  109. export const timeGrain = [
  110. {
  111. label: '原始值',
  112. value: 'original'
  113. },
  114. {
  115. label: '秒',
  116. value: 'second'
  117. },
  118. {
  119. label: '分钟',
  120. value: 'minute'
  121. },
  122. {
  123. label: '小时',
  124. value: 'hour'
  125. }, { label: '天', value: 'day' }, { label: '周', value: 'week' }, { label: '月', value: 'month' }, { label: '季度', value: 'quarter' }, { label: '年', value: 'year' }
  126. ]