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

     if order.insurer > 0:
         insuranceDetail = InsuranceDetailForOrder()
         insuranceDetail.dob = t_order.dob
         insuranceDetail.guardianName = t_order.guardianName
         insuranceDetail.order = order
+    if t_order.freebieItemId:
+        order.freebieItemId = t_order.freebieItemId
     return order
 def create_transaction(t_transaction):
     t_orders = t_transaction.orders
     if not t_orders:
             html_tr += "<td align='center'>" + ("%.0f" % lineitem.quantity) + "</td>"
             html_tr += "<td align='center'> Rs. " + ("%.2f" % lineitem.unit_price) + "</td>"
             html_tr += "<td align='center'> Rs. " + ("%.2f" % lineitem_total_price) + "</td></tr>"
             total_amount += lineitem_total_price
             html_table += html_tr
+        if order.freebieItemId:
+            catalog_client = CatalogClient().get_client()
+            item = catalog_client.getItem(order.freebieItemId)
+            html_table += "<tr><td align='center'></td><td style='font-style:italic;'> Free Item: "+item.brand + " " + item.modelName + " " + item.modelNumber+"</td><td align='center'></td><td align='center'></td><td align='center'></td><td align='center'></td></tr>"
         if order.insurer:
             html_table += "<tr><td colspan=6>&nbsp;</td></tr>"
             html_table += "<tr><td align='center'></td><td style='font-style:italic;'>Insured Against Theft for 1 Year. <a href='http://www.saholic.com/static/insurance-terms'>Know More</a></td><td align='center'></td><td align='center'></td><td align='center'></td>"
             html_table += "<td align='center'>" + str(order.insuranceAmount) + "</td></tr>"
             total_amount += order.insuranceAmount
                 inventoryClient.reduceReservationCount(itemId, order.fulfilmentWarehouseId, sourceId, order.id, order.lineitems[0].quantity)
                 inventoryClient.reserveItemInWarehouse(itemId, warehouse.id, sourceId, order.id, to_java_date(order.created_timestamp), to_java_date(order.promised_shipping_time), order.lineitems[0].quantity)
                 order.fulfilmentWarehouseId = warehouse.id
                 break
-def add_billing_details(orderId, invoice_number, serialNumbers, itemNumbers, billedBy, jacketNumber, billingType, fulfilmentWarehouseId, authorize):
+def add_billing_details(orderId, invoice_number, serialNumbers, itemNumbers, freebieWarehouseId, billedBy, jacketNumber, billingType, fulfilmentWarehouseId, authorize):
     if jacketNumber is None or jacketNumber <= 0:
         raise TransactionServiceException(110, "Invalid jacket number")
     if billedBy is None or billedBy.strip() == "":
         raise TransactionServiceException(110, "Invalid Biller")
     order = Order.get_by(id=orderId)
     if not order:
         raise TransactionServiceException(101, "No order found for the given order id" + str(orderId))
+    '''
+    First checking whether freebie can be billed or not otherwise wont proceed.
+    '''
+    if billingType == BillingType.OURS:
+        if order.freebieItemId is not None or order.freebieItemId>0:
+            if freebieWarehouseId is not None or freebieWarehouseId >0:
+                try:
+                    warehouse_client = WarehouseClient().get_client()
+                    inventoryItem = warehouse_client.scanfreebie(orderId, order.freebieItemId, freebieWarehouseId, ScanType.SALE);
+                    attr = Attribute()
+                    attr.orderId = orderId
+                    attr.name = "freebie_tp"
+                    attr.value = str(inventoryItem.unitPrice)
+                    attr1 = Attribute()
+                    attr1.orderId = orderId
+                    attr1.name = "freebie_vendor"
+                    attr1.value = str(inventoryItem.supplierId)
+                    inventory_client = InventoryClient().get_client()
+                    warehouse = inventory_client.getWarehouse(freebieWarehouseId)
+                    item_pricing = inventory_client.getItemPricing(order.freebieItemId, warehouse.vendor.id)
+                    #lineitem.transfer_price = item_pricing.transferPrice
+                    attr2 = Attribute()
+                    attr2.orderId = orderId
+                    attr2.name = "freebie_nlc"
+                    attr2.value = str(item_pricing.nlc)
+                except Exception as e:
+                    print sys.exc_info()[0]
+                    print e.message
+                    raise Exception('Error in billing freebie for warehouseId ' + str(freebieWarehouseId))
     lineitem = order.lineitems[0]
     item_id = lineitem.item_id
 #    inventoryClient = InventoryClient().get_client()
 <div>
     <p>Dear Customer,</p>
     <p>
         We are pleased to inform that we have shipped the order: $order_id for your product $product_name on $shipping_datetime.
         The shipment will be delivered to you via $courier_name Courier Service vide AWB# $awb.
+        $freebie_text
     </p>
     <p>
         Expected delivery date for your order is $expected_delivery_date.
         <br/>
         $otg_text
             otg_text = 'Your order is covered under our <a href="http://www.saholic.com/static/on-time-guarantee">On Time Guarantee; We Pay if we Delay.</a> We apologize in advance for the expected delay from our initial promised delivery date of ' + promised_delivery_date + '. Your will receive a Gift Voucher Code at time of delivery based on the actual delay. You can use the same to buy any Mobile, Camera, Laptop, Tablet, Accessory or Mobile/DTH Recharge from our website.'
         elif new_expected_delivery_timestamp < order.promised_delivery_time:
             otg_text = 'We are happy to inform you that we expect to deliver your order before time. Your order is covered under our <a href="http://www.saholic.com/static/on-time-guarantee">On Time Guarantee; We Pay if we Delay.</a> Please note, compensation for delay (If Any) will be computed from the initial promised delivery date of ' + promised_delivery_date + '.'
         else:
             otg_text = 'Your order is covered under our <a href="http://www.saholic.com/static/on-time-guarantee">On Time Guarantee; We Pay if we Delay.</a> We are committed to deliver your order by our initial promised delivery date of ' + promised_delivery_date + '.'
+    freebie_text = "<br/>"
+    if order.freebieItemId:
+        catalog_client = CatalogClient().get_client()
+        item = catalog_client.getItem(order.freebieItemId)
+        freebie_text = freebie_text = "We have also sent you " + item.brand + " " + item.modelName + item.modelNumber +" as promised"
+    else:
+        freebie_orderId = get_order_attribute_value(order.id, "freebieOrderId")
+        if freebie_orderId != "":
+            line_items = get_line_items_for_order(int(freebie_orderId))
+            freebie_text = freebie_text + "Due to some unavoidable issues in procuring " +line_items(0).brand + " " + line_items(0).model_name + " " + line_items(0).model_number
+            freebie_text = freebie_text + " Your freebie will be sent as a separate order with OrderId : " + freebie_orderId + "<br/> You can track the status of this order from My Orders section in saholic.com"
-    info = dict(order_id = order.id, product_name = product, shipping_datetime = shipping_date, awb = order.airwaybill_no, expected_delivery_date = new_expected_delivery_date, courier_name = provider_name, courier_phone = provider_phone, source_name = source_name, otg_text = otg_text)
+    info = dict(order_id = order.id, product_name = product, shipping_datetime = shipping_date, awb = order.airwaybill_no, expected_delivery_date = new_expected_delivery_date, courier_name = provider_name, courier_phone = provider_phone, source_name = source_name, otg_text = otg_text, freebie_text = freebie_text)
     return Template(html).substitute(info)
 def enqueue_shipping_confirmation_email(order):
     # Calling helper service on production
     helperClient = HelperClient(host_key = "helper_service_server_host_prod").get_client()
     invNum = str(recharge.invoiceNumber)
     billingTime = recharge.responseTime
     payMethod = recharge.payMethod
     return __printRechargeInvoice(filename, operator, amount, telNum, customerName, invNum, billingTime, payMethod)
+def split_freebie_order(order_id, splitReason, shippingDate):
+    order = get_order(order_id)
+    freebie_order = Order()
+    freebie_order.transaction = order.transaction
+    freebie_order.customer_id = order.customer_id
+    freebie_order.customer_email = order.customer_email
+    freebie_order.customer_name = order.customer_name
+    freebie_order.customer_pincode = order.customer_pincode
+    freebie_order.customer_address1 = order.customer_address1
+    freebie_order.customer_address2 = order.customer_address2
+    freebie_order.customer_city = order.customer_city
+    freebie_order.customer_state = order.customer_state
+    freebie_order.customer_mobilenumber = order.customer_mobilenumber
+    freebie_order.total_weight = order.total_weight
+    freebie_order.total_amount = 0.01
+    freebie_order.status = OrderStatus.SUBMITTED_FOR_PROCESSING
+    freebie_order.statusDescription = "In Process";
+    freebie_order.created_timestamp = datetime.datetime.now()
+    freebie_order.cod = 0
+    freebie_order.orderType = OrderType.B2C
+    freebie_order.pickupStoreId = 0
+    freebie_order.otg = 0
+    freebie_order.insurer = 0
+    freebie_order.insuranceAmount = 0
+    logistics_client = LogisticsClient().get_client()
+    logistics_info = logistics_client.getLogisticsInfo(order.customer_pincode, 1, DeliveryType.PREPAID, PickUpType.COURIER)
+    freebie_order.logistics_provider_id = logistics_info.providerId;
+    freebie_order.tracking_id = logistics_info.airway_billno
+    freebie_order.airwaybill_no = logistics_info.airway_billno
+    freebie_order.expected_delivery_time = (to_py_date(shippingDate)+datetime.timedelta(days=logistics_info.deliveryTime)).replace(hour=PREPAID_SHIPPING_CUTOFF_TIME, minute=0, second=0)
+    freebie_order.promised_delivery_time = order.promised_delivery_time
+    freebie_order.expected_shipping_time = to_py_date(shippingDate)
+    freebie_order.promised_shipping_time = order.promised_shipping_time
+    inventory_client = InventoryClient().get_client()
+    item_availability = inventory_client.getItemAvailabilityAtLocation(freebie_order.lineitems[0].item_id,1)
+    freebie_order.warehouse_id = item_availability[2]
+    freebie_order.fulfillmentWarehouseId = item_availability[0]
+    catalog_client = CatalogClient().get_client()
+    item = catalog_client.getItem(order.freebieItemId)
+    freebie_order.total_weight = item.weight
+    litem = LineItem()
+    litem.item_id = item.id
+    litem.productGroup = item.productGroup
+    litem.brand = item.brand
+    litem.model_number = item.modelNumber
+    litem.model_name = item.modelName
+    litem.color = item.color
+    litem.extra_info = "Freebie Order for Order ID " + str(order.id)
+    litem.quantity = 1
+    litem.unit_price = 0.01
+    litem.unit_weight = item.weight
+    litem.total_price = 0.01
+    litem.total_weight = item.weight
+    litem.vatRate = 5.0
+    freebie_order.lineitems.append(litem)
+    session.commit()
+    inventory_client.reserveItemInWarehouse(freebie_order.lineitems[0].item_id, item_availability[0], 1, freebie_order.id, datetime.datetime.now(), order.promised_shipping_time, 1)
+    parentOrderAttribute = Attribute()
+    parentOrderAttribute.orderId = freebie_order.id
+    parentOrderAttribute.name = "parentOrderIdForFreebie"
+    parentOrderAttribute.value = str(order.id)
+    freebieOrderAttribute = Attribute()
+    freebieOrderAttribute.orderId = order.id
+    freebieOrderAttribute.name = "freebieOrderId"
+    freebieOrderAttribute.value = str(freebie_order.id)
+    session.commit()
+    return freebie_order
 def __printRechargeInvoice(filename, operator, amount, telNum, customerName, invNum, billingTime, payMethod):
     PAGE_HEIGHT=defaultPageSize[1];
     styles = getSampleStyleSheet()
     styles.add(ParagraphStyle(name='prologue', alignment=TA_CENTER, fontName="Courier", rightIndent = 5, fontSize=10), alias='sH')
     styles.add(ParagraphStyle(name='text', alignment=TA_JUSTIFY, fontName="Courier", fontSize=10), alias='text')

Subversion Repositories SmartDukaan

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