Subversion Repositories SmartDukaan

            catalog_client = CatalogClient().get_client() 

        for billingWarehouseId, orders in billingWarehouseIdMap.items():

            logistics_client = LogisticsClient().get_client()

            transactionAmount , transactionWeight = billingWarehouseTxnMap.get(billingWarehouseId)

            costingAndDeliveryEstimateObj = None

            try:

                costingAndDeliveryEstimateObj = logistics_client.getCostingAndDeliveryEstimateForPincode(orders[0].customer_pincode, transactionAmount, False, transactionWeight, billingWarehouseId, False)

            except:

                try:

                    #This will pass the maximum unit price of available product in all scenarios. 

                    subOrderAmountsList = sorted(subOrderAmountsMap.keys())

                    maxUnitPriceOrder = subOrderAmountsMap.get(subOrderAmountsList[len(subOrderAmountsList)-1])

                    costingAndDeliveryEstimateObj = logistics_client.getCostingAndDeliveryEstimateForPincode(orders[0].customer_pincode, maxUnitPriceOrder.lineitems[0].unit_price, False, maxUnitPriceOrder.lineitems[0].unit_weight, billingWarehouseId, False)

                except:

                    #TODO:

                    raise TransactionServiceException(108, "No Logistics Provider Assigned")

                    #This should not be raised lets go ahead

            logisticsCost = costingAndDeliveryEstimateObj.logisticsCost

            logisticsCostInOrders = 0

            current_time = datetime.datetime.now()

            #delivery_delay

            for order in orders:

                deliveryTime = costingAndDeliveryEstimateObj.deliveryTime

                shippingTime = costingAndDeliveryEstimateObj.shippingTime

                delivery_delay = costingAndDeliveryEstimateObj.delivery_delay

                expectedDelay = expectedDelayMap.get(order.lineitems[0].item_id)

                shipping_delay = 24 * expectedDelay

                if shipping_delay < 0:

                    shipping_delay = shippingTime

                else:

                    shipping_delay = shipping_delay + 24 * shippingTime

                    shipping_delay = int(math.ceil(shipping_delay/24.0))

                deliveryTime = adjust_delivery_time(current_time, deliveryTime+shipping_delay)

                shippingTime = adjust_delivery_time(current_time, shipping_delay)

                delivery_delay = adjust_delivery_time(current_time, shipping_delay+delivery_delay)

                #Otg is currently available to both type of users. 

                order.otg = costingAndDeliveryEstimateObj.otgAvailable

                #If RQuick Surface then dont change shipping details

                if order.logistics_provider_id != 48:

                    order.logistics_provider_id = costingAndDeliveryEstimateObj.logistics_provider_id

                #Start:- Added by Manish Sharma for FedEx Integration - Shipment Creation on 31-Jul-2013

                #order.airwaybill_no = logistics_info.airway_billno

                #order.tracking_id = order.airwaybill_no

                #End:- Added by Manish Sharma for FedEx Integration- Shipment Creation on 31-Jul-2013

                #TODO APR2516 Promised Delivery Time should also consider delivery delay.

                    order.courier_delivery_time = (current_time + datetime.timedelta(days=delivery_delay)).replace(hour=PREPAID_SHIPPING_CUTOFF_TIME, minute=0, second=0)

                    order.expected_shipping_time = (current_time + datetime.timedelta(days=shippingTime)).replace(hour=PREPAID_SHIPPING_CUTOFF_TIME, minute=0, second=0)

                    order.promised_shipping_time = order.expected_shipping_time

                    order.expected_delivery_time = (current_time + datetime.timedelta(days=deliveryTime)).replace(hour=PREPAID_SHIPPING_CUTOFF_TIME, minute=0, second=0)

                    order.promised_delivery_time = order.expected_delivery_time

                itemLevelLogisticsCost = round((order.total_weight *logisticsCost)/transactionWeight, 2)

                logisticsCostInOrders = logisticsCostInOrders + itemLevelLogisticsCost

                order.lineitems[0].logisticsCost = itemLevelLogisticsCost

                order.lineitems[0].codCollectionCharges = 0

            orders[0].lineitems[0].logisticsCost = orders[0].lineitems[0].logisticsCost + (round(logisticsCost,2)-logisticsCostInOrders)

        for billingWarehouseId, orders in billingWarehouseIdMap.items():

            logistics_client = LogisticsClient().get_client()

            transactionAmount , transactionWeight = billingWarehouseTxnMap.get(billingWarehouseId)

            costingAndDeliveryEstimateObj = None

            try:

                costingAndDeliveryEstimateObj = logistics_client.getCostingAndDeliveryEstimateForPincode(orders[0].customer_pincode, transactionAmount, True, transactionWeight, billingWarehouseId, False)

            except:

                try:

                    subOrderAmountsList = sorted(subOrderAmountsMap.keys())

                    maxUnitPriceOrder = subOrderAmountsMap.get(subOrderAmountsList[len(subOrderAmountsList)-1])

                    costingAndDeliveryEstimateObj = logistics_client.getCostingAndDeliveryEstimateForPincode(orders[0].customer_pincode, maxUnitPriceOrder.lineitems[0].unit_price, True, maxUnitPriceOrder.lineitems[0].unit_weight, billingWarehouseId, False)

                except:

                    raise TransactionServiceException(108, "No Logistics Provider Assigned")

            current_time = datetime.datetime.now()

            logisticsCost = costingAndDeliveryEstimateObj.logisticsCost

            logisticsCostInOrders = 0

            codCollectionCharges = costingAndDeliveryEstimateObj.codCollectionCharges

            codCollectionChargesInOrders = 0

            #delivery_delay

            for order in orders:

                deliveryTime = costingAndDeliveryEstimateObj.deliveryTime

                shippingTime = costingAndDeliveryEstimateObj.shippingTime

                delivery_delay = costingAndDeliveryEstimateObj.delivery_delay

                expectedDelay = expectedDelayMap.get(order.lineitems[0].item_id)

                shipping_delay = 24 * expectedDelay

                if shipping_delay < 0:

                    shipping_delay = shippingTime

                else:

                    shipping_delay = shipping_delay + 24 * shippingTime

                    shipping_delay = int(math.ceil(shipping_delay/24.0))

                deliveryTime = adjust_delivery_time(current_time, deliveryTime+shipping_delay)

                shippingTime = adjust_delivery_time(current_time, shipping_delay)

                delivery_delay = adjust_delivery_time(current_time, shipping_delay+delivery_delay) 

                order.otg = costingAndDeliveryEstimateObj.otgAvailable

                order.logistics_provider_id = costingAndDeliveryEstimateObj.logistics_provider_id

                #Start:- Added by Manish Sharma for FedEx Integration - Shipment Creation on 31-Jul-2013

                #order.airwaybill_no = logistics_info.airway_billno

                #order.tracking_id = order.airwaybill_no

                #End:- Added by Manish Sharma for FedEx Integration- Shipment Creation on 31-Jul-2013

                order.courier_delivery_time = (current_time + datetime.timedelta(days=delivery_delay)).replace(hour=PREPAID_SHIPPING_CUTOFF_TIME, minute=0, second=0)

                order.expected_shipping_time = (current_time + datetime.timedelta(days=shippingTime)).replace(hour=PREPAID_SHIPPING_CUTOFF_TIME, minute=0, second=0)

                order.promised_shipping_time = order.expected_shipping_time

                order.expected_delivery_time = (current_time + datetime.timedelta(days=deliveryTime)).replace(hour=PREPAID_SHIPPING_CUTOFF_TIME, minute=0, second=0)

                order.promised_delivery_time = order.expected_delivery_time

                itemLevelLogisticsCost = round((order.total_weight *logisticsCost)/transactionWeight, 2)

                logisticsCostInOrders = logisticsCostInOrders + itemLevelLogisticsCost

                itemLevelCodCollectionCharges = round((order.total_amount *codCollectionCharges)/transactionAmount, 2)

                codCollectionChargesInOrders = codCollectionChargesInOrders + itemLevelCodCollectionCharges

                order.lineitems[0].logisticsCost = itemLevelLogisticsCost

                order.lineitems[0].codCollectionCharges = itemLevelCodCollectionCharges

            orders[0].lineitems[0].logisticsCost = orders[0].lineitems[0].logisticsCost + (round(logisticsCost,2)-logisticsCostInOrders)

            orders[0].lineitems[0].codCollectionCharges = orders[0].lineitems[0].codCollectionCharges + (round(codCollectionCharges,2)-codCollectionChargesInOrders)                        

            elif order.source == OrderSource.STORE:

                order.otg = False

                session.commit()

                catalog_client = CatalogClient().get_client() 

                sourcePricing = catalog_client.getStorePricing(order.lineitems[0].item_id)

                if order.total_amount >= sourcePricing.minPrice:

                    order.status = OrderStatus.SUBMITTED_FOR_PROCESSING

                    order.statusDescription = "Order Accepted"

                    session.commit()

                    sod = StoreOrderDetail.get_by(orderId = order.id)

                    __push_store_collection_to_hotspot(order, "advance", sod.cashAmount, sod.cardAmount)

                else: 

                    order.status = OrderStatus.COD_VERIFICATION_PENDING

                    order.statusDescription = "Approval Pending"

                    content = "<html><body>"

                    content += "<h4>Order Id:  " + str(order.id) + "</h4>"

                    content += "<h4>Product:  " + str(order.lineitems[0]) + "</h4>"

                    content += "<h4>Min Price: " +  str(sourcePricing.minPrice) + "</h4>"

                    content += "<h4>Recommended Price: " +  str(sourcePricing.recommendedPrice) + "</h4>"

                    content += "<h2>Approval Requested for Price: " +  str(order.total_amount) + "</h2>"

                    content += "<h2>Note 1: If this discount price is approved then reply 'Approved' otherwise 'Not Approved' without changing anythig in the Mail.</h2>"  

                    content += "<h2>Note 2: For Quick approval using browser <a href='http://support.shop2020.in:8080/Support/price-approval?xszbg=" + base64.b64encode(str(order.id))  + "'>Click Here</a></h2>"

                    content += "<br><br></body></html>"

                    store = get_hotspot_store(order.storeId, "")

                    helper_client = HelperClient().get_client()

                    helper_client.saveUserEmailForSending(store.approvalEmail.split(';'), SaholicHelpEmailId, "Price approval requested for " + str(order.lineitems[0]) + " order Id " + str(order.id) + " in store " + store.hotspotId , content, str(transaction_id), "PriceApproval", [], [], 1)

                    session.commit()

    #TODO: Primary logic for provider assignment will suffice no need to reassign.

    shipmentAmount = 0

    shipmentWeight = 0

    isCod = False

    if ordersList[0].cod:

        isCod = True

    if ordersList[0].logistics_provider_in [4, 5]:

        return ordersList

    for order in ordersList:

        shipmentAmount = shipmentAmount + order.total_amount

        shipmentWeight = shipmentWeight + order.total_weight

    logistics_client = LogisticsClient().get_client()

    costingAndDeliveryEstimateObj = None

    try:

        costingAndDeliveryEstimateObj = logistics_client.getCostingAndDeliveryEstimateForPincode(ordersList[0].customer_pincode, shipmentAmount, isCod, shipmentWeight, ordersList[0].warehouse_id, False)

    except:

        raise TransactionServiceException(227, "No Provider Assigned for these orders. Please select less orders.")

    logisticsCost = costingAndDeliveryEstimateObj.logisticsCost

    logisticsCostInOrders = 0

    codCollectionCharges = costingAndDeliveryEstimateObj.codCollectionCharges

    codCollectionChargesInOrders = 0 

    for order in ordersList:

        current_time = order.created_timestamp

        deliveryTime = costingAndDeliveryEstimateObj.deliveryTime

        shippingTime = costingAndDeliveryEstimateObj.shippingTime

        delivery_delay = costingAndDeliveryEstimateObj.delivery_delay

        shipping_delay = 24 * shippingTime

        shipping_delay = int(math.ceil(shipping_delay/24.0))

        deliveryTime = adjust_delivery_time(current_time, deliveryTime+shipping_delay)

        shippingTime = adjust_delivery_time(current_time, shipping_delay)

        delivery_delay = adjust_delivery_time(current_time, shipping_delay+delivery_delay) 

        order.otg = costingAndDeliveryEstimateObj.otgAvailable

        order.logistics_provider_id = costingAndDeliveryEstimateObj.logistics_provider_id

        #Start:- Added by Manish Sharma for FedEx Integration - Shipment Creation on 31-Jul-2013

        #order.airwaybill_no = logistics_info.airway_billno

        #order.tracking_id = order.airwaybill_no

        #End:- Added by Manish Sharma for FedEx Integration- Shipment Creation on 31-Jul-2013

        order.courier_delivery_time = (current_time + datetime.timedelta(days=delivery_delay)).replace(hour=PREPAID_SHIPPING_CUTOFF_TIME, minute=0, second=0)

        order.expected_shipping_time = (current_time + datetime.timedelta(days=shippingTime)).replace(hour=PREPAID_SHIPPING_CUTOFF_TIME, minute=0, second=0)

        order.promised_shipping_time = order.expected_shipping_time

        order.expected_delivery_time = (current_time + datetime.timedelta(days=deliveryTime)).replace(hour=PREPAID_SHIPPING_CUTOFF_TIME, minute=0, second=0)

        order.promised_delivery_time = order.expected_delivery_time

        itemLevelLogisticsCost = round((order.total_weight *logisticsCost)/shipmentWeight, 2)

        logisticsCostInOrders = logisticsCostInOrders + itemLevelLogisticsCost

        if codCollectionCharges >0:

            itemLevelCodCollectionCharges = round((order.total_amount *codCollectionCharges)/shipmentAmount, 2)

            codCollectionChargesInOrders = codCollectionChargesInOrders + itemLevelCodCollectionCharges

            order.lineitems[0].codCollectionCharges = itemLevelCodCollectionCharges

        order.lineitems[0].logisticsCost = itemLevelLogisticsCost

    ordersList[0].lineitems[0].logisticsCost = ordersList[0].lineitems[0].logisticsCost + (round(logisticsCost,2)-logisticsCostInOrders)

    if codCollectionCharges>0:

        ordersList[0].lineitems[0].codCollectionCharges = ordersList[0].lineitems[0].codCollectionCharges + (round(codCollectionCharges,2)-codCollectionChargesInOrders)                        

    session.commit()

    return ordersList