emails_service.py 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  1. import re
  2. from sqlalchemy.ext.asyncio import AsyncSession
  3. from sqlalchemy import select, func
  4. from app.core.logger import logger
  5. from app.schemas.order_event import VasOrderEventCreate
  6. from app.services.order_event_service import OrderEventService
  7. from app.models.emails import VasEmail
  8. from app.schemas.emails import VasEmailCreate
  9. class EmailsService:
  10. # 关键词黑名单:匹配到这些词的邮件不会创建订单事件
  11. SUBJECT_BLACKLIST = [
  12. "验证码",
  13. "动态码",
  14. "verification code",
  15. "otp",
  16. "one-time password",
  17. "security code",
  18. "dynamic code",
  19. "one time password"
  20. ]
  21. SENDER_BLACKLIST = [
  22. "etsy",
  23. "dsw",
  24. ]
  25. @staticmethod
  26. def _is_subject_blacklisted(subject: str) -> bool:
  27. if not subject: return False
  28. lower = subject.lower()
  29. return any(kw.lower() in lower for kw in EmailsService.SUBJECT_BLACKLIST)
  30. @staticmethod
  31. def _is_sender_blacklisted(sender: str) -> bool:
  32. if not sender: return False
  33. lower = sender.lower()
  34. return any(kw.lower() in lower for kw in EmailsService.SENDER_BLACKLIST)
  35. @staticmethod
  36. def _summarize(text: str, limit: int = 120) -> str:
  37. if not text: return ""
  38. # 将多个空白字符替换为一个空格
  39. clean = re.sub(r"\s+", " ", text).strip()
  40. return clean[:limit] + ("..." if len(clean) > limit else "")
  41. @staticmethod
  42. async def create(db: AsyncSession, data: VasEmailCreate) -> VasEmail:
  43. # 1. 检查 UID 是否已存在 (幂等性)
  44. stmt = select(VasEmail).where(VasEmail.uid == data.uid)
  45. existing = (await db.execute(stmt)).scalar_one_or_none()
  46. if existing:
  47. return existing
  48. # 2. 存入邮件记录
  49. rec = VasEmail(
  50. uid=data.uid,
  51. subject=data.subject,
  52. sender=data.sender,
  53. recipient=data.recipient,
  54. receive_time=data.receive_time,
  55. body_text=data.body_text,
  56. )
  57. db.add(rec)
  58. # 3. 拦截、匹配订单并创建订单事件 (此时还在同一个事务中)
  59. await EmailsService._intercept(db, rec)
  60. # 4. 统一提交
  61. await db.commit()
  62. await db.refresh(rec)
  63. return rec
  64. @staticmethod
  65. async def get_max_uid(db: AsyncSession) -> int:
  66. stmt = select(func.max(VasEmail.uid))
  67. return await db.scalar(stmt) or 0
  68. @staticmethod
  69. async def _intercept(db: AsyncSession, rec: VasEmail) -> None:
  70. """
  71. 拦截处理逻辑:
  72. 1. 黑名单过滤
  73. 2. 创建订单事件 (OrderEventService)
  74. """
  75. if EmailsService._is_subject_blacklisted(rec.subject or ""):
  76. logger.info(f"Email {rec.uid} skipped: subject '{rec.subject}' is in blacklist.")
  77. return
  78. if EmailsService._is_sender_blacklisted(rec.sender or ""):
  79. logger.info(f"Email {rec.uid} skipped: sender '{rec.sender}' is in blacklist.")
  80. return
  81. # 尝试创建订单事件 (OrderEventService 内部会根据 rec.recipient 匹配订单)
  82. try:
  83. event = await OrderEventService.create(
  84. db,
  85. VasOrderEventCreate(
  86. order_no=None, # 由 OrderEventService 内部填充
  87. alias_email=rec.recipient,
  88. event_title=rec.subject or "Email Update",
  89. event_message=rec.body_text,
  90. email_uid=rec.uid,
  91. event_time=None,
  92. ),
  93. )
  94. if event and event.order_no:
  95. logger.info(f"Email {rec.uid} intercepted and logged to Order {event.order_no}.")
  96. else:
  97. logger.info(f"Email {rec.uid} logged, but no matching active order found for {rec.recipient}.")
  98. except Exception as e:
  99. logger.warning(f"Failed to create order event for email {rec.uid}: {e}")
  100. return