WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py

     return amazonCancelledOrders
 def get_amazon_order(order_id):
     return AmazonOrder.get_by(orderId=order_id)
+def get_amazon_orders_to_acknowledge():
+    orderstatus = []
+    orderstatus.append('Order-Payment-Success')
+    orderstatus.append('Order-Payment-Failure')
+    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()
+def change_amazon_order_status(amazonOrderCode,status):
+    for order in AmazonOrder.query.filter(AmazonOrder.amazonOrderCode==amazonOrderCode):
+        order.status = status
+    session.commit()
 def get_orders_for_store(orderId, storeId, startDate, endDate, statuses):
     orders = []
     query = Order.query
     if storeId < 1:

Subversion Repositories SmartDukaan