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

 '''
 from optparse import OptionParser
 from shop2020.clients.InventoryClient import InventoryClient
 from shop2020.clients.LogisticsClient import LogisticsClient
 from shop2020.clients.TransactionClient import TransactionClient
+from shop2020.model.v1.order.impl import DataService
+from shop2020.model.v1.order.impl.DataService import Order
+from shop2020.model.v1.order.impl.DataAccessors import get_slipped_sipping_date_orders, get_cancelled_orders, \
+    get_orders_not_met_expected_delivery_date
-from shop2020.thriftpy.model.v1.order.ttypes import Order, DelayReason, OrderStatus
+from shop2020.thriftpy.model.v1.order.ttypes import DelayReason, OrderStatus
 from shop2020.utils.EmailAttachmentSender import get_attachment_part, mail_html
 from shop2020.utils.Utils import to_py_date, to_java_date
 import datetime
 import xlwt
+from elixir import *
+DataService.initialize(dbname='transaction', db_hostname='192.168.190.114')
 if __name__ == '__main__' and __package__ is None:
     import sys
     import os
     sys.path.insert(0, os.getcwd())
-#to = ["amar.kumar@shop2020.in"]
+#to = ["manish.sharma@shop2020.in"]
-to = ["anikendra.das@saholic.com","sandeep.sachdeva@shop2020.in","amit.sirohi@shop2020.in", "chaitnaya.vats@shop2020.in", "khushal.bhatia@shop2020.in", "rajneesh.arora@shop2020.in", "chandan.kumar@shop2020.in","manoj.kumar@shop2020.in", "manoj.pal@saholic.com", "yukti.jain@saholic.com", "ankush.dhingra@saholic.com"]
+to = ["manish.sharma@shop2020.in","amit.gupta@shop2020.in","sandeep.sachdeva@shop2020.in","amit.sirohi@shop2020.in", "chaitnaya.vats@shop2020.in", "khushal.bhatia@shop2020.in", "rajneesh.arora@shop2020.in", "manoj.kumar@shop2020.in", "yatin.singh@saholic.com"]
 def generate_delayed_orders_file():
-    txn_client = TransactionClient().get_client()
-    slipped_orders = txn_client.getSlippedSippingDateOrders()
+    slipped_orders = get_slipped_sipping_date_orders()
     wbk = xlwt.Workbook()
     sheet = wbk.add_sheet('main')
     heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
                     <th>Delay Reason</th>
                     <th>Detailed Reason Text</th>
                 </tr>
     """
-    order = Order()
     mode = {}
     mode[0] = 'Prepaid'
     mode[1] = 'COD'
     source = {}
     source[1] = 'WEBSITE'
         html +="<td>" + str(lineitem.model_number) + "</td>"
         sheet.write(i, 7, lineitem.color)
         html +="<td>" + str(lineitem.color) + "</td>"
         sheet.write(i, 8, lineitem.quantity)
         html +="<td>" + str(lineitem.quantity) + "</td>"
-        sheet.write(i, 9, to_py_date(order.created_timestamp), date_style)
+        sheet.write(i, 9, order.created_timestamp, date_style)
-        html +="<td>" + str(to_py_date(order.created_timestamp)) + "</td>"
+        html +="<td>" + str(order.created_timestamp) + "</td>"
-        sheet.write(i, 10, to_py_date(order.promised_shipping_time), date_style)
+        sheet.write(i, 10, order.promised_shipping_time, date_style)
-        html +="<td>" + str(to_py_date(order.promised_shipping_time)) + "</td>"
+        html +="<td>" + str(order.promised_shipping_time) + "</td>"
-        sheet.write(i, 11, to_py_date(order.expected_shipping_time), date_style)
+        sheet.write(i, 11, order.expected_shipping_time, date_style)
-        html +="<td>" + str(to_py_date(order.expected_shipping_time)) + "</td>"
+        html +="<td>" + str(order.expected_shipping_time) + "</td>"
-        if order.delayReason:
+        if order.delay_reason:
-            sheet.write(i, 12, DelayReason._VALUES_TO_NAMES[order.delayReason])
+            sheet.write(i, 12, order.delay_reason)
-            html +="<td>" + str(DelayReason._VALUES_TO_NAMES[order.delayReason]) + "</td>"
+            html +="<td>" + str(order.delay_reason) + "</td>"
         sheet.write(i, 13, order.delayReasonText)
         html +="<td>" + str(order.delayReasonText) + "</td>"
         html +="</tr>"
         i= i+1
         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()
     #cancelled_orders = txn_client.getAllOrders(OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY, to_java_date(datetime.datetime.now() - datetime.timedelta(hours = 24)), to_java_date(datetime.datetime.now()), -1)
-    cancelled_orders = txn_client.getCancelledOrders(to_java_date(datetime.datetime.now() - datetime.timedelta(hours = 24)), to_java_date(datetime.datetime.now()))
+    cancelled_orders = get_cancelled_orders(datetime.datetime.now() - datetime.timedelta(hours = 24), datetime.datetime.now())
     wbk = xlwt.Workbook()
     sheet = wbk.add_sheet('main')
     heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
                     <th>Cancellation Date</th>
                 </tr>
     """
-    order = Order()
     mode = {}
     mode[0] = 'Prepaid'
     mode[1] = 'COD'
     source = {}
     source[1] = 'WEBSITE'
         sheet.write(i, 5, lineitem.model_number)
         html +="<td>" + str(lineitem.model_number) + "</td>"
         sheet.write(i, 6, lineitem.color)
         html +="<td>" + str(lineitem.color) + "</td>"
-        sheet.write(i, 7, to_py_date(order.created_timestamp), date_style)
+        sheet.write(i, 7, order.created_timestamp, date_style)
-        html +="<td>" + str(to_py_date(order.created_timestamp)) + "</td>"
+        html +="<td>" + str(order.created_timestamp) + "</td>"
-        sheet.write(i, 8, to_py_date(order.promised_shipping_time), date_style)
+        sheet.write(i, 8, order.promised_shipping_time, date_style)
-        html +="<td>" + str(to_py_date(order.promised_shipping_time)) + "</td>"
+        html +="<td>" + str(order.promised_shipping_time) + "</td>"
-        sheet.write(i, 9, to_py_date(order.expected_shipping_time), date_style)
+        sheet.write(i, 9, order.expected_shipping_time, date_style)
-        html +="<td>" + str(to_py_date(order.expected_shipping_time)) + "</td>"
+        html +="<td>" + str(order.expected_shipping_time) + "</td>"
         sheet.write(i, 10, order.refundReason)
         html +="<td>" + str(order.refundReason) + "</td>"
-        sheet.write(i, 11, to_py_date(order.refund_timestamp), date_style)
+        sheet.write(i, 11, order.refund_timestamp, date_style)
-        html +="<td>" + str(to_py_date(order.refund_timestamp)) + "</td>"
+        html +="<td>" + str(order.refund_timestamp) + "</td>"
         html +="<td>" + str(order.delayReasonText) + "</td>"
         html +="</tr>"
         i= i+1
     finally:
         os.remove(filename)
 def generate_expected_delivery_missed_orders_file():
-    txn_client = TransactionClient().get_client()
-    orders_not_delivered = txn_client.getUndeliveredOrdersExpectedDeliveryDateNotMet()
+    orders_not_delivered = get_orders_not_met_expected_delivery_date()
     print "orders_not_delivered"
     print orders_not_delivered
     logistics_client = LogisticsClient().get_client()
                     <th>Customer State</th>
                     <th>Customer Pincode</th>
                 </tr>
     """
-    order = Order()
     mode = {}
     mode[0] = 'Prepaid'
     mode[1] = 'COD'
     source = {}
         html +="<td>" + str(source[order.source]) + "</td>"
         sheet.write(i, 3, order.airwaybill_no)
         html +="<td>" + str(order.airwaybill_no) + "</td>"
         sheet.write(i, 4, order.statusDescription)
         html +="<td>" + order.statusDescription + "</td>"
-        sheet.write(i, 5, to_py_date(order.shipping_timestamp), date_style)
+        sheet.write(i, 5, order.shipping_timestamp, date_style)
-        html +="<td>" + str(to_py_date(order.shipping_timestamp)) + "</td>"
+        html +="<td>" + str(order.shipping_timestamp) + "</td>"
-        sheet.write(i, 6, to_py_date(order.pickup_timestamp), date_style)
+        sheet.write(i, 6, order.pickup_timestamp, date_style)
-        html +="<td>" + str(to_py_date(order.pickup_timestamp)) + "</td>"
+        html +="<td>" + str(order.pickup_timestamp) + "</td>"
-        sheet.write(i, 7, to_py_date(order.expected_delivery_time), date_style)
+        sheet.write(i, 7, order.expected_delivery_time, date_style)
-        html +="<td>" + str(to_py_date(order.expected_delivery_time)) + "</td>"
+        html +="<td>" + str(order.expected_delivery_time) + "</td>"
         sheet.write(i, 8, warehouses_map.get(order.warehouse_id))
         html +="<td>" + str(warehouses_map.get(order.warehouse_id)) + "</td>"
         sheet.write(i, 9, order.warehouse_id)
         html +="<td>" + str(order.warehouse_id) + "</td>"
         sheet.write(i, 10, providers_map.get(order.logistics_provider_id))
     if options.undelivered:
         generate_expected_delivery_missed_orders_file()
 if __name__ == '__main__':
     main()
+    try:
+        session.close()
+    except:
+        pass

Subversion Repositories SmartDukaan

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