| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114 |
- import re
- from sqlalchemy.ext.asyncio import AsyncSession
- from sqlalchemy import select, func
- from app.core.logger import logger
- from app.schemas.order_event import VasOrderEventCreate
- from app.services.order_event_service import OrderEventService
- from app.models.emails import VasEmail
- from app.schemas.emails import VasEmailCreate
- class EmailsService:
- # 关键词黑名单:匹配到这些词的邮件不会创建订单事件
- SUBJECT_BLACKLIST = [
- "验证码",
- "动态码",
- "verification code",
- "otp",
- "one-time password",
- "security code",
- "dynamic code",
- "one time password"
- ]
-
- SENDER_BLACKLIST = [
- "etsy",
- "dsw",
- ]
- @staticmethod
- def _is_subject_blacklisted(subject: str) -> bool:
- if not subject: return False
- lower = subject.lower()
- return any(kw.lower() in lower for kw in EmailsService.SUBJECT_BLACKLIST)
-
- @staticmethod
- def _is_sender_blacklisted(sender: str) -> bool:
- if not sender: return False
- lower = sender.lower()
- return any(kw.lower() in lower for kw in EmailsService.SENDER_BLACKLIST)
- @staticmethod
- def _summarize(text: str, limit: int = 120) -> str:
- if not text: return ""
- # 将多个空白字符替换为一个空格
- clean = re.sub(r"\s+", " ", text).strip()
- return clean[:limit] + ("..." if len(clean) > limit else "")
- @staticmethod
- async def create(db: AsyncSession, data: VasEmailCreate) -> VasEmail:
- # 1. 检查 UID 是否已存在 (幂等性)
- stmt = select(VasEmail).where(VasEmail.uid == data.uid)
- existing = (await db.execute(stmt)).scalar_one_or_none()
- if existing:
- return existing
- # 2. 存入邮件记录
- rec = VasEmail(
- uid=data.uid,
- subject=data.subject,
- sender=data.sender,
- recipient=data.recipient,
- receive_time=data.receive_time,
- body_text=data.body_text,
- )
- db.add(rec)
-
- # 3. 拦截、匹配订单并创建订单事件 (此时还在同一个事务中)
- await EmailsService._intercept(db, rec)
-
- # 4. 统一提交
- await db.commit()
- await db.refresh(rec)
-
- return rec
- @staticmethod
- async def get_max_uid(db: AsyncSession) -> int:
- stmt = select(func.max(VasEmail.uid))
- return await db.scalar(stmt) or 0
- @staticmethod
- async def _intercept(db: AsyncSession, rec: VasEmail) -> None:
- """
- 拦截处理逻辑:
- 1. 黑名单过滤
- 2. 创建订单事件 (OrderEventService)
- """
- if EmailsService._is_subject_blacklisted(rec.subject or ""):
- logger.info(f"Email {rec.uid} skipped: subject '{rec.subject}' is in blacklist.")
- return
-
- if EmailsService._is_sender_blacklisted(rec.sender or ""):
- logger.info(f"Email {rec.uid} skipped: sender '{rec.sender}' is in blacklist.")
- return
- # 尝试创建订单事件 (OrderEventService 内部会根据 rec.recipient 匹配订单)
- try:
- event = await OrderEventService.create(
- db,
- VasOrderEventCreate(
- order_no=None, # 由 OrderEventService 内部填充
- alias_email=rec.recipient,
- event_title=rec.subject or "Email Update",
- event_message=rec.body_text,
- email_uid=rec.uid,
- event_time=None,
- ),
- )
- if event and event.order_no:
- logger.info(f"Email {rec.uid} intercepted and logged to Order {event.order_no}.")
- else:
- logger.info(f"Email {rec.uid} logged, but no matching active order found for {rec.recipient}.")
- except Exception as e:
- logger.warning(f"Failed to create order event for email {rec.uid}: {e}")
- return
|