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

         traceback.print_exc()
 def process_delivery_report(provider):
     try:
         orders_tobe_delivered = fetch_data(provider.id, OrderStatus.SHIPPED_TO_LOGST)
-        delivered_orders, returned_orders, undelivered_orders = read_delivery_orders(orders_tobe_delivered)
+        delivered_orders, delivered_orders_but_wrong_code_mentioned, returned_orders, undelivered_orders = read_delivery_orders(orders_tobe_delivered)
         if undelivered_orders:
             update_reason_of_undelivered_orders(provider.id, undelivered_orders)
         if delivered_orders:
             update_delivered_orders(provider.id, delivered_orders)
         if returned_orders:
                      "This is a system generated email.Please don't reply to it.",\
                      returned_orders_report)
             except:
                 print "Some issue sending the returned orders report"
                 traceback.print_exc()
+        if delivered_orders_but_wrong_code_mentioned:
+            try:
+                delivered_orders_but_wrong_code_mentioned_file = "/tmp/delivered_orders_but_wrong_code.csv"
+                print_delivered_orders_but_wrong_code_mentioned_report(delivered_orders_but_wrong_code_mentioned_file, delivered_orders_but_wrong_code_mentioned)
+                delivered_orders_but_wrong_code_mentioned_report = [get_attachment_part(delivered_orders_but_wrong_code_mentioned_file)]
+                mail(from_user, from_pwd, to,\
+                     "Delivered Orders but Wrong Code Mentioned Report for " + provider.name,\
+                     "This is a system generated email.Please don't reply to it.",\
+                     delivered_orders_but_wrong_code_mentioned_report)
+            except:
+                print "Some issue sending the delivered orders but wrong code mentioned report"
+                traceback.print_exc()
     except:
-        print "Some issue while processing the returned orders"
+        print "Some issue while processing the orders in SHIPPED_TO_LOGST status"
         traceback.print_exc()
 def get_provider_by_name(provider_name):
     logistics_client = LogisticsClient().get_client()
     provider = None
         root = parse(urllib2.urlopen(uri)).getroot()
         try:
             nodes = root.findall('HAWBDetails/HAWBHistory/HAWBUpdate')
             if len(nodes):
                 element = nodes[len(nodes)-1]
-                if element.findtext('TrackingCodeDescription', '') == 'Shipment Origin Received':
+                if element.findtext('Status', '') == 'SHOR' and element.findtext('Condition', '') == 'PKUP':
                     delivery_date = get_py_datetime(element.findtext('ActionDate', ''))
                     picked_up_doas[order.pickupRequestNo] = str(delivery_date)
         except:
             pass
         root = parse(urllib2.urlopen(uri)).getroot()
         try:
             nodes = root.findall('HAWBDetails/HAWBHistory/HAWBUpdate')
             if len(nodes):
                 element = nodes[len(nodes)-1]
-                if element.findtext('TrackingCodeDescription', '') == 'Shipment Origin Received':
+                if element.findtext('Status', '') == 'SHOR' and element.findtext('Condition', '') == 'PKUP':
                     delivery_date = get_py_datetime(element.findtext('ActionDate', ''))
                     picked_up_orders[order.airwaybill_no] = str(delivery_date)
         except:
             pass
     except ConfigException as cex:
         print cex.message
         traceback.print_exc()
     delivered_orders = {}
+    delivered_orders_but_wrong_code_mentioned = {}
     returned_orders = {}
     undelivered_orders = {}
     for order in orders_tobe_delivered:
         uri = ARAMEX_URL + order.airwaybill_no
         root = parse(urllib2.urlopen(uri)).getroot()
             nodes = root.findall('HAWBDetails/HAWBHistory/HAWBUpdate')
             if len(nodes):
                 i = len(nodes)-1
                 while i>=0:
                     element = nodes[i]
-                    if element.findtext('TrackingCodeDescription', '') == 'Shipment Delivered':
+                    if element.findtext('Status', '') == 'SHDL' and (element.findtext('Condition', '') == 'DLVD' or element.findtext('Condition', '') == 'DPTT' or element.findtext('Condition', '') == 'DLPT' or element.findtext('Condition', '') == 'LTRB'):
                         delivery_date = get_py_datetime(element.findtext('ActionDate', ''))
                         receiver = root.findtext('HAWBDetails/DeliveredTo', '')
                         delivered_orders[order.airwaybill_no] = str(delivery_date) + "|" +  receiver
+                        if element.findtext('Condition', '') != 'DLVD':
+                            delivered_orders_but_wrong_code_mentioned[order.airwaybill_no] = element.findtext('Condition', '')
                         break
-                    elif element.findtext('TrackingCodeDescription', '') == 'Shipment Release Hold':
+                    elif element.findtext('Condition', '') == 'RTRN' and (element.findtext('Status', '') == 'SHRH' or element.findtext('Status', '') == 'SHUP'):
                         delivery_date = get_py_datetime(element.findtext('ActionDate', ''))
                         if i < len(nodes)-1:
                             reason_for_return = nodes[i+1].findtext('CustomerDescription', '')
                         else:
                             reason_for_return = element.findtext('CustomerDescription', '')
                         returned_orders[order.airwaybill_no] = str(delivery_date) + "|" + reason_for_return
                         break
                     elif i == 0:
-                        reason = element.findtext('TrackingCodeDescription', '')
+                        reason = root.findtext('CurrentStatus', '')
                         undelivered_orders[order.airwaybill_no] = reason
                         break
                     i = i-1
         except:
             pass
     print "Delivered Orders:"
     print delivered_orders
+    print "Delivered Orders but wrong code mentioned:"
+    print delivered_orders_but_wrong_code_mentioned
     print "Returned Orders:"
     print returned_orders
     print "Undelivered Orders"
     print undelivered_orders
-    return delivered_orders, returned_orders, undelivered_orders
+    return delivered_orders, delivered_orders_but_wrong_code_mentioned, returned_orders, undelivered_orders
 def update_picked_orders(provider_id, pickup_details):
     txnClient = TransactionClient().get_client()
     try:
         orders_not_picked_up = txnClient.markOrdersAsPickedUp(provider_id, pickup_details)
     writer.writerow(['AWB No', 'Return date', 'Reason'])
     for awb, date_reason in returned_orders.iteritems():
         date, reason = date_reason.split('|')
         writer.writerow([awb, date, reason])
+def print_delivered_orders_but_wrong_code_mentioned_report(filename, delivered_orders_but_wrong_code_mentioned):
+    writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_NONE)
+    writer.writerow(['AWB No', 'Code Used'])
+    for awb, code_used in delivered_orders_but_wrong_code_mentioned.iteritems():
+        writer.writerow([awb, code_used])
 def get_py_datetime(time_string):
     # This should be a command line argument.
     # Refer http://docs.python.org/library/time.html#time.strftime to
     # get a complete list of format specifiers available for date time.
     time_format = "%m/%d/%Y %I:%M:%S %p"

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/order/script/AramexLogisticsReconciliation.py – Rev 4508 → 4540