| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204 |
- 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)
|