From e49417ee6eecf7f00bd77e01a6b4a1c7a420708b Mon Sep 17 00:00:00 2001
From: xuyonghao <898441624@qq.com>
Date: 星期三, 04 十二月 2024 15:08:03 +0800
Subject: [PATCH] 知识库列表获取
---
app/service/user.py | 135 +++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 130 insertions(+), 5 deletions(-)
diff --git a/app/service/user.py b/app/service/user.py
index 472c77a..f5cc7ea 100644
--- a/app/service/user.py
+++ b/app/service/user.py
@@ -1,11 +1,136 @@
-from app.models.user_model import UserModel
-from app.Log import logger
+from datetime import datetime
-async def get_user_list(db, page_size: int, page_index: int, keyword: str):
- logger.error("ffffffff")
- query = db.query(UserModel)
+from app.api import pwd_context
+from app.config.config import settings
+from app.models import RoleModel, GroupModel, AgentType
+from app.models.user_model import UserModel
+from Log import logger
+from app.service.bisheng import BishengService
+from app.service.common.app_register import AppRegister
+from app.service.ragflow import RagflowService
+from app.service.service_token import get_ragflow_token, get_bisheng_token, get_ragflow_new_token
+
+
+async def get_user_list(db, page_index: int, page_size: int, keyword: str, role_key:str, user_id):
+ query = db.query(UserModel).filter(UserModel.permission!="admin")
+ # if role_key != "admin":
+ # query.filter(UserModel.creator==user_id)
if keyword:
query = query.filter(UserModel.group_name.like('%{}%'.format(keyword)))
users = query.order_by(UserModel.id.desc()).limit(page_size).offset(
(page_index - 1) * page_size).all()
return {"total": query.count(), "rows": [user.to_json() for user in users]}
+
+
+async def edit_user_status(db, status: str, user_id: int):
+ try:
+ db.query(UserModel).filter(UserModel.id == user_id).update({"status":status})
+ db.commit()
+ except Exception as e:
+ logger.error(e)
+ db.rollback()
+ return False
+ return True
+
+
+async def delete_user_data(db, user_id: str):
+ try:
+ db.query(UserModel).filter(UserModel.id == user_id, UserModel.permission!="admin").delete()
+ db.commit()
+ except Exception as e:
+ logger.error(e)
+ db.rollback()
+ return False
+ return True
+
+
+async def create_user(db, user_name, email, phone, login_name, password, roles, groups, user_id):
+ try:
+ bisheng_service = BishengService(settings.sgb_base_url)
+ ragflow_service = RagflowService(settings.fwr_base_url)
+
+ # 娉ㄥ唽鍒版瘯鏄�
+ try:
+ bisheng_info = await bisheng_service.register(user_name, password)
+ except Exception as e:
+ logger.error(f"Failed to register with Bisheng: {str(e)}")
+ return False
+
+ # 娉ㄥ唽鍒皉agflow
+ try:
+ ragflow_info = await ragflow_service.register(user_name, password)
+ except Exception as e:
+ logger.error(f"Failed to register with Ragflow: {str(e)}")
+ return False
+
+ # 瀛樺偍鐢ㄦ埛淇℃伅
+ hashed_password = pwd_context.hash(password)
+ user_model = UserModel(username=user_name, hashed_password=hashed_password, email=email,ragflow_id=ragflow_info.get("id"),bisheng_id=bisheng_info.get("user_id"),
+ phone=phone,login_name=login_name)
+
+ user_model.roles = [db.get(RoleModel, roleId) for roleId in roles]
+ if groups:
+ user_model.groups = [db.get(GroupModel, groupId) for groupId in groups]
+ user_model.creator = user_id
+ db.add(user_model)
+ db.commit()
+ db.refresh(user_model)
+ except Exception as e:
+ logger.error(e)
+ db.rollback()
+ return False
+ return True
+
+
+async def edit_user_data(db, user_id, email, phone, login_name, roles, groups):
+ try:
+ user = db.query(UserModel).filter(UserModel.id == user_id).first()
+ user.email = email
+ user.phone = phone
+ user.login_name = login_name
+ user.email = email
+ user.updated_at = datetime.now()
+ user.roles = [db.get(RoleModel, roleId) for roleId in roles]
+ user.groups = [db.get(GroupModel, groupId) for groupId in groups]
+ db.commit()
+ except Exception as e:
+ logger.error(e)
+ db.rollback()
+ return False
+ return True
+
+
+async def edit_user_pwd(db, user_id, current_user_id ,new_password="000000"):
+ try:
+ user = db.query(UserModel).filter(UserModel.id == user_id).first()
+ pwd = user.decrypted_password()
+ for app_type in AppRegister(db).get_app():
+ if app_type == AgentType.RAGFLOW:
+ token = await get_ragflow_new_token(db, user_id, app_type)
+ ragflow_service = RagflowService(settings.fwr_base_url)
+ await ragflow_service.set_user_password(token, pwd, new_password)
+ elif app_type == AgentType.BISHENG:
+ token = get_bisheng_token(db, current_user_id)
+ bisheng_service = BishengService(settings.sgb_base_url)
+ await bisheng_service.change_password_public(token, user.username, pwd, new_password)
+ else:
+ logger.error("娉ㄥ唽鏈煡搴旂敤锛歿}".format(app_type))
+ # hashed_password = pwd_context.hash(password)
+ hashed_password = user.encrypted_password(new_password)
+
+ user.password = hashed_password
+ db.commit()
+ except Exception as e:
+ logger.error(e)
+ db.rollback()
+ return False
+ return True
+
+
+async def get_user_info(db, page_size: int, page_index: int, keyword: str):
+ query = db.query(UserModel)
+ if keyword:
+ query = query.filter(UserModel.group_name.like('%{}%'.format(keyword)))
+ users = query.order_by(UserModel.id.desc()).limit(page_size).offset(
+ (page_index - 1) * page_size).all()
+ return {"total": query.count(), "rows": [user.to_json() for user in users]}
\ No newline at end of file
--
Gitblit v1.8.0