| Line 6463... |
Line 6463... |
| 6463 |
order = order = Order.query.filter(Order.source== source).filter(Order.delivery_timestamp == None).filter(Order.status == OrderStatus.SHIPPED_FROM_WH).limit(1).one()
|
6463 |
order = order = Order.query.filter(Order.source== source).filter(Order.delivery_timestamp == None).filter(Order.status == OrderStatus.SHIPPED_FROM_WH).limit(1).one()
|
| 6464 |
print to_java_date(order.created_timestamp)
|
6464 |
print to_java_date(order.created_timestamp)
|
| 6465 |
return to_java_date(order.created_timestamp)
|
6465 |
return to_java_date(order.created_timestamp)
|
| 6466 |
|
6466 |
|
| 6467 |
def update_snapdeal_orders_status(delivered_orders):
|
6467 |
def update_snapdeal_orders_status(delivered_orders):
|
| - |
|
6468 |
try:
|
| 6468 |
for del_order in delivered_orders:
|
6469 |
for del_order in delivered_orders:
|
| 6469 |
ref_code = del_order[0]
|
6470 |
ref_code = del_order[0]
|
| 6470 |
sub_order_code = del_order[1]
|
6471 |
sub_order_code = del_order[1]
|
| 6471 |
dlvry_timestamp = del_order[2]
|
6472 |
dlvry_timestamp = del_order[2]
|
| 6472 |
|
6473 |
|
| 6473 |
if snapdeal_order_exists(sub_order_code, ref_code):
|
6474 |
if snapdeal_order_exists(sub_order_code, ref_code):
|
| 6474 |
snapdeal_order = get_snapdeal_order(None, ref_code, sub_order_code)
|
6475 |
snapdeal_order = get_snapdeal_order(None, ref_code, sub_order_code)
|
| - |
|
6476 |
if snapdeal_order:
|
| 6475 |
order = get_order(snapdeal_order.orderId)
|
6477 |
order = get_order(snapdeal_order.orderId)
|
| 6476 |
if order.status == OrderStatus.SHIPPED_FROM_WH:
|
6478 |
if order.status == OrderStatus.SHIPPED_FROM_WH:
|
| 6477 |
order.delivery_timestamp = datetime.datetime.strptime(dlvry_timestamp, "%Y-%m-%d %H:%M:%S")
|
6479 |
order.delivery_timestamp = datetime.datetime.strptime(dlvry_timestamp, "%Y-%m-%d %H:%M:%S")
|
| 6478 |
order.receiver = order.customer_name
|
6480 |
order.receiver = order.customer_name
|
| 6479 |
order.status = OrderStatus.DELIVERY_SUCCESS
|
6481 |
order.status = OrderStatus.DELIVERY_SUCCESS
|
| 6480 |
order.statusDescription = "Order delivered"
|
6482 |
order.statusDescription = "Order delivered"
|
| 6481 |
session.commit()
|
6483 |
session.commit()
|
| - |
|
6484 |
except Exception as e:
|
| - |
|
6485 |
print e
|
| - |
|
6486 |
print sys.exc_info()
|
| 6482 |
|
6487 |
|
| 6483 |
def update_flipkart_orders_status(delivered_orders):
|
6488 |
def update_flipkart_orders_status(delivered_orders):
|
| - |
|
6489 |
try:
|
| 6484 |
for del_order in delivered_orders:
|
6490 |
for del_order in delivered_orders:
|
| 6485 |
flipkart_order_id = del_order[0]
|
6491 |
flipkart_order_id = del_order[0]
|
| 6486 |
sub_order_code = del_order[1]
|
6492 |
sub_order_code = del_order[1]
|
| 6487 |
dlvry_timestamp = del_order[2]
|
6493 |
dlvry_timestamp = del_order[2]
|
| 6488 |
|
6494 |
|
| 6489 |
if flipkart_order_exists(flipkart_order_id,sub_order_code):
|
6495 |
if flipkart_order_exists(flipkart_order_id,sub_order_code):
|
| 6490 |
flipkart_order = get_flipkart_order_by_subOrderId(sub_order_code)
|
6496 |
flipkart_order = get_flipkart_order_by_subOrderId(sub_order_code)
|
| - |
|
6497 |
if flipkart_order:
|
| 6491 |
order = get_order(flipkart_order.orderId)
|
6498 |
order = get_order(flipkart_order.orderId)
|
| 6492 |
if order.status == OrderStatus.SHIPPED_FROM_WH:
|
6499 |
if order.status == OrderStatus.SHIPPED_FROM_WH:
|
| 6493 |
order.delivery_timestamp = datetime.datetime.strptime(dlvry_timestamp, "%Y-%m-%d %H:%M:%S")
|
6500 |
order.delivery_timestamp = datetime.datetime.strptime(dlvry_timestamp, "%Y-%m-%d %H:%M:%S")
|
| 6494 |
order.receiver = order.customer_name
|
6501 |
order.receiver = order.customer_name
|
| 6495 |
order.status = OrderStatus.DELIVERY_SUCCESS
|
6502 |
order.status = OrderStatus.DELIVERY_SUCCESS
|
| 6496 |
order.statusDescription = "Order delivered"
|
6503 |
order.statusDescription = "Order delivered"
|
| 6497 |
session.commit()
|
6504 |
session.commit()
|
| - |
|
6505 |
except Exception as e:
|
| - |
|
6506 |
print e
|
| - |
|
6507 |
print sys.exc_info()
|
| 6498 |
|
6508 |
|
| 6499 |
'''
|
6509 |
'''
|
| 6500 |
order_ids = delivered_orders.keys()
|
6510 |
order_ids = delivered_orders.keys()
|
| 6501 |
for orderId in order_ids:
|
6511 |
for orderId in order_ids:
|
| 6502 |
order = Order.query.filter(Order.id == orderId).first()
|
6512 |
order = Order.query.filter(Order.id == orderId).first()
|