| Line 985... |
Line 985... |
| 985 |
if not categoryName or not brand:
|
985 |
if not categoryName or not brand:
|
| 986 |
raise InventoryServiceException(101, "Invalid category or brand in request")
|
986 |
raise InventoryServiceException(101, "Invalid category or brand in request")
|
| 987 |
stmt = session.query(PrivateDeals).filter_by(isActive=1).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).subquery()
|
987 |
stmt = session.query(PrivateDeals).filter_by(isActive=1).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).subquery()
|
| 988 |
privateDealAlias = aliased(PrivateDeals,stmt)
|
988 |
privateDealAlias = aliased(PrivateDeals,stmt)
|
| 989 |
categories = ["Handsets", "Tablets", "Laptops"]
|
989 |
categories = ["Handsets", "Tablets", "Laptops"]
|
| 990 |
query = session.query(Item, privateDealAlias.dealPrice).outerjoin((privateDealAlias, Item.id==privateDealAlias.item_id).filter(Item.status != status.PHASED_OUT)
|
990 |
query = session.query(Item, privateDealAlias.dealPrice).outerjoin((privateDealAlias, Item.id==privateDealAlias.item_id)).filter(Item.status != status.PHASED_OUT)
|
| 991 |
if categoryName == "ALL":
|
991 |
if categoryName == "ALL":
|
| 992 |
pass
|
992 |
pass
|
| 993 |
elif categoryName == "ALL Accessories":
|
993 |
elif categoryName == "ALL Accessories":
|
| 994 |
query = query.filter(~Item.product_group.in_(categories))
|
994 |
query = query.filter(~Item.product_group.in_(categories))
|
| 995 |
elif categoryName == "ALL Handsets":
|
995 |
elif categoryName == "ALL Handsets":
|