order_service.py 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533
  1. # app/services/order_service.py
  2. import uuid
  3. import json
  4. from datetime import datetime, timedelta
  5. from typing import List, Optional
  6. from redis.asyncio import Redis
  7. from sqlalchemy.ext.asyncio import AsyncSession
  8. from sqlalchemy import select
  9. from app.core.logger import logger
  10. from app.utils.search import apply_keyword_search_stmt
  11. from app.utils.pagination import paginate
  12. from app.core.biz_exception import NotFoundError, BizLogicError, PermissionDeniedError
  13. from app.models.user import VasUser
  14. from app.models.order import VasOrder
  15. from app.models.vas_task import VasTask
  16. from app.models.product import VasProduct
  17. from app.models.payment import VasPayment
  18. from app.models.agency import VasAgency
  19. from app.schemas.order import VasOrderCreate, VasOrderCreateAdmin, VasOrderAdjustPrice, VasOrderPatchUserInputs, VasOrderUpdate, VasOrderRegisterPayment
  20. from app.services.webhook_service import WebhookService
  21. from app.services.agency_service import AgencyService
  22. class OrderService:
  23. @staticmethod
  24. async def create(
  25. db: AsyncSession,
  26. data: VasOrderCreate,
  27. product: VasProduct,
  28. auth_user: VasUser,
  29. redis_client: Redis,
  30. ) -> VasOrder:
  31. """
  32. 前台散客自主下单 (公海订单)
  33. """
  34. if not auth_user.email:
  35. raise BizLogicError(
  36. "Your account must be linked to an email address before you can place an order."
  37. )
  38. order_id = f"ORD-{datetime.utcnow():%Y%m%d%H%M%S}-{uuid.uuid4().hex[:8]}"
  39. safe_product_name = (product.title[:100]) if product.title else ""
  40. order = VasOrder(
  41. id=order_id,
  42. **data.dict(),
  43. product_name=safe_product_name,
  44. base_amount=product.price_amount,
  45. base_currency=product.price_currency,
  46. adjustment_delta=0,
  47. final_amount=product.price_amount,
  48. user_id=auth_user.id,
  49. channel_type='website', # 官网公海
  50. handler_id=None, # 无专人对接,销售提成甲乙双方对半平分
  51. developer_id=None, # 订单不硬绑开发者ID,由商品绑定插件动态解析技术分成归属
  52. settlement_status='unsettled',
  53. )
  54. db.add(order)
  55. await db.commit()
  56. await db.refresh(order)
  57. logger.info(f"📦 [ORDER] Created website order: id={order.id} product={product.id} user={auth_user.id} amount={order.final_amount} {order.base_currency}")
  58. return order
  59. @staticmethod
  60. async def create_by_admin(
  61. db: AsyncSession,
  62. data: VasOrderCreateAdmin,
  63. product: VasProduct,
  64. auth_user: VasUser
  65. ) -> VasOrder:
  66. """
  67. 后台管理员/客服代客录单 (支持社交自收直客 与 中介渠道同行单)
  68. """
  69. channel_type = data.channel_type or "direct"
  70. agency_id = data.agency_id if channel_type == "agency" else None
  71. # 确定金额与收款时机
  72. final_amount = data.final_amount if (data.final_amount is not None and data.final_amount > 0) else product.price_amount
  73. timing = getattr(data, "payment_timing", "pay_later") or "pay_later"
  74. is_paid_now = (timing == "paid_now")
  75. initial_status = "paid" if is_paid_now else "pending"
  76. # 渠道判定与底价拦截
  77. if channel_type == "agency":
  78. if not agency_id:
  79. raise BizLogicError("Agency channel orders must specify agency_id")
  80. agency = await AgencyService.get(db, agency_id)
  81. if not agency:
  82. raise BizLogicError(f"Agency not found: {agency_id}")
  83. if agency.status != 1:
  84. raise BizLogicError(f"Agency '{agency.name}' is currently suspended")
  85. # 专属对接人绑定 (中介拓展人独享40%提成)
  86. handler_id = agency.owner_id
  87. # 底价校验
  88. effective_floor = agency.min_floor_price if agency.min_floor_price > 0 else (getattr(product, 'min_floor_price', 0) or 0)
  89. if effective_floor > 0 and final_amount < effective_floor:
  90. raise BizLogicError(f"Agency order amount ({final_amount/100:.2f}) cannot be lower than the minimum floor price ({effective_floor/100:.2f})")
  91. else:
  92. # 社交账号自收直客单 (小红书/微信私域): 默认录单人自己,亦可指定团队接单人
  93. handler_id = data.handler_id or auth_user.id
  94. order_id = f"ORD-{datetime.utcnow():%Y%m%d%H%M%S}-{uuid.uuid4().hex[:8]}"
  95. safe_product_name = (product.title[:100]) if product.title else ""
  96. order = VasOrder(
  97. id=order_id,
  98. product_id=data.product_id,
  99. user_inputs=data.user_inputs,
  100. status=initial_status,
  101. product_name=safe_product_name,
  102. base_amount=product.price_amount,
  103. base_currency=product.price_currency,
  104. adjustment_delta=final_amount - product.price_amount,
  105. final_amount=final_amount,
  106. user_id=auth_user.id,
  107. channel_type=channel_type,
  108. agency_id=agency_id,
  109. handler_id=handler_id,
  110. developer_id=None, # 订单不硬绑开发者ID,由商品绑定插件动态解析技术分成归属
  111. settlement_status='unsettled',
  112. )
  113. # ===== user_inputs 安全修复与审计 =====
  114. raw_inputs = order.user_inputs
  115. if isinstance(raw_inputs, str):
  116. try:
  117. order.user_inputs = json.loads(raw_inputs)
  118. except Exception:
  119. order.user_inputs = {}
  120. elif raw_inputs is None or not isinstance(raw_inputs, dict):
  121. order.user_inputs = {}
  122. order.user_inputs["_admin_bypass"] = {
  123. "enabled": True,
  124. "by": auth_user.id,
  125. "at": datetime.utcnow().isoformat(),
  126. "reason": "admin manual order",
  127. "channel_type": channel_type,
  128. "handler_id": handler_id,
  129. "payment_timing": timing,
  130. }
  131. db.add(order)
  132. # 若当场全款已付,则同步生成核销入账流水
  133. if is_paid_now:
  134. provider = data.payment_method or "offline"
  135. payment = VasPayment(
  136. order_id=order.id,
  137. provider=provider,
  138. channel="admin_manual",
  139. payment_intent_id=f"MANUAL-{datetime.utcnow():%Y%m%d%H%M%S}-{uuid.uuid4().hex[:6]}",
  140. external_trade_no=data.external_trade_no,
  141. status="succeeded",
  142. base_amount=product.price_amount,
  143. adjustment_delta=final_amount - product.price_amount,
  144. final_amount=final_amount,
  145. base_currency=product.price_currency,
  146. amount=final_amount,
  147. currency=product.price_currency,
  148. random_offset=0,
  149. exchange_rate=1.0,
  150. provider_payload={
  151. "timing": "paid_now",
  152. "note": data.payment_note or "代客录单当场全款结清",
  153. "voucher_url": data.voucher_url,
  154. "registered_by": auth_user.id,
  155. "registered_by_name": getattr(auth_user, "name", auth_user.id),
  156. "registered_at": datetime.utcnow().isoformat(),
  157. },
  158. )
  159. db.add(payment)
  160. # 记录收款凭证审计记录至订单 user_inputs
  161. user_inputs = dict(order.user_inputs or {})
  162. history = list(user_inputs.get("_payments_history", []))
  163. history.append({
  164. "amount": final_amount,
  165. "provider": provider,
  166. "external_trade_no": data.external_trade_no,
  167. "voucher_url": data.voucher_url,
  168. "note": data.payment_note or "代客录单当场全款结清",
  169. "by": auth_user.id,
  170. "at": datetime.utcnow().isoformat(),
  171. })
  172. user_inputs["_payments_history"] = history
  173. order.user_inputs = user_inputs
  174. # 无论先办后付还是当场现结,抢单任务均立即入队调度!
  175. await WebhookService._create_task_if_not_exists(db, order)
  176. await db.commit()
  177. await db.refresh(order)
  178. logger.info(f"👑 [ORDER] Admin created order: id={order.id} product={product.id} channel={channel_type} timing={timing} status={initial_status} amount={final_amount}")
  179. return order
  180. @staticmethod
  181. async def register_payment(
  182. db: AsyncSession,
  183. payload: VasOrderRegisterPayment,
  184. current_user: VasUser,
  185. ) -> VasOrder:
  186. """
  187. 管理员/客服对订单进行实收金额登记与核销入账 (适用于先办后付尾款或线下补款)
  188. """
  189. stmt = select(VasOrder).where(VasOrder.id == payload.order_id)
  190. order = (await db.execute(stmt)).scalar_one_or_none()
  191. if not order:
  192. raise NotFoundError(f"Order not found: {payload.order_id}")
  193. if payload.amount <= 0:
  194. raise BizLogicError("Payment amount must be greater than 0")
  195. # 检查中介底价拦截
  196. if order.channel_type == "agency" and order.agency_id:
  197. agency = await AgencyService.get(db, order.agency_id)
  198. if agency and agency.min_floor_price > 0 and payload.amount < agency.min_floor_price:
  199. raise BizLogicError(
  200. f"Registered amount (¥{payload.amount/100:.2f}) is below agency minimum floor settlement price (¥{agency.min_floor_price/100:.2f})"
  201. )
  202. order.final_amount = payload.amount
  203. order.adjustment_delta = payload.amount - order.base_amount
  204. # 状态流转: 若原先为 pending 待付款,直接转为 paid
  205. if order.status == "pending":
  206. order.status = "paid"
  207. # 若订单已是 completed 状态,且此前未进入 eligible,更新为 eligible
  208. if order.status == "completed" and order.settlement_status == "unsettled":
  209. order.settlement_status = "eligible"
  210. # 生成成功支付流水记录
  211. payment = VasPayment(
  212. order_id=order.id,
  213. provider=payload.payment_method or "offline",
  214. channel="admin_manual",
  215. payment_intent_id=f"MANUAL-{datetime.utcnow():%Y%m%d%H%M%S}-{uuid.uuid4().hex[:6]}",
  216. external_trade_no=payload.external_trade_no,
  217. status="succeeded",
  218. base_amount=order.base_amount,
  219. adjustment_delta=order.adjustment_delta,
  220. final_amount=payload.amount,
  221. base_currency=order.base_currency,
  222. amount=payload.amount,
  223. currency=order.base_currency,
  224. random_offset=0,
  225. exchange_rate=1.0,
  226. provider_payload={
  227. "timing": "post_pay_registered",
  228. "note": payload.note or "代客下单后置收款登记",
  229. "voucher_url": payload.voucher_url,
  230. "registered_by": current_user.id,
  231. "registered_by_name": getattr(current_user, "name", current_user.id),
  232. "registered_at": datetime.utcnow().isoformat(),
  233. },
  234. )
  235. db.add(payment)
  236. # 审计日志追加
  237. user_inputs = order.user_inputs or {}
  238. if not isinstance(user_inputs, dict):
  239. try:
  240. user_inputs = json.loads(user_inputs)
  241. except Exception:
  242. user_inputs = {}
  243. history = user_inputs.get("_payments_history", [])
  244. history.append({
  245. "amount": payload.amount,
  246. "provider": payload.payment_method,
  247. "external_trade_no": payload.external_trade_no,
  248. "voucher_url": payload.voucher_url,
  249. "note": payload.note,
  250. "by": current_user.id,
  251. "at": datetime.utcnow().isoformat(),
  252. })
  253. user_inputs["_payments_history"] = history
  254. order.user_inputs = user_inputs
  255. await db.commit()
  256. await db.refresh(order)
  257. logger.info(
  258. f"💰 [ORDER] Registered payment for order {order.id}: "
  259. f"amount={payload.amount} method={payload.payment_method} by={current_user.id}"
  260. )
  261. return order
  262. @staticmethod
  263. async def cancel(
  264. db: AsyncSession,
  265. order_id: str,
  266. ) -> VasOrder:
  267. stmt = select(VasOrder).where(VasOrder.id == order_id)
  268. order = (await db.execute(stmt)).scalar_one_or_none()
  269. if not order:
  270. raise NotFoundError("Order not exist")
  271. order.status = "closed"
  272. order.settlement_status = "unsettled"
  273. task_res = await db.execute(
  274. select(VasTask).where(
  275. VasTask.order_id == order.id,
  276. VasTask.status.in_(["pending", "grabbed", "running", "pause", "completed"]),
  277. )
  278. )
  279. for task in task_res.scalars().all():
  280. task.status = "cancelled"
  281. await db.commit()
  282. await db.refresh(order)
  283. logger.info(f"🚫 [ORDER] Cancelled order: id={order.id} and its associated tasks")
  284. return order
  285. @staticmethod
  286. async def mark_completed(
  287. db: AsyncSession,
  288. order_id: str,
  289. risk_days: int = 7
  290. ) -> VasOrder:
  291. """
  292. 履约成功完成订单,并自动开启 T+N 退款风险期
  293. """
  294. stmt = select(VasOrder).where(VasOrder.id == order_id)
  295. order = (await db.execute(stmt)).scalar_one_or_none()
  296. if not order:
  297. raise NotFoundError("Order not exist")
  298. now = datetime.utcnow()
  299. order.status = "completed"
  300. order.completed_at = now
  301. order.risk_cleared_at = now + timedelta(days=risk_days)
  302. order.settlement_status = "eligible"
  303. await db.commit()
  304. await db.refresh(order)
  305. logger.info(f"🎉 [ORDER] Order completed: id={order.id}, risk cleared at: {order.risk_cleared_at}")
  306. return order
  307. @staticmethod
  308. async def adjust_order_price(db: AsyncSession, order_id: str, payload: VasOrderAdjustPrice) -> VasOrder:
  309. stmt = select(VasOrder).where(VasOrder.id == order_id)
  310. order = (await db.execute(stmt)).scalar_one_or_none()
  311. if not order:
  312. logger.warning(f"⚠️ [ORDER] Price adjust failed: Order {order_id} not found")
  313. raise NotFoundError("Order not exist")
  314. if order.status != "pending":
  315. logger.warning(f"⚠️ [ORDER] Price adjust failed: Order {order_id} status is {order.status} (expected pending)")
  316. raise BizLogicError(message="Order not adjustable")
  317. new_final = order.base_amount + payload.adjustment_delta
  318. if new_final <= 0:
  319. raise BizLogicError(message="final_amount must be > 0")
  320. order.adjustment_delta = payload.adjustment_delta
  321. order.final_amount = new_final
  322. # 是否已有 pending payment
  323. stmt = select(VasPayment).where(
  324. VasPayment.order_id == order.id,
  325. VasPayment.status == "pending",
  326. )
  327. active_payment = (await db.execute(stmt)).scalar_one_or_none()
  328. if active_payment:
  329. active_payment.status = "expired"
  330. await db.commit()
  331. await db.refresh(order)
  332. logger.info(f"💰 [ORDER] Adjusted order price: id={order.id} new={order.final_amount} delta={payload.adjustment_delta}")
  333. return order
  334. @staticmethod
  335. async def get(db: AsyncSession, order_id: str) -> Optional[VasOrder]:
  336. stmt = select(VasOrder).where(VasOrder.id == order_id)
  337. return (await db.execute(stmt)).scalar_one_or_none()
  338. @staticmethod
  339. async def get_authorized_order(
  340. db: AsyncSession,
  341. order_id: str,
  342. current_user: VasUser
  343. ) -> VasOrder:
  344. order = await OrderService.get(db, order_id)
  345. if not order:
  346. raise NotFoundError("Order not found")
  347. if current_user.role != "admin" and str(order.user_id) != str(current_user.id):
  348. raise PermissionDeniedError("Permission denied: You do not have access to this order")
  349. return order
  350. @staticmethod
  351. async def list_by_user(
  352. db: AsyncSession,
  353. user_id: str,
  354. page: int = 0,
  355. size: int = 10,
  356. keyword: Optional[str] = None,
  357. ):
  358. stmt = select(VasOrder).where(VasOrder.user_id == user_id)
  359. stmt = apply_keyword_search_stmt(
  360. stmt=stmt,
  361. model=VasOrder,
  362. keyword=keyword,
  363. fields=["id", "user_id", "product_name", "user_inputs"],
  364. ).order_by(VasOrder.created_at.desc())
  365. return await paginate(db, stmt, page, size)
  366. @staticmethod
  367. async def list_all(
  368. db: AsyncSession,
  369. page: int = 0,
  370. size: int = 10,
  371. keyword: Optional[str] = None,
  372. channel_type: Optional[str] = None,
  373. handler_id: Optional[str] = None,
  374. settlement_status: Optional[str] = None,
  375. ):
  376. stmt = select(VasOrder)
  377. if channel_type:
  378. stmt = stmt.where(VasOrder.channel_type == channel_type)
  379. if handler_id:
  380. stmt = stmt.where(VasOrder.handler_id == handler_id)
  381. if settlement_status:
  382. stmt = stmt.where(VasOrder.settlement_status == settlement_status)
  383. query = apply_keyword_search_stmt(
  384. stmt=stmt,
  385. model=VasOrder,
  386. keyword=keyword,
  387. fields=["id", "user_id", "user_name", "product_name", "user_inputs", "handler_id", "agency_id"],
  388. ).order_by(VasOrder.created_at.desc())
  389. return await paginate(db, query, page, size)
  390. @staticmethod
  391. async def patch_user_inputs(
  392. db: AsyncSession,
  393. order_id: str,
  394. payload: VasOrderPatchUserInputs,
  395. ) -> VasOrder:
  396. stmt = select(VasOrder).where(VasOrder.id == order_id)
  397. order = (await db.execute(stmt)).scalar_one_or_none()
  398. if not order:
  399. logger.warning(f"⚠️ [ORDER] Patch user_inputs failed: Order {order_id} not found")
  400. raise NotFoundError("Order not exist")
  401. order.user_inputs = payload.user_inputs
  402. # 取消旧任务
  403. task_res = await db.execute(
  404. select(VasTask).where(
  405. VasTask.order_id == order.id,
  406. VasTask.status.in_(["pending", "grabbed", "running", "pause", "completed"]),
  407. )
  408. )
  409. for task in task_res.scalars().all():
  410. task.status = "cancelled"
  411. await db.flush()
  412. await WebhookService._create_task_if_not_exists(db, order)
  413. await db.commit()
  414. await db.refresh(order)
  415. logger.info(f"🔄 [ORDER] Patched user inputs for order {order.id}, recreated tasks")
  416. return order
  417. @staticmethod
  418. async def update_order(
  419. db: AsyncSession,
  420. order_id: str,
  421. data: VasOrderUpdate,
  422. ) -> VasOrder:
  423. stmt = select(VasOrder).where(VasOrder.id == order_id)
  424. order = (await db.execute(stmt)).scalar_one_or_none()
  425. if not order:
  426. logger.warning(f"⚠️ [ORDER] Update failed: Order {order_id} not found")
  427. raise NotFoundError("Order not exist")
  428. if data.channel_type is not None:
  429. order.channel_type = data.channel_type
  430. if data.channel_type == "agency":
  431. if data.agency_id is not None:
  432. order.agency_id = data.agency_id.strip() if data.agency_id else None
  433. if data.handler_id is not None:
  434. order.handler_id = data.handler_id.strip() if data.handler_id else None
  435. elif order.agency_id:
  436. agency = await AgencyService.get(db, order.agency_id)
  437. if agency and agency.owner_id:
  438. order.handler_id = agency.owner_id
  439. elif data.channel_type == "direct":
  440. order.agency_id = None
  441. if data.handler_id is not None:
  442. order.handler_id = data.handler_id.strip() if data.handler_id else None
  443. elif data.channel_type == "website":
  444. order.agency_id = None
  445. if data.handler_id is not None:
  446. order.handler_id = data.handler_id.strip() if data.handler_id else None
  447. else:
  448. if data.agency_id is not None:
  449. order.agency_id = data.agency_id.strip() if data.agency_id else None
  450. if data.handler_id is not None:
  451. order.handler_id = data.handler_id.strip() if data.handler_id else None
  452. if data.status is not None:
  453. order.status = data.status
  454. if data.user_inputs is not None:
  455. order.user_inputs = data.user_inputs
  456. task_res = await db.execute(
  457. select(VasTask).where(
  458. VasTask.order_id == order.id,
  459. VasTask.status.in_(["pending", "grabbed", "running", "pause", "completed"]),
  460. )
  461. )
  462. for task in task_res.scalars().all():
  463. task.status = "cancelled"
  464. await db.flush()
  465. await WebhookService._create_task_if_not_exists(db, order)
  466. await db.commit()
  467. await db.refresh(order)
  468. logger.info(f"🔄 [ORDER] Admin updated order: id={order.id} channel={order.channel_type} handler={order.handler_id} agency={order.agency_id}")
  469. return order