from sqlalchemy import select,or_
from app.models.supplier import Supplier
def list_suppliers(db,business_id,query=None,active=None):
 stmt=select(Supplier).where(Supplier.business_id==business_id)
 if query: stmt=stmt.where(or_(Supplier.name.ilike(f"%{query}%"),Supplier.phone.ilike(f"%{query}%"),Supplier.email.ilike(f"%{query}%")))
 if active is not None:stmt=stmt.where(Supplier.is_active==active)
 return list(db.scalars(stmt.order_by(Supplier.name)))