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

             end_date = end_date + datetime.timedelta(days = 1)
         start_date = start_date + datetime.timedelta(days = 1)
     return delivery_days
+def get_business_days_count(start_time, end_time):
+    '''
+    Returns business dates between two dates
+    '''
+    start_date = start_time.date()
+    end_date  = end_time.date()
+    diff = (end_date - start_date).days + 1
+    sundays = diff/7 + 1 if (start_date.weekday()==6) else 0
+    '''holidays = __get_holidays(start_time, end_time)'''
+    logistics_client = LogisticsClient().get_client()
+    #TODO: This list should be cached after the first call.
+    #Calling logistics server is also unnecessary.
+    holidays = logistics_client.getHolidays(to_java_date(start_time), to_java_date(end_time))
+    non_business_days = len(holidays)
+    for holiday in holidays:
+        if holiday.weekday() == 6:
+            sundays = sundays - 1
+    return diff - (non_business_days + sundays)
 def enqueue_transaction_info_email(transaction_id):
     transaction = get_transaction(transaction_id)
     customer_name = ""
     html_header = """
 <html>
         for lineitem in order.lineitems:
             lineitem_total_price = round(lineitem.total_price, 2)
             html_tr += "<td>" + str(lineitem) + "</td>"
+            if order.otg:
+                html_tr += "<td align='center'><div>" + store_delivery_date + "</div><br><div>On Time Guarantee<span style=color:red>We pay id we delay</span></div></td>"
+            else:
-            html_tr += "<td align='center'>" + store_delivery_date + "</td>"
+                html_tr += "<td align='center'>" + store_delivery_date + "</td>"
             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
     <body>
     <div>
         <p>
             Dear $customer_name,<br /><br />
     """
     if order.pickupStoreId:
         pickup_text = "Pickup Date: " + order.delivery_timestamp.strftime("%A, %d. %B %Y %I:%M%p")
         thank_you_html = """
         Thank you for shopping with us and picking up your order in Store. Please do join us at our <a href="http://www.facebook.com/mysaholic">Facebook Page</a>, and share your experience with other shoppers.<br><br>
         Following are the details of your order for which the pickup has happened. If you have not picked up this product please <a href="$source_url/contact-us" target="_blank">contact us</a> immediately.<br>
         """
     else:
         pickup_text = ""
+        if order.otg:
+            delayed = False
+            fda = False
+            if order.first_dlvyatmp_timestamp.date() < order.delivery_timestamp.date():
+                fda = True
+            fda_datetime = order.first_dlvyatmp_timestamp
+            fda_date = fda_datetime.date()
+            if order.expected_delivery_time.date() < fda_date:
+                delayed = True
+            if not delayed and not fda:
+                thank_you_html = """As Promised """ + str(order.lineitems[0]) +""" ordered by you has been <b>Delivered On Time.</b>"""
+            elif delayed:
+                max_discount = 500
+                delayedDays = get_business_days_count(order.expected_delivery_time + datetime.timedelta(days = 1), fda_datetime)
+                max_discount = min(max_discount, order.lineitems[0].unit_price/10)
+                discount = min(max_discount,delayedDays*50)
+                promotion_client = PromotionClient().get_client()
+                endOn =  order.delivery_timestamp + datetime.timedelta(days = 30)
+                endOn = to_java_date(endOn)
+                otgCoupon = promotion_client.createCouponWithPrefix(27, endOn, order.customer_email, discount, False, 1, "otg")
-        thank_you_html = """
+                thank_you_html = '$prodName ordered by you has been delivered. We apologise for a delay of $delayedDays days. As per our <b>On Time Gaurantee</b> you have won a Gift Voucher worth <b>Rs.$discount</b>. Your unique Gift Voucher Code is <b>$otgCoupon</b>. You can use the same to buy any Mobile, Camera, Laptop, Tablet or Accessory from our website.'
+                thank_you_html = Template(thank_you_html).substitute(dict(prodName=order.lineitems[0], delayedDays = delayedDays, discount = discount, otgCoupon = otgCoupon))
+            elif fda:
+                fdaFormattedString = order.first_dlvyatmp_timestamp.strftime("%A, %d. %B %Y")
+                thank_you_html = str(order.lineitems[0]) + """ ordered by you has been delivered.  The First Delivery attempt was made on """+ fdaFormattedString +""" , within our commited estimated time for delivery."""
+            thank_you_html = thank_you_html + """If you are happy with our services please join us on <a href="http://www.facebook.com/mysaholic">Facebook</a>/<a href="https://twitter.com/saholic">Twitter</a> and help us spread the word."""
+        else :
+            thank_you_html = str(order.lineitems[0]) + """ ordered by you has been delivered.
-        Thank you for shopping with us. Please do join us at our <a href="http://www.facebook.com/mysaholic">Facebook Page</a>, and share your experience with other shoppers. Following are the details of your order.<br>
+            Thank you for shopping with us. Please do join us at our <a href="http://www.facebook.com/mysaholic">Facebook Page</a>, and share your experience with other shoppers. Following are the details of your order.<br>
-        """
+            """
     html_header = html_header + thank_you_html + """
         </p>
         <div>
             Order Date: $order_date <br>
 def mark_orders_as_delivered(provider_id, delivered_orders):
     for awb, detail in delivered_orders.iteritems():
         order = Order.query.filter_by(airwaybill_no=awb, logistics_provider_id = provider_id).first()
         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]:
             continue
+        timestamp, receiver = detail.split('|')
+        order.delivery_timestamp = datetime.datetime.strptime(timestamp, "%Y-%m-%d %H:%M:%S")
+        if order.first_dlvyatmp_timestamp is None:
-            #raise TransactionServiceException(103, "No order found for the awb:" + awb)
+            order.first_dlvyatmp_timestamp = order.delivery_timestamp
+        order.receiver = receiver
         if order.pickupStoreId:
             order.status = OrderStatus.DELIVERED_AT_STORE
             order.statusDescription = "Order delivered At Store"
             try:
                 monitoredEntity = MonitoredEntity();
                 alert_client = AlertClient().get_client()
                 alert_client.endMonitoringEntity(EntityType.COURIER, "orderId = " + str(order.id))
             except Exception as e:
                 print "Exception in scheduling alert in ShippedFromWarehouse method"
                 print e
-        timestamp, receiver = detail.split('|')
-        if order.first_dlvyatmp_timestamp is None:
-            order.first_dlvyatmp_timestamp = timestamp
-        order.delivery_timestamp = timestamp
-        order.receiver = receiver
     session.commit()
 def mark_order_as_delivered(orderId, deliveryTimestamp, receiver):
     order = Order.get_by(id=orderId)
             pc = PromotionClient().get_client()
             enddate = datetime.datetime.now() + datetime.timedelta(days=45)
             while totalAmount > 0:
                 gvAmount = totalAmount if totalAmount <= 250 else 250
                 totalAmount = totalAmount - gvAmount
-                gv = pc.createCoupon(26, to_java_date(enddate), recharge_order.userEmailId, gvAmount, False, 1)
+                gv = pc.createCoupon(26, to_java_date(enddate), recharge_order.userEmailId, gvAmount, False, 1, None)
                 gvs[gv] = gvAmount
         except:
             print "Not able to create gift voucher for user " + recharge_order.userEmailId
     return gvs
         return False
 if __name__ == '__main__':
     print 'Inside main'
     DataService.initialize()
-    a = MobileRechargeOrder()
+    '''a = MobileRechargeOrder()
+    session.commit()
     a.mobileNumber = 89564785666
     session.commit()

Subversion Repositories SmartDukaan

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