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

     except TransactionServiceException as tex:
         print tex.message
 def read_dao_return_pickup_orders(orders_tobe_picked_up):
     picked_up_orders = {}
+    list_of_order = []
     for order in orders_tobe_picked_up:
+        list_of_order.append(str(order.pickupRequestNo))
-        try:
+    try:
-            uri = Delhivery_URL + 'ref_nos=' + str(order.pickupRequestNo)
+        uri = Delhivery_URL + 'ref_nos=' + ','.join(list_of_order)
-            root = parse(urllib2.urlopen(uri)).getroot()
+        root = parse(urllib2.urlopen(uri)).getroot()
+        shipments = root.findall('Shipment')
+        for shipment in shipments:
-            nodes = root.findall('Shipment/Scans/ScanDetail')
+            nodes = shipment.findall('Scans/ScanDetail')
             for element in nodes:
                 delivery_date = get_py_datetime(element.findtext('ScanDateTime', ''))
-                picked_up_orders[order.pickupRequestNo] = str(delivery_date)
+                picked_up_orders[shipment.findtext('ReferenceNo', '')] = str(delivery_date)
                 break
-        except:
+    except:
-            pass
+        pass
     print "Picked up Orders:"
     print picked_up_orders
     return picked_up_orders
 def read_pickup_orders(orders_tobe_picked_up):
     picked_up_orders = {}
+    list_of_order = []
     for order in orders_tobe_picked_up:
+        list_of_order.append(str(order.airwaybill_no))
-        try:
+    try:
-            uri = Delhivery_URL + 'waybill=' + order.airwaybill_no
+        uri = Delhivery_URL + 'waybill=' + ','.join(list_of_order)
-            root = parse(urllib2.urlopen(uri)).getroot()
+        root = parse(urllib2.urlopen(uri)).getroot()
+        shipments = root.findall('Shipment')
+        for shipment in shipments:
-            nodes = root.findall('Shipment/Scans/ScanDetail')
+            nodes = shipment.findall('Scans/ScanDetail')
             for element in nodes:
                 delivery_date = get_py_datetime(element.findtext('ScanDateTime', ''))
-                picked_up_orders[order.airwaybill_no] = str(delivery_date)
+                picked_up_orders[shipment.findtext('AWB', '')] = str(delivery_date)
                 break
-        except:
+    except:
-            pass
+        pass
     print "Picked up Orders:"
     print picked_up_orders
     return picked_up_orders
 def read_local_connection_orders(orders_tobe_local_connected):
     local_connected_orders = {}
+    list_of_order = []
     for order in orders_tobe_local_connected:
+        list_of_order.append(str(order.airwaybill_no))
-        try:
+    try:
-            uri = Delhivery_URL + 'waybill=' + order.airwaybill_no
+        uri = Delhivery_URL + 'waybill=' + ','.join(list_of_order)
-            root = parse(urllib2.urlopen(uri)).getroot()
+        root = parse(urllib2.urlopen(uri)).getroot()
+        shipments = root.findall('Shipment')
+        for shipment in shipments:
-            nodes = root.findall('Shipment/Scans/ScanDetail')
+            nodes = shipment.findall('Scans/ScanDetail')
             for element in nodes:
                 if element.findtext('ScanType', '') == 'UD' and getTrimedString(element.findtext('Scan', '')) == getTrimedString('In Transit'):
                     delivery_date = get_py_datetime(element.findtext('ScanDateTime', ''))
-                    local_connected_orders[order.airwaybill_no] = str(delivery_date)
+                    local_connected_orders[shipment.findtext('AWB', '')] = str(delivery_date)
                     break
-        except:
+    except:
-            pass
+        pass
     print "Local Connected Orders"
     print local_connected_orders
     return local_connected_orders
 def read_reached_destination_orders(orders_tobe_reached_destination_city):
     destination_city_reached_orders = {}
+    list_of_order = []
     for order in orders_tobe_reached_destination_city:
+        list_of_order.append(str(order.airwaybill_no))
-        try:
+    try:
-            uri = Delhivery_URL + 'waybill=' + order.airwaybill_no
+        uri = Delhivery_URL + 'waybill=' + ','.join(list_of_order)
-            root = parse(urllib2.urlopen(uri)).getroot()
+        root = parse(urllib2.urlopen(uri)).getroot()
+        shipments = root.findall('Shipment')
+        for shipment in shipments:
-            nodes = root.findall('Shipment/Scans/ScanDetail')
+            nodes = shipment.findall('Scans/ScanDetail')
             for element in nodes:
                 if element.findtext('ScanType', '') == 'UD' and getTrimedString(element.findtext('Scan', '')) == getTrimedString('Pending'):
                     delivery_date = get_py_datetime(element.findtext('ScanDateTime', ''))
-                    destination_city_reached_orders[order.airwaybill_no] = str(delivery_date)
+                    destination_city_reached_orders[shipment.findtext('AWB', '')] = str(delivery_date)
                     break
-        except:
+    except:
-            pass
+        pass
     print "Destination City Reached Orders"
     print destination_city_reached_orders
     return destination_city_reached_orders
 def read_first_delivery_attempt_orders(orders_tobe_first_delivery_attempted):
     first_atdl_orders = {}
+    list_of_order = []
     for order in orders_tobe_first_delivery_attempted:
+        list_of_order.append(str(order.airwaybill_no))
-        try:
+    try:
-            uri = Delhivery_URL + 'waybill=' + order.airwaybill_no
+        uri = Delhivery_URL + 'waybill=' + ','.join(list_of_order)
-            root = parse(urllib2.urlopen(uri)).getroot()
+        root = parse(urllib2.urlopen(uri)).getroot()
+        shipments = root.findall('Shipment')
+        for shipment in shipments:
-            nodes = root.findall('Shipment/Scans/ScanDetail')
+            nodes = shipment.findall('Scans/ScanDetail')
             node_number = 0
             for element in nodes:
                 if element.findtext('ScanType', '') == 'UD' and getTrimedString(element.findtext('Scan', '')) == getTrimedString('Dispatched'):
                     if node_number != len(nodes)-1 and nodes[node_number+1].findtext('ScanType', '') == 'UD':
                         element = nodes[node_number+1]
                         delivery_date = get_py_datetime(element.findtext('ScanDateTime', ''))
                         reason_for_nondelivery = element.findtext('Instructions', '')
-                        first_atdl_orders[order.airwaybill_no] = str(delivery_date) + "|" + reason_for_nondelivery
+                        first_atdl_orders[shipment.findtext('AWB', '')] = str(delivery_date) + "|" + reason_for_nondelivery
                         break
                 node_number = node_number + 1
-        except:
+    except:
-            pass
+        pass
     print "FIRST DELIVERY ATTEMPT MADE Orders"
     print first_atdl_orders
     return first_atdl_orders
 def read_delivery_orders(orders_tobe_delivered):
     delivered_orders = {}
     returned_orders = {}
     undelivered_orders = {}
+    list_of_order = []
     for order in orders_tobe_delivered:
+        list_of_order.append(str(order.airwaybill_no))
-        try:
+    try:
-            uri = Delhivery_URL + 'waybill=' + order.airwaybill_no
+        uri = Delhivery_URL + 'waybill=' + ','.join(list_of_order)
-            root = parse(urllib2.urlopen(uri)).getroot()
+        root = parse(urllib2.urlopen(uri)).getroot()
+        shipments = root.findall('Shipment')
+        for shipment in shipments:
-            nodes = root.findall('Shipment/Scans/ScanDetail')
+            nodes = shipment.findall('Scans/ScanDetail')
             node_number = 0
             for element in nodes:
                 if element.findtext('ScanType', '') == 'DL' and getTrimedString(element.findtext('Scan', '')) == getTrimedString('Delivered'):
                     delivery_date = get_py_datetime(element.findtext('ScanDateTime', ''))
-                    receiver = root.findtext('Shipment/Status/RecievedBy', '')
+                    receiver = shipment.findtext('Status/RecievedBy', '')
-                    delivered_orders[order.airwaybill_no] = str(delivery_date) + "|" +  receiver
+                    delivered_orders[shipment.findtext('AWB', '')] = str(delivery_date) + "|" +  receiver
                     break
                 elif element.findtext('ScanType', '') == 'RT' and getTrimedString(element.findtext('Scan', '')) == getTrimedString('Returned'):
                     delivery_date = get_py_datetime(element.findtext('ScanDateTime', ''))
                     reason_for_return = element.findtext('Instructions', '')
-                    returned_orders[order.airwaybill_no] = str(delivery_date) + "|" + reason_for_return
+                    returned_orders[shipment.findtext('AWB', '')] = str(delivery_date) + "|" + reason_for_return
                     break
                 elif node_number == len(nodes)-1:
                     reason = element.findtext('Instructions', '')
-                    undelivered_orders[order.airwaybill_no] = reason
+                    undelivered_orders[shipment.findtext('AWB', '')] = reason
                     break
                 node_number = node_number + 1
-        except:
+    except:
-            pass
+        pass
     print "Delivered Orders:"
     print delivered_orders
     print "Returned Orders:"

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/order/script/DelhiveryLogisticsReconciliation.py – Rev 5262 → 5325