WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py

     session.commit()
     return True
 def request_pickup_number(order_id):
     order = get_order(order_id)
-    if order.status != OrderStatus.DELIVERY_SUCCESS and order.status != OrderStatus.DOA_PICKUP_REQUEST_RAISED:
+    if order.status != OrderStatus.DELIVERY_SUCCESS and order.status != OrderStatus.DOA_REQUEST_AUTHORIZED and order.status != OrderStatus.RET_REQUEST_AUTHORIZED:
         return False
     from_user = 'cnc.center@shop2020.in'
     from_pwd = '5h0p2o2o'
     subject = "Pickup request from " + order.customer_city
                                           'warehouse_address' : warehouse.location,
                                           'warehouse_pin' : warehouse.pincode,
                                           'warehouse_phone': '9971573026'}
         #FIXME Email is hardcoded for bluedart
         mail(from_user, from_pwd, [to_addr, 'sonikap@bluedart.com'], subject, message)
+        if order.status == OrderStatus.RET_REQUEST_AUTHORIZED:
+            order.status = OrderStatus.RET_PICKUP_REQUEST_RAISED
+            order.statusDescription = "Pick up requested for RETURN"
+        else:
-        order.status = OrderStatus.DOA_PICKUP_REQUEST_RAISED
+            order.status = OrderStatus.DOA_PICKUP_REQUEST_RAISED
-        order.statusDescription = "Pick up requested for DOA"
+            order.statusDescription = "Pick up requested for DOA"
         session.commit()
         return True
     except Exception as e:
         print sys.exc_info()[0]
         return False
 def authorize_pickup(order_id, pickup_number):
     order = get_order(order_id)
-    if order.status != OrderStatus.DOA_PICKUP_REQUEST_RAISED:
+    if order.status not in [OrderStatus.DOA_PICKUP_REQUEST_RAISED, OrderStatus.RET_PICKUP_REQUEST_RAISED]:
         return False
     from_user = 'help@shop2020.in'
     from_pwd = '5h0p2o2o'
     subject = 'Pickup details'
     filename = "/tmp/" +  str(order.id) +".pdf"
         today = date.today().strftime("%d-%B-%Y (%A)")
         raw_message = '''
         Dear Mr. %(customer_name)s,
-        In reference to the return of order ID %(order_id)d. We request you to kindly pack the box properly with bubble wrap, and send it along with the original "DOA" certificate and the invoice.
+        In reference to the return of order ID %(order_id)d. We request you to kindly pack the box properly with bubble wrap, and send it along with the original "DOA" certificate (in case of DOA) and the invoice.
         Take a printout of the attachment in this mail which contains the delivery address and paste it on the packed parcel.
         We have instructed %(provider_name)s to pick up the material from the below mentioned address on %(date)s. %(provider_name)s pickup request number is %(pickup_request_no)s. Kindly keep the parcel ready.
         Pickup will happen from the below mentioned address:-
                                          'customer_address' : __get_order_address(order)}
         print message
         __generate_return_advice(order, warehouse, provider, filename)
         mail(from_user, from_pwd, [to_addr], subject, message, [get_attachment_part(filename)])
         order.pickupRequestNo = pickup_number
+        if order.status == OrderStatus.RET_PICKUP_REQUEST_RAISED:
+            order.status = OrderStatus.RET_PICKUP_CONFIRMED
+            order.statusDescription = "RETURN pick up confirmed"
+        else:
-        order.status = OrderStatus.DOA_PICKUP_CONFIRMED
+            order.status = OrderStatus.DOA_PICKUP_CONFIRMED
-        order.statusDescription = "DOA pick up confirmed"
+            order.statusDescription = "DOA pick up confirmed"
         order.doa_auth_timestamp = datetime.datetime.now()
         session.commit()
         return True
     except Exception as e:
         print sys.exc_info()
         elif receiveCondition == 2:
             order.status = OrderStatus.DOA_LOST_IN_TRANSIT
             order.statusDescription = "DOA lost in transit"
         order.received_return_timestamp = datetime.datetime.now()
         session.commit()
+    elif order.status in [OrderStatus.RET_PICKUP_CONFIRMED, OrderStatus.RET_RETURN_IN_TRANSIT]:
+        if receiveCondition == 0:
+            order.status = OrderStatus.RET_RECEIVED_PRESTINE
+            order.statusDescription = "RETURN package received"
+        elif receiveCondition == 1:
+            order.status = OrderStatus.RET_RECEIVED_DAMAGED
+            order.statusDescription = "RETURN received damaged"
+        elif receiveCondition == 2:
+            order.status = OrderStatus.RET_LOST_IN_TRANSIT
+            order.statusDescription = "RETURN lost in transit"
+        order.received_return_timestamp = datetime.datetime.now()
+        session.commit()
     elif order.status == OrderStatus.RTO_IN_TRANSIT :
         if receiveCondition == 0:
             order.status = OrderStatus.RTO_RECEIVED_PRESTINE
             order.statusDescription = "RTO package received"
         elif receiveCondition == 1:
         order.statusDescription = "DOA Certificate Invalid"
         update_trust_level(order)
     session.commit()
     return True
+def validate_return_product(order_id, is_usable):
+    order = get_order(order_id)
+    if order.status != OrderStatus.RET_RECEIVED_PRESTINE:
+        return False
+    if is_usable:
+        order.status = OrderStatus.RET_PRODUCT_USABLE
+        order.statusDescription = "Return product usable"
+    else:
+        order.status = OrderStatus.RET_PRODUCT_UNUSABLE
+        order.statusDescription = "Return product unusable"
+        update_trust_level(order)
+    session.commit()
+    return True
 def reship_order(order_id):
     """
     If the order is in RTO_RECEIVED_PRESTINE or DOA_CERT_INVALID state, it does the following:
 . Creates a new order for processing in the BILLED state. All billing information is saved.
 . Marks the current order as one of the final states RTO_RESHIPPED and DOA_INVALID_RESHIPPED depending on what state the order started in.
     elif order.status == OrderStatus.DOA_LOST_IN_TRANSIT:
         new_order = __clone_order(order, False, False)
         order.status = OrderStatus.DOA_RESHIPPED_LOST_IN_TRANSIT
         order.statusDescription = "Order Reshipped Lost In Transit"
         session.commit()
+    elif order.status == OrderStatus.RET_PRODUCT_UNUSABLE:
+        new_order = __clone_order(order, True, False)
+        order.status = OrderStatus.RET_PRODUCT_UNUSABLE_RESHIPPED
+        order.statusDescription = "Order Reshipped"
+        session.commit()
+    elif order.status == OrderStatus.RET_PRODUCT_USABLE:
+        new_order = __clone_order(order, False, False)
+        ret_order = __create_return_order(order)
+        order.status = OrderStatus.RET_PRODUCT_USABLE_RESHIPPED
+        order.statusDescription = "Order Reshipped"
+        session.commit()
+    elif order.status == OrderStatus.RET_RECEIVED_DAMAGED:
+        new_order = __clone_order(order, False, False)
+        ret_order = __create_return_order(order)
+        order.status = OrderStatus.RET_RESHIPPED_RCVD_DAMAGED
+        order.statusDescription = "Order Reshipped Received Damaged"
+        session.commit()
+    elif order.status == OrderStatus.RET_LOST_IN_TRANSIT:
+        new_order = __clone_order(order, False, False)
+        order.status = OrderStatus.RET_RESHIPPED_LOST_IN_TRANSIT
+        order.statusDescription = "Order Reshipped Lost In Transit"
+        session.commit()
     else:
         raise TransactionServiceException(112, "This order can't be reshipped")
     order.reship_timestamp = datetime.datetime.now()
     order.new_order_id = new_order.id
                      OrderStatus.RTO_LOST_IN_TRANSIT : OrderStatus.RTO_LOST_IN_TRANSIT_REFUNDED,
                      OrderStatus.DOA_CERT_INVALID : OrderStatus.DOA_INVALID_REFUNDED,
                      OrderStatus.DOA_CERT_VALID : OrderStatus.DOA_VALID_REFUNDED,
                      OrderStatus.DOA_RECEIVED_DAMAGED : OrderStatus.DOA_REFUNDED_RCVD_DAMAGED,
                      OrderStatus.DOA_LOST_IN_TRANSIT : OrderStatus.DOA_REFUNDED_LOST_IN_TRANSIT,
+                     OrderStatus.RET_PRODUCT_UNUSABLE : OrderStatus.RET_PRODUCT_UNUSABLE_REFUNDED,
+                     OrderStatus.RET_PRODUCT_USABLE : OrderStatus.RET_PRODUCT_USABLE_REFUNDED,
+                     OrderStatus.RET_RECEIVED_DAMAGED : OrderStatus.RET_REFUNDED_RCVD_DAMAGED,
+                     OrderStatus.RET_LOST_IN_TRANSIT : OrderStatus.RET_REFUNDED_LOST_IN_TRANSIT,
                      OrderStatus.INIT : OrderStatus.CANCELED,
                      OrderStatus.SUBMITTED_FOR_PROCESSING : OrderStatus.CANCELED,
                      OrderStatus.INVENTORY_LOW : OrderStatus.CANCELED,
                      OrderStatus.LOW_INV_PO_RAISED : OrderStatus.CANCELED,
                      OrderStatus.LOW_INV_REVERSAL_IN_PROCESS : OrderStatus.CANCELED,
             __create_return_order(order)
             order.statusDescription = "RTO Refunded"
         elif order.status in [OrderStatus.DOA_CERT_INVALID, OrderStatus.DOA_CERT_VALID, OrderStatus.DOA_RECEIVED_DAMAGED, OrderStatus.DOA_LOST_IN_TRANSIT] :
             __create_return_order(order)
             __create_refund(order)
+            order.statusDescription = "DOA Refunded"
+        elif order.status in [OrderStatus.RET_PRODUCT_UNUSABLE, OrderStatus.RET_PRODUCT_USABLE, OrderStatus.RET_RECEIVED_DAMAGED, OrderStatus.RET_LOST_IN_TRANSIT] :
+            __create_return_order(order)
+            __create_refund(order)
-            order.statusDescription = "Order Refunded"
+            order.statusDescription = "Return Refunded"
         elif order.status == OrderStatus.CANCEL_REQUEST_CONFIRMED:
             if order.previousStatus  < OrderStatus.BILLED:
                 __update_inventory_reservation(order)
                 order.statusDescription = "Order Cancelled on customer request"
             elif order.previousStatus == OrderStatus.BILLED:
                      OrderStatus.RTO_LOST_IN_TRANSIT : OrderStatus.RTO_LOST_IN_TRANSIT_REFUNDED,
                      OrderStatus.DOA_CERT_INVALID : OrderStatus.DOA_INVALID_REFUNDED,
                      OrderStatus.DOA_CERT_VALID : OrderStatus.DOA_VALID_REFUNDED,
                      OrderStatus.DOA_RECEIVED_DAMAGED : OrderStatus.DOA_REFUNDED_RCVD_DAMAGED,
                      OrderStatus.DOA_LOST_IN_TRANSIT : OrderStatus.DOA_REFUNDED_LOST_IN_TRANSIT,
+                     OrderStatus.RET_PRODUCT_UNUSABLE : OrderStatus.RET_PRODUCT_UNUSABLE_REFUNDED,
+                     OrderStatus.RET_PRODUCT_USABLE : OrderStatus.RET_PRODUCT_USABLE_REFUNDED,
+                     OrderStatus.RET_RECEIVED_DAMAGED : OrderStatus.RET_REFUNDED_RCVD_DAMAGED,
+                     OrderStatus.RET_LOST_IN_TRANSIT : OrderStatus.RET_REFUNDED_LOST_IN_TRANSIT,
                      OrderStatus.SUBMITTED_FOR_PROCESSING : OrderStatus.REFUNDED,
                      OrderStatus.INVENTORY_LOW : OrderStatus.REFUNDED,
                      OrderStatus.LOW_INV_PO_RAISED : OrderStatus.REFUNDED,
                      OrderStatus.LOW_INV_REVERSAL_IN_PROCESS : OrderStatus.REFUNDED,
                      OrderStatus.LOW_INV_NOT_AVAILABLE_AT_HOTSPOT : OrderStatus.REFUNDED,
                      OrderStatus.PAYMENT_FLAGGED : OrderStatus.PAYMENT_FLAGGED_DENIED
+                     }
         if order.status not in status_transition.keys():
             raise TransactionServiceException(114, "This order can't be refunded")
-        if order.status in [OrderStatus.RTO_RECEIVED_PRESTINE, OrderStatus.RTO_RECEIVED_DAMAGED, OrderStatus.RTO_LOST_IN_TRANSIT, OrderStatus.DOA_CERT_INVALID, OrderStatus.DOA_CERT_VALID, OrderStatus.DOA_RECEIVED_DAMAGED, OrderStatus.DOA_LOST_IN_TRANSIT] :
+        if order.status in [OrderStatus.RTO_RECEIVED_PRESTINE, OrderStatus.RTO_RECEIVED_DAMAGED, OrderStatus.RTO_LOST_IN_TRANSIT] :
             __create_return_order(order)
             __create_refund(order)
+            order.statusDescription = "RTO Refunded"
+        elif order.status in [OrderStatus.DOA_CERT_INVALID, OrderStatus.DOA_CERT_VALID, OrderStatus.DOA_RECEIVED_DAMAGED, OrderStatus.DOA_LOST_IN_TRANSIT] :
+            __create_return_order(order)
+            __create_refund(order)
+            order.statusDescription = "DOA Refunded"
+        elif order.status in [OrderStatus.RET_PRODUCT_UNUSABLE, OrderStatus.RET_PRODUCT_USABLE, OrderStatus.RET_RECEIVED_DAMAGED, OrderStatus.RET_LOST_IN_TRANSIT] :
+            __create_return_order(order)
+            __create_refund(order)
-            order.statusDescription = "Order Refunded"
+            order.statusDescription = "Return Refunded"
         elif order.status in [OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.LOW_INV_PO_RAISED, OrderStatus.LOW_INV_REVERSAL_IN_PROCESS, OrderStatus.LOW_INV_NOT_AVAILABLE_AT_HOTSPOT]:
             __create_cancellation(order)
             __update_inventory_reservation(order)
             order.statusDescription = "Order Refunded"
         elif order.status == OrderStatus.CANCEL_REQUEST_CONFIRMED:

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py – Rev 4488 → 4495