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

 from elixir import *
 from random import randrange
 from reportlab.lib.units import inch
 from reportlab.pdfgen.canvas import Canvas
 from reportlab.rl_config import defaultPageSize
+from reportlab.lib.styles import ParagraphStyle
+from reportlab.lib.styles import getSampleStyleSheet
+from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer
 from shop2020.clients.AlertClient import AlertClient
 from shop2020.clients.CatalogClient import CatalogClient
 from shop2020.clients.HelperClient import HelperClient
 from shop2020.clients.InventoryClient import InventoryClient
 from shop2020.clients.LogisticsClient import LogisticsClient
 from shop2020.model.v1.order.impl import DataService, RechargeService
 from shop2020.model.v1.order.impl.DataService import Transaction, LineItem, \
     Order, BatchNoGenerator, InvoiceIDGenerator, TransactionRequiringExtraProcessing, \
     OrderInventory, Alert, PaymentSettlement, EBSSettlementSummary, \
     CodVerificationAgent, Attribute, RechargeVoucherTracker, EmiScheme, \
-    MiscCharges, BlockedIpRange, DeniedIpAddress, InsuranceDetailForOrder
+    MiscCharges, BlockedIpRange, DeniedIpAddress, InsuranceDetailForOrder,\
+    DocumentStore
 from shop2020.model.v1.order.impl.model.MobileRechargeOrder import \
     MobileRechargeOrder
 from shop2020.model.v1.order.impl.model.ReturnOrder import ReturnOrder
 from shop2020.thriftpy.alert.ttypes import MonitoredEntity, EntityType
 from shop2020.thriftpy.logistics.ttypes import DeliveryType, PickUpType
             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.insurer:
+            html_table += "<tr><td colspan=6>&nbsp;</td></tr>"
+            html_table += "<tr><td align='center'></td><td>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'>" + order.insuranceAmount + "</td></tr>"
     emi_amount = 0
     miscCharges = get_misc_charges(transaction_id)
     if miscCharges.get(1):
         emi_amount = miscCharges.get(1)
     email_header = Template(html_header).substitute(dict(order_date = formated_order_date, customer_name = customer_name, source_url = source_url, otgLink = otgLink))
     email_footer = Template(html_footer).substitute(dict(total_amount = "%.2f" % total_amount, emi_amount = "%.2f" % emi_amount, net_amount = "%.2f" % (total_amount-order.gvAmount), secret_code = random_text, store_address = store_address, store_delivery_date = store_delivery_date, source_url = source_url, source_name = source_name))
     try:
         helper_client = HelperClient().get_client()
-        if transaction.orders[0].otg :
-            helper_client.saveUserEmailForSending([user_email], "", subject, email_header + html_table + email_footer, str(transaction_id), "TransactionInfo", [], ['rajneesh.arora@shop2020.in','rajveer.singh@shop2020.in','abhishek.mathur@shop2020.in','amit.sirohi@shop2020.in'])
-        else:
-            helper_client.saveUserEmailForSending([user_email], "", subject, email_header + html_table + email_footer, str(transaction_id), "TransactionInfo", [], [])
+        helper_client.saveUserEmailForSending([user_email], "", subject, email_header + html_table + email_footer, str(transaction_id), "TransactionInfo", [], [])
         return True
     except Exception as e:
         print e
         return False
         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.insurer:
+        html_table += "<tr><td align='center'></td><td>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>"
+        html_table += "<td align='center'>" + order.insuranceAmount + "</td></tr>"
+        total_amount += order.insuranceAmount
     html_footer = """
         <tr><td colspan=5>&nbsp;</td></tr>
         <tr><td colspan=5><hr /></td></tr>
         <tr>
             <td colspan=4>Total Amount</td>
     email_header = Template(html_header).substitute(dict(order_date = formated_order_date, customer_name = customer_name, pickup_text = pickup_text, source_url = source_url))
     email_footer = Template(html_footer).substitute(dict(total_amount = "%.2f" % total_amount, source_name = source_name))
     try:
         helper_client = HelperClient(host_key = "helper_service_server_host_prod").get_client()
-        if order.otg:
-            helper_client.saveUserEmailForSending([user_email], "", subject, email_header + html_table + email_footer, str(order.id), "DeliverySuccess", [], ['rajneesh.arora@shop2020.in','rajveer.singh@shop2020.in','abhishek.mathur@shop2020.in','amit.sirohi@shop2020.in'])
-        else:
-            helper_client.saveUserEmailForSending([user_email], "", subject, email_header + html_table + email_footer, str(order.id), "DeliverySuccess", [], [])
+        helper_client.saveUserEmailForSending([user_email], "", subject, email_header + html_table + email_footer, str(order.id), "DeliverySuccess", [], [])
         return True
     except Exception as e:
         print e
         return False
         else:
             order.status = OrderStatus.DELIVERY_SUCCESS
             order.statusDescription = "Order delivered"
             update_trust_level(order)
             if order.insuranceDetails:
+                try:
-                order.insuranceDetails[0].startDate = order.delivery_timestamp
+                    update_insurance_details(order)
+                except:
-                order.insuranceDetails[0].expiryDate = order.delivery_timestamp + timedelta(days = 365)
+                    print "Error generating insurance file for order " + str(order.id)
+                    session.rollback()
+                    return
             if enqueue_delivery_success_mail(order) :
                 session.commit()
             else :
                 session.rollback()
             try:
                 alert_client.endMonitoringEntity(EntityType.COURIER, "orderId = " + str(order.id))
             except Exception as e:
                 print "Exception in scheduling alert in ShippedFromWarehouse method"
                 print e
+def update_insurance_details(order):
+    order.insuranceDetails[0].startDate = order.delivery_timestamp
+    order.insuranceDetails[0].expiryDate = order.delivery_timestamp + timedelta(days = 365)
+    filename = "/tmp/" + str(order.id) + "-policy.pdf"
+    __generate_policy_doc(order, filename)
+    file = open(filename, "rb")
+    pdfFile = file.read()
+    doc = DocumentStore()
+    doc.docType = 1
+    doc.docSource = order.id
+    doc.document = pdfFile
 def mark_order_as_delivered(orderId, deliveryTimestamp, receiver):
     order = Order.get_by(id=orderId)
     if order == None or order.status not in [OrderStatus.SHIPPED_FROM_WH, OrderStatus.SHIPPED_TO_LOGST, OrderStatus.SHIPPED_TO_DESTINATION_CITY, OrderStatus.REACHED_DESTINATION_CITY, OrderStatus.FIRST_DELIVERY_ATTEMPT_MADE, OrderStatus.DOA_PICKUP_REQUEST_RAISED, OrderStatus.DOA_PICKUP_CONFIRMED, OrderStatus.RET_REQUEST_RECEIVED, OrderStatus.RET_PICKUP_CONFIRMED, OrderStatus.RET_REQUEST_AUTHORIZED, OrderStatus.RET_PICKUP_REQUEST_RAISED, OrderStatus.RTO_IN_TRANSIT, OrderStatus.BILLED, OrderStatus.RECEIVED_AT_STORE]:
         raise TransactionServiceException(101, "Either wrond order id or invalid state " + str(orderId))
         order.receiver = receiver
     order.status = OrderStatus.DELIVERY_SUCCESS
     order.statusDescription = "Order delivered"
     update_trust_level(order)
     if order.insuranceDetails:
+        try:
-        order.insuranceDetails[0].startDate = deliveryTimestamp
+            update_insurance_details(order)
+        except:
-        order.insuranceDetails[0].expiryDate = deliveryTimestamp + timedelta(days = 365)
+            print "Error generating insurance file for order " + str(order.id)
+            session.rollback()
+            return
     session.commit()
     if order.pickupStoreId and order.cod:
         __push_collection_to_hotspot(order, "SALE")
     # Calling helper service on production
     helperClient = HelperClient(host_key = "helper_service_server_host_prod").get_client()
     try:
         emailSubject = 'Shipping Details for Order ID: ' + str(order.id)
         emailBody = get_shipping_confirmation_email_body(order)
-        if order.otg:
-            helperClient.saveUserEmailForSending([order.customer_email], None, emailSubject, emailBody, str(order.id), 'ShippingConfirmation', [], ['rajneesh.arora@shop2020.in','rajveer.singh@shop2020.in','abhishek.mathur@shop2020.in','amit.sirohi@shop2020.in'])
-        else:
-            helperClient.saveUserEmailForSending([order.customer_email], None, emailSubject, emailBody, str(order.id), 'ShippingConfirmation', [], [])
+        helperClient.saveUserEmailForSending([order.customer_email], None, emailSubject, emailBody, str(order.id), 'ShippingConfirmation', [], [])
     except Exception as e:
         print e
 def get_order_distribution_by_status(start_date, end_date):
     email_header = Template(html_header).substitute(dict(order_id = display_order_id, order_date = formated_order_date, email = email, source_url = source_url, order_amount = recharge_order.totalAmount, order_status = status, device_number = deviceNumber, service_provider = providerName, failureReason = failureReason))
     email_footer = Template(html_footer).substitute(dict(source_url = source_url, source_name = source_name))
     try:
         helper_client = HelperClient().get_client()
-        helper_client.saveUserEmailForSending([email], "", source_name + " - Recharge Order Details", email_header + email_footer, str(recharge_order.id), "RechargeInfo", [], ['anupam.singh@shop2020.in', 'rajneesh.arora@shop2020.in', 'abhishek.mathur@shop2020.in', 'amit.sirohi@shop2020.in', 'rajveer.singh@shop2020.in'])
+        helper_client.saveUserEmailForSending([email], "", source_name + " - Recharge Order Details", email_header + email_footer, str(recharge_order.id), "RechargeInfo", [], [])
         return True
     except Exception as e:
         print e
         return False
         session.query(Transaction.id).limit(1).one()
         return True
     except:
         return False
-if __name__ == '__main__':
+def get_document(docType, docSource):
-    print 'Inside main'
-    #def __generate_return_advice(order, warehouse, provider, filename):
+    document = DocumentStore.get_by(docType = docType, docSource = docSource)
-#    if warehouse.id == 7:
+    if document:
-#        executive = 'Amit Kumar'
+        return document.document
-#    else:
+    else:
-#        executive = 'Dinesh Kumar'
+        return None
+def myFirstPage(canvas, doc):
-    from reportlab.lib.styles import ParagraphStyle
+    canvas.saveState()
-    from reportlab.lib.styles import getSampleStyleSheet
+    canvas.setFont('Times-Bold',14)
-    from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer
+    canvas.drawCentredString(PAGE_WIDTH/2.0, PAGE_HEIGHT- inch, "MOBILE HAND SET INSURANCE – THEFT & BURGLARY RISKS ONLY")
-    from reportlab.lib.styles import getSampleStyleSheet
+    canvas.setTitle("Insurance Terms")
-    from reportlab.rl_config import defaultPageSize
+    canvas.restoreState()
-    from reportlab.lib.units import inch
+def __generate_policy_doc(order, filename):
     PAGE_HEIGHT=defaultPageSize[1]; PAGE_WIDTH=defaultPageSize[0]
     styles = getSampleStyleSheet()
     styles.add(ParagraphStyle(name='left', leftIndent=12,fontSize=11), alias='li')
     styles.add(ParagraphStyle(name='bullet', bulletIndent=24, leftIndent=24), alias='bull')
-    Title = "MOBILE HAND SET INSURANCE – THEFT & BURGLARY RISKS ONLY"
-    def myFirstPage(canvas, doc):
-        canvas.saveState()
-        canvas.setFont('Times-Bold',14)
-        canvas.drawCentredString(PAGE_WIDTH/2.0, PAGE_HEIGHT- inch, Title)
-        canvas.setTitle("Insurance Terms")
-        canvas.restoreState()
-    invoiceNumber = 11111111
+    invoiceNumber = order.invoice_number
-    billing_timestamp = '2012-03-14'
+    billing_timestamp = str(order.billing_timestamp.date())
-    doc = SimpleDocTemplate("/home/anupam/Desktop/phello.pdf")
+    doc = SimpleDocTemplate(filename)
     Story = [Spacer(1,0.4*inch)]
     style = styles["Normal"]
     text = ("""<u><b>Subject Matter Of Insurance</b></u> : <i>New Mobile Handsets</i> alone and <i>Tablets with 'Voice Calls'</i> only.
     Sold 'online' by <b>Spice Online Retail Private Limited, New Delhi</b>, to its customers.""")
     p = Paragraph(text, style)
     text = ("<i>Insurance is a subject matter of solicitation.</i>")
     p = Paragraph(text, style)
     Story.append(p)
     Story.append(Spacer(1,0.2*inch))
-    doc.build(Story, onFirstPage=myFirstPage)
     doc.build(Story, onFirstPage=myFirstPage)

Subversion Repositories SmartDukaan

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