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)
