Subversion Repositories SmartDukaan

Rev

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

Rev 18029 Rev 18041
Line 4393... Line 4393...
4393
        else:
4393
        else:
4394
            order_outofstock(order.id)
4394
            order_outofstock(order.id)
4395
    return True
4395
    return True
4396
 
4396
 
4397
def move_orders_to_correct_warehouse():
4397
def move_orders_to_correct_warehouse():
-
 
4398
    completedOrders = []
-
 
4399
    pendingOrders = ""
4398
    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, OrderStatus.ACCEPTED]))).order_by(Order.promised_shipping_time).all()
4400
    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, OrderStatus.ACCEPTED]))).order_by(Order.promised_shipping_time).all()
4399
    logistics_client = LogisticsClient().get_client()
4401
    logistics_client = LogisticsClient().get_client()
4400
    for order in orders:
4402
    for order in orders:
4401
        lineitem = order.lineitems[0]
4403
        lineitem = order.lineitems[0]
4402
        logistics_info = logistics_client.getLogisticsEstimation(lineitem.item_id, order.customer_pincode, order.cod)
4404
        logistics_info = logistics_client.getLogisticsEstimation(lineitem.item_id, order.customer_pincode, order.cod)
4403
        if order.fulfilmentWarehouseId != logistics_info.fulfilmentWarehouseId:
4405
        if order.fulfilmentWarehouseId != logistics_info.fulfilmentWarehouseId:
4404
            try:
4406
            try:
4405
                print "++++" + str(order.id) + "=" + str(order.fulfilmentWarehouseId) + "->"+ str(logistics_info.fulfilmentWarehouseId)
4407
                print "++++" + str(order.id) + "=" + str(order.fulfilmentWarehouseId) + "->"+ str(logistics_info.fulfilmentWarehouseId)
4406
                change_warehouse(order.id, logistics_info.fulfilmentWarehouseId)
4408
                change_warehouse(order.id, logistics_info.fulfilmentWarehouseId)
-
 
4409
                completedOrders.append(order.id)
4407
            except:
4410
            except:
4408
                print "++++" + str(order.id)
4411
                print "++++" + str(order.id)
-
 
4412
                pendingOrders = pendingOrders + str(order.id) + "|"
-
 
4413
                
-
 
4414
    if len(completedOrders)==0 and len(pendingOrders)==0:
-
 
4415
        return "No Order To Move"
-
 
4416
    elif len(completedOrders)>0 and len(completedOrders) == len(orders):
-
 
4417
        return "Completed"
-
 
4418
    elif len(pendingOrders)>0:
-
 
4419
        return pendingOrders
-
 
4420
    else:
-
 
4421
        return "No Order To Move"
4409
    
4422
    
4410
def get_slipped_sipping_date_orders():
4423
def get_slipped_sipping_date_orders():
4411
    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()
4424
    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()
4412
    
4425
    
4413
def get_cancelled_orders(cancelDateFrom, cancelDateTo):
4426
def get_cancelled_orders(cancelDateFrom, cancelDateTo):