order_service.py 24 KB

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