Subversion Repositories SmartDukaan

Rev

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

Rev 10924 Rev 10927
Line 2620... Line 2620...
2620
 
2620
 
2621
def get_flipkart_item_by_sku_at_flipkart(sku):
2621
def get_flipkart_item_by_sku_at_flipkart(sku):
2622
    return session.query(FlipkartItem,Item).join((Item,FlipkartItem.item_id==Item.id)).filter(FlipkartItem.skuAtFlipkart==sku).first()
2622
    return session.query(FlipkartItem,Item).join((Item,FlipkartItem.item_id==Item.id)).filter(FlipkartItem.skuAtFlipkart==sku).first()
2623
 
2623
 
2624
def get_all_fbb_listed_items():
2624
def get_all_fbb_listed_items():
2625
    return Amazonlisted.query.filter(Amazonlisted.isFbb==True,Amazonlisted.fbbListedOn==None).all()
2625
    return Amazonlisted.query.filter(Amazonlisted.isFbb==True).filter(Amazonlisted.fbbListedOn==None).all()
2626
   
2626
   
2627
def get_all_fbb_pricing_items():
2627
def get_all_fbb_pricing_items():
2628
    return Amazonlisted.query.filter(Amazonlisted.isFbb==True,Amazonlisted.suppressFbbPriceUpdate==False).filter(Amazonlisted.fbbPriceLastUpdatedOn > Amazonlisted.fbbPriceLastUpdatedOnSc).filter(Amazonlisted.fbbListedOn != None).all()
2628
    return Amazonlisted.query.filter(Amazonlisted.isFbb==True).filter(Amazonlisted.suppressFbbPriceUpdate==False).filter(Amazonlisted.fbbPriceLastUpdatedOn > Amazonlisted.fbbPriceLastUpdatedOnSc).filter(Amazonlisted.fbbListedOn != None).all()