def get_sprmgrs(self):
'''
查询得到所有的超级运营员信息(姓名,user_id,管理集团的uuid)
:return:
'''
user_db = UserDao(session=self.session)
com_db = CompanyDao(session=self.session)
sup_mgrs_info = []
user_confs = self.session.query(UserConf).filter(UserConf.type == UserConf.TYPE_ROLE_SUPMGR).all()
spr_mgrs = user_db.get_users_by_role_group(Users.ROLE_SUP_MGR)
syndicate_list = com_db.get_companys(Company.NO_PARENT)
for user_conf in user_confs:
for spr_mgr in spr_mgrs:
if spr_mgr.user_id == user_conf.user_id:
for syndicate in syndicate_list:
if user_conf.company_uuid == syndicate['uuid']:
sup_mgr_info = {
'user_id': user_conf.user_id,
'user_name': spr_mgr.user_name,
'syndicate_uuid': user_conf.company_uuid,
'syndicate_name': syndicate['name'],
'telephone': spr_mgr.telephone,
}
sup_mgrs_info.append(sup_mgr_info)
return sup_mgrs_info
def get_admins(self):
'''
查询得到所有的管理员信息(姓名,电话号码,user_id)及其拥有权限
:return:
'''
role_rule_db = RoleRulesDao(session=self.session)
user_db = UserDao(session=self.session)
admin_roles = role_rule_db.get_roles(Users.ROLE_ADMIN)
admins = user_db.get_users_by_role_group(Users.ROLE_ADMIN)
admin_confs = self.session.query(UserConf).filter(UserConf.type == UserConf.TYPE_ROLE_ADMIN).all()
admin_infos = []
for admin in admins:
role_info_list = []
for admin_conf in admin_confs:
if admin.user_id == admin_conf.user_id:
for admin_role in admin_roles:
if admin_role['name'] == admin_conf.rule:
role_info_list.append({
'role_name': admin_role['name'],
'role_title': admin_role['title']
})
admin_info = {
'user_id': admin.user_id,
'user_name': admin.user_name,
'telephone': admin.telephone,
'roles': role_info_list
}
admin_infos.append(admin_info)
return admin_infos
