From 3b1bf7da6771bd1d6852d3dcc1f906d5ae5c95d1 Mon Sep 17 00:00:00 2001
From: zhaoqingang <zhaoqg0118@163.com>
Date: 星期三, 12 三月 2025 13:49:12 +0800
Subject: [PATCH] 增加内容优化

---
 app/api/files.py |  213 ++++++++++++++++++++++++++++++++++++++++++-----------
 1 files changed, 169 insertions(+), 44 deletions(-)

diff --git a/app/api/files.py b/app/api/files.py
index 968b6b3..7107025 100644
--- a/app/api/files.py
+++ b/app/api/files.py
@@ -1,5 +1,6 @@
 import io
-from typing import Optional
+import time
+from typing import Optional, List
 
 import requests
 from fastapi import Depends, APIRouter, HTTPException, UploadFile, File, Query, Form
@@ -8,13 +9,20 @@
 from starlette.responses import StreamingResponse
 from werkzeug.utils import send_file
 
+from Log import logger
 from app.api import Response, get_current_user, ResponseList
 from app.config.config import settings
+from app.config.const import DOCUMENT_TO_REPORT, IMAGE_TO_TEXT, DOCUMENT_TO_REPORT_TITLE, DOCUMENT_IA_QUESTIONS, \
+    DOCUMENT_TO_PAPER, DOCUMENT_IA_QUESTIONS_DS, DOCUMENT_IA_QUESTIONS_EQUIPMENT
+from app.models import MenuCapacityModel
 from app.models.agent_model import AgentType, AgentModel
 from app.models.base_model import get_db
 from app.models.user_model import UserModel
 from app.service.basic import BasicService
 from app.service.bisheng import BishengService
+from app.service.files import read_file, service_chat_message, generate_word_document
+from app.service.v2.api_token import DfTokenDao
+from app.service.difyService import DifyService
 from app.service.ragflow import RagflowService
 from app.service.service_token import get_ragflow_token, get_bisheng_token
 import urllib.parse
@@ -23,53 +31,124 @@
 
 
 @router.post("/upload/{agent_id}", response_model=Response)
-async def upload_file(agent_id: str,
-                      file: UploadFile = File(...),
-                      chat_id: str = Query(None, description="The ID of the chat"),
-                      db: Session = Depends(get_db),
-                      current_user: UserModel = Depends(get_current_user)
-                      ):
-    agent = db.query(AgentModel).filter(AgentModel.id == agent_id).first()
+async def upload_files(
+    agent_id: str,
+    file: List[UploadFile] = File(...),  # 淇敼杩欓噷锛屾帴鍙楁枃浠跺垪琛�
+    chat_id: str = Query(None, description="The ID of the chat"),
+    db: Session = Depends(get_db),
+    current_user: UserModel = Depends(get_current_user)
+):
+    agent = db.query(MenuCapacityModel).filter(MenuCapacityModel.chat_id == agent_id).first()
     if not agent:
-        return Response(code=404, msg="Agent not found")
-    # 璇诲彇涓婁紶鐨勬枃浠跺唴瀹�
-    try:
-        file_content = await file.read()
-    except Exception as e:
-        return Response(code=400, msg=str(e))
+        return ResponseList(code=404, msg="Agent not found")
+    agent_type = int(agent.capacity_type)
 
-    if agent.agent_type == AgentType.RAGFLOW:
-        token = get_ragflow_token(db, current_user.id)
-        ragflow_service = RagflowService(base_url=settings.fwr_base_url)
-        # 鏌ヨ浼氳瘽鏄惁瀛樺湪锛屼笉瀛樺湪鍏堝垱寤轰細璇�
-        history = await ragflow_service.get_session_history(token, chat_id)
-        if len(history) == 0:
-            message = {"role": "user", "message": file.filename}
-            await ragflow_service.set_session(token, agent_id, message, chat_id, True)
+    # 妫�鏌� agent 绫诲瀷锛岀‘瀹氭槸鍚﹀厑璁镐笂浼犲涓枃浠�
+    if agent_type in [AgentType.RAGFLOW, AgentType.BISHENG]:
+        if len(file) > 1:
+            return Response(code=400, msg="杩欎釜鏅鸿兘浣撳彧鏀寔浼犲崟涓枃浠�")
 
-        ragflow_service = RagflowService(base_url=settings.fwr_base_url)
-        token = get_ragflow_token(db, current_user.id)
-        doc_ids = await ragflow_service.upload_and_parse(token, chat_id, file.filename, file_content)
-        return Response(code=200, msg="", data={"doc_ids": doc_ids, "file_name": file.filename})
-
-    elif agent.agent_type == AgentType.BISHENG:
-        bisheng_service = BishengService(base_url=settings.sgb_base_url)
+    if agent_type == AgentType.RAGFLOW or agent_type == AgentType.BISHENG:
+        file = file[0]
+        # 璇诲彇涓婁紶鐨勬枃浠跺唴瀹�
         try:
-            token = get_bisheng_token(db, current_user.id)
-            result = await bisheng_service.upload(token, file.filename, file_content)
+            file_content = await file.read()
         except Exception as e:
-            raise HTTPException(status_code=500, detail=str(e))
-        result["file_name"] = file.filename
-        return Response(code=200, msg="", data=result)
-    elif agent.agent_type == AgentType.BASIC:
+            return Response(code=400, msg=str(e))
+
+        if agent_type == AgentType.RAGFLOW:
+            token = await get_ragflow_token(db, current_user.id)
+            ragflow_service = RagflowService(base_url=settings.fwr_base_url)
+            # 鏌ヨ浼氳瘽鏄惁瀛樺湪锛屼笉瀛樺湪鍏堝垱寤轰細璇�
+            history = await ragflow_service.get_session_history(token, chat_id)
+            if len(history) == 0:
+                message = {"role": "user", "message": file.filename}
+                await ragflow_service.set_session(token, agent_id, message, chat_id, True)
+
+            doc_ids = await ragflow_service.upload_and_parse(token, chat_id, file.filename, file_content)
+            # 瀵逛簬澶氭枃浠讹紝鍙兘闇�瑕佹敹闆嗘墍鏈塪oc_ids
+            return Response(code=200, msg="", data={"doc_ids": doc_ids, "file_name": file.filename})
+
+        elif agent_type == AgentType.BISHENG:
+            bisheng_service = BishengService(base_url=settings.sgb_base_url)
+            try:
+                token = await get_bisheng_token(db, current_user.id)
+                result = await bisheng_service.upload(token, file.filename, file_content)
+            except Exception as e:
+                raise HTTPException(status_code=500, detail=str(e))
+            result["file_name"] = file.filename
+            return Response(code=200, msg="", data=result)
+
+    elif agent_type == AgentType.BASIC:
         if agent_id == "basic_excel_talk":
+            # 澶勭悊鍗曚釜鏂囦欢鐨勬儏鍐�
+            file_list = file
+            if len(file) == 1:  # and agent.agent_type != AgentType.BASIC
+                file_list = [file[0]]  # 濡傛灉鍙湁涓�涓枃浠讹紝纭繚瀹冩槸涓�涓垪琛�
             service = BasicService(base_url=settings.basic_base_url)
-            result = await service.excel_talk_upload(chat_id, file.filename, file_content)
+            # 閬嶅巻file_list锛屽瓨鍒癴iles 鍒楄〃涓�
+            files = []
+            for item in file_list:
+                file_content = await item.read()
+                files.append(('files', (item.filename, file_content, 'application/octet-stream')))
+
+            result = await service.excel_talk_upload(chat_id, files)
+            if not result:
+                return Response(code=400, msg="涓婁紶鏂囦欢鍑洪敊")
 
             return Response(code=200, msg="", data=result)
 
-    else:
-        return Response(code=200, msg="Unsupported agent type")
+        elif agent_id == "basic_paper_agent":
+            ...
+            # service = BasicService(base_url=settings.basic_paper_url)
+            # result = await service.paper_file_upload(chat_id, file.filename, file_content)
+
+    elif agent_type == AgentType.DIFY:
+        dify_service = DifyService(base_url=settings.dify_base_url)
+        if agent.chat_type == "imageTalk":
+            token = DfTokenDao(db).get_token_by_id(IMAGE_TO_TEXT)
+            if not token:
+                raise HTTPException(status_code=500, detail="鑾峰彇token澶辫触锛宨mage_and_text_conversion锛�")
+            file = file[0]
+            # 璇诲彇涓婁紶鐨勬枃浠跺唴瀹�
+            try:
+                file_content = await file.read()
+            except Exception as e:
+                return Response(code=400, msg=str(e))
+            try:
+                data = await dify_service.upload(token, file.filename, file_content, current_user.id)
+            except Exception as e:
+                raise HTTPException(status_code=500, detail=str(e))
+        elif agent.chat_type == "reportWorkflow" or agent.chat_type == "documentIa" or agent.chat_type == "paperTalk" or agent.chat_type == "documentIaDs" or agent.chat_type == "documentIaEq":
+            token_dict = {
+                "reportWorkflow": DOCUMENT_TO_REPORT_TITLE,
+                "documentIa": DOCUMENT_IA_QUESTIONS,
+                "paperTalk": DOCUMENT_TO_PAPER,
+                "documentIaDs": DOCUMENT_IA_QUESTIONS_DS,
+                "documentIaEq": DOCUMENT_IA_QUESTIONS_EQUIPMENT,
+            }
+            token = DfTokenDao(db).get_token_by_id(token_dict[agent.chat_type])
+            if not token:
+                raise HTTPException(status_code=500, detail="鑾峰彇token澶辫触锛宒ocument_to_report锛�")
+            result = []
+            for f in file:
+                try:
+                    file_content = await f.read()
+                except Exception as e:
+                    return Response(code=400, msg=str(e))
+                try:
+                    file_upload = await dify_service.upload(token, f.filename, file_content, current_user.id)
+                    try:
+                        tokens = await read_file(file_content, f.filename, f.content_type)
+                        file_upload["tokens"] = tokens
+                    except Exception as e:
+                        logger.error(e)
+                    result.append(file_upload)
+                except Exception as e:
+                    raise HTTPException(status_code=500, detail=str(e))
+        # result["file_name"] = file.filename
+            data = {"files": result}
+        return Response(code=200, msg="", data=data)
 
 
 @router.get("/download/", response_model=Response)
@@ -82,25 +161,29 @@
         file_type:  Optional[str] = Query(None, description="Optional file type for basic agents"),
         db: Session = Depends(get_db)
 ):
-    agent = db.query(AgentModel).filter(AgentModel.id == agent_id).first()
+    # agent = db.query(AgentModel).filter(AgentModel.id == agent_id).first()
+    agent = db.query(MenuCapacityModel).filter(MenuCapacityModel.chat_id == agent_id).first()
+
     if not agent:
         return Response(code=404, msg="Agent not found")
-
-    if agent.agent_type == AgentType.BISHENG:
+    agent_type = int(agent.capacity_type)
+    if agent_type == AgentType.BISHENG:
         url = urllib.parse.unquote(url)
         # 浠� URL 涓彁鍙栨枃浠跺悕
         parsed_url = urllib.parse.urlparse(url)
         filename = urllib.parse.unquote(parsed_url.path.split('/')[-1])
         url = url.replace("http://minio:9000", settings.sgb_base_url)
-    elif agent.agent_type == AgentType.RAGFLOW:
+    elif agent_type == AgentType.RAGFLOW:
         if not doc_id:
             return Response(code=400, msg="doc_id is required")
         url = f"{settings.fwr_base_url}/v1/document/get/{doc_id}"
         filename = doc_name
-    elif agent.agent_type == AgentType.BASIC:
+    elif agent_type == AgentType.BASIC:
         if agent_id == "basic_excel_talk":
             return await download_basic_file(file_id, file_type)
 
+        elif agent_id == "basic_question_talk":
+            return await download_basic_file(file_id, file_type)
     else:
         return Response(code=400, msg="Unsupported agent type")
 
@@ -137,5 +220,47 @@
             media_type=mimetype,
             headers={"Content-Disposition": f"attachment; filename={filename}"}
         )
+    elif file_type == "word":
+        content, filename, mimetype = await service.questions_talk_word_download(file_id)
+        return StreamingResponse(
+            io.BytesIO(content),
+            media_type=mimetype,
+            headers={"Content-Disposition": f"attachment; filename={filename}"}
+        )
     else:
-        return Response(code=400, msg="Unsupported file type")
\ No newline at end of file
+        return Response(code=400, msg="Unsupported file type")
+
+
+@router.get("/image/{imageId}", response_model=Response)
+async def download_image_file(imageId: str, db=Depends(get_db)):
+    file_path = f"app/images/{imageId}.png"
+
+    def generate():
+        with open(file_path, "rb") as file:
+            while True:
+                data = file.read(1048576)  # 璇诲彇1MB
+                if not data:
+                    break
+                yield data
+
+    return StreamingResponse(generate(), media_type="application/octet-stream")
+
+
+@router.get("/message/{message_id}/download", response_model=Response)
+async def chat_message_generate_docx(message_id: str, db=Depends(get_db)):
+    title, content = await service_chat_message(db, message_id)
+    if title:
+        print(title)
+        # 鍒涘缓 Word 鏂囨。
+        doc = await generate_word_document(title, content)
+
+        # 淇濆瓨鍒板唴瀛樼紦鍐插尯
+        buffer = io.BytesIO()
+        doc.save(buffer)
+        buffer.seek(0)
+        # print(2323232)
+        # 杩斿洖鏂囦欢娴�
+        return StreamingResponse(buffer,
+                                 media_type="application/vnd.openxmlformats-officedocument.wordprocessingml.document",
+                                 headers={"Content-Disposition": f"attachment; filename={int(time.time()*1000)}.docx"})
+    raise HTTPException(status_code=400, detail="Failed to generate Word document")

--
Gitblit v1.8.0