Subversion Repositories SmartDukaan

Rev

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

Rev 13034 Rev 13076
Line 2819... Line 2819...
2819
        print 'Exception in updating private deals'
2819
        print 'Exception in updating private deals'
2820
        print e
2820
        print e
2821
        return False
2821
        return False
2822
 
2822
 
2823
def get_private_deals_query():
2823
def get_private_deals_query():
2824
    return session.query(Item).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(Item.status==status.ACTIVE).filter(PrivateDeals.isActive==True).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).group_by(Item.catalog_item_id).order_by(asc(PrivateDeals.rank))
2824
    return session.query(Item).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(Item.status==status.ACTIVE).filter(PrivateDeals.isActive==True).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).group_by(Item.catalog_item_id).order_by(desc(PrivateDeals.rank))
2825
    
2825
    
2826
def get_private_deals_count():
2826
def get_private_deals_count():
2827
    return session.query(func.count(distinct(Item.catalog_item_id))).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(Item.status==status.ACTIVE).filter(PrivateDeals.isActive==True).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).scalar()
2827
    return session.query(func.count(distinct(Item.catalog_item_id))).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(Item.status==status.ACTIVE).filter(PrivateDeals.isActive==True).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).scalar()
2828
 
2828
 
2829
def get_private_deals_catalog_ids(offset,limit):
2829
def get_private_deals_catalog_ids(offset,limit):