| Line 3138... |
Line 3138... |
| 3138 |
logging.info("Unable to accept the order")
|
3138 |
logging.info("Unable to accept the order")
|
| 3139 |
else:
|
3139 |
else:
|
| 3140 |
order_outofstock(order.id)
|
3140 |
order_outofstock(order.id)
|
| 3141 |
return
|
3141 |
return
|
| 3142 |
|
3142 |
|
| - |
|
3143 |
def move_orders_to_correct_warehouse():
|
| - |
|
3144 |
orders = Order.query.filter(Order.status.in_(tuple([OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.LOW_INV_PO_RAISED, OrderStatus.LOW_INV_REVERSAL_IN_PROCESS]))).order_by(Order.promised_shipping_time).all()
|
| - |
|
3145 |
logistics_client = LogisticsClient().get_client()
|
| - |
|
3146 |
for order in orders:
|
| - |
|
3147 |
lineitem = order.lineitems[0]
|
| - |
|
3148 |
logistics_info = logistics_client.getLogisticsInfo(order.customer_pincode, lineitem.item_id, order.cod, PickUpType.COURIER) #TODO: We should be able to pass another flag to suggest ignoring the inventory situation.
|
| - |
|
3149 |
if order.fulfilmentWarehouseId != logistics_info.fulfilmentWarehouseId:
|
| - |
|
3150 |
print "++++" + str(order.id) + "=" + str(order.fulfilmentWarehouseId) + "->"+ str(logistics_info.fulfilmentWarehouseId)
|
| - |
|
3151 |
change_warehouse(order.id, logistics_info.fulfilmentWarehouseId)
|
| - |
|
3152 |
|
| 3143 |
def get_slipped_sipping_date_orders():
|
3153 |
def get_slipped_sipping_date_orders():
|
| 3144 |
return Order.query.filter(Order.status.in_(tuple([OrderStatus.COD_VERIFICATION_PENDING, OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.LOW_INV_PO_RAISED, OrderStatus.LOW_INV_REVERSAL_IN_PROCESS, OrderStatus.ACCEPTED, OrderStatus.BILLED]))).filter(Order.promised_shipping_time <= datetime.datetime.now()).order_by(Order.promised_shipping_time).all()
|
3154 |
return Order.query.filter(Order.status.in_(tuple([OrderStatus.COD_VERIFICATION_PENDING, OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.LOW_INV_PO_RAISED, OrderStatus.LOW_INV_REVERSAL_IN_PROCESS, OrderStatus.ACCEPTED, OrderStatus.BILLED]))).filter(Order.promised_shipping_time <= datetime.datetime.now()).order_by(Order.promised_shipping_time).all()
|
| 3145 |
|
3155 |
|
| 3146 |
def get_cancelled_orders(cancelDateFrom, cancelDateTo):
|
3156 |
def get_cancelled_orders(cancelDateFrom, cancelDateTo):
|
| 3147 |
return Order.query.filter(Order.status == OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY).filter(Order.refund_timestamp >= cancelDateFrom).filter(Order.refund_timestamp <= cancelDateTo).all()
|
3157 |
return Order.query.filter(Order.status == OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY).filter(Order.refund_timestamp >= cancelDateFrom).filter(Order.refund_timestamp <= cancelDateTo).all()
|