waterFacilityStatisticsModel.js 9.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256
  1. export const FACILITY_STATUS_LABELS = {
  2. source: { '0': '正常', '1': '异常' },
  3. plant: { '0': '正常', '1': '停产' },
  4. pumpStation: { '0': '正常', '1': '故障停运', '2': '检修中' },
  5. // 管网状态与其他设施统一:0-正常 / 1-异常
  6. pipe: { '0': '正常', '1': '异常' },
  7. user: { '0': '正常', '1': '欠费', '2': '停用' }
  8. }
  9. export const FACILITY_TYPE_LABELS = {
  10. source: '水源地',
  11. plant: '水厂',
  12. pumpStation: '泵站',
  13. pipe: '管网',
  14. user: '用水户'
  15. }
  16. export const FACILITY_SECTION_TYPES = {
  17. pipeNetwork: 'pipe',
  18. waterPlant: 'plant',
  19. waterSource: 'source',
  20. waterUser: 'user',
  21. pumpStation: 'pumpStation'
  22. }
  23. export const FACILITY_SECTION_LABELS = {
  24. pipeNetwork: FACILITY_TYPE_LABELS.pipe,
  25. waterPlant: FACILITY_TYPE_LABELS.plant,
  26. waterSource: FACILITY_TYPE_LABELS.source,
  27. waterUser: FACILITY_TYPE_LABELS.user,
  28. pumpStation: FACILITY_TYPE_LABELS.pumpStation
  29. }
  30. export const FACILITY_STATUS_TAG_TYPES = {
  31. source: { '0': 'success', '1': 'danger' },
  32. plant: { '0': 'success', '1': 'danger' },
  33. pumpStation: { '0': 'success', '1': 'danger', '2': 'warning' },
  34. pipe: { '0': 'success', '1': 'danger' },
  35. user: { '0': 'success', '1': 'warning', '2': 'danger' }
  36. }
  37. const unknownStatus = { label: '未知', tagType: 'info' }
  38. const FACILITY_TYPE_ORDER = ['source', 'plant', 'pumpStation', 'pipe', 'user']
  39. // 后端统计汇总接口以 Map 返回明细,键名是 SQL 别名(total_count / design_capacity ...)。
  40. // 这里以驼峰键为唯一口径,同时在查询前把下划线键归一化,避免英文原键漏到统计明细表格。
  41. export const STATISTIC_METRIC_LABELS = {
  42. totalCount: '总数',
  43. totalLength: '总长度',
  44. averageDiameter: '平均管径',
  45. designCapacity: '设计规模',
  46. currentCapacity: '实际规模',
  47. capacityUtilization: '产能利用率',
  48. pumpCount: '水泵数量',
  49. designFlow: '设计流量',
  50. designHead: '设计扬程',
  51. powerCapacity: '装机容量',
  52. annualWaterConsumption: '年用水量',
  53. materialDistribution: '管材分布',
  54. diameterDistribution: '管径分布',
  55. layingYearDistribution: '建设年代分布',
  56. levelDistribution: '等级分布',
  57. statusDistribution: '状态分布',
  58. waterSourceTypeDistribution: '水源类型分布',
  59. sourceTypeDistribution: '水源地类型分布',
  60. qualityDistribution: '水质等级分布',
  61. protectionDistribution: '保护等级分布',
  62. userTypeDistribution: '用水户类型分布',
  63. consumptionDistribution: '用水量分布'
  64. }
  65. export const STATISTIC_METRIC_DESCRIPTIONS = {
  66. totalCount: '当前筛选条件下的设施总数',
  67. totalLength: '当前筛选条件下的管网总长度',
  68. averageDiameter: '当前筛选条件下的管径平均值',
  69. designCapacity: '水厂设计供水能力',
  70. currentCapacity: '水厂实际供水能力',
  71. capacityUtilization: '实际供水能力与设计供水能力的比值',
  72. pumpCount: '泵站内水泵总数量',
  73. designFlow: '泵站设计流量',
  74. designHead: '泵站设计扬程',
  75. powerCapacity: '泵站装机总容量',
  76. annualWaterConsumption: '用水户年度用水量',
  77. materialDistribution: '按管材统计管网数量',
  78. diameterDistribution: '按管径区间统计管网数量',
  79. layingYearDistribution: '按建设年代统计管网数量',
  80. levelDistribution: '按等级统计管网数量',
  81. statusDistribution: '按业务状态统计设施数量',
  82. waterSourceTypeDistribution: '按水源类型统计水厂数量',
  83. sourceTypeDistribution: '按水源地类型统计数量',
  84. qualityDistribution: '按水质等级统计水源地数量',
  85. protectionDistribution: '按保护等级统计水源地数量',
  86. userTypeDistribution: '按用水户类型统计数量',
  87. consumptionDistribution: '按用水量区间统计用水户数量'
  88. }
  89. // 分布类统计的原始码值翻译;未登记的纯英文码值不直接展示,统一归入「其他」。
  90. export const DISTRIBUTION_VALUE_LABELS = {
  91. materialDistribution: {
  92. PE: '聚乙烯',
  93. HDPE: '高密度聚乙烯',
  94. PVC: '聚氯乙烯',
  95. 'PVC-U': '硬聚氯乙烯',
  96. PVCU: '硬聚氯乙烯',
  97. PP: '聚丙烯',
  98. PPR: '无规共聚聚丙烯',
  99. 'PE-X': '交联聚乙烯',
  100. PEX: '交联聚乙烯',
  101. ABS: '工程塑料',
  102. FRP: '玻璃钢管',
  103. GRP: '玻璃钢管'
  104. }
  105. }
  106. const UNKNOWN_GROUP_LABEL = '未填报'
  107. const UNKNOWN_METRIC_LABEL = '其他指标'
  108. const UNKNOWN_METRIC_DESCRIPTION = '按当前筛选条件统计'
  109. const UNKNOWN_SECTION_LABEL = '总览'
  110. const UNKNOWN_MATERIAL_LABEL = '其他管材'
  111. const STATISTIC_METRIC_UNIT = '项'
  112. // 码值识别:以字母开头的纯 ASCII 串视为编码(如 PE / PVC-U / HDPE);
  113. // 数字区间与含中文的值(100-299mm、Ⅳ类)保持原样展示。
  114. const ASCII_CODE_PATTERN = /^[A-Za-z][A-Za-z0-9._/-]*$/
  115. export function normalizeStatisticKey(key) {
  116. return String(key ?? '')
  117. .trim()
  118. .replace(/_([A-Za-z0-9])/g, (match, char) => char.toUpperCase())
  119. }
  120. export function resolveStatisticMetricLabel(key) {
  121. return STATISTIC_METRIC_LABELS[normalizeStatisticKey(key)] || UNKNOWN_METRIC_LABEL
  122. }
  123. export function resolveStatisticMetricDescription(key) {
  124. return STATISTIC_METRIC_DESCRIPTIONS[normalizeStatisticKey(key)] || UNKNOWN_METRIC_DESCRIPTION
  125. }
  126. export function resolveFacilitySectionLabel(key) {
  127. return FACILITY_SECTION_LABELS[key] || UNKNOWN_SECTION_LABEL
  128. }
  129. export function resolveDistributionValueLabel(metricKey, rawName) {
  130. const value = rawName === null || rawName === undefined ? '' : String(rawName).trim()
  131. if (!value) return UNKNOWN_GROUP_LABEL
  132. const labels = DISTRIBUTION_VALUE_LABELS[metricKey]
  133. if (labels && labels[value]) return labels[value]
  134. if (ASCII_CODE_PATTERN.test(value)) return labels ? UNKNOWN_MATERIAL_LABEL : UNKNOWN_GROUP_LABEL
  135. return value
  136. }
  137. export const STATISTIC_ROW_KIND = {
  138. METRIC: 'metric',
  139. DISTRIBUTION: 'distribution'
  140. }
  141. // 把后端 dashboard 的嵌套结构摊平成统计明细行。
  142. // 数组 => 分布分组(kind=distribution);标量 => 指标值(kind=metric),
  143. // 这样嵌套对象的 value/unit 这类结构键不会作为分组名进入表格。
  144. export function flattenStatisticMetrics(section, value) {
  145. if (Array.isArray(value)) {
  146. return value.map(item => ({ ...item, section, kind: STATISTIC_ROW_KIND.DISTRIBUTION }))
  147. }
  148. if (!value || typeof value !== 'object') {
  149. return [{ name: section, value, unit: STATISTIC_METRIC_UNIT, section: '', kind: STATISTIC_ROW_KIND.METRIC }]
  150. }
  151. return Object.entries(value).flatMap(([name, metric]) => {
  152. if (Array.isArray(metric)) {
  153. return metric.map(item => ({
  154. ...item,
  155. section: `${section}/${name}`,
  156. kind: STATISTIC_ROW_KIND.DISTRIBUTION
  157. }))
  158. }
  159. if (metric && typeof metric === 'object') {
  160. return flattenStatisticMetrics(`${section}/${name}`, metric)
  161. }
  162. return [{ name, value: metric, unit: STATISTIC_METRIC_UNIT, section, kind: STATISTIC_ROW_KIND.METRIC }]
  163. })
  164. }
  165. export function formatStatisticRow(section, item, options = {}) {
  166. const levelLabel = typeof options.levelLabel === 'function' ? options.levelLabel : value => value
  167. const [facilityKey, metricKey] = String(section ?? '').split('/')
  168. const facilityType = FACILITY_SECTION_TYPES[facilityKey] || facilityKey
  169. const facilityLabel = resolveFacilitySectionLabel(facilityKey)
  170. const rawMetricKey = metricKey || item.name
  171. const metricLabel = resolveStatisticMetricLabel(rawMetricKey)
  172. const isDistribution = item.kind === STATISTIC_ROW_KIND.DISTRIBUTION
  173. const isStatusDistribution = isDistribution && metricKey === 'statusDistribution'
  174. const isLevelDistribution = isDistribution && metricKey === 'levelDistribution'
  175. const name = isStatusDistribution
  176. ? resolveFacilityStatusLabel(facilityType, item.name)
  177. : isLevelDistribution
  178. ? levelLabel(item.name)
  179. : isDistribution
  180. ? resolveDistributionValueLabel(metricKey, item.name)
  181. : metricLabel
  182. return {
  183. section: `${facilityLabel} - ${metricLabel}`,
  184. name,
  185. tagType: isStatusDistribution ? resolveFacilityStatusTagType(facilityType, item.name) : undefined,
  186. value: item.value ?? item.totalCount ?? 0,
  187. unit: item.unit || STATISTIC_METRIC_UNIT,
  188. description: resolveStatisticMetricDescription(rawMetricKey)
  189. }
  190. }
  191. export function buildPipeNetworkStatisticsQuery({ facilityTypes = [], status = '' } = {}) {
  192. const query = {}
  193. const types = Array.isArray(facilityTypes)
  194. ? facilityTypes.map(type => String(type).trim()).filter(Boolean)
  195. : []
  196. const normalizedStatus = String(status ?? '').trim()
  197. if (types.length) query.facilityTypes = types.join(',')
  198. if (normalizedStatus) query.status = normalizedStatus
  199. return query
  200. }
  201. export function getFacilityStatusOptions(facilityTypes = []) {
  202. const types = FACILITY_TYPE_ORDER.filter(type => facilityTypes.includes(type))
  203. const statusValues = new Set()
  204. types.forEach(type => {
  205. Object.keys(FACILITY_STATUS_LABELS[type] || {}).forEach(status => statusValues.add(status))
  206. })
  207. return [...statusValues].sort().map(status => {
  208. const labels = types
  209. .map(type => ({
  210. type,
  211. label: FACILITY_STATUS_LABELS[type]?.[status]
  212. }))
  213. .filter(item => item.label)
  214. const distinctLabels = [...new Set(labels.map(item => item.label))]
  215. const label = types.length === 1
  216. ? `${FACILITY_TYPE_LABELS[types[0]]}: ${distinctLabels[0]}`
  217. : distinctLabels.join(' / ')
  218. return { value: status, label }
  219. })
  220. }
  221. export function resolveFacilityStatusLabel(type, status) {
  222. const value = status === null || status === undefined ? '' : String(status)
  223. return FACILITY_STATUS_LABELS[type]?.[value] || unknownStatus.label
  224. }
  225. export function resolveFacilityStatusTagType(type, status) {
  226. const value = status === null || status === undefined ? '' : String(status)
  227. return FACILITY_STATUS_TAG_TYPES[type]?.[value] || unknownStatus.tagType
  228. }