Subversion Repositories SmartDukaan

Rev

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

Rev 7530 Rev 7542
Line 5310... Line 5310...
5310 
    return amazonCancelledOrders
5310 
    return amazonCancelledOrders
5311 
 
 5311 
 
5312 
def get_amazon_order(order_id):
 5312 
def get_amazon_order(order_id):
5313 
    return AmazonOrder.get_by(orderId=order_id)
 5313 
    return AmazonOrder.get_by(orderId=order_id)
5314 
 
 5314 
 
- 
 
 5315 
def get_amazon_order_by_amazonorderid(amazonOrderId):
- 
 
 5316 
    return AmazonOrder.query.filter(AmazonOrder.amazonOrderCode==amazonOrderId)
- 
 
 5317 
 
- 
 
 5318 
 
5315 
def get_amazon_orders_to_acknowledge():
 5319 
def get_amazon_orders_to_acknowledge():
5316 
    orderstatus = []
 5320 
    orderstatus = []
5317 
    orderstatus.append('Order-Payment-Success')
 5321 
    orderstatus.append('Order-Payment-Success')
5318 
    orderstatus.append('Order-Payment-Failure')
 5322 
    orderstatus.append('Order-Payment-Failure')
5319 
    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()
 5323 
    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()