Subversion Repositories SmartDukaan

Rev

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

Rev 18595 Rev 18719
Line 3255... Line 3255...
3255
    hsItem = HsItem.get_by(hsItemId = hs_ItemId)
3255
    hsItem = HsItem.get_by(hsItemId = hs_ItemId)
3256
    return hsItem
3256
    return hsItem
3257
 
3257
 
3258
def get_pricing_for_dtr(catalogItemId):
3258
def get_pricing_for_dtr(catalogItemId):
3259
    d_item = None
3259
    d_item = None
-
 
3260
    bulkPricingMap = {}
3260
    now = datetime.datetime.now()
3261
    now = datetime.datetime.now()
3261
    items = Item.query.filter(Item.catalog_item_id == catalogItemId).all()
3262
    items = Item.query.filter(Item.catalog_item_id == catalogItemId).all()
3262
    if items:
3263
    if items:
3263
        for item in items:
3264
        for item in items:
3264
            if item.status !=3 :
3265
            if item.status !=3 :
Line 3268... Line 3269...
3268
                item.sellingPrice = pvt_deal_item.dealPrice
3269
                item.sellingPrice = pvt_deal_item.dealPrice
3269
                d_item = item
3270
                d_item = item
3270
                break
3271
                break
3271
            else:
3272
            else:
3272
                d_item = item
3273
                d_item = item
-
 
3274
    if d_item is not None:
-
 
3275
        bulkPricingList = get_bulk_pricing_by_item_id(d_item.id)
-
 
3276
        for bulkPricing in bulkPricingList:
-
 
3277
            bulkPricingMap[bulkPricing.quantity] = bulkPricing.price
-
 
3278
    
3273
    return d_item
3279
    return d_item, bulkPricingMap
3274
 
3280
 
3275
def get_all_items_to_list_on_fbd():
3281
def get_all_items_to_list_on_fbd():
3276
    return Amazonlisted.query.filter(Amazonlisted.isFbd==False).filter(or_(Amazonlisted.fbdtaxCode!=None,Amazonlisted.fbdtaxCode!="")).all()
3282
    return Amazonlisted.query.filter(Amazonlisted.isFbd==False).filter(or_(Amazonlisted.fbdtaxCode!=None,Amazonlisted.fbdtaxCode!="")).all()
3277
 
3283
 
3278
def get_all_fbd_listed_items():
3284
def get_all_fbd_listed_items():
Line 3301... Line 3307...
3301
    d_BulkItemPricing.price = bulkItemPricing.price
3307
    d_BulkItemPricing.price = bulkItemPricing.price
3302
    session.commit()
3308
    session.commit()
3303
    return d_BulkItemPricing
3309
    return d_BulkItemPricing
3304
 
3310
 
3305
def get_bulk_pricing_by_item_id(itemId):
3311
def get_bulk_pricing_by_item_id(itemId):
3306
    bulkPricingItems = BulkItemPricing.query.filter(BulkItemPricing.item_id==itemId).all()
3312
    bulkPricingItems = BulkItemPricing.query.filter(BulkItemPricing.item_id==itemId).order_by(asc(BulkItemPricing.quantity)).all()
3307
    return bulkPricingItems
3313
    return bulkPricingItems
3308
 
3314
 
3309
def delete_bulk_pricing_for_item_by_id(id):
3315
def delete_bulk_pricing_for_item_by_id(id):
3310
    bulkPricingItems = BulkItemPricing.query.filter(BulkItemPricing.id==id).all()
3316
    bulkPricingItems = BulkItemPricing.query.filter(BulkItemPricing.id==id).all()
3311
    if len(bulkPricingItems) > 0:
3317
    if len(bulkPricingItems) > 0: