Subversion Repositories SmartDukaan

Rev

Rev 4822 | Rev 4858 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 4822 Rev 4843
Line 1208... Line 1208...
1208 
def get_items_by_category(categoryName):
 1208 
def get_items_by_category(categoryName):
1209 
    if not categoryName:
 1209 
    if not categoryName:
1210 
        raise InventoryServiceException(101, "Invalid category in request")
 1210 
        raise InventoryServiceException(101, "Invalid category in request")
1211 
    categories = ["Handsets", "Tablets", "Laptops"]
 1211 
    categories = ["Handsets", "Tablets", "Laptops"]
1212 
    if categoryName == "Accessories":
 1212 
    if categoryName == "Accessories":
1213 
        query = Item.query.filter(and_(Item.product_group not in categories, Item.status != status.PHASED_OUT))
 1213 
        query = Item.query.filter(Item.status != status.PHASED_OUT).filter(~Item.product_group.in_(categories))
1214 
    elif categoryName == "Handsets":
 1214 
    elif categoryName == "Handsets":
1215 
        query = Item.query.filter(and_(Item.product_group in categories, Item.status != status.PHASED_OUT))
 1215 
        query = Item.query.filter(Item.status != status.PHASED_OUT).filter(Item.product_group.in_(categories))
1216 
    items = query.all()
 1216 
    items = query.all()
1217 
    return items
 1217 
    return items
1218 
 
 1218 
 
1219 
def get_risky_items():
 1219 
def get_risky_items():
1220 
    items = Item.query.filter_by(risky=True).all()
 1220 
    items = Item.query.filter_by(risky=True).all()