Subversion Repositories SmartDukaan

Rev

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

Rev 7672 Rev 7683
Line 5360... Line 5360...
5360
    row.status=status
5360
    row.status=status
5361
    session.commit()
5361
    session.commit()
5362
    return True
5362
    return True
5363
 
5363
 
5364
def get_amazon_orders_marked_sent():
5364
def get_amazon_orders_marked_sent():
5365
    return AmazonOrder.query.filter(AmazonOrder.status=='Acknowledgement-Sent').all()
5365
    return AmazonOrder.query.filter(AmazonOrder.status=='Order-Payment-Success').all()
5366
 
5366
 
5367
def get_amazon_orders_shipped(interval):
5367
def get_amazon_orders_shipped():
5368
    amazonShippedOrders = []
5368
    amazonShippedOrders = []
5369
    toDate = datetime.datetime.now()
5369
    ###toDate = datetime.datetime.now()
5370
    fromDate = toDate-timedelta(days = interval-1, hours=toDate.hour, minutes=toDate.minute, seconds=toDate.second)
5370
    ###fromDate = toDate-timedelta(days = interval-1, hours=toDate.hour, minutes=toDate.minute, seconds=toDate.second)
5371
    orders = get_amazon_orders_marked_sent()
5371
    orders = get_amazon_orders_marked_sent()
5372
    for order in orders:
5372
    for order in orders:
5373
        row = Order.query.filter(Order.shipping_timestamp.between (fromDate,toDate)).filter(Order.id==order.orderId).first()
5373
        row = Order.query.filter().filter(Order.id==order.orderId).first()
5374
        if row is None:
5374
        if row is None:
5375
            continue
5375
            continue
-
 
5376
        if row.shipping_timestamp is not None:
5376
        amazonShippedOrders.append(to_t_order(row))
5377
            amazonShippedOrders.append(to_t_order(row))
5377
    return amazonShippedOrders
5378
    return amazonShippedOrders
5378
 
5379
 
5379
def get_amazon_orders_cancelled(interval):
5380
def get_amazon_orders_cancelled(interval):
5380
    amazonCancelledOrders = []
5381
    amazonCancelledOrders = []
5381
    toDate = datetime.datetime.now()
5382
    toDate = datetime.datetime.now()