cost_service.py 2.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. # app/services/cost_service.py
  2. from datetime import datetime
  3. from typing import Optional, List, Dict
  4. from sqlalchemy.ext.asyncio import AsyncSession
  5. from sqlalchemy import select, func
  6. from app.models.cost import VasCostRecord
  7. from app.schemas.cost import VasCostCreate
  8. from app.utils.pagination import paginate
  9. class CostService:
  10. @staticmethod
  11. async def create(db: AsyncSession, data: VasCostCreate, user_id: str) -> VasCostRecord:
  12. record = VasCostRecord(
  13. category=data.category,
  14. amount=data.amount,
  15. currency=data.currency,
  16. description=data.description,
  17. voucher_url=data.voucher_url,
  18. paid_at=data.paid_at or datetime.utcnow(),
  19. created_by=user_id,
  20. )
  21. db.add(record)
  22. await db.commit()
  23. await db.refresh(record)
  24. return record
  25. @staticmethod
  26. async def list_costs(
  27. db: AsyncSession,
  28. period_id: Optional[str] = None,
  29. category: Optional[str] = None,
  30. start_date: Optional[datetime] = None,
  31. end_date: Optional[datetime] = None,
  32. page: int = 0,
  33. size: int = 20,
  34. ):
  35. stmt = select(VasCostRecord)
  36. if period_id:
  37. stmt = stmt.where(VasCostRecord.period_id == period_id)
  38. if category:
  39. stmt = stmt.where(VasCostRecord.category == category)
  40. if start_date:
  41. stmt = stmt.where(VasCostRecord.paid_at >= start_date)
  42. if end_date:
  43. stmt = stmt.where(VasCostRecord.paid_at <= end_date)
  44. stmt = stmt.order_by(VasCostRecord.paid_at.desc())
  45. return await paginate(db, stmt, page, size)
  46. @staticmethod
  47. async def get_costs_summary_by_date(
  48. db: AsyncSession,
  49. start_date: datetime,
  50. end_date: datetime
  51. ) -> Dict[str, int]:
  52. """
  53. 统计时间段内各项耗材的总支出 (分)
  54. """
  55. stmt = (
  56. select(VasCostRecord.category, func.sum(VasCostRecord.amount))
  57. .where(VasCostRecord.paid_at >= start_date, VasCostRecord.paid_at <= end_date)
  58. .group_by(VasCostRecord.category)
  59. )
  60. res = await db.execute(stmt)
  61. summary = {cat: 0 for cat in ['vps', 'proxy_ip', 'captcha_api', 'sms_api', 'other']}
  62. for cat, total in res.fetchall():
  63. summary[cat] = int(total or 0)
  64. return summary