Subversion Repositories SmartDukaan

    @Override

    public boolean refundOrder(int orderId, String refundedBy, String refundReason) throws ProfitMandiBusinessException {

        /*def refund_order(order_id, refunded_by, reason):

        """

        If the order is in RTO_RECEIVED_PRESTINE, DOA_CERT_VALID or DOA_CERT_INVALID state, it does the following:

            1. Creates a refund request for batch processing.

            2. Creates a return order for the warehouse executive to return the shipped material.

            3. Marks the current order as RTO_REFUNDED, DOA_VALID_REFUNDED or DOA_INVALID_REFUNDED final states.

        If the order is in SUBMITTED_FOR_PROCESSING or INVENTORY_LOW state, it does the following:

            1. Creates a refund request for batch processing.

            2. Cancels the reservation of the item in the warehouse.

            3. Marks the current order as the REFUNDED final state.

        For all COD orders, if the order is in INIT, SUBMITTED_FOR_PROCESSING or INVENTORY_LOW state, it does the following:

            1. Cancels the reservation of the item in the warehouse.

            2. Marks the current order as CANCELED.

        In all cases, it updates the reason for cancellation or refund and the person who performed the action.

        Returns True if it is successful, False otherwise.

        Throws an exception if the order with the given id couldn't be found.

        Parameters:

         - order_id

         - refunded_by

         - reason

        """

        LOGGER.info("Refunding order id: {}", orderId);

        Order order = orderRepository.selectById(orderId);

        if order.cod:

        logging.info("Refunding COD order with status " + str(order.status))

        status_transition = refund_status_transition

        if order.status not in status_transition.keys():

        raise TransactionServiceException(114, "This order can't be refunded")

        if order.status 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, OrderStatus.ACCEPTED]:

        __update_inventory_reservation(order, refund=True)

        order.statusDescription = "Order Cancelled"

            #Shipment Id and Airway Bill No should be none in case of Cancellation

        order.logisticsTransactionId = None

        order.tracking_id = None

        order.airwaybill_no = None

        elif order.status == OrderStatus.BILLED:

        __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]:

        if order.status != 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] :

        if order.status != OrderStatus.DOA_LOST_IN_TRANSIT:

        __create_return_order(order)

        __create_refund(order, 0, 'Should be unreachable for now')

        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] :

        if order.status != OrderStatus.RET_LOST_IN_TRANSIT:

        __create_return_order(order)

        __create_refund(order, 0, 'Should be unreachable for now')

        order.statusDescription = "Return Refunded"

        elif order.status == OrderStatus.CANCEL_REQUEST_CONFIRMED:

        if order.previousStatus 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, OrderStatus.ACCEPTED]:

        __update_inventory_reservation(order, refund=True)

        order.statusDescription = "Order Cancelled on customer request"

        elif order.previousStatus == OrderStatus.BILLED:

        __create_return_order(order)

        order.statusDescription = "Order Cancelled on customer request"

        order.received_return_timestamp = datetime.datetime.now()

    else:

        status_transition = {OrderStatus.LOST_IN_TRANSIT : OrderStatus.LOST_IN_TRANSIT_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.SUBMITTED_FOR_PROCESSING : OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY,

                OrderStatus.INVENTORY_LOW : OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY,

                OrderStatus.LOW_INV_PO_RAISED : OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY,

                OrderStatus.LOW_INV_REVERSAL_IN_PROCESS : OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY,

                OrderStatus.LOW_INV_NOT_AVAILABLE_AT_HOTSPOT : OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY,

                OrderStatus.ACCEPTED : OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY,

                OrderStatus.BILLED : OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY,

                OrderStatus.CANCEL_REQUEST_CONFIRMED : OrderStatus.CANCELLED_ON_CUSTOMER_REQUEST,

                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] :

        if order.status != OrderStatus.RTO_LOST_IN_TRANSIT:

        __create_return_order(order)

        __create_refund(order, order.wallet_amount, 'Order #{0} is RTO refunded'.format(order.id))

        order.statusDescription = "RTO Refunded"

            #Start:- Added By Manish Sharma for Creating a new Ticket: Category- RTO Refund on 21-Jun-2013

        try:

        crmServiceClient = CRMClient().get_client()

        ticket =Ticket()

        activity = Activity()

        description = "Creating Ticket for " + order.statusDescription + " Order"

        ticket.creatorId = 1

        ticket.assigneeId = 34

        ticket.category = TicketCategory.RTO_REFUND

        ticket.priority = TicketPriority.MEDIUM

        ticket.status = TicketStatus.OPEN

        ticket.description = description

        ticket.orderId = order.id

        activity.creatorId = 1

        activity.ticketAssigneeId = ticket.assigneeId

        activity.type = ActivityType.OTHER

        activity.description = description

        activity.ticketCategory = ticket.category

        activity.ticketDescription = ticket.description

        activity.ticketPriority = ticket.priority

        activity.ticketStatus = ticket.status

        ticket.customerId= order.customer_id

        ticket.customerEmailId = order.customer_email

        ticket.customerMobileNumber = order.customer_mobilenumber

        ticket.customerName = order.customer_name

        activity.customerId = ticket.customerId

        activity.customerEmailId = order.customer_email

        activity.customerMobileNumber = order.customer_mobilenumber

        activity.customerName = order.customer_name

        crmServiceClient.insertTicket(ticket, activity)

        except:

        print "Ticket for RTO Refund is not created."

            #End:- Added By Manish Sharma for Creating a new Ticket: Category- RTO Refund on 21-Jun-2013

        elif order.status in [OrderStatus.LOST_IN_TRANSIT]:

            #__create_return_order(order)

        __create_refund(order, order.wallet_amount, 'Order #{0} is Lost in Transit'.format(order.id))

        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] :

        if order.status != OrderStatus.DOA_LOST_IN_TRANSIT:

        __create_return_order(order)

        __create_refund(order, 0, 'This should be unreachable')

        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] :

        if order.status != OrderStatus.RET_LOST_IN_TRANSIT:

        __create_return_order(order)

        __create_refund(order, 0, 'This should be unreachable')

        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, OrderStatus.ACCEPTED]:

        __update_inventory_reservation(order, refund=True)

        order.statusDescription = "Order Refunded"

        elif order.status == OrderStatus.CANCEL_REQUEST_CONFIRMED:

        if order.previousStatus 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, OrderStatus.PAYMENT_FLAGGED, OrderStatus.ACCEPTED]:

        __update_inventory_reservation(order, refund=True)

        order.statusDescription = "Order Cancelled on customer request"

        elif order.previousStatus == OrderStatus.BILLED:

        __create_refund(order, order.wallet_amount,  'Order #{0} Cancelled on customer request'.format(order.id))

        order.statusDescription = "Order Cancelled on customer request"

        elif order.status == OrderStatus.PAYMENT_FLAGGED:

        __update_inventory_reservation(order, refund=True)

        order.statusDescription = "Order Cancelled due to payment flagged"

    # For orders that are cancelled after being billed, we need to scan in the scanned out

    # inventory item and change availability accordingly

        inventoryClient = InventoryClient().get_client()

        warehouse = inventoryClient.getWarehouse(order.warehouse_id)

        if warehouse.billingType == BillingType.OURS or warehouse.billingType == BillingType.OURS_EXTERNAL:

        #Now BILLED orders can also be refunded directly with low inventory cancellations

        if order.status in [OrderStatus.BILLED, OrderStatus.SHIPPED_TO_LOGST, OrderStatus.SHIPPED_FROM_WH]:

        __create_refund(order, order.wallet_amount, reason)

        if order.status in [OrderStatus.BILLED, OrderStatus.SHIPPED_TO_LOGST, OrderStatus.SHIPPED_FROM_WH] or (order.status == OrderStatus.CANCEL_REQUEST_CONFIRMED and order.previousStatus in [OrderStatus.BILLED, OrderStatus.SHIPPED_TO_LOGST, OrderStatus.SHIPPED_FROM_WH]):

        lineitem = order.lineitems[0]

        catalogClient = CatalogClient().get_client()

        item = catalogClient.getItem(lineitem.item_id)

        warehouseClient = WarehouseClient().get_client()

        if warehouse.billingType == BillingType.OURS:

        if ItemType.SERIALIZED == item.type:

        for serial_number in str(lineitem.serial_number).split(','):

        warehouseClient.scanSerializedItemForOrder(serial_number, ScanType.SALE_RET, order.id, order.fulfilmentWarehouseId, 1, order.warehouse_id)

                else:

        warehouseClient.scanForOrder(None, ScanType.SALE_RET, lineitem.quantity, order.id, order.fulfilmentWarehouseId, order.warehouse_id)

        if warehouse.billingType == BillingType.OURS_EXTERNAL:

        warehouseClient.scanForOursExternalSaleReturn(order.id, lineitem.transfer_price)

        if order.freebieItemId:

        warehouseClient.scanfreebie(order.id, order.freebieItemId, 0, ScanType.SALE_RET)

        order.status = status_transition[order.status]

        order.statusDescription = OrderStatus._VALUES_TO_NAMES[order.status]

        order.refund_timestamp = datetime.datetime.now()

        order.refunded_by = refunded_by

        order.refund_reason = reason

    #to re evaluate the shipping charge if any order is being cancelled.

    #_revaluate_shiping(order_id)

        session.commit()

        return True*/

        return true;

    }

    @Autowired

    DebitNoteRepository debitNoteRepository;

    //initiate refund only if the stock is returned