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