package com.casic.util; import java.util.HashMap; import java.util.Map; public enum DeviceDataFieldTableEnum { TABLE_FIELD(new HashMap<String, String>() { { put("data_dig", "ddata AS dataValue,devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_gas", "strength AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_gasliquid_gas", "strength AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_gasliquid_liquid", "liquiddata AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_gas_dector", "gas_sample_value AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_harmful_gas", "CONCAT(CO, ', ', CH4, ', ', H2S, ', ', O2) AS dataValue,devcode AS devcode,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_hydrant", "0 AS dataValue,devcode AS devcode,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_liquid", "liquiddata AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_noise", "ddata AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_temp_hum", "CONCAT(TEMPERATURE, ', ', HUMIDITY) AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_tube", "strength AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_wellcover", "descn AS dataValue,devcode AS devcode,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_temp_press", "press AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_pantilt", "concentration AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_wellcover_loca", "0 AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(LOGTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_wellplus", "0 AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(LOGTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_h2s", "strength AS dataValue,devcode AS devcode,CELL AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); put("data_pressure", "re_val AS dataValue,devcode AS devcode,'' AS cell,DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%s') AS uptime"); } }); public Map<String, String> tableNameMap; DeviceDataFieldTableEnum(Map<String, String> tableNameMap) { this.tableNameMap = tableNameMap; } public Map<String, String> getTableFieldMap() { return tableNameMap; } }