Subversion Repositories SmartDukaan

Rev

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

Rev 9470 Rev 9482
Line 6397... Line 6397...
6397
    
6397
    
6398
    return order
6398
    return order
6399
    
6399
    
6400
    
6400
    
6401
def get_orders_count_created_after_timestamp_for_source(timestamp,source,item_id):
6401
def get_orders_count_created_after_timestamp_for_source(timestamp,source,item_id):
-
 
6402
    status=[15,18,34]
6402
    print session.query(func.count(LineItem.id)).join((Order,LineItem.order_id==Order.id)).filter(LineItem.item_id==item_id).filter(Order.source==source).filter(Order.created_timestamp >=to_py_date(timestamp)).filter(Order.status>=3).first()
6403
    print session.query(func.count(LineItem.id)).join((Order,LineItem.order_id==Order.id)).filter(LineItem.item_id==item_id).filter(Order.source==source).filter(Order.created_timestamp >=to_py_date(timestamp)).filter(Order.status>=3).filter(not_(Order.status.in_(status))).first()
6403
    return session.query(func.count(LineItem.id)).join((Order,LineItem.order_id==Order.id)).filter(LineItem.item_id==item_id).filter(Order.source==source).filter(Order.created_timestamp >=to_py_date(timestamp)).filter(Order.status>=3).first()
6404
    return session.query(func.count(LineItem.id)).join((Order,LineItem.order_id==Order.id)).filter(LineItem.item_id==item_id).filter(Order.source==source).filter(Order.created_timestamp >=to_py_date(timestamp)).filter(Order.status>=3).filter(not_(Order.status.in_(status))).first()
-
 
6405
 
6404
    
6406
    
6405
 
6407
 
6406
if __name__ == '__main__':
6408
if __name__ == '__main__':
6407
    print get_orders_by_mobile_number("9650889334")
6409
    print get_orders_by_mobile_number("9650889334")
6408
6410