Subversion Repositories SmartDukaan

Rev

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

Rev 4934 Rev 4957
Line 1240... Line 1240...
1240 
    item.risky = risky
 1240 
    item.risky = risky
1241 
    if not risky and item.status == status.PAUSED_BY_RISK:
 1241 
    if not risky and item.status == status.PAUSED_BY_RISK:
1242 
        change_item_status(item.id, status.ACTIVE)
 1242 
        change_item_status(item.id, status.ACTIVE)
1243 
    session.commit()
 1243 
    session.commit()
1244
1244
1245 
def get_items_by_category(categoryName):
 1245 
def get_items_for_mastersheet(categoryName, brand):
1246 
    if not categoryName:
 1246 
    if not categoryName or not brand:
1247 
        raise InventoryServiceException(101, "Invalid category in request")
 1247 
        raise InventoryServiceException(101, "Invalid category or brand in request")
- 
 
 1248
1248 
    categories = ["Handsets", "Tablets", "Laptops"]
 1249 
    categories = ["Handsets", "Tablets", "Laptops"]
- 
 
 1250 
    query = Item.query.filter(Item.status != status.PHASED_OUT)
- 
 
 1251 
    if categoryName == "ALL":
- 
 
 1252 
        pass
1249 
    if categoryName == "Accessories":
 1253 
    elif categoryName == "ALL Accessories":
1250 
        query = Item.query.filter(Item.status != status.PHASED_OUT).filter(~Item.product_group.in_(categories))
 1254 
        query = query.filter(~Item.product_group.in_(categories))
1251 
    elif categoryName == "Handsets":
 1255 
    elif categoryName == "ALL Handsets":
1252 
        query = Item.query.filter(Item.status != status.PHASED_OUT).filter(Item.product_group.in_(categories))
 1256 
        query = query.filter(Item.product_group.in_(categories))
- 
 
 1257 
    elif categoryName == "Mobile Accessories":
- 
 
 1258 
        child_categories = get_child_categories(10011)
- 
 
 1259 
        if child_categories is not None:
- 
 
 1260 
            child_categories.append(0)
- 
 
 1261 
            query = query.filter(Item.category.in_(child_categories))
- 
 
 1262 
    elif categoryName == "Laptop Accessories":
- 
 
 1263 
        child_categories = get_child_categories(10070)
- 
 
 1264 
        if child_categories is not None:
- 
 
 1265 
            child_categories.append(0)
- 
 
 1266 
            query = query.filter(Item.category.in_(child_categories))
- 
 
 1267 
    else:
- 
 
 1268 
        query = query.filter(Item.product_group == categoryName)
- 
 
 1269
- 
 
 1270 
    if brand == "ALL":
- 
 
 1271 
        pass
- 
 
 1272 
    else:
- 
 
 1273 
        query = query.filter(Item.brand == brand)
1253 
    items = query.all()
 1274 
    items = query.all()
1254 
    return items
 1275 
    return items
1255 
 
 1276 
 
1256 
def get_risky_items():
 1277 
def get_risky_items():
1257 
    items = Item.query.filter_by(risky=True).all()
 1278 
    items = Item.query.filter_by(risky=True).all()
Line 1357... Line 1378...
1357 
    child_categories = catm.getCategory(category_id).children_category_ids
 1378 
    child_categories = catm.getCategory(category_id).children_category_ids
1358 
    brands = session.query(distinct(Item.brand)).filter(Item.category.in_(child_categories)).all()
 1379 
    brands = session.query(distinct(Item.brand)).filter(Item.category.in_(child_categories)).all()
1359
1380
1360 
    return [brand[0] for brand in brands]
 1381 
    return [brand[0] for brand in brands]
1361 
 
 1382 
 
- 
 
 1383 
def get_all_brands():
- 
 
 1384 
    brands = session.query(distinct(Item.brand)).order_by(Item.brand).all()
- 
 
 1385
- 
 
 1386 
    return [brand[0] for brand in brands]
- 
 
 1387 
 
1362 
def __enque_product_notification_email(email, product, date, url, itemId):
 1388 
def __enque_product_notification_email(email, product, date, url, itemId):
1363
1389
1364 
    html = """
 1390 
    html = """
1365 
        <html>
 1391 
        <html>
1366 
        <body>
 1392 
        <body>