agency_service.py 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. # app/services/agency_service.py
  2. import uuid
  3. from typing import List, Optional
  4. from sqlalchemy.ext.asyncio import AsyncSession
  5. from sqlalchemy import select
  6. from app.models.agency import VasAgency
  7. from app.schemas.agency import VasAgencyCreate, VasAgencyUpdate
  8. from app.core.biz_exception import NotFoundError, BizLogicError
  9. from app.utils.pagination import paginate
  10. class AgencyService:
  11. @staticmethod
  12. async def create(db: AsyncSession, data: VasAgencyCreate) -> VasAgency:
  13. # 检查重名
  14. stmt = select(VasAgency).where(VasAgency.name == data.name)
  15. existing = (await db.execute(stmt)).scalar_one_or_none()
  16. if existing:
  17. raise BizLogicError(f"Agency name '{data.name}' already exists")
  18. agency_id = data.id or f"AG-{uuid.uuid4().hex[:8].upper()}"
  19. agency = VasAgency(
  20. id=agency_id,
  21. name=data.name,
  22. contact_name=data.contact_name,
  23. contact_phone=data.contact_phone,
  24. owner_id=data.owner_id,
  25. min_floor_price=data.min_floor_price,
  26. notes=data.notes,
  27. )
  28. db.add(agency)
  29. await db.commit()
  30. await db.refresh(agency)
  31. return agency
  32. @staticmethod
  33. async def get(db: AsyncSession, agency_id: str) -> Optional[VasAgency]:
  34. stmt = select(VasAgency).where(VasAgency.id == agency_id)
  35. return (await db.execute(stmt)).scalar_one_or_none()
  36. @staticmethod
  37. async def update(db: AsyncSession, agency_id: str, data: VasAgencyUpdate) -> VasAgency:
  38. agency = await AgencyService.get(db, agency_id)
  39. if not agency:
  40. raise NotFoundError("Agency not found")
  41. update_dict = data.dict(exclude_unset=True)
  42. for key, value in update_dict.items():
  43. setattr(agency, key, value)
  44. await db.commit()
  45. await db.refresh(agency)
  46. return agency
  47. @staticmethod
  48. async def list_all(db: AsyncSession, page: int = 0, size: int = 20, active_only: bool = False):
  49. stmt = select(VasAgency)
  50. if active_only:
  51. stmt = stmt.where(VasAgency.status == 1)
  52. stmt = stmt.order_by(VasAgency.created_at.desc())
  53. return await paginate(db, stmt, page, size)