| Line 5811... |
Line 5811... |
| 5811 |
|
5811 |
|
| 5812 |
def get_amazon_order_by_amazonorderid(amazonOrderId):
|
5812 |
def get_amazon_order_by_amazonorderid(amazonOrderId):
|
| 5813 |
return AmazonOrder.query.filter(AmazonOrder.amazonOrderCode==amazonOrderId)
|
5813 |
return AmazonOrder.query.filter(AmazonOrder.amazonOrderCode==amazonOrderId)
|
| 5814 |
|
5814 |
|
| 5815 |
|
5815 |
|
| 5816 |
def get_amazon_orders_to_acknowledge():
|
5816 |
def get_amazon_orders_to_acknowledge(source):
|
| 5817 |
orderstatus = []
|
5817 |
orderstatus = []
|
| 5818 |
orderstatus.append('Order-Payment-Success')
|
5818 |
orderstatus.append('Order-Payment-Success')
|
| 5819 |
orderstatus.append('Order-Payment-Failure')
|
5819 |
orderstatus.append('Order-Payment-Failure')
|
| 5820 |
return session.query(AmazonOrder.amazonOrderCode,AmazonOrder.amazonOrderItemCode,AmazonOrder.status,AmazonOrder.transactionId,func.count(AmazonOrder.orderId)).filter(AmazonOrder.status.in_(orderstatus)).group_by(AmazonOrder.amazonOrderItemCode,AmazonOrder.status).all()
|
5820 |
return session.query(AmazonOrder.amazonOrderCode,AmazonOrder.amazonOrderItemCode,AmazonOrder.status,AmazonOrder.transactionId,func.count(AmazonOrder.orderId))\
|
| - |
|
5821 |
.join((Order, Order.id==AmazonOrder.orderId)).filter(AmazonOrder.status.in_(orderstatus)).filter(Order.source==source).group_by(AmazonOrder.amazonOrderItemCode,AmazonOrder.status).all()
|
| 5821 |
|
5822 |
|
| 5822 |
def change_amazon_order_status(amazonOrderCode,status):
|
5823 |
def change_amazon_order_status(amazonOrderCode,status):
|
| 5823 |
for order in AmazonOrder.query.filter(AmazonOrder.amazonOrderCode==amazonOrderCode):
|
5824 |
for order in AmazonOrder.query.filter(AmazonOrder.amazonOrderCode==amazonOrderCode):
|
| 5824 |
order.status = status
|
5825 |
order.status = status
|
| 5825 |
session.commit()
|
5826 |
session.commit()
|