From e6c5e89f09637b8d9ebca6895d781663f12646d6 Mon Sep 17 00:00:00 2001
From: zhaoqingang <zhaoqg0118@163.com>
Date: 星期二, 17 十二月 2024 16:43:55 +0800
Subject: [PATCH] dify 文档智能

---
 app/api/chat.py |  481 +++++++++++++++++++++++++++++++++++++++++-----------
 1 files changed, 374 insertions(+), 107 deletions(-)

diff --git a/app/api/chat.py b/app/api/chat.py
index f21f07c..57438be 100644
--- a/app/api/chat.py
+++ b/app/api/chat.py
@@ -10,9 +10,12 @@
 from Log import logger
 from app.api import get_current_user_websocket
 from app.config.config import settings
+from app.config.const import IMAGE_TO_TEXT, DOCUMENT_TO_REPORT, DOCUMENT_TO_CLEANING, DOCUMENT_IA_QUESTIONS
+from app.models import MenuCapacityModel
 from app.models.agent_model import AgentModel, AgentType
 from app.models.base_model import get_db
 from app.models.user_model import UserModel
+from app.service.v2.api_token import DfTokenDao
 from app.service.dialog import update_session_history
 from app.service.basic import BasicService
 from app.service.difyService import DifyService
@@ -33,13 +36,21 @@
     tasks = []
     await websocket.accept()
     print(f"Client {agent_id} connected")
-
-    agent = db.query(AgentModel).filter(AgentModel.id == agent_id).first()
+    agent = db.query(MenuCapacityModel).filter(MenuCapacityModel.chat_id == agent_id).first()
+    if not agent:
+        agent = db.query(AgentModel).filter(AgentModel.id == agent_id).first()
+        agent_type = agent.agent_type
+        chat_type = agent.type
+    else:
+        agent_type = agent.capacity_type
+        chat_type = agent.chat_type
+    # print(agent_type)
+    # print(chat_type)
     if not agent:
         ret = {"message": "Agent not found", "type": "close"}
         await websocket.send_json(ret)
         return
-    agent_type = agent.agent_type
+
     if chat_id == "" or chat_id == "0":
         ret = {"message": "Chat ID not found", "type": "close"}
         await websocket.send_json(ret)
@@ -47,7 +58,7 @@
 
     if agent_type == AgentType.RAGFLOW:
         ragflow_service = RagflowService(settings.fwr_base_url)
-        token = get_ragflow_token(db, current_user.id)
+        token = await get_ragflow_token(db, current_user.id)
         try:
             async def forward_to_ragflow():
                 while True:
@@ -133,7 +144,7 @@
                         pass
 
     elif agent_type == AgentType.BISHENG:
-        token = get_bisheng_token(db, current_user.id)
+        token = await get_bisheng_token(db, current_user.id)
         service_uri = f"{settings.sgb_websocket_url}/api/v1/assistant/chat/{agent_id}?t=&chat_id={chat_id}"
         headers = {'cookie': f"access_token_cookie={token};"}
 
@@ -225,7 +236,7 @@
                     await websocket.send_json({"message": "Invalid request", "type": "error"})
                     continue
                 logger.error(agent.type)
-                if agent.type == "questionTalk":
+                if chat_type == "questionTalk":
 
                     try:
                         data = await service.questions_talk(question, chat_id)
@@ -235,7 +246,7 @@
                         excel_url = None
                         if file_name:
                             excel_url = f"/api/files/download/?agent_id=basic_question_talk&file_id={file_name}&file_type=word"
-                        result = {"message": output, "type": "message", "file_url": excel_url, "file_name":file_name}
+                        result = {"message": output, "type": "message", "file_url": excel_url, "file_name": file_name}
                         try:
                             SessionService(db).update_session(chat_id,
                                                               message={"role": "assistant", "content": result})
@@ -255,26 +266,33 @@
                     logger.error("---------------------excel_talk-----------------------------")
                     excel_url = ""
                     image_url = ""
+                    image_name = ""
+                    excel_name = ""
                     async for data in service.excel_talk(question, chat_id):
                         # logger.error(data)
                         output = data.get("output", "")
-                        excel_name = data.get("excel_name", "")
-                        image_name = data.get("image_name", "")
+                        e_name = data.get("excel_name", "")
+                        i_name = data.get("image_name", "")
 
                         def build_file_url(name, file_type):
                             if not name:
                                 return None
                             return (f"/api/files/download/?agent_id={agent_id}&file_id={name}"
                                     f"&file_type={file_type}")
-                        if excel_name:
-                            excel_url = build_file_url(excel_name, 'excel')
-                        if image_name:
-                            image_url = build_file_url(image_name, 'image')
+
+                        if e_name:
+                            excel_url = build_file_url(e_name, 'excel')
+                            excel_name = e_name
+                        if i_name:
+                            image_url = build_file_url(i_name, 'image')
+                            image_name = i_name
                         if data["type"] == "message":
                             message_data = {
                                 "content": output,
                                 "excel_url": excel_url,
                                 "image_url": image_url,
+                                "image_name": image_name,
+                                "excel_name": excel_name,
                                 "sql": data.get("sql", ""),
                                 "code": data.get("code", ""),
                                 "e": data.get("e", ""),
@@ -288,7 +306,7 @@
                         await websocket.send_json(data)
                     if message_data:
                         try:
-                            SessionService(db).update_session(chat_id,message=message_data)
+                            SessionService(db).update_session(chat_id, message=message_data)
                         except Exception as e:
                             logger.error(f"Unexpected error when update_session: {e}")
         except Exception as e:
@@ -300,110 +318,359 @@
     if agent_type == AgentType.DIFY:
         dify_service = DifyService(settings.dify_base_url)
         # token = get_dify_token(db, current_user.id)
-        token = settings.dify_api_token
         try:
             async def forward_to_dify():
+                if chat_type == "imageTalk":
+                    token = DfTokenDao(db).get_token_by_id(IMAGE_TO_TEXT)
+                    if not token:
+                        await websocket.send_json({"message": "Invalid token", "type": "error"})
 
-
-                while True:
-                    image_list = []
-                    is_image = False
-                    conversation_id = ""
-                    receive_message = await websocket.receive_json()
-                    print(f"Received from client {chat_id}: {receive_message}")
-                    upload_file_id = receive_message.get('upload_file_id', "")
-                    question = receive_message.get('message', "")
-                    if not question and not image_url:
-                        await websocket.send_json({"message": "Invalid request", "type": "error"})
-                        continue
-                    try:
-                        session = SessionService(db).create_session(
-                            chat_id,
-                            question,
-                            agent_id,
-                            AgentType.DIFY,
-                            current_user.id
-                        )
-                        conversation_id = session.conversation_id
-                    except Exception as e:
-                        logger.error(e)
-                    # complete_response = ""
-                    answer_str = ""
-                    async for rag_response in dify_service.chat(token, current_user.id, question, upload_file_id, conversation_id):
-                        # print("=============================================")
-                        # print(rag_response)
+                    while True:
+                        image_list = []
+                        is_image = False
+                        conversation_id = ""
+                        receive_message = await websocket.receive_json()
+                        print(f"Received from client {chat_id}: {receive_message}")
+                        upload_file_id = receive_message.get('upload_file_id', "")
+                        question = receive_message.get('message', "")
+                        if not question and not image_url:
+                            await websocket.send_json({"message": "Invalid request", "type": "error"})
+                            continue
                         try:
-                            if rag_response[:5] == "data:":
-                                # 濡傛灉鏄紝鍒欐埅鍙栨帀鍓�5涓瓧绗︼紝骞跺幓闄ら灏剧┖鐧界
-                                complete_response = rag_response[5:].strip()
-                            else:
-                                # 鍚﹀垯锛屼繚鎸佸師鏍�
-                                complete_response = rag_response
-                            # complete_response += text
+                            session = SessionService(db).create_session(
+                                chat_id,
+                                question,
+                                agent_id,
+                                AgentType.DIFY,
+                                current_user.id
+                            )
+                            conversation_id = session.conversation_id
+                        except Exception as e:
+                            logger.error(e)
+                        # complete_response = ""
+
+                        answer_str = ""
+                        files = []
+                        if upload_file_id:
+                            files.append({
+                                "type": "image",
+                                "transfer_method": "local_file",
+                                "url": "",
+                                "upload_file_id": upload_file_id
+                            })
+                        async for rag_response in dify_service.chat(token, current_user.id, question, files,
+                                                                    conversation_id):
+                            # print(rag_response)
                             try:
-                                data = json.loads(complete_response)
-                                complete_response = ""
-                                # data = json_data.get("data")
-                                if data.get("event") == "agent_message":# "event": "message_end"
-                                    if "answer" not in  data or not data["answer"]:  # 淇℃伅杩囨护
-                                        logger.error("闈炴硶鏁版嵁--------------------")
-                                        # logger.error(data)
+                                if rag_response[:5] == "data:":
+                                    # 濡傛灉鏄紝鍒欐埅鍙栨帀鍓�5涓瓧绗︼紝骞跺幓闄ら灏剧┖鐧界
+                                    complete_response = rag_response[5:].strip()
+                                else:
+                                    # 鍚﹀垯锛屼繚鎸佸師鏍�
+                                    complete_response = rag_response
+                                try:
+                                    data = json.loads(complete_response)
+                                    if data.get("event") == "agent_message":  # "event": "message_end"
+                                        if "answer" not in data or not data["answer"]:  # 淇℃伅杩囨护
+                                            logger.error("闈炴硶鏁版嵁--------------------")
+                                            # logger.error(data)
 
+                                            continue
+                                        else:  # 姝e父杈撳嚭
+                                            answer = data.get("answer", "")
+                                            if isinstance(answer, str):
+                                                if "![](https://res.stepfun.com/" in answer and image_list:
+                                                    is_image = True
+                                                    pattern = r'!\[\] *\(https://res\.stepfun\.com/image_gen/[^)]+\)'
+                                                    url_image = image_list.pop()
+                                                    new_answer = re.sub(pattern, url_image, answer)
+                                                    answer_str += new_answer
+                                                else:
+                                                    answer_str += answer
+
+                                            elif isinstance(answer, dict):
+                                                logger.error("鏈煡鏁版嵁浣擄細0---------------------------------")
+                                                logger.error(answer)
+                                                answer_str += answer.get("action_input", "")
+
+                                            result = {"message": answer_str, "type": "message"}
+                                    elif data.get("event") == "message_end":
+                                        images_url = []
+                                        if image_list and not is_image:
+                                            answer_str += image_list[-1]
+                                        result = {"message": answer_str,
+                                                  "type": "close"}  # , "message_files": images_url
+                                        try:
+                                            SessionService(db).update_session(chat_id,
+                                                                              message={"role": "assistant",
+                                                                                       "content": {"answer": answer_str,
+                                                                                                   "images": images_url}},
+                                                                              conversation_id=data.get(
+                                                                                  "conversation_id"))
+                                        except Exception as e:
+                                            logger.error("淇濆瓨dify鐨勪細璇濆紓甯革紒")
+                                            logger.error(e)
+                                    elif data.get("event") == "message_file":
+                                        await  dify_service.save_images(data.get("url"), data.get("id") + ".png")
+                                        image_list.append(f"![](/api/files/image/{data.get('id')})")
+                                        # result = {"message": answer_str, "type": "message"}
                                         continue
-                                    else:  # 姝e父杈撳嚭
-                                        answer = data.get("answer", "")
-                                        if isinstance(answer, str):
-                                            if "![](https://res.stepfun.com/" in answer and image_list:
-                                                is_image = True
-                                                pattern = r'!\[\] *\(https://res\.stepfun\.com/image_gen/[^)]+\)'
-                                                url_image = image_list.pop()
-                                                new_answer = re.sub(pattern, url_image, answer)
-                                                answer_str += new_answer
-                                            else:
-                                                answer_str += answer
+                                    else:
+                                        continue
+                                    await websocket.send_json(result)
+                                    complete_response = ""
+                                except json.JSONDecodeError as e:
+                                    print(f"Error decoding JSON: {e}")
+                                    # print(f"Response text: {text}")
+                            except Exception as e2:
+                                result = {"message": f"鍐呴儴閿欒锛� {e2}", "type": "close"}
+                                await websocket.send_json(result)
+                                print(f"Error process message of ragflow: {e2}")
+                elif chat_type == "reportWorkflow":
 
-                                        elif isinstance(answer, dict):
-                                            logger.error("鏈煡鏁版嵁浣擄細0---------------------------------")
-                                            logger.error(answer)
-                                            answer_str += answer.get("action_input", "")
-
-                                        result = {"message": answer_str, "type": "message"}
-                                elif data.get("event") == "message_end":
-                                    images_url = []
-                                    # res_msg = await dify_service.get_session_history(token, data.get("conversation_id"), str(current_user.id))
-                                    # if len(res_msg) > 0:
-                                    #     message_files = res_msg[-1].get("message_files")
-                                    #     for msg_file in message_files:
-                                    #         await  dify_service.save_images(msg_file.get("url"), msg_file.get("id")+".png")
-                                    #         images_url.append(msg_file.get("id"))
-                                    # result = {"message": answer_str, "type": "close"} # , "message_files": images_url
-                                    if image_list and not is_image:
-                                        answer_str += image_list[-1]
-                                    result = {"message": answer_str,
-                                              "type": "close"}  # , "message_files": images_url
-                                    try:
-                                        SessionService(db).update_session(chat_id,
-                                                                          message={"role": "assistant", "content": {"answer":answer_str, "images":images_url}},conversation_id=data.get("conversation_id"))
-                                    except Exception as e:
-                                        logger.error("淇濆瓨dify鐨勪細璇濆紓甯革紒")
-                                        logger.error(e)
-                                elif data.get("event") == "message_file":
-                                    await  dify_service.save_images(data.get("url"), data.get("id") + ".png")
-                                    image_list.append(f"![](/api/files/image/{data.get('id')})")
-                                    # result = {"message": answer_str, "type": "message"}
+                    token = DfTokenDao(db).get_token_by_id(DOCUMENT_TO_CLEANING)
+                    if not token:
+                        await websocket.send_json({"message": "Invalid token document_to_cleaning", "type": "error"})
+                    while True:
+                        receive_message = await websocket.receive_json()
+                        print(f"Received from client {chat_id}: {receive_message}")
+                        upload_files = receive_message.get('upload_files', [])
+                        title = receive_message.get('title', "")
+                        workflow_type = receive_message.get('workflow', 1)
+                        if not upload_files:
+                            await websocket.send_json({"message": "Invalid request", "type": "error"})
+                            continue
+                        try:
+                            session = SessionService(db).create_session(
+                                chat_id,
+                                title,
+                                agent_id,
+                                AgentType.DIFY,
+                                current_user.id
+                            )
+                            conversation_id = session.conversation_id
+                        except Exception as e:
+                            logger.error(e)
+                        inputs = {
+                        }
+                        files = []
+                        for file in upload_files:
+                            files.append({
+                                "type": "document",
+                                "transfer_method": "local_file",
+                                "url": "",
+                                "upload_file_id": file
+                            })
+                        if workflow_type == 1:
+                            inputs["input_files"] = files
+                        if workflow_type == 2:
+                            inputs["file_list"] = files
+                            inputs["Completion_of_main_indicators"] = title
+                            token = DfTokenDao(db).get_token_by_id(DOCUMENT_TO_REPORT)
+                            if not token:
+                                await websocket.send_json(
+                                    {"message": "Invalid token document_to_cleaning", "type": "error"})
+                        complete_response = ""
+                        async for rag_response in dify_service.workflow(token, current_user.id, inputs):
+                            # print(rag_response)
+                            try:
+                                if rag_response[:5] == "data:":
+                                    # 濡傛灉鏄紝鍒欐埅鍙栨帀鍓�5涓瓧绗︼紝骞跺幓闄ら灏剧┖鐧界
+                                    complete_response = rag_response[5:].strip()
+                                elif "event: ping" in rag_response:
                                     continue
                                 else:
-                                    continue
-                                await websocket.send_json(result)
-                                complete_response = ""
-                            except json.JSONDecodeError as e:
-                                print(f"Error decoding JSON: {e}")
-                                # print(f"Response text: {text}")
-                        except Exception as e2:
-                            result = {"message": f"鍐呴儴閿欒锛� {e2}", "type": "close"}
-                            await websocket.send_json(result)
-                            print(f"Error process message of ragflow: {e2}")
+                                    # 鍚﹀垯锛屼繚鎸佸師鏍�
+                                    complete_response += rag_response
+                                try:
+                                    data = json.loads(complete_response)
+                                    complete_response = ""
+                                    if data.get("event") == "node_started" or data.get("event") == "node_finished":  # "event": "message_end"
+                                        if "data" not in data or not data["data"]:  # 淇℃伅杩囨护
+                                            logger.error("闈炴硶鏁版嵁--------------------")
+                                            logger.error(data)
+                                            continue
+                                        else:  # 姝e父杈撳嚭
+                                            answer = data.get("data", "")
+                                            if isinstance(answer, str):
+                                                logger.error("----------------鏈煡鏁版嵁--------------------")
+                                                logger.error(data)
+                                                continue
+                                            elif isinstance(answer, dict):
 
+                                                message = answer.get("title", "")
+
+                                            result = {"message": message, "type": "system"}
+                                    elif data.get("event") == "workflow_finished":
+                                        answer = data.get("data", "")
+                                        if isinstance(answer, str):
+                                            logger.error("----------------鏈煡鏁版嵁--------------------")
+                                            logger.error(data)
+                                            result = {"message": "", "type": "close", "download_url": ""}
+                                        elif isinstance(answer, dict):
+                                            download_url = ""
+                                            outputs = answer.get("outputs", {})
+                                            if outputs:
+                                                message = outputs.get("output", "")
+                                                download_url = outputs.get("download_url", "")
+                                            else:
+                                                message = answer.get("error", "")
+
+                                            result = {"message": message, "type": "message", "download_url": download_url}
+                                            try:
+                                                SessionService(db).update_session(chat_id,
+                                                                                  message={"role": "assistant",
+                                                                                           "content": {
+                                                                                               "answer": message,
+                                                                                               "download_url": download_url}},
+                                                                                  conversation_id=data.get(
+                                                                                      "conversation_id"))
+                                            except Exception as e:
+                                                logger.error("淇濆瓨dify鐨勪細璇濆紓甯革紒")
+                                                logger.error(e)
+                                            await websocket.send_json(result)
+                                            result = {"message": "", "type": "close", "download_url": ""}
+
+
+                                    else:
+                                        continue
+                                    try:
+                                        await websocket.send_json(result)
+                                    except Exception  as e:
+                                        logger.error(e)
+                                        logger.error("杩斿洖瀹㈡埛绔秷鎭紓甯�!")
+                                    complete_response = ""
+                                except json.JSONDecodeError as e:
+                                    print(f"Error decoding JSON: {e}")
+                                    # print(f"Response text: {text}")
+                            except Exception as e2:
+                                result = {"message": f"鍐呴儴閿欒锛� {e2}", "type": "close"}
+                                await websocket.send_json(result)
+                                print(f"Error process message of ragflow: {e2}")
+                elif chat_type == "documentIa":
+                    # print(122112)
+                    token = DfTokenDao(db).get_token_by_id(DOCUMENT_IA_QUESTIONS)
+                    # print(token)
+                    if not token:
+                        await websocket.send_json({"message": "Invalid token", "type": "error"})
+
+                    while True:
+                        conversation_id = ""
+                        # print(4343)
+                        receive_message = await websocket.receive_json()
+                        print(f"Received from client {chat_id}: {receive_message}")
+                        upload_file_id = receive_message.get('upload_file_id', [])
+                        question = receive_message.get('message', "")
+                        if not question and not image_url:
+                            await websocket.send_json({"message": "Invalid request", "type": "error"})
+                            continue
+                        try:
+                            session = SessionService(db).create_session(
+                                chat_id,
+                                question,
+                                agent_id,
+                                AgentType.DIFY,
+                                current_user.id
+                            )
+                            conversation_id = session.conversation_id
+                        except Exception as e:
+                            logger.error(e)
+                        # complete_response = ""
+                        files = []
+                        for fileId in upload_file_id:
+                            files.append({
+                                "type": "document",
+                                "transfer_method": "local_file",
+                                "url": "",
+                                "upload_file_id": fileId
+                            })
+
+                        answer_str = ""
+                        complete_response = ""
+                        async for rag_response in dify_service.chat(token, current_user.id, question, files,
+                                                                    conversation_id):
+                            # print(rag_response)
+                            try:
+                                if rag_response[:5] == "data:":
+                                    # 濡傛灉鏄紝鍒欐埅鍙栨帀鍓�5涓瓧绗︼紝骞跺幓闄ら灏剧┖鐧界
+                                    complete_response = rag_response[5:].strip()
+                                elif "event: ping" in rag_response:
+                                    continue
+                                else:
+                                    # 鍚﹀垯锛屼繚鎸佸師鏍�
+                                    complete_response += rag_response
+                                try:
+                                    data = json.loads(complete_response)
+                                    if data.get("event") == "node_started" or data.get(
+                                            "event") == "node_finished":  # "event": "message_end"
+                                        if "data" not in data or not data["data"]:  # 淇℃伅杩囨护
+                                            logger.error("闈炴硶鏁版嵁--------------------")
+                                            logger.error(data)
+                                            continue
+                                        else:  # 姝e父杈撳嚭
+                                            answer = data.get("data", "")
+                                            if isinstance(answer, str):
+                                                logger.error("----------------鏈煡鏁版嵁--------------------")
+                                                logger.error(data)
+                                                continue
+                                            elif isinstance(answer, dict):
+
+                                                message = answer.get("title", "")
+
+                                            result = {"message": message, "type": "system"}
+                                            continue
+                                    elif data.get("event") == "message":  # "event": "message_end"
+                                         # 姝e父杈撳嚭
+                                        answer = data.get("answer", "")
+                                        result = {"message": answer, "type": "message"}
+                                    elif data.get("event") == "workflow_finished":
+                                        answer = data.get("data", "")
+                                        if isinstance(answer, str):
+                                            logger.error("----------------鏈煡鏁版嵁--------------------")
+                                            logger.error(data)
+                                            result = {"message": "", "type": "close", "download_url": ""}
+                                        elif isinstance(answer, dict):
+                                            download_url = ""
+                                            outputs = answer.get("outputs", {})
+                                            if outputs:
+                                                message = outputs.get("answer", "")
+                                                # download_url = outputs.get("download_url", "")
+                                            else:
+                                                message = answer.get("error", "")
+
+                                            # result = {"message": message, "type": "message",
+                                            #           "download_url": download_url}
+                                            try:
+                                                SessionService(db).update_session(chat_id,
+                                                                                  message={"role": "assistant",
+                                                                                           "content": {
+                                                                                               "answer": message,
+                                                                                               "download_url": download_url}},
+                                                                                  conversation_id=data.get(
+                                                                                      "conversation_id"))
+                                            except Exception as e:
+                                                logger.error("淇濆瓨dify鐨勪細璇濆紓甯革紒")
+                                                logger.error(e)
+                                            # await websocket.send_json(result)
+                                        continue
+                                    elif data.get("event") == "message_end":
+                                        result = {"message": "", "type": "close"}
+
+                                    else:
+                                        continue
+                                    try:
+                                        await websocket.send_json(result)
+                                    except Exception as e:
+                                        logger.error(e)
+                                        logger.error("杩斿洖瀹㈡埛绔秷鎭紓甯�!")
+                                    complete_response = ""
+                                except json.JSONDecodeError as e:
+                                    print(f"Error decoding JSON: {e}")
+                                    # print(f"Response text: {text}")
+                            except Exception as e2:
+                                result = {"message": f"鍐呴儴閿欒锛� {e2}", "type": "close"}
+                                await websocket.send_json(result)
+                                print(f"Error process message of ragflow: {e2}")
 
             # 鍚姩浠诲姟澶勭悊瀹㈡埛绔秷鎭�
             tasks = [

--
Gitblit v1.8.0