package com.product.server.report.config;
|
|
import com.product.core.config.CoreConst;
|
|
public class CmnConst extends CoreConst {
|
|
// 表名常量定义
|
public static final String PRODUCT_SYS_PRODUCTS = "product_sys_products"; // 产品表名
|
public static final String PRODUCT_SYS_REPORT_TYPE_CONFIG = "product_sys_report_type_config";
|
public static final String PRODUCT_SYS_REPORT_TYPE_ATTRIBUTE = "product_sys_report_type_attribute";
|
public static final String PRODUCT_SYS_REPORT_DATASOURCE_CONFIG = "product_sys_report_datasource_config";
|
public static final String PRODUCT_SYS_REPORT_DATASOURCE_CONFIG_FIELD = "product_sys_report_datasource_config_field";
|
public static final String PRODUCT_SYS_REPORT_CONFIG = "product_sys_report_config";
|
public static final String PRODUCT_SYS_REPORT_CONFIG_CHARTS = "product_sys_report_config_charts";
|
public static final String PRODUCT_SYS_REPORT_CONFIG_ATTRIBUTE = "product_sys_report_config_attribute";
|
public static final String PRODUCT_SYS_DATAMODEL_FIELD = "product_sys_datamodel_field";
|
public static final String PRODUCT_SYS_FUNCTIONS = "product_sys_functions";
|
public static final String PRODUCT_SYS_FUNCTION_BUTTONS = "product_sys_function_buttons";
|
public static final String PRODUCT_SYS_MVC_PAGE = "product_sys_mvc_page";
|
public static final String PRODUCT_SYS_LINK = "product_sys_link";
|
public static final String PRODUCT_SYS_FUNCTION_PERMISSION = "product_sys_function_permission";
|
public static final String PRODUCT_SYS_MENUS = "product_sys_menus";
|
public static final String PRODUCT_SYS_DATAMODEL_TABLE = "product_sys_datamodel_table";
|
|
//分页常量定义
|
public static final String CPAGE = "cpage"; //页数
|
public static final String PAGESIZE = "pagesize"; //每页条数
|
|
|
//特殊常量定义
|
public static final String TYPE = "~type~";
|
public static final String DEL = "del";
|
public static final String UUID = "uuid";
|
public static final String ID = "id";
|
public static final String OPTION = "option";
|
public static final String TABLE_NAME = "table_name";
|
//数据库类型
|
public static final String MYSQL = "mysql";
|
|
//常量字段定义
|
public static final String RELATED_TABLE = "related_table";
|
public static final String TYPE_GROUP = "type_group";
|
public static final String TYPE_UUID = "type_uuid";
|
public static final String FIELD_TYPE = "field_type";
|
public static final String FIELD_LENGTH = "field_length";
|
public static final String FIELD_UNIT = "field_unit";
|
public static final String FIELD_DESCRIPTION = "field_description";
|
public static final String FIELD_TEXT = "field_text";
|
public static final String IS_VALID = "is_valid";
|
public static final String CREATED_BY = "created_by";
|
public static final String UPDATED_BY = "updated_by";
|
public static final String CREATED_UTC_DATETIME = "created_utc_dateime";
|
public static final String UPDATED_UTC_DATETIME = "updated_utc_datetime";
|
public static final String NAME = "name";
|
public static final String VALUE = "value";
|
public static final String TRICODE = "tricode";
|
public static final String MODULE_UUID = "module_uuid";
|
public static final String TABLE_UUID = "table_uuid";
|
public static final String FUNCTION_NAME = "function_name";
|
public static final String FUNCTION_DESCRIPTION = "function_description";
|
public static final String REPORT_NAME = "report_name";
|
public static final String STATUS_UUID = "status_uuid";
|
public static final String FUNCTION_TYPE_UUID = "function_type_uuid";
|
public static final String CLIENT_TYPE_UUID = "client_type_uuid";
|
public static final String BUTTON_NAME = "button_name";
|
public static final String BUTTON_TITLE = "button_title";
|
public static final String BUTTON_TYPE = "button_type";
|
public static final String BUTTON_CATEGORY_UUID = "button_category_uuid";
|
public static final String ROUTE_NAME = "route_name";
|
public static final String IS_MAIN = "is_main";
|
public static final String PAGE_NAME = "page_name";
|
public static final String LINK_TYPE = "link_type";
|
public static final String FUNCTION_UUID = "function_uuid";
|
public static final String SUB_REPORT = "sub_report";
|
public static final String LINE_FROM = "line_from";
|
public static final String FROM_TYPE = "from_type";
|
public static final String LINE_TO = "line_to";
|
public static final String TO_TYPE = "to_type";
|
public static final String BUTTON_UUID = "button_uuid";
|
public static final String ROLE_UUID = "role_uuid";
|
public static final String MENU_NAME = "menu_name";
|
public static final String MENU_ICON = "menu_icon";
|
public static final String TRICODE_PARENT = "tricode_parent";
|
public static final String IS_CATALOG = "is_catalog";
|
public static final String IS_SHOW = "is_show";
|
public static final String TOP_LOCATION = "top_location";
|
public static final String LEFT_LOCATION = "left_location";
|
public static final String VERSION_UUID = "version_uuid";
|
public static final String PAGE_TYPE = "page_type";
|
public static final String PAGE_URL = "page_url";
|
public static final String UPLOAD_API_URL = "upload_api_url";
|
public static final String PARAMS = "params";
|
public static final String SEQUENCE = "sequence";
|
public static final String REPORT_WIDTH_TYPE = "report_width_type";
|
public static final String REPORT_WIDTH_VALUE = "report_width_value";
|
public static final String DATA_TYPE = "data_type";
|
public static final String PAGE_OPEN_WITH = "page_open_with";
|
public static final String RELATE_FLAG = "relate_flag";
|
public static final String LOGICAL_OPERATOR = "logical_operator";
|
public static final String LOGICAL_VALUE = "logical_value";
|
public static final String FIRST_LOAD = "first_load";
|
|
//PRODUCT_SYS_report_config 配置主表字段
|
public static final String DATASOURCE_UUID = "datasource_uuid";
|
//数据源uuid
|
public static final String REPORT_DATASOURCE_UUID = "report_datasource_uuid";
|
//表类型uuid
|
public static final String REPORT_TYPE_CONFIG_UUID = "report_type_config_uuid";
|
//PRODUCT_SYS_report_datasource_config 报表数据源配置表字段
|
public static final String SQL_TEXT = "sql_text";
|
//PRODUCT_SYS_report_datasource_config_field 报表数据源字段信息表字段
|
public static final String FIELD_NAME = "field_name";
|
public static final String FIELD_FORMAT = "field_format";
|
public static final String FIELD_PROMPT = "field_prompt";
|
public static final String SEARCH_TYPE = "search_type";
|
//PRODUCT_SYS_report_type_attribute 报表配置属性表字段
|
public static final String REPORT_TYPE_ATTR = "report_type_attr";
|
public static final String ATTRIBUTE_NAME = "attribute_name";
|
public static final String UNPIVOT_INFO = "unpivot_info";
|
public static final String IS_UNPIVOT = "is_unpivot";
|
|
public static final String REPORT_TYPE = "report_type";
|
public static final String REPORT_TYPE_COMMON = "普通数据列表";
|
public static final String REPORT_TYPE_GROUP = "分组报表";
|
public static final String REPORT_TYPE_CROSS = "交叉报表";
|
|
|
// 缓存
|
public static final String CACHE_REPORT_CONFIG = "报表配置";
|
public static final String CACHE_REPORT_DATASOURCE_CONFIG = "数据源配置";
|
public static final String CACHE_REPORT_DATASOURCE_FIELD_CONFIG = "数据源字段配置";
|
public static final String CACHE_REPORT_TYPE = "报表类型";
|
public static final String CACHE_REPORT_TYPE_ATTR = "报表类型属性表";
|
|
// 字段
|
public static final String REPORT_TYPE_ATTR_VALUE = "report_type_attr_value";
|
public static final String CELL_POSITION_X = "cell_position_x";
|
public static final String CELL_POSITION_Y = "cell_position_y";
|
public static final String REPORT_AREA = "report_area";
|
public static final String LAST_TOTAL = "last_total";
|
public static final String TOTAL_NAME = "total_name";
|
public static final String IS_PAGE = "is_page";
|
public static final String PAGE_SIZE = "page_size";
|
public static final String TYPE_NAME = "type_name";
|
public static final String SYSTEM_SENIOR_QUERY_STRING = "systemSeniorQueryString";
|
public static final String REPORT_DATASOURCE_NAME = "report_datasource_name";
|
|
// 属性-label
|
public static final String ATTR_COLSPAN = "colspan";
|
public static final String ATTR_ROWSPAN = "rowspan";
|
public static final String ATTR_FIELD_INFO = "field_info";
|
public static final String ATTR_DATA_AREA_GROUP_FIELD = "data_area_group_field";
|
public static final String ATTR_GROUP_AREA_GROUP_FIELD = "group_area_group_field";
|
public static final String ATTR_STATISTICS = "statistics";
|
public static final String ATTR_X = "x";
|
public static final String ATTR_Y = "y";
|
public static final String ATTR_SORT = "sort";
|
public static final String ATTR_SHOW_NAME = "show_name";
|
public static final String ATTR_IS_GROUP = "is_group";
|
public static final String ATTR_IS_CUSTOM_FIELD = "is_custom_field";
|
public static final String ATTR_SP_TIME_STATISTICS_WAY = "sp_time_statistics_way";
|
public static final String ATTR_RELATE_TIME_FIELD = "relate_time_field";
|
public static final String ATTR_RELATE_COMMON_FIELD = "relate_common_field";
|
public static final String ATTR_HEAD_LAST_YEAR = "last_year__";
|
public static final String ATTR_HEAD_PRE_PERIOD = "pre_period__";
|
|
public static final String ATTR_FORMULA = "formula";
|
public static final String ATTR_IS_STATISTICS = "is_statistics";
|
public static final String ATTR_IS_STATISTICS_FIELD = "is_statistics_field";
|
public static final String ATTR_DECIMAL_DIGITS = "decimal_digits";
|
public static final String ATTR_AVG_TYPE = "avg_type";
|
public static final String ATTR_ENUM_TYPE = "enum_type";
|
public static final String ATTR_IS_TOTAL_STATISTICS = "is_total_statistics";
|
public static final String ATTR_IS_TITLE = "is_title";
|
public static final String ATTR_GROUP_AREA_SUB_CNT = "group_area_sub_cnt";
|
public static final String ATTR_DATA_AREA_SUB_CNT = "data_area_sub_cnt";
|
public static final String ATTR_SIZE = "size";
|
public static final String ATTR_STATISTICS_FIELD = "statistics_field";
|
public static final String ATTR_ORDER_BY = "order_by";
|
public static final String ATTR_DATE_FORMAT = "date_format";
|
public static final String ATTR_NUM_FORMAT = "num_format";
|
public static final String ATTR_DATA_TYPE = "data_type";
|
public static final String ATTR_WIDTH = "width";
|
public static final String ATTR_URL = "url";
|
public static final String ATTR_REAL_VALUE = "real_value";
|
public static final String ATTR_TOTAL_COUNT = "total_count";
|
public static final String ATTR_TOTAL_PAGE = "total_page";
|
public static final String ATTR_URL_PARAM = "url_param";
|
|
public static final String ATTR_REPORT_AREA = "report_area";
|
public static final String ATTR_NAME = "name";
|
public static final String ATTR_VALUE = "value";
|
public static final String ATTR_FINAL_VALUE = "final_value";
|
|
public static final String ATTR_STATISTICS_DEFAULT = "default";
|
public static final String ATTR_STATISTICS_SUM = "sum";
|
public static final String ATTR_STATISTICS_MAX = "max";
|
public static final String ATTR_STATISTICS_MIN = "min";
|
public static final String ATTR_STATISTICS_CNT = "cnt";
|
public static final String ATTR_STATISTICS_AVG = "avg";
|
public static final String ATTR_STATISTICS_ENUM = "enum";
|
public static final String ATTR_STATISTICS_FINAL_STATISTICS = "final_statistics";
|
public static final String ATTR_STATISTICS_SUB_CNT = "sub_cnt";
|
public static final String ATTR_STATISTICS_GROUP_AREA_AVG = "group_area_avg";
|
public static final String ATTR_STATISTICS_DATA_AREA_AVG = "data_area_avg";
|
|
public static final String ATTR_DATA_TYPE_STRING = "string";
|
public static final String ATTR_DATA_TYPE_NUM = "num";
|
public static final String ATTR_DATA_TYPE_DATE = "date";
|
|
public static final String STATISTICS_NAME = "统计";
|
|
public static final String ONCLICK_FUNC_NAME = "turn_2_other_page";
|
|
public static final String RETURN_ATTR_RESULT = "result";
|
public static final String RETURN_ATTR_MESSAGE = "message";
|
public static final String RETURN_ATTR_HTML = "html";
|
|
public static final String REGEXP_FORM_FIELD = "\\{#\\w+#}";
|
public static final String REGEXP_SYS_FIELD = "\\{%\\w+%}";
|
public static final String REGEXP_NUMBER = "-?[0-9]+\\.?[0-9]*";
|
|
public static final String FALSE = "false";
|
public static final String TRUE = "true";
|
|
public static final String FULL_DATE_FORMAT = "yyyy-MM-dd HH:mm:ss";
|
|
public static final String MIN_X = "min_x";
|
public static final String MAX_X = "max_x";
|
public static final String MAX_Y = "max_y";
|
|
public static final String CLASS_TR_REPORT_TITLE = "report_title";
|
public static final String CLASS_TR_HEAD = "head";
|
public static final String CLASS_TR_DATA_TITLE = "data_title";
|
public static final String CLASS_TR_DATA_STATISTICS = "data_statistics";
|
public static final String CLASS_TR_DATA_COMMON = "data_common";
|
public static final String CLASS_TR_TAIL = "tail";
|
public static final String CLASS_TD_CAN_TURN = "can_turn";
|
|
public static final String PROMPT_REAL_VALUE_TAIL = "_save_value";
|
|
public static final String REGEXP_FILTER_AREA = "\\[\\[((?!\\[).)+\\]\\]";
|
public static final String REGEXP_ALL_AREA = "(\\[\\[((?!\\[).)+\\]\\])|(\\{\\$((?!\\$).)+\\$\\})|(\\{\\^((?!\\^).)+\\^\\})|(\\{\\&((?!\\&).)+\\&\\})";
|
public static final String REGEXP_SP_SIGN_AREA = "(\\{\\$((?!\\$).)+\\$\\})|(\\{\\^((?!\\^).)+\\^\\})|(\\{\\&((?!\\&).)+\\&\\})";
|
public static final String REGEXP_ONLY_VALUE = "\\{\\$((?!\\$).)+\\$\\}";
|
public static final String REGEXP_EXCEPT_FIELD = "\\{\\^((?!\\^).)+\\^\\}";
|
public static final String REGEXP_FULL_CONTENT = "\\{\\&((?!\\&).)+\\&\\}";
|
public static final String REGEXP_ALL_TERNARY_OPERATOR = "\\{@((?!(\\{@)|(@\\})|(\\[\\[)|(\\]\\])).)+@\\}";
|
public static final String REGEXP_TERNARY_OPERATOR = "((?!\\?|(\\[)).)+\\?((?!:).)+:((?!(\\]\\])).)+";
|
public static final String REGEXP_ALL_TYPE = "(\\{\\$((?!(\\{\\$)).)+\\$\\})|(\\{\\^((?!(\\{\\^)).)+\\^\\})|(\\{\\&((?!(\\{\\&)).)+\\&\\})";
|
public static final String REGEXP_ALWAYS_TRUE = "and\\s+1\\s*=\\s*1";
|
|
public static final String TERNARY_OPERATOR_LEFT = "{@";
|
public static final String TERNARY_OPERATOR_RIGHT = "@}";
|
public static final String CONTENT_PAGE_AREA = "[[page_area]]";
|
|
public static final String ADDRESS_INIT_INTERFENCE = "api/report/data-list/get-report";
|
public static final String ADDRESS_REPORT_SHOW = "system/reportForms/dataReport/preview";
|
public static final String ADDRESS_INIT_CHART = "/api/report/EChart/generatePieEChart";
|
public static final String ADDRESS_CHART_VIEW = "system/reportForms/chartReport/previewTwo";
|
|
public static final String FIELD_TYPE_NUM_STR = "bigint,decimal,double,float,int,integer,tinyint";
|
public static final String FIELD_TYPE_DATE_STR = "date,datetime,time,timestamp";
|
}
|
