def get_project_docs(param_type,p_id):
select = Rcs_Parameter_Select.query.filter_by(tree_id=p_id).order_by("id").all()
if select:
for obj in select:
obj.style = 2
return helpers.show_result_content(select) # 返回json
param = Rcs_Parameter_Tree.query.filter_by(pId=p_id,param_type=param_type).order_by("id").all()
for obj in param:
obj.style = 1
return helpers.show_result_content(param) # 返回json
def menu_tree_json(roleId):
simplecache = SimpleCache.getInstance()
tree = []
#未点击角色
if(roleId == 0):
for key_cache in simplecache:
obj_tmp = simplecache[key_cache]
obj_tmp['checked'] = False
tree.append(obj_tmp)
#点击角色
else:
rcs_access_right = Rcs_Access_Right.query.filter_by(role_id=roleId).order_by("id").all()
for key_cache in simplecache:
obj_tmp = simplecache[key_cache]
obj_tmp['checked'] = False
for obj_access_right in rcs_access_right:
if(obj_tmp['levels'] != '4'):
if(obj_tmp['id'] == obj_access_right.resource_id):
obj_tmp['checked'] = True
break;
elif(obj_tmp['levels'] == '4'):
if(obj_tmp['id'].split("_")[0] == obj_access_right.resource_id):
if(int(obj_access_right.operations) & int(obj_tmp['id'].split("_")[1]) != 0):
obj_tmp['checked'] = True
break;
tree.append(obj_tmp)
return helpers.show_result_content(tree) # 返回json
def init_org_user_tree():
# 加载所有
tree = Org.query.order_by("id").all()
for obj in tree:
obj.id = "org_"+str(obj.id)
obj.type = "org"
obj.pId = "org_"+str(obj.pId)
obj.icon = "/static/img/icon_4.png"
#admin用户屏蔽
users = User.query.filter("id !=1").order_by("id").all()
for obj in users:
tmp = Org(obj.real_name,obj.org_id,None)
tmp.id = "user_"+str(obj.id)
tmp.type = "user"
tmp.sex = obj.sex
tmp.active = obj.active
tmp.login_name = obj.login_name
tmp.real_name = obj.real_name
tmp.pId = "org_1"
if(obj.org_id is not None):
tmp.pId = "org_"+str(obj.org_id)
elif(obj.pId is not None):
tmp.pId = "user_"+str(obj.pId)
tmp.icon = "/static/img/icon_5.png"
tree.append(tmp)
return helpers.show_result_content(tree) # 返回json
def show_tree(param_type):
orgs = Rcs_Parameter_Tree.query.filter("pId is null").order_by("id").all()
orgs_list = []
if orgs:
for obj in orgs:
sql = "FIND_IN_SET(id ,getParamList('"+str(obj.id)+"')) and param_type='"+str(param_type)+"'"
orgs_list = Rcs_Parameter_Tree.query.filter(sql).order_by("id").all()
for obj in orgs_list:
obj.open = 1
orgs_json = helpers.show_result_content(orgs_list)
orgs_json_obj = json.loads(orgs_json)
return json.dumps(orgs_json_obj)# 返回json
def show_tree(param_type):
orgs = Rcs_Parameter_Tree.query.filter("param_type='"+param_type+"' and pid is null").order_by("id").all()
orgs_list = []
orgs_list+=orgs
if orgs:
for obj in orgs:
sql = "FIND_IN_SET(id ,getParamList('"+str(obj.id)+"')) and create_user="******"id").all()
orgs_list = list(set(orgs_list))
for obj in orgs_list:
obj.open = 1
orgs_json = helpers.show_result_content(list(set(orgs_list)))
orgs_json_obj = json.loads(orgs_json)
return json.dumps(orgs_json_obj)# 返回json
def role_tree_json():
tree = Role.query.order_by("id").all()
return helpers.show_result_content(tree) # 返回json
def init_org_tree():
# 加载所有
tree = Org.query.order_by("id").all()
for obj in tree:
obj.icon = "/static/img/icon_4.png"
return helpers.show_result_content(tree) # 返回json
