| Line 6396... |
Line 6396... |
| 6396 |
raise TransactionServiceException(108, "no such order")
|
6396 |
raise TransactionServiceException(108, "no such order")
|
| 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):
|
| - |
|
6402 |
item_ordercount = dict()
|
| 6402 |
status=[15,18,34]
|
6403 |
status=[15,18,34]
|
| 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()
|
6404 |
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()
|
| 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 |
print items
|
| - |
|
6406 |
for item in items:
|
| - |
|
6407 |
print item[0]
|
| - |
|
6408 |
print item[1]
|
| - |
|
6409 |
item_ordercount[item[0]] = item[1]
|
| - |
|
6410 |
return item_ordercount
|
| 6405 |
|
6411 |
|
| 6406 |
|
6412 |
|
| 6407 |
|
6413 |
|
| 6408 |
if __name__ == '__main__':
|
6414 |
if __name__ == '__main__':
|
| 6409 |
print get_orders_by_mobile_number("9650889334")
|
6415 |
print get_orders_by_mobile_number("9650889334")
|
| 6410 |
|
6416 |
|