email.py 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
  1. from typing import List
  2. from fastapi import APIRouter, Query, Depends, Body
  3. from sqlalchemy.ext.asyncio import AsyncSession
  4. from app.core.database import get_db
  5. from app.utils.response import success
  6. from app.schemas.common import ApiResponse
  7. from app.schemas.email_authorizations import EmailAuthorizationCreate, EmailAuthorizationOut, EmailAuthorizationUpdate, EmailContent
  8. from app.schemas.emails import VasEmailCreate, VasEmailOut
  9. from app.services.email_authorizations_service import EmailAuthorizationService
  10. from app.services.emails_service import EmailsService
  11. public_router = APIRouter()
  12. protected_router = APIRouter()
  13. admin_required_router = APIRouter()
  14. @admin_required_router.get("/email-authorizations", summary="查询所有内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[List[EmailAuthorizationOut]])
  15. async def email_authorizations_get(db: AsyncSession = Depends(get_db)):
  16. obj = await EmailAuthorizationService.get_all(db)
  17. return success(data=obj)
  18. @admin_required_router.post("/email-authorizations", summary="创建内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[EmailAuthorizationOut])
  19. async def email_authorizations_create(data: EmailAuthorizationCreate, db: AsyncSession = Depends(get_db)):
  20. obj = await EmailAuthorizationService.create(db, data)
  21. return success(data=obj)
  22. @admin_required_router.get("/email-authorizations/{id}", summary="通过id查询内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[EmailAuthorizationOut])
  23. async def email_authorizations_get_by_id(id: int, db: AsyncSession = Depends(get_db)):
  24. email_auth = await EmailAuthorizationService.get_by_id(db, id)
  25. return success(data=email_auth)
  26. @admin_required_router.put("/email-authorizations/{id}", summary="通过id更新内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[EmailAuthorizationOut])
  27. async def email_authorizations_update_by_id(id: int, data: EmailAuthorizationUpdate, db: AsyncSession = Depends(get_db)):
  28. updated = await EmailAuthorizationService.update(db, id, data)
  29. return success(data=updated)
  30. @admin_required_router.delete("/email-authorizations/{id}", summary="通过id删除内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[EmailAuthorizationOut])
  31. async def email_authorizations_delete_by_id(id: int, db: AsyncSession = Depends(get_db)):
  32. deleted = await EmailAuthorizationService.delete(db, id)
  33. return success(data=deleted)
  34. @admin_required_router.get("/email-authorizations/email/{email}", summary="通过邮箱地址查询内部邮箱", tags=["邮箱接口"], response_model=ApiResponse[EmailAuthorizationOut])
  35. async def email_authorizations_get_by_email(email: str, db: AsyncSession = Depends(get_db)):
  36. email_auth = await EmailAuthorizationService.get_by_email(db, email)
  37. return success(data=email_auth)
  38. @admin_required_router.post("/email-authorizations/fetch", summary="读取邮件, 仅限文本内容", tags=["邮箱接口"], response_model=ApiResponse[EmailContent])
  39. async def email_authorizations_fetch_email(
  40. email: str = Query(..., description="收件邮箱账号, 格式: xxx@xxx.xxx"),
  41. sender: str = Query(..., description="发件人邮箱账号或者名字"),
  42. recipient: str = Query(..., description="收件人账号或者名字"),
  43. subjectKeywords: str = Query("", description="邮件主题关键词, 支持多个关键词, 用逗号隔开"),
  44. bodyKeywords: str = Query("", description="邮件内容关键词, 支持多个关键词, 用逗号隔开"),
  45. sentDate: str = Query(..., description="发件日期, UTC时间, 格式: yyyy-mm-dd hh:mm:ss"),
  46. expiry: int = Query(300, description="邮件有效期, 单位秒, 从sentDate 开始算起"),
  47. onlyText: bool = Query(True, description="是否纯文本"),
  48. db: AsyncSession = Depends(get_db)
  49. ):
  50. auth = await EmailAuthorizationService.get_by_email(db, email)
  51. print(auth)
  52. result = await EmailAuthorizationService.fetch_email_authorizations(
  53. auth,
  54. sender=sender,
  55. recipient=recipient,
  56. subject_keywords=subjectKeywords,
  57. body_keywords=bodyKeywords,
  58. sent_date=sentDate,
  59. expiry=expiry,
  60. only_text=onlyText
  61. )
  62. return success(data={"body": result})
  63. @admin_required_router.post("/email-authorizations/fetch-top", summary="从最近的几封邮件读取目标邮件,仅限文本内容, 性能会更好, 邮件多时有可能漏读", tags=["邮箱接口"], response_model=ApiResponse[EmailContent])
  64. async def email_authorizations_fetch_email_from_topn(
  65. email: str = Query(..., description="收件邮箱账号, 格式: xxx@xxx.xxx"),
  66. sender: str = Query(..., description="发件人邮箱账号或者名字"),
  67. recipient: str = Query(..., description="收件人账号或者名字"),
  68. subjectKeywords: str = Query("", description="邮件主题关键词, 支持多个关键词, 用逗号隔开"),
  69. bodyKeywords: str = Query("", description="邮件内容关键词, 支持多个关键词, 用逗号隔开"),
  70. top: int = Query(10, description="指定从最近几封邮件读取"),
  71. onlyText: bool = Query(True, description="是否纯文本"),
  72. db: AsyncSession = Depends(get_db)
  73. ):
  74. auth = await EmailAuthorizationService.get_by_email(db, email)
  75. result = await EmailAuthorizationService.fetch_email_authorizations_from_top_n(
  76. auth,
  77. sender=sender,
  78. recipient=recipient,
  79. subject_keywords=subjectKeywords,
  80. body_keywords=bodyKeywords,
  81. top=top,
  82. only_text=onlyText
  83. )
  84. return success(data={"body": result})
  85. @admin_required_router.post("/email-authorizations/forward", summary="转发邮件", tags=["邮箱接口"], response_model=ApiResponse[EmailContent])
  86. async def email_authorizations_forward_email(
  87. emailAccount: str = Query(..., description="收件邮箱账号, 格式: xxx@xxx.xxx"),
  88. forwardTo: str = Query(..., description="转发到哪个邮箱地址, 格式: xxx@xxx.xxx"),
  89. sender: str = Query(..., description="发件人邮箱账号或者名字"),
  90. recipient: str = Query(..., description="收件人账号或者名字"),
  91. subjectKeywords: str = Query("", description="邮件主题关键词, 支持多个关键词, 用逗号隔开"),
  92. bodyKeywords: str = Query("", description="邮件内容关键词, 支持多个关键词, 用逗号隔开"),
  93. db: AsyncSession = Depends(get_db)
  94. ):
  95. auth = await EmailAuthorizationService.get_by_email(db, emailAccount)
  96. result = await EmailAuthorizationService.forward_first_matching_email(
  97. auth,
  98. forward_to = forwardTo,
  99. sender = sender,
  100. recipient = recipient,
  101. subject_keywords = subjectKeywords,
  102. body_keywords = bodyKeywords
  103. )
  104. return success(data={"body": result})
  105. @admin_required_router.post("/email-authorizations/forward2", summary="转发邮件(新)", tags=["邮箱接口"], response_model=ApiResponse[EmailContent])
  106. async def email_authorizations_forward_email2(
  107. emailAccount: str = Query(..., description="收件邮箱账号, 格式: xxx@xxx.xxx"),
  108. forwardTo: str = Query(..., description="转发到哪个邮箱地址, 格式: xxx@xxx.xxx"),
  109. sender: str = Query(..., description="发件人邮箱账号或者名字"),
  110. recipient: str = Query(..., description="收件人账号或者名字"),
  111. subjectKeywords: str = Query("", description="邮件主题关键词, 支持多个关键词, 用逗号隔开"),
  112. bodyKeywords: str = Query("", description="邮件内容关键词, 支持多个关键词, 用逗号隔开"),
  113. db: AsyncSession = Depends(get_db)
  114. ):
  115. auth = await EmailAuthorizationService.get_by_email(db, emailAccount)
  116. result = await EmailAuthorizationService.forward_first_matching_email2(
  117. db,
  118. auth,
  119. forward_to = forwardTo,
  120. sender = sender,
  121. recipient = recipient,
  122. subject_keywords = subjectKeywords,
  123. body_keywords = bodyKeywords
  124. )
  125. return success(data={"body": result})
  126. @admin_required_router.post("/email-authorizations/sendmail", summary="发送邮件", tags=["邮箱接口"], response_model=ApiResponse[EmailContent])
  127. async def email_authorizations_send_email(
  128. emailAccount: str = Query(..., description="发件账号, 格式: xxx@xxx.xxx"),
  129. sendTo: str = Query(..., description="收件人邮箱账号"),
  130. subject: str = Query(..., description="邮件主题"),
  131. contentType: str = Query("text", description="内容格式,支持 text 和 html"),
  132. content: EmailContent = Body("", description="邮件内容"),
  133. db: AsyncSession = Depends(get_db)
  134. ):
  135. auth = await EmailAuthorizationService.get_by_email(db, emailAccount)
  136. result = await EmailAuthorizationService.send_email(
  137. auth,
  138. send_to = sendTo,
  139. subject = subject,
  140. content_type = contentType,
  141. content = content.body
  142. )
  143. return success(data={"body": result})
  144. @admin_required_router.post("/email-authorizations/sendmail-bulk", summary="群发送邮件", tags=["邮箱接口"], response_model=ApiResponse[EmailContent])
  145. async def email_authorizations_send_email_bulk(
  146. emailAccount: str = Query(..., description="收件邮箱账号, 格式: xxx@xxx.xxx"),
  147. sendTo: str = Query(..., description="收件人邮箱账号,多个用逗号隔开"),
  148. subject: str = Query(..., description="邮件主题"),
  149. contentType: str = Query("text", description="内容格式,支持 text 和 html"),
  150. content: EmailContent = Body(..., description="邮件内容"),
  151. db: AsyncSession = Depends(get_db)
  152. ):
  153. auth = await EmailAuthorizationService.get_by_email(db, emailAccount)
  154. result = await EmailAuthorizationService.send_email_bulk(
  155. auth,
  156. send_to = sendTo,
  157. subject = subject,
  158. content_type = contentType,
  159. content = content.body
  160. )
  161. return success(data={"body": result})
  162. @admin_required_router.post("/emails/write", summary="写入邮件", tags=["邮箱接口"], response_model=ApiResponse[VasEmailOut])
  163. async def emails_write(
  164. payload: VasEmailCreate,
  165. db: AsyncSession = Depends(get_db)
  166. ):
  167. rec = await EmailsService.create(db, payload)
  168. return success(data=rec)
  169. @admin_required_router.get("/emails/max_uid", summary="获取最大邮件UID", tags=["邮箱接口"], response_model=ApiResponse[int])
  170. async def emails_get_max_uid(
  171. db: AsyncSession = Depends(get_db)
  172. ):
  173. uid = await EmailsService.get_max_uid(db)
  174. return success(data=uid)