Subversion Repositories SmartDukaan

    AmazonOrder

def add_amazon_order(amazonOrder):

    amazon_order = AmazonOrder()

    amazon_order.orderId = amazonOrder.orderId

    amazon_order.amazonOrderCode = amazonOrder.amazonOrderCode

    amazon_order.amazonOrderItemCode = amazonOrder.amazonOrderItemCode

    amazon_order.transactionId = amazonOrder.transactionId

    amazon_order.item_id= amazonOrder.item_id

    amazon_order.status= amazonOrder.status

    session.commit()

def get_order_for_amazonordercode(order_id,status):

    try:

        row = AmazonOrder.get_by(orderId=order_id)

        row.status=status

        result=True

    except:

        result=False

    finally:

        session.commit()

        return result

def get_amazon_orders_marked_sent():

    return AmazonOrder.query.filter(AmazonOrder.status=='Acknowledment_Sent').all()

def get_amazon_orders_shipped(interval):

    amazonShippedOrders = []

    toDate = datetime.datetime.now()

    fromDate = toDate-timedelta(days = interval-1, hours=toDate.hour, minutes=toDate.minute, seconds=toDate.second)

    orders = get_amazon_orders_marked_sent()

    for order in orders:

        row = Order.query.filter(Order.shipping_timestamp.between (fromDate,toDate)).filter(Order.id==order.orderId).first()

        amazonShippedOrders.append(to_t_order(row))

    return amazonShippedOrders

def get_amazon_orders_cancelled(interval):

    amazonCancelledOrders = []

    toDate = datetime.datetime.now()

    fromDate = toDate-timedelta(days = interval-1, hours=toDate.hour, minutes=toDate.minute, seconds=toDate.second)

    orders = get_amazon_orders_marked_sent()

    for order in orders:

        row = Order.query.filter(Order.refund_timestamp.between (fromDate,toDate)).filter(Order.id==order.orderId).first()

        if ( row.status == 15 or row.status == 18 or row.status == 34 ):

            amazonCancelledOrders.append(to_t_order(row))

    return amazonCancelledOrders