package com.product.server.report.config;

public class CmnConst {

    // 表名常量定义
    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 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";
    public static final String TABLE_NAME = "table_name";
    //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 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";
}