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

         return True
     except Exception as e:
         print e
         return False
+def enqueue_received_at_store_email(order):
+    html_header = """
+    <html>
+    <body>
+    <div>
+        <p>
+            Hello $customer_name,<br /><br />
+            Your Product has reached the Store selected by you and is available for pickup. Please pick up your product on or before $order_expiry_date. Following are the details of your order and steps to pickup the same:
+        </p>
+        <div>
+            Order Date: $order_date
+        </div>
+        <div>
+            <table>
+            <tr><td colspan="5"><hr /></td></tr>
+            <tr><td colspan="5" align="left"><b>Order Details</b></td></tr>
+            <tr><td colspan="5"><hr /></td></tr>
+            <tr>
+                <th width="100">Order No.</th>
+                <th>Product</th>
+                <th width="100">Quantity</th>
+                <th width="100">Unit Price</th>
+                <th width="100">Amount</th>
+            </tr>
+    """
+    total_amount = 0.0
+    html_table = ""
+    html_pickup_text = ""
+    random_text = __get_secret_code(order.id)
+    customer_name = order.customer_name
+    order_date = order.created_timestamp
+    user_email = order.customer_email
+    html_tr = "<tr><td align='center'>" + str(order.id) + "</td>"
+    for lineitem in order.lineitems:
+        lineitem_total_price = round(lineitem.total_price, 2)
+        html_tr += "<td>" + str(lineitem) + "</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
+    html_footer = """
+        <tr><td colspan=5>&nbsp;</td></tr>
+        <tr><td colspan=5><hr /></td></tr>
+        <tr>
+            <td colspan=4>Total Amount</td>
+            <td> Rs. $total_amount</td>
+        </tr>
+        </table>
+    </div>
+    """
+    store_address = ""
+    if order.pickupStoreId:
+        store = LogisticsClient().get_client().getPickupStore(order.pickupStoreId)
+        store_address = __get_store_address_html(store)
+        html_pickup_text = html_pickup_text + """
+        <h3>Steps to Pickup In Store</h3>
+) Please visit the following store selected by you on or before $order_expiry_date<br>
+        <br><i>$store_address</i><br>
+        """
+        if order.cod:
+            html_pickup_text = html_pickup_text + """
+) Pay Rs. $total_amount, present a valid Photo Identity Proof* and quote your Secret Code <b><i>$secret_code</i></b> to claim your Product.<br><br>
+            *Valid Photo Identity Proof are Driving License, Passport, PAN Card, Voter ID, Company Issued ID Card, College issued Student ID Card Or any other Government approved Photo Id.<br>
+            <br>
+            In case you have any questions please visit <a href="www.saholic.com/static/buy-online-and-pickup-in-store">Details on Pickup in Store</a>. If you still have more questions feel free to contact us 24/7 via <a href="http://www.saholic.com/contact-us">http://www.saholic.com/contact-us</a>
+            </br><hr />
+            """
+        else:
+            html_pickup_text = html_pickup_text + """
+) Present a valid Photo Identity Proof* and use your Secret Code <b><i>$secret_code</i></b> to claim your Product(s).<br><br>
+            *Valid Photo Identity Proof are Driving License, Passport, PAN Card, Voter ID, Company Issued ID Card, College issued Student ID Card Or any other Government approved Photo Id.<br>
+            <br>
+            In case you have any questions please visit <a href="www.saholic.com/static/buy-online-and-pickup-in-store">Details on Pickup in Store</a>. If you still have more questions feel free to contact us 24/7 via <a href="http://www.saholic.com/contact-us">http://www.saholic.com/contact-us</a>
+            </br><hr />
+            """
+        html_footer = html_footer + html_pickup_text + """
+        <p>
+            Best Wishes,<br />
+            Saholic Team
+        </p>
+        </div>
+        </body>
+        </html>
+        """
+    subject = "Your order for " + str(order.lineitems[0]) + " is ready for Pickup in Store"
+    dt = datetime.datetime.strptime(str(order_date), "%Y-%m-%d %H:%M:%S")
+    formated_order_date = dt.strftime("%A, %d. %B %Y %I:%M%p")
+    oetd = datetime.datetime.now() + datetime.timedelta(days=4)
+    formated_order_expiry_date = oetd.strftime("%A, %d %B %Y")
+    email_header = Template(html_header).substitute(dict(order_date = formated_order_date, customer_name = customer_name, order_expiry_date = formated_order_expiry_date))
+    email_footer = Template(html_footer).substitute(dict(total_amount = "%.2f" % total_amount, secret_code = random_text, store_address = store_address, order_expiry_date = formated_order_expiry_date))
+    try:
+        helper_client = HelperClient().get_client()
+        helper_client.saveUserEmailForSending(user_email, "", subject, email_header + html_table + email_footer, str(order.id), "ReceivedAtStore")
+        return True
+    except Exception as e:
+        print e
+        return False
+def __get_secret_code(order_id):
+    existingAttributes = Attribute.query.filter(Attribute.orderId == order_id).all()
+    if existingAttributes :
+        for existingAttribute in existingAttributes :
+            if existingAttribute.name == 'SECRET_CODE':
+                return existingAttribute.value
+    return ""
 def get_order(order_id):
     order = Order.get_by(id=order_id)
     if not order:
         raise TransactionServiceException(108, "no such order")
     try:
         enqueue_received_at_store_email(order)
     except Exception as e:
         print e
-def enqueue_received_at_store_email(order):
-    # Calling helper service on production
-    helperClient = HelperClient(host_key = "helper_service_server_host_prod").get_client()
-    try:
-        emailSubject = 'Order Pickup from Store for Order ID: ' + str(order.id)
-        emailBody = get_received_at_store_email_body(order)
-        helperClient.saveUserEmailForSending(order.customer_email, None, emailSubject, emailBody, '', 'ReceivedAtStore')
-    except Exception as e:
-        print e
-def get_received_at_store_email_body(order):
-    html = """
-<html>
-<body>
-<div>
-    <p>Dear Customer,</p>
-    <p>
-        We are pleased to inform that your order: $order_id for your product $product_name has been reached at store.
-        You can pick it from store. Store details are mentioned below:
-    </p>
-    <p>
-     Store Address is:
-     $store_address
-    </p>
-    <p>
-        Warm Regards,<br />
-        Saholic Team
-    </p>
-</div>
-</body>
-</html>
-    """
-    client = LogisticsClient().get_client()
-    pickupStore = client.getPickupStore(order.pickupStoreId)
-    address = pickupStore.name + "\n" + pickupStore.line1 + "\n"
-    if pickupStore.line2:
-        address = address + pickupStore.line2 + "\n"
-    address = address + pickupStore.city + "\n"
-    address = address + pickupStore.state + "\n"
-    address = address + "PIN " + pickupStore.pin + "\n"
-    address = address + "Phone: " + pickupStore.phone
-    product = "%s %s %s %s" % (order.lineitems[0].brand, order.lineitems[0].model_name, order.lineitems[0].model_number, order.lineitems[0].color)
-    info = dict(order_id = order.id, product_name = product, store_address = address)
-    return Template(html).substitute(info)
 def mark_orders_as_rto(provider_id, returned_orders):
     for awb, detail in returned_orders.iteritems():
         order = Order.query.filter_by(airwaybill_no=awb, logistics_provider_id = provider_id).first()
     address = store.name + "\n" + store.line1 + "\n"
     if store.line2:
         address = address + store.line2 + "\n"
     address = address + store.city + "\n"
     address = address + store.state + "\n"
-    address = address + "PIN " + store.pin + "\n"
+    address = address + "PIN - " + store.pin + "\n"
     if store.phone:
-        address = address + "Phone: " + store.phone
+        address = address + "Phone - " + store.phone + "\n"
+    address = address +  "Store timing - 11AM to 8PM (7 days)\n"
     return address
 def __get_store_address_html(store):
     address = store.name + "<br>" + store.line1 + "<br>"
     if store.line2:
         address = address + store.line2 + "<br>"
     address = address + store.city + "<br>"
     address = address + store.state + "<br>"
-    address = address + "PIN " + store.pin + "<br>"
+    address = address + "PIN - " + store.pin + "<br>"
     if store.phone:
-        address = address + "Phone: " + store.phone
+        address = address + "Phone - " + store.phone + "<br>"
+    address = address +  "Store timing - 7 days: 11AM to 8PM  (7 days)<br>"
     return address
 def __generate_return_advice(order, warehouse, provider, filename):
     if warehouse.id == 7:
         executive = 'Amit Kumar'

Subversion Repositories SmartDukaan

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