Watch
1
0
Fork
You've already forked arc
0
forked from hesabix/arc
arc/hesabixAPI/adapters/db/repositories/ai_invoice_repository.py
2026-04-14 19:34:55 +03:30

43 lines
1.5 KiB
Python
Executable file

from typing import Optional, List
from sqlalchemy.orm import Session
from sqlalchemy import and_
from adapters.db.models.ai_invoice import AIInvoice
from adapters.db.repositories.base_repo import BaseRepository
class AIInvoiceRepository(BaseRepository[AIInvoice]):
def __init__(self, db: Session):
super().__init__(db, AIInvoice)
def get_by_code(self, code: str) -> Optional[AIInvoice]:
"""دریافت صورتحساب بر اساس کد"""
return self.db.query(self.model_class).filter(
self.model_class.code == code
).first()
def get_business_invoices(
self,
business_id: int,
invoice_type: Optional[str] = None,
limit: int = 50,
skip: int = 0
) -> List[AIInvoice]:
"""دریافت صورتحساب‌های یک کسب‌وکار"""
query = self.db.query(self.model_class).filter(
self.model_class.business_id == business_id
)
if invoice_type:
query = query.filter(self.model_class.invoice_type == invoice_type)
return query.order_by(self.model_class.created_at.desc()).offset(skip).limit(limit).all()
def get_subscription_invoices(
self,
subscription_id: int
) -> List[AIInvoice]:
"""دریافت صورتحساب‌های یک اشتراک"""
return self.db.query(self.model_class).filter(
self.model_class.subscription_id == subscription_id
).order_by(self.model_class.created_at.desc()).all()