Subversion Repositories SmartDukaan

Rev

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

Rev 7968 Rev 7972
Line 1109... Line 1109...
1109 
    return OOSStatus.query.filter_by(item_id = itemId).filter(OOSStatus.date > timestamp).all()
 1109 
    return OOSStatus.query.filter_by(item_id = itemId).filter(OOSStatus.date > timestamp).all()
1110 
 
 1110 
 
1111 
def get_non_zero_item_stock_purchase_params():
 1111 
def get_non_zero_item_stock_purchase_params():
1112 
    return ItemStockPurchaseParams.query.filter(or_("numOfDaysStock!=0","minStockLevel!=0"))
 1112 
    return ItemStockPurchaseParams.query.filter(or_("numOfDaysStock!=0","minStockLevel!=0"))
1113 
 
 1113 
 
- 
 
 1114 
def get_last_n_day_sale_for_item(itemId, numberOfDays):
- 
 
 1115 
    lastNdaySale = ""
- 
 
 1116 
    oosStatuses = get_oos_statuses_for_x_days_for_item(itemId, numberOfDays)
- 
 
 1117 
    for oosStatus in oosStatuses:
- 
 
 1118 
        if oosStatus.is_oos == True:
- 
 
 1119 
            lastNdaySale +="X-"
- 
 
 1120 
        else:
- 
 
 1121 
            lastNdaySale +=str(oosStatus.num_orders) + "-"
- 
 
 1122 
    return lastNdaySale[:-1]
- 
 
 1123 
 
1114 
def get_warehouse_name(warehouseId):
 1124 
def get_warehouse_name(warehouseId):
1115 
    row = Warehouse.get_by(id = warehouseId)
 1125 
    row = Warehouse.get_by(id = warehouseId)
1116 
    return row.displayName
 1126 
    return row.displayName
1117 
 
 1127 
 
1118 
def get_amazon_inventory_for_item(amazonItemId):
 1128 
def get_amazon_inventory_for_item(amazonItemId):