Newer
Older
smartwell_demos / src / main / java / com / casic / util / DeviceDataFieldTableEnum.java
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;
    }
}