from typing import List from fastapi import APIRouter, Query, Depends, Body from sqlalchemy.ext.asyncio import AsyncSession from app.core.database import get_db from app.utils.response import success from app.schemas.common import ApiResponse from app.schemas.email_authorizations import EmailAuthorizationCreate, EmailAuthorizationOut, EmailAuthorizationUpdate, EmailContent from app.schemas.emails import VasEmailCreate, VasEmailOut from app.services.email_authorizations_service import EmailAuthorizationService from app.services.emails_service import EmailsService public_router = APIRouter() protected_router = APIRouter() admin_required_router = APIRouter() @admin_required_router.get("/email-authorizations", summary="查询所有内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[List[EmailAuthorizationOut]]) async def email_authorizations_get(db: AsyncSession = Depends(get_db)): obj = await EmailAuthorizationService.get_all(db) return success(data=obj) @admin_required_router.post("/email-authorizations", summary="创建内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[EmailAuthorizationOut]) async def email_authorizations_create(data: EmailAuthorizationCreate, db: AsyncSession = Depends(get_db)): obj = await EmailAuthorizationService.create(db, data) return success(data=obj) @admin_required_router.get("/email-authorizations/{id}", summary="通过id查询内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[EmailAuthorizationOut]) async def email_authorizations_get_by_id(id: int, db: AsyncSession = Depends(get_db)): email_auth = await EmailAuthorizationService.get_by_id(db, id) return success(data=email_auth) @admin_required_router.put("/email-authorizations/{id}", summary="通过id更新内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[EmailAuthorizationOut]) async def email_authorizations_update_by_id(id: int, data: EmailAuthorizationUpdate, db: AsyncSession = Depends(get_db)): updated = await EmailAuthorizationService.update(db, id, data) return success(data=updated) @admin_required_router.delete("/email-authorizations/{id}", summary="通过id删除内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[EmailAuthorizationOut]) async def email_authorizations_delete_by_id(id: int, db: AsyncSession = Depends(get_db)): deleted = await EmailAuthorizationService.delete(db, id) return success(data=deleted) @admin_required_router.get("/email-authorizations/email/{email}", summary="通过邮箱地址查询内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[EmailAuthorizationOut]) async def email_authorizations_get_by_email(email: str, db: AsyncSession = Depends(get_db)): email_auth = await EmailAuthorizationService.get_by_email(db, email) return success(data=email_auth) @admin_required_router.post("/email-authorizations/fetch", summary="读取邮件, 仅限文本内容", tags=["邮箱接口"], response_model=ApiResponse[EmailContent]) async def email_authorizations_fetch_email( email: str = Query(..., description="收件邮箱账号, 格式: xxx@xxx.xxx"), sender: str = Query(..., description="发件人邮箱账号或者名字"), recipient: str = Query(..., description="收件人账号或者名字"), subjectKeywords: str = Query("", description="邮件主题关键词, 支持多个关键词, 用逗号隔开"), bodyKeywords: str = Query("", description="邮件内容关键词, 支持多个关键词, 用逗号隔开"), sentDate: str = Query(..., description="发件日期, UTC时间, 格式: yyyy-mm-dd hh:mm:ss"), expiry: int = Query(300, description="邮件有效期, 单位秒, 从sentDate 开始算起"), onlyText: bool = Query(True, description="是否纯文本"), db: AsyncSession = Depends(get_db) ): auth = await EmailAuthorizationService.get_by_email(db, email) print(auth) result = await EmailAuthorizationService.fetch_email_authorizations( auth, sender=sender, recipient=recipient, subject_keywords=subjectKeywords, body_keywords=bodyKeywords, sent_date=sentDate, expiry=expiry, only_text=onlyText ) return success(data={"body": result}) @admin_required_router.post("/email-authorizations/fetch-top", summary="从最近的几封邮件读取目标邮件,仅限文本内容, 性能会更好, 邮件多时有可能漏读", tags=["邮箱接口"], response_model=ApiResponse[EmailContent]) async def email_authorizations_fetch_email_from_topn( email: str = Query(..., description="收件邮箱账号, 格式: xxx@xxx.xxx"), sender: str = Query(..., description="发件人邮箱账号或者名字"), recipient: str = Query(..., description="收件人账号或者名字"), subjectKeywords: str = Query("", description="邮件主题关键词, 支持多个关键词, 用逗号隔开"), bodyKeywords: str = Query("", description="邮件内容关键词, 支持多个关键词, 用逗号隔开"), top: int = Query(10, description="指定从最近几封邮件读取"), onlyText: bool = Query(True, description="是否纯文本"), db: AsyncSession = Depends(get_db) ): auth = await EmailAuthorizationService.get_by_email(db, email) result = await EmailAuthorizationService.fetch_email_authorizations_from_top_n( auth, sender=sender, recipient=recipient, subject_keywords=subjectKeywords, body_keywords=bodyKeywords, top=top, only_text=onlyText ) return success(data={"body": result}) @admin_required_router.post("/email-authorizations/forward", summary="转发邮件", tags=["邮箱接口"], response_model=ApiResponse[EmailContent]) async def email_authorizations_forward_email( emailAccount: str = Query(..., description="收件邮箱账号, 格式: xxx@xxx.xxx"), forwardTo: str = Query(..., description="转发到哪个邮箱地址, 格式: xxx@xxx.xxx"), sender: str = Query(..., description="发件人邮箱账号或者名字"), recipient: str = Query(..., description="收件人账号或者名字"), subjectKeywords: str = Query("", description="邮件主题关键词, 支持多个关键词, 用逗号隔开"), bodyKeywords: str = Query("", description="邮件内容关键词, 支持多个关键词, 用逗号隔开"), db: AsyncSession = Depends(get_db) ): auth = await EmailAuthorizationService.get_by_email(db, emailAccount) result = await EmailAuthorizationService.forward_first_matching_email( auth, forward_to = forwardTo, sender = sender, recipient = recipient, subject_keywords = subjectKeywords, body_keywords = bodyKeywords ) return success(data={"body": result}) @admin_required_router.post("/email-authorizations/forward2", summary="转发邮件(新)", tags=["邮箱接口"], response_model=ApiResponse[EmailContent]) async def email_authorizations_forward_email2( emailAccount: str = Query(..., description="收件邮箱账号, 格式: xxx@xxx.xxx"), forwardTo: str = Query(..., description="转发到哪个邮箱地址, 格式: xxx@xxx.xxx"), sender: str = Query(..., description="发件人邮箱账号或者名字"), recipient: str = Query(..., description="收件人账号或者名字"), subjectKeywords: str = Query("", description="邮件主题关键词, 支持多个关键词, 用逗号隔开"), bodyKeywords: str = Query("", description="邮件内容关键词, 支持多个关键词, 用逗号隔开"), db: AsyncSession = Depends(get_db) ): auth = await EmailAuthorizationService.get_by_email(db, emailAccount) result = await EmailAuthorizationService.forward_first_matching_email2( db, auth, forward_to = forwardTo, sender = sender, recipient = recipient, subject_keywords = subjectKeywords, body_keywords = bodyKeywords ) return success(data={"body": result}) @admin_required_router.post("/email-authorizations/sendmail", summary="发送邮件", tags=["邮箱接口"], response_model=ApiResponse[EmailContent]) async def email_authorizations_send_email( emailAccount: str = Query(..., description="发件账号, 格式: xxx@xxx.xxx"), sendTo: str = Query(..., description="收件人邮箱账号"), subject: str = Query(..., description="邮件主题"), contentType: str = Query("text", description="内容格式,支持 text 和 html"), content: EmailContent = Body("", description="邮件内容"), db: AsyncSession = Depends(get_db) ): auth = await EmailAuthorizationService.get_by_email(db, emailAccount) result = await EmailAuthorizationService.send_email( auth, send_to = sendTo, subject = subject, content_type = contentType, content = content.body ) return success(data={"body": result}) @admin_required_router.post("/email-authorizations/sendmail-bulk", summary="群发送邮件", tags=["邮箱接口"], response_model=ApiResponse[EmailContent]) async def email_authorizations_send_email_bulk( emailAccount: str = Query(..., description="收件邮箱账号, 格式: xxx@xxx.xxx"), sendTo: str = Query(..., description="收件人邮箱账号,多个用逗号隔开"), subject: str = Query(..., description="邮件主题"), contentType: str = Query("text", description="内容格式,支持 text 和 html"), content: EmailContent = Body(..., description="邮件内容"), db: AsyncSession = Depends(get_db) ): auth = await EmailAuthorizationService.get_by_email(db, emailAccount) result = await EmailAuthorizationService.send_email_bulk( auth, send_to = sendTo, subject = subject, content_type = contentType, content = content.body ) return success(data={"body": result}) @admin_required_router.post("/emails/write", summary="写入邮件", tags=["邮箱接口"], response_model=ApiResponse[VasEmailOut]) async def emails_write( payload: VasEmailCreate, db: AsyncSession = Depends(get_db) ): rec = await EmailsService.create(db, payload) return success(data=rec) @admin_required_router.get("/emails/max_uid", summary="获取最大邮件UID", tags=["邮箱接口"], response_model=ApiResponse[int]) async def emails_get_max_uid( db: AsyncSession = Depends(get_db) ): uid = await EmailsService.get_max_uid(db) return success(data=uid)