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

                 order.lineitems[0].transfer_price = item_pricing.transferPrice
             except:
                 print "Not able to get transfer price. Skipping"
     elif new_status == TransactionStatus.COD_IN_PROCESS:
         for order in transaction.orders:
-            order.status = OrderStatus.INIT
+            order.status = OrderStatus.COD_VERIFICATION_PENDING
             order.statusDescription = "Verification Pending"
             order.cod = True
             #After we got payment success, we will set logistics info also
             logistics_client = LogisticsClient().get_client()
             #FIXME line item is only one now. If multiple will come, need to fix.
     return True
 def verify_order(self, orderId):
     logging.info("Verifying order no: " + str(orderId))
     order = get_order(orderId)
-    if order.status == OrderStatus.INIT:
+    if order.status == OrderStatus.COD_VERIFICATION_PENDING:
         order.status = OrderStatus.SUBMITTED_FOR_PROCESSING
         order.statusDescription = "Submitted for processing"
         order.verification_timestamp = datetime.datetime.now()
         session.commit()
         logging.info("Successfully verified order no: " + str(orderId))
     limit if it's passed as 0. Raises an excpetion if the supplied limit is
     less than 0.
     '''
     if limit < 0:
         raise TransactionServiceException(101, "Invalid argument limit " + limit)
-    query = Order.query.filter(Order.status >= OrderStatus.INIT)
+    query = Order.query.filter(Order.status >= OrderStatus.COD_VERIFICATION_PENDING)
     query = query.order_by(desc(Order.created_timestamp))
     if limit != 0:
         query = query.limit(limit)
     return query.all()
     elif order.status == OrderStatus.RTO_LOST_IN_TRANSIT:
         new_order = __clone_order(order, False, order.cod)
         order.status = OrderStatus.RTO_LOST_IN_TRANSIT_RESHIPPED
         order.statusDescription = "Order Reshipped Lost In Transit"
         session.commit()
+    elif order.status == OrderStatus.LOST_IN_TRANSIT:
+        new_order = __clone_order(order, False, order.cod)
+        order.status = OrderStatus.LOST_IN_TRANSIT_RESHIPPED
+        order.statusDescription = "Order Reshipped Lost In Transit"
+        session.commit()
     elif order.status == OrderStatus.DOA_CERT_INVALID:
         new_order = __clone_order(order, True, False)
         order.status = OrderStatus.DOA_INVALID_RESHIPPED
         order.statusDescription = "Order Reshipped"
         session.commit()
     if order.cod:
         logging.info("Refunding COD order with status " + str(order.status))
+        status_transition = { OrderStatus.LOST_IN_TRANSIT : OrderStatus.LOST_IN_TRANSIT_REFUNDED,
-        status_transition = {OrderStatus.RTO_RECEIVED_PRESTINE : OrderStatus.RTO_REFUNDED,
+                     OrderStatus.RTO_RECEIVED_PRESTINE : OrderStatus.RTO_REFUNDED,
                      OrderStatus.RTO_RECEIVED_DAMAGED : OrderStatus.RTO_DAMAGED_REFUNDED,
                      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.COD_VERIFICATION_PENDING : 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,
                      OrderStatus.LOW_INV_NOT_AVAILABLE_AT_HOTSPOT : OrderStatus.CANCELED,
             __create_return_order(order)
             order.statusDescription = "Order Cancelled"
         elif order.status in [OrderStatus.RTO_RECEIVED_PRESTINE, OrderStatus.RTO_RECEIVED_DAMAGED, OrderStatus.RTO_LOST_IN_TRANSIT]:
             __create_return_order(order)
             order.statusDescription = "RTO Refunded"
+        elif order.status in [OrderStatus.LOST_IN_TRANSIT]:
+            __create_return_order(order)
+            order.statusDescription = "Lost in Transit 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] :
                 order.statusDescription = "Order Cancelled on customer request"
             elif order.previousStatus == OrderStatus.BILLED:
                 __create_return_order(order)
                 order.statusDescription = "Order Cancelled on customer request"
     else:
+        status_transition = {OrderStatus.LOST_IN_TRANSIT : OrderStatus.LOST_IN_TRANSIT_REFUNDED,
-        status_transition = {OrderStatus.RTO_RECEIVED_PRESTINE : OrderStatus.RTO_REFUNDED,
+                     OrderStatus.RTO_RECEIVED_PRESTINE : OrderStatus.RTO_REFUNDED,
                      OrderStatus.RTO_RECEIVED_DAMAGED : OrderStatus.RTO_DAMAGED_REFUNDED,
                      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,
         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.LOST_IN_TRANSIT]:
+            __create_return_order(order)
+            __create_refund(order)
+            order.statusDescription = "Lost in Transit 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] :
 def change_product(order_id, item_id):
     '''
     Ship a product of a different color to the customer.
     '''
     order = get_order(order_id)
-    if order.status not in [OrderStatus.INIT, 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]:
+    if order.status not in [OrderStatus.COD_VERIFICATION_PENDING, 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]:
         raise TransactionServiceException(120, "This order has already been processed. Please seek help from engineering.")
     lineitem = order.lineitems[0]
     catalog_client = CatalogClient().get_client()
 def change_warehouse(order_id, warehouse_id):
     '''
     Update the warehouse which will be used to fulfil this order.
     '''
     order = get_order(order_id)
-    if order.status not in [OrderStatus.INIT, 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]:
+    if order.status not in [OrderStatus.COD_VERIFICATION_PENDING, 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]:
         raise TransactionServiceException(117, "This order has already been processed. Please seek help from engineering.")
     if warehouse_id == order.warehouse_id:
         raise TransactionServiceException(118, "You have selected the current warehouse again. Nothing to do")
     back to that status if cancellation request is denied.
     Parameters:
      - orderId
     """
-    status_transition = {OrderStatus.INIT : OrderStatus.CANCEL_REQUEST_RECEIVED,
+    status_transition = {OrderStatus.COD_VERIFICATION_PENDING : OrderStatus.CANCEL_REQUEST_RECEIVED,
              OrderStatus.SUBMITTED_FOR_PROCESSING : OrderStatus.CANCEL_REQUEST_RECEIVED,
              OrderStatus.INVENTORY_LOW : OrderStatus.CANCEL_REQUEST_RECEIVED,
              OrderStatus.LOW_INV_PO_RAISED : OrderStatus.CANCEL_REQUEST_RECEIVED,
              OrderStatus.LOW_INV_REVERSAL_IN_PROCESS : OrderStatus.CANCEL_REQUEST_RECEIVED,
              OrderStatus.LOW_INV_NOT_AVAILABLE_AT_HOTSPOT : OrderStatus.CANCEL_REQUEST_RECEIVED,
              OrderStatus.ACCEPTED : OrderStatus.CANCEL_REQUEST_RECEIVED,
              OrderStatus.BILLED : OrderStatus.CANCEL_REQUEST_RECEIVED,
              OrderStatus.PAYMENT_FLAGGED : OrderStatus.CANCEL_REQUEST_RECEIVED
+             }
+    order = get_order(orderId)
     if order.status not in status_transition.keys():
         raise TransactionServiceException(114, "This order can't be considered for cancellation")
-    order = get_order(orderId)
     order.previousStatus = order.status
     order.status = OrderStatus.CANCEL_REQUEST_RECEIVED
     order.statusDescription = "Cancellation request received from user"
     session.commit()
+def mark_order_as_lost_in_transit(orderId):
+    """
+    Parameters:
+     - orderId
+    """
+    order = get_order(orderId)
+    if order.status not in [OrderStatus.SHIPPED_FROM_WH, OrderStatus.SHIPPED_TO_LOGST]:
+        raise TransactionServiceException(115, "This order can't be marked as lost in transit")
+    order.status = OrderStatus.LOST_IN_TRANSIT
+    order.statusDescription = "Lost in Transit"
+    session.commit()
 def mark_transaction_as_payment_flag_removed(transactionId):
     """
     If we and/or payment gateway has decided to accept the payment, this method needs to be called.
     Changed transaction and all orders status to payment accepted.
         else:
             order_outofstock(order.id)
     return
 def get_slipped_sipping_date_orders():
-    return Order.query.filter(Order.status.in_(tuple([OrderStatus.INIT, 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()
+    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()
 def mark_orders_as_po_raised(vendorId, itemId, quantity, estimate, isReminder):
     if isReminder:
         statuses = tuple([OrderStatus.LOW_INV_PO_RAISED_TIMEOUT, OrderStatus.LOW_INV_REVERSAL_TIMEOUT])
     else:

Subversion Repositories SmartDukaan

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