def fetch_alarm_disposition_list(request): """ 获取故障处理工单数据 :param request: :return: """ req_params = parse_json(request) limit = req_params.get('limit', 20) current_page = req_params.get('page', 1) sj_org_code = req_params.get("SJ_ORG_CODE") one_solve = req_params.get("ONE_SOLVE") satisfaction = req_params.get("SATISFACTION") status = req_params.get("STATUS") # 执行sql语句 table_name = "v_alarm_disposition_9" try: keywords = [] if sj_org_code is not None and len(sj_org_code.strip()) > 0: keywords.append({ "key": "SJ_ORG_CODE", "value": sj_org_code, "condition": "=" }) if one_solve in [10, 20, 30]: keywords.append({ "key": "ONE_SOLVE", "value": str(one_solve), "condition": "=" }) if satisfaction in [10, 20, 30]: keywords.append({ "key": "SATISFACTION", "value": str(satisfaction), "condition": "=" }) if status in [10, 20, 30, 40]: keywords.append({ "key": "STATUS", "value": str(status), "condition": "=" }) sql, con_sql = splice_sql(table_name, limit, current_page, keywords=keywords) oracle_execute_sql = OracleExecuteSQL() object_list = oracle_execute_sql.fetchall_to_dict(sql) count = oracle_execute_sql.fetchone_to_dict(con_sql) data = { 'count': count.get("COUNT", 0), 'list': object_list, 'current_page': current_page } return json_resp("success", data) except Exception as e: print(e) return json_resp("error", None, 500)
def fetch_alarm_record_list(request): """ 获取基础故障告警数据 :param request: :return: """ req_params = parse_json(request) limit = req_params.get('limit', 20) current_page = req_params.get('page', 1) sj_org_code = req_params.get("SJ_ORG_CODE") name = req_params.get("NAME") severity = req_params.get("SEVERITY") pro_status = req_params.get("PRO_STATUS") # 执行sql语句 table_name = "v_alarm_record_9" try: keywords = [] if sj_org_code is not None and len(sj_org_code.strip()) > 0: keywords.append({ "key": "SJ_ORG_CODE", "value": sj_org_code, "condition": "=" }) if name is not None and len(name.strip()) > 0: keywords.append({ "key": "NAME", "value": name + "", "condition": "like" }) if severity in [0, 1, 2]: keywords.append({ "key": "SEVERITY", "value": str(severity), "condition": "=" }) if pro_status in [10, 20, 30]: keywords.append({ "key": "PRO_STATUS", "value": str(pro_status), "condition": "=" }) sql, con_sql = splice_sql(table_name, limit, current_page, keywords=keywords) oracle_execute_sql = OracleExecuteSQL() object_list = oracle_execute_sql.fetchall_to_dict(sql) count = oracle_execute_sql.fetchone_to_dict(con_sql) data = { 'count': count.get("COUNT", 0), 'list': object_list, 'current_page': current_page } return json_resp("success", data) except Exception as e: print(e) return json_resp("error", None, 500)
def fetch_network_perf_list(request): """ 获取网络设备监测指标数据 :param request: :return: """ req_params = parse_json(request) limit = req_params.get('limit', 20) current_page = req_params.get('page', 1) sj_org_code = req_params.get("ORG_CODE") net_dev_online_state = req_params.get("NET_DEV_ONLINE_STATE") net_dev_alert_level = req_params.get("NET_DEV_ALERT_LEVEL") # 执行sql语句 table_name = "v_network_perf_9" try: keywords = [] if sj_org_code is not None and len(sj_org_code.strip()) > 0: keywords.append({ "key": "ORG_CODE", "value": sj_org_code, "condition": "=" }) if net_dev_online_state in [10, 20]: keywords.append({ "key": "NET_DEV_ONLINE_STATE", "value": str(net_dev_online_state), "condition": "=" }) if net_dev_alert_level in [0, 1, 2, 3]: keywords.append({ "key": "NET_DEV_ALERT_LEVEL", "value": str(net_dev_alert_level), "condition": "=" }) sql, con_sql = splice_sql(table_name, limit, current_page, keywords=keywords) oracle_execute_sql = OracleExecuteSQL() object_list = oracle_execute_sql.fetchall_to_dict(sql) count = oracle_execute_sql.fetchone_to_dict(con_sql) data = { 'count': count.get("COUNT", 0), 'list': object_list, 'current_page': current_page } return json_resp("success", data) except Exception as e: print(e) return json_resp("error", None, 500)
def fetch_hardware_resource_list(request): """ 获取硬件资源数据 :param request: :return: """ req_params = parse_json(request) limit = req_params.get('limit', 20) current_page = req_params.get('page', 1) sj_org_code = req_params.get("SJ_ORG_CODE") sj_status = req_params.get("SJ_STATUS") sj_cl_network = req_params.get("SJ_CI_NETWORK") # 执行sql语句 table_name = "v_hardware_resource_9" try: keywords = [] if sj_org_code is not None and len(sj_org_code.strip()) > 0: keywords.append({ "key": "SJ_ORG_CODE", "value": sj_org_code + "", "condition": "=" }) if sj_status in [1, 2, 3, 4, 5, 6, 7, 8]: keywords.append({ "key": "SJ_STATUS", "value": str(sj_status), "condition": "=" }) if sj_cl_network in [1, 2]: keywords.append({ "key": "SJ_CI_NETWORK", "value": str(sj_cl_network), "condition": "=" }) sql, con_sql = splice_sql(table_name, limit, current_page, keywords=keywords) oracle_execute_sql = OracleExecuteSQL() object_list = oracle_execute_sql.fetchall_to_dict(sql) count = oracle_execute_sql.fetchone_to_dict(con_sql) data = { 'count': count.get("COUNT", 0), 'list': object_list, 'current_page': current_page } return json_resp("success", data) except Exception as e: print(e) return json_resp("error", None, 500)
def fetch_network_link_list(request): """ 获取网络骨干链路信息数据 :param request: :return: """ req_params = parse_json(request) limit = req_params.get('limit', 20) current_page = req_params.get('page', 1) sj_org_code = req_params.get("ORG_CODE") # 执行sql语句 table_name = "v_network_link_9" try: keywords = [] if sj_org_code is not None and len(sj_org_code.strip()) > 0: keywords.append({ "key": "ORG_CODE", "value": sj_org_code, "condition": "=" }) sql, con_sql = splice_sql(table_name, limit, current_page, keywords=keywords) oracle_execute_sql = OracleExecuteSQL() object_list = oracle_execute_sql.fetchall_to_dict(sql) count = oracle_execute_sql.fetchone_to_dict(con_sql) data = { 'count': count.get("COUNT", 0), 'list': object_list, 'current_page': current_page } return json_resp("success", data) except Exception as e: print(e) return json_resp("error", None, 500)
def branch(request): req_params = parse_json(request) limit = req_params.get('limit', 20) current_page = req_params.get('page', 1) sj_org_code = req_params.get("SJ_ORG_CODE") sj_rm_name = req_params.get("SJ_RM_NAME") sj_is_th_mon = req_params.get("SJ_IS_TH_MON") sj_is_water_mon = req_params.get("SJ_IS_WATER_MON") sj_is_fire_mon = req_params.get("SJ_IS_FIRE_MON") # 执行sql语句 table_name = "v_room_situation_9" try: keywords = [] if sj_org_code is not None and len(sj_org_code.strip()) > 0: keywords.append({ "key": "SJ_ORG_CODE", "value": sj_org_code, "condition": "=" }) if sj_rm_name is not None and len(sj_rm_name.strip()) > 0: keywords.append({ "key": "SJ_RM_NAME", "value": sj_rm_name + "", "condition": "like" }) if sj_is_th_mon in [10, 20]: keywords.append({ "key": "SJ_IS_TH_MON", "value": str(sj_is_th_mon), "condition": "=" }) if sj_is_water_mon in [10, 20]: keywords.append({ "key": "SJ_IS_WATER_MON", "value": str(sj_is_water_mon), "condition": "=" }) if sj_is_fire_mon in [10, 20]: keywords.append({ "key": "SJ_IS_FIRE_MON", "value": str(sj_is_fire_mon), "condition": "=" }) sql, con_sql = splice_sql(table_name, limit, current_page, keywords=keywords) oracle_execute_sql = OracleExecuteSQL() object_list = oracle_execute_sql.fetchall_to_dict(sql) count = oracle_execute_sql.fetchone_to_dict(con_sql) data = { 'count': count.get("COUNT", 0), 'list': object_list, 'current_page': current_page } return json_resp("success", data) except Exception as e: print(e) return json_resp("error", None, 500)