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