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

+# -*- coding: utf-8 -*-
 '''
 Created on 29-Mar-2010
 @author: Chandranshu
 '''
 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
+    MiscCharges, BlockedIpRange, DeniedIpAddress, InsuranceDetailForOrder
 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
     if t_order.created_timestamp:
         order.created_timestamp = to_py_date(t_order.created_timestamp)
     else:
         order.created_timestamp = datetime.datetime.now()
     order.pickupStoreId = t_order.pickupStoreId
+    order.insurer = t_order.insurer
+    order.insuranceAmount = t_order.insuranceAmount
+    if order.insurer > 0:
+        insuranceDetail = InsuranceDetailForOrder()
+        insuranceDetail.dob = t_order.dob
+        insuranceDetail.guardianName = t_order.guardianName
+        insuranceDetail.order = order
     return order
 def create_transaction(t_transaction):
     t_orders = t_transaction.orders
     if not t_orders:
                 print e
         else:
             order.status = OrderStatus.DELIVERY_SUCCESS
             order.statusDescription = "Order delivered"
             update_trust_level(order)
+            if order.insuranceDetails:
+                order.insuranceDetails[0].startDate = order.delivery_timestamp
+                order.insuranceDetails[0].expiryDate = order.delivery_timestamp + timedelta(days = 365)
             if enqueue_delivery_success_mail(order) :
                 session.commit()
             else :
                 session.rollback()
             try:
             order.first_dlvyatmp_timestamp = deliveryTimestamp
         order.receiver = receiver
     order.status = OrderStatus.DELIVERY_SUCCESS
     order.statusDescription = "Order delivered"
     update_trust_level(order)
+    if order.insuranceDetails:
+        order.insuranceDetails[0].startDate = deliveryTimestamp
+        order.insuranceDetails[0].expiryDate = deliveryTimestamp + timedelta(days = 365)
     session.commit()
     if order.pickupStoreId and order.cod:
         __push_collection_to_hotspot(order, "SALE")
     except:
         return False
 if __name__ == '__main__':
     print 'Inside main'
-    DataService.initialize()
-    '''a = MobileRechargeOrder()
-    session.commit()
-    a.mobileNumber = 89564785666
-    session.commit()
-    '''
     #def __generate_return_advice(order, warehouse, provider, filename):
+#    if warehouse.id == 7:
+#        executive = 'Amit Kumar'
+#    else:
+#        executive = 'Dinesh Kumar'
+    from reportlab.lib.styles import ParagraphStyle
+    from reportlab.lib.styles import getSampleStyleSheet
+    from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer
+    from reportlab.lib.styles import getSampleStyleSheet
+    from reportlab.rl_config import defaultPageSize
+    from reportlab.lib.units import inch
+    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
+    billing_timestamp = '2012-03-14'
+    doc = SimpleDocTemplate("/home/anupam/Desktop/phello.pdf")
+    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)
+    Story.append(p)
+    Story.append(Spacer(1,0.2*inch))
+    text = ("""Insurer will indemnify the Insured in the event of Theft/Burglary of <i>Mobile Handsets</i>
+    alone and <i>Tablets with 'Voice Calls'</i> only sold as per Invoice No. %d
+    dated %s and insured with THE NEW INDIA ASSURANCE COMPANY LIMITED, BANGALORE, as per Policy No. 671700/46/12/2400000008,
+    for a period of 12 months from the date and time of delivery of Mobile Handset to the customer.""" % (invoiceNumber, billing_timestamp))
+    p = Paragraph(text, style)
+    Story.append(p)
+    Story.append(Spacer(1,0.2*inch))
+    text = ("""<b>WARRANTY</b> -  Warranted that the Mobile Handset sold during the Policy Period of 25/02/2013 to 24/02/2014
+             are only covered irrespective of date of delivery to the customer""")
+    p = Paragraph(text, style)
+    Story.append(p)
+    Story.append(Spacer(1,0.2*inch))
+    text = ("<b>INSURER</b> - New India Assurance company limited.")
+    p = Paragraph(text, style)
+    Story.append(p)
+    Story.append(Spacer(1,0.2*inch))
+    text = ("<b>INSURED</b> - Purchaser of the Mobile Handset OR his/her spouse or children. If the Purchaser is a ‘Company’, user is the duly authorised person.")
+    p = Paragraph(text, style)
+    Story.append(p)
+    Story.append(Spacer(1,0.2*inch))
+    text = ("<b>GEOGRAPHICAL LIMIT</b> – World-wide")
+    p = Paragraph(text, style)
+    Story.append(p)
+    Story.append(Spacer(1,0.2*inch))
+    text = ("<b>RISK COVERAGE</b> – Theft and/or burglary only")
+    p = Paragraph(text, style)
+    Story.append(p)
+    Story.append(Spacer(1,0.2*inch))
+    text = ("Exclusions:")
+    p = Paragraph(text, styles["h2"])
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("Insurer is not liable")
+    p = Paragraph(text, styles["left"])
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("If the handset is not connected to Mobile Service Provider Network")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("Caused by incorrect storage, poor care and maintenance, careless use, negligence.")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("Due to mysterious disappearance, forgotten or misplaced or Lost or if handset is left unattended at any point of time.")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("Caused by war, war like operation, act of foreign enemy, civil war, rebellion, civil commotion, military usurped power, seizure, capture, confiscation, arrests, restrains and detainment by order of any Government or any other Authority.")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("Caused whilst engaging in criminal acts.")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("Caused by consequential loss or damage of whatsoever nature or any costs incurred in connection with claim under this policy, including postage, transit costs and reconnection cost.")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("Loss of mobile handset due to theft from an unattended vehicle unless the vehicle is of  fully enclosed saloon type having at time all the doors/windows and other opening securely locked and properly fastened.")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("Loss of mobile handset due to theft from the building unless there is visible forcible entry/exit into/from the building.")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("If the documents are found to be tampered; non-disclosure of material fact, fraud/misrepresentation.")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("The policy is not transferable.")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.2*inch))
+    text = ("Claim Procedure:")
+    p = Paragraph(text, styles["h2"])
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("""For Theft or Burglary of the handset immediate intimation to be given
+     to the police within 48 hours of occurrence of incident and proper documents to be obtained
+     and inform the service provider within 48 hours about theft of handset in order to block the SIM services.""")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("""To intimate Insurance Company about the loss of Mobile Handset within 48 hours
+     through Call Centre No.022-49107910 OR through e-mail saholic.claims@universalinsurance.co.in OR through
+     written communication to <i>Universal Insurance brokers (UIB) No.304, Commerce House, 9/1,Cunningham Road, Bangalore – 560052</i>.""")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("""Claim documents can be downloaded through UIB Website ***TO BE DECIDED***
+    To know or track your claim please contact Call Centre No. 022-49107910 of Universal Insurance brokers (UIB). """)
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("""All the completed claim documents to reach ‘Universal Insurance Brokers (UIB)’ office
+    at <i>No.304, Commerce House, 9/1, Cunningham Road, Bangalore – 560052</i> <b>within 21 days</b>.""")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.2*inch))
+    text = ("Excess(Minimum Deduction):")
+    p = Paragraph(text, styles["h2"])
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("""The excess will be 5% of the value of each claim subject to a minimum of Rs.500/-""")
+    p = Paragraph(text, styles["left"])
+    Story.append(p)
+    Story.append(Spacer(1,0.2*inch))
+    text = ("Depreciation:")
+    p = Paragraph(text, styles["h2"])
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("For 0 – 60 days, 15%")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("61-150 days, 30%")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.1*inch))
+    text = ("151 – 365 days, 45%")
+    p = Paragraph(text, styles["bullet"], bulletText='\xe2\x80\xa2')
+    Story.append(p)
+    Story.append(Spacer(1,0.4*inch))
+    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)

Subversion Repositories SmartDukaan

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