rag-gateway.git

			@@ -1,41 +1,33 @@
			from sqlalchemy.testing.pickleable import Order

			from app.config.config import settings
			from app.models.group_model import GroupInfoModel, UserGroupModel
			from app.models import CanvasModel, DialogModel, KnowledgeModel
			from app.models.group_model import GroupModel
			from app.models.user_model import UserModel
			from app.service.ragflow import RagflowService
			from app.service.token import get_ragflow_token
			from app.service.service_token import get_ragflow_token
			from Log import logger


			async def group_list(db, page_size: int, page_index: int, keyword: str):
			query = db.query(GroupInfoModel)
			async def group_list(db, page_size: int, page_index: int, keyword: str, role_key:str, user_id):
			logger.info("-------------------------group_list----------------------------------")
			query = db.query(GroupModel).filter(GroupModel.creator==user_id)
			# if role_key != "admin":
			# query.filter(GroupModel.creator==user_id)
			if keyword:
			query = query.filter(GroupInfoModel.group_name.like('%{}%'.format(keyword)))
			items = query.order_by(GroupInfoModel.group_id.desc()).limit(page_size).offset(
			query = query.filter(GroupModel.group_name.like('%{}%'.format(keyword)))
			items = query.order_by(GroupModel.id.desc()).limit(page_size).offset(
			(page_index - 1) * page_size).all()
			items_list = [item.to_dict() for item in items]
			groups = [i["id"] for i in items_list]
			group_dict = {}
			for group_user in db.query(UserGroupModel.group_id, UserModel.id, UserModel.username).outerjoin(UserModel,
			UserModel.id == UserGroupModel.user_id).filter(
			UserGroupModel.group_id.in_(groups)).all():
			if group_user.group_id in group_dict:
			group_dict[group_user.group_id].append({"user_id": group_user.id, "user_name": group_user.username})
			else:
			group_dict[group_user.group_id] = [{"user_id": group_user.id, "user_name": group_user.username}]
			for item in items_list:
			item["users"] = group_dict.get(item["id"], [])
			return {"total": query.count(), "items": items_list}

			return {"total": query.count(), "items": [item.to_json() for item in items]}


			async def create_group(db, group_name: str, group_description: str):
			async def create_group(db, group_name: str, group_description: str, user_id):
			try:
			group_model = GroupInfoModel(group_name=group_name, group_description=group_description)
			group_model = GroupModel(group_name=group_name, group_description=group_description, creator=user_id)
			db.add(group_model)
			db.commit()
			db.refresh(group_model)
			except Exception as e:
			print(e)
			logger.error(e)
			db.rollback()
			return False
			return True
			@@ -43,10 +35,10 @@

			async def edit_group_data(db, group_id: int, data):
			try:
			db.query(GroupInfoModel).filter(GroupInfoModel.group_id == group_id).update(data)
			db.query(GroupModel).filter(GroupModel.id == group_id).update(data)
			db.commit()
			except Exception as e:
			print(e)
			logger.error(e)
			db.rollback()
			return False
			return True
			@@ -54,10 +46,10 @@

			async def delete_group_data(db, group_id: int):
			try:
			db.query(GroupInfoModel).filter(GroupInfoModel.group_id == group_id).delete()
			db.query(GroupModel).filter(GroupModel.id == group_id).delete()
			db.commit()
			except Exception as e:
			print(e)
			logger.error(e)
			db.rollback()
			return False
			return True
			@@ -66,9 +58,9 @@
			async def get_group_users(db, group_id):
			not_group_user = []
			in_group_user = []
			user_list = [i.user_id for i in
			db.query(UserGroupModel.user_id).filter(UserGroupModel.group_id.__eq__(group_id)).all()]
			for u in db.query(UserModel.id, UserModel.username).order_by(UserModel.id.desc()).all():
			user_list = [u.id for i in
			db.query(GroupModel).filter(GroupModel.id.__eq__(group_id)).all() for u in i.users]
			for u in db.query(UserModel.id, UserModel.username).filter(UserModel.permission!="admin").order_by(UserModel.id.desc()).all():
			if u.id in user_list:
			in_group_user.append({"user_id": u.id, "user_name": u.username})
			else:
			@@ -77,15 +69,17 @@


			async def save_user_to_group(db, user_id, group_id, user_list):
			group_user_list = [i.user_id for i in
			db.query(UserGroupModel.user_id).filter(UserGroupModel.group_id.__eq__(group_id)).all()]
			group_user_list = [u.id for i in
			db.query(GroupModel).filter(GroupModel.id.__eq__(group_id)).all() for u in i.users]
			new_users = set([i for i in user_list if i not in group_user_list])
			delete_user = [i for i in group_user_list if i not in user_list]
			print(new_users)
			if new_users:

			user_dict = {i.id: {"rg_id": i.ragflow_id, "email": i.email} for i in
			db.query(UserModel.id, UserModel.email, UserModel.ragflow_id).filter(
			UserModel.id.in_(user_list)).all()}
			print(user_dict)
			ragflow_service = RagflowService(settings.fwr_base_url)
			token = get_ragflow_token(db, user_id)

			@@ -101,19 +95,31 @@
			for user1 in new_users:
			for user2 in new_users:
			if user1 != user2:
			print(user1, user2)
			await ragflow_service.add_user_tenant(token, user_dict[user1]["rg_id"],
			user_dict[user2]["email"],
			user_dict[user2]["rg_id"])
			except Exception as e:
			print(e)
			logger.error(e)
			return False

			try:
			for user in new_users:
			db_user = UserGroupModel(group_id=group_id, user_id=user)
			db.add(db_user)
			db.query(UserGroupModel).filter(UserGroupModel.group_id.__eq__(group_id), UserGroupModel.user_id.in_(delete_user)).delete()
			group = db.query(GroupModel).filter(GroupModel.id.__eq__(group_id)).first()
			group.users = [db.get(UserModel, user) for user in user_list]
			db.commit()
			except Exception as e:
			print(e)
			logger.error(e)
			return False
			return True

			async def save_group_resource(db, user_id, group_id, agents, dialogs, knowledges):
			try:
			group = db.query(GroupModel).filter(GroupModel.id.__eq__(group_id)).first()
			group.agents = [db.get(CanvasModel, user) for user in agents]
			group.dialogs = [db.get(DialogModel, user) for user in dialogs]
			group.knowledges = [db.get(KnowledgeModel, user) for user in knowledges]
			db.commit()
			except Exception as e:
			logger.error(e)
			return False
			return True