WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/order/script/DelayedOrdersReport.py

 from shop2020.utils.Utils import to_py_date, to_java_date
 from shop2020.clients.TransactionClient import TransactionClient
 from shop2020.clients.LogisticsClient import LogisticsClient
 from shop2020.clients.CatalogClient import CatalogClient
 from shop2020.thriftpy.model.v1.order.ttypes import  Order, DelayReason
-from shop2020.utils.EmailAttachmentSender import mail, get_attachment_part
+from shop2020.utils.EmailAttachmentSender import mail, get_attachment_part, mail_html
 to = ["sandeep.sachdeva@shop2020.in","ashutosh.saxena@shop2020.in","suraj.sharma@shop2020.in","pankaj.jain@spiceglobal.com", "pankaj.kankar@shop2020.in", "chaitnaya.vats@shop2020.in", "asghar.bilgrami@shop2020.in", "rajneesharora@spiceretail.co.in"]
 def generate_delayed_orders_file():
     txn_client = TransactionClient().get_client()
     slipped_orders = txn_client.getSlippedSippingDateOrders()
     sheet.write(0, 0, "Order ID", heading_xf)
     sheet.write(0, 1, "Mode.", heading_xf)
     sheet.write(0, 2, "Brand", heading_xf)
     sheet.write(0, 3, "Model Name", heading_xf)
     sheet.write(0, 4, "Model Number", heading_xf)
-    sheet.write(0, 5, "Color", heading_xf)
+    sheet.write(0, 5, "Colour", heading_xf)
     sheet.write(0, 6, "Creation Date", heading_xf)
     sheet.write(0, 7, "Promised Shipping Date", heading_xf)
     sheet.write(0, 8, "Expected Shipping Date", heading_xf)
     sheet.write(0, 9, "Delay Reason", heading_xf)
     sheet.write(0, 10, "Detailed Reason Text", heading_xf)
+    html = """\
+    <html>
+        <head>
+            <style type="text/css">
+                table, tr, th { border :1px solid black;}
+            </style>
+        </head>
+        <body>
+            <center><h3>Delayed Orders</h3></center>
+            <table>
+                <tr>
+                    <th>Order ID</th>
+                    <th>Mode</th>
+                    <th>Brand</th>
+                    <th>Model Name</th>
+                    <th>Model Number</th>
+                    <th>Colour</th>
+                    <th>Creation Date</th>
+                    <th>Promised Shipping Date</th>
+                    <th>Expected Shipping Date</th>
+                    <th>Delay Reason</th>
+                    <th>Detailed Reason Text</th>
+                </tr>
+    """
     order = Order()
     mode = {}
     mode[0] = 'Prepaid'
     mode[1] = 'COD'
     i = 1
     for order in slipped_orders:
+        html +="<tr>"
         sheet.write(i, 0, order.id)
+        html +="<td>" + str(order.id) + "</td>"
         sheet.write(i, 1, mode[order.cod])
+        html +="<td>" + str(mode[order.cod]) + "</td>"
         lineitem = order.lineitems[0]
         sheet.write(i, 2, lineitem.brand)
+        html +="<td>" + str(lineitem.brand) + "</td>"
         sheet.write(i, 3, lineitem.model_name)
+        html +="<td>" + str(lineitem.model_name) + "</td>"
         sheet.write(i, 4, lineitem.model_number)
+        html +="<td>" + str(lineitem.model_number) + "</td>"
         sheet.write(i, 5, lineitem.color)
+        html +="<td>" + str(lineitem.color) + "</td>"
         sheet.write(i, 6, to_py_date(order.created_timestamp), date_style)
+        html +="<td>" + str(to_py_date(order.created_timestamp)) + "</td>"
         sheet.write(i, 7, to_py_date(order.promised_shipping_time), date_style)
+        html +="<td>" + str(to_py_date(order.promised_shipping_time)) + "</td>"
         sheet.write(i, 8, to_py_date(order.expected_shipping_time), date_style)
+        html +="<td>" + str(to_py_date(order.expected_shipping_time)) + "</td>"
         if order.delayReason:
             sheet.write(i, 9, DelayReason._VALUES_TO_NAMES[order.delayReason])
+            html +="<td>" + str(DelayReason._VALUES_TO_NAMES[order.delayReason]) + "</td>"
         sheet.write(i, 10, order.delayReasonText)
+        html +="<td>" + str(order.delayReasonText) + "</td>"
+        html +="</tr>"
         i= i+1
     today = datetime.date.today()
     datestr = str(today.year) + "-" + str(today.month) + "-" + str(today.day)
     filename = "/tmp/SlippedOrders-" + datestr + ".xls"
     wbk.save(filename)
+    html +="</table></body></html>"
     try:
         part = get_attachment_part(filename)
-        mail("cnc.center@shop2020.in", "5h0p2o2o", to, "Slipped Orders as on: " + datestr, "PFA attached xls files for the orders which missed the shipping date.", [part])
+        mail_html("cnc.center@shop2020.in", "5h0p2o2o", to, "Slipped Orders as on: " + datestr, html, [part])
     finally:
         os.remove(filename)
 def generate_cancelled_orders_file():
     txn_client = TransactionClient().get_client()
     sheet.write(0, 0, "Order ID", heading_xf)
     sheet.write(0, 1, "Mode.", heading_xf)
     sheet.write(0, 2, "Brand", heading_xf)
     sheet.write(0, 3, "Model Name", heading_xf)
     sheet.write(0, 4, "Model Number", heading_xf)
-    sheet.write(0, 5, "Color", heading_xf)
+    sheet.write(0, 5, "Colour", heading_xf)
     sheet.write(0, 6, "Creation Date", heading_xf)
     sheet.write(0, 7, "Promised Shipping Date", heading_xf)
     sheet.write(0, 8, "Expected Shipping Date", heading_xf)
     sheet.write(0, 9, "Cancellation Reason", heading_xf)
     sheet.write(0, 10, "Cancellation Date", heading_xf)
+    html = """\
+    <html>
+        <head>
+            <style type="text/css">
+                table, tr, th { border :1px solid black;}
+            </style>
+        </head>
+        <body>
+            <center><h3>Delayed Orders</h3></center>
+            <table>
+                <tr>
+                    <th>Order ID</th>
+                    <th>Mode</th>
+                    <th>Brand</th>
+                    <th>Model Name</th>
+                    <th>Model Number</th>
+                    <th>Colour</th>
+                    <th>Creation Date</th>
+                    <th>Promised Shipping Date</th>
+                    <th>Expected Shipping Date</th>
+                    <th>Cancellation Reason</th>
+                    <th>Cancellation Date</th>
+                </tr>
+    """
     order = Order()
     mode = {}
     mode[0] = 'Prepaid'
     mode[1] = 'COD'
     i = 1
     for order in cancelled_orders:
+        html +="<tr>"
         sheet.write(i, 0, order.id)
+        html +="<td>" + str(order.id) + "</td>"
         sheet.write(i, 1, mode[order.cod])
+        html +="<td>" + str(mode[order.cod]) + "</td>"
         lineitem = order.lineitems[0]
         sheet.write(i, 2, lineitem.brand)
+        html +="<td>" + str(lineitem.brand) + "</td>"
         sheet.write(i, 3, lineitem.model_name)
+        html +="<td>" + str(lineitem.model_name) + "</td>"
         sheet.write(i, 4, lineitem.model_number)
+        html +="<td>" + str(lineitem.model_number) + "</td>"
         sheet.write(i, 5, lineitem.color)
+        html +="<td>" + str(lineitem.color) + "</td>"
         sheet.write(i, 6, to_py_date(order.created_timestamp), date_style)
+        html +="<td>" + str(to_py_date(order.created_timestamp)) + "</td>"
         sheet.write(i, 7, to_py_date(order.promised_shipping_time), date_style)
+        html +="<td>" + str(to_py_date(order.promised_shipping_time)) + "</td>"
         sheet.write(i, 8, to_py_date(order.expected_shipping_time), date_style)
+        html +="<td>" + str(to_py_date(order.expected_shipping_time)) + "</td>"
         sheet.write(i, 9, order.refundReason)
+        html +="<td>" + str(order.refundReason) + "</td>"
         sheet.write(i, 10, to_py_date(order.refund_timestamp), date_style)
+        html +="<td>" + str(to_py_date(order.refund_timestamp)) + "</td>"
+        html +="<td>" + str(order.delayReasonText) + "</td>"
+        html +="</tr>"
         i= i+1
     today = datetime.date.today()
     datestr = str(today.year) + "-" + str(today.month) + "-" + str(today.day)
     filename = "/tmp/CancelledOrders-" + datestr + ".xls"
     wbk.save(filename)
+    html +="</table></body></html>"
     try:
         part = get_attachment_part(filename)
-        mail("cnc.center@shop2020.in", "5h0p2o2o", to, "Low Inventory Cancelled Orders as on: " + datestr, "PFA attached xls files for the orders which has been cancelled.", [part])
+        mail_html("cnc.center@shop2020.in", "5h0p2o2o", to, "Low Inventory Cancelled Orders as on: " + datestr, html, [part])
     finally:
         os.remove(filename)
 def generate_expected_delivery_missed_orders_file():
     sheet.write(0, 10, "Logistics Provider ID", heading_xf)
     sheet.write(0, 11, "Customer City", heading_xf)
     sheet.write(0, 12, "Customer State", heading_xf)
     sheet.write(0, 13, "Customer Pincode", heading_xf)
+    html = """\
+    <html>
+        <head>
+            <style type="text/css">
+                table, tr, th { border :1px solid black;}
+            </style>
+        </head>
+        <body>
+            <center><h3>Delayed Orders</h3></center>
+            <table border=1>
+                <tr>
+                    <th>Order ID</th>
+                    <th>Mode</th>
+                    <th>Airway BillNo</th>
+                    <th>Current Status</th>
+                    <th>Shipping Date</th>
+                    <th>Pickup Date</th>
+                    <th>Expected Delivery Date</th>
+                    <th>Warehouse</th>
+                    <th>Warehouse ID</th>
+                    <th>Logistics Provider</th>
+                    <th>Logistics Provider ID</th>
+                    <th>Customer City</th>
+                    <th>Customer State</th>
+                    <th>Customer Pincode</th>
+                </tr>
+    """
     order = Order()
     mode = {}
     mode[0] = 'Prepaid'
     mode[1] = 'COD'
     i = 1
     for order in orders_not_delivered:
+        html +="<tr>"
         sheet.write(i, 0, order.id)
+        html +="<td>" + str(order.id) + "</td>"
         sheet.write(i, 1, mode[order.cod])
+        html +="<td>" + str(mode[order.cod]) + "</td>"
         sheet.write(i, 2, order.airwaybill_no)
+        html +="<td>" + str(order.airwaybill_no) + "</td>"
         sheet.write(i, 3, order.statusDescription)
+        html +="<td>" + order.statusDescription + "</td>"
         sheet.write(i, 4, to_py_date(order.shipping_timestamp), date_style)
+        html +="<td>" + str(to_py_date(order.shipping_timestamp)) + "</td>"
         sheet.write(i, 5, to_py_date(order.pickup_timestamp), date_style)
+        html +="<td>" + str(to_py_date(order.pickup_timestamp)) + "</td>"
         sheet.write(i, 6, to_py_date(order.expected_delivery_time), date_style)
+        html +="<td>" + str(to_py_date(order.expected_delivery_time)) + "</td>"
         sheet.write(i, 7, warehouses_map.get(order.warehouse_id))
+        html +="<td>" + str(warehouses_map.get(order.warehouse_id)) + "</td>"
         sheet.write(i, 8, order.warehouse_id)
+        html +="<td>" + str(order.warehouse_id) + "</td>"
         sheet.write(i, 9, providers_map.get(order.logistics_provider_id))
+        html +="<td>" + str(providers_map.get(order.logistics_provider_id)) + "</td>"
         sheet.write(i, 10, order.logistics_provider_id)
+        html +="<td>" + str(order.logistics_provider_id) + "</td>"
         sheet.write(i, 11, order.customer_city)
+        html +="<td>" + str(order.customer_city) + "</td>"
         sheet.write(i, 12, order.customer_state)
+        html +="<td>" + str(order.customer_state) + "</td>"
         sheet.write(i, 13, order.customer_pincode)
+        html +="<td>" + str(order.customer_pincode) + "</td>"
+        html +="</tr>"
         i= i+1
     today = datetime.date.today()
     datestr = str(today.year) + "-" + str(today.month) + "-" + str(today.day)
     filename = "/tmp/UndeliveredOrders-" + datestr + ".xls"
     wbk.save(filename)
+    html +="</table></body></html>"
     try:
         part = get_attachment_part(filename)
-        mail("cnc.center@shop2020.in", "5h0p2o2o", to, "Orders which missed Expected Delivery Date as on: " + datestr, "PFA attached xls files for the orders which missed the Expected Delivery Date.", [part])
+        mail_html("cnc.center@shop2020.in", "5h0p2o2o", to, "Orders which missed Expected Delivery Date as on: " + datestr, html, [part])
     finally:
         os.remove(filename)
 def main():
     parser = OptionParser()

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/order/script/DelayedOrdersReport.py – Rev 5577 → 5631