Subversion Repositories SmartDukaan

Rev

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

Rev 9575 Rev 9598
Line 6407... Line 6407...
6407 
    return order
 6407 
    return order
6408
6408
6409
6409
6410 
def get_orders_count_created_after_timestamp_for_source(timestamp,source):
 6410 
def get_orders_count_created_after_timestamp_for_source(timestamp,source):
6411 
    item_ordercount = dict()
 6411 
    item_ordercount = dict()
6412 
    status=[15,18,34]
 6412 
    status=[15,18,34,0,1]
6413 
    items =session.query(LineItem.item_id,func.count(LineItem.id)).join((Order,LineItem.order_id==Order.id)).filter(Order.source==source).filter(Order.created_timestamp >=to_py_date(timestamp)).filter(not_(Order.status.in_(status))).group_by(LineItem.item_id).all()
 6413 
    items =session.query(LineItem.item_id,func.count(LineItem.id)).join((Order,LineItem.order_id==Order.id)).filter(Order.source==source).filter(Order.created_timestamp >=to_py_date(timestamp)).filter(not_(Order.status.in_(status))).group_by(LineItem.item_id).all()
6414 
    print items
 6414 
    print items
6415 
    for item in items:
 6415 
    for item in items:
6416 
        print item[0]
 6416 
        print item[0]
6417 
        print item[1]
 6417 
        print item[1]