ticket_service.py 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334
  1. from datetime import datetime
  2. from typing import List, Optional
  3. from redis.asyncio import Redis
  4. from sqlalchemy import select, case
  5. from sqlalchemy.ext.asyncio import AsyncSession
  6. from app.utils.search import apply_keyword_search_stmt
  7. from app.utils.pagination import paginate
  8. from app.core.biz_exception import NotFoundError, PermissionDeniedError, BizLogicError
  9. from app.core.logger import logger
  10. from app.models.user import VasUser
  11. from app.models.order import VasOrder
  12. from app.models.vas_task import VasTask
  13. from app.models.payment import VasPayment
  14. from app.models.ticket import VasTicket
  15. from app.models.ticket_message import VasTicketMessage
  16. from app.schemas.ticket import VasTicketCreate
  17. from app.services.notification_service import NotificationService
  18. from app.services.webhook_service import WebhookService
  19. class TicketService:
  20. @staticmethod
  21. async def create(
  22. db: AsyncSession,
  23. data: VasTicketCreate,
  24. current_user: VasUser,
  25. redis_client: Redis
  26. ):
  27. # 1. 验证订单存在性及访问权限
  28. order_res = await db.execute(
  29. select(VasOrder).where(VasOrder.id == data.order_id)
  30. )
  31. order = order_res.scalar_one_or_none()
  32. if not order:
  33. raise NotFoundError("Associated order not found")
  34. if current_user.role != "admin" and str(order.user_id) != str(current_user.id):
  35. raise PermissionDeniedError("Permission denied: You do not have permission to create a ticket for this order")
  36. # 2. 一个订单只能有一个处于打开状态的工单 (pending, info_required)
  37. existing_ticket = (await db.execute(
  38. select(VasTicket).where(
  39. VasTicket.order_id == data.order_id,
  40. VasTicket.status.in_(["pending", "info_required"])
  41. )
  42. )).scalars().first()
  43. if existing_ticket:
  44. raise BizLogicError(f"An open ticket (#{existing_ticket.id}) already exists for this order. Duplicate submissions are not allowed.")
  45. ticket = VasTicket(
  46. **data.dict(),
  47. user_id=current_user.id,
  48. status="pending",
  49. created_at=datetime.utcnow(),
  50. updated_at=datetime.utcnow(),
  51. )
  52. db.add(ticket)
  53. await db.commit()
  54. await db.refresh(ticket)
  55. formatted_time = ticket.created_at.strftime('%Y-%m-%d %H:%M') + " (UTC)"
  56. await NotificationService.post_message(
  57. db=db,
  58. channel="email",
  59. payload={
  60. "template_id": "ticket_created",
  61. "receiver": current_user.email,
  62. "payload": {
  63. "app_name": "STRATA",
  64. "username": current_user.email,
  65. "ticket_id": ticket.id,
  66. "ticket_type": ticket.type,
  67. "ticket_url": "https://text.skin/dashboard",
  68. "created_at": formatted_time
  69. }
  70. },
  71. )
  72. return ticket
  73. @staticmethod
  74. async def update_status(
  75. db: AsyncSession,
  76. ticket_id: int,
  77. status: str,
  78. comment: str = "",
  79. admin_id: Optional[str] = None,
  80. user: Optional[VasUser] = None,
  81. ) -> VasTicket:
  82. result = await db.execute(
  83. select(VasTicket)
  84. .where(VasTicket.id == ticket_id)
  85. .with_for_update()
  86. )
  87. ticket = result.scalar_one_or_none()
  88. if not ticket:
  89. raise NotFoundError("Ticket not exist")
  90. effective_admin_id = admin_id or (str(user.id) if user else "system")
  91. ticket.status = status
  92. ticket.admin_comment = comment
  93. ticket.updated_at = datetime.utcnow()
  94. db.add(
  95. VasTicketMessage(
  96. ticket_id=ticket.id,
  97. sender_type="admin",
  98. sender_id=str(effective_admin_id),
  99. content=comment,
  100. created_at=datetime.utcnow(),
  101. )
  102. )
  103. if status == "resolved":
  104. await TicketService._handle_resolution(db, ticket)
  105. elif status == "rejected":
  106. await TicketService._handle_rejection(db, ticket)
  107. await db.commit()
  108. await db.refresh(ticket)
  109. # 标记解决时,自动给工单提出者发送提醒邮件
  110. if status == "resolved":
  111. try:
  112. user_stmt = select(VasUser).where(VasUser.id == ticket.user_id)
  113. ticket_user = (await db.execute(user_stmt)).scalar_one_or_none()
  114. if ticket_user and ticket_user.email:
  115. formatted_time = ticket.updated_at.strftime('%Y-%m-%d %H:%M') + " (UTC)"
  116. await NotificationService.post_message(
  117. db=db,
  118. channel="email",
  119. payload={
  120. "template_id": "ticket_resolved",
  121. "receiver": ticket_user.email,
  122. "payload": {
  123. "app_name": "STRATA",
  124. "username": ticket_user.nickname or ticket_user.email,
  125. "ticket_id": ticket.id,
  126. "order_id": ticket.order_id or "N/A",
  127. "ticket_type": ticket.type,
  128. "status": "Resolved",
  129. "resolution_comment": comment or "Your ticket has been marked as resolved by customer service.",
  130. "ticket_url": "https://text.skin/dashboard",
  131. "resolved_at": formatted_time,
  132. },
  133. },
  134. )
  135. except Exception as e:
  136. logger.error(f"Failed to post ticket resolved notification: {e}")
  137. return ticket
  138. # =========================
  139. # 工单解决逻辑
  140. # =========================
  141. @staticmethod
  142. async def _handle_resolution(
  143. db: AsyncSession,
  144. ticket: VasTicket,
  145. ) -> None:
  146. if not ticket.order_id:
  147. return
  148. result = await db.execute(
  149. select(VasOrder)
  150. .where(VasOrder.id == ticket.order_id)
  151. .with_for_update()
  152. )
  153. order = result.scalar_one_or_none()
  154. if not order:
  155. return
  156. # ---------- 退款 ----------
  157. if ticket.type == "refund":
  158. order.status = "closed"
  159. pay_res = await db.execute(
  160. select(VasPayment).where(
  161. VasPayment.order_id == order.id,
  162. VasPayment.status.in_(["succeeded", "late_paid"]),
  163. )
  164. )
  165. payment = pay_res.scalar_one_or_none()
  166. if payment:
  167. payment.status = "refunded"
  168. payment.refunded_at = datetime.utcnow()
  169. payment.refund_reason = ticket.reason
  170. task_res = await db.execute(
  171. select(VasTask).where(
  172. VasTask.order_id == order.id,
  173. VasTask.status.in_(["pending", "grabbed", "running", "pause", "completed"]),
  174. )
  175. )
  176. for task in task_res.scalars().all():
  177. task.status = "cancelled"
  178. # =========================
  179. # 工单拒绝逻辑
  180. # =========================
  181. @staticmethod
  182. async def _handle_rejection(
  183. db: AsyncSession,
  184. ticket: VasTicket,
  185. ) -> None:
  186. if not ticket.order_id:
  187. return
  188. result = await db.execute(
  189. select(VasOrder)
  190. .where(VasOrder.id == ticket.order_id)
  191. .with_for_update()
  192. )
  193. order = result.scalar_one_or_none()
  194. if not order:
  195. return
  196. # if ticket.type == "refund" and order.status == "refund_pending":
  197. # order.status = "paid"
  198. @staticmethod
  199. async def add_message(
  200. db: AsyncSession,
  201. ticket_id: int,
  202. sender_type: str, # "user" | "admin" | "system"
  203. sender_id: Optional[str] = None,
  204. content: str = "",
  205. attachments: Optional[dict] = None,
  206. ):
  207. ticket = await db.get(VasTicket, ticket_id)
  208. if not ticket:
  209. raise NotFoundError("Ticket not exist")
  210. if sender_type != "admin" and sender_id and str(ticket.user_id) != str(sender_id):
  211. raise PermissionDeniedError("Permission denied: You do not have access to this ticket")
  212. message = VasTicketMessage(
  213. ticket_id=ticket_id,
  214. sender_type=sender_type,
  215. sender_id=sender_id,
  216. content=content,
  217. attachments=attachments,
  218. created_at=datetime.utcnow(),
  219. )
  220. db.add(message)
  221. ticket.updated_at = datetime.utcnow()
  222. await db.commit()
  223. await db.refresh(message)
  224. return message
  225. @staticmethod
  226. async def list_messages(
  227. db: AsyncSession,
  228. ticket_id: int,
  229. page: int = 1,
  230. size: int = 20,
  231. current_user: Optional[VasUser] = None,
  232. ):
  233. # 校验 ticket 是否存在及权限
  234. ticket = await db.get(VasTicket, ticket_id)
  235. if not ticket:
  236. raise NotFoundError("Ticket not exist")
  237. if current_user and current_user.role != "admin" and str(ticket.user_id) != str(current_user.id):
  238. raise PermissionDeniedError("Permission denied: You do not have access to this ticket")
  239. stmt = (
  240. select(VasTicketMessage)
  241. .where(VasTicketMessage.ticket_id == ticket_id)
  242. .order_by(VasTicketMessage.created_at.desc())
  243. )
  244. return await paginate(db, stmt, page, size)
  245. @staticmethod
  246. async def list_by_user(
  247. db: AsyncSession,
  248. user_id: str,
  249. page: int = 1,
  250. size: int = 20,
  251. keyword: Optional[str] = None,
  252. ):
  253. stmt = select(VasTicket).where(VasTicket.user_id == user_id)
  254. stmt = apply_keyword_search_stmt(
  255. stmt=stmt,
  256. model=VasTicket,
  257. keyword=keyword,
  258. fields=["order_id", "user_id", "reason", "admin_comment"],
  259. )
  260. stmt = stmt.order_by(VasTicket.id.desc())
  261. return await paginate(db, stmt, page, size)
  262. @staticmethod
  263. async def list_all(
  264. db: AsyncSession,
  265. page: int = 1,
  266. size: int = 20,
  267. keyword: Optional[str] = None,
  268. ):
  269. stmt = select(VasTicket)
  270. # 关键词搜索
  271. stmt = apply_keyword_search_stmt(
  272. stmt=stmt,
  273. model=VasTicket,
  274. keyword=keyword,
  275. fields=["order_id", "user_id", "reason", "admin_comment"],
  276. )
  277. # 排序:未解决优先 ('pending','info_required') -> 0, 已解决 ('resolved','rejected') -> 1
  278. stmt = stmt.order_by(
  279. case(
  280. (VasTicket.status.in_(["pending", "info_required"]), 0),
  281. else_=1
  282. ),
  283. VasTicket.id.desc()
  284. )
  285. return await paginate(db, stmt, page, size)