webhook_service.py 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492
  1. import re
  2. import json
  3. from datetime import datetime, timedelta
  4. from typing import List, Optional
  5. from decimal import Decimal
  6. from sqlalchemy.ext.asyncio import AsyncSession
  7. from sqlalchemy import select
  8. from app.core.logger import logger
  9. from app.core.biz_exception import NotFoundError, BizLogicError
  10. from app.models.order import VasOrder
  11. from app.models.vas_task import VasTask
  12. from app.models.product_routing import VasProductRouting
  13. from app.models.payment_event import VasPaymentEvent
  14. from app.models.payment import VasPayment
  15. from app.models.payment_qr import VasPaymentQR
  16. from app.schemas.webhook import SMSHelperWebhookPayload, PaymentWebhookOut
  17. class WebhookService:
  18. # =========================================================
  19. # 内部方法:创建 Task(幂等)
  20. # =========================================================
  21. @staticmethod
  22. async def _create_task_if_not_exists(
  23. db: AsyncSession,
  24. order: VasOrder,
  25. ) -> List[VasTask]:
  26. # 1. 查询路由配置
  27. stmt = select(VasProductRouting).where(
  28. VasProductRouting.product_id == order.product_id,
  29. VasProductRouting.is_active == 1,
  30. )
  31. result = await db.execute(stmt)
  32. routings = result.scalars().all()
  33. if not routings:
  34. return []
  35. created_tasks: List[VasTask] = []
  36. # --- 别名邮箱生成逻辑开始 ---
  37. # 提取原始邮箱用户名
  38. user_inputs = order.user_inputs or {}
  39. original_email = str(user_inputs.get("email", "user")).strip()
  40. base_user = original_email.split('@')[0] if '@' in original_email else original_email
  41. if not base_user:
  42. base_user = "user"
  43. # 计算稳定的域名索引 (基于原始用户名)
  44. DOMAINS = [
  45. "gmail-app.com",
  46. "outlooksearch.com",
  47. "hotmails.vip",
  48. "gmail365.cc",
  49. "ymails.top",
  50. "teamymail.cfd"
  51. ]
  52. h = 0
  53. for ch in base_user:
  54. h = (31 * h + ord(ch)) & 0xFFFFFFFF
  55. if h & 0x80000000: # 模拟 Java 有符号 32 位 int
  56. h = -((~h + 1) & 0xFFFFFFFF)
  57. domain_index = abs(h) % len(DOMAINS)
  58. selected_domain = DOMAINS[domain_index]
  59. # 提取 Order ID 后两位作为唯一后缀
  60. order_id_str = str(order.id)
  61. suffix = order_id_str[-2:] if len(order_id_str) >= 2 else order_id_str
  62. # 组合最终别名
  63. final_alias_email = f"{base_user}{suffix}@{selected_domain}"
  64. # --- 别名邮箱生成逻辑结束 ---
  65. for routing in routings:
  66. # 幂等检查
  67. exists_stmt = select(VasTask).where(
  68. VasTask.order_id == order.id,
  69. VasTask.routing_key == routing.routing_key,
  70. VasTask.status.in_(["pending", "grabbed", "running", "pause", "completed"]),
  71. )
  72. exists_result = await db.execute(exists_stmt)
  73. exists = exists_result.scalar_one_or_none()
  74. if exists:
  75. continue
  76. # 构造任务配置,合并路由默认配置与动态生成的 alias_email
  77. # 如果 routing.config 已经有内容,我们覆盖其中的关键字段
  78. task_config = (routing.config or {}).copy()
  79. task_config.update({
  80. "alias_email": final_alias_email,
  81. "include_today": True,
  82. "include_tomorrow": True,
  83. "time_filter": ["AM", "PM"],
  84. "exclude_dates": [],
  85. "allowed_weekdays": [1, 2, 3, 4, 5],
  86. "select": "random"
  87. })
  88. task = VasTask(
  89. order_id=order.id,
  90. routing_key=routing.routing_key,
  91. script_version=routing.script_version,
  92. priority=routing.priority,
  93. status="pending",
  94. user_inputs=order.user_inputs,
  95. config=task_config, # 使用新生成的配置
  96. attempt_count=0,
  97. notify_count=0,
  98. expire_at=datetime.utcnow() + timedelta(days=60),
  99. created_at=datetime.utcnow(),
  100. )
  101. db.add(task)
  102. await db.flush()
  103. await db.refresh(task)
  104. created_tasks.append(task)
  105. return created_tasks
  106. # =========================================================
  107. # SMSHelper 微信 / 支付宝 收款 webhook
  108. # =========================================================
  109. @staticmethod
  110. async def smshelper_payment_webhook(
  111. db: AsyncSession,
  112. payload: SMSHelperWebhookPayload,
  113. ) -> Optional[PaymentWebhookOut]:
  114. title = payload.title
  115. content = payload.content
  116. if "微信" in title:
  117. provider = "wechat"
  118. elif "支付宝" in title:
  119. provider = "alipay"
  120. else:
  121. raise BizLogicError("Unknown payment provider")
  122. device_match = re.search(r"【(.+?)】", content)
  123. device_id = device_match.group(1) if device_match else None
  124. amount_match = re.search(r"¥([\d.]+)", content)
  125. if not amount_match:
  126. raise BizLogicError("Amount not found in webhook content")
  127. amount_yuan = Decimal(amount_match.group(1))
  128. amount_cent = int(amount_yuan * 100)
  129. # 修正点:实例化 Event 时字段名需匹配模型
  130. event = VasPaymentEvent(
  131. provider=provider,
  132. event_type="payment_received",
  133. title=title,
  134. content=content,
  135. parsed_amount=amount_cent,
  136. parsed_currency="CNY",
  137. parsed_device=device_id,
  138. raw_payload=payload.dict(), # 对应模型 raw_payload
  139. status="received",
  140. )
  141. db.add(event)
  142. await db.commit()
  143. await db.refresh(event)
  144. # ---------- 查找 QR ----------
  145. qr_stmt = select(VasPaymentQR).where(
  146. VasPaymentQR.provider == provider,
  147. VasPaymentQR.device == device_id,
  148. VasPaymentQR.is_active == 1,
  149. )
  150. qr_result = await db.execute(qr_stmt)
  151. payment_qr = qr_result.scalar_one_or_none()
  152. if not payment_qr:
  153. event.status = "failed"
  154. event.error_message = "QR not found"
  155. await db.commit()
  156. raise BizLogicError("QR not found")
  157. # ---------- 查找 payment ----------
  158. pay_stmt = (
  159. select(VasPayment)
  160. .where(
  161. VasPayment.provider == provider,
  162. VasPayment.amount == amount_cent,
  163. VasPayment.qr_id == payment_qr.id,
  164. VasPayment.status == "pending",
  165. )
  166. .order_by(VasPayment.created_at.desc())
  167. )
  168. pay_result = await db.execute(pay_stmt)
  169. payment = pay_result.scalar_one_or_none()
  170. if not payment:
  171. event.status = "failed"
  172. event.error_message = "No matching pending payment"
  173. await db.commit()
  174. raise BizLogicError("Payment not found")
  175. if payment.status in ("succeeded", "late_paid"):
  176. event.status = "duplicate"
  177. event.matched_payment_id = payment.id
  178. event.matched_order_id = payment.order_id
  179. await db.commit()
  180. return None
  181. now = datetime.utcnow()
  182. payment.status = "late_paid" if payment.expire_at and now > payment.expire_at else "succeeded"
  183. payment.provider_payload = {
  184. "title": title,
  185. "content": content,
  186. "device_id": device_id,
  187. "received_at": now.isoformat(),
  188. }
  189. order_stmt = select(VasOrder).where(VasOrder.id == payment.order_id)
  190. order_result = await db.execute(order_stmt)
  191. order = order_result.scalar_one_or_none()
  192. if order and order.status != "paid":
  193. order.status = "paid"
  194. await WebhookService._create_task_if_not_exists(db, order)
  195. event.status = "applied"
  196. event.matched_payment_id = payment.id
  197. event.matched_order_id = payment.order_id
  198. await db.commit()
  199. await db.refresh(payment)
  200. logger.info(f"🔔 [WEBHOOK] SMSHelper matched payment {payment.id} for order {order.id} status={payment.status}")
  201. return PaymentWebhookOut(
  202. status=True,
  203. order_id=order.id,
  204. user_id=order.user_id,
  205. payment_id=payment.id,
  206. notify=True,
  207. )
  208. # =========================================================
  209. # Stripe webhook
  210. # =========================================================
  211. @staticmethod
  212. async def stripe_payment_webhook(
  213. db: AsyncSession,
  214. event: dict,
  215. ) -> Optional[PaymentWebhookOut]:
  216. event_id = event["id"]
  217. event_type = event["type"]
  218. data = event["data"]["object"]
  219. existed_stmt = select(VasPaymentEvent).where(
  220. VasPaymentEvent.provider == "stripe",
  221. VasPaymentEvent.event_id == event_id,
  222. )
  223. existed_result = await db.execute(existed_stmt)
  224. if existed_result.scalar_one_or_none():
  225. logger.info(f"🔔 [WEBHOOK] Stripe duplicate event ignored: {event_id}")
  226. return None
  227. if event_type != "checkout.session.completed":
  228. db.add(
  229. VasPaymentEvent(
  230. provider="stripe",
  231. event_id=event_id,
  232. event_type=event_type,
  233. raw_payload=event,
  234. created_at=datetime.utcnow(),
  235. status="ignored"
  236. )
  237. )
  238. await db.commit()
  239. return None
  240. metadata = data.get("metadata", {})
  241. payment_id = metadata.get("payment_id")
  242. order_id = metadata.get("order_id")
  243. if not payment_id or not order_id:
  244. logger.error(f"❌ [WEBHOOK] Missing payment_id or order_id in Stripe metadata for event {event_id}")
  245. raise BizLogicError("Missing payment_id or order_id in metadata")
  246. pay_stmt = select(VasPayment).where(VasPayment.id == int(payment_id))
  247. pay_result = await db.execute(pay_stmt)
  248. payment = pay_result.scalar_one_or_none()
  249. if not payment:
  250. logger.error(f"❌ [WEBHOOK] Stripe payment {payment_id} not found")
  251. raise NotFoundError("Payment not found")
  252. if payment.status == "succeeded":
  253. db.add(
  254. VasPaymentEvent(
  255. provider="stripe",
  256. event_id=event_id,
  257. event_type=event_type,
  258. matched_payment_id=payment.id,
  259. raw_payload=event,
  260. status="duplicate",
  261. created_at=datetime.utcnow(),
  262. )
  263. )
  264. await db.commit()
  265. logger.info(f"🔔 [WEBHOOK] Stripe payment {payment_id} already succeeded (duplicate event)")
  266. return None
  267. paid_amount = data["amount_total"]
  268. paid_currency = data["currency"].upper()
  269. if paid_amount != payment.amount or paid_currency != payment.currency:
  270. logger.error(f"❌ [WEBHOOK] Stripe amount mismatch: expected {payment.amount} {payment.currency}, got {paid_amount} {paid_currency}")
  271. raise BizLogicError(
  272. f"Amount mismatch, expected {payment.amount} {payment.currency}, "
  273. f"got {paid_amount} {paid_currency}"
  274. )
  275. now = datetime.utcnow()
  276. payment.status = "late_paid" if payment.expire_at and now > payment.expire_at else "succeeded"
  277. payment.provider_payload = event
  278. payment.updated_at = now
  279. order_stmt = select(VasOrder).where(VasOrder.id == order_id)
  280. order_result = await db.execute(order_stmt)
  281. order = order_result.scalar_one_or_none()
  282. if order and order.status != "paid":
  283. order.status = "paid"
  284. order.updated_at = now
  285. await WebhookService._create_task_if_not_exists(db, order)
  286. db.add(
  287. VasPaymentEvent(
  288. provider="stripe",
  289. event_id=event_id,
  290. event_type=event_type,
  291. matched_payment_id=payment.id,
  292. matched_order_id=order_id,
  293. raw_payload=event,
  294. status="applied",
  295. created_at=now,
  296. )
  297. )
  298. await db.commit()
  299. await db.refresh(payment)
  300. logger.info(f"🎉 [WEBHOOK] Stripe checkout completed: order={order.id} payment={payment.id} status={payment.status}")
  301. return PaymentWebhookOut(
  302. status=True,
  303. order_id=order.id,
  304. user_id=order.user_id,
  305. payment_id=payment.id,
  306. notify=True,
  307. )
  308. # =========================================================
  309. # Creem webhook
  310. # =========================================================
  311. @staticmethod
  312. async def creem_payment_webhook(
  313. db: AsyncSession,
  314. event: dict,
  315. ) -> Optional[PaymentWebhookOut]:
  316. event_id = event.get("id") or event.get("event_id")
  317. event_type = event.get("eventType") or event.get("event") or event.get("type")
  318. obj = event.get("object") or event.get("data") or event
  319. if not event_id:
  320. logger.error("❌ [WEBHOOK] Missing event id in Creem webhook")
  321. return None
  322. # 1. 幂等性去重
  323. existed_stmt = select(VasPaymentEvent).where(
  324. VasPaymentEvent.provider == "creem",
  325. VasPaymentEvent.event_id == event_id,
  326. )
  327. existed_result = await db.execute(existed_stmt)
  328. if existed_result.scalar_one_or_none():
  329. logger.info(f"🔔 [WEBHOOK] Creem duplicate event ignored: {event_id}")
  330. return None
  331. # 2. 仅在 checkout.completed 或 subscription.paid 时核销支付
  332. if event_type not in ("checkout.completed", "subscription.paid"):
  333. db.add(
  334. VasPaymentEvent(
  335. provider="creem",
  336. event_id=event_id,
  337. event_type=event_type or "unknown",
  338. raw_payload=event,
  339. created_at=datetime.utcnow(),
  340. status="ignored"
  341. )
  342. )
  343. await db.commit()
  344. return None
  345. metadata = obj.get("metadata", {})
  346. payment_id = metadata.get("payment_id")
  347. order_id = metadata.get("order_id")
  348. # 尝试从 request_id (例如 order_123_pay_456) 解析
  349. if not payment_id or not order_id:
  350. request_id = obj.get("request_id", "")
  351. if request_id.startswith("order_") and "_pay_" in request_id:
  352. parts = request_id.split("_")
  353. try:
  354. order_id = parts[1]
  355. payment_id = parts[3]
  356. except Exception:
  357. pass
  358. if not payment_id or not order_id:
  359. logger.error(f"❌ [WEBHOOK] Missing payment_id or order_id in Creem metadata for event {event_id}")
  360. raise BizLogicError("Missing payment_id or order_id in metadata")
  361. pay_stmt = select(VasPayment).where(VasPayment.id == int(payment_id))
  362. pay_result = await db.execute(pay_stmt)
  363. payment = pay_result.scalar_one_or_none()
  364. if not payment:
  365. logger.error(f"❌ [WEBHOOK] Creem payment {payment_id} not found")
  366. raise NotFoundError("Payment not found")
  367. if payment.status == "succeeded":
  368. db.add(
  369. VasPaymentEvent(
  370. provider="creem",
  371. event_id=event_id,
  372. event_type=event_type,
  373. matched_payment_id=payment.id,
  374. raw_payload=event,
  375. status="duplicate",
  376. created_at=datetime.utcnow(),
  377. )
  378. )
  379. await db.commit()
  380. logger.info(f"🔔 [WEBHOOK] Creem payment {payment_id} already succeeded (duplicate event)")
  381. return None
  382. now = datetime.utcnow()
  383. payment.status = "late_paid" if payment.expire_at and now > payment.expire_at else "succeeded"
  384. payment.provider_payload = event
  385. payment.updated_at = now
  386. order_stmt = select(VasOrder).where(VasOrder.id == int(order_id))
  387. order_result = await db.execute(order_stmt)
  388. order = order_result.scalar_one_or_none()
  389. if order and order.status != "paid":
  390. order.status = "paid"
  391. order.updated_at = now
  392. await WebhookService._create_task_if_not_exists(db, order)
  393. db.add(
  394. VasPaymentEvent(
  395. provider="creem",
  396. event_id=event_id,
  397. event_type=event_type,
  398. matched_payment_id=payment.id,
  399. matched_order_id=int(order_id),
  400. raw_payload=event,
  401. status="applied",
  402. created_at=now,
  403. )
  404. )
  405. await db.commit()
  406. await db.refresh(payment)
  407. logger.info(f"🎉 [WEBHOOK] Creem checkout completed: order={order_id} payment={payment.id} status={payment.status}")
  408. return PaymentWebhookOut(
  409. status=True,
  410. order_id=order.id,
  411. user_id=order.user_id,
  412. payment_id=payment.id,
  413. notify=True,
  414. )