From ac9373fd6f0db53c983d87c4790cb627e82759e9 Mon Sep 17 00:00:00 2001
From: zhaoqingang <zhaoqg0118@163.com>
Date: 星期二, 25 二月 2025 17:25:39 +0800
Subject: [PATCH] merge
---
app/service/group.py | 100 ++++++++++++++++++++++++++------------------------
1 files changed, 52 insertions(+), 48 deletions(-)
diff --git a/app/service/group.py b/app/service/group.py
index af95c76..c65dbd8 100644
--- a/app/service/group.py
+++ b/app/service/group.py
@@ -1,23 +1,26 @@
from app.config.config import settings
-from app.models import CanvasModel, DialogModel, KnowledgeModel
+from app.models.dialog_model import DialogModel
+from app.models.knowledge_model import KnowledgeModel
+from app.models.llm_model import CommonLlmModel
from app.models.group_model import GroupModel
from app.models.user_model import UserModel
from app.service.ragflow import RagflowService
from app.service.service_token import get_ragflow_token
from Log import logger
+from sqlalchemy import and_
-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)
+async def group_list(db, page_size: int, page_index: int, keyword: str):
+ # logger.info("-------------------------group_list----------------------------------")
+ query = db.query(GroupModel)
# if role_key != "admin":
# query.filter(GroupModel.creator==user_id)
if keyword:
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()
+ total = query.count()
+ items = query.order_by(GroupModel.id.desc()).limit(page_size).offset((page_index - 1) * page_size)
- return {"total": query.count(), "items": [item.to_json() for item in items]}
+ return {"total":total , "items": [item.to_json() for item in items.all()]}
async def create_group(db, group_name: str, group_description: str, user_id):
@@ -58,50 +61,51 @@
async def get_group_users(db, group_id):
not_group_user = []
in_group_user = []
- 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():
+ user_list = [u.id for u in db.query(GroupModel).filter(GroupModel.id.__eq__(group_id)).first().users]
+ for u in db.query(UserModel.id, UserModel.username, UserModel.permission).filter(
+ and_(UserModel.permission != "admin", UserModel.status != 2)
+ ).order_by(UserModel.id.desc()).all():
if u.id in user_list:
- in_group_user.append({"user_id": u.id, "user_name": u.username})
+ in_group_user.append({"userId": u.id, "userName": u.username})
else:
- not_group_user.append({"user_id": u.id, "user_name": u.username})
- return {"in_group": in_group_user, "not_in_group": not_group_user}
+ not_group_user.append({"userId": u.id, "userName": u.username})
+ return {"inGroup": in_group_user, "notInGroup": not_group_user}
async def save_user_to_group(db, user_id, group_id, user_list):
- 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)
-
- try:
- for old_user in group_user_list:
- if old_user in delete_user:
- continue
- for new_user in new_users:
- await ragflow_service.add_user_tenant(token, user_dict[old_user]["rg_id"], user_dict[new_user]["email"],
- user_dict[new_user]["rg_id"])
- await ragflow_service.add_user_tenant(token, user_dict[new_user]["rg_id"], user_dict[old_user]["email"],
- user_dict[old_user]["rg_id"])
- 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:
- logger.error(e)
- return False
+ # 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 = await get_ragflow_token(db, user_id)
+ #
+ # try:
+ # for old_user in group_user_list:
+ # if old_user in delete_user:
+ # continue
+ # for new_user in new_users:
+ # await ragflow_service.add_user_tenant(token, user_dict[old_user]["rg_id"], user_dict[new_user]["email"],
+ # user_dict[new_user]["rg_id"])
+ # await ragflow_service.add_user_tenant(token, user_dict[new_user]["rg_id"], user_dict[old_user]["email"],
+ # user_dict[old_user]["rg_id"])
+ # 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:
+ # logger.error(e)
+ # return False
try:
group = db.query(GroupModel).filter(GroupModel.id.__eq__(group_id)).first()
@@ -112,10 +116,10 @@
return False
return True
-async def save_group_resource(db, user_id, group_id, agents, dialogs, knowledges):
+async def save_group_resource(db, user_id, group_id, llms, 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()
--
Gitblit v1.8.0